This article explains the fields that can be mapped from your import file into FastTrack Time and Attendance when you create a Timesheet Import batch. It also outlines the required data type for each field so that your file passes mapping and data type validation.
📌 Note: Some fields were introduced in version 12.17 to support importing reimbursements, absences and adjustment timesheets. These are highlighted in the descriptions below where relevant.
How Mapping Fields Are Used
When you create a Timesheet Import batch, each column header in your import file can be mapped to a FastTrack timesheet field on the Import Settings screen. The value in each row of that column is then imported into the mapped field on the resulting timesheet or timesheet item.
Use this table to:
Confirm which fields are available to map.
Check what each field does and when it should be used.
Ensure the data in your file matches the required data type (for example, date, time, numeric or alphanumeric).
For details of how the system validates required mappings and data types when you queue a batch, see Field Mapping and Data Type Validation.
Timesheet Import Field List and Data Types
Field Name | Description | Data Type |
Attendance / Absence Item Import Code | Import code assigned to an attendance item, as configured on an attendance type in Recruitment Maintenance, and click Attendance. Use this field (instead of Attendance Item Name) when the Attendance Item or Absence Item setting in Agency Portal, then click Settings, after that click Maintenance, then click Time & Attendance and click Timesheet Import is set to Import Code. | Alphanumeric (maximum 25 characters) |
Attendance / Absence Item Name | Name of an attendance item, as configured in Recruitment Maintenance in Attendance. | Alphanumeric (maximum 255 characters) |
Adjustment Reason | Adjustment Reason used when the timesheet to be imported is an Adjustment Timesheet. This is mandatory for Adjustment Timesheets where the file contains different reasons for individual adjustment timesheets. If all adjustment timesheets share the same reason, use the Default Adjustment Reason in the Create Timesheet Import Batch wizard and do not include this field in the file. | Alphanumeric (maximum 40 characters) |
Adjustment Reason Import Code | Adjustment Reason Import Code used when the timesheet to be imported is an Adjustment Timesheet. Works the same way as Adjustment Reason, but uses the import code instead of the name. If all adjustment timesheets share the same reason, set it as the wizard’s default and do not include this field in the file. | Alphanumeric (maximum 50 characters) |
Break End 1 | Unpaid break end time for the 1st shift on a given date. | Time (format: |
Break End 2 | Unpaid break end time for the 2nd shift on a given date. | Time (format: |
Break End 3 | Unpaid break end time for the 3rd shift on a given date. | Time (format: |
Break End 4 | Unpaid break end time for the 4th shift on a given date. | Time (format: |
Break End 5 | Unpaid break end time for the 5th shift on a given date. | Time (format: |
Break End 6 | Unpaid break end time for the 6th shift on a given date. | Time (format: |
Break End 7 | Unpaid break end time for the 7th shift on a given date. | Time (format: |
Break End 8 | Unpaid break end time for the 8th shift on a given date. | Time (format: |
Break End 9 | Unpaid break end time for the 9th shift on a given date. | Time (format: |
Break End 10 | Unpaid break end time for the 10th shift on a given date. | Time (format: |
Break Start 1 | Unpaid break start time for the 1st shift on a given date. | Time (format: |
Break Start 2 | Unpaid break start time for the 2nd shift on a given date. | Time (format: |
Break Start 3 | Unpaid break start time for the 3rd shift on a given date. | Time (format: |
Break Start 4 | Unpaid break start time for the 4th shift on a given date. | Time (format: |
Break Start 5 | Unpaid break start time for the 5th shift on a given date. | Time (format: |
Break Start 6 | Unpaid break start time for the 6th shift on a given date. | Time (format: |
Break Start 7 | Unpaid break start time for the 7th shift on a given date. | Time (format: |
Break Start 8 | Unpaid break start time for the 8th shift on a given date. | Time (format: |
Break Start 9 | Unpaid break start time for the 9th shift on a given date. | Time (format: |
Break Start 10 | Unpaid break start time for the 10th shift on a given date. | Time (format: |
Candidate Alt No | Alternative candidate number or code that the client uses to reference the candidate, as configured in the candidate record in Recruitment Manager. | Alphanumeric (maximum 50 characters) |
Candidate Firstname | Candidate’s given name, as configured on the candidate record in Recruitment Manager. | Alphanumeric (maximum 50 characters) |
Candidate Full Name (formatted CandidateFirstname CandidateSurname) | Candidate’s full name in the format | Alphanumeric (maximum 101 characters) |
Candidate Full Name (formatted CandidateSurname CandidateFirstname) | Candidate’s full name in the format | Alphanumeric (maximum 101 characters) |
Candidate ID | Unique number that identifies a candidate, as configured on the candidate record in Recruitment Manager. | Integer (9 characters exactly) |
Candidate Surname | Candidate’s family name, as configured on the candidate record in Recruitment Manager. | Alphanumeric (maximum 50 characters) |
Client Alternate No | Alternative client number or code that the client uses to identify themselves, as configured on the client record in Recruitment Manager. | Alphanumeric (maximum 50 characters) |
Client No | Unique number that identifies a client, as defined on the client record in Recruitment Manager. | Integer (9 characters exactly) |
Cost Centre Code | Code that identifies a client cost centre (site), as defined in the Cost Centre record in Recruitment Manager. Two cost centres for the same client cannot share the same code, but cost centres for different clients can. If cost centre codes are reused across clients, consider using Cost Centre No. instead for a unique match. | Alphanumeric (maximum 50 characters) |
Cost Centre Name | Name of a client cost centre (site), as defined on the Cost Centre record in Recruitment Manager. Two cost centres for the same client cannot share the same name, but cost centres for different clients can. If names are reused across clients, consider using Cost Centre No. instead for a unique match. | Alphanumeric (maximum 50 characters) |
Cost Centre No. | System-generated, nine-digit number that uniquely identifies a client cost centre (site), as defined in the Cost Centre record in Recruitment Manager. | Integer (9 characters exactly) |
End Time 1 | End time of the 1st shift on a given date. | Time (format: |
End Time 2 | End time of the 2nd shift on a given date. | Time (format: |
End Time 3 | End time of the 3rd shift on a given date. | Time (format: |
End Time 4 | End time of the 4th shift on a given date. | Time (format: |
End Time 5 | End time of the 5th shift on a given date. | Time (format: |
End Time 6 | End time of the 6th shift on a given date. | Time (format: |
End Time 7 | End time of the 7th shift on a given date. | Time (format: |
End Time 8 | End time of the 8th shift on a given date. | Time (format: |
End Time 9 | End time of the 9th shift on a given date. | Time (format: |
End Time 10 | End time of the 10th shift on a given date. | Time (format: |
Item Date | Date on which a timesheet item occurs. | Date (format: |
Job Alt No | Alternative job order number that the client uses to reference a job order, as configured in the job order record in Recruitment Manager. | Alphanumeric (maximum 50 characters) |
Job ID | Unique job number that identifies a specific job order record in Recruitment Manager. | Integer (9 characters exactly) |
Pay Code Import Code | Import code assigned to a pay code, as configured in the pay code record header in Rates and Rules. Can be used to identify manual/additional timesheet items. Use this field (instead of Pay Code Name) when the Manual Item setting in Agency Portal in Settings, then click Maintenance, click Time & Attendance, and click Timesheet Import is set to Import Code. | Alphanumeric (maximum 50 characters) |
Pay Code Name | Unique name that identifies a pay code, as configured in the pay code header in Rates and Rules. Can be used to identify manual/additional timesheet items. Use this field (instead of Pay Code Import Code) when the Manual Item setting in Agency Portal, then click Settings, and click Maintenance, then click Time & Attendance, and click Timesheet Import is set to Name. | Alphanumeric (maximum 50 characters) |
Pay Rate | Rate of pay that applies to an additional (manual) timesheet item. | Numeric |
Project Code | Unique code that identifies a project against which a timesheet item is allocated. If Display Codes as Picklist is enabled on the Job Order, then click Project Codes record for the job order, the value in this field must match one of the project codes configured on that job order. | Alphanumeric (maximum 50 characters) |
Project Code 1 | Project code against which the 1st shift on a given date is allocated. If Display Codes as Picklist is enabled on the job order, the value must match a configured project code. | Alphanumeric (maximum 20 characters) |
Project Code 2 | Project code against which the 2nd shift on a given date is allocated. | Alphanumeric (maximum 20 characters) |
Project Code 3 | Project code against which the 3rd shift on a given date is allocated. | Alphanumeric (maximum 20 characters) |
Project Code 4 | Project code against which the 4th shift on a given date is allocated. | Alphanumeric (maximum 20 characters) |
Project Code 5 | Project code against which the 5th shift on a given date is allocated. | Alphanumeric (maximum 20 characters) |
Project Code 6 | Project code against which the 6th shift on a given date is allocated. | Alphanumeric (maximum 20 characters) |
Project Code 7 | Project code against which the 7th shift on a given date is allocated. | Alphanumeric (maximum 20 characters) |
Project Code 8 | Project code against which the 8th shift on a given date is allocated. | Alphanumeric (maximum 20 characters) |
Project Code 9 | Project code against which the 9th shift on a given date is allocated. | Alphanumeric (maximum 20 characters) |
Project Code 10 | Project code against which the 10th shift on a given date is allocated. | Alphanumeric (maximum 20 characters) |
Purchase Order No | Unique number or code that identifies a purchase order, as assigned to a job order record in Recruitment Manager. | Alphanumeric (maximum 50 characters) |
Quantity | Quantity that applies to an additional (manual) timesheet item. | Numeric |
Start Time 1 | Start time of the 1st shift on a given date. | Time (format: |
Start Time 2 | Start time of the 2nd shift on a given date. | Time (format: |
Start Time 3 | Start time of the 3rd shift on a given date. | Time (format: |
Start Time 4 | Start time of the 4th shift on a given date. | Time (format: |
Start Time 5 | Start time of the 5th shift on a given date. | Time (format: |
Start Time 6 | Start time of the 6th shift on a given date. | Time (format: |
Start Time 7 | Start time of the 7th shift on a given date. | Time (format: |
Start Time 8 | Start time of the 8th shift on a given date. | Time (format: |
Start Time 9 | Start time of the 9th shift on a given date. | Time (format: |
Start Time 10 | Start time of the 10th shift on a given date. | Time (format: |
Timesheet Code | Code that uniquely identifies a timesheet, as specified in the timesheet header in Time and Attendance. | Alphanumeric (maximum 50 characters) |
Timesheet Week Ending Date | Week ending date of the timesheet. | Date (format: |
Timesheet Week Starting Date | Week starting date of the timesheet. | Date (format: |
Reimbursement Item Name | Name of the Reimbursement Item when reimbursements are included in the timesheet import. You must include this field or Reimbursement Import Code for reimbursement rows. The date is supplied using the existing Item Date field. | Alphanumeric (maximum 255 characters) |
Reimbursement Import Code | Import code of the Reimbursement Item when reimbursements are included in the timesheet import. Use this field or Reimbursement Item Name for reimbursement rows. | Alphanumeric (maximum 50 characters) |
Net | Reimbursement net value when reimbursements are included in the timesheet import. Required where a reimbursement is imported and Currency Code and Currency Value are not used. | Numeric |
Tax | Reimbursement tax value (GST/VAT) when reimbursements are included in the timesheet import. Required where a reimbursement is imported and Currency Code and Currency Value are not used. Must be zero if not applicable. | Numeric |
Currency Code | Currency code used where Currency Conversion is configured and the reimbursement amount needs to be converted during payroll. Where currency is required, both Currency Code and Currency Value must be supplied, and Net and Tax are not required. | Alphanumeric (3 characters) |
Currency Value | Currency value used where Currency Conversion is configured and the reimbursement amount needs to be converted during payroll. Where currency is required, both Currency Code and Currency Value must be supplied, and Net and Tax are not required. | Numeric |
Reimbursement Project Code | Project code for the reimbursement item where a project code is required. If a project code is mandatory on the timesheet, this value must be provided for all reimbursement rows. | Alphanumeric (maximum 50 characters) |
Important – Reimbursement rows: For reimbursement items, leave Pay Code Name blank (if mapped) because the Reimbursement Item Name or Reimbursement Import Code is used instead. Also leave Quantity blank for reimbursement rows.