chat_channels

source 1 PII columns

The finance chat channels.

Definition

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

11 of 11

Column

Description

Tests · PII

chat_channel_id

Primary key — BIGSERIAL on the source.

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

created_at

Row insert timestamp in the source DB.

updated_at

Row update timestamp in the source DB.