Table CLAIM

DescriptionA 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 .

e.g. Claim from Victor Nosal to DEF Insurance Company for fire damage to his house.
e.g. Reinsurance claim from DEF Insurance Company to Baltimore Reinsurance Company
e.g. Subrogation claim from Mighty Insurance Company to Brian Madison for compensation for property damage incurred to a car insured and paid for by Mighty Insurance Company.

Columns
CLAIM_IDCLAIM_ID
ANCHOR_IDANCHOR_ID
CLAIM_MINI_DIMENSION_IDCLAIM_MINI_DIMENSION_ID
CLOSING_DATECLOSING_DATE
COVERAGE_PERCENTAGECOVERAGE_PERCENTAGE
DECISIONSDECISIONS
DESCRIPTIONDESCRIPTION
EFFECTIVE_FROM_DATEEFFECTIVE_FROM_DATE
EFFECTIVE_TO_DATEEFFECTIVE_TO_DATE
EXTERNAL_REFERENCEEXTERNAL_REFERENCE
FULL_RECOVERY_DATEFULL_RECOVERY_DATE
INDEMNITY_PORTIONINDEMNITY_PORTION
OPENING_DATEOPENING_DATE
POLICYHOLDER_NUMBER_OF_YEARS_INSUREDPOLICYHOLDER_NUMBER_OF_YEARS_INSURED
PROVIDER_NAMEPROVIDER_NAME
RECOVERY_DURATIONRECOVERY_DURATION
STATUS_DATESTATUS_DATE
TYPETYPE
VALID_FROM_DATEVALID_FROM_DATE
VALID_TO_DATEVALID_TO_DATE
DEDUCTIBLE_AMOUNTDEDUCTIBLE_AMOUNT
TOTAL_COSTTOTAL_COST
CLAIMED_AMOUNTCLAIMED_AMOUNT
CURRENT_AMOUNT_PAIDCURRENT_AMOUNT_PAID

Primary Key
CLAIM_PKCLAIM_PK

Dependencies
AWM - TransformationAWM - Transformation

Column Details

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



 ANCHOR_ID
DescriptionAny value without business meaning that uniquely distinguishes occurrences of this entity independently of its history.
Data TypeBIGINT
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 CLAIM_MINI_DIMENSION_ID
DescriptionSoft link to Claim mini dimension
Data TypeBIGINT
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 CLOSING_DATE
DescriptionThe date at which this claim ceases and no longer can be changed by the financial services company.
Derived from the status related information.
Data TypeDATE
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 COVERAGE_PERCENTAGE
DescriptionIndicates 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 TypeDECIMAL(8 , 5)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 DECISIONS
DescriptionA 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 TypeVARCHAR(256)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 DESCRIPTION
DescriptionA 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 TypeVARCHAR(256)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 EFFECTIVE_FROM_DATE
DescriptionThe 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 TypeTIMESTAMP
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 EFFECTIVE_TO_DATE
DescriptionThe 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 TypeTIMESTAMP
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 EXTERNAL_REFERENCE
DescriptionThe number or code assigned to claim by a party for identification or communication purposes.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 FULL_RECOVERY_DATE
DescriptionDate at which the full financial recovery has been reached for the claim.
Data TypeDATE
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 INDEMNITY_PORTION
DescriptionThe 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 TypeDECIMAL(8 , 5)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 OPENING_DATE
DescriptionThe 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 TypeDATE
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 POLICYHOLDER_NUMBER_OF_YEARS_INSURED
DescriptionNumber of years a policyholder has been a customer before submitting this claim.
Data TypeDATE
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 PROVIDER_NAME
DescriptionName of the provider of service.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



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



 STATUS_DATE
DescriptionThe date at which a claim becomes effective in a given status.
Data TypeDATE
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 TYPE
DescriptionIndicates the name of the type the business model object belongs to.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 VALID_FROM_DATE
DescriptionThe 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 TypeTIMESTAMP
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 VALID_TO_DATE
DescriptionThe 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 TypeTIMESTAMP
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 DEDUCTIBLE_AMOUNT
DescriptionThe 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 TypeDECIMAL(14 , 2)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 TOTAL_COST
DescriptionThe 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 TypeDECIMAL(14 , 2)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 CLAIMED_AMOUNT
DescriptionThe amount for the money provision element part (used for decomposing a money provision element).
Data TypeDECIMAL(14 , 2)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 CURRENT_AMOUNT_PAID
DescriptionThe amount for the money provision element part (used for decomposing a money provision element).
Data TypeDECIMAL(14 , 2)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse

Primary Key Details

 CLAIM_PK
DescriptionThe unique identifier of the Claim
MemberCLAIM_ID [BIGINT]

Dependency Details

 AWM - Transformation