Table PERSON_MINI_DIMENSION

DescriptionGrouping of attributes used to perform analysis on instances of Person that share the same characteristics.

Columns
PERSON_MINI_DIMENSION_IDPERSON_MINI_DIMENSION_ID
BANKCARDBANKCARD
BANKING_PROFILEBANKING_PROFILE
BLOOD_TYPEBLOOD_TYPE
BUILDING_STYLEBUILDING_STYLE
CUSTOMER_STATUSCUSTOMER_STATUS
DEBIT_CREDIT_STATUSDEBIT_CREDIT_STATUS
DRIVING_LICENSE_STATUSDRIVING_LICENSE_STATUS
EDUCATION_LEVELEDUCATION_LEVEL
EMPLOYMENT_STATUSEMPLOYMENT_STATUS
ETHNICITYETHNICITY
FAMILYFAMILY
FIRST_HEAD_AGE_RANGEFIRST_HEAD_AGE_RANGE
FIRST_HEAD_EMPLOYMENT_STATUSFIRST_HEAD_EMPLOYMENT_STATUS
FIRST_HEAD_GENDERFIRST_HEAD_GENDER
FIRST_HEAD_MARITAL_STATUSFIRST_HEAD_MARITAL_STATUS
FIRST_HEAD_NATIONALITYFIRST_HEAD_NATIONALITY
FIRST_HEAD_SMOKERFIRST_HEAD_SMOKER
GENDERGENDER
GOOD_DRIVERGOOD_DRIVER
HOME_OWNERSHIPHOME_OWNERSHIP
IMPORTANCE_LEVELIMPORTANCE_LEVEL
INTRODUCTIONINTRODUCTION
LIFE_CUSTOMERLIFE_CUSTOMER
MARITAL_STATUSMARITAL_STATUS
MARRIED_COUPLEMARRIED_COUPLE
MISSINGMISSING
MODELLED_ORGANISATIONMODELLED_ORGANISATION
MOTORCYCLE_OWNERSHIPMOTORCYCLE_OWNERSHIP
NATIONALITYNATIONALITY
NON_LIFE_CUSTOMERNON_LIFE_CUSTOMER
OVERALL_CONDITIONOVERALL_CONDITION
PREFERRED_PAYMENT_METHODPREFERRED_PAYMENT_METHOD
PREFIX_TITLESPREFIX_TITLES
PREVIOUS_REFUSALPREVIOUS_REFUSAL
PRIME_ROLEPRIME_ROLE
RESIDENCY_LENGTHRESIDENCY_LENGTH
SECOND_HEAD_AGE_RANGESECOND_HEAD_AGE_RANGE
SECOND_HEAD_EMPLOYMENT_STATUSSECOND_HEAD_EMPLOYMENT_STATUS
SECOND_HEAD_GENDERSECOND_HEAD_GENDER
SECOND_HEAD_NATIONALITYSECOND_HEAD_NATIONALITY
SECOND_HEAD_OCCUPATION_CODESECOND_HEAD_OCCUPATION_CODE
SECOND_HEAD_SMOKERSECOND_HEAD_SMOKER
SELF_EMPLOYED_BUSINESSSELF_EMPLOYED_BUSINESS
SMOKING_HABIT_TYPESMOKING_HABIT_TYPE
SPEAKING_LANGUAGESPEAKING_LANGUAGE
STATUSSTATUS
STATUS_REASONSTATUS_REASON
PREFERRED_CONTACT_METHODPREFERRED_CONTACT_METHOD

Primary Key
PERSON_MINI_DIMENSION_PKPERSON_MINI_DIMENSION_PK

Dependencies
AWM - TransformationAWM - Transformation

Column Details

 PERSON_MINI_DIMENSION_ID
DescriptionThe unique identifier of the Person mini dimension
Data TypeBIGINT
Default ValueNone
Is Primary Keytrue
Is Identitytrue
Is Nullablefalse
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 BANKCARD
DescriptionIndicates whether the Person has a credit card issued by a bank or other financial institution.
Data TypeCHAR(1)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 BANKING_PROFILE
DescriptionIdentifies the banking profile of the person with respect to the number of banking establishments the person works with at a point in time.

