rfx_approval_rules

source

The thresholds that force a proposal into approval.

Definition

The approval-rule catalog — one row per rule with a trigger type, a threshold + comparator, the approver role, the sequence in the chain, an escalation role, and an SLA. Reference data describing the approval workflow for proposals — no personal data.

10 of 10

Column

Description

Tests · PII

rule_id

UUID5 — primary key on the source side. Stable across re-syncs.

2 tests

name

Human-readable rule name. Free-text.

trigger_type

What the rule fires on — `discount_pct`, `deal_value`, `margin_floor`, `legal_terms`.

threshold_value

Numeric threshold compared against the trigger. Plain decimal on the wire; coerced to Decimal(14,2) in staging.

comparator

Comparison operator — `gt`, `gte`, `lt`, `lte`.

approver_role

Role that must approve when the rule fires — `rfx_approver`, `finance`, `legal`, `exec`.

sequence

Order of this rule in the approval chain. String on the wire; coerced to UInt8 in staging.

escalation_role

Role the approval escalates to if the SLA is breached. LowCardinality(String).

sla_hours

Hours allowed before escalation. String on the wire; coerced to UInt16 in staging.

active

String "true"/"false" — whether the rule is currently in force. Coerced to UInt8 (0/1) in staging.