05 — Process × Trigger RP Cross-Axis Surfaces (PHASE E)

Status: COMPLETE. RP can now cross-check process↔trigger relationships. Additive, read-only, birth-free (1,174,030 before==after apply).

New views (rollback 99_rollback.sql)

1. v_ax_process_trigger_drilldown — process candidate → linked triggers. 12 of 19 candidates have triggers (WPC-OS-INFRA 29, WPC-CRON-ENV-HELPER 7, WPC-HEALTH-MON 6, WPC-BACKUP-DR 5, WPC-DOT-NRM/DB-SCHED-JOB 4, …); flags PROCESS_MISSING_TRIGGER for the 7 with 0 triggers. All owner_status=UNASSIGNED.
2. v_ax_trigger_process_drilldown — each trigger → its process (69 rows, all MANY_TRIGGER_ONE_PROCESS / ENTRYPOINT).
3. v_rp_process_trigger_cross_axis_surface — unified two-perspective feed:
   • PROCESS perspective: 19 rows, 69 total linked triggers.
   • TRIGGER_CLASS perspective: 7 rows, 525 total triggers.
4. v_rp_process_trigger_action_items — cross-axis gaps (all owner-gated bar one):

item	qty	action	gate
TRIGGER_MISSING_PROCESS	381	CLASSIFY_INFRA_OR_PROMOTE	OWNER_GATED_LOW
HIGH_RISK_ENABLED_NO_PROCESS	381	AUDIT_AND_CLASSIFY	OWNER_GATED
TRIGGER_OWNERSHIP_GAP	117	ASSIGN_AX_TRIGGER_OWNER	OWNER_GATED
STALE_TRIGGER_RELATION	27	REVIEW_FOR_RETIREMENT	OWNER_GATED
PROCESS_OWNERSHIP_GAP	19	ASSIGN_PROCESS_OWNER	OWNER_GATED
PROCESS_MISSING_TRIGGER	7	REVIEW_TRIGGER_LINKAGE	SAFE_REVIEW

(HIGH_RISK_ENABLED_NO_PROCESS overlaps TRIGGER_MISSING_PROCESS — same 381 enabled db_dml population, surfaced as a risk-audit lens; noted in the view.)

Coverage of the 7 required cross-axis dimensions

process→triggers ✓ · trigger→processes ✓ · process missing trigger ✓ (7) · trigger missing process ✓ (381) · high-risk trigger affecting process ✓ (381 audit) · trigger/process ownership gap ✓ (117 + 19) · trigger/process stale relation ✓ (27).

RP integration

AX-PROCESS drilldown now includes triggers (v_ax_process_trigger_drilldown); AX-TRIGGER drilldown includes processes (v_ax_trigger_process_drilldown); the unified surface + action items power a single cross-axis RP panel (queued as the next UI panel after the process-axis dashboard ships).

Net

All cross-axis surfaces live and apply-ready. Every actionable item is owner-gated except a safe review. No ownership/canon faked.