The table below lists and describes the FastTrack timesheet fields that can be mapped to column headers in a timesheet import file. These field are available for selection in the Map To Field column on the Import Settings screen when creating a Timesheet Import batch. For each field, the table identifies the data type that is required by the field.
...
Field Name
...
Description
...
Data Type
...
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)
...
Attendance Type
...
Identifies if a timesheet item is an attendance or absence. Must be set to attendance or absence.
...
The table below lists and describes the FastTrack timesheet fields that can be mapped to column headers in a timesheet import file. These field are available for selection in the Map To Field column on the Import Settings screen when creating a Timesheet Import batch. For each field, the table identifies the data type that is required by the field. Items in red are availailable for mapping from V12.17 to support import of Reimbursements, Absences and Adjustment Timesheets.
Field Name | Description | Data Type | |||||
---|---|---|---|---|---|---|---|
Attendance / Absence 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 / Absence 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) | |||||
Adjustment Reason | Map to an Adjustment Reason where the timesheet to be imported is an Adjustment Timesheet (Adjustment Reason is mandatory for Adjustment Timesheets). This is used where the file contains different Adjustment Reasons for individual adjustment timesheets. If the Adjustment Timesheets all require the same reason, select the Create Timesheet Import Batch wizard Default Adjustment Reason and do not include this item in the import file. | Alphanumeric (maximum 40 characters) | |||||
Adjustment Reason Import Code | Map to an Adjustment Reason Import Code where the timesheet to be imported is an Adjustment Timesheet (Adjustment Reason is mandatory for Adjustment Timesheets). This is used where the file contains different Adjustment Reasons for individual adjustment timesheets. If the Adjustment Timesheets all require the same reason, select the Create Timesheet Import Batch wizard Default Adjustment Reason and do not include this item in the import file. | Alphanumeric (maximum 50 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 3rd 5th shift on a given date. | Time (format: hh:mm) | |||||
Break Start 46 | Specifies the unpaid break start time for the 4th 6th shift on a given date. | Time (format: hh:mm) | |||||
Break Start 57 | Specifies the unpaid break start time for the 5th 7th shift on a given date. | Time (format: hh:mm) | |||||
Break Start 68 | Specifies the unpaid break start time for the 6th 8th shift on a given date. | Time (format: hh:mm) | |||||
Break Start 79 | Specifies the unpaid break start time for the 7th 9th shift on a given date. | Time (format: hh:mm) | |||||
Break Start 810 | Specifies the unpaid break start time for the 8th 10th 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. | Time (format: hh:mm) | |||||
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 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 Full Name (formatted CandidateFirstname CandidateSurname) | Full name of a candidate in the format <first name> <surname>. For example: John Smith
| Alphanumeric (maximum 101 characters) | |||||
Candidate Full Name (formatted CandidateSurname CandidateFirstname CandidateSurname) | Full name of a candidate in the format <surname> <first name> <surname>. For example: Smith John Smith
| Alphanumeric (maximum 101 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 IDID | Number that uniquely identifies a candidate, as configured on a candidate record in Recruitment Manager. | Integer (9 characters exactly) | ||
Candidate Surname | Family name of a candidate, as configured on a 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 in the client record properties in Recruitment Manager. | Alphanumeric (maximum 50 characters) | |||||
Client No | Number that uniquely identifies a candidateclient, as configured on defined in a candidate 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. | Alphanumeric (maximum 50 characters) | |||||
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) | |||||
Client No | 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 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 as defined in on a Cost Centre record in Recruitment Manager.
| Alphanumeric (maximum 50 characters) | |||||
Cost Centre NameName of No. | System-generated, nine-digit number that uniquely identifies 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 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 1st 6th shift on a given date. | Time (format: hh:mm) | |||||
End Time 27 | Specifies the end time of the 2nd 7th shift on a given date. | Time (format: hh:mm) | |||||
End Time 38 | Specifies the end time of the 3rd 8th shift on a given date. | Time (format: hh:mm) | |||||
End Time 49 | Specifies the end time of the 4th 9th shift on a given date. | Time (format: hh:mm) | |||||
End Time 510 | Specifies the end time of the 5th shift on a given date.Time 10th shift on a given date. | Time (format: hh:mm) | |||||
Item Date | Date on which a timesheet item occurred. | Date (format: hh:dd/mm/yyyy) | |||||
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. | 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 ManagerJob 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) | |||||
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. Note that this field needs to be used to identify additional items rather than the Pay Code Name field if the Manual Item field in Agency Portal > Settings > Maintenance > Time & Attendance > Timesheet Import is set to Import Code instead of Pay Code Name. | 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 if the Manual Item field in Agency Portal > Settings > Maintenance > Time & Attendance > Timesheet Import is set to Name instead of Import Code. | Alphanumeric (maximum 50 characters) | |||||
Pay Rate | Rate of payment that applies to an additional (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 | Project Code | Specifies the project code against which the 1st shift on a given date is allocated. | |||||
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 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. Note that this field needs to be used to identify additional items rather than the Pay Code Name field if the Manual Item field in Agency Portal > Settings > Maintenance > Time & Attendance > Timesheet Import is set to Import Code instead of Pay Code Name. | 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 if the Manual Item field in Agency Portal > Settings > Maintenance > Time & Attendance > Timesheet Import is set to Name instead of Import Code. | Alphanumeric (maximum 50 characters) | |||||
Pay Rate | Rate of payment that applies to an additional (manual) timesheet item. | Numeric | |||||
Unique code that identifies a specific project against which a timesheet item 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 50 20 characters) | |||||
Project Code 15 | Specifies the project code against which the 1st 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 26 | Specifies the project code against which the 2nd 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 37 | Specifies the project code against which the 3rd 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 48 | Specifies the project code against which the 4th 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 59 | Specifies the project code against which the 5th 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 610 | Specifies the project code against which the 6th 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 orderof the project codes configured on the job order. | Alphanumeric (maximum 20 characters) | |||||
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 20 characters) | Project Code 7 | Specifies the project code against which the 7th 50 characters) | |||
Quantity | Quantity that applies to an additional (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 | Project Code 8 | Specifies the start time of 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) | Specifies the project code against which the 8th . | 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 | Project Code 9 | Specifies the start time of 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) | Specifies the project code against which the 9th . | 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 | Project Code 10 | Specifies the start time of 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) | Specifies the project code against which the 10th . | Time (format: hh:mm) | ||
Start Time 7 | Specifies the start time of 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) | |||||
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) | |||||
Quantity | Quantity that applies to an additional (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. | 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. | Date (format: dd/mm/yyyy) | |||||
Reimbursement Item Name | Specifies the Reimbursement Item where they are to be included with the timesheet import. Must include this item OR Reimbursement Import Code. Note for the Date, the existing ‘Item Date’ mapping item is used. | Alphanumeric (maximum 255 characters) | |||||
Reimbursement Import Code | Specifies the Reimbursement Item where reimbursements are included with the timesheet import. Must include this item OR Reimbursement Item Name where a Reimbursement is to be imported in the timesheet. | Alphanumeric (maximum 50 characters) | |||||
Net | Specifies the Reimbursement Net value where reimbursements are included with the timesheet import. Must include this item where a Reimbursement is to be imported in the timesheet where Currency Code and Currency Value do not apply. | Numeric | |||||
Tax | Specifies the Reimbursement Tax value where reimbursements are be included with the timesheet import. Must include this item where a Reimbursement is to be imported in the timesheet where Currency Code and Currency Value do not apply. Must be zero if not applicable. | Numeric | |||||
Currency Code | Specifies the Currency required where Currency Conversion has been configured in the environment, and the Reimbursement Item value needs to include the Currency Code that it needs to be converted to in the payroll process. Where Currency is required, Currency Code and Currency Value are required. Net an Tax values are not required. | Alphanumeric (3 characters) | |||||
Currency Value | Specifies the Currency value where Currency Conversion has been configured in the environment, and the Reimbursement Item value needs to include the Currency Value that needs to be converted in the payroll process. Where Currency is required, Currency Code and Currency Value are required. Net an Tax values are not required. | Numeric | |||||
Reimbursement Project Code | Specifies the Project Code where required for the reimbursement item. Where the Project Code is mandatory on a timesheet, this value must be included with any reimbursements. | 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. | Date (format: dd/mm/yyyy)
Info |
---|
Note that for Reimbursement items, in the row the value for Pay Code Name (where mapped) is left blank, as the Reimbursement Item Name is used instead. The Quantity item (where mapped) is also left blank for rows containing Reimbursement items. |