Table PERSON_VALUE_FACT

DescriptionFact entity that records the measures related to the value of persons.
The measures are fully identified by the Reference date at which the measures are calculated and by the dimension, which is:
- Person (grain: person)
- Geographic
- Household
- Time
- Party Name
Measures are additive across the dimension.

Columns
AMOUNT_OWEDAMOUNT_OWED
GROSS_INCOMEGROSS_INCOME
LIFETIME_VALUELIFETIME_VALUE
NUMBER_OF_CARSNUMBER_OF_CARS
NUMBER_OF_DEPENDENT_ADULTSNUMBER_OF_DEPENDENT_ADULTS
NUMBER_OF_DEPENDENT_CHILDRENNUMBER_OF_DEPENDENT_CHILDREN
POTENTIAL_LIFETIME_VALUEPOTENTIAL_LIFETIME_VALUE
WRITTEN_PREMIUMWRITTEN_PREMIUM
AGE_OF_PARTYAGE_OF_PARTY
OTHER_INCOMEOTHER_INCOME
NUMBER_OF_DAYS_IN_EMPLOYMENTNUMBER_OF_DAYS_IN_EMPLOYMENT
COLLEGE_EXPENSESCOLLEGE_EXPENSES
RETIREMENT_FUNDRETIREMENT_FUND
MORTGAGE_DEBTMORTGAGE_DEBT
LIFE_INSURANCE_PRESENT_VALUELIFE_INSURANCE_PRESENT_VALUE
OTHER_EXPENSESOTHER_EXPENSES
FUNERAL_AND_OTHER_EXPENSESFUNERAL_AND_OTHER_EXPENSES
SAVINGS_AND_INVESTMENTSSAVINGS_AND_INVESTMENTS
OTHER_DEBT_AMOUNTOTHER_DEBT_AMOUNT
NUMBER_OF_COVERAGE_YEARSNUMBER_OF_COVERAGE_YEARS
PERSON_IDPERSON_ID
HOUSEHOLD_IDHOUSEHOLD_ID
GEOGRAPHIC_AREA_IDGEOGRAPHIC_AREA_ID
CALENDAR_DATE_IDCALENDAR_DATE_ID
PERSON_MINI_DIMENSION_IDPERSON_MINI_DIMENSION_ID
HOUSEHOLD_MINI_DIMENSION_IDHOUSEHOLD_MINI_DIMENSION_ID
GEOGRAPHIC_AREA_MINI_DIMENSION_IDGEOGRAPHIC_AREA_MINI_DIMENSION_ID
POPULATION_TIMESTAMPPOPULATION_TIMESTAMP
CLAIMS_AMOUNTCLAIMS_AMOUNT
CLAIMS_COUNTCLAIMS_COUNT
DISPOSABLE_INCOMEDISPOSABLE_INCOME
CUSTOMER_IDCUSTOMER_ID
NUMBER_OF_POLICIESNUMBER_OF_POLICIES
NUMBER_OF_CANCELLED_POLICIESNUMBER_OF_CANCELLED_POLICIES
NUMBER_OF_CLAIMS_DENIEDNUMBER_OF_CLAIMS_DENIED
TENURETENURE
YEARS_SINCE_DRIVERS_LICENSE_OBTAINEDYEARS_SINCE_DRIVERS_LICENSE_OBTAINED
MONTHS_SINCE_LAST_ADDRESS_CHANGEMONTHS_SINCE_LAST_ADDRESS_CHANGE

Foreign Key
PERSON_VA_CALEN_FKPERSON_VA_CALEN_FK
PERSON_V_GEOGRA_FKPERSON_V_GEOGRA_FK
PERSON_VAL_HOUS_FKPERSON_VAL_HOUS_FK
PERSON_VAL_PERS_FKPERSON_VAL_PERS_FK
PERS_HOUSEHOLD__FKPERS_HOUSEHOLD__FK
PERSO_PERSON_MI_F1PERSO_PERSON_MI_F1
PERS_GEOGRAPHIC_FKPERS_GEOGRAPHIC_FK
PERSON_VAL_CUST_FKPERSON_VAL_CUST_FK

