Table HOUSEHOLD

DescriptionA set of individuals who usually reside at the same address, are members of the same nuclear or extended family, share a common economic interest and who are to be treated for certain purposes (marketing campaigns, taxes) as a unit.

e.g. Smith Household.

Columns
HOUSEHOLD_IDHOUSEHOLD_ID
AMOUNT_OWEDAMOUNT_OWED
ANCHOR_IDANCHOR_ID
CUSTOMER_STATUS_TENURECUSTOMER_STATUS_TENURE
DESCRIPTIONDESCRIPTION
DISPOSABLE_INCOMEDISPOSABLE_INCOME
DISSOLUTION_DATEDISSOLUTION_DATE
DISTANCE_FROM_AGENTDISTANCE_FROM_AGENT
EFFECTIVE_FROM_DATEEFFECTIVE_FROM_DATE
EFFECTIVE_TO_DATEEFFECTIVE_TO_DATE
EXTERNAL_REFERENCEEXTERNAL_REFERENCE
FIRST_HEAD_FORENAMEFIRST_HEAD_FORENAME
FIRST_HEAD_FULL_NAMEFIRST_HEAD_FULL_NAME
FIRST_HEAD_GIVEN_NAMEFIRST_HEAD_GIVEN_NAME
FIRST_HEAD_MIDDLE_NAMEFIRST_HEAD_MIDDLE_NAME
FIRST_HEAD_OCCUPATION_CODEFIRST_HEAD_OCCUPATION_CODE
FIRST_HEAD_OCCUPATION_NAMEFIRST_HEAD_OCCUPATION_NAME
FIRST_HEAD_PREFIX_TITLEFIRST_HEAD_PREFIX_TITLE
FIRST_HEAD_SUFFIX_TITLEFIRST_HEAD_SUFFIX_TITLE
FIRST_HEAD_SURNAMEFIRST_HEAD_SURNAME
FOUNDATION_DATEFOUNDATION_DATE
FULL_NAMEFULL_NAME
GROSS_INCOMEGROSS_INCOME
HOUSEHOLD_MINI_DIMENSION_IDHOUSEHOLD_MINI_DIMENSION_ID
NUMBER_OF_DEPENDENT_ADULTSNUMBER_OF_DEPENDENT_ADULTS
NUMBER_OF_DEPENDENT_CHILDRENNUMBER_OF_DEPENDENT_CHILDREN
NUMBER_OF_EMPLOYEESNUMBER_OF_EMPLOYEES
NUMBER_OF_MEMBERSNUMBER_OF_MEMBERS
OLDEST_DEPENDENT_ADULT_BIRTH_DATEOLDEST_DEPENDENT_ADULT_BIRTH_DATE
OLDEST_DEPENDENT_CHILD_BIRTH_DATEOLDEST_DEPENDENT_CHILD_BIRTH_DATE
PROPERTY_MARKET_VALUEPROPERTY_MARKET_VALUE
SECOND_HEAD_FORENAMESECOND_HEAD_FORENAME
SECOND_HEAD_FULL_NAMESECOND_HEAD_FULL_NAME
SECOND_HEAD_GIVEN_NAMESECOND_HEAD_GIVEN_NAME
SECOND_HEAD_MIDDLE_NAMESECOND_HEAD_MIDDLE_NAME
SECOND_HEAD_OCCUPATION_NAMESECOND_HEAD_OCCUPATION_NAME
SECOND_HEAD_PREFIX_TITLESECOND_HEAD_PREFIX_TITLE
SECOND_HEAD_SUFFIX_TITLESECOND_HEAD_SUFFIX_TITLE
SECOND_HEAD_SURNAMESECOND_HEAD_SURNAME
STATUS_DATESTATUS_DATE
TYPETYPE
VALID_FROM_DATEVALID_FROM_DATE
VALID_TO_DATEVALID_TO_DATE
YOUNGEST_DEPENDENT_ADULT_BIRTH_DATEYOUNGEST_DEPENDENT_ADULT_BIRTH_DATE
YOUNGEST_DEPENDENT_CHILD_BIRTH_DATEYOUNGEST_DEPENDENT_CHILD_BIRTH_DATE
NUMBER_OF_INSURED_CARSNUMBER_OF_INSURED_CARS

