ControlTemplate
Name Data Type Size Comments
A template for a procedure in place to address an objective or risk
AssessmentCount int16 Count of child assessments
AttachmentCount int16 Count of child attachments
AuditTypeNames string List of audit types which the item applies to
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
Guidance richtext Unlimited rich text displayed when viewing any record originally created from this record
Guidance_Plain string Plain text equivilent of the corresponding rich text field
Locked boolean Whether or not the item definition is read-only to end users
Name string (555) Constructed from the Ref and Title
PrincipleNames string List of principles which the item applies to
Ref string (50) Standard short reference
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
ActiveState ActiveState M:1 Whether the item is "Draft", "Live" or "Closed"
Assessments ControlTemplateAssessment 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
Category ControlCategory M:1 Simple segmentation
ChildFindings FindingTemplate 1:M Link to all child findings (i.e. including ones linked indirectly)
Components ControlComponent M:M Tick-many segmentation which is calculated based on the principles
Controls Control 1:M Link to child Controls
CurrentAssessment ControlTemplateAssessment 1:1 Link to the current assessment (which will also be in the list of all assessments)
EntityControls EntityControl 1:M Link to child Entity Controls
Findings FindingTemplate 1:M Link to child Findings
Importance ControlImportance M:1 Basic segmentation
LinkedObjectives ObjectiveTemplate M:M Link to all related Objectives
LinkedRisks RiskTemplate M:M Link to all related Risks
Method ControlMethod M:1 Basic segmentation
Objective ObjectiveTemplate M:1 Link to parent Objective
ParentObjective ObjectiveTemplate M:1 Link to ultimate parent Objective
Principles ControlPrinciple M:M Tick-many segmentation which is used to determine the components
Process Process M:1 Link to parent Process
Risk RiskTemplate 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
Tests TestTemplate 1:M Link to child Tests
Type ControlType M:1 Basic segmentation