approvals

source

Who approved what, and when.

Definition

Approval workflow steps over finance objects (`object_type` + `object_id` is a polymorphic soft FK; no hard relationship test). `approver_employee_id` is an actor reference (DSAR-access location).

10 of 10

Column

Description

Tests · PII

approval_id

Primary key — BIGSERIAL on the source.

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.

step_number

1-based approval step ordinal.

approver_employee_id

FK to `finance_employees.employee_id` — actor reference. NOT NULL.

1 test

decision

Decision — `pending` / `approved` / `rejected` / `delegated`.

1 test

decided_at

When the decision was made. Nullable while pending.

comment

Free-text approver comment. Nullable.

created_at

Row insert timestamp in the source DB.

updated_at

Row update timestamp in the source DB.