Primary Key
HOUSEHOLD_PKHOUSEHOLD_PK

Dependencies
AWM - TransformationAWM - Transformation

Column Details

 HOUSEHOLD_ID
DescriptionThe unique identifier of the Household
Data TypeBIGINT
Default ValueNone
Is Primary Keytrue
Is Identitytrue
Is Nullablefalse
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 AMOUNT_OWED
DescriptionThe amount owed by or to the party. If the debit creditor status is set to debtor, the party owes money to the modelled organisation (premium, loan). If the debit creditor status is set to creditor, the modelled organisation owes money to the party.
Data TypeDECIMAL(14 , 2)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



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



 CUSTOMER_STATUS_TENURE
DescriptionThe number of years that a household has been classified within its customer status.
Data TypeDATE
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 DESCRIPTION
DescriptionThe textual representation of information or free form comments about a role player.
Data TypeVARCHAR(256)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 DISPOSABLE_INCOME
DescriptionThe amount of money that this household can spend after having paid all the fixed expenses such as rent, mortgage repayment and so on.
This information should be provided by the household when not all composing elements for calculating the disposable income are available.
Data TypeDECIMAL(14 , 2)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 DISSOLUTION_DATE
DescriptionThe date at which this organisation ceases to legally exist.
Data TypeDATE
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 DISTANCE_FROM_AGENT
DescriptionDistance, in miles, from the primary agent of this household.
Data TypeINTEGER
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 EFFECTIVE_FROM_DATE
DescriptionThe effective date and time that represents the beginning of the time period during which the values of all attributes of the entity occurrence are true in the business reality.
Data TypeTIMESTAMP
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 EFFECTIVE_TO_DATE
DescriptionThe effective date and time that represents the end of the time period during which the values of all attributes of the entity occurrence are true in the business reality.
Data TypeTIMESTAMP
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 EXTERNAL_REFERENCE
DescriptionThe number or code used for identification or communication purposes.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 FIRST_HEAD_FORENAME
DescriptionThe first head of Household's name normally preceding the surname and typically used in informal circumstances.
Data TypeVARCHAR(256)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 FIRST_HEAD_FULL_NAME
DescriptionThe complete text of name used for identifying the first head of Household where the components of the name are unavailable or inapplicable. By default, the full name is a concatenation of the prefix title, the forename, the middle name, the surname and the suffix title.
Data TypeVARCHAR(256)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 FIRST_HEAD_GIVEN_NAME
DescriptionGiven name of the first head of Household.
Data TypeVARCHAR(256)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 FIRST_HEAD_MIDDLE_NAME
DescriptionThe additional names given to the first head of Household, usually at birth, and which appear sequentially between the forename and surname.
Data TypeVARCHAR(256)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 FIRST_HEAD_OCCUPATION_CODE
DescriptionIndicates the occupation 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_OCCUPATION_NAME
DescriptionName of the main current occupation performed by 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_PREFIX_TITLE
DescriptionThe honorifics or titles that precede the name when addressing the first head of Household in polite, somewhat formal circumstances.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 FIRST_HEAD_SUFFIX_TITLE
DescriptionThe titles, qualifications, or positions that follow the first head of Household's name when addressing formally or professionally, usually when writing.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 FIRST_HEAD_SURNAME
DescriptionThe part of the first head of Household's name arising from family identifications.
Data TypeVARCHAR(256)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 FOUNDATION_DATE
DescriptionThe date on which the organisation was founded or created.
Data TypeDATE
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 FULL_NAME
DescriptionThe complete aggregated name used for identifying a role player when the components of the name are unavailable or inapplicable.

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



 GROSS_INCOME
