expense_reports

source 1 PII columns

Employee expense claims and their lifecycle.

Definition

Expense-report headers submitted by employees. `report_title` can echo behavioral PII (nullify on erasure). Statutory record kept 7 years (basis legal_obligation per OQ-2 / C1).

14 of 14

Column

Description

Tests · PII

expense_report_id

Primary key — BIGSERIAL on the source.

employee +1 PII2 tests

report_number

Report reference number. Unique.

2 tests

employee_id

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

employee +2 PII1 test

period_id

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

1 test

journal_entry_id

FK to the GL entry recording the report. 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. NUMERIC(12,2).

currency

Report currency.

approved_by_employee_id

FK to the approving employee — actor reference. Nullable.

reimbursed_ap_payment_id

FK to the AP payment that reimbursed the report. Nullable.

created_at

Row insert timestamp in the source DB.

updated_at

Row update timestamp in the source DB.