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

stg_postgres__expense_report_lines

staging view 2 PII columns

Expense-report lines, cleaned.

Lineage Builds PII registry
Definition

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

15 of 15
Column
Description
Tests · PII
expense_report_line_id
Primary key — UInt64.
2 tests
expense_report_id
FK to `stg_postgres__expense_reports.expense_report_id`. NOT NULL.
employee PII2 tests
line_number
1-based line ordinal within the report. Int16.
gl_account_id
FK to `stg_postgres__gl_accounts.gl_account_id`. NOT NULL.
2 tests
cost_center_id
FK to `stg_postgres__cost_centers.cost_center_id`. Nullable.
expense_date
Date the expense was incurred. Date.
expense_day
Calendar date — toDate(expense_date).
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. Decimal(12,2).
currency
Line currency, uppercased.
is_reimbursable
True if reimbursable to the employee.
source_created_at
Row insert timestamp from the source DB. DateTime64(6).
airbyte_extracted_at
When the loader extracted this row from postgres-source.