DescriptionThe most recent known gross income of this household.
Would only be derivable from the gross income of the persons that are the household members, provided this information is available for all members of the household.
Data TypeDECIMAL(14 , 2)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 HOUSEHOLD_MINI_DIMENSION_ID
DescriptionSoft link to Household mini dimension
Data TypeBIGINT
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 NUMBER_OF_DEPENDENT_ADULTS
DescriptionThe declared number of adults that are dependent from the household.
Data TypeINTEGER
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 NUMBER_OF_DEPENDENT_CHILDREN
DescriptionThe declared number of children that are dependent from the household.
Data TypeINTEGER
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 NUMBER_OF_EMPLOYEES
DescriptionThe number of persons employed by the organisation.
Data TypeINTEGER
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 NUMBER_OF_MEMBERS
DescriptionThe number of people being the members of this organisation. This number often is an approximate number, because the number of members may in general change over time without the modelled organisation being brought up to date.
Data TypeINTEGER
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 OLDEST_DEPENDENT_ADULT_BIRTH_DATE
DescriptionThe birth date of the eldest dependent adult.
Data TypeDATE
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 OLDEST_DEPENDENT_CHILD_BIRTH_DATE
DescriptionThe birth date of the eldest dependent child.
Data TypeDATE
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 PROPERTY_MARKET_VALUE
DescriptionThe market value of the household's primary residential home.
Data TypeDECIMAL(14 , 2)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 SECOND_HEAD_FORENAME
DescriptionThe second head of Household's name normally preceding the surname and typically used to refer to him/her in informal circumstances.
Data TypeVARCHAR(256)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 SECOND_HEAD_FULL_NAME
DescriptionThe complete text of name used for identifying the second head of Household where the components of the name are unavailable or inapplicable. By default, the full name is a concatenation of the prefix title, the forename, the middle name, the surname and the suffix title.
Data TypeVARCHAR(256)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 SECOND_HEAD_GIVEN_NAME
DescriptionGiven name of the second head of Household.
Data TypeVARCHAR(256)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 SECOND_HEAD_MIDDLE_NAME
DescriptionThe additional names given to the second head of Household, usually at birth, and which appear sequentially between the forename and surname.
Data TypeVARCHAR(256)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 SECOND_HEAD_OCCUPATION_NAME
DescriptionName of the main current occupation performed by 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_PREFIX_TITLE
DescriptionThe honorifics or titles that precede the name when addressing the second head of Household in polite, somewhat formal circumstances.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 SECOND_HEAD_SUFFIX_TITLE
DescriptionThe titles, qualifications, or positions that follow the second head of Household's name when addressing formally or professionally, usually when writing.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 SECOND_HEAD_SURNAME
DescriptionThe part of the second head of Household's name arising from family identifications.
Data TypeVARCHAR(256)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 STATUS_DATE
DescriptionThe date on which the organisation's latest status became effective.
Data TypeDATE
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 TYPE
DescriptionThe mutually exclusive categorisation of this Household.
Data TypeVARCHAR(20)
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 VALID_FROM_DATE
DescriptionThe transaction time that represents the beginning of the time period during which the values of this recorded data are true in the source system.
Data TypeTIMESTAMP
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 VALID_TO_DATE
DescriptionThe transaction time that represents the end of the time period during which the values of this recorded data are true in the source system.
Data TypeTIMESTAMP
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 YOUNGEST_DEPENDENT_ADULT_BIRTH_DATE
DescriptionThe birth date of the youngest dependent adult.
Data TypeDATE
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 YOUNGEST_DEPENDENT_CHILD_BIRTH_DATE
DescriptionThe birth date of the youngest dependent child.
Data TypeDATE
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse



 NUMBER_OF_INSURED_CARS
DescriptionThe declared number of children that are dependent from the household.
Data TypeINTEGER
Default ValueNone
Is Primary Keyfalse
Is Identityfalse
Is Nullabletrue
Is Generatedfalse
Is Row Change Timestampfalse
Is hiddenfalse

Primary Key Details

 HOUSEHOLD_PK
DescriptionThe unique identifier of the Household
MemberHOUSEHOLD_ID [BIGINT]

Dependency Details

 AWM - Transformation