Table INSURANCE_POLICY

DescriptionAn agreement (individual agreement, or group agreement) between an and a based on a . The agreement specifies the obligation of the to pay benefits and of the premium payer to pay premiums.
Document specifying the details of a financial services agreement. As a general extension, the term policy is also used as an alias for insurance agreement. That is, the content of the agreement between the policyholder and the insurance company, such as the policyholder information, the objects covered, all clauses and more specifically the premium and benefit obligations, forecast of savings, and so on.

e.g. An inherited insurance policy opened by a using death benefit from another insurance policy from which the was named . The inherited insurance policy is related to its originating insurance policy with the agreement conversion association.

Columns
INSURANCE_POLICY_IDINSURANCE_POLICY_ID
ANCHOR_IDANCHOR_ID
BOUND_DATEBOUND_DATE
EFFECTIVE_FROM_DATEEFFECTIVE_FROM_DATE
EFFECTIVE_TO_DATEEFFECTIVE_TO_DATE
EXTERNAL_REFERENCEEXTERNAL_REFERENCE
INCEPTION_DATEINCEPTION_DATE
PLANNED_END_DATEPLANNED_END_DATE
RENEWAL_DATERENEWAL_DATE
REVIEW_DATEREVIEW_DATE
STATUS_DATESTATUS_DATE
INSURANCE_POLICY_MINI_DIMENSION_IDINSURANCE_POLICY_MINI_DIMENSION_ID
TYPETYPE
VALID_FROM_DATEVALID_FROM_DATE
VALID_TO_DATEVALID_TO_DATE
VERSIONVERSION
STATUSSTATUS
PAYMENT_FREQUENCYPAYMENT_FREQUENCY
PREMIUM_AMOUNTPREMIUM_AMOUNT
NAMENAME

Primary Key
INSURANCE_POLICY_PKINSURANCE_POLICY_PK

Column Details

 INSURANCE_POLICY_ID
DescriptionThe unique identifier of the Top level financial services agreement
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



 BOUND_DATE
DescriptionThe date at which the financial services agreement is considered legally binding, or in force. Depending on the legislation the bound date can be the date when the financial services agreement is signed by both parties and/or when the first premium has been paid.
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



 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 allocated to an agreement for identification and communication purposes such as a policy number.
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 TypeTIMESTAMP
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



 RENEWAL_DATE
DescriptionThe next date at which the inforce status of the agreement must be re-evaluated or reconducted.
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



 INSURANCE_POLICY_MINI_DIMENSION_ID
DescriptionSoft link to Top level financial services agreement mini dimension
Data TypeBIGINT
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



 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



 STATUS
DescriptionThe position of the agreement within a life-cycle model consisting of a number of statuses.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 PAYMENT_FREQUENCY
DescriptionThe length of time between payments. Typically this cannot be altered once the policy has been issued.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 PREMIUM_AMOUNT
DescriptionThe amount for the money provision element part of type policy premium(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



 NAME
DescriptionThe number or code allocated to an agreement for identification and communication purposes such as a policy number.
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_PK
DescriptionThe unique identifier of the Insurance policy
MemberINSURANCE_POLICY_ID [BIGINT]