| Insurance Data Model |
Description | Fact entity that records the measures related to communications involving a customer which could be generated by a marketing campaign.The measures are fully identified by the dimensions, which are:- Time (grain: day)- Campaign (grain: campaign)- Customer - Communication purpose- Channel role who is the sender or recipient of the communication.- Policy- Communication profile- Task - location of customer- Party score- Risk Factor Score. Grain = Claimant communication score- Risk Factor Score. Grain = Social media activity score- Communication role- SignorFor example, the measure Number of communications corresponds to the number of communications received per day, per campaign, per market segment, per communication purpose (for example, complaint), per communication channel role.This may be use to analyse the number of complaints generated by a marketing campaign. |
Primary Key | |
![]() |
Column Details |
Description | The total number of communications issued by parties contacted in the context of marketing activities. |
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 | The number of days or time lapsed between a given communication and the last communication received. |
Data Type | DECIMAL(20 , 6) |
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 | Identifies the Calendar date dimension of this Fact Entity. |
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 | Identifies the Customer dimension of this Fact Entity. |
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 | Identifies the Geographic Area dimension of this Fact Entity. |
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 | Identifies the Task dimension of this Fact Entity. |
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 | Identifies the Geographic Area Mini Dimension of this Fact Entity. |
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 | Identifies the Task mini dimension of this Fact Entity. |
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 | 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 Communication profile |
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 Communication content |
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 Communication 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 |
Description | The unique identifier of the Geographic Area |
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 Person |
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 Person 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 |
Description | The total number of communications issued by parties contacted in the context of marketing activities. |
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 | The total number of communications issued by parties contacted in the context of marketing activities. |
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 |
Foreign Key Details |
Referential Integrity: On Update | NO_ACTION |
Referential Integrity: On Delete | NO_ACTION |
Is Identifying Relationship | true |
Child Table | COMMUNICATIONS_FACT |
Child Role Name | has for dimension |
Child Multiplicity | * |
Key Column | CALENDAR_DATE_ID [BIGINT] |
Parent Table | CALENDAR_DATE |
Parent Role Name | is dimension of |
Parent Multiplicity | 1 |
Unique Constraint | CALENDAR_DATE_PK |
Referential Integrity: On Update | NO_ACTION |
Referential Integrity: On Delete | NO_ACTION |
Is Identifying Relationship | true |
Child Table | COMMUNICATIONS_FACT |
Child Role Name | has for dimension |
Child Multiplicity | * |
Key Column | CUSTOMER_ID [BIGINT] |
Parent Table | CUSTOMER |
Parent Role Name | is dimension of |
Parent Multiplicity | 1 |
Unique Constraint | CUSTOMER_PK |
Referential Integrity: On Update | NO_ACTION |
Referential Integrity: On Delete | NO_ACTION |
Is Identifying Relationship | true |
Child Table | COMMUNICATIONS_FACT |
Child Role Name | has for dimension |
Child Multiplicity | * |
Key Column | GEOGRAPHIC_AREA_ID [BIGINT] |
Parent Table | GEOGRAPHIC_AREA |
Parent Role Name | is dimension of |
Parent Multiplicity | 1 |
Unique Constraint | GEOGRAPHIC_AREA_PK |
Referential Integrity: On Update | NO_ACTION |
Referential Integrity: On Delete | NO_ACTION |
Is Identifying Relationship | true |
Child Table | COMMUNICATIONS_FACT |
Child Role Name | has for dimension |
Child Multiplicity | * |
Key Column | TASK_ID [BIGINT] |
Parent Table | TASK |
Parent Role Name | is dimension of |
Parent Multiplicity | 1 |
Unique Constraint | TASK_PK |
Referential Integrity: On Update | NO_ACTION |
Referential Integrity: On Delete | NO_ACTION |
Is Identifying Relationship | false |
Child Table | COMMUNICATIONS_FACT |
Child Role Name | has for dimension |
Child Multiplicity | * |
Key Column | TASK_MINI_DIMENSION_ID [BIGINT] |
Parent Table | TASK_MINI_DIMENSION |
Parent Role Name | is dimension of |
Parent Multiplicity | 0..1 |
Unique Constraint | TASK_MINI_DIMENSION_PK |
Referential Integrity: On Update | NO_ACTION |
Referential Integrity: On Delete | NO_ACTION |
Is Identifying Relationship | false |
Child Table | COMMUNICATIONS_FACT |
Child Role Name | has for dimension |
Child Multiplicity | * |
Key Column | GEOGRAPHIC_AREA_MINI_DIMENSION_ID [BIGINT] |
Parent Table | GEOGRAPHIC_AREA_MINI_DIMENSION |
Parent Role Name | is dimension of |
Parent Multiplicity | 0..1 |
Unique Constraint | GEOGRAPHIC_AREA_MINI_DIMENSION_PK |
Referential Integrity: On Update | NO_ACTION |
Referential Integrity: On Delete | NO_ACTION |
Is Identifying Relationship | true |
Child Table | COMMUNICATIONS_FACT |
Child Role Name | Verb1 |
Child Multiplicity | * |
Key Column | COMMUNICATION_PROFILE_ID [BIGINT] |
Parent Table | COMMUNICATION_PROFILE |
Parent Multiplicity | 1 |
Unique Constraint | COMMUNICATION_PROFILE_PK |
Referential Integrity: On Update | NO_ACTION |
Referential Integrity: On Delete | NO_ACTION |
Is Identifying Relationship | true |
Child Table | COMMUNICATIONS_FACT |
Child Role Name | Verb2 |
Child Multiplicity | * |
Key Column | COMMUNICATION_CONTENT_ID [BIGINT] |
Parent Table | COMMUNICATION_CONTENT |
Parent Multiplicity | 1 |
Unique Constraint | COMMUNICATION_CONTENT_PK |
Referential Integrity: On Update | NO_ACTION |
Referential Integrity: On Delete | NO_ACTION |
Is Identifying Relationship | false |
Child Table | COMMUNICATIONS_FACT |
Child Role Name | Verb3 |
Child Multiplicity | * |
Key Column | COMMUNICATION_MINI_DIMENSION_ID [BIGINT] |
Parent Table | COMMUNICATION_MINI_DIMENSION |
Parent Multiplicity | 0..1 |
Unique Constraint | COMMUNICATION_MINI_DIMENSION_PK |
Referential Integrity: On Update | NO_ACTION |
Referential Integrity: On Delete | NO_ACTION |
Is Identifying Relationship | true |
Child Table | COMMUNICATIONS_FACT |
Child Role Name | Verb4 |
Child Multiplicity | * |
Key Column | CONTACT_POINT_ID [BIGINT] |
Parent Table | CONTACT_POINT |
Parent Multiplicity | 1 |
Unique Constraint | CONTACT_POINT_PK |
Referential Integrity: On Update | NO_ACTION |
Referential Integrity: On Delete | NO_ACTION |
Is Identifying Relationship | true |
Child Table | COMMUNICATIONS_FACT |
Child Role Name | Verb5 |
Child Multiplicity | * |
Key Column | PERSON_ID [BIGINT] |
Parent Table | PERSON |
Parent Multiplicity | 1 |
Unique Constraint | PERSON_PK |
Referential Integrity: On Update | NO_ACTION |
Referential Integrity: On Delete | NO_ACTION |
Is Identifying Relationship | false |
Child Table | COMMUNICATIONS_FACT |
Child Role Name | Verb6 |
Child Multiplicity | * |
Key Column | PERSON_MINI_DIMENSION_ID [BIGINT] |
Parent Table | PERSON_MINI_DIMENSION |
Parent Multiplicity | 0..1 |
Unique Constraint | PERSON_MINI_DIMENSION_PK |
Primary Key Details |
Description | The unique identifier of the Communications Fact |
Member | CALENDAR_DATE_ID [BIGINT] |
Member | CUSTOMER_ID [BIGINT] |
Member | TASK_ID [BIGINT] |
Member | GEOGRAPHIC_AREA_ID [BIGINT] |
Member | COMMUNICATION_PROFILE_ID [BIGINT] |
Member | COMMUNICATION_CONTENT_ID [BIGINT] |
Member | CONTACT_POINT_ID [BIGINT] |
Member | PERSON_ID [BIGINT] |
| Insurance Data Model |