The Qld Payment History Import relies upon a file provided from DETConnect. The format of this file can change, depending on the contract type (QS, PS or CSQ).
For QS contracts, (Cert III Guarantee, Higher Level Skills) the payment file will be emailed to you each month.
The file provided is a full year to date payment file, as such it is necessary to 'roll-back' the previous import in VETtrak, to ensure that payment records are not doubled up.
VETtrak will only use some of the columns from the file, as detailed below. The data for these columns must begin in Row 2 of the file (allowing for column headings in Row 1).
| (column) | (data) | (VETtrak Column) |
| A | RTO_ID | |
| B | RTO | |
| C | Contract_No | Purchasing |
| D | RFO | |
| E | TS_Number | |
| F | Training_Catalog_Item | |
| G | Course_Training_Package_Code | Qualification |
| H | Course_Training_Package_Desc | |
| I | LLN | |
| J | Comp_Point | |
| K | Course_Training_Package_Count | |
| L | TS_Value | |
| M | Submission_No | |
| N | Submission_Date | |
| O | Submission_Time | |
| P | Family_Name | Client |
| Q | First_Name | Client |
| R | Client_Identifier | Client Code |
| S | Student_Count | |
| T | Competency_No | Unit |
| U | Enrol_Start_Date | |
| V | Enrol_End_Date | |
| W | Delivery | |
| X | Outcome | |
| Y | Postcode | |
| Z | Result_Desc | |
| AA | Calculated_Claim | Amount |
| AB | Points | |
| AC | Incomplete_Value | |
| AD | Payable_Outcome | |
| AE | Counted_Outcome | |
| AF | VPC_Comp | |
| AG | Student_Pay | |
| AH | TS_Pay | |