Table CLAIM_MINI_DIMENSION

DescriptionGrouping of attributes used to perform analysis on instances of Claim that share the same characteristics.

Columns
CLAIM_MINI_DIMENSION_IDCLAIM_MINI_DIMENSION_ID
ACCIDENT_FAULTACCIDENT_FAULT
COURT_CASECOURT_CASE
DUAL_COVERAGEDUAL_COVERAGE
FIRST_ADVICEFIRST_ADVICE
FULL_RECOVERY_MADEFULL_RECOVERY_MADE
INCOMINGINCOMING
INCURRED_BUT_NOT_REPORTEDINCURRED_BUT_NOT_REPORTED
RECOVERY_OUTSTANDINGRECOVERY_OUTSTANDING
RECOVERY_STRATEGYRECOVERY_STRATEGY
SETTLEMENT_CURRENCY_SELECTIONSETTLEMENT_CURRENCY_SELECTION
STATUSSTATUS
STATUS_REASONSTATUS_REASON

Primary Key
CLAIM_MINI_DIMENSION_PKCLAIM_MINI_DIMENSION_PK

Dependencies
AWM - TransformationAWM - Transformation

Column Details

 CLAIM_MINI_DIMENSION_ID
DescriptionThe unique identifier of the Claim mini dimension
Data TypeBIGINT
Default ValueNone
Is Primary Keytrue
Is Identitytrue
Is Nullablefalse
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 ACCIDENT_FAULT
DescriptionIndicates 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 TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 COURT_CASE
DescriptionIndicates whether the claim is the subject of litigation.
Data TypeCHAR(1)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 DUAL_COVERAGE
DescriptionIndicates that the claimed losses are covered by more than one insurance policy.
Data TypeCHAR(1)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 FIRST_ADVICE
DescriptionIndicates 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 TypeCHAR(1)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 FULL_RECOVERY_MADE
DescriptionIndicates whether a full financial recovery has been made for the claim.
Data TypeCHAR(1)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 INCOMING
DescriptionIf 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 TypeCHAR(1)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 INCURRED_BUT_NOT_REPORTED
DescriptionIncurred 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 TypeCHAR(1)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 RECOVERY_OUTSTANDING
DescriptionIndicates whether amounts must still be received as recovery for the claim.
Data TypeCHAR(1)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 RECOVERY_STRATEGY
DescriptionIndicates 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 TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 SETTLEMENT_CURRENCY_SELECTION
DescriptionIndicates 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 TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 STATUS
DescriptionIdentifies 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 TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 STATUS_REASON
DescriptionThe 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 TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse

Primary Key Details

 CLAIM_MINI_DIMENSION_PK
DescriptionThe unique identifier of the Claim mini dimension
MemberCLAIM_MINI_DIMENSION_ID [BIGINT]

Dependency Details

 AWM - Transformation