Traceability Gaps

Requirements Missing Downstream Implementation

TABLE status, criticality, policies, procedures, controls, systems, publications
FROM "02 Requirements"
WHERE type = "requirement" AND (length(policies) = 0 OR length(procedures) = 0 OR length(controls) = 0)
SORT criticality DESC, file.name ASC

Controls Missing Procedure or System Link

TABLE status, criticality, requirements, procedures, systems, implementation_state
FROM "06 Controls"
WHERE type = "control" AND (length(requirements) = 0 OR length(procedures) = 0 OR length(systems) = 0)
SORT criticality DESC, file.name ASC

Processes Missing Operating Objects

TABLE status, criticality, requirements, procedures, controls, systems
FROM "03 Processes"
WHERE type = "process" AND (length(requirements) = 0 OR length(procedures) = 0 OR length(controls) = 0)
SORT criticality DESC, file.name ASC

Review Packs With Open Issues

TABLE status, criticality, issues, next_review
FROM "10 Review Packs"
WHERE type = "review_pack" AND length(issues) > 0
SORT criticality DESC, next_review ASC