| Insurance Data Model |
Description | Grouping of attributes used to perform analysis on instances of Top level financial services agreement that share the same characteristics. |
Primary Key | |
![]() |
Dependencies | |
![]() |
Column Details |
Description | The unique identifier of the Top level financial services agreement mini 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 | Indicates the currency as selected by the customer to be used on any monetary information provided to the customer. |
Data Type | VARCHAR(20) |
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 position of the agreement within a life-cycle model consisting of a number of statuses. e.g. Cancelled e.g. Draft e.g. In-force e.g. Lapsed e.g. Not taken up e.g. Offered e.g. Rejected e.g. Suspended e.g. Terminated |
Data Type | VARCHAR(20) |
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 additional information to explain the latest status of the agreement. e.g. Not eligible (if |
Data Type | VARCHAR(20) |
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 tax regime that applies to this agreement. |
Data Type | VARCHAR(20) |
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 | Defines the tax status of an agreement. e.g. Conpulsory e.g. Voluntary |
Data Type | VARCHAR(20) |
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 | An indication that an agreement has multiple limits and limit ranges applicable. |
Data Type | CHAR(1) |
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 period of time stipulated in the policy under which the insurance company can declare a life insurance contract void because of misrepresentation. This time period is typically fixed at two years and, once the time period has passed, the company cannot cancel the policy unless there has been nonpayment of premiums. |
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 | Indicator to determine if there is an option to convert a term policy to a permanent policy during the course of the agreement. |
Data Type | CHAR(1) |
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 | Indicator to determine if the death benefits are guaranteed for the duration of the policy. |
Data Type | CHAR(1) |
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 | Indicator to determine whether premiums are guaranteed not to change during the life of the policy. |
Data Type | CHAR(1) |
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 | Indicator to determine if the term life insurance policy can be renewed at the end of the policy term. |
Data Type | CHAR(1) |
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 | An option to receive dividends as a form of benefit payment related to a participating life insurance policy. These dividends are not guaranteed and there is no tax liability associated with them. |
Data Type | VARCHAR(20) |
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 position of the agreement within a life-cycle model consisting of a number of statuses. e.g. Cancelled e.g. Draft e.g. In-force e.g. Lapsed e.g. Not taken up e.g. Offered e.g. Rejected e.g. Suspended e.g. Terminated |
Data Type | VARCHAR(20) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Primary Key Details |
Description | The unique identifier of the Insurance policy mini dimension |
Member | INSURANCE_POLICY_MINI_DIMENSION_ID [BIGINT] |
Dependency Details |
| Insurance Data Model |