› (uploaded from local; see content below)

Checkpoint — RP Final Acceptance, Law/Pin/UI & Information Handoff (MCP-readable short SSOT)

Date: 2026-06-03 Macro: REGISTRIES_PIVOT_FINAL_ACCEPTANCE_LAW_RATIFY_PIN_UI_AND_INFORMATION_HANDOFF Final status: PARTIAL — all safe engineering branches complete & live; blocker is owner law-ratification + operator UI redeploy (both non-engineering). Execution mode: EXECUTION_MODE (read query_pg RO directus; write ssh contabo → docker exec -i postgres psql -U workflow_admin, superuser, read_only off; temp-object rollback verified).

Live mutation: YES — 5 additive, reversible objects

1. registry_pin (table, empty) — pinning.
2. rp_grouping_policy (table, default threshold 50) — auto-grouping.
3. v_registries_pivot_node_contract REPLACE — pin_state now honest (PINNED/UNPINNED); other 25 cols byte-identical.
4. v_registries_pivot_surface NEW — pin ordering (pin_sort_rank) + grouping (grouping_status).
5. v_pivot_dot_by_category REPLACE — dropped stale status='published' filter → 25 groups / 309 (was 16; now agrees with canon PIV-104). Rehearsed BEGIN..ROLLBACK net-0 first (birth 1,132,025 before==after — no DDL birth side-effect; pin demo proven then rolled back). No birth, no composition fix, no dot-pivot-update, no governance change.

Aggregate law status

orphan PIV-301=59 CANDIDATE · phantom PIV-302=289 CANDIDATE · drift PIV-303=3 CANDIDATE · KG PIV-312=2,259 NEEDS_LAW_DEFINITION · unmanaged PIV-304=NULL NEEDS_LAW_DEFINITION · grand-total PIV-500=NULL NOT_A_PIVOT_EQUATION_VIEW. 0 faked, 0 promoted to canon.

Registry_pin status: LIVE + proven (empty; owner inserts). pin_state honest in base contract; ordering in v_registries_pivot_surface.

Auto-grouping status: LIVE + deterministic (default 50; pivot>species>default). DOT 309 SATISFIED; birth/issues/IU/PIV-005 NEEDS_GROUPING; small roots NOT_REQUIRED.

UI/API acceptance: VERIFIED honest on core (PG-only counts, no Nuxt math, legacy /knowledge/registries parity, drill via fn, FAILED-not-fake-green: 152 ok/5 unverified/3 failed). PATCH-READY for pin/grouping/candidate/drill — ticket RP_UI_CONSUME_SURFACE_AND_CANDIDATES (P1–P5). No redeploy (operator-gated).

End-to-end layer proof: DONE — L1 totals+status+grouping+pin; DOT 309→25 groups RECONCILES; IU/issues aggregates; candidate/warning non-final; final substrate ×24.

Count integrity: 160 leaves (152 ok/5 unverified/3 failed); surplus 21,224; 22 pivot-backed leaves; grand total unverifiable_at_grand_total; no WARNING_DRILL_MISMATCH.

Done-for-information-work: YES. Done-for-UI-implementation: YES (backend).

Exact remaining blocker: owner law-ratification + operator UI redeploy. Engineering complete.

Next information-piece macro: resume miếng thông tin on live surface — consume v_registries_pivot_surface + v_rp_aggregate_candidate_register + fn_registries_pivot_node_substrate; FINAL=pivot_backed, CANDIDATE=register rows; define group pivots for NEEDS_GROUPING roots; pin owner rows.

Reports: knowledge/dev/reports/architecture/registries-pivot-final-acceptance-law-pin-ui-information-handoff-2026-06-03/ (docs 00–11). SQL: /tmp/rp_final_apply.sql + /tmp/rp_final_rollback.sql.