ZSF_DS_METRIC
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_PK |
METRIC_ID, SNAPSHOT_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| METRIC_ID | NUMBER | 18 | Yes | Unique identifier for metric value | |
| PERIOD_ID | NUMBER | 18 | Yes | Period as defined in ZSF_DS_PERIOD | |
| SNAPSHOT_ID | NUMBER | 18 | Yes | Snapshot as defined in ZSF_DS_SNAPSHOT or 0 | |
| 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 | ||
| DIM1_ROOT_FLAG | VARCHAR2 | 1 | Y / NULL to indicate if the dimension key is the root of the hierarchy or not | ||
| DIM2_ROOT_FLAG | VARCHAR2 | 1 | Y / NULL to indicate if the dimension key is the root of the hierarchy or not | ||
| DIM3_ROOT_FLAG | VARCHAR2 | 1 | Y / NULL to indicate if the dimension key is the root of the hierarchy or not | ||
| DIM4_ROOT_FLAG | VARCHAR2 | 1 | Y / NULL to indicate if the dimension key is the root of the hierarchy or not | ||
| DIM5_ROOT_FLAG | VARCHAR2 | 1 | Y / NULL to indicate if the dimension key is the root of the hierarchy or not | ||
| METRIC_CODE | VARCHAR2 | 100 | Yes | Metric name as defined in ZSF_DS_METRIC_DEFN | |
| METRIC_LEVEL | VARCHAR2 | 30 | Yes | One of SUB | OWN | TOTAL SUB - rolled up value of all subordinates. OWN - total of all records directly owned. TOTAL - sum of the above two metrics. | |
| 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. | ||
| 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_N1 | Non Unique | Default | SNAPSHOT_ID, METRIC_DIM1_KEY, METRIC_DIM2_KEY, METRIC_CODE |
| ZSF_DS_METRIC_N2 | Non Unique | Default | SNAPSHOT_ID, METRIC_DIM1_KEY, DIM2_ROOT_FLAG, METRIC_CODE |
| ZSF_DS_METRIC_PK | Unique | Default | METRIC_ID, SNAPSHOT_ID |