DW_EB_X_EBS_PROJECTS_W_PROJ_RQMNT_COMPETENCY_H
Bridge table stores details of all requirement competencies
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 |
|---|---|---|---|---|---|---|
| COMPETENCY_ID | VARCHAR2 | 80 CHAR | Competancy Id | |||
| RQMNT_ID | VARCHAR2 | 80 CHAR | Requirement id | |||
| CHANGED_ON_DT | TIMESTAMP | 6 | OLTP last update date of the transaction | |||
| DATASOURCE_NUM_ID | NUMBER | 10 | Datasource Num Id | |||
| INTEGRATION_ID | VARCHAR2 | 80 CHAR | Integration Id | |||
| MANDATORY_FLG | VARCHAR2 | 1 CHAR | mandatory Flag | |||
| RATING_LEVEL | VARCHAR2 | 10 CHAR | Rating Level | |||
| TENANT_ID | VARCHAR2 | 80 CHAR | Tenant Id | |||
| X_CUSTOM | VARCHAR2 | 10 CHAR | Generic Extension Column | |||
| YEARS_EXP | NUMBER | 10 | ||||
| W$_INSERT_DT | TIMESTAMP | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 6 |