OrganizationAttributeValue

Entity Definition

Logical Name : OrganizationAttributeValue
Physical Name : CO_ORGN_ATTR_VL

Captures the assignment of a value to an AttributeType for an Organization.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
OrganizationAttributeValueID (PK) Token ID for an OrganizationAttributeValue ID_ORGN_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)
Organization (FK) A unique, system assigned identity for a Party. ID_PRTY_ORGN Identity integer Organization(PA_ORGN)
OrganizationAttributeValue The value assigned to this OrganizationAttributeType. CH_ORGN_ATTR_VL DescriptionShort varchar(255)
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 OrganizationAttributeValue. 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 OrganizationAttributeValue
Organization is described by OrganizationAttributeValue

Logical Views containing OrganizationAttributeValue

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