e.g. Several banks
e.g. Single bank
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 BLOOD_TYPE
DescriptionThe classification of the person's blood with regard to ABO and Rhesus systems in the human blood type profile.

e.g. A
e.g. A+
e.g. AB
e.g. AB+
e.g. B-
e.g. O
e.g. O+
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 BUILDING_STYLE
DescriptionThe design style of the structure.

e.g. Duplex
e.g. High rise multiple units
e.g. Low rise multiple units
e.g. Single family detached four square
e.g. Single family detached ranch
e.g. Single family row home
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 CUSTOMER_STATUS
DescriptionIndicates the position of the Person within an insurance customer life-cycle model consisting of a number of statuses.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 DEBIT_CREDIT_STATUS
DescriptionIdentifies the financial status of the party with respect to the modelled organisation.

e.g. Creditor
e.g. Debtor
e.g. Neutral
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 DRIVING_LICENSE_STATUS
DescriptionThe kind of road vehicle that may be driven with the driving license.

e.g. A (Motorcycles)
e.g. B (Cars and light trucks)
e.g. C (B plus Vehicles carrying 16 or more passengers)
e.g. D (B plus Heavy trucks with trailers)
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 EDUCATION_LEVEL
DescriptionThe highest level of degree obtained by the person.

e.g. None
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 EMPLOYMENT_STATUS
DescriptionThe status of the person's employment.

e.g. Contractual
e.g. Full-time
e.g. Retired
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 ETHNICITY
DescriptionIdentifies the ethnic group to which an individual is associated.

e.g. Afro-American.
e.g. Caucasian.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 FAMILY
DescriptionIndicates whether or not the household contains a couple of whom one is designated as the head of the household as well as at least one child of the couple.
Data TypeCHAR(1)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 FIRST_HEAD_AGE_RANGE
DescriptionA range expressing the first head of Household's age.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 FIRST_HEAD_EMPLOYMENT_STATUS
DescriptionIndicates the first head of Household's current work situation for his or her main function.

e.g. Contractual
e.g. Full-time
e.g. Retired
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 FIRST_HEAD_GENDER
DescriptionThe person's sex or gender.

e.g. Female
e.g. Male
e.g. Unknown
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 FIRST_HEAD_MARITAL_STATUS
DescriptionIndicates the legal state of the first head of a household with respect to marriage.

e.g. Divorced.
e.g. Married.
e.g. Single.
e.g. Widowed.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 FIRST_HEAD_NATIONALITY
DescriptionIndicates the registered nationality of the first head of Household.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 FIRST_HEAD_SMOKER
DescriptionIndicates whether the first head of Household is a smoker or tobacco user.
Data TypeCHAR(1)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 GENDER
DescriptionThe person's sex or gender.

e.g. Female
e.g. Male
e.g. Unknown
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 GOOD_DRIVER
DescriptionIndicates that the person has received a safe driver award or has followed a defensive driving course.
Data TypeCHAR(1)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 HOME_OWNERSHIP
DescriptionThe tenancy status of the main residence.
Is derived via the object ownership of a physical object that is a dwelling and where that dwelling is located at, via physical object location, the same place as the residence for the household.

e.g. Own
e.g. Rent
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 IMPORTANCE_LEVEL
DescriptionThe level of importance the customer has to the modelled organisation.

e.g. 1 (Highest priority/ VIP)
e.g. 2 (High priority)
e.g. 3 (Normal priority)
e.g. 4 (Low priority)
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 INTRODUCTION
DescriptionThe manner in which the party is first introduced to the modelled organisation.

e.g. Advertisement
e.g. Business partner
e.g. Mailshot campaign
e.g. Newspaper
e.g. Personal recommendation
e.g. Television advertisement
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 LIFE_CUSTOMER
DescriptionIndicates whether a party has a current life agreement with the modelled organisation.
Data TypeCHAR(1)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 MARITAL_STATUS
DescriptionThe legal status of the person with regard to marriage.

