| Insurance Data Model |
Description | Fact entity that records measures related to CRM events in the life-cycle of customers or prospects.The measures are fully identified by the dimensions, which are:- Time (grain: calendar day)- Type (grain: life event type)- Customer (grain: Customer)- Party (grain: Party)- Party name (grain: Unstructured name]- External organisation [grain: social media network]- Communication content- Other category = event categoryThe measures are additive on the time dimension. |
Foreign Key | |
![]() |
|
![]() |
|
![]() |
|
![]() |
|
![]() |
|
![]() |
|
![]() |
|
![]() |
Primary Key | |
![]() |
Column Details |
Description | Number of Customer events of the same type that happened on the Calendar day for a Party and for a Customer profile. e.g. New customers e.g. New marriages |
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 | 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 Event 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 Event category 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 Person 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 Person 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 | Age of the customer at the time the event happened.Note: This is a degenerate dimension and not a foreign key |
Data Type | INTEGER |
Default Value | None |
Is Primary Key | true |
Is Identity | false |
Is Nullable | false |
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_LIFE_EVENTS_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 | CUSTOMER_LIFE_EVENTS_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 | CUSTOMER_LIFE_EVENTS_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 | CUSTOMER_LIFE_EVENTS_FACT |
Child Role Name | has for dimension |
Child Multiplicity | * |
Key Column | CRM_EVENT_ID [BIGINT] |
Parent Table | EVENT |
Parent Role Name | is dimension of |
Parent Multiplicity | 1 |
Unique Constraint | EVENT_PK |
Referential Integrity: On Update | NO_ACTION |
Referential Integrity: On Delete | NO_ACTION |
Is Identifying Relationship | false |
Child Table | CUSTOMER_LIFE_EVENTS_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 | CUSTOMER_LIFE_EVENTS_FACT |
Child Role Name | has for dimension |
Child Multiplicity | * |
Key Column | EVENT_CATEGORY_ID [BIGINT] |
Parent Table | EVENT_CATEGORY |
Parent Role Name | is dimension of |
Parent Multiplicity | 1 |
Unique Constraint | EVENT_CATEGORY_PK |
Referential Integrity: On Update | NO_ACTION |
Referential Integrity: On Delete | NO_ACTION |
Is Identifying Relationship | true |
Child Table | CUSTOMER_LIFE_EVENTS_FACT |
Child Role Name | has for dimension |
Child Multiplicity | * |
Key Column | PERSON_ID [BIGINT] |
Parent Table | PERSON |
Parent Role Name | is dimension of |
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 | CUSTOMER_LIFE_EVENTS_FACT |
Child Role Name | has for dimension |
Child Multiplicity | * |
Key Column | PERSON_MINI_DIMENSION_ID [BIGINT] |
Parent Table | PERSON_MINI_DIMENSION |
Parent Role Name | is dimension of |
Parent Multiplicity | 0..1 |
Unique Constraint | PERSON_MINI_DIMENSION_PK |
Primary Key Details |
Description | The unique identifier of the Customer life events Fact |
Member | CALENDAR_DATE_ID [BIGINT] |
Member | CUSTOMER_ID [BIGINT] |
Member | GEOGRAPHIC_AREA_ID [BIGINT] |
Member | CRM_EVENT_ID [BIGINT] |
Member | EVENT_CATEGORY_ID [BIGINT] |
Member | PERSON_ID [BIGINT] |
Member | CUSTOMER_AGE [INTEGER] |
| Insurance Data Model |