KB-3215

Process/Workflow Axis RP Pilot — 01 Live Substrate & SSOT

5 min read Revision 1
process-axislive-substrate2026-06-04

01 — Live Substrate & SSOT Confirmation

All figures live-verified 2026-06-04 via query_pg (RO) + psql. SSOT checkpoints read first (topic-axis self-operated, rp-ui-axis-decision-queue, topic-axis-pilot-apply, rp-final-acceptance, layer-definition canon).

Workflow / task substrate (the MOW/MOT cluster)

table rows role born?
workflows 2 PROCESS DEFINITION (versioned BPMN; process_code WF-NNN, version, level, parent_workflow_id, category_id, task_id, status) BORN (2/2)
workflow_steps 70 STEP/node (step_type ∈ action/condition/agent_call/wait_for_event/human_checkpoint; code ND-NNNN; actor_type; sort_order; block_id) BORN (70/70)
workflow_step_relations 80 EDGE (from_step_idto_step_id, relation_type sequence/conditional, condition_expression, label) BORN (80)
workflow_categories 3 TAXONOMY tree (C1→C2→C3) over definitions BORN (3)
workflow_change_requests 3 KAIZEN proposal (change_type, dsl_diff, approved_by, applied_at; 2 applied/1 draft) BORN (3)
tasks 10 WORK ITEM (code TSK-NNN, task_type, assigned_to, lead_ai/critic_ai, deadline, checklist) BORN (13 births > 10 live = 3 stale)
ai_tasks 0 AI work RUN/round (empty)
os_tasks 0 Agency-OS client task (empty)
task_checkpoints 9 VERIFICATION gate (pass 6/pending 2/fail 1; binds workflow_step_id) born
task_comments 75 review/approval log (multi-agent) born

WF-001 "Quy trình duyệt công việc" (active, v4, 10 steps incl 1 human_checkpoint + 1 wait_for_event, linked TSK-004). WF-002 "Quy trình xử lý đơn hàng xuất khẩu (60 bước)" (draft, v1).

Queue / job substrate (Điều-45 core)

table rows note
job_queue 13 leased retry queue; all cut.* kinds; 7 queued (stuck), 6 succeeded; UNBORN (0 births), ABSENT from meta_catalog
job_dead_letter 0 empty (no parked failures)
queue_heartbeat 3 executors cut_pipeline_operator(ok), dieu45_phase3_pilot(ok), iu_outbound_default(warn)
v_queue_health 1 substrate_enabled=false, worker_enabled=false → 7 jobs idle since 2026-05-26

Event / trigger substrate

table rows note
event_type_registry 45 catalog (active 30/inactive 15; lane delayed 24/immediate 21)
event_outbox 204,136 published log (~99.8% system.issue_opened from triggers)
event_pending 0 CDC capture inbox — drained (healthy)
event_read 203,775 read receipts
event_subscription 3 routing rules
trigger_registry 107 declared expected-trigger baseline (all enabled/active; BEFORE 59/AFTER 48)
trigger_guard_alerts / _exceptions 129 / 27 drift detector (alerts informational) + sanctioned allow-list (incl. disabled trg_count_*)
context_trigger_sources 6 fire-source vocab: cron/on_demand/on_deploy/on_law_enact/on_dot_register/system_init

DOT / run substrate

dot_tools 309 (active 291/published 16; trigger_type null 205/on-demand 44/cron 42/dual 6/event 5/on-deploy 4/manual 3); dot_iu_command_catalog 54; dot_iu_command_run 55 (0 failures, last 2026-05-28); dot_iu_runtime_lease 0; candidate_scan_run 0; universal_rule_runs 13 / results 130 (last 2026-03-20, 0 violations). ABSENT: external_tool_registry, agent_run.

Birth / governance / RP baseline

  • birth_registry ≈ 1.158M (live-accruing from background activity; my work added 0).
  • governance_object_ownership 0 rows (empty system-wide); governance_responsibility_scope 6 generic scopes (GOV-COUNCIL approval/policy, GOV-SIV audit/health, GOV-DOT execution, GOV-MOUT render).
  • approval_requests 225 (applied 176/expired 19/pending 14/rejected 14/approved 2). action='add' auto-approves; inserts birth.
  • pivot_definitions 39. Process pivots already exist: PIV-004 workflows, PIV-005 workflow_steps, PIV-006 workflow_change_requests, PIV-010 tasks, PIV-015 trigger_registry, PIV-021 task_comments, PIV-007/104 dot_tools. No pivot for job_queue/os_tasks/ai_tasks/event_pending. Highest = PIV-313.
  • axis_registry 1 → now 2 (AX-TOPIC + AX-PROCESS). axis_assignment 25 (AX-TOPIC only).

Execution-mode classification

EXECUTION_MODE — write path (ssh→psql as table-owner directus) confirmed; additive DDL safe (DDL event-guards act only on trigger objects); axis_registry birth-free.

Back to Knowledge Hub knowledge/dev/reports/architecture/process-workflow-axis-registries-pivot-birth-governance-ui-pilot-2026-06-04/01-live-substrate-and-ssot-confirmation.md