Skip to main content
Administrator Guide
Last Updated: 2025-11-14
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 new time off requests into Workday. For performant data loads, we recommend you use this EIB when the batch of requests exceeds either:
  • 100 requests against an absence table.
  • 1,000 requests directly against a time off type or plan.
  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 include time off requests more than 99 weeks old.
    • 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.