PersonAttibuteValue

Entity Definition

Logical Name : PersonAttibuteValue
Physical Name : CO_PRS_ATTR_VL

Captures the assignment of a value to an AttributeType for a Person

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
PersonAttributeValueID (PK) Token ID for a PersonAttributeValue ID_PRS_ATTR_VL Identity integer
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)
PersonAttributeValue The actual value assigned to this PersonAttributeType. CH_PRS_ATTR_VL_ID DescriptionShort varchar(255)
PersonPartyID (FK) A unique, system assigned identity for a Party. ID_PRTY_PRS Identity integer Person(PA_PRS)
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 PersonAttributeValue. 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
Person is described by PersonAttibuteValue
AttributeType defines type of PersonAttibuteValue

Logical Views containing PersonAttibuteValue

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