Table COVERAGE_COMPONENT_MINI_DIMENSION

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

Columns
COVERAGE_COMPONENT_MINI_DIMENSION_IDCOVERAGE_COMPONENT_MINI_DIMENSION_ID
ANNUITY_DURATION_TYPEANNUITY_DURATION_TYPE
COVERAGE_DETERMINATIONCOVERAGE_DETERMINATION
COVERAGE_PRIORITYCOVERAGE_PRIORITY
JOINT_CONTINGENCYJOINT_CONTINGENCY
STATUSSTATUS
STATUS_REASONSTATUS_REASON
TAX_STATUSTAX_STATUS
CLASS_OF_BUSINESSCLASS_OF_BUSINESS
INSURABLE_RISKINSURABLE_RISK

Primary Key
COVERAGE_COMPONENT_MINI_DIMENSION_PKCOVERAGE_COMPONENT_MINI_DIMENSION_PK

Dependencies
AWM - TransformationAWM - Transformation

Column Details

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



 ANNUITY_DURATION_TYPE
DescriptionIndicates how long the annuity will be payable.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 COVERAGE_DETERMINATION
DescriptionIndicates how the coverage benefit amount for the death coverage is determined.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 COVERAGE_PRIORITY
DescriptionIndicates the priority of the coverage in relation to other insurance policies that cover the same insured for the same risks.

e.g. Contribution per limit ratio
e.g. Equal share
e.g. Excess
e.g. Primary
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 JOINT_CONTINGENCY
DescriptionIndicates under which conditions the annuity will start to be payable.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 STATUS
DescriptionThe position of the agreement within a life-cycle model consisting of a number of statuses.

e.g. Cancelled
e.g. Draft
e.g. In-force
e.g. Lapsed
e.g. Not taken up
e.g. Offered
e.g. Rejected
e.g. Suspended
e.g. Terminated
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 STATUS_REASON
DescriptionThe additional information to explain the latest status of the agreement.

e.g. Not eligible (if rejected)
e.g. Not taken up (if rejected)
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 TAX_STATUS
DescriptionDefines the tax status of an agreement.

e.g. Conpulsory
e.g. Voluntary
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 CLASS_OF_BUSINESS
DescriptionThe business classification for this type of coverage.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 INSURABLE_RISK
DescriptionAn indication of whether coverage includes an insurable risk.
Data TypeCHAR(1)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse

Primary Key Details

 COVERAGE_COMPONENT_MINI_DIMENSION_PK
DescriptionThe unique identifier of the Coverage component mini dimension
MemberCOVERAGE_COMPONENT_MINI_DIMENSION_ID [BIGINT]

Dependency Details

 AWM - Transformation