HouseholdAttributeValue

Entity Definition

Logical Name : HouseholdAttributeValue
Physical Name : CO_HSHLD_ATTR_VL

The assignment of an attribute value for a specific household to a HouseholdAttributeType.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
HouseholdAttributeValueID (PK) A token ID for HouseholdAttributeValue. ID_HSHLD_ATTR_VL Identity integer
PartyID (FK) A unique, system assigned identity for a Party. ID_PRTY Identity integer Household(PA_HSHLD)
HouseholdID (FK) Token identifier for a Household. ID_HSHLD Identity integer Household(PA_HSHLD)
AttributeValue The actual value assigned to an attribute type that describes a Household VL_ATTR DescriptionShort varchar(255)
AttributeTypeID (FK) Token ID for an attribute type used in EAV extension to baseline ARTS model. ID_ATTR_TYP Identity integer AttributeType(CO_ATTR_TYP)
EntityTypeID (FK) Unique ID for an entity type ID_ET Identity integer AttributeType(CO_ATTR_TYP)
EffectiveDate Date the attribute value applies DC_EF EffectiveDate date
ExpirationDate Date the attribute value no longer applies DC_EP ExpirationDate date
StatusCode Current status of the HouseholdAttributeValue. Sample: I = Inactive (attribute value no longer applies) A = Active (attribute value applies) CD_STS Code2Status char(2)

Relationships

Parent Entity Verb Phrase Child Entity
AttributeType defines type of HouseholdAttributeValue
Household is described by HouseholdAttributeValue

Logical Views containing HouseholdAttributeValue

Logical View
Logical 07010 - Customer Account Information Extended
Logical 07030 - Customer Segment Independent Characteristics