| WEALTH Data Model |
Description | Individual Customer identifies an Individual that is eligible to avail itself of the Financial Institution's Products and Services. |
Foreign Key | |
![]() |
Primary Key | |
![]() |
Indexes | |
![]() |
Column Details |
Description | The unique identifier of the Individual Customer Dimension. |
Data Type | BIGINT |
Default Value | None |
Is Primary Key | true |
Is Identity | true |
Is Nullable | false |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Description | The unique identifier of the Calendar Date 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 Denomination Currency 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 | Birth Date indicates the calendar date associated with the Individual's Date Of Birth. |
Data Type | DATE |
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 | Employer Name indicates the entire and complete name of the subject Employer; for example, 'Incorporated Township of East Quincy', 'International Business Machines Corporation' , 'XYZ Limited Partnership for Fossil Fuel Exploration'. |
Data Type | VARCHAR(50) |
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 | Employment Title indicates the employment position held by the Individual Customer. |
Data Type | VARCHAR(50) |
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 | First Name indicates an Individual Customer's name component that is chosen and assigned to the Individual Customer at his or her birth, usually by the parent(s); for example, John, Jurgen, Helga or Jane. |
Data Type | VARCHAR(50) |
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 | Full Name indicates an Individual Customer's name component that comprises the entire and complete name of the subject Individual Customer; for example, 'John A. Doe'. |
Data Type | VARCHAR(50) |
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 | Identity Card Number indicates the number displayed on an identity card, which is used to uniquely identify the Individual Customer. Alternative cards can be identified through the Involved Party Card Holder. |
Data Type | CHAR(20) |
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 | Customer Number indicates the unique identifier of the Customer within the Financial Institution. |
Data Type | CHAR(20) |
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 | Description indicates a textual explanation or free form comments about the Individual Customer. |
Data Type | VARCHAR(2000) |
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 | Middle Name indicates an Individual Customer's name component that is the part of the name that typically follows sequentially the Given Name and precedes the Surname; for example, the Middle Name of Individual Customer #392837 (Edmund Fitzgerald Smythe) is 'Fitzgerald'. |
Data Type | VARCHAR(50) |
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 | Household Name indicates a label by which Household is known. |
Data Type | VARCHAR(50) |
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 | Identification Number indicates one or more numbers or codes by which an Individual can be identified. The identification item can be an industry recognized identifier, such as BIC (Bank Identification Code), SWIFT (Society for Worldwide Interbank Financial Telecommunication), ABA (American Bankers Association), BLZ (Bankleitzahl) or can be an internally generated password for employee use. The Individual can have one or more identification items from various sources. In this case, additional Alternative Identifications can be used. |
Data Type | CHAR(20) |
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 | Individual Risk Domicile indicates the Country where the Customer realizes the risk associated with their exposures. |
Data Type | VARCHAR(50) |
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 | Managed By Employee Name indicates the entire and complete name of the subject Employee; for example, 'John A. Doe'. |
Data Type | VARCHAR(50) |
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 | Managed By Employee Number indicates an identifier by which the Employee is known to the Financial Institution. |
Data Type | CHAR(50) |
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 | Name Initial indicates an Individual Customer's name component that is the part of the name that is comprised of the letter(s) of an Individual Customer's Name(s); for example, the Name Initial for Individual Customer # 432542 (Mary E Smythe) is 'E' . |
Data Type | CHAR(10) |
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 | Name Qualification is the part of a name that exists to show that the Individual Customer addressed has earned or possesses academic or professional certification or has reached a certain status or position in his or her profession; for example, PhD (Doctor of Philosophy), Chief Executive Officer (CEO), Vice President. |
Data Type | CHAR(50) |
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 | Photo indicates a picture of the Individual Customer produced by photography for identification purpose. |
Data Type | VARCHAR(2000) |
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 | Primary Account Name indicates the label given to a specific Account Arrangement. |
Data Type | VARCHAR(50) |
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 | Primary Account Number indicates the number of the Account Arrangement as defined by the Financial Institution. |
Data Type | CHAR(20) |
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 | Primary Branch Code indicates an internal code or business identifier used within the Financial Institution to identify the Individual Customer e.g. for accounting purposes. |
Data Type | CHAR(10) |
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 | Spouse Identification Number indicates one or more numbers or codes by which an Individual Customer can be identified. The identification item can be an industry recognized identifier, such as BIC (Bank Identification Code), SWIFT (Society for Worldwide Interbank Financial Telecommunication), ABA (American Bankers Association), BLZ (Bankleitzahl) or can be an internally generated password for employee use. The Individual Customer can have one or more identification items from various sources. In this case, additional Alternative Identifications can be used. |
Data Type | CHAR(20) |
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 | Primary Branch Name indicates the entire and complete name of the Individual Customer. |
Data Type | VARCHAR(50) |
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 | Primary Location indicates the name of the city where the Geographic Area is located. |
Data Type | VARCHAR(50) |
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 | Professional Title indicates the title assigned to the Individual based on his or her formal qualification regardless of position or relationship to product lines; for example, Professional Title is 'Dr' where the qualification is a 'PhD'. |
Data Type | CHAR(10) |
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 | Salutation indicates an Individual Customer's name component that is the part of a name by which an Individual Customer is addressed in a polite, businesslike, and somewhat formal context. It is often possible to derive the gender of an addressee from a Salutation. Some feminine Salutations reflect the marital status of the addressee to whom they apply. Examples of Salutation include Mrs., Mister, Ms., Miss, Herr, Fr, Madame. |
Data Type | CHAR(10) |
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 | Short First Name indicates an abbreviated form of the First Name by which an Involved Party is commonly known. |
Data Type | VARCHAR(20) |
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 | Signature Sample indicates a picture of the Individual Customer's handwritten signature for identification purpose. |
Data Type | CHAR(10) |
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 | Social Security Number indicates the unique number assigned to an Individual Customer by a governmental agency for the purposes of qualifying for Social Security benefits. |
Data Type | DECIMAL(5 , 0) |
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 | Spouse Name indicates an Individual Customer's name component that comprises the entire and complete name of the subject Individual Customer; for example, 'John A. Doe'. |
Data Type | VARCHAR(50) |
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 | Suffix indicates an Individual Customer's name component that is the part of a name which is added at the end in order to aid in identification of the named Individual. A Suffix is often used when two or more Individual Customer have names that, excepting Suffix, are the same; for example, Junior, Senior, II, III. |
Data Type | VARCHAR(50) |
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 | Surname1 indicates an Individual Customer's name component that represents the name of the family the Individual Customer is a part of; for example, Smith. When an Individual Customer is known by a joint family name, for example "Smith Mueller", the Surname1 is "Smith" and the Surname2 is "Mueller". |
Data Type | VARCHAR(50) |
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 | Surname1 indicates an Individual Customer's name component that represents the name of the family the Individual Customer is a part of; for example, Smith. When an Individual Customer is known by a joint family name, for example "Smith Mueller", the Surname1 is "Smith" and the Surname2 is "Mueller". |
Data Type | VARCHAR(50) |
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 | Individual Tax Identification Number indicates the unique number which identifies an Individual Customer to the tax authorities. |
Data Type | CHAR(20) |
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 | Anchor Id indicates any value without business meaning that uniquely distinguishes occurrences of this entity independently of its history. |
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 |
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 |
Data Type | DATE |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Data Type | DATE |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Data Type | DATE |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Data Type | DATE |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Data Type | VARCHAR(50) |
Default Value | None |
Is Primary Key | false |
Is Identity | false |
Is Nullable | true |
Is Generated | false |
Is Row Change Timestamp | false |
Is hidden | false |
Data Type | VARCHAR(50) |
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 | NO_ACTION |
Is Identifying Relationship | false |
Child Table | INDIVIDUAL_CUSTOMER_DIMENSION |
Child Multiplicity | * |
Key Column | CALENDAR_DATE_DIMENSION_ID [BIGINT] |
Key Column | DENOMINATION_CURRENCY_DIMENSION_ID [BIGINT] |
Key Column | INDIVIDUAL_CUSTOMER_DIMENSION_ID [BIGINT] |
Parent Table | INDIVIDUAL_SNAPSHOT_FACT |
Parent Multiplicity | 0..1 |
Unique Constraint | INDIVIDUAL_SNAPSHOT_FACT_PK |
Primary Key Details |
Member | INDIVIDUAL_CUSTOMER_DIMENSION_ID [BIGINT] |
Index Details |
Is Unique | true |
Is Clustered | false |
Member | INDIVIDUAL_CUSTOMER_DIMENSION_ID [BIGINT] Ascending |
| WEALTH Data Model |