Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
ISO_3166-2CountrySubDivisionID (PK) | Token ID assigned to uniquely identify all country-primary subdivision instances. This token is non-signifcant and should be automatically generated. | ID_ISO_3166_2_CY_SBDVN | Identity | integer | |
ISOCountryPrimarySubdivisionID (AK) | ISO 3166-2 five digit number used ot uniquely identify a country primary subdivision. | ID_ISO_3166_2_CY_PRMRY_SBDVN | Identity | integer | |
ISOThreeCharacterCountryCode (AK) | ISO 3166-2 three character abbreviation for the country | CD_ISO_3_CHR_CY | Code4 | char(4) | |
ISOCountryPrimarySubDivisionName | Full proper name of the country primary subdivision | NM_ISO_CY_PRMRY_SBDVN | Name | varchar(40) | |
ISOCountryPrimarySubDivisionAbbreviationCode | ISO 3166-2 country primary subdivision abbreviation. Concatenation of two character country code, a dash and three character abbreviation for the subdivision. Note we're carrying this as a single attribute because it's represented that way in the ISO 3166-2 standard. | CD_ISO_CY_PRMRY_SBDVN_ABBR_CD | Code6 | char(6) | |
ISOSubdivisionAlternateNameDescription | This is a comma delimited list of subdivision names. This is part of the ISO 3166-2 standard and is a denormalized list of unofficial, nonstandard names (which is why it's not part of an alternate key). | DE_ISO_SBDVN_ALT_NM | DescriptionShort | varchar(255) | |
ISOCountryName | Full proper name of the country | NM_ISO_CY | Name | varchar(40) | |
ISO3166_CountryPrimarySubdivisionTypeCode (FK) | An ISO 3166-2 designated code that indicates the type of country primary subdivision. The list shown under examples is the ISO standard and should be loaded in as the code values. Eamples include: ------------------------- Province District county Parish Dependency federal district city territory state municipality autonomous republic Governorate division Region Capital Region Department canton Entity autonomous municipality geographical region prefecture commune economic prefecture special administrative region autonomous region capital district island special municipality administration metropolitan department Metropolitan regions overseas regions territorial collectivity overseas territory Overseas territorial collectivity self-governed part administrative regions Perfecture governorates special zone. autonomous sector capital city city of county right union territory autonomous province special district geographic units special region Urban Perfecture Metropolis Island group Special City metropolitan city capital metropolitan city special zone popularate federal territory administrative atoll capital council Chain of Islands autonomous territorial unit territorial unit quarter Rerion zone development regions country Regional Council Special Island Authority Unitary Authority capital territory Pakistan administered area administered areas federal capital territory indigenous region constitutional province Voivodship republic administrative territory administrative region autonomous district autonomous city geographical entities administrative area area states autonomous community metropolitan administration special administrative city Island Council geographic regions Emirate council area (Scotland) district council area (Northern Ireland) borough metropolitan district unitary authority (Wales) two-tier county city corporation principality outlying area federal dependency | CD_ISO3166_CY_PRMRY_SBDVN_TYP | Code | varchar(20) | ISO3166-2PrimarySubdivisionType(LU_ISO3166_2_PRMRY_SBDVN_TYP) |
ISOCountryCode (FK) | The ISO-3166-1 two letter code denoting a locality in which the retailer does business. | CD_CY_ISO | Code2 | char(2) | ISO3166-1Country(LO_CY_ISO) |