Entity Definition

Logical Name : CustomerGiftRegistry
Physical Name : TR_RGST_CT_GF

A specific Customer's gift registry for a particular Occasion. Individual Items are added to the Registry by GiftRegisteredItem; while whole groups of Items are added to the Registry by GiftRegisteredItemGroup.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
GiftRegistryID (PK) A unique system assigned identifier for this particular CustomerGiftRegistry. ID_RGST_CT_GF Identity integer
CustomerID (FK) A unique system assigned identifier for the Customer. ID_CT Identity integer CustomerOccasion(PA_OCCN_CT)
CustomerOccasionDate (FK) The start date of a an event or other occasion that a customer celebrates. DC_OCCN_CT DateCalendar date CustomerOccasion(PA_OCCN_CT)
Date The date that a CUSTOMER GIFT RESTRATION is created. DC_RGST_CT_GF DateCalendar date
CustomerOccasionTypeCode (FK) A retailer assigned code for the CustomerOccasionType. TY_OCCN_CT Code6 char(6) CustomerOccasion(PA_OCCN_CT)


Parent Entity Verb Phrase Child Entity
CustomerOccasion leads to CustomerGiftRegistry
CustomerGiftRegistry registers GiftRegistryLineItem
CustomerGiftRegistry registers GiftRegisteredItemGroup

Logical Views containing CustomerGiftRegistry

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