# Zendesk Workforce Management schema ERD

Table and field reference for the Fivetran Zendesk Workforce Management connector.

## Table & Field Reference

### agent_attendance

| Column | Type | Keys |
| --- | --- | --- |
| end_time | Unknown | PK |
| interval | Unknown | PK |
| start_time | Unknown | PK |
| agent_id | Unknown | PK, FK |
| attendance_rate | String |  |
| attendance_time | String |  |
| late_occurrence | String |  |
| late_time | String |  |
| left_early_occurrence | String |  |
| left_early_time | String |  |
| occupancy_rate | String |  |
| overtime_occurrence | String |  |
| overtime_time | String |  |
| scheduled_time | String |  |
| team_id | Unknown |  |
| team_is_deleted | Unknown |  |
| team_name | Unknown |  |
| total_time | String |  |
| unpaid_general_task_time | String |  |

### activity_type_id

| Column | Type | Keys |
| --- | --- | --- |
| activity_id | String | PK, FK |
| activity_type_id | String | PK, FK |

### activity

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| agent_id | Unknown |  |
| color | Unknown |  |
| duration | Unknown |  |
| end_time | Unknown |  |
| event_type | Unknown |  |
| is_paid | Unknown |  |
| lock_interval | Unknown |  |
| name | Unknown |  |
| start_time | Unknown |  |
| ticket_id | Unknown |  |
| type | Unknown |  |

### agent

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| deactivated | Unknown |  |
| email | Unknown |  |
| is_deleted | Unknown |  |
| name | Unknown |  |

### activity_type

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| color | Unknown |  |
| is_deleted | Unknown |  |
| name | Unknown |  |

### agent_time_off

| Column | Type | Keys |
| --- | --- | --- |
| end_time | Unknown | PK |
| interval | Unknown | PK |
| start_time | Unknown | PK |
| time_off_reason_id | Unknown | PK |
| agent_id | Unknown | PK, FK |
| planned_time_off_occurrence | String |  |
| planned_time_off_time | String |  |
| time_off_reason_is_deleted | Unknown |  |
| time_off_reason_name | Unknown |  |
| time_off_reason_type | Unknown |  |
| total_time_off_occurrence | String |  |
| total_time_off_time | String |  |
| unplanned_time_off_occurrence | String |  |
| unplanned_time_off_time | String |  |

### agent_activity

| Column | Type | Keys |
| --- | --- | --- |
| end_time | Unknown | PK |
| interval | Unknown | PK |
| start_time | Unknown | PK |
| activity_type_id | String | PK, FK |
| agent_id | Unknown | PK, FK |
| adherence_rate | String |  |
| assigned_point | String |  |
| attend_point | String |  |
| escalate_point | String |  |
| paid_general_task_time | String |  |
| paid_time | String |  |
| reopen_point | String |  |
| scheduled_time | String |  |
| solved_point | String |  |
| total_time | String |  |
| unpaid_general_task_time | String |  |

## Relationships

- agent_attendance(agent_id) → agent(id)
- activity_type_id(activity_type_id) → activity_type(id)
- activity_type_id(activity_id) → activity(id)
- agent_time_off(agent_id) → agent(id)
- agent_activity(agent_id) → agent(id)
- agent_activity(activity_type_id) → activity_type(id)