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 A unique Workforce Ready field which maps to the Employee ID field of the Resource Master Table in this application.
Work Code *Time Off   10 A unique Workforce Ready field which maps to the wstat table (work code abbreviation table) in this application. This property uses the Workforce Ready Time-off category that is equivalent to a work code in this application as defined on the work code mapping table located in the Integration tab of the Import Manager for a Workforce Ready account.
Since Date

Object Property removed from report processing logic.

See Notes Columns See Notes Column   Important: The Since Date is the run date of the Workforce Ready Accrual Import Task.
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 task run time of the Workforce Ready Accrual Import task 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 both belong to the same Accrual Group.

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 The Workforce Ready report column Accrual Balance Hours replaced the Hours Remaining column for accrual balances.