DW_EB_X_EBS_COMMON_W_GEO_COUNTRY_D
DW_EB_X_EBS_COMMON_W_GEO_COUNTRY_D Dimension table contains the 2-letter ISO Country Code, ISO Country Name, 3-letter ISO Country Code, ISO Numeric Country Code, and the NLS Terrirory for each Country.
Details
Module: Common Tables (EBS_COMMON)
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 | Surrogate key to uniquely identify a record. | ||
| AUX1_CHANGED_ON_DT | TIMESTAMP | 6 | System field. This column identifies the last modified date and time of the auxiliary table's record which acts as a source for the current table. | |||
| AUX2_CHANGED_ON_DT | TIMESTAMP | 6 | System field. This column identifies the last modified date and time of the auxiliary table's record which acts as a source for the current table. | |||
| AUX3_CHANGED_ON_DT | TIMESTAMP | 6 | System field. This column identifies the last modified date and time of the auxiliary table's record which acts as a source for the current table. | |||
| AUX4_CHANGED_ON_DT | TIMESTAMP | 6 | System field. This column identifies the last modified date and time of the auxiliary table's record which acts as a source for the current table. | |||
| CHANGED_BY_WID | NUMBER | 38 | This is a foreign key to the DW_EB_X_EBS_COMMON_W_USER_D dimension indicating the user who last modified the record in the source system. | |||
| CHANGED_ON_DT | TIMESTAMP | 6 | Identifies the date and time when the record was last modified in the source system. | |||
| CREATED_BY_WID | NUMBER | 38 | This is a foreign key to the DW_EB_X_EBS_COMMON_W_USER_D dimension indicating the user who created the record in the source system. | |||
| CREATED_ON_DT | TIMESTAMP | 6 | Identifies the date and time when the record was initially created in the source system. | |||
| DELETE_FLG | VARCHAR2 | 1 CHAR | This flag indicates the deletion status of the record in the source system. A value of "Y" indicates that the record is deleted from the source system and logically deleted from the data warehouse; a value of "N" indicates that the record is active. | |||
| ISO_ALPHA3_CODE | VARCHAR2 | 3 CHAR | Identifies the ISO Standardized 3- letter Country Code generated from the United Nations web page. | |||
| ISO_COUNTRY_CODE | VARCHAR2 | 2 CHAR | Identifies the ISO Standardized 2- letter Country Code generated from the United Nations web page. | |||
| ISO_COUNTRY_NAME | VARCHAR2 | 255 CHAR | Identifies the ISO Standardized Country Name generated from the United Nations web page. | |||
| ISO_NUMERICAL_CODE | VARCHAR2 | 3 CHAR | Identifies the ISO Standardized Numerical Country Code generated from the United Nations web page. | |||
| NLS_TERRITORY | VARCHAR2 | 30 CHAR | Identifies the NLS Territory for each country | |||
| W_COUNTRY_CODE | VARCHAR2 | 50 CHAR | Identifies the Country Code cleansed from the data warehouse domain W_COUNTRY. | |||
| X_CUSTOM | VARCHAR2 | 10 CHAR | This column is used as a generic field for customer extensions. | |||
| W$_INSERT_DT | TIMESTAMP | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 6 |