maiven gateway · online··
manifest · 1d ago
Sign in
Back to catalog
MAIVENsourceraw_postgres

expense_report_lines

source 2 PII columns

Line-level detail behind every expense report.

Lineage Sources & syncs PII registry
Definition

GL-coded expense lines per report. `merchant_name` + `description` are behavioral PII (nullify on erasure). Statutory record kept 7 years.

13 of 13
Column
Description
Tests · PII
expense_report_line_id
Primary key — BIGSERIAL on the source.
2 tests
expense_report_id
FK to `expense_reports.expense_report_id`. NOT NULL.
employee PII1 test
line_number
1-based line ordinal within the report.
gl_account_id
FK to `gl_accounts.gl_account_id`. NOT NULL.
1 test
cost_center_id
FK to `cost_centers.cost_center_id`. Nullable.
expense_date
Date the expense was incurred.
category
Category — `travel` / `meals` / `lodging` / `software` / `office` / `other`.
1 test
merchant_name
Merchant. Behavioral PII. Nullable.
PII
description
Free-text line description. Behavioral PII. Nullable.
PII
amount
Line amount. NUMERIC(12,2).
currency
Line currency.
is_reimbursable
True if the line is reimbursable to the employee.
created_at
Row insert timestamp in the source DB.