KeyCustomerAttributeValue

Entity Definition

Logical Name : KeyCustomerAttributeValue
Physical Name : CO_CT_ATTR_VL

The assignment of a specific value for a specific key customer to a CustomerAttributeType.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
CustomerAttributeValueID (PK) Token ID for a specific instance of a CustomerAttributeValue. This entity instance is the point where a customer-specific value is assigned to a CustomerAttributeType and is part of the ENTITY - ATTRIBUTE -VALUE framework used to allow retailers to identify, define and describe their own customer attributes. ID_CT_ATTR_VL Identity integer
AttributeValue The actual customer specific value for the CustomerAttributeType. CH_ATTR_VL DescriptionShort varchar(255)
EffectiveDate The date this value for this CustomerAttributeType is valid. This is used to track changes in customer attributes over time. DT_EF EffectiveDate date
ExpirationDate The date this value for this CustomerAttributeType is no-longer valid. This is used to track changes in customer attributes over time. DT_EP ExpirationDate date
StatusCode The current state of this CustomerAttributeValue instance. Values include: A - Active I - Inactive As a rule, a given CustomerAttributeType should have ONE AND ONLY ONE ACTIVE CustomerAttributeValue associated with it. This rule should be enforced in the retailer's application code. SC_CT_ATTR_VL Code2Status char(2)
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)
CustomerID (FK) A unique system assigned identifier for a person or organization that purchases a product or service from the retailer. ID_CT Identity integer KeyCustomer(PA_KY_CT)

Relationships

Parent Entity Verb Phrase Child Entity
AttributeType defines type of KeyCustomerAttributeValue
KeyCustomer is characterized by KeyCustomerAttributeValue

Logical Views containing KeyCustomerAttributeValue

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