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
DENOMINATION_CURRENCY_DIMENSION_IDDENOMINATION_CURRENCY_DIMENSION_ID
CUSTOMER_SEGMENT_MINI_DIMENSION_IDCUSTOMER_SEGMENT_MINI_DIMENSION_ID
LIMIT_MINI_DIMENSION_IDLIMIT_MINI_DIMENSION_ID
INDIVIDUAL_CUSTOMER_DIMENSION_IDINDIVIDUAL_CUSTOMER_DIMENSION_ID
CHANNEL_DIMENSION_IDCHANNEL_DIMENSION_ID
DEBT_TO_CREDIT_LIMIT_RATIODEBT_TO_CREDIT_LIMIT_RATIO
EXCHANGE_RATE_TO_ORIGINAL_CURRENCYEXCHANGE_RATE_TO_ORIGINAL_CURRENCY
INDIVIDUAL_AGEINDIVIDUAL_AGE
INDIVIDUAL_ANNUAL_SALARY_AMOUNTINDIVIDUAL_ANNUAL_SALARY_AMOUNT
INDIVIDUAL_FINANCIAL_ASSETS_AMOUNTINDIVIDUAL_FINANCIAL_ASSETS_AMOUNT
INDIVIDUAL_LIABILITIES_AMOUNTINDIVIDUAL_LIABILITIES_AMOUNT
INDIVIDUAL_LIQUID_NET_WORTHINDIVIDUAL_LIQUID_NET_WORTH
INDIVIDUAL_NET_WORTHINDIVIDUAL_NET_WORTH
INDIVIDUAL_OTHER_ANNUAL_INCOME_AMOUNTINDIVIDUAL_OTHER_ANNUAL_INCOME_AMOUNT
INDIVIDUAL_OTHER_NONFINANCIAL_ASSETS_AMOUNTINDIVIDUAL_OTHER_NONFINANCIAL_ASSETS_AMOUNT
INDIVIDUAL_REAL_PROPERTY_ASSETS_AMOUNTINDIVIDUAL_REAL_PROPERTY_ASSETS_AMOUNT
MONTHLY_HOUSING_COST_AMOUNTMONTHLY_HOUSING_COST_AMOUNT
MONTHLY_INCOME_AFTER_TAX_AMOUNTMONTHLY_INCOME_AFTER_TAX_AMOUNT
MONTHLY_NON_MORTGAGE_CREDIT_PAYMENT_AMOUNTMONTHLY_NON_MORTGAGE_CREDIT_PAYMENT_AMOUNT
MONTHLY_NON_MORTGAGE_CREDIT_TO_INCOME_RATIOMONTHLY_NON_MORTGAGE_CREDIT_TO_INCOME_RATIO
NUMBER_OF_DEPENDANTSNUMBER_OF_DEPENDANTS
NUMBER_OF_DEPENDENT_CHILDRENNUMBER_OF_DEPENDENT_CHILDREN
NUMBER_OF_DORMANT_CREDIT_CARD_ARRANGEMENTSNUMBER_OF_DORMANT_CREDIT_CARD_ARRANGEMENTS
NUMBER_OF_HARD_INQUIRIESNUMBER_OF_HARD_INQUIRIES
NUMBER_OF_SOFT_INQUIRIESNUMBER_OF_SOFT_INQUIRIES
NUMBER_OF_YEARS_AT_CURRENT_ADDRESSNUMBER_OF_YEARS_AT_CURRENT_ADDRESS
POPULATION_TIMESTAMPPOPULATION_TIMESTAMP
NETWORTH_DIMENSION_IDNETWORTH_DIMENSION_ID
TOTAL_AMOUNT_IN_STOCKSTOTAL_AMOUNT_IN_STOCKS
TOTAL_AMOUNT_IN_BONDSTOTAL_AMOUNT_IN_BONDS
TOTAL_AMOUNT_IN_MONEY_MARKETTOTAL_AMOUNT_IN_MONEY_MARKET
TOTAL_AMOUNT_IN_FOREXTOTAL_AMOUNT_IN_FOREX
TOTAL_AMOUNT_IN_MLP_FUNDSTOTAL_AMOUNT_IN_MLP_FUNDS
TOTAL_AMOUNT_IN_COMMODITY_FUNDSTOTAL_AMOUNT_IN_COMMODITY_FUNDS
TOTAL_AMOUNT_IN_DERIVATIVESTOTAL_AMOUNT_IN_DERIVATIVES
TOTAL_AMOUNT_OF_TRADE_IN_STOCKSTOTAL_AMOUNT_OF_TRADE_IN_STOCKS
TOTAL_AMOUNT_OF_TRADE_IN_BONDSTOTAL_AMOUNT_OF_TRADE_IN_BONDS
TOTAL_AMOUNT_OF_TRADE_IN_MONEY_MARKETTOTAL_AMOUNT_OF_TRADE_IN_MONEY_MARKET
TOTAL_AMOUNT_OF_TRADE_IN_OTHERSTOTAL_AMOUNT_OF_TRADE_IN_OTHERS
TOTAL_FUNDINGTOTAL_FUNDING
TOTAL_AMOUNT_BY_METHODICALTOTAL_AMOUNT_BY_METHODICAL
TOTAL_AMOUNT_BY_LUMPYTOTAL_AMOUNT_BY_LUMPY
TOTAL_AMOUNT_BY_RARELYTOTAL_AMOUNT_BY_RARELY
TOTAL_NUMBER_OF_WEEKLY_INTERACTIONSTOTAL_NUMBER_OF_WEEKLY_INTERACTIONS
TOTAL_NUMBER_OF_YEARLY_INTERACTIONSTOTAL_NUMBER_OF_YEARLY_INTERACTIONS
TOTAL_NUMBER_OF_INFREQUENT_INTERACTIONSTOTAL_NUMBER_OF_INFREQUENT_INTERACTIONS
TOTAL_AMOUNT_IN_OTHERSTOTAL_AMOUNT_IN_OTHERS

