EntityControl
Name Data Type Size Comments
A procedure in place to address an objective or risk
ActionCount int16 Count of child actions
AssessmentCount int16 Count of child assessments
AttachmentCount int16 Count of child attachments
AuditTypeNames string List of audit types which the item applies to
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
DueDate date (8) Date when external assessment is due
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 an external assessment
ReviewCount int16 Count of child Reviews
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
Actions Action 1:M Link to child Actions
ActiveState ActiveState M:1 Whether the item is "Draft", "Live" or "Closed"
Assessments EntityControlAssessment 1:M Link to child assessments
Attachments Attachment 1:M Link to child Attachments
AuditTypes AuditType M:M Audit types for which the work plan is included if default
BusinessOwner Person M:1 Person who is responsible for the item in the business (used for permissions)
BusinessReviewer Person M:1 Person who is responsible for reviewing 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
Components ControlComponent M:M Tick-many segmentation which is calculated based on the principles
Controls Control 1:M Link to child Controls
CurrentAssessment EntityControlAssessment 1:1 Link to the current assessment (which will also be in the list of all assessments)
CurrentExternalAssessment EntityControlAssessment 1:1 Link to the current external assessment (which will also be in the list of all assessments)
EntityProcess EntityProcess M:1 Link to parent Entity/Process
Importance ControlImportance M:1 Basic segmentation
LastReview Review 1:1 Link to the last Review
LinkedObjectives EntityObjective M:M Link to all related Objectives
LinkedRisks EntityRisk M:M Link to all related Risks
Method ControlMethod M:1 Basic segmentation
Notes Note 1:M Link to child Notes
Objective EntityObjective M:1 Link to parent Objective
ParentObjective EntityObjective M:1 Link to ultimate parent Objective
PreviousAssessment EntityControlAssessment 1:1 Link to the previous assessment (which will also be in the list of all assessments)
PreviousExternalAssessment EntityControlAssessment 1:1 Link to the previous external assessment (which will also be in the list of all assessments)
Principles ControlPrinciple M:M Tick-many segmentation which is used to determine the components
Reviews Review 1:M Link to child Reviews
ReviewState ReviewState M:1 Whether the item is "Not Reviewed", "Reviewed" or "Changed"
Risk EntityRisk M:1 Link to parent Risk
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 EntityTest 1:M Link to child Tests
Type ControlType M:1 Basic segmentation