Zendesk Workforce Management
Explore the interactive ERD
Table & Field Reference
agent_attendance
| Column | Type | Keys |
|---|---|---|
end_time | Unknown | PK |
interval | Unknown | PK |
start_time | Unknown | PK |
agent_id | Unknown | PKFK |
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 | PKFK |
activity_type_id | String | PKFK |
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 | PKFK |
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 | PKFK |
agent_id | Unknown | PKFK |
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 |