Household

Entity Definition

Logical Name : Household
Physical Name : PA_HSHLD

A Household is an identifiable, named, defined group of Person party subtypes that make retail related decisions together. Traditionally households are tied to residential addresses and represented nuclear families. Today these qualifiers of household don't always apply so it is a more generic way to gather individual parties into a economic decision making unit. Households share some characteristics with Organization and Community - but they are important to retailers because they represent groups of parties that purchase and consume products and services as an economic decision making unit. In ARTS we are distinguishing Households from Organizations (which are more typically representing commercial, public of charitable business establishments) and communities which may or may not have clearly delineated econcomic decision making capacity.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
HouseholdID (PK) Token identifier for a Household. ID_HSHLD Identity integer
PartyID (FK)(PK) A unique, system assigned identity for a Party. ID_PRTY Identity integer
HouseholdIncomeAmount Estimated pooled annual income for all members of a household. This used to differentiate purchasing power of individuals (see Person) and families or similar economic groupings. MO_HSHLD_INCM Money decimal(16,5)
HouseholdName A name assigned by the retailer to a Household for reporting purposes. Typically a household name applied to a collection of Person entities will assume the last name, first name of the PrincipalSubParty. This is not a requirement so retailers may adopt their own convention for assigning names to Household party types. NM_HSHLD DescriptionShort varchar(255)
HouseholdPartyCount The number of parties in a household. This count is determined through program logic and should be basedon a count of individually identified parites affiliated with this household party. QU_PRTY_HSLD QuantityShortCount decimal(3,0)
HouseholdTypeCode A retailer designated category used to group households with common properties together for reporting and analysis. CD_HSHLD_TYP_CD Code varchar(20)

Relationships

Parent Entity Verb Phrase Child Entity
Household is described by HouseholdAttributeValue
Party can be a Household

Logical Views containing Household

Logical View
Logical 06310 - Party - Role View
Logical 07000 - Core Customer Entities
Logical 07010 - Customer Account Information Extended
Logical 07019 - Party-Consumer-Customer Household View
Logical 07030 - Customer Segment Independent Characteristics