V_ID_<eventtype>

Business Intelligence (BI) Interface Guide › Business Intelligence Interface › SQL Interfaces › Raw Data and Intermediate Data Interfaces › V_ID_<eventtype>

V_ID_<eventtype>

For each Event Type in the system, a view named V_ID_<eventtype> is created (where <eventtype> is the name of the event type for which the view is created).

This view exposes records of the specific Event Type.
Instead of an XML that contain the data of the Event, this view has an actual column for each Field of the Event. The column name is according to the name of the Field, as defined in the system and the column type is a string.

These views can be useful when designing reports on a specific Event Type.

The V_ID_<eventtype> interface is able to handle raw data fields with their real types, according to the definition of the event type.

In case the Event name and/or the Event Field names contain non-ASCII characters, they are replaced by '_', or removed from the name.

Names longer than 30 characters are truncated. In case the truncation returns a name that already exists, the name is changed to end with a sequence number.

The following table describes the fields in V_ID_<eventtype>.

Name	Type	Content
METRIC_ID	number(10)	Foreign Key to T_RULES.
METRIC_GLOBAL_ID	number(10)	Foreign Key to T_GLOBAL_RULES.
METRIC_GLOBAL_NAME	varchar2(200)	Name of the Metric that sent the Event.
RESOURCE_ID	number(10)	Foreign Key to T_RESOURCES. Null if the Event is not related to a specific Resource.
RESOURCE_NAME	varchar2(100)	Name of the Resource. Null if the Event is not related to a specific Resource.
TIME_UNIT	varchar2(30)	Refers to the sending Metric: HOUR, DAY, WEEK, MONTH, QUARTER, or YEAR (for doing a join with V_PSL_EXTENDED on page ).
IS_PERIOD	number(1)	Refers to the sending Metric: 0 - Operational calculation. 1 - Business calculation according to the tracking period defined in the contract.
COMPLETE_PERIOD	number(1)	Refers to the sending Metric: 0 - Ongoing calculation in the middle of the period. 1 - Calculation of a period that was completed.
INTERVAL_LENGTH	number(10)	Refers to the sending Metric: the number of TIME_UNITs in the calculated period.
TRG_TIME_STAMP	date	The time stamp of the Event (UTC time).
WITH_EXCEPTION	number(1)	0 - Calculation that ignores Exceptions. 1 - Calculation that takes Exceptions into account.
WITH_CORRECTION	number(1)	0 - Calculation that ignores Corrections. 1 - Calculation that takes Corrections into account.
CORRECTION_FOLDED	number(1)	0 - Correction took place, and the current calculation was performed with and without Corrections separately. 1 - No Correction took place, and the current calculation was performed with and without Corrections together.
EXCEPTION_FOLDED	number(1)	0 - Exception took place, and the current calculation was performed with and without Exceptions separately. 1 - No Exception took place, and the current calculation was performed with and without Exceptions together.
CREATE_DATE	date	Creation date of the record.
MODIFY_DATE	date	Modification date of the record.
CALCULATION_MODE	varchar2(20)	Either NORMAL or FORECAST.
F_NAME1	field1type	Value of field #1 in the Event.
F_NAME2	field2type	Value of field #2 in the Event.
F_NAMEX	fieldxtype	Value of field #x in the Event.