Expand All Collapse All
Survey Detail

SurveyDetail Table

Survey Detail

The SurveyDetail table contains detailed information about the result of a survey. There is one row per survey offered.

  • Table Type - Historical
  • Last Changed Version - 4.0.106.453
  • Last Changed Reason - 4.0 Release

SQL Column Definitions

Column Data Type (Size) Is Nullable Contains PII Description Last Change Version Last Change Reason CX Insights Name CX Insights Type CX Insights Folder Name
SurveyFormID uniqueidentifier False No

ID of the survey form.

 4.0.106.453 4.0 Release Survey Form ID Attribute CSSurvey
EventCode int False No

Event code for how the survey ended.

  • 0 - None
  • 1 - Complete
  • 2 - Abandoned
  • 3 - Insufficient Resources
  • 4 - Opt-out
  • 5 - Error
  • 6 - NotAnswered
  • 7 - Caller Disconnect
 4.0.106.453 4.0 Release Event Code Fact CSSurvey
EventDetail nvarchar (255) True Depends on customer usage

Textual representation of the EventCode column. See EventCode for code and detail pairing.

 4.0.106.453 4.0 Release Event Detail Attribute CSSurvey
EventDate datetime False No

UTC Date and time of when the survey was taken.

 4.0.106.453 4.0 Release Event Date Attribute CSSurvey
CallIdKey varchar (20) False No

Full 18 digit call ID key of the interaction.

 4.0.106.453 4.0 Release Call Id Key Attribute CSSurvey
Origin int False No

Origin of the survey

  • 0 - Post-call
  • 1 - External
  • 2 - Internal
  • 3 - Transfer
  • 4 - Outbound
 4.0.106.453 4.0 Release Origin Fact CSSurvey

SQL Constraints

Primary Key Name Type Column Name (sort order)
PK_SurveyDetail Non-clustered SurveyFormID (Ascending)

Foreign Key Name Column Reference Table Reference Column Indexed
FK_SurveyDetail_SurveyFormID SurveyFormID SurveyForm SurveyFormId

Index Name Type Column Name (sort order)
IX_SurveyDetail_EventDate Clustered EventDate (Ascending)