Process/Workflow Axis RP Pilot — 01 Live Substrate & SSOT
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_id→to_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.