Skip to main content
Documentation
Documentation
Administrator Guide
Last Updated: 2023-10-20
Example: Include Workday and Company-Specific Deductions in EIB Spreadsheets

Example: Include Workday and Company-Specific Deductions in EIB Spreadsheets

This example illustrates how to include both Workday and company-specific deductions in an EIB spreadsheet when uploading payroll input or off-cycle payments.
You want to upload payroll input in the form of either payroll input or off-cycle payments for these pay components:
  • A parking deduction (a deduction your company created).
  • A withholding order employer fee (a Workday-owned deduction).
You need to add a large number of inputs, so you use an EIB based on a spreadsheet to upload the inputs. You want to use 1 spreadsheet to add input for both the Workday-delivered and company-specific deductions.
Create an inbound EIB:
  • For payroll inputs, base the EIB on the
    Import Payroll Input
     web service.
  • For off-cycle payments, base the EIB on the
    Import Payroll Off-cycle Payment
     web service.
Create a deduction for parking fees with a code of
WE_PARK
.
Security:
  • Integration Build
     domain in the Integration functional area.
  • My Reports
     domain in the System functional area.
  1. Access the
    View Integration System
     task and select the integration system for your inbound EIB.
    1. Select
      Template Model
      View
       from the related actions menu.
    2. Navigate to the
      Payroll Input Data+
       or
      Off cycle Input Data+
       section and select
      Edit Template Model Area
      .
    3. In the
      Column Details
       grid, select the
      Separate Type Column
       check box in the row with the
      Deduction
       label.
    4. Click
      OK
       and
      Done
       to return to the template model.
    5. From the related actions menu, select
      Template Model
      Generate Spreadsheet Template
      .
  2. Access the
    My Reports
     task to download the Excel file spreadsheet template.
    Keep the template in its original
    XML Spreadsheet 2003
     format.
  3. Add a row for each input:
    Spreadsheet Key
    Row ID
    Deduction - ID Type
    Deduction-ID Value
    Amount
    1
    1
    Deduction_Code
    WE_PARK
    25
    2
    2
    Workday_Deduction_Code
    W_WOFER
    50
    You can identify deduction ID types and values on the
    Integration IDs
     report.
  4. Complete the remaining fields for the payroll input or off-cycle payment.
Launch the EIB spreadsheet upload.