Compliance Overview

Object Inventory

TABLE length(rows) AS "Count"
FROM ""
WHERE type AND !contains(file.path, "99 Archive")
GROUP BY type
SORT type ASC

Critical Objects Not Yet Approved

TABLE type, status, implementation_state, business_owner, approver, next_review
FROM ""
WHERE !contains(file.path, "99 Archive") AND criticality = "critical" AND status != "approved" AND status != "implemented" AND status != "operational" AND status != "closed"
SORT type ASC, file.name ASC

Current Open Issues

TABLE criticality, business_owner, next_review
FROM "08.2 Issues"
WHERE status = "open" OR status = "in_progress"
SORT criticality DESC, next_review ASC

Planned Implementation Objects

TABLE type, status, criticality, business_owner, next_review
FROM ""
WHERE !contains(file.path, "99 Archive") AND implementation_state = "planned"
SORT criticality DESC, type ASC, file.name ASC

Current Implementation Objects

TABLE type, status, criticality, business_owner, next_review
FROM ""
WHERE !contains(file.path, "99 Archive") AND implementation_state = "current"
SORT type ASC, file.name ASC