AuditQuestionnaireSection
Name Data Type Size Comments
Record Questionnaire Section being answered within an Audit
AlertCount int16 Count of child answers with a type of "alert"
AnsweredCount int16 Count of child answers with a type of "answered"
AttachmentCount int16 Count of child attachments
Comments richtext Unlimited rich text comments
Comments_Plain string Plain text equivilent of the corresponding rich text field
CrossReferences string List of other items to which this item is cross-referenced
FindingCount int16 Count of child findings
NormalCount int16 Count of child answers with a type of "normal"
NoteCount int16 Count of child notes
ProblemCount int16 Count of child answers with a type of "problem"
Progress int16 Percentage of the child Questions which require an answer which have one
ReviewCount int16 Count of child reviews
ReviewPointCount int16 Count of child review points
UnansweredCount int16 Count of child answers with a type of "unanswered"
Answers QuestionAnswer 1:M Link to child Answers
Approval SignOff 1:1 Link to Sign Off which contains when the record was Approved and when
Attachments Attachment 1:M Link to child Attachments
ChildFindings Finding 1:M Link to all child findings (i.e. including ones linked indirectly)
Completion SignOff 1:1 Link to Sign Off which contains when the record was Completed and when
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
Questionnaire AuditQuestionnaire M:1 Link to the parent Questionnaire
QuestionnaireTailoring AuditQuestionnaire 1:1 Link to the parent Questionnaire for which this is the "tailoring" section
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 QuestionnaireSection M:1 Link to the parent Section
SignOffState SignOffState M:1 Whether the item is "Open", "Completed" or "Approved"