maiven gateway · online··
manifest · 1d ago
Sign in Back to catalog
Definition
One row per routing/approval rule (grain rule_id), grouped by rule_type: escalation_trigger (e.g. high_value at the £250k LOA threshold, new_scope_of_work, unusual_or_high_risk_technical, capex_new_equipment, manual_override), review_path (standard / escalated), issuance_route (uk_front_desk / us_bdm_direct / live_presentation_then_reissue), and requote_reason. sequence_order gives the escalation-ladder / step order.
Watch out for
- mediumTreating the £250k LOA threshold as final
threshold_value on the high_value trigger is the MVP placeholder (£250k); Session 3 recorded a £150k–£500k debate. It is not a locked business rule.
- lowReading rule_type outside the enum
rule_type is constrained to escalation_trigger / review_path / issuance_route / crm_stage / requote_reason. Filter on those values.
Questions this answers
- “What triggers an escalated review, and at what value threshold?”
- “How is a UK-entity proposal routed after approval?”
8 of 8
Column
Type
Description
Tests · PII
rule_id
String
Primary key — grain of this mart.
2 tests
rule_type
Nullable(String)
Rule category (escalation_trigger / review_path / issuance_route / crm_stage / requote_reason).
name
Nullable(String)
Rule name/token (e.g. high_value, standard, uk_front_desk, scope_change).
description
Nullable(String)
What the rule does.
threshold_value
Nullable(Decimal(14, 2))
LOA escalation threshold value (£250k placeholder on high_value), if any.
threshold_currency
Nullable(String)
Threshold currency, if any.
applies_to_entity
String
Entity the rule is scoped to (e.g. smithers_mdt_ltd_uk), or empty for all.
sequence_order
Nullable(UInt8)
Escalation-ladder / step order.