MSC_ST_MEASURE_DATA
This is a staging table to store the details of DP Forecast Measures and DP Shipments and Booking History records that are to be collected into the Oracle Data Store for consumption by Planning products.
Details
-
Schema: FUSION
-
Object owner: MSC
-
Object type: TABLE
-
Tablespace: INTERFACE
Columns
Name | Datatype | Length | Not-null | Comments | Status |
---|---|---|---|---|---|
SR_INSTANCE_CODE | VARCHAR2 | 30 | Yes | Source instance code for which the data is being loaded. | |
SR_INSTANCE_ID | NUMBER | Source instance id will be stored for the validation failed records only. | |||
PLAN_NAME | VARCHAR2 | 100 | Plan name for which the data is being loaded. | ||
MEASURE_NAME | VARCHAR2 | 100 | The measure for which the data is being loaded. | ||
MEASURE_ID | NUMBER | Measure id will be stored for the validation failed records only. | |||
PRD_HIERARCHY_NAME | VARCHAR2 | 64 | Hierarchy name to identify the level and level member name of the product hierarchy. | ||
PRD_LVL_NAME | VARCHAR2 | 100 | Level name of the member of the product dimension. | ||
PRD_LVL_ID | NUMBER | Product level id will be stored for the validation failed records only. | |||
PRD_LVL_MEMBER_NAME | VARCHAR2 | 300 | Member name of the product dimension level. | ||
PRD_LVL_MEMBER_ID | NUMBER | Product level member id will be stored for the validation failed records only. | |||
ORG_HIERARCHY_NAME | VARCHAR2 | 64 | Hierarchy name to identify the level and level member name of the organization hierarchy. | ||
ORG_LVL_NAME | VARCHAR2 | 100 | Level name of the member of the organization dimension. | ||
ORG_LVL_ID | NUMBER | Organization level id will be stored for the validation failed records only. | |||
ORG_LVL_MEMBER_NAME | VARCHAR2 | 100 | Member name of the organization dimension level. | ||
ORG_LVL_MEMBER_ID | NUMBER | Organization level member id will be stored for the validation failed records only. | |||
CUS_HIERARCHY_NAME | VARCHAR2 | 64 | Hierarchy name to identify the level and level member name of the customer hierarchy. | ||
CUS_LVL_NAME | VARCHAR2 | 100 | Level name of the member of the customer dimension. | ||
CUS_LVL_ID | NUMBER | Customer level id will be stored for the validation failed records only. | |||
CUS_LVL_MEMBER_NAME | VARCHAR2 | 360 | Member name of the customer dimension level. | ||
CUS_LVL_MEMBER_ID | NUMBER | Customer level member id will be stored for the validation failed records only. | |||
CUS_SITE_LVL_NAME | VARCHAR2 | 100 | Level name of the member of the customer site dimension. | ||
CUS_SITE_LVL_MEMBER_NAME | VARCHAR2 | 360 | Member name of the customer site dimension level. | ||
SUP_LVL_NAME | VARCHAR2 | 100 | Level name of the member of the supplier dimension. | ||
SUP_LVL_ID | NUMBER | Supplier level id will be stored for the validation failed records only. | |||
SUP_LVL_MEMBER_NAME | VARCHAR2 | 360 | Member name of the supplier dimension level. | ||
SUP_SITE_LVL_MEMBER_NAME | VARCHAR2 | 360 | Member name of the supplier site dimension level. | ||
SUP_LVL_MEMBER_ID | NUMBER | Supplier level member id will be stored for the validation failed records only. | |||
DCS_LVL_NAME | VARCHAR2 | 100 | Level name of the member of the demand class dimension. | ||
DCS_LVL_ID | NUMBER | Demand class level id will be stored for the validation failed records only. | |||
DCS_LVL_MEMBER_NAME | VARCHAR2 | 100 | Member name of the demand class dimension level. | ||
DCS_LVL_MEMBER_ID | NUMBER | Demand class level member id will be stored for the validation failed records only. | |||
TIM_HIERARCHY_NAME | VARCHAR2 | 240 | Hierarchy name to identify the level and level member name of the time hierarchy. | ||
TIM_LVL_NAME | VARCHAR2 | 100 | Level name of the member of the time dimension. | ||
TIM_LVL_MEMBER_VALUE | DATE | Member name of the time dimension level. | |||
TIM_LVL_MEMBER_ID | NUMBER | Time level member id will be stored for the validation failed records only. | |||
CTO_LVL_MEMBER_NAME | VARCHAR2 | 2000 | Member name of the CTO dimension level. | ||
CTO_LVL_MEMBER_ID | NUMBER | CTO level member id will be stored for the validation failed records only. | |||
SOR_LVL_NAME | VARCHAR2 | 100 | Level name of the member of the sales rep dimension. | ||
SOR_LVL_ID | NUMBER | Sales rep level id will be stored for the validation failed records only. | |||
SOR_LVL_MEMBER_NAME | VARCHAR2 | 360 | Member name of the sales rep dimension level. | ||
SOR_LVL_MEMBER_ID | NUMBER | Sales rep level member id will be stored for the validation failed records only. | |||
ORD_LVL_NAME | VARCHAR2 | 100 | Level name of the member of the order type dimension. | ||
ORD_LVL_ID | NUMBER | Order type level id will be stored for the validation failed records only. | |||
ORD_LVL_MEMBER_NAME | VARCHAR2 | 100 | Member name of the order type dimension level. | ||
ORD_LVL_MEMBER_ID | NUMBER | Order type level member id will be stored for the validation failed records only. | |||
EXP_LVL_NAME | VARCHAR2 | 100 | Level name of the member of the exception type dimension. | ||
EXP_LVL_ID | NUMBER | Exception type level id will be stored for the validation failed records only. | |||
EXP_LVL_MEMBER_NAME | VARCHAR2 | 100 | Member name of the exception type dimension. | ||
EXP_LVL_MEMBER_ID | NUMBER | Exception type level member id will be stored for the validation failed records only. | |||
RES_LVL_NAME | VARCHAR2 | 100 | Level name of the member of the resource dimension. | ||
RES_LVL_ID | NUMBER | Resource level id will be stored for the validation failed records only. | |||
RES_LVL_MEMBER_NAME | VARCHAR2 | 100 | Member name of the resource dimension. | ||
RES_LVL_MEMBER_ID | NUMBER | Resource level member id will be stored for the validation failed records only. | |||
FCM_LVL_NAME | VARCHAR2 | 100 | Level name of the member of the demand forecast method dimension. | ||
FCM_LVL_ID | NUMBER | Demand forecast method level id will be stored for the validation failed records only. | |||
FCM_LVL_MEMBER_NAME | VARCHAR2 | 100 | Member name of the demand forecast method dimension. | ||
FCM_LVL_MEMBER_ID | NUMBER | Demand forecast method level member id will be stored for the validation failed records only. | |||
CLG_LVL_NAME | VARCHAR2 | 100 | Level name of the member of the component group dimension. | ||
CLG_LVL_ID | NUMBER | Component group level id will be stored for the validation failed records only. | |||
CLG_LVL_MEMBER_NAME | VARCHAR2 | 100 | Member name of the component group dimension. | ||
CLG_LVL_MEMBER_ID | NUMBER | Component group level member id will be stored for the validation failed records only. | |||
ORDER_TYPE_FLAG | VARCHAR2 | 50 | Flag to indicate whether the order is TO, ISO or others. | ||
MEASURE_TYPE | NUMBER | Indicates the type of measure 0 - User-Defined Measures 1 - Forecast Measures 2 - Shipments History 3 - Bookings History 4 - Causal Factors 5 - Option Shipment History 6 - Option Booking History | |||
UOM | VARCHAR2 | 50 | UOM code of the measure being loaded. | ||
OTH1_LVL_MEMBER_ID | NUMBER | Other1 Level member id will be stored for the validation failed records only. | |||
OTH1_LVL_MEMBER_NAME | VARCHAR2 | 100 | Member name of the Other1 dimension. | ||
OTH2_LVL_MEMBER_ID | NUMBER | Other2 Level member id will be stored for the validation failed records only. | |||
OTH2_LVL_MEMBER_NAME | VARCHAR2 | 100 | Member name of the Other2 dimension. | ||
OTH3_LVL_MEMBER_ID | NUMBER | Other3 Level member id will be stored for the validation failed records only. | |||
OTH3_LVL_MEMBER_NAME | VARCHAR2 | 100 | Member name of the Other3 dimension. | ||
OTH4_LVL_MEMBER_ID | NUMBER | Other4 Level member id will be stored for the validation failed records only. | |||
OTH4_LVL_MEMBER_NAME | VARCHAR2 | 100 | Member name of the Other4 dimension. | ||
OTH5_LVL_MEMBER_ID | NUMBER | Other5 Level member id will be stored for the validation failed records only. | |||
OTH5_LVL_MEMBER_NAME | VARCHAR2 | 100 | Member name of the Other5 dimension. | ||
SHIPPED_DATE | DATE | Shipped date of the measure being loaded. | |||
BOOKED_DATE | DATE | Booked date of the measure being loaded. | |||
REQUESTED_DATE | DATE | Requested date of the measure being loaded. | |||
PROMISED_DATE | DATE | Promised date of the measure being loaded. | |||
COMPONENT_CODE | VARCHAR2 | 5 | Component code of the item - use for CTO data only. | ||
COMPONENT_MODEL | VARCHAR2 | 5 | Model of component - use for CTO data only | ||
ISO_FLAG | NUMBER | Flag to indicate whether the order is an ISO | Obsolete | ||
VALUE_NUMBER | NUMBER | This column will be populated for NUMBER type measures. | |||
VALUE_DATE | DATE | This column will be populated for Date type measures. | |||
VALUE_TEXT | VARCHAR2 | 100 | This column will be populated for Text type measures. | ||
CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
CURRENCY | VARCHAR2 | 5 | Currency code of the custom measure. For seeded measures, this column will be NULL. | ||
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 | -for process flag=5 row indicates input_group_id for rows to be loaded to ODS -for other rows it is cycle-id of Collections cycle that inserted/updated this record | |||
PROCESS_FLAG | NUMBER | 5- new record to be loaded to ODS 4-record queued for retry by a collections cycle 3-Record loaded to ODS with warnings 2-record errored out by a collections cycle 1-Record loaded to ODS without warnings | |||
RETRY_COUNT | NUMBER | This column is for future use. | |||
ERROR_CODE | VARCHAR2 | 150 | Error code for functional validation errors in the record. | ||
ERROR_TEXT | VARCHAR2 | 2000 | Error text for functional validation errors in the record. | ||
DELETED_FLAG | NUMBER | Flag indicating whether this is a deleted record. | |||
LOAD_REQUEST_ID | NUMBER | Stores the request id of the job that loaded the data. | |||
DCS_HIERARCHY_NAME | VARCHAR2 | 64 | Hierarchy name to identify the level and level member name of the demand class hierarchy. | ||
TIM_RANGE_END_DATE | DATE | The end date for the SCC measure records. This value is used to delete the measure based on the date range. |