Workforce Ready Accrual Import Column Descriptions

Object Property in this application Workforce Ready Report Column Name Required Formatting in this application Max Length Notes
Employee ID *Employee Id alphanumeric 30 Unique Workforce Ready field which maps to the employee ID field of Resource Master Table in this application.
Work Code *Time Off   10 Unique Workforce Ready field which maps to the wstat table (workcode abbreviation) in this application. Uses the Workforce Ready ‘time off’ category that is equivalent to this application’s ‘work code’ as set in the mapping table located in Setup > System > Import Manager...>Workforce Ready Integration > ... Accrual Import Mapping
Since Date

Object Property removed from report processing logic.

>>>>>>> See Notes >>>>>>> See Notes >>>>>> Important: The Since Date is the run date of the Workforce Ready Accrual Import Task as of v6.8.5+, and 7.1.1+.
Work Code Hours Accrual Balance Hours1 H.JJJ;-H.JJJ n/a This Workforce Ready field is used to set the accrual balance of hours. If empty or a dash (-) is present, zero hours is implied for work code hours. The format is ‘Hours.Fraction Rounded’. For example, 4:20=4.333, 4:40=4.667.

Since Date in Setup Codes

The logic for the Since Date object property was moved from the Workforce Ready Reportin application version 6.8.5+, and 7.1.1+. The task run time of the Workforce Ready Accrual Import task now sets the Since Date for the work code supplied -and all other work codes with the same Group number located in Setup > Codes.

For example, suppose the following work codes share the same work code Group number of five: Sick Time Earned, Sick Taken, Vacation Earned, Vacation Taken and all employees are affected by the import. On July 5, 2019 the task Workforce Ready Accrual Import runs and imports 4 hours of Sick Time Earned. This means that employees have a Sick Time Earned work code on their calendar on July 5, 2019 for 4 hours. The Sick Time Earned work code -AND Sick Time Taken, Vacation Earned, Vacation Taken now show a Since Date of July 5, 2019 in Setup > Codes... because they share the same Group number value.

Moreover, suppose a Vacation Earned import for 8hrs runs on July 12, 2019, this means that employees see Vacation Earned on their calendar on July 12, 2019 for 8 hours. The Vacation Time Earned work code -AND Vacation Taken, Sick Time Taken, Sick Time Earned now show a Since Date of July 12, 2019 in Setup > Codes... because they share the same Group number value.

1 In application version 6.8.5+, and 7.1.1+ the Workforce Ready report column Accrual Balance Hours replaced the Hours Remaining column for accrual balances.