WFM Hourly Availability dataset

The WFM Hourly Availability dataset contains the following data:

Hourly Availability

Data field Definition
Available Days The number of days when agents recorded any available time.
Available Time (h) The number of hours when agents were in a ready state.
Available Time (m) The number of minutes when agents were in a ready state.
Scheduled Days The number of days where an agent has scheduled activity.
Scheduled Time (h) All the scheduled time in hours, regardless if it is contract time, work time, or absence time.
Scheduled Time (m) All the scheduled time in minutes, regardless if it is contract time, work time, or absence time.

Shift Start Date

Time subject representing dates bound to the agent local time zone for shifts, absence days, days off, and schedule preferences.

Utilization (%)

The percentage of available time within scheduled time.

Organization

Data field Definition
Business Unit Code The Workforce Optimization database GUID for the business unit.
Business Unit Name The organizational unit at the top of the business hierarchy. It can contain one or more sites.
Site Code The Workforce Optimization database GUID for the site.
Site Name A site is a unit in the business hierarchy, belonging to a business unit and containing one or more teams.
Team Code The Workforce Optimization database GUID for a team.
Team Name

The display name for the collection of agents.

Person

Data field Definition
Agent Skill Set Code The Workforce Optimization database GUID for the agent skill set.
Agent Skill Set Name A unique combination of assigned skills for an agent.
Employment End Date The date when the person's employment ended in Workforce Optimization.
Employment Number

This number associated with the person appears if your Workforce Optimization system is connected to your Human Resources Management System (HRMS).

Employment Start Date The date when the person's employment started in Workforce Optimization.
First Name The user's first name.

Is Agent

Whether or not the person is an agent. 1 = yes, 0 = no.

Is Person Deleted

Whether or not a person is deleted. 1 = yes, 0 = no.

Is User

Whether or not a person is a user in WFM. 1 = yes, 0 = no.

Last Name

The user's last name.

Person Code

The unique ID of a WFM person.

Person Contract Code

The Workforce Optimization database GUID of the person contract.

Person Contract Name

The display name of the person contract.

Person Email

The user's email address.

Person Name

The full name of the agent in the WFM system. A person is considered to be an agent if he/she belongs to a team. The person code/ID connected is a unique identifier for the person in the WFM system regardless of person period.

Person Note

This data comes from an open-text field in the People module.

Person Parttime %

The percentage of a full-time schedule that a part-time agent works. For example, an agent who works half time has a parttime % of .5.

Person Period Note

A comment that is added to the person period. This data comes from an open-text field in the People module.

Person Timezone

The timezone associated with the user's WFM settings.

Scenario

Data field Definition
Is Default Scenario Whether or not the scenario is the default. 1 = yes, 0 = no.
Is Scenario Deleted Whether or not a scenario is deleted. 1 = yes, 0 = no.
Scenario Code The Workforce Optimization database GUID for the scenario.
Scenario Name Scenarios are used to test the consequences different factors have on staffing. A schedule can be created in any scenario, but for it to be published and visible for agents, it has to be in the default scenario. Requests by agents are only visible in the default scenario.
Scenario Name (Business Unit) The name of the scenario with the name of the business unit in parentheses after it.
Scenario Status Whether the scenario is Active or Deleted.

System

Data field Definition

system_person_code

The unique ID of a WFM person.

system_realm_id

The Workforce Optimization database ID for the Provider realm that the tenant is in.

system_team_code

The Workforce Optimization database GUID for a team.

system_tenant_id

The Workforce Optimization database ID for the tenant.