DW_EB_X_EBS_COMMON_W_TASK_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	Referred Table
BASE_INTEGRATION_ID	VARCHAR2	80 CHAR
DATASOURCE_NUM_ID	NUMBER		10
STRUCTURE_ID	VARCHAR2	80 CHAR
BASE_TASK_NAME	VARCHAR2	240 CHAR
BASE_TASK_NUMBER	VARCHAR2	25 CHAR
BASE_WBS_LEVEL	NUMBER		10
BASE_WBS_NUMBER	VARCHAR2	240 CHAR
CHANGED_BY_WID	NUMBER		38
CHANGED_ON_DT	TIMESTAMP		6
CREATED_BY_WID	NUMBER		38
CREATED_ON_DT	TIMESTAMP		6
ETL_PROC_WID	NUMBER		38
FIXED_HIER_LEVEL	NUMBER		10
LVL10_INTEGRATION_ID	VARCHAR2	80 CHAR
LVL10_TASK_NAME	VARCHAR2	240 CHAR
LVL10_TASK_NUMBER	VARCHAR2	25 CHAR
LVL10_WBS_LEVEL	NUMBER		10
LVL10_WBS_NUMBER	VARCHAR2	240 CHAR
LVL11_INTEGRATION_ID	VARCHAR2	80 CHAR
LVL11_TASK_NAME	VARCHAR2	240 CHAR
LVL11_TASK_NUMBER	VARCHAR2	25 CHAR
LVL11_WBS_LEVEL	NUMBER		10
LVL11_WBS_NUMBER	VARCHAR2	240 CHAR
LVL12_INTEGRATION_ID	VARCHAR2	80 CHAR
LVL12_TASK_NAME	VARCHAR2	240 CHAR
LVL12_TASK_NUMBER	VARCHAR2	25 CHAR
LVL12_WBS_LEVEL	NUMBER		10
LVL12_WBS_NUMBER	VARCHAR2	240 CHAR
LVL13_INTEGRATION_ID	VARCHAR2	80 CHAR
LVL13_TASK_NAME	VARCHAR2	240 CHAR
LVL13_TASK_NUMBER	VARCHAR2	25 CHAR
LVL13_WBS_LEVEL	NUMBER		10
LVL13_WBS_NUMBER	VARCHAR2	240 CHAR
LVL14_INTEGRATION_ID	VARCHAR2	80 CHAR
LVL14_TASK_NAME	VARCHAR2	240 CHAR
LVL14_TASK_NUMBER	VARCHAR2	25 CHAR
LVL14_WBS_LEVEL	NUMBER		10
LVL14_WBS_NUMBER	VARCHAR2	240 CHAR
LVL15_INTEGRATION_ID	VARCHAR2	80 CHAR
LVL15_TASK_NAME	VARCHAR2	240 CHAR
LVL15_TASK_NUMBER	VARCHAR2	25 CHAR
LVL15_WBS_LEVEL	NUMBER		10
LVL15_WBS_NUMBER	VARCHAR2	240 CHAR
LVL16_INTEGRATION_ID	VARCHAR2	80 CHAR
LVL16_TASK_NAME	VARCHAR2	240 CHAR
LVL16_TASK_NUMBER	VARCHAR2	25 CHAR
LVL16_WBS_LEVEL	NUMBER		10
LVL16_WBS_NUMBER	VARCHAR2	240 CHAR
LVL17_INTEGRATION_ID	VARCHAR2	80 CHAR
LVL17_TASK_NAME	VARCHAR2	240 CHAR
LVL17_TASK_NUMBER	VARCHAR2	25 CHAR
LVL17_WBS_LEVEL	NUMBER		10
LVL17_WBS_NUMBER	VARCHAR2	240 CHAR
LVL18_INTEGRATION_ID	VARCHAR2	80 CHAR
LVL18_TASK_NAME	VARCHAR2	240 CHAR
LVL18_TASK_NUMBER	VARCHAR2	25 CHAR
LVL18_WBS_LEVEL	NUMBER		10
LVL18_WBS_NUMBER	VARCHAR2	240 CHAR
LVL1_INTEGRATION_ID	VARCHAR2	80 CHAR
LVL1_TASK_NAME	VARCHAR2	240 CHAR
LVL1_TASK_NUMBER	VARCHAR2	25 CHAR
LVL1_WBS_LEVEL	NUMBER		10
LVL1_WBS_NUMBER	VARCHAR2	240 CHAR
LVL2_INTEGRATION_ID	VARCHAR2	80 CHAR
LVL2_TASK_NAME	VARCHAR2	240 CHAR
LVL2_TASK_NUMBER	VARCHAR2	25 CHAR
LVL2_WBS_LEVEL	NUMBER		10
LVL2_WBS_NUMBER	VARCHAR2	240 CHAR
LVL3_INTEGRATION_ID	VARCHAR2	80 CHAR
LVL3_TASK_NAME	VARCHAR2	240 CHAR
LVL3_TASK_NUMBER	VARCHAR2	25 CHAR
LVL3_WBS_LEVEL	NUMBER		10
LVL3_WBS_NUMBER	VARCHAR2	240 CHAR
LVL4_INTEGRATION_ID	VARCHAR2	80 CHAR
LVL4_TASK_NAME	VARCHAR2	240 CHAR
LVL4_TASK_NUMBER	VARCHAR2	25 CHAR
LVL4_WBS_LEVEL	NUMBER		10
LVL4_WBS_NUMBER	VARCHAR2	240 CHAR
LVL5_INTEGRATION_ID	VARCHAR2	80 CHAR
LVL5_TASK_NAME	VARCHAR2	240 CHAR
LVL5_TASK_NUMBER	VARCHAR2	25 CHAR
LVL5_WBS_LEVEL	NUMBER		10
LVL5_WBS_NUMBER	VARCHAR2	240 CHAR
LVL6_INTEGRATION_ID	VARCHAR2	80 CHAR
LVL6_TASK_NAME	VARCHAR2	240 CHAR
LVL6_TASK_NUMBER	VARCHAR2	25 CHAR
LVL6_WBS_LEVEL	NUMBER		10
LVL6_WBS_NUMBER	VARCHAR2	240 CHAR
LVL7_INTEGRATION_ID	VARCHAR2	80 CHAR
LVL7_TASK_NAME	VARCHAR2	240 CHAR
LVL7_TASK_NUMBER	VARCHAR2	25 CHAR
LVL7_WBS_LEVEL	NUMBER		10
LVL7_WBS_NUMBER	VARCHAR2	240 CHAR
LVL8_INTEGRATION_ID	VARCHAR2	80 CHAR
LVL8_TASK_NAME	VARCHAR2	240 CHAR
LVL8_TASK_NUMBER	VARCHAR2	25 CHAR
LVL8_WBS_LEVEL	NUMBER		10
LVL8_WBS_NUMBER	VARCHAR2	240 CHAR
LVL9_INTEGRATION_ID	VARCHAR2	80 CHAR
LVL9_TASK_NAME	VARCHAR2	240 CHAR
LVL9_TASK_NUMBER	VARCHAR2	25 CHAR
LVL9_WBS_LEVEL	NUMBER		10
LVL9_WBS_NUMBER	VARCHAR2	240 CHAR
ROW_WID	NUMBER		38	DW_EB_X_EBS_COMMON_W_TASK_D
TOPLVL_INTEGRATION_ID	VARCHAR2	80 CHAR
TOPLVL_TASK_NAME	VARCHAR2	240 CHAR
TOPLVL_TASK_NUMBER	VARCHAR2	25 CHAR
TOPLVL_WBS_LEVEL	NUMBER		10
TOPLVL_WBS_NUMBER	VARCHAR2	240 CHAR
TREE_CODE	VARCHAR2	80 CHAR
W$_INSERT_DT	TIMESTAMP		6
W$_UPDATE_DT	TIMESTAMP		6