Table CONTACT_INFORMATION_DIMENSION

DescriptionContact Information identifies the location of a physical address, telephone number, email or web site.

Columns
CONTACT_INFORMATION_DIMENSION_IDCONTACT_INFORMATION_DIMENSION_ID
ACCESS_CODEACCESS_CODE
ADDRESS_DOMAINADDRESS_DOMAIN
BOX_NUMBERBOX_NUMBER
BUILDING_IDENTIFIERBUILDING_IDENTIFIER
CITYCITY
COUNTRYCOUNTRY
COUNTYCOUNTY
DESCRIPTIONDESCRIPTION
DEVICEDEVICE
DIRECTIONDIRECTION
DISTRICTDISTRICT
EMAILEMAIL
EXTENSIONEXTENSION
FLOORFLOOR
FULL_TELEPHONE_NUMBERFULL_TELEPHONE_NUMBER
LOCAL_NUMBERLOCAL_NUMBER
HOUSE_NUMBERHOUSE_NUMBER
LOCATION_UNIT_NUMBERLOCATION_UNIT_NUMBER
MAXIMUM_MESSAGE_SIZEMAXIMUM_MESSAGE_SIZE
NAMENAME
POSTCODE_AREAPOSTCODE_AREA
ROOM_NUMBERROOM_NUMBER
SPATIAL_X_COORDINATESPATIAL_X_COORDINATE
SPATIAL_Y_COORDINATESPATIAL_Y_COORDINATE
SPATIAL_Z_COORDINATESPATIAL_Z_COORDINATE
STATESTATE
STREETSTREET
STREET_NAMESTREET_NAME
STREET_NUMBERSTREET_NUMBER
STREET_SUFFIXSTREET_SUFFIX
UNIVERSAL_RESOURCE_LOCATORUNIVERSAL_RESOURCE_LOCATOR
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
CONTACT_INFORMATION_DIMENSION_PKCONTACT_INFORMATION_DIMENSION_PK

Indexes
CONTACT_INFORMATION_DIMENSION_PKCONTACT_INFORMATION_DIMENSION_PK

Column Details

 CONTACT_INFORMATION_DIMENSION_ID
DescriptionThe unique identifier of the Contact Information Dimension
Data TypeBIGINT
Default ValueNone
Is Primary Keytrue
Is Identitytrue
Is Nullablefalse
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 ACCESS_CODE
DescriptionAddress Component indicates the portion of the address that allows entry to an electronic location; for example, an alphanumeric code to access a communication system at a specific location.
Data TypeINTEGER
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 ADDRESS_DOMAIN
DescriptionAddress Domain indicates the portion of an e-mail address that represents a service or network provider. For example in the address 'j_doe@webaddress.com' the Electronic Address Domain is 'webaddress.com'.
Data TypeVARCHAR(50)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 BOX_NUMBER
Description Box Number indicates a mail receptacle located at a public Post Office or other postal service provider.
Data TypeCHAR(10)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 BUILDING_IDENTIFIER
DescriptionBuilding Identifier indicates a name, number, or code of a premise.
Data TypeCHAR(10)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 CITY
DescriptionCity indicates a Geographic Area that is a municipality with legal power granted by a state charter.
Data TypeVARCHAR(50)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 COUNTRY
DescriptionCountry indicates a Geographic Area that is recognized as an independent political unit in world affairs.
Data TypeVARCHAR(50)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 COUNTY
DescriptionCounty indicates a Geographic Area that represents a political subdivision of a country or state; for example, Galway, Orange County.
Data TypeVARCHAR(50)
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 Contact Information.
Data TypeVARCHAR(2000)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 DEVICE
DescriptionDevice indicates the equipment on which the data or voice transfer occurs.
Data TypeCHAR(10)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 DIRECTION
DescriptionDirection indicates one or more compass points that are used to distinguish an address; for example, High Street SE or High Street NW.
Data TypeCHAR(10)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 DISTRICT
DescriptionDistrict indicates an administrative or political division of a territory.
Data TypeVARCHAR(50)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 EMAIL
DescriptionEmail indicates e-mail address
Data TypeVARCHAR(50)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 EXTENSION
DescriptionExtension indicates an addition to a Root Number that uniquely identifies an Address, such as a telephone number.
Data TypeCHAR(10)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 FLOOR
Description Floor indicates a story in a building; for example, the international department is on the second floor (2F).
Data TypeCHAR(10)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 FULL_TELEPHONE_NUMBER
DescriptionFull Telephone Number indicates an international unique dialling number.
Data TypeBIGINT
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 LOCAL_NUMBER
DescriptionLocal Number indicates the portion of the telephonic number spectific to each local individual connection to the telephone network.
Data TypeCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 HOUSE_NUMBER
Description House Number indicates the numeric portion or alphanumeric label that identifies a building on street; for example, 2, as in 2 Main Street; 14B, as in 14B Center Street.
Data TypeCHAR(10)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 LOCATION_UNIT_NUMBER
DescriptionLocation Unit Number indicates a unit within a building, for example, '14', as in 'Apartment 14, 15 Bath Road'.
Data TypeCHAR(10)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 MAXIMUM_MESSAGE_SIZE
DescriptionMaximum Message Size indicates the total size (in bytes) of an e-mail, inclusive of body, headers and attachments.
Data TypeCHAR(10)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 NAME
DescriptionName indicates the primary name assigned to the Contact Information.
Data TypeVARCHAR(50)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 POSTCODE_AREA
DescriptionPostcode Area indicates a Geographic Area defined by postal authorities to facilitate mail delivery services; for example, the area defined by a Zip Code in the U.S.
Data TypeINTEGER
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 ROOM_NUMBER
DescriptionRoom Number indicates the identifier of a specific enclosed unit within a premise.
Data TypeCHAR(10)
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



 STATE
DescriptionState indicates a Geographic Area that represents a first level legal and political subdivision of a country; for example, Virginia, Bavaria.
Data TypeVARCHAR(10)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 STREET
DescriptionStreet indicates a characteristic of the Street e.g. Avenue, Drive, Court, Lane.
Data TypeVARCHAR(50)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 STREET_NAME
DescriptionStreet Name indicates the label assigned to the street; for example, Main as in Main street or First as in First Avenue.
Data TypeVARCHAR(50)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 STREET_NUMBER
DescriptionStreet Number indicates the numeric value assigned to the street; for example '5' as in '5th Avenue'
Data TypeCHAR(10)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 STREET_SUFFIX
DescriptionStreet Suffix indicates a descriptive label assigned to the street: for example, 'Lower' as in '14 Baggot St. Lr'.
Data TypeCHAR(10)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 UNIVERSAL_RESOURCE_LOCATOR
DescriptionUniversal Resource Locator indicates a textual identification of the location of the web page.
Data TypeVARCHAR(100)
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 TypeVARCHAR(50)
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 TypeVARCHAR(50)
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 TypeVARCHAR(50)
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 TypeVARCHAR(50)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse

Primary Key Details

 CONTACT_INFORMATION_DIMENSION_PK
MemberCONTACT_INFORMATION_DIMENSION_ID [BIGINT]

Index Details

 CONTACT_INFORMATION_DIMENSION_PK
Is Uniquetrue
Is Clusteredfalse
MemberCONTACT_INFORMATION_DIMENSION_ID [BIGINT] Ascending