V_FORMULA_TO

Business Intelligence (BI) Interface Guide › Business Intelligence Interface › SQL Interfaces › Additional Calculated Data Interface › V_FORMULA_TO_DATA

V_FORMULA_TO_DATA

This view holds data that is a combination of the V_FORMULA_TO_RAW_DATA and V_FORMULA_TO_INTERMEDIATE_DATA views, where raw data events have the value RD under the column DATA_TYPE and intermediate data events have the value ID in that field.

Note: Columns that are specific for Raw Data events have a NULL value in the intermediate data specific columns and vice a versa.

Name	Type	Content	Source of Column
FORMULA_ID	number	Foreign Key to T_FORMULAS It points to a formula that uses this event.	This field exists in both V_FORMULA_TO_ RAW_DATA and V_FORMULA_TO_ INTERMEDIATE_DATA
EVENT_ID	number	The ID of the event in T_INTERMEDIATE_ DATA or T_RAW_ DATA.	V_FORMULA_TO_ RAW_DATA (RAW_DATA_ID) or V_FORMULA_TO_ INTERMEDIATE_DATA (METRIC_EVENT_ID)
DATA_TYPE	varchar2(2)	Indication of the whether the data event is Raw Data (RD) or Intermediate Data (ID)	NA
EVENT_TYPE_ID	number	Foreign Key to T_EVENT_TYPES.	This field exists in both V_FORMULA_TO_ RAW_DATA and V_FORMULA_TO_ INTERMEDIATE_DATA
RESOURCE_ID	number	Foreign Key to T_RESOURCES. Null if the Event is not related to a specific Resource.	This field exists in both V_FORMULA_TO_ RAW_DATA and V_FORMULA_TO_ INTERMEDIATE_DATA
TIME_STAMP	date	Time stamp of the Event (UTC time).	V_FORMULA_TO_ RAW_DATA (TIME_STAMP) or V_FORMULA_TO_ INTERMEDIATE_DATA (TRG_TIME_STAMP)
SOURCE_TIME_ STAMP	date	The time stamp of the event was written.	V_FORMULA_TO_ RAW_DATA (READER_TIME_STAMP) or V_FORMULA_TO_ INTERMEDIATE_DATA (SRC_TIME_STAMP)
CREATE_DATE	date	Creation date of the record.	This field exists in both V_FORMULA_TO_ RAW_DATA and V_FORMULA_TO_ INTERMEDIATE_DATA
MODIFY_DATE	date		This field exists in both V_FORMULA_TO_ RAW_DATA and V_FORMULA_TO_ INTERMEDIATE_DATA
DATA_HTML	CLOB	Aggregation of all values of all the dynamic fields of the event in HTML format including field names.	This field exists in both V_FORMULA_TO_ RAW_DATA and V_FORMULA_TO_ INTERMEDIATE_DATA
HTML_DATA_ STR	varchar2(4000)	The first 4000 characters of the HTML data. Note: This field content might not be complete if the event data is longer than 4000 characters.	This field exists in both V_FORMULA_TO_ RAW_DATA and V_FORMULA_TO_ INTERMEDIATE_DATA
READER_ID	number	Foreign Key to T_READERS.	V_FORMULA_TO_ RAW_DATA
CREATED_BY	number	If the event was added by a Correction, contains the ID of the Correction.	V_FORMULA_TO_ RAW_DATA
CORRECTED_BY	number	If the event was deleted by a Correction, contains the ID of the Correction.	V_FORMULA_TO_ RAW_DATA
DATA_SOURCE_ ID	varchar2(60)	The name of the input file from which the event is retrieved and that the adapter reads.	V_FORMULA_TO_ RAW_DATA
HASH_DATA_ KEY	varchar2(16)	A value used to distinguish between events for sake of event singularity.	V_FORMULA_TO_ RAW_DATA
METRIC_ID	number	Foreign Key to T_RULES	V_FORMULA_TO_ INTERMEDIATE_DATA
METRIC_ GLOBAL_ID	number	Foreign Key to T_GLOBAL_RULES	V_FORMULA_TO_ INTERMEDIATE_DATA
TIME_UNIT	varchar2(30)	Refers to the sending Metric: HOUR/DAY/WEEK/MONTH/QUARTER/YEAR (for doing a join with V_PSL_EXTENDED).	V_FORMULA_TO_ INTERMEDIATE_DATA
IS_PERIOD	number	Refers to the sending Metric: 0 - Operational calculation. 1 - Business calculation according to the tracking period defined in the contract.	V_FORMULA_TO_ INTERMEDIATE_DATA
COMPLETE_ PERIOD	number	Refers to the sending Metric: 0 - Ongoing calculation in the middle of a period. 1 - Calculation of a period that was completed.	V_FORMULA_TO_ INTERMEDIATE_DATA
INTERVAL_ LENGTH	number	Refers to the sending Metric: the number of TIME_UNITs in the calculated period.	V_FORMULA_TO_ INTERMEDIATE_DATA
WITH_ EXCEPTION	number	0 - Calculation that ignores Exceptions. 1 - Calculation that takes Exceptions into account.	V_FORMULA_TO_ INTERMEDIATE_DATA
WITH_ CORRECTION	number	0 - Calculation that ignores Corrections. 1 - Calculation that takes Corrections into account.	V_FORMULA_TO_ INTERMEDIATE_DATA
CORRECTION_ FOLDED	number	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.	V_FORMULA_TO_ INTERMEDIATE_DATA
EXCEPTION_ FOLDED	number	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.	V_FORMULA_TO_ INTERMEDIATE_DATA
CALCULATION_ MODE	varchar2(20)	Either NORMAL or FORECAST.	V_FORMULA_TO_ INTERMEDIATE_DATA
FIELD_001	varchar2(4000)	The 1st value of the first dynamic field of this event	This field exists in both V_FORMULA_TO_ RAW_DATA and V_FORMULA_TO_ INTERMEDIATE_DATA
FIELD_002	varchar2(4000)	The 2nd value of the first dynamic field of this event	This field exists in both V_FORMULA_TO_ RAW_DATA and V_FORMULA_TO_ INTERMEDIATE_DATA
FIELD_099	varchar2(4000)	The 99th value of the first dynamic field of this event	This field exists in both V_FORMULA_TO_ RAW_DATA and V_FORMULA_TO_ INTERMEDIATE_DATA
FIELD_100	varchar2(4000)	The 100th value of the first dynamic field of this event	This field exists in both V_FORMULA_TO_ RAW_DATA and V_FORMULA_TO_ INTERMEDIATE_DATA