Data Warehouse (Legacy)
Dimension Tables
Reference tables: agents, teams, tags, HSM templates.
Was this page helpful?
Documentation Index
Fetch the complete documentation index at: /llms.txt
Use this file to discover all available pages before exploring further.
Reference tables: agents, teams, tags, HSM templates.
| Column | Type | Description |
|---|---|---|
id | Int32 | Agent identifier |
company_id | Int32 | Company identifier |
first_name | String | First name |
last_name | String | Last name |
email | String | Email address |
active | Bool | Whether the agent is active |
agent_type | String | Agent type: admin, agent, etc. |
| Column | Type | Description |
|---|---|---|
id | Int32 | Tag identifier |
company_id | Int32 | Company identifier |
name | String | Tag name |
team_id | Int32 | Team it belongs to. 0 if no team |
| Column | Type | Description |
|---|---|---|
id | Int32 | Team identifier |
company_id | Int32 | Company identifier |
name | String | Team name |
| Column | Type | Description |
|---|---|---|
id | Int32 | Template identifier |
company_id | Int32 | Company identifier |
name | String | Template name |
status | String | Status: APPROVED, REJECTED, PROCESSING |
category | String | Template category |
template_type | String | Template type |
content | String | Template content |
provider_id | String | Template ID at Meta |
| Column | Type | Description |
|---|---|---|
agent_id | Int32 | Agent identifier |
company_id | Int32 | Company identifier |
tag_id | Int32 | Tag identifier |
tag_name | String | Tag name |
team_id | Int32 | Team identifier |
team_name | String | Team name |
SELECT
a.first_name,
a.last_name,
at.tag_name,
at.team_name
FROM client_analytics.dim_agents a
INNER JOIN client_analytics.dim_agent_tags at ON at.agent_id = a.id
WHERE a.active = true
ORDER BY at.team_name, a.first_name
Was this page helpful?