Works id #
You must set up a Works id for every candidate. Without a unique Works id you will be unable to map shifts to the candidate. You are free to use any alphanumeric characters. Every candidate’s Works id must be unique.
There are no restrictions for restarters – use a different or original Works id.
New fields #
Be sure to add the following new Fields to your Rocket installation for paiyroll®:
- End date (leaving date)
- Starter Declaration (A B C)
Candidate/Worker Data feed #
| paiyroll column | Your file column specification |
|---|---|
| username | {Email} -> _.lower() |
| {Email} -> _.lower() | |
| is_active=True | |
| title | {Title*} |
| name | {Forename} {Surname} -> _.replace(‘(‘, ”).replace(‘)’, ”) |
| mobile | {Mobile Phone} -> _[:20] |
| preferences={} | |
| works_id | {Payroll Number} |
| start_date | {Start Date} -> _.split(‘ ‘, 1)[0] if _ else ” |
| working_days | {{true,true,true,true,true,false,false}} |
| fte | |
| end_date | {Leave Date} |
| original_start_date | |
| department | w1 |
| existing_employee=False | |
| notes | |
| data | |
| cost_centres | |
| uploaded= | True |
| external_uid= | |
| postaldetail.line1 | {Address Line 1} |
| postaldetail.line2 | {Address Line 2} |
| postaldetail.line3 | {Town} |
| postaldetail.line4 | |
| postaldetail.postcode | {Postcode} -> _.replace(‘ ‘, ”) |
| postaldetail.foreign_country | |
| taxdetail.weekly_hours_worked=Other | |
| taxdetail.P45_tax_code= | |
| taxdetail.P45_week1_month1=False | |
| taxdetail.P45_leaving_date= | |
| taxdetail.P45_total_pay_to_date= | |
| taxdetail.P45_total_tax_to_date= | |
| taxdetail.P45_continue_student_loan=0 | |
| taxdetail.P45_continue_postgraduate_loan=0 | |
| taxdetail.NI_category=General | |
| taxdetail.workplace_postcode= | |
| taxdetail.director=False | |
| taxdetail.director_from= | |
| taxdetail.director_NI_cumulative=False | |
| taxdetail.paid_irregularly=False | |
| taxdetail.off_payroll_worker=False | |
| taxdetail.migrated_rti_payid= | |
| taxdetail.cis= | |
| taxeedetail.date_of_birth | {Date of Birth} -> _.split(‘ ‘, 1)[0] if _ else ” |
| taxeedetail.gender | |
| taxeedetail.NI_number | {National Insurance Number} -> re.sub(‘[^A-Z0-9]’, ”, _.upper()) |
| taxeedetail.employee_statement | {Starter Declaration} |
| taxeedetail.student_loan=0 | |
| taxeedetail.postgraduate_loan=0 | |
| taxeedetail.cis_trading_name= |
Shift/Timesheet Data feed #
Below is a typical column mapping:
| paiyroll column | Your file column specification |
|---|---|
| Works id | {Payroll Number} |
| Worker name | {Candidate Name} |
| Rate | {Standard Pay} |
| Units | {Standard (Decimal)} |
| Display as | {Started}{Location}{Standard (Decimal)}{Standard Pay} -> ‘{0} {1} {2}hrs x {3}’.format(_1[:16], _2, _3, _4) |
| Code | |
| Date |
Codes #
You can specify up to 10 project Cost codes.