Control Assurance

Control Register

TABLE status, criticality, implementation_state, business_owner, requirements, procedures, systems, next_review
FROM "06 Controls"
WHERE type = "control"
SORT criticality DESC, file.name ASC

Controls Pending Implementation

TABLE status, criticality, business_owner, requirements, procedures, systems, next_review
FROM "06 Controls"
WHERE implementation_state = "planned"
SORT criticality DESC, file.name ASC

Current Controls

TABLE status, criticality, business_owner, requirements, procedures, systems
FROM "06 Controls"
WHERE implementation_state = "current"
SORT criticality DESC, file.name ASC

Controls Linked to Open Issues

TABLE status, criticality, business_owner, issues, next_review
FROM "06 Controls"
WHERE length(issues) > 0
SORT criticality DESC, next_review ASC