Performitor

Questionnaire Header Table

The Questionnaire Header Table is used to store essential metadata and configuration settings for each questionnaire in the system. Each entry represents a distinct questionnaire, including details such as the start and end dates, associated questions, display conditions, and status. This table is key to organizing and managing the structure of questionnaires, ensuring that they are correctly displayed and function according to the defined settings, both in the backend and during the survey process. It also includes features like anonymous options, filtering criteria, and language conversion for tailored survey experiences.

Name	Type	Comments
id	Primary	ID of the record (auto-incremented). This is the unique identifier for each record in the table.
moduleid	Index	ID of the module associated with the record. This links the record to a specific module.
startdate	date	Defines when the questionnaire active.
enddate	date	Defines when the questionnaire becomes inactive.
lastqdetailid	varchar(200)	Stores the last qdetail Id of the questionnaire. Used to track the last question that was interacted with.
lastoptionids	varchar(200)	Stores the last option ID if the questionnaire.
anonymousoptions	varchar(200)	Stores the options considered anonymous. Typically used to identify responses that shouldn't be traceable to users.
anonymousinvcnt	int	The number of anonymous invitations sent. This tracks how many anonymous invitations have been issued.
caseanonymoptions	varchar(200)	Used to define anonymous options for action lists in surveys, import data, or invitation screens, excluding some data.
status	int	Indicates the status of the record: 1=active, 0=inactive, 2=archive. Reflects whether the record is in use, archived, or inactive.
filterquestions	varchar(200)	Stores a list of filtered question IDs. This specifies which questions should be excluded from the questionnaire.
nooftilesperpage	int	Defines the number of tiles to display per page in the UI. Affects the layout and pagination in the display.
noofcolperpage	int	Defines the number of columns to display per page in the UI. Used to control the column layout per page.
branchlevelqtnposition	text	Defines the display order and corresponding text for branch-level questions, separated by commas and special characters.
branchlevelqtnmenuid	int	Stores the menu ID for branch-level questions. Identifies the menu or section in which the question will appear.
maxtags	int	Defines the maximum number of tags to display in the tag cloud. Controls the display of tags based on frequency.
tagfrequency	int	Specifies how often a word must appear to be treated as a tag. Defines the threshold for a word to be considered a tag.
counttagonce	int	Ensures that each word from each respondent is counted only once in the tag cloud, regardless of frequency.
optoutoptionids	varchar(200)	Stores the option IDs for “opt-out” questions. Selecting these options will immediately end the survey.
vraagreferenceqdetailid	int	If set, updates the `dispcndtn` and `dispprms` for the referenced question details when new tailor-made questions are added.
emotionqdetailids	varchar(200)	Stores the question detail IDs for emotion-related questions. Links emotional responses with the survey questions.
settileemptytxt	int	If set, allows default text to be displayed when graph content is empty (useful for empty or incomplete responses).
noofopenansinexport	int	Defines the number of open-answer questions to include in the export. Default is 100. Can be adjusted based on requirements.
emotionlibrarytype	varchar(250)	Specifies the type of emotion library used. Defines which emotional data or categories the survey will reference.
topiclibrarytype	varchar(100)	Specifies the type of topic library used. Identifies the set of topics available for categorizing survey questions.
topiclibraryversion	text	Stores version information for the topic library. Tracks which version of the library is being used.
languageconversion	varchar(100)	Specifies the language conversion applied to the survey (e.g., French to Dutch). Defines which languages are used for translation.
newlanguageconversion	varchar(100)	Specifies a language conversion between Dutch and English. Typically used when supporting bilingual surveys.