| WEALTH Data Model |
Description | Contact Information identifies the location of a physical address, telephone number, email or web site. |
Primary Key | |
![]() |
Indexes | |
![]() |
Column Details |
Description | The unique identifier of the Contact Information Dimension |
Data Type | BIGINT |
Default Value | None |
Is Primary Key | true |
Is Identity | true |
Is Nullable | false |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | Address 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 Type | INTEGER |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | Address 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 Type | VARCHAR(50) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | Box Number indicates a mail receptacle located at a public Post Office or other postal service provider. |
Data Type | CHAR(10) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | Building Identifier indicates a name, number, or code of a premise. |
Data Type | CHAR(10) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | City indicates a Geographic Area that is a municipality with legal power granted by a state charter. |
Data Type | VARCHAR(50) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | Country indicates a Geographic Area that is recognized as an independent political unit in world affairs. |
Data Type | VARCHAR(50) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | County indicates a Geographic Area that represents a political subdivision of a country or state; for example, Galway, Orange County. |
Data Type | VARCHAR(50) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | Description indicates a textual explanation or free form comments about the Contact Information. |
Data Type | VARCHAR(2000) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | Device indicates the equipment on which the data or voice transfer occurs. |
Data Type | CHAR(10) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | Direction indicates one or more compass points that are used to distinguish an address; for example, High Street SE or High Street NW. |
Data Type | CHAR(10) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | District indicates an administrative or political division of a territory. |
Data Type | VARCHAR(50) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | Email indicates e-mail address |
Data Type | VARCHAR(50) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | Extension indicates an addition to a Root Number that uniquely identifies an Address, such as a telephone number. |
Data Type | CHAR(10) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | Floor indicates a story in a building; for example, the international department is on the second floor (2F). |
Data Type | CHAR(10) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | Full Telephone Number indicates an international unique dialling number. |
Data Type | BIGINT |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | Local Number indicates the portion of the telephonic number spectific to each local individual connection to the telephone network. |
Data Type | CHAR(20) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
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 Type | CHAR(10) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | Location Unit Number indicates a unit within a building, for example, '14', as in 'Apartment 14, 15 Bath Road'. |
Data Type | CHAR(10) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | Maximum Message Size indicates the total size (in bytes) of an e-mail, inclusive of body, headers and attachments. |
Data Type | CHAR(10) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | Name indicates the primary name assigned to the Contact Information. |
Data Type | VARCHAR(50) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | Postcode 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 Type | INTEGER |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | Room Number indicates the identifier of a specific enclosed unit within a premise. |
Data Type | CHAR(10) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | Spatial 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 Type | CHAR(10) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | Spatial 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 Type | CHAR(10) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | Spatial 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 Type | CHAR(10) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | State indicates a Geographic Area that represents a first level legal and political subdivision of a country; for example, Virginia, Bavaria. |
Data Type | VARCHAR(10) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | Street indicates a characteristic of the Street e.g. Avenue, Drive, Court, Lane. |
Data Type | VARCHAR(50) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | Street Name indicates the label assigned to the street; for example, Main as in Main street or First as in First Avenue. |
Data Type | VARCHAR(50) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | Street Number indicates the numeric value assigned to the street; for example '5' as in '5th Avenue' |
Data Type | CHAR(10) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | Street Suffix indicates a descriptive label assigned to the street: for example, 'Lower' as in '14 Baggot St. Lr'. |
Data Type | CHAR(10) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | Universal Resource Locator indicates a textual identification of the location of the web page. |
Data Type | VARCHAR(100) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | Anchor Id indicates any value without business meaning that uniquely distinguishes occurrences of this entity independently of its history. |
Data Type | INTEGER |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | Current 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 Type | INTEGER |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | Effective 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 Type | VARCHAR(50) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | Effective 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 Type | VARCHAR(50) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | Valid 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 Type | VARCHAR(50) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | Valid 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 Type | VARCHAR(50) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Primary Key Details |
Member | CONTACT_INFORMATION_DIMENSION_ID [BIGINT] |
Index Details |
Is Unique | true |
Is Clustered | false |
Member | CONTACT_INFORMATION_DIMENSION_ID [BIGINT] Ascending |
| WEALTH Data Model |