Primary Key
PERSON_VALUE_FACT_PKPERSON_VALUE_FACT_PK

Column Details

 AMOUNT_OWED
DescriptionThe amount owed by or to the party. If the debit creditor status is set to debtor, the party owes money to the modelled organisation (premium, loan). If the debit creditor status is set to creditor, the modelled organisation owes money to the party.
Data TypeDECIMAL(14 , 2)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 GROSS_INCOME
DescriptionThe most recent known gross income of this person.
Data TypeDECIMAL(14 , 2)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 LIFETIME_VALUE
DescriptionThe sum of the embedded values of all the person's inforce policies at the Reference date according to a standard calculation basis.
Data TypeDECIMAL(14 , 2)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 NUMBER_OF_CARS
DescriptionTotal number of vehicles owned by a person at the Reference date.
Data TypeINTEGER
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 NUMBER_OF_DEPENDENT_ADULTS
DescriptionThe count of dependent adults at the Reference date.
Data TypeINTEGER
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 NUMBER_OF_DEPENDENT_CHILDREN
DescriptionThe count of dependent children at the Reference date.
Data TypeINTEGER
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 POTENTIAL_LIFETIME_VALUE
DescriptionThe net present value, at the Reference date of the policies and policy components that the person will purchase in the future according to a standard calculation basis. Note: Referral value is not included in this definition of potential value.
Data TypeDECIMAL(14 , 2)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 WRITTEN_PREMIUM
DescriptionTotal premium generated from all policies hold by a Person at the Reference date.

Premium for active policy components adjusted according to the frequency of payment and term:
* For single premium policies, the initial single premium.
* For recurring/renewable single premium policies, the most recent premium amount.
* For regular premium policies, the regular premium amount effective at the last premium due date expressed in terms of a standard frequency of payment and adjusted pro-rata for cases where the term of the policy is less than the payment interval implied by the standard frequency.

