DW_EB_X_EBS_PROJECTS_W_EMP_COMPETENCY_F
Employee competencies Fact table stores details of all employee competencies
Details
Module: Projects (EBS_PROJECTS)
Business Name: Employee Competencies Fact
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 | System generated row 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 | |||
| 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_WID | NUMBER | 38 | competancy wid | DW_EB_X_EBS_PROJECTS_W_PROJ_COMPETENCY_D | ||
| 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 | |||
| CURRENT_FLG | VARCHAR2 | 1 CHAR | current flag | |||
| DATASOURCE_NUM_ID | NUMBER | 10 | Datasource Num Id | |||
| DELETE_FLG | VARCHAR2 | 1 CHAR | Delete Flag | |||
| EFFECTIVE_FROM_DT | TIMESTAMP | 6 | effective from date | |||
| EFFECTIVE_TO_DT | TIMESTAMP | 6 | effective to date | |||
| EMP_WID | NUMBER | 38 | employee wid | DW_EB_X_EBS_COMMON_W_EMPLOYEE_D | ||
| ETL_PROC_WID | NUMBER | 38 | ETL Process Identifier | |||
| INTEGRATION_ID | VARCHAR2 | 80 CHAR | Integration Id | |||
| PROFICIENCY_WID | NUMBER | 38 | rating level | DW_EB_X_EBS_PROJECTS_W_COMPETENCY_RATING_D | ||
| 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 |