Problem
Name Data Type Size Comments
A grouping for findings within an audit
ActionCount int16 Count of child actions
AttachmentCount int16 Count of child attachments
CrossReferences string List of other items to which this item is cross-referenced
DepartmentNames string List of names of the related departments
Description richtext Standard unlimited rich text description
Description_Plain string Plain text equivilent of the corresponding rich text field
EntityNames string List of names of the entities of the item
FindingCount int16 Count of child findings
KeyIssueCount int16 Count of child key issues
Name string (555) Constructed from the Ref and Title
NoteCount int16 Count of child notes
OrgUnit1Names string List of names of the first-level org units of the item
OrgUnit2Names string List of names of the second-level org units of the item
OrgUnit3Names string List of names of the third-level org units of the item
OrgUnit4Names string List of names of the fourth-level org units of the item
ProcessArea1Names string List of names of the first-level process areas of the item
ProcessArea2Names string List of names of the second-level process areas of the item
ProcessArea3Names string List of names of the third-level process areas of the item
ProcessArea4Names string List of names of the fourth-level process areas of the item
ProcessNames string List of names of the processes of the item
Ref string (50) Standard short reference
ResolutionComments richtext Unlimited rich text Comments to accompany Resolution
ResolutionComments_Plain string Plain text equivilent of the corresponding rich text field
ReviewCount int16 Count of child reviews
ReviewPointCount int16 Count of child review points
ScopeNames string List of entity/processes which are covered by the item scope
Title string (500) Standard short title
Actions Action 1:M Link to child Actions
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
Category ProblemCategory M:1 Simple segmentation
Completion SignOff 1:1 Link to Sign Off which contains when the record was Completed and when
Confirmation SignOff 1:1 Link to Sign Off which contains when the record was confirmed and when
Departments Department M:M Department to which the item is assigned (used for permissions)
Findings Finding M:M Link to child findings
KeyIssues KeyIssue M:M Link to child key issues
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
Owner Person M:1 Person who owns the item which is used for permissions
Preparation SignOff 1:1 Link to Sign Off which contains when the record was prepared and when
Resolution ProblemResolution M:1 Basic segmentation
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"
Scope EntityProcess M:M Entity/Processes (i.e universe matrix) which are covered by the Audit
SignOffState SignOffState M:1 Whether the item is "Open", "Completed" or "Approved"