Skip to main content
Documentation
Documentation
Administrator Guide
Last Updated: 2023-06-23
Example: Bulk Load Time Off Requests into Workday

Example: Bulk Load Time Off Requests into Workday

When uploading a high volume of time off requests through an EIB spreadsheet or existing web services, you must follow certain criteria. This example illustrates how to configure the EIB spreadsheet for the
Import Time Off Request Event Batch
 web service.
You want to bulk upload a high volume of time off requests into Workday.
  1. Generate an EIB spreadsheet based on the
    Import Time Off Request Event Batch
     web service.
  2. Prepare the EIB spreadsheet using these criteria:
    • Don't enter a time off request before the latest persisted balance date.
    • Don't split workers across files. All entries for a worker should be in the same file.
    • Each row has a unique ID in the tenant.
    • Each time off request in the same time off type has only 1 unit for the same date per row. Example: A worker requests 3 hours time off and 2 hours time off of the same type and on the same date. Include these requests as 5 hours on the same row. If you're loading requests with start and end times, you can use multiple rows.
    • Each worker has only 1 line key.
    • Order requests chronologically, from oldest to most recent.
    • You can enter an optional
      Time Off Entry ID
       value for each entry that you're loading. If you specify a value, it must be unique. When you leave it blank, Workday generates an ID automatically.
    • You can use multiple header keys. All time off requests from an individual worker must use the same header key.
You can view your time off requests in Workday.