Foreign Key
INDIVIDUAL_NETW_FKINDIVIDUAL_NETW_FK
INDIVIDUA_LIMIT_FKINDIVIDUA_LIMIT_FK
INDIVID_CALEND_FKINDIVID_CALEND_FK
INDI_INDIVIDUA_FKINDI_INDIVIDUA_FK

Primary Key
INDIVIDUAL_SNAPSHOT_FACT_PKINDIVIDUAL_SNAPSHOT_FACT_PK

Indexes
INDIVIDUAL_SNAPSHOT_FACT_PKINDIVIDUAL_SNAPSHOT_FACT_PK

Column Details

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



 DENOMINATION_CURRENCY_DIMENSION_ID
DescriptionThe unique identifier of the Denomination Currency Dimension. It indicates the Currency in which the monetary amounts are expressed.
Data TypeBIGINT
Default ValueNone
Is Primary Keytrue
Is Identityfalse
Is Nullablefalse
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 CUSTOMER_SEGMENT_MINI_DIMENSION_ID
DescriptionThe unique identifier of the Individual Segment Mini Dimension.
Data TypeBIGINT
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 LIMIT_MINI_DIMENSION_ID
DescriptionThe unique identifier of the Individual Status Mini Dimension.
Data TypeBIGINT
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 Customer Dimension.
Data TypeBIGINT
Default ValueNone
Is Primary Keytrue
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 TypeBIGINT
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 DEBT_TO_CREDIT_LIMIT_RATIO
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(5 , 2)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



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



 INDIVIDUAL_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



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



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



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



 INDIVIDUAL_LIQUID_NET_WORTH
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(20 , 5)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



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



 INDIVIDUAL_OTHER_ANNUAL_INCOME_AMOUNT
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(20 , 5)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 INDIVIDUAL_OTHER_NONFINANCIAL_ASSETS_AMOUNT
DescriptionA measure that identifies an Individual's non financial assets value.
Data TypeDECIMAL(20 , 5)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



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



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



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



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



 MONTHLY_NON_MORTGAGE_CREDIT_TO_INCOME_RATIO
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(5 , 2)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



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



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



 NUMBER_OF_DORMANT_CREDIT_CARD_ARRANGEMENTS
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 TypeINTEGER
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 NUMBER_OF_HARD_INQUIRIES
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 TypeINTEGER
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 NUMBER_OF_SOFT_INQUIRIES
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 TypeINTEGER
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 NUMBER_OF_YEARS_AT_CURRENT_ADDRESS
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



 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



 NETWORTH_DIMENSION_ID
