MSC_MEASURE_DATA

ODS table to store the detials 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_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	Status
SR_INSTANCE_ID	NUMBER			Yes	Source Instance ID from which the row was collected.	Active
PLAN_ID	NUMBER			Yes	Plan id is to which data belongs.	Active
MEASURE_ID	NUMBER			Yes	Measure to which data belongs.	Active
PRD_LVL_ID	NUMBER			Yes	Level id of the Product dimension Member.	Active
PRD_LVL_MEMBER_ID	NUMBER			Yes	Product dimension Member id.	Active
ORG_LVL_ID	NUMBER			Yes	Level id of the Organization dimension Member	Active
ORG_LVL_MEMBER_ID	NUMBER			Yes	Organization dimension Member id.	Active
CUS_LVL_ID	NUMBER			Yes	Level id of the Customer dimension Member.	Active
CUS_LVL_MEMBER_ID	NUMBER			Yes	Customer dimension Member id.	Active
SUP_LVL_ID	NUMBER			Yes	Level id of the Supplier dimension Member.	Active
SUP_LVL_MEMBER_ID	NUMBER			Yes	Supplier dimension Member id.	Active
DCS_LVL_ID	NUMBER			Yes	Demand Class dimension Level ID.	Active
DCS_LVL_MEMBER_ID	NUMBER			Yes	Demand Class dimension Member ID.	Active
TIM_LVL_ID	NUMBER			Yes	Level id of the Time dimension Member.	Active
TIM_LVL_MEMBER_ID	NUMBER			Yes	Start date of the time dimension member.	Active
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 ID of the Order Type Dimension
ORD_LVL_MEMBER_ID	NUMBER			Yes	ID of the level member of the Order Type Dimension
EXP_LVL_ID	NUMBER			Yes	Level ID of the Exception Type Dimension
EXP_LVL_MEMBER_ID	NUMBER			Yes	ID of the level member of the Exception Type Dimension
RES_LVL_ID	NUMBER			Yes	Level ID of the Resource Type Dimension
RES_LVL_MEMBER_ID	NUMBER			Yes	ID of the level member of the Resource Type Dimension
FCM_LVL_ID	NUMBER			Yes	Level Id of the Demand Forecast Method Level Dimension
FCM_LVL_MEMBER_ID	NUMBER			Yes	ID of the level member of Demand Forecast Method Level Dimension
CLG_LVL_ID	NUMBER			Yes	Level Id of the Component Group Level Dimension
CLG_LVL_MEMBER_ID	NUMBER			Yes	ID of the level member of the Component Group Level Dimension
ORDER_TYPE_FLAG	NUMBER		1		Flag to indicate whether the order is an TO,ISO or others.
MEASURE_TYPE	NUMBER			Yes	1 - Forecast Measures 2 - Shipments History 3 - Bookings History 4 - Causal Factors
UOM	VARCHAR2	50			UOM Code.	Active
OTH1_LVL_MEMBER_ID	NUMBER			Yes	Additional Dimension1 Memberid (for customization, future feature).	Active
OTH2_LVL_MEMBER_ID	NUMBER			Yes	Additional Dimension2 Memberid (for customization, future feature).	Active
OTH3_LVL_MEMBER_ID	NUMBER			Yes	Additional Dimension3 Memberid (for customization, future feature).	Active
OTH4_LVL_MEMBER_ID	NUMBER			Yes	Additional Dimension4 Memberid (for customization, future feature).	Active
OTH5_LVL_MEMBER_ID	NUMBER			Yes	Additional Dimension5 Memberid (for customization, future feature).	Active
COMPONENT_CODE	VARCHAR2	5			Component Code of this Item - use for CTO data only.	Active
COMPONENT_MODEL	VARCHAR2	5			Model of Component - for CTO data only.	Active
VALUE_NUMBER	NUMBER				This column will be populated for Number, Currency, Percentage type measures.	Active
CURRENCY	VARCHAR2	5			Currency code of the org	Active
VALUE_DATE	DATE				This column will be populated for Date type measures	Active
VALUE_TEXT	VARCHAR2	100			This column will be populated for Text type measures	Active
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.	Active
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.	Active
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.	Active
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.	Active
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.	Active
REFRESH_NUMBER	NUMBER		18	Yes	Cycle id of Collections that inserted/last updated this row	Active
DELETED_FLAG	NUMBER				1-true; 2-False Whether record should be deleted from ODS by collections
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	Status
MSC_MEASURE_DATA_N2	Non Unique	FUSION_TS_TX_IDX	PLAN_ID, MEASURE_ID, TIM_LVL_MEMBER_ID, REFRESH_NUMBER	Active
MSC_MEASURE_DATA_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