DW_EB_X_EBS_COMMON_W_BUSN_LOCATION_D_TL
Stores language-specific names and descriptions for business locations.
Details
Module: Common Tables (EBS_COMMON)
Business Name: Business Location Translation Dimension
Key Columns
Key column information is not documented in the supplied metadata.
Columns
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table |
|---|---|---|---|---|---|---|
| LANGUAGE_CODE | VARCHAR2 | 4 CHAR | Code identifying the language in which translated attributes are stored. | |||
| ROW_WID | NUMBER | 38 | Warehouse-generated surrogate key that uniquely identifies the record. | |||
| SOURCE_RECORD_ID | VARCHAR2 | 43 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. | |||
| BUSN_LOC_DESCR | VARCHAR2 | 1000 CHAR | ||||
| BUSN_LOC_NAME | VARCHAR2 | 255 CHAR | ||||
| 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. | |||
| 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. | |||
| DATASOURCE_NUM_ID | NUMBER | 10 | Identifier of the source system from which the record was extracted. | |||
| ETL_PROC_WID | NUMBER | 38 | Warehouse identifier of the ETL process that loaded the record. | |||
| INTEGRATION_ID | VARCHAR2 | 80 CHAR | Unique identifier of the record in the source system; it may contain concatenated values for composite keys. | |||
| 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 | This column is used as a generic field for customer extensions. |