DW_EB_X_EBS_COMMON_W_PROJECT_DH

This table stores a flattened hierarchy of the Project dimension DW_EB_X_EBS_COMMON_W_PROJECT_D. Eighteen levels of the hierarchy are allowed, but the user can extend it easily if required. The lowest level is called Base level, and the highest level is called Program. The other ones are numbered from 1 to 18.

Details

Module: Common Tables (EBS_COMMON)

Key Columns

Key column information is not documented in the supplied metadata.

Columns

Columns
Name	Datatype	Length	Precision	Not Null	Comments	Referred Table
ROW_WID	NUMBER		38	True	Surrogate key to uniquely identify a record.
BASE_PROJECT_ID	VARCHAR2	25 CHAR			Key of the base Project in the Source system
BASE_PROJECT_NAME	VARCHAR2	240 CHAR			Name of the base Project in the Source system
BASE_PROJECT_WID	NUMBER		38		Surrogate key of the base Project in the Target system	DW_EB_X_EBS_COMMON_W_PROJECT_D
CURRENT_FLG	VARCHAR2	1 CHAR			Indicates whether this hierarchy record is current or not. At anytime, there should be only one record for each BASE_PROJECT_WID, for which this flag is set to 'Y'
DATASOURCE_NUM_ID	NUMBER		10		This column is the unique identifier of the source system from which data was extracted. In order to be able to trace the data back to its source, Oracle recommends that you define separate unique source IDs for each of your different source instances.
EFFECTIVE_DT	TIMESTAMP		6
ETL_PROC_WID	NUMBER		38		System Field. This column is the unique identifier for the specific ETL process used to create or update this data.
FIXED_HIER_LEVEL	NUMBER		10		Level of this Project (defined by BASE_PROJECT_ID) in the current Hierarchy
LVL10_PROJECT_ID	VARCHAR2	25 CHAR			Key of the Level 10 Project in the Source system
LVL10_PROJECT_NAME	VARCHAR2	240 CHAR			Name of the Level 10 Project
LVL11_PROJECT_ID	VARCHAR2	25 CHAR			Key of the Level 11 Project in the Source system
LVL11_PROJECT_NAME	VARCHAR2	240 CHAR			Name of the Level 11 Project
LVL12_PROJECT_ID	VARCHAR2	25 CHAR			Key of the Level 12 Project in the Source system
LVL12_PROJECT_NAME	VARCHAR2	240 CHAR			Name of the Level 12 Project
LVL13_PROJECT_ID	VARCHAR2	25 CHAR			Key of the Level 13 Project in the Source system
LVL13_PROJECT_NAME	VARCHAR2	240 CHAR			Name of the Level 13 Project
LVL14_PROJECT_ID	VARCHAR2	25 CHAR			Key of the Level 14 Project in the Source system
LVL14_PROJECT_NAME	VARCHAR2	240 CHAR			Name of the Level 14 Project
LVL15_PROJECT_ID	VARCHAR2	25 CHAR			Key of the Level 15 Project in the Source system
LVL15_PROJECT_NAME	VARCHAR2	240 CHAR			Name of the Level 15 Project
LVL16_PROJECT_ID	VARCHAR2	25 CHAR			Key of the Level 16 Project in the Source system
LVL16_PROJECT_NAME	VARCHAR2	240 CHAR			Name of the Level 16 Project
LVL17_PROJECT_ID	VARCHAR2	25 CHAR			Key of the Level 17 Project in the Source system
LVL17_PROJECT_NAME	VARCHAR2	240 CHAR			Name of the Level 17 Project
LVL18_PROJECT_ID	VARCHAR2	25 CHAR			Key of the Level 18 Project in the Source system
LVL18_PROJECT_NAME	VARCHAR2	240 CHAR			Name of the Level 18 Project
LVL1_PROJECT_ID	VARCHAR2	25 CHAR			Key of the Level 1 Project in the Source system
LVL1_PROJECT_NAME	VARCHAR2	240 CHAR			Name of the Level 1 Project
LVL2_PROJECT_ID	VARCHAR2	25 CHAR			Key of the Level 2 Project in the Source system
LVL2_PROJECT_NAME	VARCHAR2	240 CHAR			Name of the Level 2 Project
LVL3_PROJECT_ID	VARCHAR2	25 CHAR			Key of the Level 3 Project in the Source system
LVL3_PROJECT_NAME	VARCHAR2	240 CHAR			Name of the Level 3 Project
LVL4_PROJECT_ID	VARCHAR2	25 CHAR			Key of the Level 4 Project in the Source system
LVL4_PROJECT_NAME	VARCHAR2	240 CHAR			Name of the Level 4 Project
LVL5_PROJECT_ID	VARCHAR2	25 CHAR			Key of the Level 5 Project in the Source system
LVL5_PROJECT_NAME	VARCHAR2	240 CHAR			Name of the Level 5 Project
LVL6_PROJECT_ID	VARCHAR2	25 CHAR			Key of the Level 6 Project in the Source system
LVL6_PROJECT_NAME	VARCHAR2	240 CHAR			Name of the Level 6 Project
LVL7_PROJECT_ID	VARCHAR2	25 CHAR			Key of the Level 7 Project in the Source system
LVL7_PROJECT_NAME	VARCHAR2	240 CHAR			Name of the Level 7 Project
LVL8_PROJECT_ID	VARCHAR2	25 CHAR			Key of the Level 8 Project in the Source system
LVL8_PROJECT_NAME	VARCHAR2	240 CHAR			Name of the Level 8 Project
LVL9_PROJECT_ID	VARCHAR2	25 CHAR			Key of the Level 9 Project in the Source system
LVL9_PROJECT_NAME	VARCHAR2	240 CHAR			Name of the Level 9 Project
PROGRAM_ID	VARCHAR2	25 CHAR			Key of the Top Level Program in the Source system
PROGRAM_NAME	VARCHAR2	240 CHAR			Name of the Top Level Program
PROJ_BU_ID	VARCHAR2	80 CHAR
TREE_NAME	VARCHAR2	80 CHAR
W$_INSERT_DT	TIMESTAMP		6
W$_UPDATE_DT	TIMESTAMP		6