agents

source 2 PII columns

The humans handling support tickets.

Definition

Support agent roster — identity, team tier, tenure. Joins to `support_tickets` on `agent_id`. Agents are a separate data subject from customers; their PII is governed under `processing_purpose: support` rather than the consumer consent ledger.

8 of 8

Column

Description

Tests · PII

agent_id

Primary key — BIGSERIAL on the source.

agent PII2 tests

Agent work email. Unique on the source; treated as PII downstream.

2 testsPII

full_name

Agent display name shown in tickets.

PII

team

Tier the agent works on — one of `tier1`, `tier2`, `specialist`, `manager`.

1 test

hired_at

Date the agent was hired. Used to bound staffing analytics.

is_active

True for currently employed agents; false for departures (kept for historical ticket attribution).

created_at

Row insert timestamp in the source DB.

updated_at

Row update timestamp in the source DB.