KB-4896

07 — Official List Inventory (15 lists)

7 min read Revision 1
architecturediscoveryofficial-listsinventorypivotreuse-first

07 — Official List Inventory

For each list: source, owner law, existing artifacts, current vs planned count method, and readiness across pivot / birth / IU-KG / DOT-refresh / UI. No new lists designed here. Readiness: ✅ live · 🟡 partial · ❌ absent.

Legend for count method — PIV-xxx = already covered by a live pivot_definition.

1. DOT Registry List

  • Source: PG dot_tools (309) + dot_iu_command_catalog (54). Owner law: Đ23/Đ35. Live count: PIV-007 (309). Pivot ✅ · Birth 🟡 (dot_tool species births exist) · IU-KG 🟡 (dot_tools→taxonomy edges; 2 IU rows only) · DOT-refresh ✅ (fn_refresh_dot_count/orphan) · UI 🟡 (manifest item dot-registry, spec_ready). Reconcile: CAT-006 vs CAT-DOT dual count; 178 unpaired. Action: REUSE pivot; RECONCILE count target. (Deep-dive doc 08.)

2. UI Preview Master List

  • Source: manifest (static JSON on VPS). Owner law: Đ28. Live count: hand-baked in JSON (61/36/25/16), no pivot. Pivot ❌ · Birth ❌ · IU-KG ❌ (surfaces not IUs) · DOT-refresh ❌ · UI ✅ (it is the UI). Reconcile: vs ui_pages (37 live, PG) — no join key. Action: EXTEND to PG-backed + NEW pivot; RECONCILE with ui_pages. (Deep-dive doc 09.)

3. Workflow Design List

  • Source: PG workflows (2) + workflow_steps (70) + workflow_step_relations (80), body inline (bpmn_xml/narrative), NOT IU-bound. Owner: Đ37/Đ7 (MOWD under GOV-MOW, not 5th Mother). Count: PIV-004/005. Pivot ✅ · Birth 🟡 · IU-KG ❌ (no iu_ref cols) · DOT-refresh 🟡 · UI 🟡 (workflow-design spec_ready). Action: EXTEND with iu_ref/owner_gov_code (additive).

4. Workflow Runtime List

  • Source: ❌ runtime tables (workflow_instance/task_instance) not born (manifest DATA items, not_started/spec_ready). Owner: Đ45/Đ37. Count: n/a. Pivot ❌ · all ❌. Action: DEFER (runtime out of scope) / NEW under Đ45 when needed.

5. Task List

  • Source: PG tasks (10) + task_comments (75) + task_checkpoints. Owner: GOV-MOT (draft). Count: PIV-010/021. Pivot ✅ · Birth 🟡 · IU-KG ❌ · DOT-refresh 🟡 · UI 🟡 (task-registry/my-tasks-dashboard). Action: REUSE pivot.

6. Field Registry List

  • Source: directus_fields (1,482) live; field_registry proposed ABSENT; collection_field_standards (11, has tier). Owner: GOV-MOIT (draft). Count: none for proposed registry. Pivot ❌ (for new registry) · Birth ❌ (dress-rehearsed) · IU-KG ❌ · UI 🟡 (field-registry/field-registry-manager). Action: RECONCILE (directus_fields = field truth) before NEW; await Đ32.

7. Trigger Registry List

  • Source: PG trigger_registry (107) = physical DB triggers. Owner: Đ31/system. Count: PIV-015. Pivot ✅ · Birth 🟡 · IU-KG 🟡 (trigger_registry→taxonomy 354 edges) · DOT-refresh 🟡 · UI 🟡 (trigger-registry). COLLISION: not the same as design/business triggers (workflow_trigger_design absent). Action: REUSE for DB triggers; NEW separate table for design triggers.

8. Input Form Registry List

  • Source: input_form_registry ABSENT; forms/block_form empty (0). Owner: GOV-MOIT. Count: n/a. All ❌. UI 🟡 (input-form-registry/moit-form-builder). Action: NEW (await Đ32); form definitions currently unborn.

9. Output Table Registry List

  • Source: design_templates (1) is the de-facto output substrate; output-table-registry proposed absent. Owner: GOV-MOUT (draft) / Đ28. Count: n/a. Pivot ❌ · UI 🟡 (output-table-registry/mout-table-renderer). Action: EXTEND design_templates / NEW registry under MOUT.

10. Personnel / Role / Agent List

  • Source: PG directus_users (13) + directus_roles (9) + directus_policies (8) + agents (6). Owner: Đ37 (human-org-role unborn). Count: PIV-011 (agents). Pivot 🟡 (agents only) · Birth 🟡 · IU-KG ❌ · UI 🟡 (personnel-registry/role-registry/agent-registry). Action: REUSE Directus RBAC + agents; add pivots for users/roles.

11. Approval / Proposal List

  • Source: PG approval_requests (211) + apr_approvals (42) + workflow_change_requests (3) + table_proposals (0). Owner: Đ32/Đ37. Count: PIV-207. Pivot ✅ · Birth 🟡 · IU-KG ❌ · DOT-refresh ✅ · UI 🟡 (approval-queue/approval-queue-manager). Action: REUSE as universal approval spine for all list changes.

12. Event / Notification / DLQ List

  • Source: PG event_outbox (165k) + event_type_registry (40) + iu_outbound_route (15) + job_queue/DLQ (0). Owner: Đ45. Count: pivotable on event_type_registry (add pivot). Pivot 🟡 · Birth 🟡 · IU-KG 🟡 · DOT-refresh 🟡 · UI 🟡 (notification-queue/trigger-event-log/notification-center). Action: REUSE single substrate; flip dry_run when ready.

13. Collection / Table / Meta Catalog List

  • Source: PG meta_catalog (169, SoT) + collection_registry (168) + table_registry (21, UI defs). Owner: Đ26/Đ36/Đ29. Count: PIV-001/002/009 + refresh_meta_catalog_from_pivot. Pivot ✅ · Birth ✅ · IU-KG 🟡 · DOT-refresh ✅ · UI ✅ (/knowledge/registries). Action: REUSE — this is the reference implementation of a living list.

14. IU / KG Relation List

  • Source: PG information_unit (219) + iu_relation (60) + universal_edges (2199) + view v_kg_edges_all (2259). Owner: Đ38/Đ39/Đ44. Count: pivotable (add PIV for IU/edges). Pivot 🟡 · Birth 🟡 · IU-KG ✅ · DOT-refresh 🟡 (fn_iu_kg_edge_audit) · UI ❌. Action: REUSE as semantic/profile layer; add count pivots.

15. Law / Normative Registry List

  • Source: PG normative_registry (47, metadata SoT) + law_catalog (5, legacy) + governance_registry (9); text in KB. Owner: Đ38/Đ37. Count: add pivot (none today). Pivot ❌ · Birth 🟡 · IU-KG ✅ (law_units 187 in IU) · DOT-refresh 🟡 · UI 🟡. Reconcile: Đ23/Đ45 missing from normative_registry; law_catalog stale. Action: RECONCILE (register Đ23/45, deprecate law_catalog); add count pivot.

Pattern observed

The mature lists (DOT, collection/meta, approval, workflow, task, trigger, agents) are already PG-backed and pivot-counted. The immature lists (UI Preview Master, field/form/output, runtime, human-org-role) are either static files or unborn registries. The reuse-first path: lift immature lists onto the same meta_catalog + pivot + birth + approval pattern the mature lists already use — do not invent a parallel "living list" engine.

Back to Knowledge Hub knowledge/dev/reports/architecture/law-capability-discovery-official-lists-automation-2026-05-30/07-official-list-inventory.md