AuditProcess
Name Data Type Size Comments
Represents a (Entity) Process within an Audit
AttachmentCount int16 Count of child attachments
CertificationComments richtext Unlimited rich text to explain the certification
CertificationComments_Plain string Plain text equivilent of the corresponding rich text field
CertifiedTime datetime Date/time when the item was certified
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
Name string (1200) Constructed from the Ref and Title
NoteCount int16 Count of child notes
NotifiedDate date (8) Date when owner was notified of item
ObjectiveCount int16 Count of child objectives
RespondByDate date (8) Date by when their should be a response
ReviewPointCount int16 Count of child review points
SOXAccountNames string List of names of the related SOX accounts
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
BusinessOwner Person M:1 Person who is responsible for the item in the business (used for permissions)
CertificationState CertificationState M:1 Whether the item is "Not Certified", "Certified With Exceptions" or "Certified"
CertifiedBy Person M:1 Link to Person who certified the item
Completion SignOff 1:1 Link to Sign Off which contains when the record was Completed and when
Configuration MatrixConfiguration M:1 Link to (matrix) configuration which applies to item
Confirmation SignOff 1:1 Link to Sign Off which contains when the record was Confirmed and when
Controls Control 1:M Link to child Controls
EntityProcess EntityProcess M:1 Link to parent Entity/Process
Notes Note 1:M Link to child notes
Objectives Objective 1:M Link to child objectives
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
ReviewPoints ReviewPoint 1:M Link to child review points
SignOffState SignOffState M:1 Whether the item is "Open", "Completed" or "Approved"
SOXAccounts SOXAccount M:M SOX Accounts to which the item relates
Tests Test 1:M Link to child Tests