1. Tables and Views for Sales and Fusion Service
  2. ZSF_DS_METRIC_SRC_CHG_LOG

ZSF_DS_METRIC_SRC_CHG_LOG

This table contains metric change log details

Details

  • Schema: FUSION

  • Object owner: ZSF

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

ZSF_DS_METRIC_SRC_CHG_LOG_PK

METRIC_SRC_CHG_LOG_ID

Columns

Name Datatype Length Precision Not-null Comments
METRIC_SRC_CHG_LOG_ID NUMBER 18 Yes Surrogate primary key that uniquely identifies a metric change
PERIOD_ID NUMBER 18 Yes Period as defined in ZSF_DS_PERIOD
METRIC_CODE VARCHAR2 100 Yes Metric name as defined in ZSF_DS_METRIC_DEFN
METRIC_DIM1_KEY NUMBER 18 Yes Foreign Key of the first metric dimension
METRIC_DIM2_KEY NUMBER 18 Foreign Key of the second metric dimension
METRIC_DIM3_KEY NUMBER 18 Foreign Key of the third metric dimension
METRIC_DIM4_KEY NUMBER 18 Foreign Key of the fourth metric dimension
METRIC_DIM5_KEY NUMBER 18 Foreign Key of the fifth metric dimension
METRIC_SRC_PK1 NUMBER 18 Yes PK value of first metric source table
METRIC_SRC_OVN1 NUMBER 30 Yes OVN value of first metric source table
METRIC_SRC_PK2 NUMBER 18 PK value of second metric source table
METRIC_SRC_OVN2 NUMBER 30 OVN value of second metric source table
METRIC_SRC_PK3 NUMBER 18 PK value of third metric source table
METRIC_SRC_OVN3 NUMBER 30 OVN value of third metric source table
DIFF_AMOUNT NUMBER Yes Differential amount added or reduced from the metric source
PROCESS_STATUS VARCHAR2 1 Column to indicate that the row is being worked on by the Metrics compress Process.
METRIC_LEVEL VARCHAR2 30 One of NRT | DEL | NULL NRT - Records to be processed by compress job. DEL - should be deleted during compress.
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.
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.
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
JOB_DEFINITION_NAME VARCHAR2 100 Enterprise Service Scheduler: indicates the name of the job that created or last updated the row.
JOB_DEFINITION_PACKAGE VARCHAR2 900 Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row.

Indexes

Index Uniqueness Tablespace Columns
ZSF_DS_METRIC_SRC_CHG_LOG_N1 Non Unique Default PERIOD_ID, METRIC_DIM1_KEY, METRIC_DIM2_KEY, METRIC_DIM3_KEY
ZSF_DS_METRIC_SRC_CHG_LOG_PK Unique Default METRIC_SRC_CHG_LOG_ID