| WEALTH Data Model |
Description | Individual Customer Communication Fact is a fact table recording the key measures relating to Individual Customer Communications. |
Foreign Key | |
![]() |
|
![]() |
|
![]() |
|
![]() |
Primary Key | |
![]() |
Indexes | |
![]() |
Column Details |
Description | The unique identifier of the Calendar Date Dimension. |
Data Type | BIGINT |
Default Value | None |
Is Primary Key | true |
Is Identity | false |
Is Nullable | false |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | The unique identifier of the Channel Dimension. |
Data Type | BIGINT |
Default Value | None |
Is Primary Key | true |
Is Identity | false |
Is Nullable | false |
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 | true |
Is Identity | false |
Is Nullable | false |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | A Measure that identifies the number of calls which resulted in a sale expressed as a percentage of the number of calls made or received. |
Data Type | DECIMAL(5 , 2) |
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 | A Measure that identifies the number of calls which resulted in a sale expressed as a percentage of the number of calls made or received. |
Data Type | DECIMAL(5 , 2) |
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 | A measure that identifies the total cost of communications initiated by the Financial Institution. For example, the cost of sending out bank statements to customers on a monthly basis. |
Data Type | DECIMAL(10 , 2) |
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 | A Measure that identifies the cost to the Financial Institution of processing communications identified by the key dimensions, both in direct channel costs and in FI resources. |
Data Type | DECIMAL(10 , 2) |
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 | (Total Financial Institution Processing Time For Communications)A Measure that identifies the total number of hours spent by employees of the Financial Institution in processing Communications during the measurement period. |
Data Type | TIME |
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 | A measure that identifies the amount of time spent processing matters arising from a Communication after the communication has been completed expressed in the units referenced by Time Unit Of Measure.For example, the amount of time an operator in a call center spends documenting issues raised by a customer complaint after the customer call ends. |
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 | A Measure that identifies the amount of available time not spent processing Communications or related activities during the measurement period expressed in the units referenced by Financial Organisation's standard Time Unit Of Measure. |
Data Type | TIME |
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 | A Measure that identifies the monetary value of the loss. |
Data Type | DECIMAL(20 , 5) |
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 | A measure that identifies the amount of time spent preparing for a communication during the measurement period expressed in the units referenced by Time Unit Of Measure.For example, the amount of time an operator in a telesales call center spends gathering information about a customer and planning the call before actually calling the customer. |
Data Type | TIME |
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 | A Measure that identifies the monetary value of the profit. |
Data Type | DECIMAL(20 , 5) |
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 | A timestamp that identifies when this Fact Entity's instance was populated. |
Data Type | TIMESTAMP |
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 Customer Segment Mini 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 |
Referential Integrity: On Update | NO_ACTION |
Referential Integrity: On Delete | NO_ACTION |
Is Identifying Relationship | true |
Child Table | CUSTOMER_COMMUNICATION_FACT |
Child Multiplicity | * |
Key Column | CHANNEL_DIMENSION_ID [BIGINT] |
Parent Table | CHANNEL_DIMENSION |
Parent Multiplicity | 0..1 |
Unique Constraint | CHANNEL_DIMENSION_PK |
Referential Integrity: On Update | NO_ACTION |
Referential Integrity: On Delete | NO_ACTION |
Is Identifying Relationship | true |
Child Table | CUSTOMER_COMMUNICATION_FACT |
Child Multiplicity | * |
Key Column | CALENDAR_DATE_DIMENSION_ID [BIGINT] |
Parent Table | CALENDAR_DATE_DIMENSION |
Parent Multiplicity | 0..1 |
Unique Constraint | CALENDAR_DATE_DIMENSION_PK |
Referential Integrity: On Update | NO_ACTION |
Referential Integrity: On Delete | NO_ACTION |
Is Identifying Relationship | true |
Child Table | CUSTOMER_COMMUNICATION_FACT |
Child Multiplicity | * |
Key Column | INDIVIDUAL_CUSTOMER_DIMENSION_ID [BIGINT] |
Parent Table | INDIVIDUAL_CUSTOMER_DIMENSION |
Parent Multiplicity | 0..1 |
Unique Constraint | INDIVIDUAL_CUSTOMER_DIMENSION_PK |
Referential Integrity: On Update | NO_ACTION |
Referential Integrity: On Delete | NO_ACTION |
Is Identifying Relationship | false |
Child Table | CUSTOMER_COMMUNICATION_FACT |
Child Multiplicity | * |
Key Column | CUSTOMER_SEGMENT_MINI_DIMENSION_ID [BIGINT] |
Parent Table | CUSTOMER_SEGMENT_MINI_DIMENSION |
Parent Multiplicity | 0..1 |
Unique Constraint | CUSTOMER_SEGMENT_MINI_DIMENSION_PK |
Primary Key Details |
Description | The unique identifier of the Customer Communication Fact |
Member | CHANNEL_DIMENSION_ID [BIGINT] |
Member | INDIVIDUAL_CUSTOMER_DIMENSION_ID [BIGINT] |
Member | CALENDAR_DATE_DIMENSION_ID [BIGINT] |
Index Details |
Is Unique | true |
Is Clustered | false |
Member | CHANNEL_DIMENSION_ID [BIGINT] Ascending |
Member | INDIVIDUAL_CUSTOMER_DIMENSION_ID [BIGINT] Ascending |
Member | CALENDAR_DATE_DIMENSION_ID [BIGINT] Ascending |
| WEALTH Data Model |