Control
Name Data Type Size Comments
A procedure in place to address an objective or risk
AssessmentCount int16 Count of child assessments
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
ComponentNames string List of components which the item applies to
CrossReferences string List of other items to which this item is cross-referenced
Description richtext Standard unlimited rich text description
Description_Plain string Plain text equivilent of the corresponding rich text field
FindingCount int16 Count of child findings
HasParent boolean Indicates if the item has a "parent" item at entity level
HasTemplate boolean Indicates if the item has a "template" item at library level
Locked boolean Whether or not the item definition is read-only to end users
Name string (555) Constructed from the Ref and Title
NoteCount int16 Count of child notes
NotifiedDate date (8) Date when owner was notified of item
PrincipleNames string List of principles which the item applies to
Ref string (50) Standard short reference
RespondByDate date (8) Date by when their should be a response
ReviewCount int16 Count of child reviews
ReviewPointCount int16 Count of child review points
RiskCount int16 Count of linked risks
SOXAccountNames string List of names of the related SOX accounts
SOXAssertionNames string List of names of the related SOX assertions
TestCount int16 Count of child tests
Title string (500) Standard short title
Approval SignOff 1:1 Link to Sign Off which contains when the record was Approved and when
Assessments ControlAssessment 1:M Link to child assessments
Attachments Attachment 1:M Link to child Attachments
AuditProcess AuditProcess M:1 Link to parent Link to parent Audit/Process
BusinessOwner Person M:1 Person who is responsible for the item in the business (used for permissions)
Category ControlCategory M:1 Simple segmentation
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
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
Components ControlComponent M:M Tick-many segmentation which is calculated based on the principles
Confirmation SignOff 1:1 Link to Sign Off which contains when the record was confirmed and when
CurrentAssessment ControlAssessment 1:1 Link to the current assessment (which will also be in the list of all assessments)
Findings Finding 1:M Link to child Findings
Importance ControlImportance M:1 Basic segmentation
LastReview Review 1:1 Link to the last Review
LinkedObjectives Objective M:M Link to all related Objectives
LinkedRisks Risk M:M Link to all related Risks
Method ControlMethod M:1 Basic segmentation
Notes Note 1:M Link to child Notes
Objective Objective M:1 Link to parent Objective
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
Parent EntityControl M:1 Link to Entity item from which this item was created
ParentObjective Objective M:1 Link to ultimate parent Objective
Preparation SignOff 1:1 Link to Sign Off which contains when the record was prepared and when
Principles ControlPrinciple M:M Tick-many segmentation which is used to determine the components
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"
Risk Risk M:1 Link to parent Risk
ScopeState ScopeState M:1 Whether the item is "In Scope" or "Out of Scope"
SignOffState SignOffState M:1 Whether the item is "Open", "Completed" or "Approved"
SOXAccounts SOXAccount M:M SOX Accounts to which the item relates
SOXAssertions SOXAssertion M:M SOX Assertions to which the item relates
Template ControlTemplate M:1 Link to the template from which this item was created
Tests Test 1:M Link to child Tests
Type ControlType M:1 Basic segmentation