DW_EB_X_EBS_COMMON_W_TASK_D

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
DATASOURCE_NUM_ID	NUMBER		10
INTEGRATION_ID	VARCHAR2	80 CHAR
ACTUAL_FINISH_DT	TIMESTAMP		6
ACTUAL_START_DT	TIMESTAMP		6
ALLOW_CROSS_CHARGE_FLG	VARCHAR2	1 CHAR
AUX1_CHANGED_ON_DT	TIMESTAMP		6
AUX2_CHANGED_ON_DT	TIMESTAMP		6
AUX3_CHANGED_ON_DT	TIMESTAMP		6
AUX4_CHANGED_ON_DT	TIMESTAMP		6
BILLABLE_FLG	VARCHAR2	1 CHAR
CAPITALIZABLE_FLG	VARCHAR2	1 CHAR
CC_PROCESS_LABOR_FLG	VARCHAR2	1 CHAR
CHANGED_BY_WID	NUMBER		38	DW_EB_X_EBS_COMMON_W_USER_D
CHANGED_ON_DT	TIMESTAMP		6
CHARGEABLE_FLG	VARCHAR2	1 CHAR
COMPLETION_DT	TIMESTAMP		6
CONTRACT_HDR_ID	VARCHAR2	80 CHAR
CONTRACT_LINE_ID	VARCHAR2	80 CHAR
CREATED_BY_WID	NUMBER		38	DW_EB_X_EBS_COMMON_W_USER_D
CREATED_ON_DT	TIMESTAMP		6
CRITICAL_FLG	VARCHAR2	1 CHAR
DELETE_FLG	VARCHAR2	1 CHAR
EARLY_FINISH_DT	TIMESTAMP		6
EARLY_START_DT	TIMESTAMP		6
ETL_PROC_WID	NUMBER		38
FINANCIAL_TASK_FLG	VARCHAR2	1 CHAR
INVOICE_METHOD	VARCHAR2	30 CHAR
LATE_FINISH_DT	TIMESTAMP		6
LATE_START_DT	TIMESTAMP		6
MILESTONE_FLG	VARCHAR2	1 CHAR
PARENT_TASK_ID	VARCHAR2	80 CHAR
PRIORITY_CODE	VARCHAR2	50 CHAR
PRIORITY_NAME	VARCHAR2	255 CHAR
PROJECT_ID	VARCHAR2	80 CHAR
REVENUE_ACCRUAL_METHOD	VARCHAR2	30 CHAR
ROW_WID	NUMBER		38
SCHEDULED_FINISH_DT	TIMESTAMP		6
SCHEDULED_START_DT	TIMESTAMP		6
SERVICE_TYPE_CODE	VARCHAR2	50 CHAR
SERVICE_TYPE_NAME	VARCHAR2	255 CHAR
START_DT	TIMESTAMP		6
STATUS_CODE	VARCHAR2	50 CHAR
STATUS_NAME	VARCHAR2	255 CHAR
TASK_DESC	VARCHAR2	250 CHAR
TASK_MANAGER_ID	VARCHAR2	80 CHAR
TASK_NAME	VARCHAR2	240 CHAR
TASK_NUMBER	VARCHAR2	100 CHAR
TASK_OWNING_ORGANIZATION_ID	VARCHAR2	80 CHAR
TASK_TYPE	VARCHAR2	150 CHAR
TASK_TYPE_NAME	VARCHAR2	255 CHAR
TENANT_ID	VARCHAR2	80 CHAR
TOP_TASK_ID	VARCHAR2	80 CHAR
WBS_LEVEL	NUMBER		3
WBS_NUMBER	VARCHAR2	240 CHAR
WORK_TYPE_ID	VARCHAR2	80 CHAR
X_CUSTOM	VARCHAR2	10 CHAR
W$_INSERT_DT	TIMESTAMP		6
W$_UPDATE_DT	TIMESTAMP		6