MSC_MEASURE_DATA_LEVELS
Metadata table to identify if data is available at aggregate levels in ODS for each measure in the plan
Details
-
Schema: FUSION
-
Object owner: MSC
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
MSC_MEASURE_DATA_LEVELS_PK |
PLAN_ID, MEASURE_ID, PRD_LVL_ID, ORG_LVL_ID, CUS_LVL_ID, SUP_LVL_ID, DCS_LVL_ID, TIM_LVL_ID, ORD_LVL_ID, EXP_LVL_ID, RES_LVL_ID, FCM_LVL_ID, CLG_LVL_ID, SOR_LVL_ID |
Columns
| Name | Datatype | Length | Not-null | Comments |
|---|---|---|---|---|
| PLAN_ID | NUMBER | Yes | Plan id is to which data belongs. | |
| MEASURE_ID | NUMBER | Yes | The Unique identifier for the measure | |
| PRD_LVL_ID | NUMBER | Yes | Level id of the Product dimension Member | |
| ORG_LVL_ID | NUMBER | Yes | Level id of the Organization dimension Member | |
| CUS_LVL_ID | NUMBER | Yes | Level id of the Customer dimension Member | |
| SUP_LVL_ID | NUMBER | Yes | Level id of the Supplier dimension Member | |
| DCS_LVL_ID | NUMBER | Yes | Demand Class dimension Level ID | |
| TIM_LVL_ID | NUMBER | Yes | Level id of the Time dimension Member | |
| ORD_LVL_ID | NUMBER | Yes | Level ID of the Order Type Dimension | |
| EXP_LVL_ID | NUMBER | Yes | Level ID of the Exception Type Dimension | |
| RES_LVL_ID | NUMBER | Yes | Level ID of the Resource Type Dimension | |
| FCM_LVL_ID | NUMBER | Yes | Level Id of the Demand Forecast Method Level Dimension | |
| CLG_LVL_ID | NUMBER | Yes | Level Id of the Component Group Level Dimension | |
| SOR_LVL_ID | NUMBER | Yes | Level ID of the Sales Rep Level Member | |
| 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 |
|---|---|---|---|
| MSC_MEASURE_DATA_LEVELS_U1 | Unique | Default | PLAN_ID, MEASURE_ID, PRD_LVL_ID, ORG_LVL_ID, CUS_LVL_ID, SUP_LVL_ID, DCS_LVL_ID, TIM_LVL_ID, ORD_LVL_ID, EXP_LVL_ID, RES_LVL_ID, FCM_LVL_ID, CLG_LVL_ID, SOR_LVL_ID |