DW_EB_X_EBS_COMMON_W_GL_SEGMENT_DH

This is a generic hierarchy table. It stores hierarchies in flattened out structure. ColumnsLEVEL0_CODE- LEVEL31_CODE stores the code values for each level within anhierarchy, including the leaf nodes. For instance, if you have a hierarchy with 12 leaf nodes,then you will have 12 records in this table. Each record will record the top node to leaf nodepath.This table supports storing unlimited number of hierarchies. TheROW_WID column is a system generated numeric ID which uniquely identifies a record in thistable. Fact tables or dimension tables will reference a particular record in this table using thisROW_WID column.

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	Referred Table
ROW_WID	NUMBER		38	True
AUX1_CHANGED_ON_DT	TIMESTAMP		6
AUX2_CHANGED_ON_DT	TIMESTAMP		6
AUX3_CHANGED_ON_DT	TIMESTAMP		6
AUX4_CHANGED_ON_DT	TIMESTAMP		6
CHANGED_BY_WID	NUMBER		38
CHANGED_ON_DT	TIMESTAMP		6
CREATED_BY_WID	NUMBER		38
CREATED_ON_DT	TIMESTAMP		6
CURRENT_FLG	VARCHAR2	1 CHAR
DATASOURCE_NUM_ID	NUMBER		10
DELETE_FLG	VARCHAR2	1 CHAR
EFFECTIVE_FROM_DT	TIMESTAMP		6
EFFECTIVE_TO_DT	TIMESTAMP		6
ENABLED_FLG	VARCHAR2	1 CHAR
ETL_PROC_WID	NUMBER		38
FIXED_HIER_LEVEL	NUMBER		10
GL_SEGMENT_WID	NUMBER		38		DW_EB_X_EBS_COMMON_W_GL_SEGMENT_D
HIERARCHY_ID	VARCHAR2	100 CHAR
HIERARCHY_LOV_ID	VARCHAR2	100 CHAR
HIERARCHY_VERSION	VARCHAR2	100 CHAR
HIERARCHY_VERSION_NAME	VARCHAR2	100 CHAR
HIER_CAT_CODE	VARCHAR2	50 CHAR
HIER_CAT_DESC	VARCHAR2	80 CHAR
HIER_SUB_CAT_CODE	VARCHAR2	50 CHAR
HIER_SUB_CAT_DESC	VARCHAR2	80 CHAR
INTEGRATION_ID	VARCHAR2	400 CHAR
LEVEL0_CODE	VARCHAR2	150 CHAR
LEVEL0_INTEGRATION_ID	VARCHAR2	400 CHAR
LEVEL0_SECURITY_ID	VARCHAR2	400 CHAR
LEVEL10_CODE	VARCHAR2	150 CHAR
LEVEL10_INTEGRATION_ID	VARCHAR2	400 CHAR
LEVEL10_SECURITY_ID	VARCHAR2	400 CHAR
LEVEL11_CODE	VARCHAR2	150 CHAR
LEVEL11_INTEGRATION_ID	VARCHAR2	400 CHAR
LEVEL11_SECURITY_ID	VARCHAR2	400 CHAR
LEVEL12_CODE	VARCHAR2	150 CHAR
LEVEL12_INTEGRATION_ID	VARCHAR2	400 CHAR
LEVEL12_SECURITY_ID	VARCHAR2	400 CHAR
LEVEL13_CODE	VARCHAR2	150 CHAR
LEVEL13_INTEGRATION_ID	VARCHAR2	400 CHAR
LEVEL13_SECURITY_ID	VARCHAR2	400 CHAR
LEVEL14_CODE	VARCHAR2	150 CHAR
LEVEL14_INTEGRATION_ID	VARCHAR2	400 CHAR
LEVEL14_SECURITY_ID	VARCHAR2	400 CHAR
LEVEL15_CODE	VARCHAR2	150 CHAR
LEVEL15_INTEGRATION_ID	VARCHAR2	400 CHAR
LEVEL15_SECURITY_ID	VARCHAR2	400 CHAR
LEVEL16_CODE	VARCHAR2	150 CHAR
LEVEL16_INTEGRATION_ID	VARCHAR2	400 CHAR
LEVEL16_SECURITY_ID	VARCHAR2	400 CHAR
LEVEL17_CODE	VARCHAR2	150 CHAR
LEVEL17_INTEGRATION_ID	VARCHAR2	400 CHAR
LEVEL17_SECURITY_ID	VARCHAR2	400 CHAR
LEVEL18_CODE	VARCHAR2	150 CHAR
LEVEL18_INTEGRATION_ID	VARCHAR2	400 CHAR
LEVEL18_SECURITY_ID	VARCHAR2	400 CHAR
LEVEL19_CODE	VARCHAR2	150 CHAR
LEVEL19_INTEGRATION_ID	VARCHAR2	400 CHAR
LEVEL19_SECURITY_ID	VARCHAR2	400 CHAR
LEVEL1_CODE	VARCHAR2	150 CHAR
LEVEL1_INTEGRATION_ID	VARCHAR2	400 CHAR
LEVEL1_SECURITY_ID	VARCHAR2	400 CHAR
LEVEL20_CODE	VARCHAR2	150 CHAR
LEVEL20_INTEGRATION_ID	VARCHAR2	400 CHAR
LEVEL20_SECURITY_ID	VARCHAR2	400 CHAR
LEVEL21_CODE	VARCHAR2	150 CHAR
LEVEL21_INTEGRATION_ID	VARCHAR2	400 CHAR
LEVEL21_SECURITY_ID	VARCHAR2	400 CHAR
LEVEL22_CODE	VARCHAR2	150 CHAR
LEVEL22_INTEGRATION_ID	VARCHAR2	400 CHAR
LEVEL22_SECURITY_ID	VARCHAR2	400 CHAR
LEVEL23_CODE	VARCHAR2	150 CHAR
LEVEL23_INTEGRATION_ID	VARCHAR2	400 CHAR
LEVEL23_SECURITY_ID	VARCHAR2	400 CHAR
LEVEL24_CODE	VARCHAR2	150 CHAR
LEVEL24_INTEGRATION_ID	VARCHAR2	400 CHAR
LEVEL24_SECURITY_ID	VARCHAR2	400 CHAR
LEVEL25_CODE	VARCHAR2	150 CHAR
LEVEL25_INTEGRATION_ID	VARCHAR2	400 CHAR
LEVEL25_SECURITY_ID	VARCHAR2	400 CHAR
LEVEL26_CODE	VARCHAR2	150 CHAR
LEVEL26_INTEGRATION_ID	VARCHAR2	400 CHAR
LEVEL26_SECURITY_ID	VARCHAR2	400 CHAR
LEVEL27_CODE	VARCHAR2	150 CHAR
LEVEL27_INTEGRATION_ID	VARCHAR2	400 CHAR
LEVEL27_SECURITY_ID	VARCHAR2	400 CHAR
LEVEL28_CODE	VARCHAR2	150 CHAR
LEVEL28_INTEGRATION_ID	VARCHAR2	400 CHAR
LEVEL28_SECURITY_ID	VARCHAR2	400 CHAR
LEVEL29_CODE	VARCHAR2	150 CHAR
LEVEL29_INTEGRATION_ID	VARCHAR2	400 CHAR
LEVEL29_SECURITY_ID	VARCHAR2	400 CHAR
LEVEL2_CODE	VARCHAR2	150 CHAR
LEVEL2_INTEGRATION_ID	VARCHAR2	400 CHAR
LEVEL2_SECURITY_ID	VARCHAR2	400 CHAR
LEVEL30_CODE	VARCHAR2	150 CHAR
LEVEL30_INTEGRATION_ID	VARCHAR2	400 CHAR
LEVEL30_SECURITY_ID	VARCHAR2	400 CHAR
LEVEL31_CODE	VARCHAR2	150 CHAR
LEVEL31_INTEGRATION_ID	VARCHAR2	400 CHAR
LEVEL31_SECURITY_ID	VARCHAR2	400 CHAR
LEVEL3_CODE	VARCHAR2	150 CHAR
LEVEL3_INTEGRATION_ID	VARCHAR2	400 CHAR
LEVEL3_SECURITY_ID	VARCHAR2	400 CHAR
LEVEL4_CODE	VARCHAR2	150 CHAR
LEVEL4_INTEGRATION_ID	VARCHAR2	400 CHAR
LEVEL4_SECURITY_ID	VARCHAR2	400 CHAR
LEVEL5_CODE	VARCHAR2	150 CHAR
LEVEL5_INTEGRATION_ID	VARCHAR2	400 CHAR
LEVEL5_SECURITY_ID	VARCHAR2	400 CHAR
LEVEL6_CODE	VARCHAR2	150 CHAR
LEVEL6_INTEGRATION_ID	VARCHAR2	400 CHAR
LEVEL6_SECURITY_ID	VARCHAR2	400 CHAR
LEVEL7_CODE	VARCHAR2	150 CHAR
LEVEL7_INTEGRATION_ID	VARCHAR2	400 CHAR
LEVEL7_SECURITY_ID	VARCHAR2	400 CHAR
LEVEL8_CODE	VARCHAR2	150 CHAR
LEVEL8_INTEGRATION_ID	VARCHAR2	400 CHAR
LEVEL8_SECURITY_ID	VARCHAR2	400 CHAR
LEVEL9_CODE	VARCHAR2	150 CHAR
LEVEL9_INTEGRATION_ID	VARCHAR2	400 CHAR
LEVEL9_SECURITY_ID	VARCHAR2	400 CHAR
SRC_EFF_FROM_DT	TIMESTAMP		6
SRC_EFF_TO_DT	TIMESTAMP		6
TENANT_ID	VARCHAR2	80 CHAR
X_CUSTOM	VARCHAR2	10 CHAR
W$_INSERT_DT	TIMESTAMP		6
W$_UPDATE_DT	TIMESTAMP		6