maiven gateway · online··
manifest · 2d ago
Sign in Back to catalog
Definition
Approval workflow steps over finance objects. `object_type` + `object_id` is a polymorphic soft FK — no hard relationship test is possible; coverage is asserted via accepted_values on object_type + decision. `approver_employee_id` is an actor reference.
11 of 11
Column
Description
Tests · PII
approval_id
Primary key — UInt64.
2 tests
object_type
Approved object type — vendor_bill / expense_report / gl_journal_entry / ap_payment / budget.
1 test
object_id
Soft FK to the PK of the object_type table. NOT NULL. No hard relationship test (polymorphic).
1 test
step_number
1-based approval step ordinal. Int16.
approver_employee_id
FK to `stg_postgres__finance_employees.employee_id` — actor reference. NOT NULL.
2 tests
decision
Decision — pending / approved / rejected / delegated.
1 test
decided_at
When the decision was made. Nullable while pending.
comment
Free-text approver comment. Nullable.
source_created_at
Row insert timestamp from the source DB. DateTime64(6).
source_updated_at
Row update timestamp from the source DB. DateTime64(6).
airbyte_extracted_at
When the loader extracted this row from postgres-source.