stg_postgres__chat_channels

staging view 1 PII columns

Chat channels, cleaned.

Definition

Chat-channel headers (Slack/Teams). `topic` is free-text PII (nullify on erasure). 365-day comms retention.

12 of 12

Column

Description

Tests · PII

chat_channel_id

Primary key — UInt64.

external_ref

Workspace channel id (e.g. Slack C0XXXXX). Unique.

2 tests

platform

Platform — slack / teams.

1 test

channel_name

Channel name (e.g. month-end-close).

topic

Channel topic. Free-text PII. Nullable.

PII

is_private

True for private channels.

created_by_employee_id

FK to `stg_postgres__finance_employees.employee_id`. Nullable.

related_period_id

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

created_at_source

When the channel was created in the source workspace. DateTime64(6).

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.