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

ZSF_DS_METRIC_CALC

This table contains the source tables from which metrics will be computed in Sales Forecasting.

Details

  • Schema: FUSION

  • Object owner: ZSF

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

ZSF_DS_METRIC_CALC_PK

METRIC_CALC_ID, PERIOD_ID

Columns

Name Datatype Length Precision Not-null Comments
METRIC_CALC_ID NUMBER 18 Yes Unique identifier for metric value
METRIC_CODE VARCHAR2 100 Yes Metric name as defined in ZSF_DS_METRIC_DEFN
PERIOD_ID NUMBER 18 Yes Period as defined in ZSF_DS_PERIOD.
DIM1_KEY NUMBER 18 Yes Foreign Key of the first metric dimension
DIM1_PARENT_KEY NUMBER 18 Parent reference of first metric dimension
DIM1_ANC_PATH VARCHAR2 1000 Ancestor path reference of first metric dimension.
DIM1_ROOT_FLAG VARCHAR2 1 Y / NULL to indicate if the dimension key is the root of the hierarchy or not
DIM2_KEY NUMBER 18 Foreign Key of the second metric dimension
DIM2_PARENT_KEY NUMBER 18 Parent reference of second metric dimension.
DIM2_ANC_PATH VARCHAR2 1000 Ancestor path reference of second metric dimension.
DIM2_ROOT_FLAG VARCHAR2 1 Y / NULL to indicate if the dimension key is the root of the hierarchy or not
DIM3_KEY NUMBER 18 Foreign Key of the third metric dimension
DIM3_PARENT_KEY NUMBER 18 Parent reference of third metric dimension.
DIM3_ANC_PATH VARCHAR2 1000 Ancestor path reference of third metric dimension.
DIM3_ROOT_FLAG VARCHAR2 1 Y / NULL to indicate if the dimension key is the root of the hierarchy or not
DIM4_KEY NUMBER 18 Foreign Key of the fourth metric dimension
DIM4_PARENT_KEY NUMBER 18 Parent reference of fourth metric dimension.
DIM4_ANC_PATH VARCHAR2 1000 Ancestor path reference of fourth metric dimension.
DIM4_ROOT_FLAG VARCHAR2 1 Y / NULL to indicate if the dimension key is the root of the hierarchy or not
DIM5_KEY NUMBER 18 Foreign Key of the fifth metric dimension
DIM5_PARENT_KEY NUMBER 18 Parent reference of fifth metric dimension.
DIM5_ANC_PATH VARCHAR2 1000 Ancestor path reference of fifth metric dimension.
DIM5_ROOT_FLAG VARCHAR2 1 Y / NULL to indicate if the dimension key is the root of the hierarchy or not
METRIC_VALUE NUMBER Yes Amount / Value of the metric. If the metric is an amount based metric, this column will contain the amount in Corporate Currency. If the metric is unit based (like Quantity based metrics), it will contain the number of units.
METRIC_SRC_PK1 NUMBER 18 PK value of first metric source table
METRIC_SRC_OVN1 NUMBER 30 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
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_CALC_N2 Non Unique Default PERIOD_ID, DIM1_PARENT_KEY, METRIC_CODE
ZSF_DS_METRIC_CALC_PK Unique Default METRIC_CALC_ID, PERIOD_ID