Table INDIVIDUAL_CUSTOMER_DIMENSION

DescriptionIndividual Customer identifies an Individual that is eligible to avail itself of the Financial Institution's Products and Services.

Columns
INDIVIDUAL_CUSTOMER_DIMENSION_IDINDIVIDUAL_CUSTOMER_DIMENSION_ID
CALENDAR_DATE_DIMENSION_IDCALENDAR_DATE_DIMENSION_ID
DENOMINATION_CURRENCY_DIMENSION_IDDENOMINATION_CURRENCY_DIMENSION_ID
BIRTH_DATEBIRTH_DATE
EMPLOYER_NAMEEMPLOYER_NAME
EMPLOYMENT_TITLEEMPLOYMENT_TITLE
FIRST_NAMEFIRST_NAME
FULL_NAMEFULL_NAME
IDENTITY_CARD_NUMBERIDENTITY_CARD_NUMBER
CUSTOMER_NUMBERCUSTOMER_NUMBER
DESCRIPTIONDESCRIPTION
MIDDLE_NAMEMIDDLE_NAME
HOUSEHOLD_NAMEHOUSEHOLD_NAME
IDENTIFICATION_NUMBERIDENTIFICATION_NUMBER
INDIVIDUAL_RISK_DOMICILEINDIVIDUAL_RISK_DOMICILE
MANAGED_BY_EMPLOYEE_NAMEMANAGED_BY_EMPLOYEE_NAME
MANAGED_BY_EMPLOYEE_NUMBERMANAGED_BY_EMPLOYEE_NUMBER
NAME_INITIALNAME_INITIAL
NAME_QUALIFICATIONNAME_QUALIFICATION
PHOTOPHOTO
PRIMARY_ACCOUNT_NAMEPRIMARY_ACCOUNT_NAME
PRIMARY_ACCOUNT_NUMBERPRIMARY_ACCOUNT_NUMBER
PRIMARY_BRANCH_CODEPRIMARY_BRANCH_CODE
SPOUSE_IDENTIFICATION_NUMBERSPOUSE_IDENTIFICATION_NUMBER
PRIMARY_BRANCH_NAMEPRIMARY_BRANCH_NAME
PRIMARY_LOCATIONPRIMARY_LOCATION
PROFESSIONAL_TITLEPROFESSIONAL_TITLE
SALUTATIONSALUTATION
SHORT_FIRST_NAMESHORT_FIRST_NAME
SIGNATURE_SAMPLESIGNATURE_SAMPLE
SOCIAL_SECURITY_NUMBERSOCIAL_SECURITY_NUMBER
SPOUSE_NAMESPOUSE_NAME
SUFFIXSUFFIX
SURNAME1SURNAME1
SURNAME2SURNAME2
TAX_IDENTIFICATION_NUMBERTAX_IDENTIFICATION_NUMBER
ANCHOR_IDANCHOR_ID
CURRENT_ROW_INDICATORCURRENT_ROW_INDICATOR
EFFECTIVE_FROM_DATEEFFECTIVE_FROM_DATE
EFFECTIVE_TO_DATEEFFECTIVE_TO_DATE
VALID_FROM_DATEVALID_FROM_DATE
VALID_TO_DATEVALID_TO_DATE
MARITAL_STATUSMARITAL_STATUS
EDUCATIONEDUCATION

Foreign Key
INDIVIDUA_INDI_FKINDIVIDUA_INDI_FK

Primary Key
INDIVIDUAL_CUSTOMER_DIMENSION_PKINDIVIDUAL_CUSTOMER_DIMENSION_PK

Indexes
INDIVIDUAL_CUSTOMER_DIMENSION_PKINDIVIDUAL_CUSTOMER_DIMENSION_PK

Column Details

 INDIVIDUAL_CUSTOMER_DIMENSION_ID
DescriptionThe unique identifier of the Individual Customer Dimension.
Data TypeBIGINT
Default ValueNone
Is Primary Keytrue
Is Identitytrue
Is Nullablefalse
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



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



 DENOMINATION_CURRENCY_DIMENSION_ID
