stg_postgres__agents

staging view 2 PII columns

Agents, deduped and typed.

Definition

Support agents staged from the operational DB — dedupes on `agent_id` keeping the most-recent Airbyte extract, lower-cases email, and exposes `hired_at` as a required date for staffing analytics. The agent dimension that powers ticket attribution.

9 of 9

Column

Description

Tests · PII

agent_id

Primary key — UInt64.

agent PII3 tests

Lower-cased, trimmed agent work email. Tagged PII so column-grants exclude it for AI personas.

2 testsPII

full_name

Agent display name.

PII

team

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

1 test

hired_at

Date the agent was hired. NOT NULL — drives staffing analytics.

1 test

is_active

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

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 Airbyte extracted this row from postgres-source.