WFM Scheduled Agent Days dataset

The WFM Scheduled Agent Days dataset contains the following data:

Absence

Data field Definition
Absence In Contract Time Name The display name for the absence in contract time.
Absence In Paid Time Name The display name for the absence in paid time.
Absence In Work Time Name The display name for the absence in work time.
Absence Type All absence types that could be added to schedules in the WFM system. Status property shows if the absence is active or deleted in the system.
Absence Type Code The Calabrio ONE database GUID for the absence type.

Absence Type ID

The Calabrio ONE database ID for the absence type.

Absence Type Short Name

An abbreviation for the absence type that is configured in WFM.

Absence Type Status

Whether the absence type is active or deleted.

Is Absence In Contract Time

Whether or not the absence is in contract time. 1 = yes, 0 = no.

Is Absence In Paid Time

Whether or not the absence is in paid time. 1 = yes, 0 = no.

Is Absence In Work Time

Whether or not the absence is in work time. 1 = yes, 0 = no.

Is Absence Type Deleted

Whether or not the absence type is deleted. 1 = yes, 0 = no.

Day Off

Data field Definition
Day Off ID The Calabrio ONE database ID for the day off.
Day Off Name All day-off types available in the system. A day off is a scheduled non-work day, or weekly resting day, for an agent during a period.
Day Off Short Name An abbreviation for the day off that is configured in WFM.

Location

Data field Definition
Location ID 1 = home, 2 = office.
Location Name The agents scheduled work location. The agent can be scheduled to work from either home or office. If location is empty the location is not set.

Organization

Data field Definition
Business Unit Code The Calabrio ONE 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 Calabrio ONE 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 Calabrio ONE database GUID for a team.

Team Name

The display name for the collection of agents.

Person

Data field Definition
Agent Skill Set Code The Calabrio ONE 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 Calabrio ONE.

Employment Number

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

Employment Start Date The date when the person's employment started in Calabrio ONE.
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 Calabrio ONE 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 Calabrio ONE 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.

Scheduled Agent Days

Data field Definition
Absences Full Day Absence for a number of hours covering the full shift.
All Agent Days A sum of days where agents’ location was set to home and days where their location was set to office.
Days Off Total number of scheduled non-work days, or weekly resting days, for an agent.
Home Agent Days

The number of days when agents’ location is set to home.

Office Agent Days The number of days when agents' location is set to office.
Shift Start Date  

Shift Category

Data field Definition
Is Shift Category Deleted Whether or not a shift category is deleted. 1 = yes, 0 = no.
Shift Category ID A shift category is a group page for shifts. The shift categories are used for preferences, rotations, fairness, and shift category limitations.
Shift Category Name A shift category is a group page for shifts. The shift categories are used for preferences, rotations, fairness, and shift category limitations.
Shift Category Short Name The abbreviation for the shift category that your organization configures in WFM.
Shift Category Status Whether the shift category is Active or Deleted.

System

Data field Definition
system_person_code

The unique ID of a WFM person.

system_realm_id

The Calabrio ONE database ID for the Calabrio realm that the tenant is in.

system_team_code The Calabrio ONE database GUID for a team.
system_tenant_id

The Calabrio ONE database ID for the tenant.