09 — Final Summary

Status: ✅ PASS Execution mode: EXECUTION_MODE. Live mutation: YES.

Headline

The Registries-Pivot aggregate/count layer is now materially improved and honest. Two real aggregate totals are live, the DOT drill no longer lies, and every candidate/law-sensitive concept is classified and surfaced (never faked). RP is done enough for miếng thông tin and for read-only UI implementation.

What was committed (3 mutations, all in scope)

1. PIV-311 Information Units = 219, PIV-313 Open System Issues = 207,940 — added to pivot_definitions in one statement; both pivot_backed L1 roots; 2 births landed clean. Roots 24→26, active 35→37.
2. PIV-104 DOT drill fix — dropped the stray status='published' filter; the DOT-by-category drill now sums to 309 and RECONCILES to parent PIV-007 (proven in v_rp_drill_reconciliation).
3. Two additive read-only views — v_rp_drill_reconciliation (parent↔child reconciliation with an honest partition law; no mismatch remains) and v_rp_aggregate_candidate_register (the explicit candidate/law aggregate surface).

Graph hash 91576fb6… → 8c5d25a8…. Births 1,132,011 → 1,132,013.

Classifications delivered

pivot	result
PIV-311 / PIV-313	FINAL — LIVE
PIV-301 orphan (59) / PIV-302 phantom (289) / PIV-303 drift (3)	CANDIDATE_REPORT_ONLY (register, birth-grain caveat)
PIV-312 KG edges (2,259)	NEEDS_LAW_DEFINITION (register)
PIV-304 unmanaged	NEEDS_LAW_DEFINITION (law draft in doc 04)
PIV-500 grand total	NOT_A_PIVOT_BUT_EQUATION_VIEW (UNVERIFIABLE until anchor ratified)

Count integrity

Honest, not fake-green: equation counted + orphan + phantom + unmanaged; unmanaged NULL + PIV-500 missing ⇒ unverifiable_at_grand_total (warning). DOT drill mismatch resolved; dot_tools record-surplus (146 phantom-candidate) drift retained and surfaced as a distinct, legitimate signal.

Compliance

No RP cleanup; no dot-pivot-update (untouched/invalid); no birth/governance/pre-birth alteration beyond the 2 designed aggregate births; no fake pivots; no Nuxt count math; no hardcoded depth; no hidden PIVOT_MISSING; no unrelated pivot mutated; batch insert (not row-by-row).

Remaining (owner-gated, non-blocking)

Owner ratification of: unmanaged + grand-total law (doc 04), candidate→FINAL promotion (doc 03). Then optionally registry_pin / label-by-facet.

Next macro

REGISTRIES_PIVOT_AGGREGATE_LAW_RATIFY_AND_REGISTRY_PIN — or proceed directly to information-piece work on the live contract.