10 — Pilot Mappings (VERIFIED v2)

Format: current source → target pivot → missing → UI path → no-hardcode strategy. Numbers verified live.

Pilot 1 — DOT Registry List

• Current: dot_tools (309 live) counted via CAT-006 (record 309 / actual 163), CAT-DOT (record 307, dot_total), and PIV-007 (309, fresh 13:27).
• Target pivot: PIV-007 (source_object=dot_tools, species=dot_tool, registry_group=công_cụ).
• Missing: dedupe CAT-006/CAT-DOT → one CAT pointing at PIV-007; fix CAT-006.actual_count(163); have pivot page read PIV-007 not CAT-DOT.
• UI path: "DOT Tools" row on /knowledge/pivot + CAT-006 on registries.
• No-hardcode: count from PIV-007; show refreshed_at.

Pilot 2 — UI Preview Master 61-item List

• Current: static manifest.json (61 items) at /ui-preview/_master/v1/ — not PG-backed ([[project-ui-preview-master-homepage-governance-index-2026-05-30]]). Species page (SPE-PGE) + meta_catalog CAT-007 Pages/Routes exist (record 37 vs actual 52 — already drifting). ui_pages is the live source (PIV-008).
• Target pivot: PIV-008 (ui_pages) once the 61 surfaces are born into ui_pages/birth_registry under species page.
• Missing: birth the 61 UI surfaces; reconcile CAT-007 37↔52; add the 61-list as a meta_catalog list.
• UI path: render via pivot shell; retire static manifest as SoT (keep as import seed).
• No-hardcode: items become rows; manifest stops being truth.

Pilot 3 — meta_catalog / table_registry List

• Current: meta_catalog 169 (PIV-001/101/102/106), table_registry 21 (PIV-002), collection_registry 168 (PIV-009). meta_catalog stores numbers (164/169).
• Target pivot: PIV-001 (meta_catalog) / PIV-002 (table_registry) + l2-drill PIV-201..206 by composition_level.
• Missing: stop storing record_count/actual_count as truth; backfill ui_page (18/169).
• UI path: the registries page itself = list-of-lists navigator.
• No-hardcode: groups from composition_level values (until a composition_levels reference table is built — doc 06 gap); counts from pivot.

Pilot 4 — Species Taxonomy List

• Current: entity_species 42 (PIV-016/103), species_collection_map 164 (PIV-017). All species flat (depth=1); no live tree.
• Target pivot: PIV-016 (entity_species) + a species×composition_level matrix via pivot_matrix('entity_species','species_code','composition_level','count',…).
• Missing: build the kingdom/phylum/species tree (design-only today); clean dirty composition_level values ('meta','1'); build composition_levels reference table.
• UI path: Species Matrix / Taxonomy 6x6 surfaces (already on registries page).
• No-hardcode: species from entity_species; layers from a reference table (to build).

Pilot 5 — Workflow Design List

• Current: PIV-004 workflows, PIV-005 workflow_steps, PIV-006 workflow_change_requests (registry_group=quy_trình); species workflow/workflow_step/wcr. Workflow substrate per MOWD packages ([[project-mow-design-registry-reuse-first-live-survey-and-design-pack-2026-05-29]]).
• Target pivot: PIV-004/005/006 (already exist).
• Missing: workflow design list not yet IU-bound / not a first-class navigable meta_catalog surface; depends on MOWD EXTEND (Đ32 pending).
• UI path: future workflow registry surface; reuse pivot shell.
• No-hardcode: workflow species/status from entity_species + pivots.

Cross-pilot pattern

Every pilot = (a) ensure source + birth, (b) the pivot usually already exists (37 defs cover ~20 sources), (c) reconcile stored vs pivot, (d) render via the shared pivot shell. Pilots 2 & 4 need a birth/build step (UI surfaces; species tree + layer reference table); pilots 1/3/5 mostly need reconciliation.