07 — Aggregate / IU / Document / System-Issue Pivots

What physically exists

Only two PIV-3xx aggregate pivots are physical in pivot_definitions:

code	name	source_object	active
PIV-311	Information Units — Total	information_unit	true
PIV-313	System Issues (open) — Total	system_issues	true

PIV-310 (documents), PIV-301 / 302 / 303 do NOT exist. Any doc/UI referencing them is describing un-built pivots. → UNVERIFIABLE / not-built (max physical aggregate pivot = PIV-313). Do not show these as live counts.

Reconciliation against live source — PASS (exact)

pivot	pivot count_value	live source	match
PIV-311	219	SELECT count(*) FROM information_unit = 219 (filter [] = all)	EXACT
PIV-313	220,170	SELECT count(*) FROM system_issues WHERE status='open' (total 220,864)	EXACT, documented filter

• PIV-311: empty filter, drift null, substrate_ref information_unit. Live and correct.
• PIV-313: filter_spec {status = open} → 220,170 of 220,864 total (694 non-open excluded). drift_status ok. Live and correct. The "open" qualifier is in the pivot name and filter — honest.

system_issues is a large, fast-growing table (220,864 now vs ~216,114 a few days ago) → PIV-313 will drift as a cached number but is recomputed LIVE. ACCEPTABLE_BACKGROUND_DRIFT.

Classification

• PIV-311, PIV-313 → OK / FINAL (exact live reconciliation).
• PIV-301/302/303/310 → UNVERIFIABLE (do not exist; remove from any UI/contract that claims them).

Score: 82/100

The two pivots that exist are among the most trustworthy counts in the system (exact match to live source with documented filters). Docked only because the broader aggregate-pivot family referenced in narrative docs is not built — a UI driven by those references would show phantom counts.