AttributeType

Entity Definition

Logical Name : AttributeType
Physical Name : CO_ATTR_TYP

A general entity used to identify, define and describe retailer defined attribute types that supplement those provided in the ARTS Data Model. This is part of an entity-attribute-value design pattern.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
AttributeTypeID (PK) Token ID for an attribute type used in EAV extension to baseline ARTS model. ID_ATTR_TYP Identity integer
EntityTypeID (FK)(PK) Unique ID for an entity type ID_ET Identity integer EntityType(CO_ET_TYP)
AttributeTypeName The business/display name of this attribute. NM_ATTR_TYP DescriptionShort varchar(255)
AttributeTypeDefinition Short business definition of the attribute NA_ATTR_TYP_DFN DescriptionNarrative varchar(4000)
AttributeDataType The type of data format this attribute uses. Valid values are: DATE - Calendar date (MMDDCCYY DATETIME Timestamp MMDDCCYYHHMMSSmmmm LIST - Use referenced value list INTEGER - whole number DECIMAL - decimal or money amount FLOATING_POINT - IEEE floating point ALL Data is stored in character form. This code is used to transform the data type into its target form for processing. We're using text for the same reason XML uses it -- its the lowest common denominator and can be read by pepole. CD_ATTR_DAT_TYP DescriptionShort varchar(255)
HighValue Maximum value (inclusive) of a value for this AttributeType VL_HGH DescriptionShort varchar(255)
LowValue Minimum value (inclusive) that may be assumed by this AttributeType VL_LW DescriptionShort varchar(255)
AttributeRangeTypeCode Indicates if this attribute type's domain is limited to: SCALAR single value of a given data type HIGH_LOW high low range of a given data type LIST of values (in subtable) of a given data type CD_ATTR_RNGE_TYP Code varchar(20)

Relationships

Parent Entity Verb Phrase Child Entity
EntityType is described by AttributeType
AttributeType defines type of OrganizationAttributeValue
AttributeType defines type of AnonymousAttributeValue
AttributeType defines type of PersonAttibuteValue
AttributeType defines type of KeyCustomerAttributeValue
AttributeType assumes AttributeValue
AttributeType defines type of HouseholdAttributeValue
AttributeType is enumerated by AttributeValueList

Logical Views containing AttributeType

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