Entity Definition

Logical Name : CustomerPreference
Physical Name : PA_PRFC_CT

A description of a Customer's merchandise preferences for classes of items or general categories..

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
PreferenceTypeCode (FK)(PK) A unique code for a group of preferences. For instance, all the types of material (clothing) preferences may be grouped together. TY_PRFC Code2 char(2) PreferenceType(PA_PRFC_TYP)
CustomerID (FK) A unique system assigned identifier for the Customer. ID_CT Identity integer CustomerSurveyResponse(DO_SRVY_CT_RSPS)
Description A description of customers likes or dislikes of classes of items, colors, sizes, materials, etc. DE_PRFC_CT DescriptionNarrative varchar(4000)
CustomerSurveyID (FK) A unique retailer assigned identifier for the CustomerSurvery. ID_SRVY_CT Identity integer CustomerSurveyResponse(DO_SRVY_CT_RSPS)
SurveyQuestionID (FK) Unique retailer assigned identifier for the SurveyQuestion within the context of the CustomerSurvey. ID_SRVY_QST Identity integer CustomerSurveyResponse(DO_SRVY_CT_RSPS)


Parent Entity Verb Phrase Child Entity
PreferenceType categorizes CustomerPreference
CustomerSurveyResponse elicits CustomerPreference

Logical Views containing CustomerPreference

Logical View
Logical 07010 - Customer Account Information Extended
Logical 10400 - Enterprise - Channels