ACD_METRICS_MEASURES

Contains configuration for creating rollups

Details

• Schema: FUSION

• Object owner: ACD

• Object type: TABLE

• Tablespace: REFERENCE

Primary Key

Name	Columns
ACD_METRICS_MEASURES_PK	METRICS_CONFIG_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
METRICS_CONFIG_ID	NUMBER		18	Yes	unique concept ID. Each version of a concept is stored as a separate concept with its own ID.
ACTIVE_FLAG	NUMBER		1	Yes	if val=1 than is used in rollup script.
ROLLUP_COL_NAME	VARCHAR2	30		Yes	This is the name of source column to employ for the rollup.
ROLLUP_RESULT_COL_NAME	VARCHAR2	30		Yes	The name of column to store result of rollup
QUANTITY_FLAG	NUMBER			Yes	If set i.e. val=1 than multiple the quantity during rollup
RLP_INCOMPLETE_CNT_COL_NAME	VARCHAR2	30			ROllup incomplete column name : If this column name is set, than it contains calculated value of n > 0 for missing values in rollup where n is the number of missing values. And 0 for non-missing values.
VARIANCE_TARGET_COL_NAME	VARCHAR2	30			The column where the target value can be found that is needed during variance calculation
VARIANCE_RESULT_COL_NAME	VARCHAR2	30			The result of variance calculated from rolled up value and target value.
VARIANCE_INVERSE_CALC_FLAG	NUMBER		1	Yes	if 1 than variance is calculated ROLLUP_RESULT_COL_NAME-VARIANCE_TARGET_COL_NAME if 0 than variance is calculated VARIANCE_TARGET_COL_NAME-ROLLUP_RESULT_COL_NAME
METRICS_MEASURES_GRP_ID	NUMBER		18	Yes	This is a foriegn key value from the ACD_METRICS_MEAS_GRP_B table that specifies the source and target tables for the rollups.
OBJECT_VERSION_NUMBER	NUMBER		9	Yes	Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.

Indexes

Index	Uniqueness	Tablespace	Columns
ACD_METRICS_MEASURES_N1	Non Unique	Default	METRICS_MEASURES_GRP_ID
ACD_METRICS_MEASURES_U1	Unique	Default	METRICS_CONFIG_ID
ACD_METRICS_MEASURES_U2	Unique	Default	ROLLUP_COL_NAME, ROLLUP_RESULT_COL_NAME, VARIANCE_TARGET_COL_NAME, VARIANCE_RESULT_COL_NAME, RLP_INCOMPLETE_CNT_COL_NAME, METRICS_MEASURES_GRP_ID