AuditQuestionnaire
Name Data Type Size Comments
Record Questionnaire 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
SectionCount int16 Count of child sections
UnansweredCount int16 Count of child answers with a type of "unanswered"
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
Audit Audit M:1 Link to parent Audit
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
LockedBy Person M:1 Person who is currently answering the Questionnaire
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
Owner Person M:1 Person who owns the item which is used for permissions
Questionnaire Questionnaire M:1 Link to the parent Questionnaire
QuestionnaireState QuestionnaireState M:1 Whether the item is "open", "tailoring complete", "tailoring approved", "complete", "approved"
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"
ScopeState ScopeState M:1 Whether the item is "In Scope" or "Out of Scope"
Sections AuditQuestionnaireSection 1:M Link to child Sections
SignOffState SignOffState M:1 Whether the item is "Open", "Completed" or "Approved"
TailoringSection AuditQuestionnaireSection 1:1 Link to the child Tailoring Section