Entity Definition

Logical Name : CustomerOccasion
Physical Name : PA_OCCN_CT

An event celebrated or observed by a Customer.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
CustomerOccasionTypeCode (FK)(PK) A retailer assigned code for the CustomerOccasionType. TY_OCCN_CT Code6 char(6) CustomerOccasionType(PA_OCCN_CT_TYP)
CustomerID (FK)(PK) A unique system assigned identifier for the Customer. ID_CT Identity integer Customer(PA_CT)
CustomerOccasionDate (PK) The start date of a an event or other occasion that a customer celebrates. DC_OCCN_CT DateCalendar date


Parent Entity Verb Phrase Child Entity
CustomerOccasionType describes CustomerOccasion
Customer celebrates CustomerOccasion
CustomerOccasion leads to CustomerGiftRegistry

Logical Views containing CustomerOccasion

Logical View
Logical 02300 - Retail Transaction - Macro View
Logical 07010 - Customer Account Information Extended
Logical 07040 - Customer Segment Dependent Behavior