Table GEOGRAPHIC_AREA_MINI_DIMENSION

DescriptionGrouping of attributes used to perform analysis on instances of Geographic Area that share the same characteristics.

Columns
GEOGRAPHIC_AREA_MINI_DIMENSION_IDGEOGRAPHIC_AREA_MINI_DIMENSION_ID
ADDRESS_TYPEADDRESS_TYPE
BANKRUPTCY_RATE_SEGMENTBANKRUPTCY_RATE_SEGMENT
COUNTRY_CODECOUNTRY_CODE
COUNTRY_TELEPHONE_CODECOUNTRY_TELEPHONE_CODE
EU_MEMBERSHIP_FLAGEU_MEMBERSHIP_FLAG
ELECTRONIC_ADDRESS_TYPEELECTRONIC_ADDRESS_TYPE
GEOGRAPHIC_AREA_DENSITY_DESIGNATIONGEOGRAPHIC_AREA_DENSITY_DESIGNATION
GEOGRAPHIC_AREA_NATUREGEOGRAPHIC_AREA_NATURE
GEOGRAPHIC_AREA_TYPEGEOGRAPHIC_AREA_TYPE
INFLATION_RATE_SEGMENTINFLATION_RATE_SEGMENT
LOCATION_TYPELOCATION_TYPE
RESTRICTED_COUNTRY_FLAGRESTRICTED_COUNTRY_FLAG
SUSPICIOUS_COUNTRY_FLAGSUSPICIOUS_COUNTRY_FLAG
TIME_ZONETIME_ZONE
UNEMPLOYMENT_RATE_SEGMENTUNEMPLOYMENT_RATE_SEGMENT
WEB_ADDRESS_TYPEWEB_ADDRESS_TYPE

Primary Key
GEOGRAPHIC_AREA_MINI_DIMENSION_PKGEOGRAPHIC_AREA_MINI_DIMENSION_PK

Column Details

 GEOGRAPHIC_AREA_MINI_DIMENSION_ID
DescriptionThe unique identifier of the Geographic Area Mini Dimension
Data TypeBIGINT
Default ValueNone
Is Primary Keytrue
Is Identitytrue
Is Nullablefalse
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 ADDRESS_TYPE
DescriptionAddress Type distinguishes between Addresses according to the nature and application of the Address.

* Domain *
Electronic Address
Postal Address
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 BANKRUPTCY_RATE_SEGMENT
DescriptionBankruptcy 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 TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 COUNTRY_CODE
DescriptionThe code of the country according to ISO 3166-1-alpha-2 code; for example:

United States: US
United Kingdom: GB
Ireland: IE
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 COUNTRY_TELEPHONE_CODE
DescriptionThe telephonic country area code - a prefix required to dial a phone number in the country from abroad; for example:

United States: 1
United Kingdom: 44
Ireland: 353
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 EU_MEMBERSHIP_FLAG
DescriptionIndicates whether or not the Country is a member of the European Union.
Data TypeCHAR(1)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 ELECTRONIC_ADDRESS_TYPE
DescriptionElectronic 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 TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 GEOGRAPHIC_AREA_DENSITY_DESIGNATION
DescriptionGeographic 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 TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 GEOGRAPHIC_AREA_NATURE
DescriptionGeographic Area Nature distinguishes between Geographic Areas according to the density, type and layout of buildings in the Area.

* Domain *
Rural
Suburban
Urban
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 GEOGRAPHIC_AREA_TYPE
DescriptionGeographic 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 TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 INFLATION_RATE_SEGMENT
DescriptionInflation Rate Segment classifies Locations based on their inflation rate band.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 LOCATION_TYPE
DescriptionLocation 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 TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 RESTRICTED_COUNTRY_FLAG
DescriptionIndicates that trading or engaging in any financial arrangement with a country is restricted.
Data TypeCHAR(1)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 SUSPICIOUS_COUNTRY_FLAG
DescriptionIndicates whether or not the Country is suspected of engaging in activities that transgress international law, such as money laundering and supporting terrorist organizations.
Data TypeCHAR(1)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 TIME_ZONE
DescriptionTime 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 TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 UNEMPLOYMENT_RATE_SEGMENT
DescriptionUnemployment Rate Segment classifies Locations based on the number of unemployed in the area; for example, Up To 5% Unemployment, 5-10% Unemployment.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 WEB_ADDRESS_TYPE
DescriptionWeb Address Type distinguishes between Web Addresses according to the protocol accessed by the Address.

* Domain *
Hypertext Transfer Protocol (HTTP)
File Transfer Protocol (FTP)
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse

Primary Key Details

 GEOGRAPHIC_AREA_MINI_DIMENSION_PK
DescriptionThe unique identifier of the Geographic Area Mini Dimension
MemberGEOGRAPHIC_AREA_MINI_DIMENSION_ID [BIGINT]