* Ad hoc premium injections to investment funds are not included.
Data TypeDECIMAL(14 , 2)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 AGE_OF_PARTY
DescriptionThe age of the person.
Data TypeINTEGER
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 OTHER_INCOME
DescriptionThe annual earnings, independent of employment income, accumulated from other sources. This includes dividends, interest, spousal income and any entitlements from social security.
Data TypeDECIMAL(14 , 2)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 NUMBER_OF_DAYS_IN_EMPLOYMENT
DescriptionIdentifies the length of time between the claimant's employment start date and the date of the incident to identify claimants who started their employment shortly before the incident occurred.
Data TypeINTEGER
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 COLLEGE_EXPENSES
DescriptionThe estimated college expenses for dependents liable for future payment. This denotes the average total cost of a four year university education. It may be impacted on whether the education is derived at a public or private institution and includes the cost of tuition, room, board, books, transportation and other expenses.
Data TypeDECIMAL(14 , 2)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 RETIREMENT_FUND
DescriptionThe current value of retirement fund assets and includes any IRAs, 401k plans, pension and profit sharing plans.
Data TypeDECIMAL(14 , 2)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 MORTGAGE_DEBT
DescriptionThe current mortgage debt liable for payment by a party.
Data TypeDECIMAL(14 , 2)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 LIFE_INSURANCE_PRESENT_VALUE
DescriptionThe present value of life insurance and includes any group insurance and personal insurance purchased by the party.
Data TypeDECIMAL(14 , 2)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 OTHER_EXPENSES
DescriptionThe estimated daily household expenses liable for payment by a party in order to support the household. This includes food, clothing, utilities and insurance expenses.
Data TypeDECIMAL(14 , 2)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 FUNERAL_AND_OTHER_EXPENSES
DescriptionThe estimated costs associated with funeral and other death related expenses that are incurred by a party.
Data TypeDECIMAL(14 , 2)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 SAVINGS_AND_INVESTMENTS
DescriptionThe current value of savings and investments and includes bank accounts, stocks, bonds, mutual funds, real estate and rental property.
Data TypeDECIMAL(14 , 2)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 OTHER_DEBT_AMOUNT
DescriptionThe amount in non-mortgage debt outstanding upon the death of policyholder.
Data TypeDECIMAL(14 , 2)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 NUMBER_OF_COVERAGE_YEARS
DescriptionThe number of years coverage specified by the policy.
Data TypeDECIMAL(20 , 6)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 PERSON_ID
DescriptionIdentifies the Person dimension of this Fact Entity.
Data TypeBIGINT
Default ValueNone
Is Primary Keytrue
Is Identityfalse
Is Nullablefalse
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 HOUSEHOLD_ID
DescriptionIdentifies the Household dimension of this Fact Entity.
Data TypeBIGINT
Default ValueNone
Is Primary Keytrue
Is Identityfalse
Is Nullablefalse
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 GEOGRAPHIC_AREA_ID
DescriptionIdentifies the Geographic Area dimension of this Fact Entity.
Data TypeBIGINT
Default ValueNone
Is Primary Keytrue
Is Identityfalse
Is Nullablefalse
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 CALENDAR_DATE_ID
DescriptionIdentifies the Calendar date dimension of this Fact Entity.
Data TypeBIGINT
Default ValueNone
Is Primary Keytrue
Is Identityfalse
Is Nullablefalse
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 PERSON_MINI_DIMENSION_ID
DescriptionIdentifies the Person mini dimension of this Fact Entity.
Data TypeBIGINT
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 HOUSEHOLD_MINI_DIMENSION_ID
DescriptionIdentifies the Household mini dimension of this Fact Entity.
Data TypeBIGINT
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 GEOGRAPHIC_AREA_MINI_DIMENSION_ID
DescriptionIdentifies the Geographic Area Mini Dimension of this Fact Entity.
Data TypeBIGINT
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 POPULATION_TIMESTAMP
DescriptionA timestamp that identifies when this Fact Entity's instance was populated
Data TypeTIMESTAMP
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 CLAIMS_AMOUNT
Data TypeDECIMAL(14 , 2)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 CLAIMS_COUNT
Data TypeINTEGER
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 DISPOSABLE_INCOME
DescriptionThe amount of money that this household can spend after having paid all the fixed expenses such as rent, mortgage repayment and so on.
This information should be provided by the household when not all composing elements for calculating the disposable income are available.
Data TypeDECIMAL(14 , 2)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 CUSTOMER_ID
DescriptionThe unique identifier of the Customer
Data TypeBIGINT
Default ValueNone
Is Primary Keytrue
Is Identityfalse
Is Nullablefalse
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 NUMBER_OF_POLICIES
DescriptionTotal number of policies owned by a person at the Reference date.
Data TypeINTEGER
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 NUMBER_OF_CANCELLED_POLICIES
DescriptionTotal number of policies cancelled by a person at the Reference date.
Data TypeINTEGER
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 NUMBER_OF_CLAIMS_DENIED
DescriptionIdentfies the length of time between a policy inception and event date to ascertain claims made shortly after policy inception.
Data TypeINTEGER
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 TENURE
DescriptionThe time (usually in months) that this person has been a customer with the company
Data TypeINTEGER
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 YEARS_SINCE_DRIVERS_LICENSE_OBTAINED
DescriptionThe age of the person.
Data TypeINTEGER
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 MONTHS_SINCE_LAST_ADDRESS_CHANGE
DescriptionThe age of the person.
Data TypeINTEGER
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse

Foreign Key Details

 PERSON_VA_CALEN_FK
Referential Integrity: On UpdateNO_ACTION
Referential Integrity: On DeleteNO_ACTION
Is Identifying Relationshiptrue
Child TablePERSON_VALUE_FACT
Child Role Namehas for dimension
Child Multiplicity*
Key ColumnCALENDAR_DATE_ID [BIGINT]
Parent TableCALENDAR_DATE
Parent Role Nameis dimension of
Parent Multiplicity1
Unique ConstraintCALENDAR_DATE_PK



 PERSON_V_GEOGRA_FK
