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 Workforce Optimization 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 Workforce Optimization 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 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. |
Overtime
Data field | Definition |
---|---|
Is Overtime Type Deleted | Whether or not an overtime type is deleted. 1 = yes, 0 = no. |
Overtime ID | The Workforce Optimization 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 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. |
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 Workforce Optimization database ID for the shift length. |
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. |