| Insurance Data Model |
Description | Grouping of attributes used to perform analysis on instances of Claim that share the same characteristics. |
Primary Key | |
![]() |
Dependencies | |
![]() |
Column Details |
Description | The unique identifier of the Claim 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 whether or not the blame for an accident related to a claim is allocated to the claimant. e.g. At fault e.g. Non-fault e.g. Split liability e.g. Under investigation |
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 whether the claim is the subject of litigation. |
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 | Indicates that the claimed losses are covered by more than one insurance 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 | Indicates that this request is the first received by this insurer from the claimant or his representative concerning the claimed event. e.g. False e.g. True |
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 | Indicates whether a full financial recovery has been made for the claim. |
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 | If true, indicates that the claim is an incoming claim, the claim is made by another party against the modelled organisation.If false, indicates that the claim is an outgoing claim, the claim is made by the modelled organisation against another party.The value is derived from the party role in claim: claimant and claimee. |
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 | Incurred but not reported claim. Indicates that the claim is a provision for a loss that has incurred but is not yet reported to the insurance company. e.g. False e.g. True |
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 | Indicates whether amounts must still be received as recovery for the claim. |
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 | Indicates in which way the modelled organisation will try to recover the cost of the claim from a third party. e.g. Legal action against third party. |
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 currency selected by the customer to be used for all benefit payments and all monetary information related to this claim. e.g. Euro |
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 position of the claim folder within a life-cycle model consisting of a number of statuses.Identifies the position of the claim within a life-cycle model consisting of a number of statuses. e.g. Abandoned e.g. Closed e.g. Coverage confirmed e.g. Coverage evaluation e.g. Granted e.g. In dispute e.g. Notified e.g. Nullified e.g. Open e.g. Rejected e.g. Rejected coverage not provided e.g. Settled e.g. Under evaluation e.g. Under negotiation |
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 reason explaining why there was a status change. e.g. Abnormal claims level or pattern (Rejected) e.g. Coverage not Confirmed (Rejected) e.g. Driver not on cover (Rejected) e.g. Loss not within Coverage period (Rejected) e.g. Not pursued (Closed) e.g. Settled (Closed) e.g. Uninsured loss recovery (Notified) e.g. Vehicle not on cover (Rejected) e.g. Whereabouts of third party unknown |
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 Claim mini dimension |
Member | CLAIM_MINI_DIMENSION_ID [BIGINT] |
Dependency Details |
| Insurance Data Model |