DescriptionThe unique identifier of the Denomination Currency Dimension.
Data TypeBIGINT
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 BIRTH_DATE
DescriptionBirth Date indicates the calendar date associated with the Individual's Date Of Birth.
Data TypeDATE
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 EMPLOYER_NAME
DescriptionEmployer 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 TypeVARCHAR(50)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 EMPLOYMENT_TITLE
DescriptionEmployment Title indicates the employment position held by the Individual Customer.
Data TypeVARCHAR(50)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 FIRST_NAME
DescriptionFirst 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 TypeVARCHAR(50)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 FULL_NAME
DescriptionFull 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 TypeVARCHAR(50)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 IDENTITY_CARD_NUMBER
DescriptionIdentity 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 TypeCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 CUSTOMER_NUMBER
DescriptionCustomer Number indicates the unique identifier of the Customer within the Financial Institution.
Data TypeCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 DESCRIPTION
DescriptionDescription indicates a textual explanation or free form comments about the Individual Customer.
Data TypeVARCHAR(2000)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 MIDDLE_NAME
DescriptionMiddle 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 TypeVARCHAR(50)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 HOUSEHOLD_NAME
DescriptionHousehold Name indicates a label by which Household is known.
Data TypeVARCHAR(50)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 IDENTIFICATION_NUMBER
DescriptionIdentification 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 TypeCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 INDIVIDUAL_RISK_DOMICILE
DescriptionIndividual Risk Domicile indicates the Country where the Customer realizes the risk associated with their exposures.
Data TypeVARCHAR(50)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 MANAGED_BY_EMPLOYEE_NAME
DescriptionManaged By Employee Name indicates the entire and complete name of the subject Employee; for example, 'John A. Doe'.
Data TypeVARCHAR(50)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 MANAGED_BY_EMPLOYEE_NUMBER
DescriptionManaged By Employee Number indicates an identifier by which the Employee is known to the Financial Institution.
Data TypeCHAR(50)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 NAME_INITIAL
DescriptionName 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 TypeCHAR(10)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 NAME_QUALIFICATION
DescriptionName 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 TypeCHAR(50)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 PHOTO
DescriptionPhoto indicates a picture of the Individual Customer produced by photography for identification purpose.
Data TypeVARCHAR(2000)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 PRIMARY_ACCOUNT_NAME
DescriptionPrimary Account Name indicates the label given to a specific Account Arrangement.
Data TypeVARCHAR(50)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 PRIMARY_ACCOUNT_NUMBER
DescriptionPrimary Account Number indicates the number of the Account Arrangement as defined by the Financial Institution.
Data TypeCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 PRIMARY_BRANCH_CODE
DescriptionPrimary 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 TypeCHAR(10)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 SPOUSE_IDENTIFICATION_NUMBER
DescriptionSpouse 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 TypeCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 PRIMARY_BRANCH_NAME
DescriptionPrimary Branch Name indicates the entire and complete name of the Individual Customer.
Data TypeVARCHAR(50)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 PRIMARY_LOCATION
DescriptionPrimary Location indicates the name of the city where the Geographic Area is located.
Data TypeVARCHAR(50)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 PROFESSIONAL_TITLE
DescriptionProfessional 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 TypeCHAR(10)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 SALUTATION
DescriptionSalutation 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 TypeCHAR(10)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 SHORT_FIRST_NAME
DescriptionShort First Name indicates an abbreviated form of the First Name by which an Involved Party is commonly known.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 SIGNATURE_SAMPLE
DescriptionSignature Sample indicates a picture of the Individual Customer's handwritten signature for identification purpose.
Data TypeCHAR(10)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



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



 SPOUSE_NAME
DescriptionSpouse 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 TypeVARCHAR(50)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 SUFFIX
DescriptionSuffix 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 TypeVARCHAR(50)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 SURNAME1
DescriptionSurname1 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 TypeVARCHAR(50)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 SURNAME2
DescriptionSurname1 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 TypeVARCHAR(50)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 TAX_IDENTIFICATION_NUMBER
DescriptionIndividual Tax Identification Number indicates the unique number which identifies an Individual Customer to the tax authorities.
Data TypeCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 ANCHOR_ID
DescriptionAnchor Id indicates any value without business meaning that uniquely distinguishes occurrences of this entity independently of its history.
Data TypeINTEGER
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



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



 EFFECTIVE_FROM_DATE
Data TypeDATE
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 EFFECTIVE_TO_DATE
Data TypeDATE
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 VALID_FROM_DATE
Data TypeDATE
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 VALID_TO_DATE
Data TypeDATE
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 MARITAL_STATUS
Data TypeVARCHAR(50)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 EDUCATION
Data TypeVARCHAR(50)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse

Foreign Key Details

 INDIVIDUA_INDI_FK
Referential Integrity: On UpdateNO_ACTION
Referential Integrity: On DeleteNO_ACTION
Is Identifying Relationshipfalse
Child TableINDIVIDUAL_CUSTOMER_DIMENSION
Child Multiplicity*
Key ColumnCALENDAR_DATE_DIMENSION_ID [BIGINT]
Key ColumnDENOMINATION_CURRENCY_DIMENSION_ID [BIGINT]
Key ColumnINDIVIDUAL_CUSTOMER_DIMENSION_ID [BIGINT]
Parent TableINDIVIDUAL_SNAPSHOT_FACT
Parent Multiplicity0..1
Unique ConstraintINDIVIDUAL_SNAPSHOT_FACT_PK

Primary Key Details

 INDIVIDUAL_CUSTOMER_DIMENSION_PK
MemberINDIVIDUAL_CUSTOMER_DIMENSION_ID [BIGINT]

Index Details

 INDIVIDUAL_CUSTOMER_DIMENSION_PK
Is Uniquetrue
Is Clusteredfalse
MemberINDIVIDUAL_CUSTOMER_DIMENSION_ID [BIGINT] Ascending