Entity Definition

Logical Name : PartyAffiliation
Physical Name : CO_AFLN_PRTY

A relationship between two Partys that has some meaning to the Retailer.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
PartyAffiliationTypeCode (FK)(PK) A unique retailer assigned 2 leter code denoting the type of affiliation between two Partys. CD_TYP_PRTY_AFLN Code varchar(20) PartyAffiliationType(CO_TYP_PRTY_AFLN)
PartyID (FK)(PK) A unique, system assigned identity for a Party. ID_PRTY Identity integer Party(PA_PRTY)
SubPartyID (FK)(PK) A unique, system assigned identity for a Party. ID_PRTY_AFLN Identity integer Party(PA_PRTY)
ChannelID (FK) Token Identifier for a channel instance ID_CHNL Identity integer Channel(CO_CHNL)
InvolvementTypeCode (FK) Identifies and names a category of involvement. Examples: CREATORS - create content and originate ideas for the community CRITICS - review and comment on others' work COLLECTORS - Use material from others, add tag lines, comments JOINERS - Maintain profiles, visit SPECTATORS - Read material, read reviews, etc. INACTIVES - Joined community but not active This typically applies to PartyAffiliations between Person and Community. CD_INVLVMNT_TYP Code varchar(20) InvolvementType(LU_INVLVMNT)
EffectiveDateTime The date and time the affiliation between two parties was inforce DT_AFLN_EF EffectiveDateTime datetime
ExpirationDateTime The date and time the affiliation between two parties was no longer in force. DT_AFLN_EP ExpirationDateTime datetime
StatusCode Current status of the affiliation between two parties. Values include: ACTIVE INACTIVE Retailers may add other values if required, SC_AFLN Code2Status char(2)
PrincipleSubPartyFlag Boolean indicator that tells if the SubPartyID in this affiliation is a principle sub party or not. A principle subparty applies to affiliations like households and serves to identify the name and address of the "lead" member for contact purposes. A given household (or any non person group, community or houshold party type) may have one and only one designated PrincipleSubParty. Note that this rule has to be enforced in stored procedures or application code. It is not built into the data model. FL_PRCNPL_SUB_PRTY Flag integer


Parent Entity Verb Phrase Child Entity
Party is affiliated via PartyAffiliation
Party is affiliated via PartyAffiliation
InvolvementType defines magnitude of inflence of PartyAffiliation
Channel facilitated information exchange between PartyAffiliation
PartyAffiliationType categorizes PartyAffiliation

Logical Views containing PartyAffiliation

Logical View
Logical 02341 - Retail Transaction - Change for Charities View
Logical 06310 - Party - Role View
Logical 06320 - Party - Address and Contact View
Logical 07000 - Core Customer Entities
Logical 07010 - Customer Account Information Extended
Logical 07019 - Party-Consumer-Customer Household View
Logical 07030 - Customer Segment Independent Characteristics