| WEALTH Data Model |
Description | Channel identifies the different delivery and communications mechanisms through which products and services are made available to a customer and by which the Financial Institution and customers communicate with each other.At a leaf level, Channel is a role played by either an Involved Party (e.g. Employee, Organization Unit) or a Resource Item (e.g. an ATM, a Website). At higher levels, Channels are Groups of such Involved Parties and/or Resource Items.The lowest granularity of Channel required will be a matter of choice for the Financial Institution. Some may wish to just identify the ATM Network (a Resource Item) as a Channel, whereas others will wish to be able to identify each individual ATM machine (each a Resource Item). A Call Centre (an Organization Unit) may be sufficient granularity as a Channel in some cases - others will require recording of each Call Centre operative (Employees).Where a given Involved Party or Resource Item instance is capable of both receiving or distributing services, it may be appropriate to associate that instance with two Channels. For example, a Teller Employment Position may be part of the Teller Receipt Channel for Transactions, but part of the Teller Distribution Channel for Product Campaigns.Specific Channels may be utilized where there are accessibility issues e.g. an IP who prefers to be contacted by telephone, in this case the Channel Communication Form of Verbal is utilized. |
Foreign Key | |
![]() |
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 | The unique identifier of the Calendar Date Dimension. |
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 | The unique identifier of the Denomination Currency Dimension. It indicates the Currency in which the monetary amounts are expressed. |
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 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 | 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 |
Description | The unique identifier of the Individual Customer Dimension. |
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 |
Foreign Key Details |
Description | The unique identifier of the Individual Snapshot |
Referential Integrity: On Update | NO_ACTION |
Referential Integrity: On Delete | NO_ACTION |
Is Identifying Relationship | false |
Child Table | CHANNEL_DIMENSION |
Child Multiplicity | * |
Key Column | CALENDAR_DATE_DIMENSION_ID [BIGINT] |
Key Column | DENOMINATION_CURRENCY_DIMENSION_ID [BIGINT] |
Key Column | INDIVIDUAL_CUSTOMER_DIMENSION_ID [BIGINT] |
Parent Table | INDIVIDUAL_SNAPSHOT_FACT |
Parent Multiplicity | 0..1 |
Unique Constraint | INDIVIDUAL_SNAPSHOT_FACT_PK |
Primary Key Details |
Description | The unique identifier of the Channel Dimension |
Member | CHANNEL_DIMENSION_ID [BIGINT] |
Index Details |
Description | The unique identifier of the Channel Dimension |
Is Unique | true |
Is Clustered | false |
Member | CHANNEL_DIMENSION_ID [BIGINT] Ascending |
| WEALTH Data Model |