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

ZSF_DS_ADJUSTMENT_CALC

This table contains the metric adjustments 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_ADJUSTMENT_CALC_PK

ADJUSTMENT_CALC_ID, PERIOD_ID

Columns

Name Datatype Length Precision Not-null Comments
ADJUSTMENT_CALC_ID NUMBER 18 Yes Unique identifier for adjustment calc id
ADJUSTMENT_ID NUMBER 18 Yes Foreign key from ZSF_DS_ADJUSTMENT
OPERATION_CODE VARCHAR2 30 Yes When an adjustment is created or updated the value will be ADJUST. When an adjustment is deleted, a set of records will be served with value RESET. This will be used to assist in effectively disregarding this adjustment when computing adjusted metrics.
METRIC_CODE VARCHAR2 100 Yes Metric name as defined in ZSF_DS_METRIC_DEFN
METRIC_LEVEL VARCHAR2 30 Yes May be one of SUB | OWN | TOTAL
PERIOD_ID NUMBER 18 Yes Period as defined in ZSF_DS_PERIOD.
ADJUSTED_BY_DIM1_KEY NUMBER 18 Yes ID of the ancestor who made the adjustment. Copied over from the corresponding ZSF_DS_ADJUSTMENT record.
ADJUSTED_BY_DIM1_ANC_PATH VARCHAR2 1000 Yes Path of the ancestor who made the adjustment.
DIM1_KEY NUMBER 18 Yes Foreign Key of the first metric dimension
DIM1_PARENT_KEY NUMBER 18 Yes Starting from the ADJUSTED_BY_METRIC_DIM1_KEY, all the ancestors of DIM1_KEY are populated in this column
DIM1_ANC_PATH VARCHAR2 1000 Yes Ancestor path reference of first metric dimension.
DIM1_ROOT_FLAG VARCHAR2 1 Y / NULL to indicate if the parent root 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 parent root 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 parent root 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 parent root 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 parent root key is the root of the hierarchy or not
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
ADJUSTED_METRIC_VALUE NUMBER Yes Value that the adjuster entered in the adjustment.
PROCESS_STATUS VARCHAR2 1 Column to indicate that the row is being worked on by the Metrics compress Process.
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_ADJUSTMENT_CALC_N1 Non Unique Default PERIOD_ID, DIM1_PARENT_KEY, OPERATION_CODE, PROCESS_STATUS, METRIC_CODE, METRIC_LEVEL
ZSF_DS_ADJUSTMENT_CALC_N2 Non Unique Default PERIOD_ID, DIM1_ANC_PATH, OPERATION_CODE, PROCESS_STATUS, METRIC_CODE, METRIC_LEVEL
ZSF_DS_ADJUSTMENT_CALC_PK Unique Default ADJUSTMENT_CALC_ID, PERIOD_ID