DW_EB_X_EBS_COMMON_W_BALANCING_SEGMENT_DH

Imported from database

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
AUX1_CHANGED_ON_DT	TIMESTAMP		6
AUX2_CHANGED_ON_DT	TIMESTAMP		6
AUX3_CHANGED_ON_DT	TIMESTAMP		6
AUX4_CHANGED_ON_DT	TIMESTAMP		6
BALANCING_SEGMENT_WID	NUMBER		38			DW_EB_X_EBS_COMMON_W_BALANCING_SEGMENT_D
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			ENABLED_FLG
ETL_PROC_WID	NUMBER		38
FIXED_HIER_LEVEL	NUMBER		10
HIERARCHY_ID	VARCHAR2	100 CHAR
HIERARCHY_LOV_ID	VARCHAR2	100 CHAR
HIERARCHY_VERSION	VARCHAR2	100 CHAR
HIERARCHY_VERSION_NAME	VARCHAR2	100 CHAR			HIERARCHY_VERSION_NAME
INTEGRATION_ID	VARCHAR2	400 CHAR
LEVEL0_CODE	VARCHAR2	150 CHAR			LEVEL0_CODE
LEVEL0_INTEGRATION_ID	VARCHAR2	400 CHAR			LEVEL0_INTEGRATION_ID
LEVEL0_SECURITY_ID	VARCHAR2	400 CHAR			LEVEL0_SECURITY_ID
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