Performitor

This is an old revision of the document!

Questionnaire Header Table

The Questionnaire Header Table contains key information related to the general setup and meta-data of a questionnaire. This table is essential for organizing the structure and behavior of the questionnaire, including data about modules, dates, anonymous options, and other display parameters. Below is an overview of the table structure:

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	The start date of the record or event. Defines when the questionnaire or event becomes active.
enddate	date	The end date of the record or event. Defines when the questionnaire or event becomes inactive.
lastqdetailid	varchar(200)	Stores the ID of the last question detail answered. Used to track the last question that was interacted with.
lastoptionids	varchar(200)	Stores the option IDs selected for the last question answered. Tracks user responses for the most recent question.
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.