| WEALTH Data Model |
Description | Social Interaction Channel dimension identifies the different social channels associated with the Customer. |
Primary Key | |
![]() |
Indexes | |
![]() |
Column Details |
Description | The unique identifier of the Channel 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 | Administration Involved Party Code indicates a short alphanumeric identifier that uniquely identifies the Involved Party. |
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 | Administration Involved Party Name indicates the entire and complete name of the subject Involved Party; for example, 'Incorporated Township of East Quincy', 'International Business Machines Corporation' , 'XYZ Limited Partnership for Fossil Fuel Exploration'. |
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 | Code indicates 'meaningful' mnemonic external codes, in each language of the warehouse environment, are assigned to each Group occurrence for purposes of identification. |
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 | Delivery Channel Code indicates 'meaningful' mnemonic external codes, in each language of the warehouse environment, are assigned to each Group occurrence for purposes of identification. |
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 | Delivery Channel Name indicates a label by which Channel is known; for example, Group #43 is known as, and is commonly called,'Fiscal Year 1993 Marketing Prospects'. |
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 | Delivery Involved Party Code indicates a short alphanumeric identifier that uniquely identifies the Involved Party. |
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 | Involved Party Name indicates the entire and complete name of the subject Involved Party; for example, 'Incorporated Township of East Quincy', 'International Business Machines Corporation' , 'XYZ Limited Partnership for Fossil Fuel Exploration'. |
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 Group. |
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 | Keyword indicates a significant word to be used for searching a database. This is often known as a 'Shortname', and is based on an abbreviated version of the complete Involved Party Name. |
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 | Name indicates a label by which Channel is known; for example, Group #43 is known as, and is commonly called,'Fiscal Year 1993 Marketing Prospects'. |
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 | Parent Channel Code indicates 'meaningful' mnemonic external codes, in each language of the warehouse environment, are assigned to each Parent Channel occurrence for purposes of identification. |
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 | Parent Channel Name indicates a label by which an instance of Parent Channel is known. |
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 | 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 | DATE |
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 | DATE |
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 | DATE |
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 | DATE |
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 | Unique Id In Source System indicates the unique identifier of the populated instance in the Source System. |
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 |
Primary Key Details |
Member | CHANNEL_DIMENSION_ID [BIGINT] |
Index Details |
Is Unique | true |
Is Clustered | false |
Member | CHANNEL_DIMENSION_ID [BIGINT] Ascending |
| WEALTH Data Model |