finance_employees

source 5 PII columns

The finance team — who they are and who they report to.

Definition

Employee master for the finance domain. The identity table for the `employee` data subject (DSAR erasure tokenizes identity here, not the retained legal_obligation rows that merely reference an employee). Carries contact + financial PII; `manager_employee_id` builds the reporting tree.

14 of 14

Column

Description

Tests · PII

employee_id

Primary key — BIGSERIAL on the source.

employee +2 PII2 tests

work_email

Work email. Unique on the source; contact PII.

2 testsPII

full_name

Employee full name. Identity PII.

PII

personal_phone

Personal phone number. Contact PII. Nullable.

PII

role

Finance role — `fpa_analyst` / `controller` / `ap_clerk` / `ar_clerk` / `cfo` / `approver` / `staff`.

department

Department — `finance` / `sales` / `engineering` / `ops` / `marketing`.

cost_center_id

FK to `cost_centers.cost_center_id`. Nullable.

manager_employee_id

Self-FK to `finance_employees.employee_id`. Nullable.

bank_account_last4

Last 4 of reimbursement bank account. Financial PII (never store full).

PII

tax_id_last4

Last 4 of tax id. Financial PII.

PII

hired_at

Hire date.

is_active

True for currently employed staff.

created_at

Row insert timestamp in the source DB.

updated_at

Row update timestamp in the source DB.