Concept: Data Entry in Period Schedule EIB Spreadsheets
To upload a period schedule, you can create an EIB based on the
Put Period Schedule
web
service. You can then enter data in a spreadsheet that corresponds to the inbound
EIB.These examples illustrate how to complete the EIB spreadsheet for the
Put Period
Schedule
web service.- Examples: Add A New Period Schedule
- You want to upload a period schedule with a monthly frequency from January 2018 to April 2018. You’re going to use the period schedule for Workday Payroll, and Absence Management.Add these rows to the EIB spreadsheet:Spreadsheet KeyPeriod Schedule IDPeriod Schedule NameFrequencyUsagePeriod Data - Row IDPeriod Start DatePeriod End DatePayroll Payment DatePeriod ID1MONTHLYMonthlyMonthlyUsage_Payroll12018-01-012018-01-312018-01-30Period_11Usage_Absence22018-02-012018-02-282018-02-27Period_2132018-03-012018-03-312018-03-31Period_3142018-04-012018-04-302018-04-30Period_4If you leave thePeriod Schedule IDblank, Workday generates a new reference ID when you import the sheet. This new reference ID can cause duplicate period schedules if you run the same EIB spreadsheet multiple times.ThePayroll Payment Datefield is only for Workday Payroll and Workday Payroll Interface usage.
- Example: Modify Existing Period Schedule
- You want to modify the payroll payment date for a period in an existing period schedule.Enter these columns in the EIB spreadsheet:Spreadsheet KeyPeriod Schedule IDPeriod Schedule NameFrequencyPeriod Data (Row ID)Period Start DatePeriod End DatePayroll Payment DatePeriod ID1MONTHLYMonthlyMonthly12018-03-012018-03-312018-03-30Period_3Ensure that thePeriod Schedule IDandPeriod IDfields refer to the existing period schedule and period. When you enter a newPeriod Schedule IDor leave the field empty, Workday creates a new period schedule.
- Example: Create Forward Accruals
- You have a biweekly period schedule for January and February. You want to set up forward accruals for the last period of each month when there are remaining days in the month after the period end date.Enter these columns in the EIB spreadsheet:Period Data (Row ID)Period Start DatePeriod End DatePayroll Payment DatePayroll GL AccrualsDays to AccrueDays in BasisAccrual DateAccrual Reversal DatePeriod ID12018-01-012018-01-142018-01-19222018-01-152018-01-282018-02-02Y3102018-01-312018-02-01332018-01-292018-02-112018-02-16442018-02-122018-02-252018-03-02Y3102018-02-282018-03-015