| Insurance Data Model |
Description | Fact entity that records the measures related to responses generated by a Campaign for each customerThe measures are fully identified by the dimensions, which are:- Time (grain: day)- Campaign (grain: campaign)- Market segment- Financial services product (grain: product)- Channel role- Communication mediumThe measure sum insured tracks if the campaign generated new revenue and how much |
Primary Key | |
![]() |
Column Details |
Description | Amount received by the Insurance Company when selling third-party products. |
Data Type | DECIMAL(14 , 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 | Amount paid out by the Insurance company when selling their products via Channels. e.g. 2500 USD |
Data Type | DECIMAL(14 , 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 | The total sum insured (policy face amount) of new policies that the company wrote as a result of a Campaign. |
Data Type | DECIMAL(14 , 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 | 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 Communication profile 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 Financial services product 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 Role player 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 Financial services product 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 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 | 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 Campaign |
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 Campaign 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 Code |
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 |
Foreign Key Details |
Referential Integrity: On Update | NO_ACTION |
Referential Integrity: On Delete | NO_ACTION |
Is Identifying Relationship | true |
Child Table | CUSTOMER_CAMPAIGN_RESPONSE_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_CAMPAIGN_RESPONSE_FACT |
Child Role Name | has for dimension |
Child Multiplicity | * |
Key Column | COMMUNICATION_PROFILE_ID [BIGINT] |
Parent Table | COMMUNICATION_PROFILE |
Parent Role Name | is dimension of |
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 | CUSTOMER_CAMPAIGN_RESPONSE_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_CAMPAIGN_RESPONSE_FACT |
Child Role Name | has for dimension |
Child Multiplicity | * |
Key Column | FINANCIAL_SERVICES_PRODUCT_ID [BIGINT] |
Parent Table | FINANCIAL_SERVICES_PRODUCT |
Parent Role Name | is dimension of |
Parent Multiplicity | 1 |
Unique Constraint | FINANCIAL_SERVICES_PRODUCT_PK |
Referential Integrity: On Update | NO_ACTION |
Referential Integrity: On Delete | NO_ACTION |
Is Identifying Relationship | true |
Child Table | CUSTOMER_CAMPAIGN_RESPONSE_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_CAMPAIGN_RESPONSE_FACT |
Child Role Name | has for dimension |
Child Multiplicity | * |
Key Column | MARKET_SEGMENT_ID [BIGINT] |
Parent Table | MARKET_SEGMENT |
Parent Role Name | is dimension of |
Parent Multiplicity | 1 |
Unique Constraint | MARKET_SEGMENT_PK |
Referential Integrity: On Update | NO_ACTION |
Referential Integrity: On Delete | NO_ACTION |
Is Identifying Relationship | false |
Child Table | CUSTOMER_CAMPAIGN_RESPONSE_FACT |
Child Role Name | has for dimension |
Child Multiplicity | * |
Key Column | FINANCIAL_SERVICES_PRODUCT_MINI_DIMENSION_ID [BIGINT] |
Parent Table | FS_PRODUCT_MINI_DIMENSION |
Parent Role Name | is dimension of |
Parent Multiplicity | 0..1 |
Unique Constraint | FS_PRODUCT_MINI_DIMENSION_PK |
Referential Integrity: On Update | NO_ACTION |
Referential Integrity: On Delete | NO_ACTION |
Is Identifying Relationship | false |
Child Table | CUSTOMER_CAMPAIGN_RESPONSE_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_CAMPAIGN_RESPONSE_FACT |
Child Role Name | Verb1 |
Child Multiplicity | * |
Key Column | CAMPAIGN_ID [BIGINT] |
Parent Table | CAMPAIGN |
Parent Multiplicity | 1 |
Unique Constraint | CAMPAIGN_PK |
Referential Integrity: On Update | NO_ACTION |
Referential Integrity: On Delete | NO_ACTION |
Is Identifying Relationship | false |
Child Table | CUSTOMER_CAMPAIGN_RESPONSE_FACT |
Child Role Name | Verb2 |
Child Multiplicity | * |
Key Column | CAMPAIGN_MINI_DIMENSION_ID [BIGINT] |
Parent Table | CAMPAIGN_MINI_DIMENSION |
Parent Multiplicity | 0..1 |
Unique Constraint | CAMPAIGN_MINI_DIMENSION_PK |
Referential Integrity: On Update | NO_ACTION |
Referential Integrity: On Delete | NO_ACTION |
Is Identifying Relationship | true |
Child Table | CUSTOMER_CAMPAIGN_RESPONSE_FACT |
Child Role Name | Verb3 |
Child Multiplicity | * |
Key Column | RESPONSE_CODE_ID [BIGINT] |
Parent Table | CODE |
Parent Multiplicity | 1 |
Unique Constraint | CODE_PK |
Referential Integrity: On Update | NO_ACTION |
Referential Integrity: On Delete | NO_ACTION |
Is Identifying Relationship | true |
Child Table | CUSTOMER_CAMPAIGN_RESPONSE_FACT |
Child Role Name | Verb4 |
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 | CUSTOMER_CAMPAIGN_RESPONSE_FACT |
Child Role Name | Verb5 |
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 Campaign sales Fact |
Member | CALENDAR_DATE_ID [BIGINT] |
Member | COMMUNICATION_PROFILE_ID [BIGINT] |
Member | CUSTOMER_ID [BIGINT] |
Member | FINANCIAL_SERVICES_PRODUCT_ID [BIGINT] |
Member | GEOGRAPHIC_AREA_ID [BIGINT] |
Member | MARKET_SEGMENT_ID [BIGINT] |
Member | CAMPAIGN_ID [BIGINT] |
Member | RESPONSE_CODE_ID [BIGINT] |
Member | PERSON_ID [BIGINT] |
| Insurance Data Model |