DescriptionUnique identifier of the network dimension.
Data TypeINTEGER
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 TOTAL_AMOUNT_IN_STOCKS
DescriptionThis measure identifies the total amount invested by the Individual in Stocks
Data TypeDECIMAL(20 , 5)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 TOTAL_AMOUNT_IN_BONDS
DescriptionThis measure identifies the total amount invested by the Individual in Bonds
Data TypeDECIMAL(20 , 5)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 TOTAL_AMOUNT_IN_MONEY_MARKET
DescriptionThis measure identifies the total amount invested by the Individual in Money Market
Data TypeDECIMAL(20 , 5)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 TOTAL_AMOUNT_IN_FOREX
DescriptionThis measure identifies the total amount invested by the Individual in Forex
Data TypeDECIMAL(20 , 5)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 TOTAL_AMOUNT_IN_MLP_FUNDS
DescriptionThis measure identifies the total amount invested by the Individual in MLP Funds
Data TypeDECIMAL(20 , 5)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 TOTAL_AMOUNT_IN_COMMODITY_FUNDS
DescriptionThis measure identifies the total amount invested by the Individual in Commodity Funds
Data TypeDECIMAL(20 , 5)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 TOTAL_AMOUNT_IN_DERIVATIVES
DescriptionThis measure identifies the total amount invested by the Individual in Derivatives
Data TypeDECIMAL(20 , 5)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 TOTAL_AMOUNT_OF_TRADE_IN_STOCKS
DescriptionThis measure identifies the total amount traded by the Individual in Stocks
Data TypeDECIMAL(20 , 5)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 TOTAL_AMOUNT_OF_TRADE_IN_BONDS
DescriptionThis measure identifies the total amount traded by the Individual in Bonds
Data TypeDECIMAL(20 , 5)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 TOTAL_AMOUNT_OF_TRADE_IN_MONEY_MARKET
DescriptionThis measure identifies the total amount traded by the Individual in Money Market
Data TypeDECIMAL(20 , 5)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 TOTAL_AMOUNT_OF_TRADE_IN_OTHERS
DescriptionThis measure identifies the total amount traded by the Individual in Others (High Risk categories)
Data TypeDECIMAL(20 , 5)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 TOTAL_FUNDING
DescriptionThis measure identifies the total amount invested by the Individual
Data TypeDECIMAL(20 , 5)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 TOTAL_AMOUNT_BY_METHODICAL
DescriptionThis measure identifies the total amount invested by Individual through methodical approach
Data TypeDECIMAL(20 , 5)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 TOTAL_AMOUNT_BY_LUMPY
DescriptionThis measure identifies the total amount invested by Individual through Lumpy pattern
Data TypeDECIMAL(20 , 5)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 TOTAL_AMOUNT_BY_RARELY
DescriptionThis measure identifies the total amount invested by Individual through Rarely pattern
Data TypeDECIMAL(20 , 5)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 TOTAL_NUMBER_OF_WEEKLY_INTERACTIONS
DescriptionThis measure identifies the total number of interactions over a week.
Data TypeINTEGER
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 TOTAL_NUMBER_OF_YEARLY_INTERACTIONS
DescriptionThis measure identifies the total number of interactions over an year.
Data TypeINTEGER
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 TOTAL_NUMBER_OF_INFREQUENT_INTERACTIONS
DescriptionThis measure identifies the total number of infrequent interactions.
Data TypeINTEGER
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 TOTAL_AMOUNT_IN_OTHERS
DescriptionThis measure identifies the total amount invested by the Individual in Others (other high risk categories)
Data TypeDECIMAL(20 , 5)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse

Foreign Key Details

 INDIVIDUAL_NETW_FK
Referential Integrity: On UpdateNO_ACTION
Referential Integrity: On DeleteCASCADE
Is Identifying Relationshipfalse
Child TableINDIVIDUAL_SNAPSHOT_FACT
Child Multiplicity*
Key ColumnNETWORTH_DIMENSION_ID [INTEGER]
Parent TableNETWORTH_DIMENSION
Parent Multiplicity0..1
Unique ConstraintNETWORTH_DIMENSIO1



 INDIVIDUA_LIMIT_FK
Referential Integrity: On UpdateNO_ACTION
Referential Integrity: On DeleteNO_ACTION
Is Identifying Relationshipfalse
Child TableINDIVIDUAL_SNAPSHOT_FACT
Child Multiplicity*
Key ColumnLIMIT_MINI_DIMENSION_ID [BIGINT]
Parent TableLIMIT_MINI_DIMENSION
Parent Multiplicity0..1
Unique ConstraintLIMIT_MINI_DIMENSION_PK



 INDIVID_CALEND_FK
Referential Integrity: On UpdateNO_ACTION
Referential Integrity: On DeleteNO_ACTION
Is Identifying Relationshiptrue
Child TableINDIVIDUAL_SNAPSHOT_FACT
Child Multiplicity*
Key ColumnCALENDAR_DATE_DIMENSION_ID [BIGINT]
Parent TableCALENDAR_DATE_DIMENSION
Parent Multiplicity0..1
Unique ConstraintCALENDAR_DATE_DIMENSION_PK



 INDI_INDIVIDUA_FK
Referential Integrity: On UpdateNO_ACTION
Referential Integrity: On DeleteNO_ACTION
Is Identifying Relationshiptrue
Child TableINDIVIDUAL_SNAPSHOT_FACT
Child Multiplicity*
Key ColumnINDIVIDUAL_CUSTOMER_DIMENSION_ID [BIGINT]
Parent TableINDIVIDUAL_CUSTOMER_DIMENSION
Parent Multiplicity0..1
Unique ConstraintINDIVIDUAL_CUSTOMER_DIMENSION_PK

Primary Key Details

 INDIVIDUAL_SNAPSHOT_FACT_PK
DescriptionThe unique identifier of the Individual Snapshot fact table.
MemberCALENDAR_DATE_DIMENSION_ID [BIGINT]
MemberDENOMINATION_CURRENCY_DIMENSION_ID [BIGINT]
MemberINDIVIDUAL_CUSTOMER_DIMENSION_ID [BIGINT]

Index Details

 INDIVIDUAL_SNAPSHOT_FACT_PK
Is Uniquetrue
Is Clusteredfalse
MemberCALENDAR_DATE_DIMENSION_ID [BIGINT] Ascending
MemberDENOMINATION_CURRENCY_DIMENSION_ID [BIGINT] Ascending
MemberINDIVIDUAL_CUSTOMER_DIMENSION_ID [BIGINT] Ascending