MSC_DELETED_PLAN_MEMBERS

This table is used to store the level members for non filtered dimensions that have been deleted from ODS. The plan snapshot process will use this table to delete or update the data records for these deleted level members from PDS tables.

Details

• Schema: FUSION

• Object owner: MSC

• Object type: TABLE

• Tablespace: Default

Primary Key

Name	Columns
MSC_DELETED_PLAN_MEMBERS_PK	MEMBER_ID, LEVEL_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
MEMBER_ID	NUMBER			Yes	Identifier for the member of the level which is deleted from ODS.
LOWER_LEVEL_MEMBER_ID	NUMBER				Identifier for member of the lowest level in the hierarchy which is deleted from ODS.
LOWER_LEVEL_ID	NUMBER				Identifier for the Lowest level in Hierarchy for which member record is deleted from ODS.
DIMENSION_ID	NUMBER				Identifies the records belonging to the dimension. Value '7' indicates member record which is deleted from ODS belongs to time dimension.
LEVEL_ID	NUMBER			Yes	Identifier for the Level in hierachy for which the member record is deleted from ODS.
ACTION_CODE	NUMBER		1		Indicates where the record is updated, or, deleted
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_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated 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.

Indexes

Index	Uniqueness	Tablespace	Columns
MSC_DELETED_PLAN_MEMBERS_U1	Unique	Default	MEMBER_ID, LEVEL_ID