Entity Definition

Logical Name : ISO3166-2PrimarySubdivisionType
Physical Name : LU_ISO3166_2_PRMRY_SBDVN_TYP

A reference entity that lists the valid types of country primary subdivisions defined in the ISO 3166-2 standard.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
ISO3166_CountryPrimarySubdivisionTypeCode (PK) 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_CountryPrimarySubdivisionDescription Description of the ISO 3166-2 sub division types. This is optional since the codes are self-explanatory. DE_ISO3166_CY_PRMRY_SBDVN_TYP DescriptionShort varchar(255)


Parent Entity Verb Phrase Child Entity
ISO3166-2PrimarySubdivisionType validates ISO3166-2CountrySubdivision

Logical Views containing ISO3166-2PrimarySubdivisionType

Logical View
Logical 07030 - Customer Segment Independent Characteristics
Logical 10108 - Enterprise - Physical Locations View
Logical 10108 - Enterprise - Physical Locations View