Export file details

The following table displays the details of the export file sent from WFM to the HRMS.

Element	Description
File Location	C:\Program Files\Common Files\Calabrio ONE\Data Server\gis\vacationreports\<tenant name>
File Name	vacation_<date>_WFM
File Header	VACATION FROM WFM DATE: <date>
Column Headers	login date vacationTypeLabel usedHours requestedHours approvedHours employeeId acdId

• All agents that have a vacation plan via the import file (see Import file details) are included in the export file.
• Only dates with usedHours in the past 7 days are included in the export for each agent.
• If a date has usedHours for an agent for at least one vacation type, then all vacation types are shown in the file, even if no hours were used on that date. In that case, the usedHours field displays a dash ( — ).
• The requestedHours and approvedHours fields appear only on the last date that is reported for each agent. These values are not tied to a specific date since they are totals for all future dates.
• If an agent does not have any used hours for any vacation type in the 7 day period, then a date row is inserted for yesterday for each vacation type and requestedHours and approvedHours are reported there.

The output export file contains the following for each vacation type:

• Used Hours: The hours used for the date on the row. This value is based on the duration of vacation type exceptions in the agent’s schedule for the date. Vacation type exceptions are configured on the Calabrio ONE Vacation Types page (Application Management > Vacation Planning > Vacation Types).
• Requested Hours: The total hours that are pending and not yet approved at the current time.
• Approved Hours: The total approved hours. For partial day requests, the duration of the request is used. For all-day requests, the duration is calculated as Minimum Hours Per Week ÷ 5 as defined in the agent’s Full Time Equivalents Profile, configured on the Calabrio ONE Full Time Equivalents Profiles page (Application Management > Vacation Planning > Full Time Equivalents Profiles).

The following is an example of an export file.

VACATION FROM WFM DATE: 2018-04-20
login,date,vacationTypeLabel,usedHours,requestedHours,approvedHours,
employeeId,acdId
smithj@example.com,2018-04-13,Floating Holiday,8.0,-,-,john.smith,2
smithj@example.com,2018-04-13,Vacation,-,-,-,john.smith,2
smithj@example.com,2018-04-15,Floating Holiday,-,-,-,john.smith,2
smithj@example.com,2018-04-15,Vacation,8.0,16.0,8.0,john.smith,2
jonest@example.com,2018-04-14,Vacation,4.0,-,-,teri.jones,1
jonest@example.com,2018-04-15,Vacation,8.0,-,-,teri.jones,1
adamsb@example.com,2018-04-19,Vacation,-,-,-,teri.jones,1

In this example, vacation hours are reported as follows.

Employee	Vacation Hour Usage
smithj	Used 8 hours of Floating Holiday on April 13. Used 8 hours of Vacation on April 15. Has 16 hours of requests for Vacation that are pending approval on or after April 20. Has 8 hours of requests for Vacation that are approved on or after April 20. Has no approved or pending requests for a Floating Holiday on or after April 20.
jonest	Used 4 hours of Vacation on April 14. Used 8 hours of Vacation on April 15. Has no approved or pending requests for a Floating Holiday on or after April 20.
adamsb	Has no used hours in the 7-day period starting April 13. Has no approved or pending requests for a Floating Holiday on or after April 20.