Workday logovP

Leave, absence and time

Workday to vPlan integration: Dutch workers as vPlan resources, with hours, time off and leave of absence per day

With an integration between Workday and vPlan, every worker of the Dutch organisation in Workday appears automatically as a resource in vPlan, with start date, last day of work and scheduled hours per day. Approved time off and a leave of absence from Workday remove available hours on the right days, so planners in vPlan do not schedule work on someone who is away.

What the integration does

Organisations that manage workers in Workday and plan work in the Netherlands in vPlan add new employees to vPlan by hand. Planners only hear about holidays when someone does not show up, and long leave such as parental leave only exists in Workday.

  1. HR completes a hire in Workday for the part of the organisation that plans in vPlan.
  2. KoppelHet creates a resource in vPlan with the Employee ID as reference, from the start date.
  3. The weekly hours from Workday are spread over the working days and set per date in vPlan.
  4. Approved time off and a leave of absence put leave or absence hours on those days.
  5. After a termination the resource gets the last day of work as end date.
Workday → KoppelHet → vPlanSOURCEWorkdayTARGETvPlanvPlanKoppelHetmapping · logging · monitoringWorkday → KoppelHet → vPlanSOURCEWorkdayTARGETvPlanvPlanKoppelHetmapping · logging · monitoring
Out: Resource with Employee ID, name, start date and last day of work · Working days and hours per day · Approved time off per day · Leave of absence over a longer period

What to watch for with Workday and vPlan

  • Workday records scheduled hours per week, not hours per weekday, unless the organisation uses Workday Time Tracking with work schedules. vPlan plans per day. KoppelHet spreads the weekly hours over the working days by a rule you choose beforehand, and sets them per date in vPlan.
  • Workday distinguishes time off, such as a day of holiday, from a leave of absence, such as parental or long-term leave. Time off becomes leave hours on that day in vPlan. A leave of absence removes the whole schedule over the period, so an employee is not plannable for two months without anyone entering each day separately.
  • Workday's Absence Management web service has operations to enter time off and to fetch balances, but no operation to read time off entries. KoppelHet therefore reads approved time off with a RaaS report on change date.
  • On a termination Workday records the last day of work next to the termination date. An employee who takes their final weeks as leave cannot be planned after the last day of work. KoppelHet uses that date as the resource's end date.
  • A Workday tenant contains workers in many countries. vPlan often only runs for one Dutch department or division. KoppelHet only reads workers of the supervisory organizations planned in vPlan, so office staff and colleagues abroad do not appear as resources in planning.
  • A reference may occur only once in vPlan, also on archived resources. The Employee ID in Workday stays the same on a rehire. KoppelHet therefore restores a returning employee from the archive instead of creating a second resource.

How we build and run it

  • The integration runs on the KoppelHet platform, hosted in a data centre in the EU.
  • Every sync and every error is visible in the functional log; on an error your administrator is notified.
  • A change that cannot go through is not half-applied but queued for another attempt.
  • KoppelHet is ISO 27001 certified. Data travels encrypted and stays on the platform no longer than needed.
  • After go-live we manage the integration and adjust it when your process changes.
  • The integration fits next to your existing integration layer. Only the fields in the design are transferred; the platform keeps no register of its own.

Implementation, architecture and compliance

Implementation and price

This is not an app you switch on. We build the integration for your organisation on our platform, with building blocks we reuse on every project. So it is custom work that does not start from scratch.

A consultant prepares the intake and analyses both systems. We then record the mapping and exceptions field by field, test in the test or acceptance environment and go live at a moment you choose. Costs are a one-off amount for the setup and a monthly amount for platform, monitoring and support.

Price indication · Basic

Leave your work email and you see the price indication right away.

We only use your address to follow up on your question about this integration.

Frequently asked questions

Do planned jobs from vPlan go back to Workday?

No. vPlan plans the work, Workday manages the people. Hours from vPlan to Workday or payroll can come later as an extension.

What if an employee has a different schedule?

Without work schedules in Workday the integration spreads weekly hours by a fixed rule. For a different schedule the planner can set an exception in vPlan, or you record the schedule in Workday.

Does the planner see why someone is away?

No. vPlan only receives whether it is leave or absence and how many hours. The type of leave and the reason stay in Workday.

Technical details for IT

For those who want to know how it works under the hood: APIs, fields and sources used.

  • Workday through RaaS reports with an Integration System User - workers on change date (Employee_ID, Hire_Date, Scheduled_Weekly_Hours, Supervisory_Organization, Last_Day_of_Work) and approved time off entries and leaves of absence. The Absence Management web service contains Enter_Time_Off and Get_Time_Off_Plan_Balances, no read operation for time off entries.
  • vPlan through the vPlan API (https://api.vplan.com/v1) with OAuth 2. Resource with type employee, start_date, end_date and external_ref (duplicate returns 422); integration_schedule set to true, schedule per date through PUT /resource/{resource_id}/schedule with hours_work, hours_leave and hours_absence.

Which fields are transferred

The key fields. The full mapping is agreed per customer.

Field in WorkdayField in vPlanNotes
Employee_IDexternal_refUnique in vPlan, also on archived resources
Preferred_Name / Legal_Namename
Hire_Datestart_date
Last_Day_of_Work (termination)end_dateNot the termination date
Scheduled_Weekly_Hoursschedules[].hours_work per datumSpread over the working days by a fixed rule
Time off entries (goedgekeurd)schedules[].hours_leaveFrom a RaaS report
Leave of absence (begin- en einddatum)schedules[].hours_absenceThe whole schedule of those days

Related

Which systems do you want to connect?

Tell us which systems you use and what should happen automatically. Together we define the smallest working solution, with a clear design and a quote before building.