DW_EB_X_EBS_COMMON_W_GEO_D
Geography dimensions are used as rollup dimension for holding the aggregate data at different levels. Each business analytics may have different aggregate requirements of storing pre-aggregated data at different levels of details. The rollup dimensions thus are available at the different levelsThe source of the data for geography dimensions are mainly coming from the various address and location table in the OLTP systems. The address tables include the address components for describing the postal addresses for mailing, delivering, shipping, or locating the customers and down to the street and specific number. The location table describes the logical sites or location recognized by the deploying company for various purposes, such as receiving docks, employee or property assignments, etc. A location may have the address components but may not have a complete address and include the high level physical location components such as country, state, city.
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. | |||
| CITY_CODE | VARCHAR2 | 120 CHAR | Identifies the source city code in source system. | |||
| CONTINENT_CODE | VARCHAR2 | 120 CHAR | Identifies the source continent code in source system. | |||
| COUNTRY_REGION_CODE | VARCHAR2 | 120 CHAR | Identifies the source country region code in source system. | |||
| COUNTY_CODE | VARCHAR2 | 120 CHAR | Identifies the source county code in 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. | |||
| C_CITY_CODE | VARCHAR2 | 120 CHAR | Identifies the customer conformed city domain code. | |||
| C_CONTINENT_CODE | VARCHAR2 | 120 CHAR | Identifies the customer conformed continent domain code. | |||
| C_COUNTRY_REGION_CODE | VARCHAR2 | 120 CHAR | Identifies the customer conformed country region domain code. Country region is the geography district below country and above state/province. | |||
| C_COUNTY_CODE | VARCHAR2 | 120 CHAR | Identifies the customer conformed county domain code. | |||
| C_REGION_CODE | VARCHAR2 | 120 CHAR | Identifies the customer conformed region domain code. | |||
| C_STATE_PROV_CODE | VARCHAR2 | 240 CHAR | Identifies the customer conformed state or province domain code. | |||
| DATASOURCE_NUM_ID | NUMBER | 10 | This column is the unique identifier of the source system from which data was extracted. In order to be able to trace the data back to its source, Oracle recommends that you define separate unique source IDs for each of your different source instances. | |||
| 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. | |||
| DUP_ZIPCODE | VARCHAR2 | 30 CHAR | Identifies if a duplicate zipcode. | |||
| END_DT | TIMESTAMP | 6 | ||||
| ETL_PROC_WID | NUMBER | 38 | System Field. This column is the unique identifier for the specific ETL process used to create or update this data. | |||
| GEO_COUNTRY_WID | NUMBER | 38 | Foreign key to the base dimension DW_EB_X_EBS_COMMON_W_GEO_COUNTRY_D. | DW_EB_X_EBS_COMMON_W_GEO_COUNTRY_D | ||
| GEO_ID | VARCHAR2 | 80 CHAR | Unique identifier for the geography in source system | |||
| INTEGRATION_ID | VARCHAR2 | 480 CHAR | This column is the unique identifier of a dimension or fact entity in its source system. In case of composite keys, the value in this column can consist of concatenated parts. | |||
| POSTAL_CODE | VARCHAR2 | 120 CHAR | Identifies postal code. | |||
| REGION_CODE | VARCHAR2 | 120 CHAR | Identifies the source region code in source system. | |||
| STATE_PROV_CODE | VARCHAR2 | 240 CHAR | Identifies the source state or province code in source system. | |||
| TENANT_ID | VARCHAR2 | 80 CHAR | This column is the unique identifier for a Tenant in a multi-tenant environment. This would typically be used in an Application Service Provider (ASP) / Software As a Service (SOAS) model. | |||
| W_COUNTRY_CODE | VARCHAR2 | 120 CHAR | Identifies the data warehouse conformed country domain code. | |||
| 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 |