| WEALTH Data Model |
Description | Individual Snapshot Fact is a fact entity recording a snapshot of the key measures relating to Individuals. |
Foreign Key | |
![]() |
|
![]() |
|
![]() |
|
![]() |
Primary Key | |
![]() |
Indexes | |
![]() |
Column Details |
Description | The unique identifier of the Calendar Date Dimension. |
Data Type | BIGINT |
Default Value | None |
Is Primary Key | true |
Is Identity | false |
Is Nullable | false |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | The unique identifier of the Denomination Currency Dimension. It indicates the Currency in which the monetary amounts are expressed. |
Data Type | BIGINT |
Default Value | None |
Is Primary Key | true |
Is Identity | false |
Is Nullable | false |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | The unique identifier of the Individual Segment Mini Dimension. |
Data Type | BIGINT |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | The unique identifier of the Individual Status Mini Dimension. |
Data Type | BIGINT |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | The unique identifier of the Individual Customer Dimension. |
Data Type | BIGINT |
Default Value | None |
Is Primary Key | true |
Is Identity | false |
Is Nullable | false |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | The unique identifier of the Original Currency Dimension. It indicates the currency in which the monetary amounts were originally expressed. |
Data Type | BIGINT |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | A 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 Type | DECIMAL(5 , 2) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | A measure that identifies the exchange rate used for translation out of the Denomination Currency back into an original currency. |
Data Type | DECIMAL(5 , 2) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | A measure that identifies the age of the Individual. |
Data Type | INTEGER |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | A measure that identifies the annual salary of the Individual. |
Data Type | DECIMAL(20 , 5) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | A measure that identifies the amount of Financial Assets recorded for an Individual. |
Data Type | DECIMAL(20 , 5) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | A measure that identifies an Individual's debts amount. |
Data Type | DECIMAL(20 , 5) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | A measure that identifies an Individual's liquid assets minus liabilities. Liquid assets include cash, equities, bonds and instantly accessible deposit account balances. |
Data Type | DECIMAL(20 , 5) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | A measure that identifies an Individual's assets minus liabilities. |
Data Type | DECIMAL(20 , 5) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | A 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 Type | DECIMAL(20 , 5) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | A measure that identifies an Individual's non financial assets value. |
Data Type | DECIMAL(20 , 5) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | A measure that identifies the value of parcels of land and all physical property related to it, that belong to the Individual. |
Data Type | DECIMAL(20 , 5) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | A measure that indicates the monthly cost of housing for the Individual. |
Data Type | DECIMAL(20 , 5) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | A measure that identifies an Individual's Monthly Income After Tax. |
Data Type | DECIMAL(20 , 5) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | A measure that identifies an Individual's Monthly Non Mortgage Credit Payments, such as payments for loans, hire purchasing and Credit Cards. |
Data Type | DECIMAL(20 , 5) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | A 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 Type | DECIMAL(5 , 2) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | A measure that identifies the number of people who are dependent on the Individual for support, including the count of dependent children. |
Data Type | INTEGER |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | A measure that identifies the number of children who are dependent on the Individual for support. |
Data Type | INTEGER |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | A 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 Type | INTEGER |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | A 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 Type | INTEGER |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | A 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 Type | INTEGER |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | A measure that identifies the number of years the Individual has been resident at the current address. |
Data Type | INTEGER |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | A timestamp that identifies when this Fact Entity's instance was populated. |
Data Type | TIMESTAMP |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | Unique identifier of the network dimension. |
Data Type | INTEGER |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | This measure identifies the total amount invested by the Individual in Stocks |
Data Type | DECIMAL(20 , 5) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | This measure identifies the total amount invested by the Individual in Bonds |
Data Type | DECIMAL(20 , 5) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | This measure identifies the total amount invested by the Individual in Money Market |
Data Type | DECIMAL(20 , 5) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | This measure identifies the total amount invested by the Individual in Forex |
Data Type | DECIMAL(20 , 5) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | This measure identifies the total amount invested by the Individual in MLP Funds |
Data Type | DECIMAL(20 , 5) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | This measure identifies the total amount invested by the Individual in Commodity Funds |
Data Type | DECIMAL(20 , 5) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | This measure identifies the total amount invested by the Individual in Derivatives |
Data Type | DECIMAL(20 , 5) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | This measure identifies the total amount traded by the Individual in Stocks |
Data Type | DECIMAL(20 , 5) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | This measure identifies the total amount traded by the Individual in Bonds |
Data Type | DECIMAL(20 , 5) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | This measure identifies the total amount traded by the Individual in Money Market |
Data Type | DECIMAL(20 , 5) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | This measure identifies the total amount traded by the Individual in Others (High Risk categories) |
Data Type | DECIMAL(20 , 5) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | This measure identifies the total amount invested by the Individual |
Data Type | DECIMAL(20 , 5) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | This measure identifies the total amount invested by Individual through methodical approach |
Data Type | DECIMAL(20 , 5) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | This measure identifies the total amount invested by Individual through Lumpy pattern |
Data Type | DECIMAL(20 , 5) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | This measure identifies the total amount invested by Individual through Rarely pattern |
Data Type | DECIMAL(20 , 5) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | This measure identifies the total number of interactions over a week. |
Data Type | INTEGER |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | This measure identifies the total number of interactions over an year. |
Data Type | INTEGER |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | This measure identifies the total number of infrequent interactions. |
Data Type | INTEGER |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | This measure identifies the total amount invested by the Individual in Others (other high risk categories) |
Data Type | DECIMAL(20 , 5) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Foreign Key Details |
Referential Integrity: On Update | NO_ACTION |
Referential Integrity: On Delete | CASCADE |
Is Identifying Relationship | false |
Child Table | INDIVIDUAL_SNAPSHOT_FACT |
Child Multiplicity | * |
Key Column | NETWORTH_DIMENSION_ID [INTEGER] |
Parent Table | NETWORTH_DIMENSION |
Parent Multiplicity | 0..1 |
Unique Constraint | NETWORTH_DIMENSIO1 |
Referential Integrity: On Update | NO_ACTION |
Referential Integrity: On Delete | NO_ACTION |
Is Identifying Relationship | false |
Child Table | INDIVIDUAL_SNAPSHOT_FACT |
Child Multiplicity | * |
Key Column | LIMIT_MINI_DIMENSION_ID [BIGINT] |
Parent Table | LIMIT_MINI_DIMENSION |
Parent Multiplicity | 0..1 |
Unique Constraint | LIMIT_MINI_DIMENSION_PK |
Referential Integrity: On Update | NO_ACTION |
Referential Integrity: On Delete | NO_ACTION |
Is Identifying Relationship | true |
Child Table | INDIVIDUAL_SNAPSHOT_FACT |
Child Multiplicity | * |
Key Column | CALENDAR_DATE_DIMENSION_ID [BIGINT] |
Parent Table | CALENDAR_DATE_DIMENSION |
Parent Multiplicity | 0..1 |
Unique Constraint | CALENDAR_DATE_DIMENSION_PK |
Referential Integrity: On Update | NO_ACTION |
Referential Integrity: On Delete | NO_ACTION |
Is Identifying Relationship | true |
Child Table | INDIVIDUAL_SNAPSHOT_FACT |
Child Multiplicity | * |
Key Column | INDIVIDUAL_CUSTOMER_DIMENSION_ID [BIGINT] |
Parent Table | INDIVIDUAL_CUSTOMER_DIMENSION |
Parent Multiplicity | 0..1 |
Unique Constraint | INDIVIDUAL_CUSTOMER_DIMENSION_PK |
Primary Key Details |
Description | The unique identifier of the Individual Snapshot fact table. |
Member | CALENDAR_DATE_DIMENSION_ID [BIGINT] |
Member | DENOMINATION_CURRENCY_DIMENSION_ID [BIGINT] |
Member | INDIVIDUAL_CUSTOMER_DIMENSION_ID [BIGINT] |
Index Details |
Is Unique | true |
Is Clustered | false |
Member | CALENDAR_DATE_DIMENSION_ID [BIGINT] Ascending |
Member | DENOMINATION_CURRENCY_DIMENSION_ID [BIGINT] Ascending |
Member | INDIVIDUAL_CUSTOMER_DIMENSION_ID [BIGINT] Ascending |
| WEALTH Data Model |