Table INDIVIDUAL_SNAPSHOT_FACT

DescriptionIndividual Snapshot Fact is a fact entity recording a snapshot of the key measures relating to Individuals.

Columns
CALENDAR_DATE_DIMENSION_IDCALENDAR_DATE_DIMENSION_ID
DNMN_CCY_DIM_IDDNMN_CCY_DIM_ID
CST_SEG_MINI_DIM_IDCST_SEG_MINI_DIM_ID
LMT_MINI_DIM_IDLMT_MINI_DIM_ID
INDIVIDUAL_CUSTOMER_DIMENSION_IDINDIVIDUAL_CUSTOMER_DIMENSION_ID
CHANNEL_DIMENSION_IDCHANNEL_DIMENSION_ID
DBT_TO_CR_LMT_RTODBT_TO_CR_LMT_RTO
EXG_RATE_TO_ORIG_CCYEXG_RATE_TO_ORIG_CCY
IDV_AGEIDV_AGE
IDV_ANUL_SLRY_AMTIDV_ANUL_SLRY_AMT
IDV_FNC_AST_AMTIDV_FNC_AST_AMT
IDV_LBY_AMTIDV_LBY_AMT
IDV_LQD_NET_WRTHIDV_LQD_NET_WRTH
IDV_NET_WRTHIDV_NET_WRTH
IDV_OTHR_ANUL_INCM_AMTIDV_OTHR_ANUL_INCM_AMT
IDV_OTHR_NFNC_AST_AMTIDV_OTHR_NFNC_AST_AMT
IDV_REAL_PTY_AST_AMTIDV_REAL_PTY_AST_AMT
MO_HSG_COST_AMTMO_HSG_COST_AMT
MO_INCM_AF_TAX_AMTMO_INCM_AF_TAX_AMT
MO_NON_MRTG_CR_PYMT_AMTMO_NON_MRTG_CR_PYMT_AMT
MO_NON_MRTG_CR_TO_INCM_RTOMO_NON_MRTG_CR_TO_INCM_RTO
NBR_OF_DPNDNBR_OF_DPND
NBR_OF_DPND_CHLNBR_OF_DPND_CHL
NBR_OF_DRMT_CC_ARNBR_OF_DRMT_CC_AR
NBR_OF_HARD_INQRNBR_OF_HARD_INQR
NBR_OF_SOFT_INQRNBR_OF_SOFT_INQR
NOY_AT_CRN_ADRNOY_AT_CRN_ADR
PPN_TMSPPN_TMS

Foreign Key
INDIVIDUAL_SNAPSHOT_FACT_CALENDAR_DATE_DIMENSION_FKINDIVIDUAL_SNAPSHOT_FACT_CALENDAR_DATE_DIMENSION_FK
INDIVIDUAL_SNAPSHOT_FACT_INDIVIDUAL_CUSTOMER_DIMENSION_FKINDIVIDUAL_SNAPSHOT_FACT_INDIVIDUAL_CUSTOMER_DIMENSION_FK

Indexes
INDIVIDUAL_SNAPSHOT_FACT_CALENDAR_DATE_DIMENSION_ID_IDXINDIVIDUAL_SNAPSHOT_FACT_CALENDAR_DATE_DIMENSION_ID_IDX

Column Details

 CALENDAR_DATE_DIMENSION_ID
