DW_EB_X_EBS_PROJECTS_W_PROJ_STATUS_QTR_SNP_F
No table description is available in the supplied metadata.
Details
Module: Projects (EBS_PROJECTS)
Key Columns
Key column information is not documented in the supplied metadata.
Columns
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table |
|---|---|---|---|---|---|---|
| ROW_WID | NUMBER | 38 | True | ROW_WID | ||
| ACTUAL_END_DT | TIMESTAMP | 6 | ACTUAL_END_DT | |||
| ACTUAL_START_DT | TIMESTAMP | 6 | ACTUAL_START_DT | |||
| AUX1_CHANGED_ON_DT | TIMESTAMP | 6 | AUX1_CHANGED_ON_DT | |||
| AUX2_CHANGED_ON_DT | TIMESTAMP | 6 | AUX2_CHANGED_ON_DT | |||
| AUX3_CHANGED_ON_DT | TIMESTAMP | 6 | AUX3_CHANGED_ON_DT | |||
| AUX4_CHANGED_ON_DT | TIMESTAMP | 6 | AUX4_CHANGED_ON_DT | |||
| CHANGED_BY_WID | NUMBER | 38 | CHANGED_BY_WID | |||
| CHANGED_ON_DT | TIMESTAMP | 6 | CHANGED_ON_DT | |||
| COMPLETED_PERCENT | NUMBER | COMPLETED_PERCENT | ||||
| CONTRACT_HDR_WID | NUMBER | 38 | ||||
| CONTRACT_LINE_WID | NUMBER | 38 | ||||
| CREATED_BY_WID | NUMBER | 38 | CREATED_BY_WID | |||
| CREATED_ON_DT | TIMESTAMP | 6 | CREATED_ON_DT | |||
| DATASOURCE_NUM_ID | NUMBER | 10 | DATASOURCE_NUM_ID | |||
| DELETE_FLG | VARCHAR2 | 1 CHAR | DELETE_FLG | |||
| DESCRIPTION | VARCHAR2 | 250 CHAR | DESCRIPTION | |||
| EFFECTIVE_FROM_DT | TIMESTAMP | 6 | EFFECTIVE_FROM_DT | |||
| EFFECTIVE_TO_DT | TIMESTAMP | 6 | EFFECTIVE_TO_DT | |||
| ESTIMATED_END_DT | TIMESTAMP | 6 | ESTIMATED_END_DT | |||
| ESTIMATED_START_DT | TIMESTAMP | 6 | ESTIMATED_START_DT | |||
| ETL_PROC_WID | NUMBER | 38 | ETL_PROC_WID | |||
| GL_ACCOUNTING_DT_WID | NUMBER | 38 | GL_ACCOUNTING_DT_WID | |||
| GL_MCAL_CAL_WID | NUMBER | 38 | GL_MCAL_CAL_WID | |||
| INTEGRATION_ID | VARCHAR2 | 80 CHAR | INTEGRATION_ID | |||
| PROGRESS_STATUS_CODE | VARCHAR2 | 80 CHAR | PROGRESS_STATUS_CODE | |||
| PROJECT_OR_TASK_ID | VARCHAR2 | 80 CHAR | PROJECT_OR_TASK_ID | |||
| PROJECT_WID | NUMBER | 38 | PROJECT_WID | |||
| PROJ_BU_WID | NUMBER | 38 | PROJ_BU_WID | |||
| PROJ_MANAGER_WID | NUMBER | 38 | PROJ_MANAGER_WID | |||
| PROJ_ORGANIZATION_WID | NUMBER | 38 | PROJ_ORGANIZATION_WID | |||
| PROJ_PR_CUSTOMER_ACCOUNT_WID | NUMBER | 38 | PROJ_PR_CUSTOMER_ACCOUNT_ WID | |||
| PROJ_PR_CUSTOMER_WID | NUMBER | 38 | PROJ_PR_CUSTOMER_WID | |||
| PROJ_STATUS_WID | NUMBER | 38 | PROJ_STATUS_WID | |||
| SNAPSHOT_DT_WID | NUMBER | 38 | SNAPSHOT_DT_WID | |||
| TASK_WID | NUMBER | 38 | TASK_WID | |||
| TENANT_ID | VARCHAR2 | 80 CHAR | TENANT_ID | |||
| W_ROW_TYPE | VARCHAR2 | 10 CHAR | W_ROW_TYPE | |||
| X_CUSTOM | VARCHAR2 | 10 CHAR | X_CUSTOM | |||
| W$_INSERT_DT | TIMESTAMP | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 6 |