whse_approval_rules

source

The thresholds that force an operation 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 warehousing operations (write-off value, hazmat handling, credit note, SLA waiver) — 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 — `write_off_value`, `hazmat_handling`, `credit_note`, `sla_waiver`.

threshold_value

Numeric threshold compared against the trigger. Coerced to Decimal(14,2) in staging.

comparator

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

approver_role

Role that must approve when the rule fires — `logistics_ops_manager`, `compliance_officer`, `finance`, `exec`.

sequence

Order of this rule in the approval chain. Coerced to UInt8 in staging.

escalation_role

Role the approval escalates to if the SLA is breached — `logistics_ops_manager`, `compliance_officer`, `finance`, `exec`.

sla_hours

Hours allowed before escalation. Coerced to UInt16 in staging.

active

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