MSC_MEASURE_DATA_BK
ODS table to store the backup of the details of measures such as Shipments History, Bookings History, Forecast Measures and Causal Factors, etc.
Details
-
Schema: FUSION
-
Object owner: MSC
-
Object type: TABLE
-
Tablespace: TRANSACTION_TABLES
Primary Key
| Name | Columns |
|---|---|
|
MSC_MEASURE_DATA_BK_PK |
MEASURE_ID, PLAN_ID, PRD_LVL_ID, PRD_LVL_MEMBER_ID, ORG_LVL_ID, ORG_LVL_MEMBER_ID, CUS_LVL_ID, CUS_LVL_MEMBER_ID, SUP_LVL_ID, SUP_LVL_MEMBER_ID, DCS_LVL_ID, DCS_LVL_MEMBER_ID, TIM_LVL_ID, TIM_LVL_MEMBER_ID, CTO_LVL_MEMBER_ID, SOR_LVL_ID, SOR_LVL_MEMBER_ID, ORD_LVL_ID, ORD_LVL_MEMBER_ID, RES_LVL_ID, RES_LVL_MEMBER_ID, EXP_LVL_ID, EXP_LVL_MEMBER_ID, FCM_LVL_ID, FCM_LVL_MEMBER_ID, CLG_LVL_ID, CLG_LVL_MEMBER_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| SR_INSTANCE_ID | NUMBER | Yes | Source instance identifier from which the row was collected. | ||
| PLAN_ID | NUMBER | Yes | Identifier of the plan to which the data belongs to. | ||
| MEASURE_ID | NUMBER | Yes | Identifier of the measure to which data belongs to. | ||
| PRD_LVL_ID | NUMBER | Yes | Level identifier of the Product dimension member. | ||
| PRD_LVL_MEMBER_ID | NUMBER | Yes | Identifier of the Product dimension member. | ||
| ORG_LVL_ID | NUMBER | Yes | Level identifier of the Organization dimension member. | ||
| ORG_LVL_MEMBER_ID | NUMBER | Yes | Identifier of the Organization dimension member. | ||
| CUS_LVL_ID | NUMBER | Yes | Level identifier of the Customer dimension member. | ||
| CUS_LVL_MEMBER_ID | NUMBER | Yes | Identifier of the Customer dimension member. | ||
| SUP_LVL_ID | NUMBER | Yes | Level identifier of the Supplier dimension member. | ||
| SUP_LVL_MEMBER_ID | NUMBER | Yes | Identifier of the Supplier dimension member. | ||
| DCS_LVL_ID | NUMBER | Yes | Level identifier of the Demand Class dimension. | ||
| DCS_LVL_MEMBER_ID | NUMBER | Yes | Identifier of the Demand Class dimension member. | ||
| TIM_LVL_ID | NUMBER | Yes | Level identifier of the Time dimension member. | ||
| TIM_LVL_MEMBER_ID | NUMBER | Yes | Identifier of the Time dimension member. | ||
| CTO_LVL_MEMBER_ID | NUMBER | Yes | Level Member ID of the CTO level | ||
| SOR_LVL_ID | NUMBER | Yes | Level ID of the Sales Rep Level Member | ||
| SOR_LVL_MEMBER_ID | NUMBER | Yes | Member ID of the Sales Rep dimension | ||
| ORD_LVL_ID | NUMBER | Yes | Level identifier of the Order Type dimension member. | ||
| ORD_LVL_MEMBER_ID | NUMBER | Yes | Identifier of the Order Type dimension member. | ||
| EXP_LVL_ID | NUMBER | Yes | Level identifier of the Exception Type dimension. | ||
| EXP_LVL_MEMBER_ID | NUMBER | Yes | Identifier of the Exception Type dimension member. | ||
| RES_LVL_ID | NUMBER | Yes | Level identifier of the Resource Type dimension. | ||
| RES_LVL_MEMBER_ID | NUMBER | Yes | Identifier of the Resource type dimension member. | ||
| FCM_LVL_ID | NUMBER | Yes | Level identifier of the Demand Forecast Method dimension. | ||
| FCM_LVL_MEMBER_ID | NUMBER | Yes | ID of the level member of Demand Forecast Method Level Dimension | ||
| CLG_LVL_ID | NUMBER | Yes | Level identifier of the Decomposition Group dimension. | ||
| CLG_LVL_MEMBER_ID | NUMBER | Yes | Identifier of the Decomposition group dimension member. | ||
| ORDER_TYPE_FLAG | NUMBER | 1 | Flag to indicate whether the order is Internal, External, Transfer Order, Internal Sales Order or others. | ||
| MEASURE_TYPE | NUMBER | Yes | Numerical value to denote the Type of the measure. The valid values are 1 - Forecast Measures, 2 - Shipments History, 3 - Bookings History, 4 - Causal Factors. | ||
| UOM | VARCHAR2 | 50 | UOM code of the item and organization combination used in the measure data record. | ||
| OTH1_LVL_MEMBER_ID | NUMBER | Yes | Additional dimension1 member identifier (for customization, future feature). | ||
| OTH2_LVL_MEMBER_ID | NUMBER | Yes | Additional dimension2 member identifier (for customization, future feature). | ||
| OTH3_LVL_MEMBER_ID | NUMBER | Yes | Additional dimension3 member identifier (for customization, future feature). | ||
| OTH4_LVL_MEMBER_ID | NUMBER | Yes | Additional dimension4 member identifier (for customization, future feature). | ||
| OTH5_LVL_MEMBER_ID | NUMBER | Yes | Additional dimension5 member identifier (for customization, future feature). | ||
| COMPONENT_CODE | VARCHAR2 | 5 | Component code of the item. This applies to the configure-to-order data only. | ||
| COMPONENT_MODEL | VARCHAR2 | 5 | Model of the component. This applies to the configure-to-order data only. | ||
| VALUE_NUMBER | NUMBER | The quantity of the measure being uploaded. This column applies to number, currency and percentage type measures only. | |||
| CURRENCY | VARCHAR2 | 5 | Currency code of the organization used in the measure data record. | ||
| VALUE_DATE | DATE | The date value for the measure being uploaded. This column applies to date type measures only. | |||
| VALUE_TEXT | VARCHAR2 | 100 | The text value for the measure being uploaded. This column applies to text type measures only. | ||
| 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. | ||
| REFRESH_NUMBER | NUMBER | 18 | Yes | Cycle identifier of Collections that inserted or last updated the row. | |
| DELETED_FLAG | NUMBER | A numberical flag to denote whether the record should be deleted from ODS by collections. The valid values are 1 - True, 2-False. | |||
| 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. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| MSC_MEASURE_DATA_BK_U1 | Unique | Default | MEASURE_ID, PLAN_ID, PRD_LVL_ID, PRD_LVL_MEMBER_ID, ORG_LVL_ID, ORG_LVL_MEMBER_ID, CUS_LVL_ID, CUS_LVL_MEMBER_ID, SUP_LVL_ID, SUP_LVL_MEMBER_ID, DCS_LVL_ID, DCS_LVL_MEMBER_ID, TIM_LVL_ID, TIM_LVL_MEMBER_ID, CTO_LVL_MEMBER_ID, SOR_LVL_ID, SOR_LVL_MEMBER_ID, ORD_LVL_ID, ORD_LVL_MEMBER_ID, RES_LVL_ID, RES_LVL_MEMBER_ID, EXP_LVL_ID, EXP_LVL_MEMBER_ID, FCM_LVL_ID, FCM_LVL_MEMBER_ID, CLG_LVL_ID, CLG_LVL_MEMBER_ID |