audit_log

source 2 PII columns

The tamper-evident change history for finance objects.

Definition

Append-only audit trail. `old_value` / `new_value` may echo PII; they are retained under legal_obligation and erased via `retain_aggregate` (the change history is itself the legal record, so values are aggregated, never nullified). Cursor is on audit_log_id (no updated_at).

10 of 10

Column

Description

Tests · PII

audit_log_id

Primary key — BIGSERIAL on the source.

2 tests

object_type

Audited object type (polymorphic).

object_id

Soft FK to the PK of the object_type table. NOT NULL.

action

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

1 test

actor_employee_id

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

created_at

Row insert timestamp in the source DB.