DW_EB_X_EBS_COMMON_W_PROJECT_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	Not Null	Referred Table
ROW_WID	NUMBER		38	True
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
CAPITAL_COST_TYPE_CODE	VARCHAR2	50 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
CITY	VARCHAR2	80 CHAR
CLOSE_DT	TIMESTAMP		6
COMPLETION_DT	TIMESTAMP		6
CONTRACT_HDR_ID	VARCHAR2	80 CHAR
CONTRACT_LINE_ID	VARCHAR2	80 CHAR
COUNTRY	VARCHAR2	80 CHAR
CREATED_BY_WID	NUMBER		38		DW_EB_X_EBS_COMMON_W_USER_D
CREATED_ON_DT	TIMESTAMP		6
DATASOURCE_NUM_ID	NUMBER		10
DELETE_FLG	VARCHAR2	1 CHAR
DIM_LEDGER_ID	VARCHAR2	80 CHAR
ENABLE_BILLABLE_FLG	VARCHAR2	1 CHAR
ENABLE_CAPITALIZATION_FLG	VARCHAR2	1 CHAR
ETL_PROC_WID	NUMBER		38
FUNDING_APPROVAL_STATUS_CODE	VARCHAR2	50 CHAR
FUNDING_APPROVAL_STATUS_NAME	VARCHAR2	255 CHAR
INCLUDE_GAINS_LOSSES_FLG	VARCHAR2	1 CHAR
INTEGRATION_ID	VARCHAR2	80 CHAR
INVOICE_BILL_OFFSET_NUM_DAYS	NUMBER		15
INVOICE_METHOD	VARCHAR2	30 CHAR
LEDGER_ID	VARCHAR2	80 CHAR
LOC_CURRENCY_CODE	VARCHAR2	50 CHAR
OPERATING_UNIT_ORG_ID	VARCHAR2	80 CHAR
PRIORITY_CODE	VARCHAR2	50 CHAR
PRIORITY_NAME	VARCHAR2	255 CHAR
PROJECT_CURRENCY_CODE	VARCHAR2	50 CHAR
PROJECT_DESC	VARCHAR2	250 CHAR
PROJECT_NAME	VARCHAR2	240 CHAR
PROJECT_NUMBER	VARCHAR2	30 CHAR
PROJECT_SERVICE_TYPE_CODE	VARCHAR2	50 CHAR
PROJECT_SERVICE_TYPE_NAME	VARCHAR2	255 CHAR
PROJECT_STATUS_CODE	VARCHAR2	50 CHAR
PROJECT_STATUS_NAME	VARCHAR2	255 CHAR
PROJECT_TYPE_CLASS_CODE	VARCHAR2	50 CHAR
PROJECT_TYPE_CLASS_NAME	VARCHAR2	255 CHAR
PROJECT_TYPE_CODE	VARCHAR2	50 CHAR
PROJECT_TYPE_NAME	VARCHAR2	250 CHAR
PROJECT_UNIT_ID	VARCHAR2	80 CHAR
PROJECT_VALUE	NUMBER		22
PROJ_MGR_ID	VARCHAR2	80 CHAR
PROJ_MGR_NAME	VARCHAR2	160 CHAR
PROJ_OPERATING_UNIT_ID	VARCHAR2	80 CHAR
PROJ_ORGANIZATION_ID	VARCHAR2	80 CHAR
PROJ_ORGANIZATION_NAME	VARCHAR2	100 CHAR
PROJ_PR_CUSTOMER_ACCOUNT_ID	VARCHAR2	80 CHAR
PROJ_PR_CUSTOMER_ID	VARCHAR2	80 CHAR
PUBLIC_SECTOR_FLG	VARCHAR2	1 CHAR
REGION	VARCHAR2	240 CHAR
REVALUATE_FUNDING_FLG	VARCHAR2	1 CHAR
REVENUE_ACCRUAL_METHOD	VARCHAR2	30 CHAR
SECURITY_LEVEL_CODE	VARCHAR2	50 CHAR
SECURITY_LEVEL_NAME	VARCHAR2	255 CHAR
START_DT	TIMESTAMP		6
TENANT_ID	VARCHAR2	80 CHAR
TOP_TASK_INVOICE_METHOD_FLG	VARCHAR2	1 CHAR
W_PRIORITY_CODE	VARCHAR2	50 CHAR
W_PROJECT_FUNDING_LEVEL_CODE	VARCHAR2	50 CHAR
W_PROJECT_FUNDING_LEVEL_NAME	VARCHAR2	80 CHAR
W_PROJECT_SERVICE_TYPE_CODE	VARCHAR2	50 CHAR
W_PROJECT_STATUS_CODE	VARCHAR2	50 CHAR
W_PROJECT_TYPE_CLASS_CODE	VARCHAR2	50 CHAR
W_PROJECT_TYPE_CLASS_NAME	VARCHAR2	80 CHAR
W_PROJECT_TYPE_CODE	VARCHAR2	50 CHAR
W_SECURITY_LEVEL	VARCHAR2	255 CHAR
X_CUSTOM	VARCHAR2	10 CHAR
ZIPCODE	VARCHAR2	30 CHAR
W$_INSERT_DT	TIMESTAMP		6
W$_UPDATE_DT	TIMESTAMP		6