maiven gateway · online··
manifest · 2d ago
Sign in Back to catalog
Definition
Cleaned mirror of `raw_gcs.whse_approval_rules`. Coerces the CSV's `Nullable(String)` columns into typed equivalents. Reference data describing the approval workflow that gates warehousing operations on write-off value, hazmat handling, credit notes, and SLA waivers — no personal data.
13 of 13
Column
Description
Tests · PII
rule_id
UUID5 from the source CSV. Primary key.
2 tests
name
Human-readable rule name. Free-text.
1 test
trigger_type
What the rule fires on.
2 tests
threshold_value
Numeric threshold compared against the trigger. Coerced from String → Decimal(14,2).
1 test
comparator
Comparison operator.
2 tests
approver_role
Role that must approve when the rule fires.
2 tests
sequence
Order of this rule in the approval chain. Coerced from String → UInt8.
1 test
escalation_role
Role the approval escalates to if the SLA is breached.
1 test
sla_hours
Hours allowed before escalation. Coerced from String → UInt16.
1 test
active
1 if the rule is currently in force, 0 otherwise. Coerced from the CSV's "true"/"false" strings.
2 tests
source_file_url
Airbyte-supplied `_ab_source_file_url` — the gs:// URI the row came from.
source_file_modified_at
Airbyte-supplied `_ab_source_file_last_modified` — object mtime of the source file.
airbyte_extracted_at
When Airbyte extracted this row from GCS.