stg_postgres__expense_reports

staging view 1 PII columns

Expense reports, cleaned.

Definition

Expense-report headers submitted by employees. `report_title` can echo behavioral PII (nullify on erasure). Statutory record kept 7 years.

15 of 15

Column

Description

Tests · PII

expense_report_id

Primary key — UInt64.

report_number

Report reference number. Unique.

2 tests

employee_id

FK to `stg_postgres__finance_employees.employee_id` (submitter). NOT NULL.

period_id

FK to fiscal_periods.period_id (not staged in this slice). NOT NULL.

1 test

journal_entry_id

FK to `stg_postgres__gl_journal_entries.journal_entry_id`. Nullable.

report_title

Free-text title. Behavioral PII. Nullable.

PII

submitted_at

When the report was submitted. Nullable while draft.

status

Lifecycle — draft / submitted / approved / rejected / reimbursed.

1 test

total_amount

Report total. Decimal(12,2).

currency

Report currency, uppercased.

approved_by_employee_id

FK to the approving employee — actor reference. Nullable.

reimbursed_ap_payment_id

FK to `stg_postgres__ap_payments.ap_payment_id`. 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.