Table INSURANCE_POLICY_MINI_DIMENSION

DescriptionGrouping of attributes used to perform analysis on instances of Top level financial services agreement that share the same characteristics.

Columns
INSURANCE_POLICY_MINI_DIMENSION_IDINSURANCE_POLICY_MINI_DIMENSION_ID
CURRENCY_SELECTIONCURRENCY_SELECTION
STATUSSTATUS
STATUS_REASONSTATUS_REASON
TAX_QUALIFICATIONTAX_QUALIFICATION
TAX_STATUSTAX_STATUS
MULTI_LEVEL_INSURANCE_TERMSMULTI_LEVEL_INSURANCE_TERMS
CONTESTABILITY_PERIODCONTESTABILITY_PERIOD
GUARANTEED_CONVERTIBILITY_INDICATORGUARANTEED_CONVERTIBILITY_INDICATOR
GUARANTEED_DEATH_BENEFIT_INDICATORGUARANTEED_DEATH_BENEFIT_INDICATOR
GUARANTEED_PREMIUM_INDICATORGUARANTEED_PREMIUM_INDICATOR
GUARANTEED_RENEWABILITY_INDICATORGUARANTEED_RENEWABILITY_INDICATOR
PARTICIPATING_LIFE_INSURANCE_DIVIDEND_OPTIONPARTICIPATING_LIFE_INSURANCE_DIVIDEND_OPTION
RENEWAL_STATUSRENEWAL_STATUS

Primary Key
INSURANCE_POLICY_MINI_DIMENSION_PKINSURANCE_POLICY_MINI_DIMENSION_PK

Dependencies
AWM - TransformationAWM - Transformation

Column Details

 INSURANCE_POLICY_MINI_DIMENSION_ID
DescriptionThe unique identifier of the Top level financial services agreement mini dimension
Data TypeBIGINT
Default ValueNone
Is Primary Keytrue
Is Identitytrue
Is Nullablefalse
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 CURRENCY_SELECTION
DescriptionIndicates the currency as selected by the customer to be used on any monetary information provided to the customer.
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_QUALIFICATION
DescriptionIdentifies the tax regime that applies to this agreement.
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



 MULTI_LEVEL_INSURANCE_TERMS
DescriptionAn indication that an agreement has multiple limits and limit ranges applicable.
Data TypeCHAR(1)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 CONTESTABILITY_PERIOD
DescriptionThe period of time stipulated in the policy under which the insurance company can declare a life insurance contract void because of misrepresentation. This time period is typically fixed at two years and, once the time period has passed, the company cannot cancel the policy unless there has been nonpayment of premiums.
Data TypeDECIMAL(20 , 6)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 GUARANTEED_CONVERTIBILITY_INDICATOR
DescriptionIndicator to determine if there is an option to convert a term policy to a permanent policy during the course of the agreement.
Data TypeCHAR(1)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 GUARANTEED_DEATH_BENEFIT_INDICATOR
DescriptionIndicator to determine if the death benefits are guaranteed for the duration of the policy.
Data TypeCHAR(1)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 GUARANTEED_PREMIUM_INDICATOR
DescriptionIndicator to determine whether premiums are guaranteed not to change during the life of the policy.
Data TypeCHAR(1)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 GUARANTEED_RENEWABILITY_INDICATOR
DescriptionIndicator to determine if the term life insurance policy can be renewed at the end of the policy term.
Data TypeCHAR(1)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 PARTICIPATING_LIFE_INSURANCE_DIVIDEND_OPTION
DescriptionAn option to receive dividends as a form of benefit payment related to a participating life insurance policy. These dividends are not guaranteed and there is no tax liability associated with them.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 RENEWAL_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

Primary Key Details

 INSURANCE_POLICY_MINI_DIMENSION_PK
DescriptionThe unique identifier of the Insurance policy mini dimension
MemberINSURANCE_POLICY_MINI_DIMENSION_ID [BIGINT]

Dependency Details

 AWM - Transformation