Expand All Collapse All
Survey Prompt

SurveyPrompt Table

Survey Prompt

The SurveyPrompt table contains information about prompts available for use.

  • Table Type - Lookup
  • 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
SurveyPromptID varchar (32) False No

ID of the survey prompt.

 4.0.106.453 4.0 Release Survey Prompt ID Attribute CSSurvey
PromptType int False No

Type of prompt.

  • 0 - None
  • 1 - File-based Prompt
  • 2 - Handler-based Prompt
  • 3 - TTS-based Prompt
 4.0.106.453 4.0 Release Prompt Type Fact CSSurvey
PromptName nvarchar (255) True Depends on customer usage

Name of the prompt.

 4.0.106.453 4.0 Release Prompt Name Attribute CSSurvey
RecordingFile nvarchar (255) True Depends on customer usage

Filename of the recorded file. All survey prompts are located at I3ICResourcesSurveyPrompts on the IC server.

 4.0.106.453 4.0 Release Recording File Attribute CSSurvey
PromptText nvarchar (1024) True Depends on customer usage

Text-to-speech that will play if the prompt is unavailable.

 4.0.106.453 4.0 Release Prompt Text Attribute CSSurvey

SQL Constraints

Primary Key Name Type Column Name (sort order)
PK_SurveyPrompt Clustered SurveyPromptID (Ascending)