XCC_ESSBASE_DUPLICATE_PARENTS

Table to store duplicate member info at parent level within the incoming tree versions compared to that of existing Essbase hierarchies.

Details

• Schema: FUSION

• Object owner: XCC

• Object type: TABLE

• Tablespace: Default

Primary Key

Name	Columns
XCC_ESSBASE_DUP_PARENTS_PK	CUBE_ID, MEMBER_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
CUBE_ID	NUMBER		18	Yes	Unique identifier for Essbase Cube.
VALUE_SET_ID	NUMBER		18	Yes	Value Set Id of the Budget COA segment
TREE_CODE	VARCHAR2	30		Yes	Identifier for the tree associated with this request
TREE_VERSION_ID	VARCHAR2	32			Identifier for the tree version associated with this request
MEMBER_NAME	VARCHAR2	150		Yes	Member of the tree, tree node name
MEMBER_ID	VARCHAR2	80		Yes	Internal identifier for the tree node
COLUMN_NAME	VARCHAR2	30		Yes	Column name which the segment value is stored
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.

Indexes

Index	Uniqueness	Tablespace	Columns
XCC_ESSBASE_DUP_PARENTS_N1	Non Unique	Default	TREE_CODE, TREE_VERSION_ID
XCC_ESSBASE_DUP_PARENTS_U1	Unique	Default	CUBE_ID, MEMBER_ID