Table HOUSEHOLD_MINI_DIMENSION

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

Columns
HOUSEHOLD_MINI_DIMENSION_IDHOUSEHOLD_MINI_DIMENSION_ID
BUILDING_STYLEBUILDING_STYLE
DEBIT_CREDIT_STATUSDEBIT_CREDIT_STATUS
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
HOME_OWNERSHIPHOME_OWNERSHIP
INTRODUCTIONINTRODUCTION
MARRIED_COUPLEMARRIED_COUPLE
MOTORCYCLE_OWNERSHIPMOTORCYCLE_OWNERSHIP
PREFERRED_PAYMENT_METHODPREFERRED_PAYMENT_METHOD
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
STATUSSTATUS
STATUS_REASONSTATUS_REASON

Primary Key
HOUSEHOLD_MINI_DIMENSION_PKHOUSEHOLD_MINI_DIMENSION_PK

Dependencies
AWM - TransformationAWM - Transformation

Column Details

 HOUSEHOLD_MINI_DIMENSION_ID
DescriptionThe unique identifier of the Household mini dimension
Data TypeBIGINT
Default ValueNone
Is Primary Keytrue
Is Identitytrue
Is Nullablefalse
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



 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



 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



 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



 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



 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



 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



 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



 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



 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

Primary Key Details

 HOUSEHOLD_MINI_DIMENSION_PK
DescriptionThe unique identifier of the Household mini dimension
MemberHOUSEHOLD_MINI_DIMENSION_ID [BIGINT]

Dependency Details

 AWM - Transformation