The table below lists and describes the FastTrack manual item interpreted timesheet fields that can be mapped to column headers in a timesheet an interpreter manual item import file. These field fields are available for selection in the Map To Field column on the Import Settings screen when creating a Timesheet Manual Item Import batch. For each field, the table identifies the data type that is required by the field.
Map to Fields | Description | Data |
---|
Attendance Item Import Code
Import code that is assigned to an attendance item, as configured on an attendance type that is configured in Recruitment Maintenance > Attendance.
Note that this field needs to be used to identify attendance or absence items rather than the Attendance Item Name field if the Attendance Item field or the Absence Item field in Agency Portal > Settings > Maintenance > Time & Attendance > Timesheet Import is set to Import Code instead of Name.
Alphanumeric (maximum 25 characters)
Attendance Item Name
Name of an attendance item, as configured in Recruitment Maintenance > Attendance.
Note that this field needs to be used to identify attendance or absence items rather than the Attendance Item Import Code field if the Attendance Item field or the Absence Item field in Agency Portal > Settings > Maintenance > Time & Attendance > Timesheet Import is set to Name instead of Import Code.
Alphanumeric (maximum 255 characters)
Break End 1
Specifies the unpaid break end time for the 1st shift on a given date.
Time (format: hh:mm)
Break End 2
Specifies the unpaid break end time for the 2nd shift on a given date.
Time (format: hh:mm)
Break End 3
Specifies the unpaid break end time for the 3rd shift on a given date.
Time (format: hh:mm)
Break End 4
Specifies the unpaid break end time for the 4th shift on a given date.
Time (format: hh:mm)
Break End 5
Specifies the unpaid break end time for the 5th shift on a given date.
Time (format: hh:mm)
Break End 6
Specifies the unpaid break end time for the 6th shift on a given date.
Time (format: hh:mm)
Break End 7
Specifies the unpaid break end time for the 7th shift on a given date.
Time (format: hh:mm)
Break End 8
Specifies the unpaid break end time for the 8th shift on a given date.
Time (format: hh:mm)
Break End 9
Specifies the unpaid break end time for the 9th shift on a given date.
Time (format: hh:mm)
Break End 10
Specifies the unpaid break end time for the 10th shift on a given date.
Time (format: hh:mm)
Break Start 1
Specifies the unpaid break start time for the 1st shift on a given date.
Time (format: hh:mm)
Break Start 2
Specifies the unpaid break start time for the 2nd shift on a given date.
Time (format: hh:mm)
Break Start 3
Specifies the unpaid break start time for the 3rd shift on a given date.
Time (format: hh:mm)
Break Start 4
Specifies the unpaid break start time for the 4th shift on a given date.
Time (format: hh:mm)
Break Start 5
Specifies the unpaid break start time for the 5th shift on a given date.
Time (format: hh:mm)
Break Start 6
Specifies the unpaid break start time for the 6th shift on a given date.
Time (format: hh:mm)
Break Start 7
Specifies the unpaid break start time for the 7th shift on a given date.
Time (format: hh:mm)
Break Start 8
Specifies the unpaid break start time for the 8th shift on a given date.
Time (format: hh:mm)
Break Start 9
Specifies the unpaid break start time for the 9th shift on a given date.
Time (format: hh:mm)
Break Start 10
Specifies the unpaid break start time for the 10th shift on a given date.
Format | ||
---|---|---|
Candidate ID | Number that uniquely identifies a candidate, as configured on a candidate record in Recruitment Manager. | Integer (9 characters exactly) |
Candidate Alt No | Alternative candidate number or code that is used by the client to reference a candidate, as configured in the candidate record properties in Recruitment Manager. | Alphanumeric (maximum 50 characters) |
Candidate Firstname | Given name of a candidate, as configured on a candidate record in Recruitment Manager. | Alphanumeric (maximum 50 characters) |
Candidate Surname | Family name of a candidate, as configured on a candidate record in Recruitment Manager. | Alphanumeric (maximum 50 characters) |
Candidate Full Name (formatted CandidateSurname CandidateFirstname |
)* | Full name of a candidate in the format <surname> <first name> |
. For example: Smith John |
|
|
|
|
|
| Alphanumeric (maximum 101 characters) | |
Candidate Full Name (formatted CandidateFirstname CandidateSurname |
)* | Full name of a candidate in the format < |
first name> < |
surname>. For example: John Smith |
|
|
|
|
| Alphanumeric (maximum 101 characters) |
Client No | Number that uniquely identifies a |
client, as |
defined in a |
client record in Recruitment Manager. | Integer (9 characters exactly |
Candidate Surname
Family name of a candidate, as configured on a candidate record in Recruitment Manager.
) | ||
Client Alternate No | Alternative client number or code that the client uses to identify themselves, as configured in the client record properties in Recruitment Manager. | Alphanumeric (maximum 50 characters) |
Number that uniquely identifies a client, as defined in a client record in Recruitment Manager.
Integer (9 characters exactly)
Cost Centre Code | Code that identifies a client cost centre (site), as defined in a Cost Centre record in Recruitment Manager.
| Alphanumeric (maximum 50 characters) | ||
Cost Centre Name | Name of a client cost centre (site), as defined on a Cost Centre record in Recruitment Manager.
| Alphanumeric (maximum 50 characters) | ||
Cost Centre No |
System-generated, nine-digit number that uniquely identifies a client cost centre (site), as defined in a Cost Centre record in Recruitment Manager. | Integer (9 characters exactly) |
End Time 1
Specifies the end time of the 1st shift on a given date.
Time (format: hh:mm)
End Time 2
Specifies the end time of the 2nd shift on a given date.
Time (format: hh:mm)
End Time 3
Specifies the end time of the 3rd shift on a given date.
Time (format: hh:mm)
End Time 4
Specifies the end time of the 4th shift on a given date.
Time (format: hh:mm)
End Time 5
Specifies the end time of the 5th shift on a given date.
Time (format: hh:mm)
End Time 6
Specifies the end time of the 6th shift on a given date.
Time (format: hh:mm)
End Time 7
Specifies the end time of the 7th shift on a given date.
Time (format: hh:mm)
End Time 8
Specifies the end time of the 8th shift on a given date.
Time (format: hh:mm)
End Time 9
Specifies the end time of the 9th shift on a given date.
Time (format: hh:mm)
End Time 10
Specifies the end time of the 10th shift on a given date.
Time (format: hh:mm)
Item Date
Date on which a timesheet item occurred.
Job Alt No | Alternative job order number that is used by the client to reference a job order, as configured in the job order record properties 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) |
Purchase Order No | Unique number or code that identifies a purchase order number, as assigned to a job order record in Recruitment Manager. | Alphanumeric (maximum 50 characters) |
Timesheet ID | The ID of the timesheet that the manual item is to be applied to. This is a system generated value that is assigned to a timesheet. | Numeric |
Timesheet Week Ending Date | Date on which the week ending date of a timesheet falls. | Date (format: dd/mm/yyyy) |
Timesheet Week Starting Date | Date on which the week starting date of a timesheet falls. | Date (format: dd/mm/yyyy) |
Manual Item Date | Date of the manual item, must intersect with the related interpreted timesheet’s Start Date and End Date period. Mandatory | Date (format: dd/mm/yyyy |
Job Alt No
Alternative job order number that is used by the client to reference a job order, as configured in the job order record properties in Recruitment Manager.
) |
Unique job number that identifies a specific job order record in Recruitment Manager.
Integer (9 characters exactly)
Pay Code Import Code | Import code that is assigned to a pay code, as configured in the pay code record header in Rates and Rules. This can be used to identify manual/additional timesheet items. Mandatory where Pay Code Name is not supplied. Note that this field needs to be used to identify additional items rather than the Pay Code Name |
- must relate to an active Pay Code for the Timesheet’s Country. | 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. This can be used to identify manual/additional timesheet items.
Note that this field needs to be used to identify additional items rather than the Pay Code Import Code |
field |
Alphanumeric (maximum 50 characters) | |
Pay |
Quantity |
Quantity that applies to an additional pay (manual) timesheet item. |
Numeric
Project Code
Unique code that identifies a specific project against which a timesheet item is allocated.
Note that if the Display Codes as Picklist option is enabled in the Job Order > Project Codes record for the corresponding job order in Recruitment Manager, the value provided in this field must match one of the project codes configured on the job order.
Alphanumeric (maximum 50 characters)
Project Code 1
Specifies the project code against which the 1st shift on a given date is allocated.
Note that if the Display Codes as Picklist option is enabled in the Job Order > Project Codes record for the corresponding job order in Recruitment Manager, the value provided in this field must match one of the project codes configured on the job order.
Alphanumeric (maximum 20 characters)
Project Code 2
Specifies the project code against which the 2nd shift on a given date is allocated.
Note that if the Display Codes as Picklist option is enabled in the Job Order > Project Codes record for the corresponding job order in Recruitment Manager, the value provided in this field must match one of the project codes configured on the job order.
Alphanumeric (maximum 20 characters)
Project Code 3
Specifies the project code against which the 3rd shift on a given date is allocated.
Note that if the Display Codes as Picklist option is enabled in the Job Order > Project Codes record for the corresponding job order in Recruitment Manager, the value provided in this field must match one of the project codes configured on the job order.
Alphanumeric (maximum 20 characters)
Project Code 4
Specifies the project code against which the 4th shift on a given date is allocated.
Note that if the Display Codes as Picklist option is enabled in the Job Order > Project Codes record for the corresponding job order in Recruitment Manager, the value provided in this field must match one of the project codes configured on the job order.
Alphanumeric (maximum 20 characters)
Project Code 5
Specifies the project code against which the 5th shift on a given date is allocated.
Note that if the Display Codes as Picklist option is enabled in the Job Order > Project Codes record for the corresponding job order in Recruitment Manager, the value provided in this field must match one of the project codes configured on the job order.
Alphanumeric (maximum 20 characters)
Project Code 6
Specifies the project code against which the 6th shift on a given date is allocated.
Note that if the Display Codes as Picklist option is enabled in the Job Order > Project Codes record for the corresponding job order in Recruitment Manager, the value provided in this field must match one of the project codes configured on the job order.
Alphanumeric (maximum 20 characters)
Project Code 7
Specifies the project code against which the 7th shift on a given date is allocated.
Note that if the Display Codes as Picklist option is enabled in the Job Order > Project Codes record for the corresponding job order in Recruitment Manager, the value provided in this field must match one of the project codes configured on the job order.
Alphanumeric (maximum 20 characters)
Project Code 8
Specifies the project code against which the 8th shift on a given date is allocated.
Note that if the Display Codes as Picklist option is enabled in the Job Order > Project Codes record for the corresponding job order in Recruitment Manager, the value provided in this field must match one of the project codes configured on the job order.
Alphanumeric (maximum 20 characters)
Project Code 9
Specifies the project code against which the 9th shift on a given date is allocated.
Note that if the Display Codes as Picklist option is enabled in the Job Order > Project Codes record for the corresponding job order in Recruitment Manager, the value provided in this field must match one of the project codes configured on the job order.
Alphanumeric (maximum 20 characters)
Project Code 10
Specifies the project code against which the 10th shift on a given date is allocated.
Note that if the Display Codes as Picklist option is enabled in the Job Order > Project Codes record for the corresponding job order in Recruitment Manager, the value provided in this field must match one of the project codes configured on the job order.
Alphanumeric (maximum 20 characters)
Purchase Order No
| Numeric (maximum 38,6) | |
Reimbursement Net Value | The net value that applies where the related manual item Pay Code is of type ‘Reimbursement’.
| Numeric (maximum 38,6) |
Reimbursement GST/VAT Value | The GST/VAT/Tax component value that applies where the related manual item Pay Code is of type ‘Reimbursement’.
| Numeric (maximum 38,6) |
Pay Rate | Where the manual item is not of type ‘Reimbursement’ a pay rate value is required.
| Numeric (maximum 38,6) |
Bill Code Import Code | Import code that is assigned to a bill code, as configured in the bill code record header in Rates and Rules. This can be used to identify manual/additional timesheet items. Mandatory where Bill Code Name is not supplied. Note that this field needs to be used to identify additional items rather than the Bill Code Name - must relate to an active Bill Code for the Timesheet’s Country. | Alphanumeric (maximum 50 characters) |
Bill Code Name | Unique name that identifies a bill code, as configured in the pay code header in Rates and Rules. This can be used to identify manual/additional timesheet items.
Note that this field needs to be used to identify additional items rather than the Bill Code Import Code field | Alphanumeric (maximum 50 characters) |
Bill Quantity | Quantity that applies to an additional bill (manual) timesheet item. |
Numeric
Start Time 1
Specifies the start time of the 1st shift on a given date.
Time (format: hh:mm)
Start Time 2
Specifies the start time of the 2nd shift on a given date.
Time (format: hh:mm)
Start Time 3
Specifies the start time of the 3rd shift on a given date.
Time (format: hh:mm)
Start Time 4
Specifies the start time of the 4th shift on a given date.
Time (format: hh:mm)
Start Time 5
Specifies the start time of the 5th shift on a given date.
Time (format: hh:mm)
Start Time 6
Specifies the start time of the 6th shift on a given date.
Time (format: hh:mm)
Start Time 7
Specifies the start time of the 7th shift on a given date.
Time (format: hh:mm)
Start Time 8
Specifies the start time of the 8th shift on a given date.
Time (format: hh:mm)
Start Time 9
Specifies the start time of the 9th shift on a given date.
Time (format: hh:mm)
Start Time 10
Specifies the start time of the 10th shift on a given date.
Time (format: hh:mm)
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
Date on which the week ending date of a timesheet falls.
Date (format: dd/mm/yyyy)
Timesheet Week Starting Date
Date on which the week starting date of a timesheet falls.
| Numeric (maximum 38,6) | |
Bill Rate | The rate that is changed to the client for the manual item.
| Numeric (maximum 38,6) |
Project Code | If the timesheet’s related job order is set to enforce project code, then a valid project code is required. | Alphanumeric (maximum 50) |