DW_EB_X_EBS_PROJECTS_W_AWARD_D
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 | ||
| 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 | |||
| AWARD_APPRV_DT | TIMESTAMP | 6 | AWARD_APPRV_DT | |||
| AWARD_BEGIN_DT | TIMESTAMP | 6 | AWARD_BEGIN_DT | |||
| AWARD_BU_ID | VARCHAR2 | 80 CHAR | AWARD_BU_ID | |||
| AWARD_DT | TIMESTAMP | 6 | AWARD_DT | |||
| AWARD_END_DT | TIMESTAMP | 6 | AWARD_END_DT | |||
| AWARD_PURPOSE_CODE | VARCHAR2 | 80 CHAR | AWARD_PURPOSE_CODE | |||
| AWARD_STATUS | VARCHAR2 | 80 CHAR | AWARD_STATUS | |||
| AWARD_TYPE | VARCHAR2 | 80 CHAR | AWARD_TYPE | |||
| CFDA_NUM | VARCHAR2 | 80 CHAR | CFDA_NUM | |||
| CHANGED_BY_WID | NUMBER | 38 | CHANGED_BY_WID | DW_EB_X_EBS_COMMON_W_USER_D | ||
| CHANGED_ON_DT | TIMESTAMP | 6 | CHANGED_ON_DT | |||
| CONTRACT_NUM | VARCHAR2 | 80 CHAR | CONTRACT_NUM | |||
| COST_SHARE_FLG | VARCHAR2 | 1 CHAR | ||||
| COST_SHR_SPNSR_REQ | VARCHAR2 | 80 CHAR | COST_SHR_SPNSR_REQ | |||
| CREATED_BY_WID | NUMBER | 38 | CREATED_BY_WID | DW_EB_X_EBS_COMMON_W_USER_D | ||
| CREATED_ON_DT | TIMESTAMP | 6 | CREATED_ON_DT | |||
| CUST_ID | VARCHAR2 | 80 CHAR | CUST_ID | |||
| DATASOURCE_NUM_ID | NUMBER | 10 | DATASOURCE_NUM_ID | |||
| DELETE_FLG | VARCHAR2 | 1 CHAR | DELETE_FLG | |||
| EMP_ID | VARCHAR2 | 80 CHAR | EMPLID | |||
| ETL_PROC_WID | NUMBER | 38 | ETL_PROC_WID | |||
| GM_DEPT_CR_LVL | VARCHAR2 | 80 CHAR | GM_DEPT_CR_LVL | |||
| INSTN_ID | VARCHAR2 | 80 CHAR | INSTN_ID | |||
| INTEGRATION_ID | VARCHAR2 | 80 CHAR | INTEGRATION_ID | |||
| PROPOSAL_RFP_REF | VARCHAR2 | 80 CHAR | PROPOSAL_RFP_REF | |||
| REF_AWARD_NUM | VARCHAR2 | 80 CHAR | REF_AWARD_NUM | |||
| SOLICITATION_TITLE | VARCHAR2 | 80 CHAR | SOLICITATION_TITLE | |||
| SPNSR_AWARD_NUM | VARCHAR2 | 80 CHAR | ||||
| TENANT_ID | VARCHAR2 | 80 CHAR | TENANT_ID | |||
| X_CUSTOM | VARCHAR2 | 10 CHAR | X_CUSTOM | |||
| W$_INSERT_DT | TIMESTAMP | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 6 |