...
| Info |
|---|
For a full list and description of the fields that can be mapped and the applicable data type of each field, see Mapping Fields. |
Field Mapping Validation
...
Candidate ID or Candidate Alt No or Candidate Full Name or (Candidate Firstname + Candidate Surname)
Manual Item Date or Timesheet Week Ending Date.
Next, Timesheet Import will check if the following fields, which are required to identify attendance items, have been mapped:
Start Time 1
End Time 1
| Info |
|---|
Standard rates timesheets may not have shift start and end times and therefore it is not mandatory to map the Start Time 1 and E nd Time 1 fields. However, if a start time field is mapped, the corresponding end time field must also be mapped. |
If the Start Time 1 and End Time 1 fields have been mapped the system will then check if the following fields have been mapped:
Item Date
Attendance Item Name, Attendance Item Import Code, Pay Code Name or Pay Code Import Code.
If neither Start Time 1 nor End Time 1 fields have been mapped the system will check if all of the following fields have been mapped:
Item Date
Pay Code Name or Pay Code Import Code
Quantity
Fields Required to Identify Additional Shift Start & End Times
If the Start Time 1 and End Time 1 fields have been mapped, the system will check if the Start Time 2 – Start Time 10 fields and the End Time 2 – End Time 10 fields have been mapped. Where any of those fields have been mapped, the system will check that corresponding start/end time field has also been mapped.
For example, if Start Time 2 has been mapped the system must check that End Time 2 has also been mapped. If End Time 10 has been mapped the system must check that Start Time 10 has also been mapped and so on.
Fields Required to Identify Unpaid Breaks
If the Start Time 1 and End Time 1 fields have been mapped, the system will check if any of the Break Start 1 – Break Start 10 and Break End 1 – Break End 10 fields have been mapped. If any one of these fields is mapped, the system will check that the corresponding start/end field has also been mapped.
For example, if Break Start 1 has been mapped the system must check that Break End 1 has also been mapped. If Break End 10 has been mapped the system must check that Break Start 10 has also been mapped and so on.
not checked in the above process, the system will check if the Manual Item Date has been mapped.
Where successful, the system will then check if the following items have been mapped:
Pay Code Import Code OR Pay Code Name
Pay Quantity
Pay Rate AND/OR Reimbursement Net AND Reimbursement GST/VAT Value (the import may include both manual and reimbursement items, or one or the other).
Bill Code Import Code OR Bill Code Name
Bill Quantity
Bill Rate
Data Type Validation
When you attempt to queue a Timesheet Manual Item Import batch for processing the system also checks that the type of data that is provided in each mapped column within the import file matches the data type of FastTrack field to which that column is mapped. For example, if a column header is mapped to a field that must contain a date value, Timesheet Manual Item Import will check that the corresponding column contains dates and not any other type of data. For example if the date is not the correct format a pop up message will display 'Error: Date contains an invalid format type for the field mapping. Required date format is DD/MM/YYYY.’
...