WFM Scheduled Agent Time dataset

The WFM Scheduled Agent Time 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 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.

Activity

Data field Definition
Activity In Contract Time Name The display name for the activity in contract time.
Activity In Paid Time Name The display name for the activity in paid time.
Activity In Ready Time Name The display name for the activity in ready time.
Activity In Work Time Name The display name for the activity in work time.
Activity Type All activity types that could be added to schedules in the system. Status property shows if the activity is active or deleted in the system.
Activity Type Code The Calabrio ONE database GUID for the activity type.
Activity Type Status Can be active or deleted.
Is Activity In Contract Time Whether or not an activity is in contract time. 1 = yes, 0 = no.

Is Activity In Paid Time

Whether or not an activity is in paid time. 1 = yes, 0 = no.
Is Activity In Ready Time Whether or not an activity is in ready time. 1 = yes, 0 = no.
Is Activity In Work Time Whether or not an activity is in work time. 1 = yes, 0 = no.
Is Activity Type Deleted Whether or not an activity type is deleted. 1 = yes, 0 = no.

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.

Overtime

Data field Definition
Is Overtime Type Deleted Whether or not an overtime type is deleted. 1 = yes, 0 = no.
Overtime ID The Calabrio ONE database ID for the type of overtime.
Overtime Name All overtime types available in the system.
Overtime Type Status Can be active or deleted.

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 Time

Data field Definition
Absenteeism (%) How much of the scheduled contract time the agents have been absent calculated as Scheduled contract absence time / Scheduled contract time.
Activity End Date The date when the activity ended in an agent's schedule.
Activity Start Date The date when the activity started in an agent's schedule.
Planned Overtime (m) The originally planned overtime in minutes for an agent. If an agent was scheduled to work overtime but is absent, he/she will not be compensated for the overtime.
Schedule Date Interval The base level interval marker that underlies all schedules. Format is MMDDYYHHMM.
Scheduled Contract Absence Time (h) All contract time in hours for absence types. One may specify per absence type whether it should be considered contract time or not.

Scheduled Contract Absence Time (m)

All contract time in minutes for absence types. One may specify per absence type whether it should be considered contract time or not.

Scheduled Contract Absence Time (s)

All contract time in seconds for absence types. One may specify per absence type whether it should be considered contract time or not.

Scheduled Contract Time (h)

The time in hours for which the agent has been contracted to work. The amount is defined per agent using contract, contract schedule, part-time percentage, and schedule period. One may specify per activity and absence whether it should be considered contract time or not.

Scheduled Contract Time (m)

The time in minutes for which the agent has been contracted to work. The amount is defined per agent using contract, contract schedule, part-time percentage, and schedule period. One may specify per activity and absence whether it should be considered contract time or not.

Scheduled Contract Time (s)

The time in hh:mm:ss for which the agent has been contracted to work. The amount is defined per agent using contract, contract schedule, part-time percentage and schedule period. One may specify per activity and absence whether it should be considered contract time or not.

Scheduled Overtime (h)

All time in hours worked beyond the normal contract time.

Scheduled Overtime (m)

All time in minutes worked beyond the normal contract time.

Scheduled Overtime (s)

All time in seconds worked beyond the normal contract time.

Scheduled Paid Time (h)

All scheduled time in hours that is paid for, could be both absence and activity. Whether an activity or absence should be regarded as paid time is defined per activity and absence.

Scheduled Paid Time (m)

All scheduled time in minutes that is paid for, could be both absence and activity. Whether an activity or absence should be regarded as paid time is defined per activity and absence.

Scheduled Paid Time (s)

All scheduled time in seconds that is paid for, could be both absence and activity. Whether an activity or absence should be regarded as paid time is defined per activity and absence.

Scheduled Ready Time (h)

Time in hours when agents are scheduled to be logged in and ready to handle customer contacts.

Scheduled Ready Time (m)

Time in minutes when agents are scheduled to be logged in and ready to handle customer contacts.

Scheduled Ready Time (s)

Time in seconds when agents are scheduled to be logged in and ready to handle customer contacts.

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.

Scheduled Time (s)

All the scheduled time in seconds, regardless if it is contract time, work time, or absence time.

Scheduled Work Time (h)

The reported or calculated time used performing an activity (work-related tasks) or in absence. Whether an activity or absence should be regarded as work time is defined per activity and absence.

Scheduled Work Time (m)

The reported or calculated time used performing an activity (work-related tasks) or in absence. Whether an activity or absence should be regarded as work time is defined per activity and absence.

Scheduled Work Time (s)

The reported or calculated time used performing an activity (work-related tasks), or in absence. Whether an activity or absence should be regarded as work time is defined per activity and absence.

Shift End Date

The date when the shift ends.

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.

Shift Length

Data field Definition
Shift Length (h) The shift length is the total time of a shift. Use the Shift Length to sort or filter measures for Agent Schedule and Preferences.
Shift Length (m) The duration of the shift in minutes.
Shift Length ID The Calabrio ONE database ID for the shift length.

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.