| BANKING Data Model |
Description | Geographic Area identifies a place or a bounded area that is defined by nature, by an external authority, such as a government, or for an internal business purpose. |
Primary Key | |
![]() |
Indexes | |
![]() |
Column Details |
Description | The unique identifier of the Geographic Area Dimension. |
Data Type | BIGINT |
Default Value | None |
Is Primary Key | true |
Is Identity | true |
Is Nullable | false |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | Country indicates the name of the country where the Geographic Area is located. |
Data Type | VARCHAR(50) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | Country Row indicates whether or not this row represents a Country in the hierarchy of Geographic Area. |
Data Type | CHAR(10) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | Region indicates the name of the region (depending on the country, this could be the state, province or county) where the Geographic Area is located. |
Data Type | VARCHAR(50) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | Region Row indicates whether or not this row represents a Region in the hierarchy of Geographic Area. |
Data Type | CHAR(10) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | City indicates the name of the city where the Geographic Area is located. |
Data Type | VARCHAR(50) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | City row indicates whether or not this row represents a City in the hierarchy of Geographic Area. |
Data Type | CHAR(10) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | Common Name indicates a Geographic Area Name that is a label used in a usual or widespread manner, when different from a country, a region, or a city. In case of country, region or city, the Common Name is held by the Country, Region and City attributes respectively. |
Data Type | VARCHAR(50) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | Official Name indicates a Geographic Area Name that is a properly authorized label. |
Data Type | VARCHAR(50) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | Geographic Area Code indicates a short code associated with the Geographic Area e.g. 'PA' for Pennsylvania. |
Data Type | CHAR(10) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | Internal Identification indicates an internally generated number or code by which a Geographic Area can be identified. |
Data Type | BIGINT |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | Description indicates a textual explanation or free form comments about the Geographic Area. |
Data Type | VARCHAR(2000) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | Spatial X Coordinate indicates the value on the X-axis in the Spatial Coordinate System used to locate the Geographic Area. For example, it may represent the latitude, which defines an east-west line on the earths surface which shows degrees north or south of the equator that the Geographic Area lies upon. |
Data Type | CHAR(10) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | Spatial Y Coordinate indicates the value on the Y-axis in the Spatial Coordinate System used to locate the Geographic Area. For example, it may represent the longitude, which defines a line on the earths surface which the Geographic Area lies upon showing degrees east or west of the Greenwich meridian.e.g. GCS-DMS: 45d21m15s N 122d17m54s W (GCS: Geographic Coordinate System, DMS: Degree-Minutes-Seconds notation)e.g. USNG: 15SWC8083350993 (USNG: United States National Grid)e.g. UTM: 580817mE, 4251205mN (UTM: Universal Transverse Mercator) |
Data Type | CHAR(10) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | Spatial Z Coordinate indicates the value on the Z-axis in the Spatial Coordinate System used to locate the Geographic Area. For example, it may represent the altitude of the Geographic Area. |
Data Type | CHAR(10) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | Anchor Id indicates any value without business meaning that uniquely distinguishes occurrences of this entity independently of its history. |
Data Type | INTEGER |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | Current Row Indicator indicates whether or not, among the different versions of this dimension, this row holds the values that are currently valid in the business reality. This indicator enables the current values of the dimension to be retrieved quickly. |
Data Type | INTEGER |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | Effective From Date indicates the effective date and time that represents the beginning of the time period during which the values of all attributes of the entity occurrence are true in the business reality. |
Data Type | DATE |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | Effective To Date indicates the effective date and time that represents the end of the time period during which the values of all attributes of the entity occurrence are true in the business reality. |
Data Type | DATE |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | Valid From Date indicates the transaction time that represents the beginning of the time period during which the values of this recorded data are true in the source system. |
Data Type | DATE |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | Valid To Date indicates the transaction time that represents the end of the time period during which the values of this recorded data are true in the source system. |
Data Type | DATE |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Primary Key Details |
Member | GEOGRAPHIC_AREA_DIMENSION_ID [BIGINT] |
Index Details |
Is Unique | true |
Is Clustered | false |
Member | GEOGRAPHIC_AREA_DIMENSION_ID [BIGINT] Ascending |
| BANKING Data Model |