Table COVERAGE_COMPONENT

DescriptionA (financial services agreement component) detailing the circumstances under which a benefit (money or services) will be paid. Effectively this provides protection against a particular risk. In property insurance, coverage identifies elements such as perils insured against, properties covered, locations covered, individuals insured and the limits of indemnification. In life insurance, a coverage identifies elements such as living and death benefits.

Columns
COVERAGE_COMPONENT_IDCOVERAGE_COMPONENT_ID
ANCHOR_IDANCHOR_ID
ANNUITY_REDUCTION_PERCENTAGEANNUITY_REDUCTION_PERCENTAGE
COVERAGE_COMPONENT_MINI_DIMENSION_IDCOVERAGE_COMPONENT_MINI_DIMENSION_ID
EFFECTIVE_FROM_DATEEFFECTIVE_FROM_DATE
EFFECTIVE_TO_DATEEFFECTIVE_TO_DATE
ELIGIBILITY_PERIODELIGIBILITY_PERIOD
EXTENDED_REPORTING_PERIODEXTENDED_REPORTING_PERIOD
EXTERNAL_REFERENCEEXTERNAL_REFERENCE
INCEPTION_DATEINCEPTION_DATE
OWN_RISK_PERIODOWN_RISK_PERIOD
PLANNED_END_DATEPLANNED_END_DATE
RETROACTIVE_START_DATERETROACTIVE_START_DATE
REVIEW_DATEREVIEW_DATE
STATUS_DATESTATUS_DATE
TYPETYPE
VALID_FROM_DATEVALID_FROM_DATE
VALID_TO_DATEVALID_TO_DATE
VERSIONVERSION
WAITING_PERIODWAITING_PERIOD
BRANDBRAND
PRODUCT_DESCRIPTIONPRODUCT_DESCRIPTION
PRODUCT_EXTERNAL_REFERENCEPRODUCT_EXTERNAL_REFERENCE
PRODUCT_NAMEPRODUCT_NAME
PRODUCT_VERSIONPRODUCT_VERSION
DEDUCTIBLE_PERIODICITYDEDUCTIBLE_PERIODICITY
DEDUCTIBLE_MINIMUM_AMOUNTDEDUCTIBLE_MINIMUM_AMOUNT
DEDUCTIBLE_MAXIMUM_AMOUNTDEDUCTIBLE_MAXIMUM_AMOUNT
LIMIT__PERIODICITYLIMIT__PERIODICITY
LIMIT_MAXIMUM_AMOUNTLIMIT_MAXIMUM_AMOUNT
LIMIT_MINIMUM_AMOUNTLIMIT_MINIMUM_AMOUNT

Primary Key
COVERAGE_COMPONENT_PKCOVERAGE_COMPONENT_PK

Dependencies
AWM - TransformationAWM - Transformation

Column Details

 COVERAGE_COMPONENT_ID
DescriptionThe unique identifier of the Coverage component
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



 ANNUITY_REDUCTION_PERCENTAGE
DescriptionIndicates that when 1 of the coinsured insured's of an annuity dies, the payment of the annuity to the other coinsured insured's continues but is reduced with the percentage indicated in this attribute.
Data TypeDECIMAL(8 , 5)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 COVERAGE_COMPONENT_MINI_DIMENSION_ID
DescriptionSoft link to Coverage component mini dimension
Data TypeBIGINT
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



 ELIGIBILITY_PERIOD
DescriptionTime following the eligibility date during which the insured may apply for insurance without evidence of insurability.
Data TypeDECIMAL(20 , 6)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 EXTENDED_REPORTING_PERIOD
DescriptionPeriod following the termination date of the policy or coverage in which a claim can still be accepted, provided the claimed loss has occurred during the coverage period.

e.g. 2 years
Data TypeDECIMAL(20 , 6)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 EXTERNAL_REFERENCE
DescriptionThe number or code allocated to a Policy component by a Party for identification and communication.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 INCEPTION_DATE
DescriptionThe date on which the agreement first starts. For renewable agreements, this date represents the date of the original agreement before any renewal.
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



 OWN_RISK_PERIOD
DescriptionThe period of time after the start of the disability and during which benefits are not payable. Benefits start to be payable from the end of the own risk period onwards.

e.g. The payment of the disability benefit starts only 4 weeks after the accident.
Data TypeDECIMAL(20 , 6)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 PLANNED_END_DATE
DescriptionThe planned end date of the agreement such as the maturity date for an endowment policy or the expiration date of a 3 year term life policy. The termination date of the agreement is represented in the status date for the terminated status.
Data TypeDATE
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 RETROACTIVE_START_DATE
DescriptionStart date of policy coverage chosen as a date in the past preceding the policy inception date.

e.g. 1 june 2004 where inception date is 1 march 2005
Data TypeDATE
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 REVIEW_DATE
DescriptionThe date on which a review of the agreement is planned.
Data TypeDATE
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 STATUS_DATE
DescriptionThe date on which the agreement's latest status became effective.
Data TypeDATE
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 TYPE
DescriptionThe mutually exclusive categorisation of this Coverage component.
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



 VERSION
DescriptionRepresents the versioning information for this instance of an agreement.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 WAITING_PERIOD
DescriptionThe period of time after the start date of the coverage component during which the insured is not covered. Any loss occurring before the end of the waiting period will not be subject to a benefit.
Data TypeDECIMAL(20 , 6)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 BRAND
DescriptionThe brand name of the service which the service is usually known as which may be different to the actual name of the service product.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 PRODUCT_DESCRIPTION
DescriptionA free-text statement used to describe the product.
Data TypeVARCHAR(256)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 PRODUCT_EXTERNAL_REFERENCE
DescriptionThe number or code of the product used 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



 PRODUCT_NAME
DescriptionThe word or phrase that identifies (but not uniquely) the product.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 PRODUCT_VERSION
DescriptionIdentifies the version of a specification of the product.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 DEDUCTIBLE_PERIODICITY
DescriptionDefinition:
The length of every recurring period to which the deductible applies. This is used in conjunction with anniversary date.

Example:

Per loss event
Per damage
Per claim
Life time
Annual
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 DEDUCTIBLE_MINIMUM_AMOUNT
DescriptionDefinition:
The lower limit for the amount of the deductible. When the deductible consists of only one amount, the minimum represents that amount.

Example:

EUR 250 as the minimum for a deductible of 5% of the claimed amount.
Data TypeINTEGER
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 DEDUCTIBLE_MAXIMUM_AMOUNT
DescriptionDefinition:
The upper limit for the amount of the deductible.

Example:

EUR 1000 as the maximum amount of a deductible of 5% of the claimed amount.
Data TypeINTEGER
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 LIMIT__PERIODICITY
DescriptionDefinition:
The length of every recurring period to which the limit applies. This is used in conjunction with anniversary date (see example in anniversary date).

Example:

First loss limited
Life time
Per month
Single loss per location
Per year
Per single payment
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 LIMIT_MAXIMUM_AMOUNT
DescriptionThe amount that represents the limit maximum

When the limit consists of only one amount, the minimum represents that amount.
Data TypeINTEGER
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 LIMIT_MINIMUM_AMOUNT
Description
When the limit consists of only one amount, the minimum represents that amount.
Data TypeINTEGER
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse

Primary Key Details

 COVERAGE_COMPONENT_PK
DescriptionThe unique identifier of the Coverage component
MemberCOVERAGE_COMPONENT_ID [BIGINT]

Dependency Details

 AWM - Transformation