stg_postgres__email_threads

staging view 1 PII columns

Email threads, cleaned.

Definition

Email-thread headers owned by a finance employee. `subject` is free-text PII (nullify on erasure). 365-day comms retention. Authoritative entity links live in communication_links.

14 of 14

Column

Description

Tests · PII

email_thread_id

Primary key — UInt64.

3 tests

external_ref

Stable external thread ref (uuid5-derived). Unique.

2 tests

mailbox_owner_employee_id

FK to `stg_postgres__finance_employees.employee_id` (mailbox owner). NOT NULL.

employee PII2 tests

subject

Thread subject. Free-text PII. Nullable.

PII

thread_started_at

When the thread started. DateTime64(6).

last_message_at

When the last message landed. DateTime64(6).

message_count

Number of messages in the thread. Int32.

is_internal

True when all participants are internal employees.

primary_entity_type

Denormalised hint — customer_invoice / vendor_bill / customer / vendor / period. Nullable.

primary_entity_id

Soft FK to the primary_entity_type PK. Nullable.

source_uri

gs:// folder for the thread's corpus blobs. 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.