DescriptionThe unique identifier of the Calendar Date Dimension.
Data TypeINTEGER
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullablefalse
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 DNMN_CCY_DIM_ID
DescriptionThe unique identifier of the Denomination Currency Dimension. It indicates the Currency in which the monetary amounts are expressed.
Data TypeINTEGER
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 CST_SEG_MINI_DIM_ID
DescriptionThe unique identifier of the customer segmentation mini dimension.
Data TypeINTEGER
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 LMT_MINI_DIM_ID
DescriptionThe unique identifier of the Limit Mini dimension.
Data TypeINTEGER
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 INDIVIDUAL_CUSTOMER_DIMENSION_ID
DescriptionThe unique identifier of the Individual Dimension.
Data TypeINTEGER
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullablefalse
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 CHANNEL_DIMENSION_ID
DescriptionThe unique identifier of the Original Currency Dimension. It indicates the currency in which the monetary amounts were originally expressed.
Data TypeINTEGER
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 DBT_TO_CR_LMT_RTO
DescriptionA measure that identifies the utilization of the Credit extended to an Involved Party. The Debt To Credit Limit Ratio is used to establish the Line Of Credit Utilization Segment, and is usually calculated monthly in respect of Account Facility Finance Service Arrangements.
Data TypeDECIMAL(6 , 2)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 EXG_RATE_TO_ORIG_CCY
DescriptionA measure that identifies the exchange rate used for translation out of the Denomination Currency back into an original currency.
Data TypeDECIMAL(12 , 7)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 IDV_AGE
DescriptionA measure that identifies the age of the Individual.
Data TypeINTEGER
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 IDV_ANUL_SLRY_AMT
DescriptionA measure that identifies the annual salary of the Individual.
Data TypeDECIMAL(15 , 2)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 IDV_FNC_AST_AMT
DescriptionA measure that identifies the amount of Financial Assets recorded for an Individual.
Data TypeDECIMAL(15 , 2)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 IDV_LBY_AMT
DescriptionA measure that identifies an Individual's debts amount.
Data TypeDECIMAL(15 , 2)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 IDV_LQD_NET_WRTH
DescriptionA measure that identifies an Individual's liquid assets minus liabilities. Liquid assets include cash, equities, bonds and instantly accessible deposit account balances.
Data TypeDECIMAL(15 , 2)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 IDV_NET_WRTH
DescriptionA measure that identifies an Individual's assets minus liabilities.
Data TypeDECIMAL(15 , 2)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 IDV_OTHR_ANUL_INCM_AMT
DescriptionA measure that identifies an Individual's secondary income. This may come from a second employment position, or dividends from holdings in stocks and shares, trusts etc.
Data TypeDECIMAL(15 , 2)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 IDV_OTHR_NFNC_AST_AMT
DescriptionA measure that identifies the assets of an Individual which are considered to be non-financial.
Data TypeDECIMAL(15 , 2)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 IDV_REAL_PTY_AST_AMT
DescriptionA measure that identifies the value of parcels of land and all physical property related to it, that belong to the Individual.
Data TypeDECIMAL(15 , 2)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 MO_HSG_COST_AMT
DescriptionA measure that indicates the monthly cost of housing for the Individual.
Data TypeDECIMAL(15 , 2)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 MO_INCM_AF_TAX_AMT
DescriptionA measure that identifies an Individual's Monthly Income After Tax.
Data TypeDECIMAL(15 , 2)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 MO_NON_MRTG_CR_PYMT_AMT
DescriptionA measure that identifies an Individual's Monthly Non Mortgage Credit Payments, such as payments for loans, hire purchasing and Credit Cards.
Data TypeDECIMAL(15 , 2)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 MO_NON_MRTG_CR_TO_INCM_RTO
DescriptionA measure that identifies an Individual's Monthly Non Mortgage Credit To Income Ratio, which is the ratio of an Individual's Non Mortgage Credit Payments to Income After Tax. The greater the Non Mortgage Credit To Income Ratio, the more adverse the effect is upon the Individual's Credit Score.
Data TypeDECIMAL(6 , 2)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 NBR_OF_DPND
DescriptionA measure that identifies the number of people who are dependent on the Individual for support, including the count of dependent children.
Data TypeSMALLINT
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 NBR_OF_DPND_CHL
DescriptionA measure that identifies the number of children who are dependent on the Individual for support.
Data TypeSMALLINT
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 NBR_OF_DRMT_CC_AR
DescriptionA measure that identifies the number of Credit Card Arrangements which have not been used for a specified time. This information can be obtained by inspection of an Individual's Credit Card Arrangements with the Bank and those listed on the individual's Credit Report. The greater the number of dormant Credit Card Arrangements, the more adverse the effect is upon the Individual's Credit Score and the Bank's perception of the Individual's credit worthiness.
Data TypeSMALLINT
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 NBR_OF_HARD_INQR
DescriptionA measure that identifies the number of Hard Inquiries made on an Individual's Credit Report. Hard Inquiries arise from the Individual's requests for credit, and the greater the number the more adverse the effect is upon the Individual's Credit Score.
Data TypeSMALLINT
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 NBR_OF_SOFT_INQR
DescriptionA measure that identifies the number of Soft Inquiries made on an Individual's Credit Report. Soft Inquiries do not arise from the Individual's requests for credit, and have no effect upon the Individual's Credit Score. For example, an inquiry from an Individual who is checking their own Credit Report.
Data TypeSMALLINT
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 NOY_AT_CRN_ADR
DescriptionA measure that identifies the number of years the Individual has been resident at the current address.
Data TypeINTEGER
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 PPN_TMS
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

Foreign Key Details

 INDIVIDUAL_SNAPSHOT_FACT_CALENDAR_DATE_DIMENSION_FK
Referential Integrity: On UpdateNO_ACTION
Referential Integrity: On DeleteNO_ACTION
Is Identifying Relationshipfalse
Child TableINDIVIDUAL_SNAPSHOT_FACT
Child Multiplicity*
Key ColumnCALENDAR_DATE_DIMENSION_ID [INTEGER]
Parent TableCALENDAR_DATE_DIMENSION
Parent Multiplicity0..1
Unique ConstraintCALENDAR_DATE_DIMENSION_PK



 INDIVIDUAL_SNAPSHOT_FACT_INDIVIDUAL_CUSTOMER_DIMENSION_FK
Referential Integrity: On UpdateNO_ACTION
Referential Integrity: On DeleteNO_ACTION
Is Identifying Relationshipfalse
Child TableINDIVIDUAL_SNAPSHOT_FACT
Child Multiplicity*
Key ColumnINDIVIDUAL_CUSTOMER_DIMENSION_ID [INTEGER]
Parent TableINDIVIDUAL_CUSTOMER_DIMENSION
Parent Multiplicity0..1
Unique ConstraintINDIVIDUAL_CUSTOMER_DIMENSION_PK

Index Details

 INDIVIDUAL_SNAPSHOT_FACT_CALENDAR_DATE_DIMENSION_ID_IDX
Is Uniquetrue
Is Clusteredfalse
MemberCALENDAR_DATE_DIMENSION_ID [INTEGER] Ascending
MemberINDIVIDUAL_CUSTOMER_DIMENSION_ID [INTEGER] Ascending