...
New / Updated Map to Fields | Description | Data Format | |||||
TS Alt No | Added to provide the ability to import Imports an alternative timesheet id/number relating to that identifies the corresponding timesheet in the third 3rd party system. | Alphanumeric | |||||
Bill Code Import Code This value is mapped where import data is required to prompt the generation of a new Rate Stet in the related Standard Rate Job. Either Bill Code Import Code or Bill Code Name can be applied. | The following items are mandatory to trigger the generation of a new rate setIdentifies a bill element by mapping to the Import Code on a Bill Code record in FastTrack360. This field or the Bill Code Name field must be mapped if you require a new rate set to be created in the standard rates of the corresponding job order on import.
| Alphanumeric | |||||
Bill Code Name This value is mapped where import data is required to prompt the generation of a new Rate Stet in the related Standard Rate Job. Either Bill Code Import Code or Bill Code Name can be applied. | The following items are mandatory to trigger the generation of a new rate setIdentifies a bill element by mapping it to the name of a bill code as defined on a Bill Code record in FastTrack360. This field or the Bill Code Import Code field must be mapped if you require a new rate set to be created in the standard rates of the corresponding job order on import.
| Alphanumeric | |||||
Bill Rate | This item is displayed below ‘Pay Rate' and is mapped where import data is required to either:
| Numeric |
...
Identifies the bill rate of the corresponding item in the import file. This field must be mapped if either of the following applies:
| Numeric |
Example Import File for Creating New Rate Sets
The example below shows a representation of what must be provided in an import file so that new standard rates rate sets can be generated on job order in FastTrack360. In this example, the Overtime and Reimbursement items are elements do not exist in the Standard Rate Job Order. Mandatory items to generate a new rate set are highlighted in yellowjob rates. Items highlighted in yellow are elements that must be provided in the import if new rate sets are to be created.
Candidate ID | Client No | Job ID | Item Date | Pay Code Name/Pay Code Import Name | Pay Quantity | Pay Rate | Bill Code/Bill Code Import Code | Bill Rate | Reimbursement Item | Reimbursement Net Value | Reimbursement GST/VAT Value | Alt TS Id |
100014020 | 300005146 | 200013720 | 14/06/2021 | Ordinary | 8 |
|
|
|
|
|
| 123456 |
100014020 | 300005146 | 200013720 | 14/06/2021 | Overtime | 2 | 60 | Overtime | 72 |
|
|
| 123456 |
100014020 | 300005146 | 200013720 | 14/06/2021 |
|
|
| Reimbursement | 100 | Reimbursement | 90.91 | 9.09 | 123456 |
For normal rates (not reimbursement) the following mapped values are required:
Pay Code /or Pay Code Import Code
Pay Rate
Bill Code /or Bill Code Import Code
Bill Rate
| Info |
|---|
...
Reimbursement items |
...
can only be |
...
added to a new rate set that is created via this process if the Bill Type is Flat. If you require any other Bill Type to be applied and the rate value to be dependent on this, |
...
such reimbursement rates must be added manually to the standard rates on the corresponding job orders. |
To use import to add Reimbursement items, the following is required:
Reimbursement Item /or Reimbursement Import Code
Net
GST/VAT (if applicable to the reimbursement being claimed, not required for the new rate)
Bill Code /or Bill Code Import Code
Bill Rate (please be aware this value will be applied to the Job’s new Rate Set as a FLAT RATE - if you wish to use the same Reimbursement item for future imports, provide the Bill Rate required for each reimbursement, and this value will be applied in the Interpreter as a superseded rate value)
Import Settings Changes to Support Grouping
To achieve FastTrack360 now supports the ability to bulk import timesheet iterations, for example an . For example, a single import file may contain more than one timesheet can contain the original timesheet and one or more adjustment timesheets for the same job order and week ending date - for example an original and its subsequent adjustment(s), in the . To facilitate this, the Timesheet Import Wizard Import Settings , a new setting is available and will need to be populated. This item, labelled ‘Grouping’, will enable the system to know the import field to targeted to determine the timesheet iteration grouping. now features a Group Field option (see Figure 1 below) which is mandatory if multiple timesheet iterations are to be bulk imported via a single import file. This new option allows you to specify which field in the import file must be used to provide a grouping sequence for matching rows of data in the import file to a unique timesheet in FastTrack360.
In the import file, the Grouping value will need to be assigned to a grouping value must be provided against each data row for the same job and week ending date . Where multiple to inform FastTrack360 of which iteration of a timesheet the row corresponds to. If an original and one or more adjustment timesheets need to be generatedcreated based on the data provided in the import file, the system will use uses the Grouping grouping value to determine the rows required for each timesheet and the order of the timesheets. The ability to sequence the order is very important as each iteration of the timesheet needs to target the timesheet it is adjustingthe system must be able to match each row of data in the import file to the corresponding original timesheet or adjustment timesheet respectively.
| Note |
|---|
Please note that where there is the possibility that the original timesheet and one or more subsequent adjustments could be imported in one file, then the ‘Adjustment Only’ setting must be true enabled in the related Job Ordercorresponding job orders, so that there is a zero-result timesheet already in the system. Click here for more details. |
Grouping Example
In the example below, we have used the new Alternate Timesheet value Alt TS Id (alternative timesheet ID) field as the grouping value, as this is a value that will can be included in each row of data in the import file and will be displayed next to each data row. Where there is data for more than one iteration of a timesheet for the same job and week ending date, the system will use Alt. TS Id to determine each timesheet and the order of each timesheet ie; Adjustment 1, Adjustment 2, based on the order of the group field. We have also mapped this field in the Field Mapping area, as it is a value that is available on the timesheet, which will be helpful if we need to cross check data with the VMS.If your system does not provide a Timesheet Ididentify the correct original or adjustment timesheet to which each row of data corresponds and the sequence of the timesheets (i.e. original, adjustment 1, adjustment 2 etc.). In this example, the Alt. TS Id field has also been mapped in the Field Mappings, thereby allowing the alternative timesheet ID to be saved against the target timesheet in FastTrack360, which may be helpful for cross-checking with timesheets in the 3rd party system.
| Info |
|---|
If the 3rd party system does not provide a unique timesheet ID, you can add a row to your data import and label it ‘Grouping’, then add values to |
...
define the relevant grouping sequence (e.g. 1, 2, 3 etc.). It is important to note that where multiple timesheets for same job and date are required, each row in the import must contain a grouping value. |
| Info |
|---|
The values provided for grouping must be able to be sequenced ie; 1, 2, 3, 4 and must be whole numbers. For example, the system will not be able to sequence 1.2, 1.3, 1.4. Please be aware that if you use alpha numeric numbers to group, the standard sort algorithm places the alpha in order, and then the logic looks at the first number and sorts this first, and then takes the next pass to look for a second number, then orders this etc. As such values like A7, A8, A9, A10, A11 would sort as A10, A11, A7, A8, A9. This would be problematic as the timesheets would be interpreted in the wrong order. If you wish to use alpha numeric, then make sure that the string numbers have the same amount of digits, so the logic will look at the whole number. Using the above example you would supply vales as: A07, A08, A09, A10, A11. |
...
In the data sheet example representation of an import file below, ‘Alt TS No’ was used for Groupingis used as the grouping. There are three iterations of the same timesheet, where the original timesheet is a Zero Result Adjustment Only Timesheet (click here for more details on this strategy). zero result adjustment only timesheet, as follows:
Alt TS No: 4556 - First timesheet is for 8 hrs of Ordinary.
Alt TS No: 4559 - The first adjustment, changes this to 7 hrs of Ordinary 8 hrs was not correct.
Alt TS No: 4563 - In the third iteration, the hours have not changed, however a reimbursement item was missed in the previous iterations.
...