stg_postgres__audit_log

staging view 2 PII columns

Finance audit trail, cleaned.

Definition

Append-only change history. `old_value` / `new_value` may echo PII; retained under legal_obligation and erased via `retain_aggregate` (the history is itself the legal record). `object_id` is a soft FK keyed by object_type; `actor_employee_id` is an actor reference. Cursor on audit_log_id (no updated_at).

11 of 11

Column

Description

Tests · PII

audit_log_id

Primary key — UInt64.

2 tests

object_type

Audited object type (polymorphic soft FK).

object_id

Soft FK to the PK of the object_type table. NOT NULL. No hard relationship test (polymorphic).

1 test

action

Action — insert / update / delete / post / approve / void.

1 test

actor_employee_id

FK to `stg_postgres__finance_employees.employee_id` — actor reference. Nullable.

employee PII

field_name

Name of the changed field. Nullable.

old_value

Prior value. May echo PII. Retained under legal_obligation (retain_aggregate). Nullable.

PII

new_value

New value. May echo PII. Retained under legal_obligation (retain_aggregate). Nullable.

PII

occurred_at

When the change occurred. DateTime64(6).

source_created_at

Row insert timestamp from the source DB. DateTime64(6).

airbyte_extracted_at

When the loader extracted this row from postgres-source.