e.g. Divorced.
e.g. Married.
e.g. Single.
e.g. Widowed.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 MARRIED_COUPLE
DescriptionIndicates whether the Household contains a married couple.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 MISSING
DescriptionIndicates whether or not the person's whereabouts are known.
Data TypeCHAR(1)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 MODELLED_ORGANISATION
DescriptionIndicates whether a person is part of the modelled organisation.
Data TypeCHAR(1)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 MOTORCYCLE_OWNERSHIP
DescriptionIndicates whether a member of this household owns a motorcycle.
Data TypeCHAR(1)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 NATIONALITY
DescriptionThe persons' nationality.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 NON_LIFE_CUSTOMER
DescriptionIndicates whether a party has a current non-life policy with the modelled organisation.
Data TypeCHAR(1)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 OVERALL_CONDITION
DescriptionThe overall health status of the person.

e.g. Excellent.
e.g. Good.
e.g. Poor.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 PREFERRED_PAYMENT_METHOD
DescriptionThe preferred method of payment.

e.g. Cash
e.g. Cheque
e.g. Credit card
e.g. Direct debit
e.g. Standing order
e.g. Transfer
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 PREFIX_TITLES
DescriptionThe honorifics or titles that precede the name when addressing a person in polite, somewhat formal circumstances.

e.g. Dr.
e.g. Herr
e.g. Mr.
e.g. Mrs.
e.g. Ms.
e.g. Prof.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 PREVIOUS_REFUSAL
DescriptionIndicates if the party has been refused insurance or has had a policy cancelled or special terms imposed by the modelled organisation.
Data TypeCHAR(1)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 PRIME_ROLE
DescriptionThe main type of relationship the party has with the modelled organisation.

e.g. Intermediary
e.g. Named driver
e.g. Policyholder
e.g. Premium payer
e.g. Repairer
e.g. Solicitor
e.g. Witness
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 RESIDENCY_LENGTH
DescriptionIndicates the number of years the Household has lived at the current address.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 SECOND_HEAD_AGE_RANGE
DescriptionA range expressing the second head of Household's age.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 SECOND_HEAD_EMPLOYMENT_STATUS
DescriptionIndicates the second head of Household's current work situation for his or her main function.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 SECOND_HEAD_GENDER
DescriptionIndicates whether the second head of Household is male or female.

e.g. Female
e.g. Male
e.g. Unknown
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 SECOND_HEAD_NATIONALITY
DescriptionIndicates the registered nationality of the second head of Household.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 SECOND_HEAD_OCCUPATION_CODE
DescriptionIndicates the occupation of the second head of Household.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 SECOND_HEAD_SMOKER
DescriptionIndicates whether the second head of Household is a smoker or tobacco user.
Data TypeCHAR(1)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 SELF_EMPLOYED_BUSINESS
DescriptionIndicates if a person has a self-employed business.
Data TypeCHAR(1)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 SMOKING_HABIT_TYPE
DescriptionIndicates whether or not the person is a smoker or tobacco user.
Is derived from the existence of a smoking habit linked to the person via activity involvement.
Code indicating what kind of smoking habit a person has.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 SPEAKING_LANGUAGE
DescriptionPreferred speaking language of the Person.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 STATUS
DescriptionIdentifies the position of the organisation within a life-cycle model consisting of a number of statuses.
It is used for all statuses other than foundation and dissolution.

e.g. Active
e.g. Closed out
e.g. Compulsory liquidation
e.g. Liquidation
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 STATUS_REASON
DescriptionThe additional information to explain the latest status of the organisation.

e.g. Risky investment
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 PREFERRED_CONTACT_METHOD
DescriptionThe preferred method of contact.

e.g. Phone
eg. e-mail
e.g. mail

etc.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse

Primary Key Details

 PERSON_MINI_DIMENSION_PK
DescriptionThe unique identifier of the Person mini dimension
MemberPERSON_MINI_DIMENSION_ID [BIGINT]

Dependency Details

 AWM - Transformation