Table CONTACT_POINT

DescriptionA geographic area is an area defined by physical or governmental boundaries. This represents a place, such as the postal (or zip) code contained in a postal address or agent sales territory.
The primary use of this atomic subject area is to identify geographic and demographic areas. Demographic area is a location whose population is analyzed to determine its characteristics (see < Geo-demographics>).

Columns
CONTACT_POINT_IDCONTACT_POINT_ID
ADDRESS_LINESADDRESS_LINES
ANCHOR_IDANCHOR_ID
BASIC_DATA_INCOMPLETEBASIC_DATA_INCOMPLETE
BOX_NUMBERBOX_NUMBER
BUILDING_NAMEBUILDING_NAME
CITYCITY
CITY_ROWCITY_ROW
CONTACT_INFORMATIONCONTACT_INFORMATION
COUNTRYCOUNTRY
COUNTRY_ROWCOUNTRY_ROW
EFFECTIVE_FROM_DATEEFFECTIVE_FROM_DATE
EFFECTIVE_TO_DATEEFFECTIVE_TO_DATE
FLOOR_NUMBERFLOOR_NUMBER
CONTACT_POINT_MINI_DIMENSION_IDCONTACT_POINT_MINI_DIMENSION_ID
HOUSE_NUMBERHOUSE_NUMBER
LATITUDELATITUDE
LONGITUDELONGITUDE
POPULATION_INFO_IDPOPULATION_INFO_ID
POSTAL_BARCODEPOSTAL_BARCODE
POSTAL_CODEPOSTAL_CODE
REGION_ROWREGION_ROW
STREETSTREET
SUBREGIONSUBREGION
SUBREGION_ROWSUBREGION_ROW
TYPE_EXTERNAL_REFERENCETYPE_EXTERNAL_REFERENCE
UNIT_NUMBERUNIT_NUMBER
VALID_FROM_DATEVALID_FROM_DATE
VALID_TO_DATEVALID_TO_DATE
REGIONREGION
ELEVATIONELEVATION
GPS_POINTGPS_POINT

Primary Key
CONTACT_POINT_PKCONTACT_POINT_PK

Dependencies
AWM - TransformationAWM - Transformation

Column Details

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



 ADDRESS_LINES
DescriptionThe lines of the formatted address.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



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



 BASIC_DATA_INCOMPLETE
DescriptionIndicates whether the data is considered incomplete.
Data TypeCHAR(1)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 BOX_NUMBER
DescriptionThe mail receptacle located at a public post office or other postal service provider.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 BUILDING_NAME
DescriptionThe name of the building.

e.g. Residence Petit Paradis
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 CITY
DescriptionThe city where the address is located.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



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



 CONTACT_INFORMATION
DescriptionThe concatenated string that represents the fully formatted address.

e.g. mbeaulne@attglobal.net
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 COUNTRY
DescriptionThe country where the address is located.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



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



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



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



 FLOOR_NUMBER
DescriptionThe number of the floor.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 CONTACT_POINT_MINI_DIMENSION_ID
DescriptionSoft link to Geographic Area Mini Dimension
Data TypeBIGINT
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 HOUSE_NUMBER
DescriptionThe number of the building in the street.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 LATITUDE
DescriptionThe location of the place, expressed in measurements with respect to a commonly used reference system. The coordinates identify both the reference system and the values with respect to the dimensions of the reference system. Coordinates can be used to define targeted areas in marketing activitys.
Defines an east-west line on the earths surface which shows degrees north or south of the equator that the Postal address lies upon.
Data TypeINTEGER
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 LONGITUDE
DescriptionThe location of the place, expressed in measurements with respect to a commonly used reference system. The coordinates identify both the reference system and the values with respect to the dimensions of the reference system. Coordinates can be used to define targeted areas in marketing activitys.
Defines a line on the earths surface which the address 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 TypeINTEGER
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 POPULATION_INFO_ID
DescriptionThe unique identifier of the population information for each occurrence of this entity.
Data TypeBIGINT
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 POSTAL_BARCODE
DescriptionThe representation of this address as a bar code that can be printed on mail. Some mail operators offer discount on bulk mail if a valid barcode has been printed by the sender.

e.g. The US Zip+4 Postnet barcode is a 12 digits postal bar code structured as follows: 5 digits for the ZIP code. 4 digits for the ZIP+4 code. 2 digits representing the last 2 digits of the street address.1 digit checksum calculated as the sum of the other digits modulo 10
Data TypeVARCHAR(256)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 POSTAL_CODE
DescriptionThe unique identifier used to associate postal deliveries. This may also be referred to as zip code or post code.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



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



 STREET
DescriptionThe street where the address is located.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 SUBREGION
DescriptionThe sub-region (depending on the country, this could be the commune or county) where the address is located.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 SUBREGION_ROW
DescriptionIndicates whether this row represents a Subregion in the hierarchy of Geographic Area.
Data TypeCHAR(1)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 TYPE_EXTERNAL_REFERENCE
DescriptionThe mutually exclusive categorisation of this Postal address.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 UNIT_NUMBER
DescriptionThe numeric portion or alphanumeric label that identifies a unit within a building.

e.g. 14 (as in Apartment 14, Bath Road)
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



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



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



 REGION
DescriptionThe region (depending on the country, this could be the state, province or county) where the address is located.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 ELEVATION
DescriptionThe gps coordinate for the elevation or altitude of a location.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 GPS_POINT
DescriptionThis captures points on a map related to an address and may be implemented depending on the database platform and the geo spatial functionality used.
Data TypeVARCHAR(2000)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse

Primary Key Details

 CONTACT_POINT_PK
DescriptionThe unique identifier of the Geographic Area
MemberCONTACT_POINT_ID [BIGINT]

Dependency Details

 AWM - Transformation