DW_EB_X_EBS_PROJECTS_W_PROJ_COMPETENCY_D_TL
Stores language-specific names and descriptions for project competencies.
Details
Module: Projects (EBS_PROJECTS)
Business Name: Project Competency Translation 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 | Identifier of the source system from which the record was extracted. | |||
| INTEGRATION_ID | VARCHAR2 | 80 CHAR | Unique identifier of the record in the source system; it may contain concatenated values for composite keys. | |||
| LANGUAGE_CODE | VARCHAR2 | 4 CHAR | Code identifying the language in which translated attributes are stored. | |||
| SOURCE_RECORD_ID | VARCHAR2 | 124 CHAR | Identifier of the record in the source system. | |||
| AUX1_CHANGED_ON_DT | TIMESTAMP | 6 | Last modification date and time of auxiliary source record 1 used by the ETL process. | |||
| AUX2_CHANGED_ON_DT | TIMESTAMP | 6 | Last modification date and time of auxiliary source record 2 used by the ETL process. | |||
| AUX3_CHANGED_ON_DT | TIMESTAMP | 6 | Last modification date and time of auxiliary source record 3 used by the ETL process. | |||
| AUX4_CHANGED_ON_DT | TIMESTAMP | 6 | Last modification date and time of auxiliary source record 4 used by the ETL process. | |||
| CHANGED_BY_ID | VARCHAR2 | 80 CHAR | Identifier of the user or process that last changed the record. | |||
| CHANGED_ON_DT | TIMESTAMP | 6 | Date and time when the record was last changed. | |||
| COMPETENCY_DESCR | VARCHAR2 | 2000 CHAR | ||||
| COMPETENCY_NAME | VARCHAR2 | 700 CHAR | ||||
| CREATED_BY_ID | VARCHAR2 | 80 CHAR | Identifier of the user or process that created the record. | |||
| CREATED_ON_DT | TIMESTAMP | 6 | Date and time when the record was created. | |||
| DELETE_FLG | VARCHAR2 | 1 CHAR | ||||
| ETL_PROC_WID | NUMBER | 38 | Warehouse identifier of the ETL process that loaded the record. | |||
| ROW_WID | NUMBER | 38 | Warehouse-generated surrogate key that uniquely identifies the record. | |||
| SRC_LANGUAGE_CODE | VARCHAR2 | 4 CHAR | Code identifying the original language of the source record. | |||
| TENANT_ID | VARCHAR2 | 80 CHAR | Identifier of the tenant associated with the record. | |||
| X_CUSTOM | VARCHAR2 | 10 CHAR | Generic Extension Column |