MSC_LEVEL_MEMBERS

This ODS table stores member details of all dynamically generated levels of the given Dimensions.

Details

Name	Datatype	Length	Precision	Not-null	Comments	Status
HIERARCHY_ID	NUMBER				ID of the given Hierarchy.
LEVEL_ID	NUMBER			Yes	ID of the given Level.	Active
LEVEL_MEMBER_ID	NUMBER			Yes	ID of the given Level Member	Active
ROOT_MEMBER_ID	NUMBER				Column for Root Member ID.
PARENT_LEVEL_ID	NUMBER				Level ID of Parent level of the given level
PARENT_LEVEL_MEMBER_ID	NUMBER				Column for Parent Level Member Id.
LEVEL_NUMBER	NUMBER		5		Column for the Level Number.
IS_LEAF_LEVEL	NUMBER		1		Denotes whether the given Level is leaf level or not. A leaf level is the last level in the given tree
LAST_REFRESH_NUMBER	NUMBER			Yes	LAST_REFRESH_NUMBER
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

Index	Uniqueness	Tablespace	Columns	Status
MSC_LEVEL_MEMBERS_U1	Unique	Default	HIERARCHY_ID, LEVEL_ID, LEVEL_MEMBER_ID, ROOT_MEMBER_ID
MSC_LEVEL_MEMBERS_U2	Unique	Default	HIERARCHY_ID, PARENT_LEVEL_ID, PARENT_LEVEL_MEMBER_ID, LEVEL_MEMBER_ID, LEVEL_ID	Obsolete
MSC_LEVEL_MEMBERS_U3	Unique	Default	HIERARCHY_ID, LEVEL_ID, LEVEL_MEMBER_ID, PARENT_LEVEL_ID, PARENT_LEVEL_MEMBER_ID