| Insurance Data Model |
Description | A demand by an individual or organization to obtain money or enforcement of a right or benefit.The demand for money, services or goods from one party to another party under terms and conditions which have been defined in a |
Primary Key | |
![]() |
Dependencies | |
![]() |
Column Details |
Description | The unique identifier of the Claim |
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 | Any value without business meaning that uniquely distinguishes occurrences of this entity independently of its history. |
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 | Soft link to Claim 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 date at which this claim ceases and no longer can be changed by the financial services company.Derived from the status related information. |
Data Type | DATE |
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 | Indicates whether or not, and to which extend, the insurance policys of the claimant cover the loss incurred in the claim. The information about the claim and its circumstances will be validated against the insurance policy and financial services product information to verify whether the claim is covered or not and to which extend: not covered (0%), fully covered (100%) or partially covered (any other%). e.g. 60% (where the house is only covered for 60% of its value) e.g. Value of the house at time of providing coverage was set at 200T Euro. At time of loss, the value appears to be 250T Euro. The coverage percentage is set to 80%. |
Data Type | DECIMAL(8 , 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 free-text statement used to capture the decisions made by the financial services company when assessing this claim. e.g. A decision may be taken to grant coverage to a loyal customer, even though some of the coverage conditions are not fulfilled. |
Data Type | VARCHAR(256) |
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 free-text statement used to explain what is represented by this claim. e.g. Claim for dented hood and front fenders caused by a fallen tree branch during a windstorm. |
Data Type | VARCHAR(256) |
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 effective date and time that represents the beginning of the time period during which the values of all attributes of the entity occurrence are true in the business reality. |
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 effective date and time that represents the end of the time period during which the values of all attributes of the entity occurrence are true in the business reality. |
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 number or code assigned to claim by a party for identification or communication purposes. |
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 | Date at which the full financial recovery has been reached for the claim. |
Data Type | DATE |
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 part of the total cost of the claim that reimburses the loss. It excludes all fees and expenses.Calculated from the money provision element parts from the particular money provisions that are the benefits in the claim offers that are offered for the claim. |
Data Type | DECIMAL(8 , 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 | The date at which this claim commences; that is, the date at which the loss or damage has been recognised.Derived from the status related information. |
Data Type | DATE |
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 | Number of years a policyholder has been a customer before submitting this claim. |
Data Type | DATE |
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 | Name of the provider of service. |
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 | Indicates the time period between settling of the primary claim offer and the settling of the claim offer related through claim offer recovery. Is derived from the status dates on the claim offers. |
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 | The date at which a claim becomes effective in a given status. |
Data Type | DATE |
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 | Indicates the name of the type the business model object belongs to. |
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 transaction time that represents the beginning of the time period during which the values of this recorded data are true in the source system. |
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 transaction time that represents the end of the time period during which the values of this recorded data are true in the source system. |
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 amount to be subtracted from any benefit paid for all the elementary claims linked to this claim.At elementary claim level derived from the applicable deductibles for the coverage components against which the claim benefit is requested.At claim folder level derived from the deductibles at the elementary claim level adjusted with deductibles applied to the insurance policies against which the claim is recorded. |
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 cost of this claim to the financial services company.Calculated from the money provision element parts from the particular money provisions that are the benefits in the claim offers that are offered for the claim, and from the associated internal claim cost. |
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 amount for the money provision element part (used for decomposing a money provision element). |
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 amount for the money provision element part (used for decomposing a money provision element). |
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 |
Primary Key Details |
Description | The unique identifier of the Claim |
Member | CLAIM_ID [BIGINT] |
Dependency Details |
| Insurance Data Model |