Expand All Collapse All

IR_Questionnaire Table

  • 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
QuestionnaireId uniqueidentifier False No

4.0.106.453 4.0 Release
QDirectoryId uniqueidentifier False No

4.0.106.453 4.0 Release
QuestionnaireName nvarchar (255) False Depends on customer usage

4.0.106.453 4.0 Release
RankGroupId uniqueidentifier True No

4.0.106.453 4.0 Release
MaxScore numeric True No

4.0.106.453 4.0 Release
MinScore numeric True No

4.0.106.453 4.0 Release
MinAcceptableScore numeric True No

4.0.106.453 4.0 Release
Note nvarchar (1024) True Depends on customer usage

4.0.106.453 4.0 Release
IsTemplate tinyint False No

4.0.106.453 4.0 Release
IsLocked tinyint False No

4.0.106.453 4.0 Release
ShowRankWhileScoring tinyint False No

4.0.106.453 4.0 Release
TotalNumCriticalQuestions int False No

4.0.106.453 4.0 Release
Version int False No

4.0.106.453 4.0 Release
IsActive tinyint False No

4.0.106.453 4.0 Release
ShowPassFailWhileScoring tinyint False No

4.0.106.453 4.0 Release

SQL Constraints

Primary Key Name Type Column Name (sort order)
PK_IR_Questionnaire Clustered QuestionnaireId (Ascending)

Foreign Key Name Column Reference Table Reference Column Indexed
FK_IR_Qnaire_QDirectoryId QDirectoryId IR_QDirectory QDirectoryId Yes
FK_IR_Questionnair_RankGroupId RankGroupId IR_RankGroup RankGroupId Yes