DW_EB_X_EBS_PROJECTS_W_PROJ_COMPETENCY_D
Dimension table stores details of all project competencies
Details
Module: Projects (EBS_PROJECTS)
Business Name: Project Competency Dimension
Key Columns
Key column information is not documented in the supplied metadata.
Columns
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table |
|---|---|---|---|---|---|---|
| DATASOURCE_NUM_ID | NUMBER | 10 | Datasource Num Id | |||
| INTEGRATION_ID | VARCHAR2 | 80 CHAR | Integration Id | |||
| AUX1_CHANGED_ON_DT | TIMESTAMP | 6 | Auxiliary 1 Changed on Date | |||
| AUX2_CHANGED_ON_DT | TIMESTAMP | 6 | Auxiliary 2 Changed on Date | |||
| AUX3_CHANGED_ON_DT | TIMESTAMP | 6 | Auxiliary 3 Changed on Date | |||
| AUX4_CHANGED_ON_DT | TIMESTAMP | 6 | Auxiliary 4 Changed on Date | |||
| CERTIFICATION_REQUIRED_FLG | VARCHAR2 | 1 CHAR | certification required flag | |||
| CHANGED_BY_WID | NUMBER | 38 | OLTP user who last updated the transaction | DW_EB_X_EBS_COMMON_W_USER_D | ||
| CHANGED_ON_DT | TIMESTAMP | 6 | OLTP last update date of the transaction | |||
| COMPETENCY_GROUP | VARCHAR2 | 255 CHAR | competancy group | |||
| COMPETENCY_GROUP_ID | VARCHAR2 | 80 CHAR | competancy group id | |||
| CREATED_BY_WID | NUMBER | 38 | OLTP user who created the transaction | DW_EB_X_EBS_COMMON_W_USER_D | ||
| CREATED_ON_DT | TIMESTAMP | 6 | OLTP creation date of the transaction | |||
| DELETE_FLG | VARCHAR2 | 1 CHAR | Delete Flag | |||
| END_DATE | TIMESTAMP | 6 | To date | |||
| ETL_PROC_WID | NUMBER | 38 | ETL Process Identifier | |||
| MAX_LEVEL | VARCHAR2 | 30 CHAR | Max level | |||
| MIN_LEVEL | VARCHAR2 | 30 CHAR | Min Level | |||
| ROW_WID | NUMBER | 38 | System generated row id | |||
| START_DATE | TIMESTAMP | 6 | From date | |||
| TENANT_ID | VARCHAR2 | 80 CHAR | Tenant Id | |||
| X_CUSTOM | VARCHAR2 | 10 CHAR | Generic Extension Column | |||
| W$_INSERT_DT | TIMESTAMP | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 6 |