Question
Name Data Type Size Comments
An individual question which forms part of a larger Questionnaire
Active boolean Whether or not the item is currently available for use
AnswerNames string List of answers to the Question
BooleanAnswer boolean The answer for a "boolean" type Question
CategoryNames string List of names of the categories of the question
Comments richtext Unlimited rich text comments
Comments_Plain string Plain text equivilent of the corresponding rich text field
DateAnswer date (8) The answer for a "date" type Question
DecimalAnswer decimal (18,2) The answer for a "decimal" type Question
Description richtext Standard unlimited rich text description
Folder1Name string (555) Name of first-level folder
Folder2Name string (555) Name of second-level folder
Folder3Name string (555) Name of third-level folder
Folder4Name string (555) Name of fourth-level folder
HelpItemCount int16 Count of child help items
Hidden boolean Whether or not the Question should be hidden from the end-users
IntegerAnswer int16 The answer for a "integer" type Question
InversionCount int16 Count of child inversions
Logic string Logic statement associated to the item
LogicTitle string (100) Title of Question when referenced in the logic of subsequent Questions
LogicUsed boolean Calculated property indicating if the Question is referenced the logic of a later Question
Name string (555) Constructed from the Ref and Title
Order int16 Order in which item appears (amongst siblings)
Ref string (50) Standard short reference
SourceItemCount int16 Count of child source items
TextAnswer string The answer for a "text" type Question
Title string (500) Standard short title
UniqueId guid Used for uniquely identifying the item during "mapping"
Answers Answer M:M Link to child Answers
AnswerSet AnswerSet M:1 Link to the related Answer Set
AnswerType AnswerType M:1 Whether the item is "answered", "unanswered" and "not required"
Categories QuestionCategory M:M Simple segmentation
Children Question 1:M Link to child Questions
Folder QuestionFolder M:1 Link to the parent Question Folder
HelpItems HelpItem M:M Link to the child Help Items
Inversions QuestionInversion 1:M Link to the child Inversions
Parent Question M:1 Link to parent Question
QuestionAnswers QuestionAnswer 1:M Link to child Answers
Section QuestionnaireSection M:1 Link to the parent Section
SourceItems SourceItem M:M Link to child source items
Type QuestionType M:1 Whether the item is "none", "one", "many", etc