| Insurance Data Model |
Description | Grouping of attributes used to perform analysis on instances of Geographic Area that share the same characteristics. |
Primary Key | |
![]() |
Column Details |
Description | The unique identifier of the Geographic Area Mini 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 | Address Type distinguishes between Addresses according to the nature and application of the Address.* Domain * Electronic Address Postal Address |
Data Type | VARCHAR(20) |
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 | Bankruptcy Rate Segment classifies Locations based on the failure of businesses in the area. For example, Less Than 5% Bankruptcy, 6% To 10% Bankruptcy, More Than 10% Bankruptcy. |
Data Type | VARCHAR(20) |
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 | The code of the country according to ISO 3166-1-alpha-2 code; for example:United States: USUnited Kingdom: GBIreland: IE |
Data Type | VARCHAR(20) |
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 | The telephonic country area code - a prefix required to dial a phone number in the country from abroad; for example:United States: 1United Kingdom: 44Ireland: 353 |
Data Type | VARCHAR(20) |
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 | Indicates whether or not the Country is a member of the European Union. |
Data Type | CHAR(1) |
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 | Electronic Address Type distinguishes between Electronic Addresses according to the nature and application of the Electronic Address.* Domain * Telephonic Address E-Mail Address Web Address |
Data Type | VARCHAR(20) |
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 Density Designation classifies Geographic Areas according to the number of people resident per unit of area.* Domain * Sparsely Populated Medium Density High Density |
Data Type | VARCHAR(20) |
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 Nature distinguishes between Geographic Areas according to the density, type and layout of buildings in the Area.* Domain * Rural Suburban Urban |
Data Type | VARCHAR(20) |
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 Type classifies a Geographic Area according to the purpose for which a geographic boundary has been identified; for example, 'Country', 'Region', 'Postcode Area', 'County', 'Time Zone', 'Municipality'.* Domain * City, State, County, Country, Census Area, Postcode area. |
Data Type | VARCHAR(20) |
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 | Inflation Rate Segment classifies Locations based on their inflation rate band. |
Data Type | VARCHAR(20) |
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 | Location Type distinguishes between Locations according to whether a Location is precisely identifiable by a specific address or is representative of an area that has boundaries drawn for various business or other purposes.* Domain * Address Geographic Area |
Data Type | VARCHAR(20) |
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 | Indicates that trading or engaging in any financial arrangement with a country is restricted. |
Data Type | CHAR(1) |
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 | Indicates whether or not the Country is suspected of engaging in activities that transgress international law, such as money laundering and supporting terrorist organizations. |
Data Type | CHAR(1) |
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 | Time Zone distinguishes between Geographic Areas according to their standard time relative to Universal Time Coordinated (UTC).* Domain * UTC - 12:00 UTC - 11:00 UTC - 10:00 (Hawaiian Time) UTC - 9:00 (Alaska Time) UTC - 8:00 (Pacific Time) UTC - 7:00 (Mountain Time) UTC - 6:00 (Central Time) UTC - 5:00 (Eastern Time) UTC - 4:00 (Atlantic Time) UTC - 3:30 (Newfoundland) UTC - 3:00 UTC - 2:00 (Mid-Atlantic Time) UTC - 1:00 UTC (Greenwich Mean Time, Western European Time) UTC + 1:00 (Central Europe Time) UTC + 2:00 (Eastern Europe Time) UTC + 3:00 (Moscow Time) UTC + 3:30 (Tehran) UTC + 4:00 UTC + 4:30 (Kabul) UTC + 5:00 UTC + 5:30 (Bombay) UTC + 6:00 UTC + 7:00 UTC + 8:00 (Australian Western Time) UTC + 9:00 UTC + 9:30 (Australian Central Time) UTC + 10:00 (Australian Eastern Time) UTC + 11:00 UTC + 12:00 |
Data Type | VARCHAR(20) |
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 | Unemployment Rate Segment classifies Locations based on the number of unemployed in the area; for example, Up To 5% Unemployment, 5-10% Unemployment. |
Data Type | VARCHAR(20) |
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 | Web Address Type distinguishes between Web Addresses according to the protocol accessed by the Address.* Domain * Hypertext Transfer Protocol (HTTP) File Transfer Protocol (FTP) |
Data Type | VARCHAR(20) |
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 |
Description | The unique identifier of the Geographic Area Mini Dimension |
Member | GEOGRAPHIC_AREA_MINI_DIMENSION_ID [BIGINT] |
| Insurance Data Model |