Table GEOGRAPHIC_AREA_DIMENSION

DescriptionGeographic 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.

Columns
GEOGRAPHIC_AREA_DIMENSION_IDGEOGRAPHIC_AREA_DIMENSION_ID
COUNTRYCOUNTRY
COUNTRY_ROWCOUNTRY_ROW
REGIONREGION
REGION_ROWREGION_ROW
CITYCITY
CITY_ROWCITY_ROW
COMMON_NAMECOMMON_NAME
OFFICIAL_NAMEOFFICIAL_NAME
GEOGRAPHIC_AREA_CODEGEOGRAPHIC_AREA_CODE
INTERNAL_IDENTIFICATIONINTERNAL_IDENTIFICATION
DESCRIPTIONDESCRIPTION
SPATIAL_X_COORDINATESPATIAL_X_COORDINATE
SPATIAL_Y_COORDINATESPATIAL_Y_COORDINATE
SPATIAL_Z_COORDINATESPATIAL_Z_COORDINATE
ANCHOR_IDANCHOR_ID
CURRENT_ROW_INDICATORCURRENT_ROW_INDICATOR
EFFECTIVE_FROM_DATEEFFECTIVE_FROM_DATE
EFFECTIVE_TO_DATEEFFECTIVE_TO_DATE
VALID_FROM_DATEVALID_FROM_DATE
VALID_TO_DATEVALID_TO_DATE

Primary Key
GEOGRAPHIC_AREA_DIMENSION_PKGEOGRAPHIC_AREA_DIMENSION_PK

Indexes
GEOGRAPHIC_AREA_DIMENSION_PKGEOGRAPHIC_AREA_DIMENSION_PK

Column Details

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



 COUNTRY
DescriptionCountry indicates the name of the country where the Geographic Area is located.
Data TypeVARCHAR(50)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 COUNTRY_ROW
DescriptionCountry Row indicates whether or not this row represents a Country in the hierarchy of Geographic Area.
Data TypeCHAR(10)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 REGION
DescriptionRegion 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 TypeVARCHAR(50)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 REGION_ROW
DescriptionRegion Row indicates whether or not this row represents a Region in the hierarchy of Geographic Area.
Data TypeCHAR(10)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 CITY
DescriptionCity indicates the name of the city where the Geographic Area is located.
Data TypeVARCHAR(50)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 CITY_ROW
DescriptionCity row indicates whether or not this row represents a City in the hierarchy of Geographic Area.
Data TypeCHAR(10)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 COMMON_NAME
DescriptionCommon 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 TypeVARCHAR(50)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 OFFICIAL_NAME
DescriptionOfficial Name indicates a Geographic Area Name that is a properly authorized label.
Data TypeVARCHAR(50)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 GEOGRAPHIC_AREA_CODE
DescriptionGeographic Area Code indicates a short code associated with the Geographic Area e.g. 'PA' for Pennsylvania.
Data TypeCHAR(10)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 INTERNAL_IDENTIFICATION
DescriptionInternal Identification indicates an internally generated number or code by which a Geographic Area can be identified.
Data TypeBIGINT
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 DESCRIPTION
DescriptionDescription indicates a textual explanation or free form comments about the Geographic Area.
Data TypeVARCHAR(2000)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 SPATIAL_X_COORDINATE
DescriptionSpatial 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 TypeCHAR(10)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 SPATIAL_Y_COORDINATE
DescriptionSpatial 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 TypeCHAR(10)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 SPATIAL_Z_COORDINATE
DescriptionSpatial 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 TypeCHAR(10)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 ANCHOR_ID
DescriptionAnchor Id indicates any value without business meaning that uniquely distinguishes occurrences of this entity independently of its history.
Data TypeINTEGER
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 CURRENT_ROW_INDICATOR
DescriptionCurrent 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 TypeINTEGER
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 EFFECTIVE_FROM_DATE
DescriptionEffective 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 TypeDATE
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 EFFECTIVE_TO_DATE
DescriptionEffective 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 TypeDATE
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 VALID_FROM_DATE
DescriptionValid 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 TypeDATE
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 VALID_TO_DATE
DescriptionValid 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 TypeDATE
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse

Primary Key Details

 GEOGRAPHIC_AREA_DIMENSION_PK
MemberGEOGRAPHIC_AREA_DIMENSION_ID [BIGINT]

Index Details

 GEOGRAPHIC_AREA_DIMENSION_PK
Is Uniquetrue
Is Clusteredfalse
MemberGEOGRAPHIC_AREA_DIMENSION_ID [BIGINT] Ascending