WFMScheduleAdherenceReport
Query the WFM Schedule Adherence Report via the Explore API. Provides data on whether agents are in adherence with their schedules. Up to a month of data per request.
Select
The WFMScheduleAdherenceReport is a report view. The connector processes the following pseudo-columns server-side; any other WHERE clause conditions are evaluated client-side.
- TimespanFrom supports the following operator: >=
- TimespanTo supports the following operator: <
- Timezone supports the following operator: =
If TimespanFrom and TimespanTo are omitted, the connector defaults the time range to the last 31 days.
For example, the following query is processed server-side:
SELECT * FROM WFMScheduleAdherenceReport WHERE TimespanFrom >= '2025-01-01' AND TimespanTo < '2025-02-01'
Columns
| Name | Type | References | Description |
| AgentName | String | The name of the agent. | |
| AdherenceEventStartTime | Datetime | The start time of the adherence event. | |
| AgentEmail | String | The email of the agent. | |
| AgentRingGroups | String | The ring groups the agent belongs to. | |
| TeamName | String | The team name of the agent. | |
| AccountTimeZone | String | The account time zone. | |
| ReferenceDate | Datetime | The reference date for the adherence event. | |
| AdherenceEventEndTime | Datetime | The end time of the adherence event. | |
| AdherenceEventDuration | Int | The duration of the adherence event, in seconds. | |
| AdherenceStatus | String | The adherence status. Example values: Aligned, Deviated. | |
| ShiftStatus | String | The shift status. Example values: On Shift, Off Shift. | |
| ScheduledEventName | String | The name of the scheduled event. Example values: Available for all channels A, Unscheduled. | |
| ScheduledEventPayStatus | String | The pay status of the scheduled event. Example values: Paid, Unpaid. | |
| ActualStatus | String | The actual status of the agent. Example values: Offline, Available. |
Pseudocolumns
Pseudocolumn fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.
| Name | Type | Description | |
| TimespanFrom | Datetime | The start date for the report timespan. | |
| TimespanTo | Datetime | The end date for the report timespan. | |
| Timezone | String | The IANA timezone for the report timespan. |