The Qld Payment History Import relies upon a file provided from the funding body. The format of this file can change, depending on the contract type (QS, PS or CSQ).
The file provided is a full financial 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 | tx_bo_number | Purchasing |
| B | am_value | |
| C | nm_party | |
| D | tx_bo_number | |
| E | am_student_places | |
| F | course_cd | Qualification |
| G | course | |
| H | catalog_id | |
| I | id_state | |
| J | id_bo | |
| K | id_bo | |
| L | id_contractor | |
| M | nr_submission | |
| N | d_start | |
| O | d_end | |
| P | no_module | Unit |
| Q | am_totalhoursdelivered | |
| R | am_currenthoursdelivered | |
| S | enrol_start | |
| T | enrol_end | |
| U | cd_deliverystrategy | |
| V | cd_moduleoutcome | |
| W | am_calculatedpayment | Amount |
| X | nm_calculateddesc | |
| Y | no_nominal_hrs | |
| Z | nm_family | Client |
| AA | nm_first | Client |
| AB | nm_othergiven | |
| AC | student_dob | |
| AD | id_student | |
| AE | tx_clientidentifier | Client Code |
| AF | cd_deliverypostcode |