stg_postgres__finance_notes

staging view 2 PII columns

Finance notes, cleaned.

Definition

Notes (meeting / close-checklist / reconciliation / board-prep / variance-commentary / general). `title` + `body_text` are free-text PII (nullify on erasure); the full body also lands in the GCS corpus.

18 of 18

Column

Description

Tests · PII

finance_note_id

Primary key — UInt64.

employee PII2 tests

external_ref

Note GUID (== corpus blob key). Unique.

2 tests

author_employee_id

FK to `stg_postgres__finance_employees.employee_id` (author). NOT NULL.

2 tests

note_type

Type — meeting / close_checklist / reconciliation / board_prep / variance_commentary / general.

1 test

title

Note title. Free-text PII (nullify on erasure).

PII

body_text

Note body. Free-text PII (nullify on erasure).

PII

related_period_id

FK to fiscal_periods.period_id (not staged in this slice). Nullable.

related_cost_center_id

FK to `stg_postgres__cost_centers.cost_center_id`. Nullable.

related_entity_type

Hint — customer_invoice / vendor_bill / gl_account / budget / forecast. Nullable.

related_entity_id

Soft FK to the related_entity_type PK. Nullable.

noted_at

When the note was taken. DateTime64(6).

noted_day

Calendar date — toDate(noted_at).

source_uri

gs:// blob for the body. Nullable.

document_id

Corpus document_id, backfilled. Nullable.

document +5 PII

sha256

SHA-256 of the corpus blob, backfilled. Nullable.

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.