AttributeValueList

Entity Definition

Logical Name : AttributeValueList
Physical Name : CO_ATTR_VL_LST

Identifies and lists the one or more values an AttributeType with a AttributeDateType of 'LIST" may take on. For example AttributeType - 'GENDER', may assume values of: 'M' Male 'F' Female 'U' Undetermined This list consitutes the AttributeListValue domain for GENDER.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
AttributeTypeID (FK)(PK) 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)(PK) Unique ID for an entity type ID_ET Identity integer AttributeType(CO_ATTR_TYP)
AttributeListItemSequenceNumber (PK) Sequence number to ensure unique value list for a list type attribute. Also prescribes order of lst. AI_ATTR_LST_ITM_SQN LineNumber smallint
AttributeListValue Short hand code used to lookup a longer text description. VL_ATTR_LST DescriptionShort varchar(255)
AttributeListItemDescription Short description of this AttributeValueList row. DE_ATTR_LST DescriptionShort varchar(255)

Relationships

Parent Entity Verb Phrase Child Entity
AttributeType is enumerated by AttributeValueList

Logical Views containing AttributeValueList

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