Referential Integrity: On UpdateNO_ACTION
Referential Integrity: On DeleteNO_ACTION
Is Identifying Relationshiptrue
Child TablePERSON_VALUE_FACT
Child Role Namehas for dimension
Child Multiplicity*
Key ColumnGEOGRAPHIC_AREA_ID [BIGINT]
Parent TableGEOGRAPHIC_AREA
Parent Role Nameis dimension of
Parent Multiplicity1
Unique ConstraintGEOGRAPHIC_AREA_PK



 PERSON_VAL_HOUS_FK
Referential Integrity: On UpdateNO_ACTION
Referential Integrity: On DeleteNO_ACTION
Is Identifying Relationshiptrue
Child TablePERSON_VALUE_FACT
Child Role Namehas for dimension
Child Multiplicity*
Key ColumnHOUSEHOLD_ID [BIGINT]
Parent TableHOUSEHOLD
Parent Role Nameis dimension of
Parent Multiplicity1
Unique ConstraintHOUSEHOLD_PK



 PERSON_VAL_PERS_FK
Referential Integrity: On UpdateNO_ACTION
Referential Integrity: On DeleteNO_ACTION
Is Identifying Relationshiptrue
Child TablePERSON_VALUE_FACT
Child Role Namehas for dimension
Child Multiplicity*
Key ColumnPERSON_ID [BIGINT]
Parent TablePERSON
Parent Role Nameis dimension of
Parent Multiplicity1
Unique ConstraintPERSON_PK



 PERS_HOUSEHOLD__FK
Referential Integrity: On UpdateNO_ACTION
Referential Integrity: On DeleteNO_ACTION
Is Identifying Relationshipfalse
Child TablePERSON_VALUE_FACT
Child Role Namehas for dimension
Child Multiplicity*
Key ColumnHOUSEHOLD_MINI_DIMENSION_ID [BIGINT]
Parent TableHOUSEHOLD_MINI_DIMENSION
Parent Role Nameis dimension of
Parent Multiplicity0..1
Unique ConstraintHOUSEHOLD_MINI_DIMENSION_PK



 PERSO_PERSON_MI_F1
Referential Integrity: On UpdateNO_ACTION
Referential Integrity: On DeleteNO_ACTION
Is Identifying Relationshipfalse
Child TablePERSON_VALUE_FACT
Child Role Namehas for dimension
Child Multiplicity*
Key ColumnPERSON_MINI_DIMENSION_ID [BIGINT]
Parent TablePERSON_MINI_DIMENSION
Parent Role Nameis dimension of
Parent Multiplicity0..1
Unique ConstraintPERSON_MINI_DIMENSION_PK



 PERS_GEOGRAPHIC_FK
Referential Integrity: On UpdateNO_ACTION
Referential Integrity: On DeleteNO_ACTION
Is Identifying Relationshipfalse
Child TablePERSON_VALUE_FACT
Child Role Namehas for dimension
Child Multiplicity*
Key ColumnGEOGRAPHIC_AREA_MINI_DIMENSION_ID [BIGINT]
Parent TableGEOGRAPHIC_AREA_MINI_DIMENSION
Parent Role Nameis dimension of
Parent Multiplicity0..1
Unique ConstraintGEOGRAPHIC_AREA_MINI_DIMENSION_PK



 PERSON_VAL_CUST_FK
Referential Integrity: On UpdateNO_ACTION
Referential Integrity: On DeleteNO_ACTION
Is Identifying Relationshiptrue
Child TablePERSON_VALUE_FACT
Child Role NameVerb1
Child Multiplicity*
Key ColumnCUSTOMER_ID [BIGINT]
Parent TableCUSTOMER
Parent Multiplicity1
Unique ConstraintCUSTOMER_PK

Primary Key Details

 PERSON_VALUE_FACT_PK
DescriptionThe unique identifier of the Person value Fact
MemberCALENDAR_DATE_ID [BIGINT]
MemberGEOGRAPHIC_AREA_ID [BIGINT]
MemberHOUSEHOLD_ID [BIGINT]
MemberPERSON_ID [BIGINT]
MemberCUSTOMER_ID [BIGINT]