stg_postgres__finance_employees

staging view 5 PII columns

The finance team, cleaned.

Definition

Employee master for the `employee` data subject. work_email lowercased; identity / contact / financial PII tagged so masking fires downstream. DSAR erasure tokenizes identity here (per H6), not the retained legal_obligation rows that merely reference an employee.

15 of 15

Column

Description

Tests · PII

employee_id

Primary key — UInt64.

employee +2 PII3 tests

work_email

Lowercased work email. Contact PII.

2 testsPII

full_name

Employee full name. Identity PII.

PII

personal_phone

Personal phone. Contact PII. Nullable.

PII

role

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

1 test

department

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

1 test

cost_center_id

FK to `stg_postgres__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. Nullable.

PII

tax_id_last4

Last 4 of tax id. Financial PII. Nullable.

PII

hired_at

Hire date. Date.

is_active

True for currently employed staff.

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.