03 — Live Process/Workflow Inventory & Gap Map

Live via v_axis_process_inventory (60 rows) + v_axis_process_candidates (58 rows), 2026-06-04.

Inventory by class (live)

process_type	object_class	count	birth_state	source
TYPE_3_HUMAN_IN_LOOP	workflow_definition	2	BORN	workflows
TYPE_2_AUTOMATED_MULTI	automated_pipeline_implicit	1	UNBORN	job_queue
TYPE_1_DOT_CONTAINED	dot_contained	57	GOVERNED_NOT_BIRTH_TRACKED	dot_tools

Component counts (live)

• workflow_steps 70, workflow_step_relations 80, workflow_categories 3, workflow_change_requests 3.
• tasks 10 (+task_checkpoints 9, task_comments 75).
• job_queue 13 (7 queued stuck / 6 succeeded), job_dead_letter 0, queue_heartbeat 3.
• trigger_registry 107, event_type_registry 45, event_outbox 204,136.
• dot_tools 309 (57 triggered → Type-1 process candidates).

Implicit Type-2 processes currently invisible as process objects

candidate	evidence	status
cut_pipeline	13 job_queue cut.* rows, 7 stuck queued since 2026-05-26, executor cut_pipeline_operator	implicit, UNBORN, NO_WORKFLOW_OBJECT — strongest
topic-axis candidate/approval pipeline	axis_assignment 25 + 14 AXR-TOPIC approval_requests + v_axis_topic_decision_queue; no job rows	implicit, evidenced by DOTs/views, no process object
RP aggregation / pivot-update pipeline	pivot_definitions refresh triggers + v_registries_pivot_* + dot-pivot-update (staged)	implicit, trigger-chain only
queue refresh / job workflow	v_queue_health (worker disabled) + queue_heartbeat	implicit, dormant
approval workflow	approval_requests 225 + apr triggers (auto-approve add)	implicit, embedded in triggers
57 scheduled/event DOTs	dot_tools trigger_type cron/event/dual/on-deploy	Type-1, DOT-owned, process-alias only

Candidate classification

• already registered (BORN, governed): WF-001, WF-002 (Type 3).
• implicit/unborn (needs governance + birth): cut_pipeline (Type 2). Topic-axis/RP/approval pipelines are implicit but distributed across triggers/DOTs/views — they need a process definition to become objects.
• DOT-contained only: 57 triggered DOTs — keep DOT-owned, alias into process inventory.
• needs IU/SOP: every process object — workflow tables carry 0 IU-binding columns (Doc-04 inventory gap confirmed live).

The five-store fragmentation (live-confirmed, matches 2026-05-29 audit Doc 04)

Process designs are scattered with no join key: (1) PG workflow_* substrate, (2) DOT commands, (3) KB reports/SOP docs, (4) agent/user paste-prompts (no registry), (5) PL/pgSQL functions + triggers. The single PG substrate is not IU-bound. AX-PROCESS + v_axis_process_inventory is the first surface that joins stores (1)+(2)+queue into one countable lens.

Explicit gaps

1. Birth gap: job_queue (13 live) UNBORN + absent from meta_catalog; cut_pipeline has no process object; os_tasks/ai_tasks/event_pending empty.
2. Object gap: 4 of 5 named implicit pipelines have no workflows row.
3. IU/SOP gap: 0 IU-binding columns on all workflow tables.
4. Owner gap: governance_object_ownership empty → every process object OWNER_MISSING.
5. RP gap (closed by this pilot): job_queue/pipelines had no pivot — now surfaced via PIV-342/344/347/350/353.