Entity Definition

Logical Name : CustomerSurveyResponse
Physical Name : DO_SRVY_CT_RSPS

A specific customer's survey responses

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
CustomerSurveyID (FK)(PK) A unique retailer assigned identifier for the CustomerSurvery. ID_SRVY_CT Identity integer SurveyQuestion(DO_SRVY_QST)
SurveyQuestionID (FK)(PK) Unique retailer assigned identifier for the SurveyQuestion within the context of the CustomerSurvey. ID_SRVY_QST Identity integer SurveyQuestion(DO_SRVY_QST)
CustomerID (FK)(PK) A unique system assigned identifier for the Customer. ID_CT Identity integer Customer(PA_CT)
ResponseDate The date the Customer provided the response to the CustomerSurvey DC_RSP DateCalendar date
Response The response the Customer gave to the particular SurveyQuestion. DE_RSP DescriptionShort varchar(255)


Parent Entity Verb Phrase Child Entity
Customer provides CustomerSurveyResponse
SurveyQuestion is answered in CustomerSurveyResponse
CustomerSurveyResponse elicits CustomerPreference

Logical Views containing CustomerSurveyResponse

Logical View
Logical 07010 - Customer Account Information Extended