Entity Definition

Logical Name : CustomerAccountCardAssignment
Physical Name : CO_ASGMT_CTAC_CRD

A record of the period of time which a CustomerAccountCard was assigned to a particular CustomerAccount.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
CustomerAccountID (FK)(PK) A unique identifier for a customer account. ID_CTAC Identity integer CustomerAccount(LE_CTAC)
CustomerAccountCardID (FK)(PK) A 16 digit Credit or Debit card PAN as defined by ISO-7812, uniquely identifying CustomerAccountCard. AI_ACNT_CT_CRD CreditDebitCardPAN varchar(20) CustomerAccountCard(LE_ACNT_CT_CRD)
StatusCode A unqiue retailer assigned code denoting the status of the assignment. SC_ASGMT_CTAC_CRD Code2Status char(2)
EffectiveDate The date at which the assignment commences. DC_EF EffectiveDate date
ExpirationDate The date at which the assignment finishes. DC_EP ExpirationDate date


Parent Entity Verb Phrase Child Entity
CustomerAccountCard is assigned CustomerAccountCardAssignment
CustomerAccount is assigned CustomerAccountCardAssignment

Logical Views containing CustomerAccountCardAssignment

Logical View
Logical 07010 - Customer Account Information Extended
Logical 07200 - Customer Purchase Transaction History View