QuestionAnswer
Name Data Type Size Comments
The answer to a Question with respect to a specific Audit Questionnaire
Active boolean Whether or not the item is currently available for use
AnswerNames string List of answers to the Question
AttachmentCount int16 Count of child attachments
BooleanAnswer boolean The answer for a "boolean" type 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
FindingCount int16 Count of child findings
IntegerAnswer int16 The answer for a "integer" type Question
NoteCount int16 Count of child notes
ReviewCount int16 Count of child reviews
ReviewPointCount int16 Count of child review points
Score int16 Score associated to the given answer(s)
TextAnswer string The answer for a "text" type Question
Answers Answer M:M Link to child Answers
Attachments Attachment 1:M Link to child Attachments
Findings Finding 1:M Link to child Findings
LastReview Review 1:1 Link to the last Review
Notes Note 1:M Link to child Notes
OfflineCheckOut OfflineCheckOut 1:1 Link to child check out which contains who/when item was checked out
Question Question M:1 Link to the parent Question
ReviewPoints ReviewPoint 1:M Link to child Review Points
Reviews Review 1:M Link to child Reviews
ReviewState ReviewState M:1 Whether the item is "Not Reviewed", "Reviewed" or "Changed"
Section AuditQuestionnaireSection M:1 Link to the parent Section
Type AnswerType M:1 Whether the item is "answered", "unanswered" and "not required"