Note
For a demonstration on the Government Payment Import Utilities, refer to our Government Import Utilities articleThe Skills Victoria Payment History Import relies upon a file provided from SVTS.
The file required is the Payment History Details report, which can be downloaded from SVTS each month.
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 | Column Title | VETtrak Column | Format |
| A | TOID | ||
| B | Contract ID | Purchasing Contract | Purchasing Contract (Code) |
| C | Client ID | Client Code | String (VETtrak Client Code) |
| D | Client Name | Client Name | String (eg. Surname, FirstName) |
| E | Client ID Apprenticeships | ||
| F | Program ID | Qualification | String (Qualification Code) |
| G | Program Name | ||
| H | Associated Program ID | ||
| I | Program Commencement Date | Commence | Date (dd/mm/yyyy) |
| J | Subject ID | Unit | String (Unit Code) |
| K | Subject Name | ||
| L | Enrolment ID | ||
| M | Claim ID | Unique Identifer (hidden field) | Integer (eg. 5) |
| N | Delivery Location Name | ||
| O | Activity Start Date | ||
| P | Activity End Date | ||
| Q | Outcome ID National | ||
| R | Payment Status | ||
| S | Funding Source Code | Funding | Char/String (eg. P,L) |
| T | Hours Paid | Hours | Integer (eg. 5) |
| U | Total Amount Excl GST | Amount | Double up to 4 decimal places (eg. 20.000) |
| V | Amount Base Payment | ||
| W | Amount Regional Loading | ||
| X | Amount Indigenous Loading | ||
| Y | Amount Youth Loading | ||
| Z | Amount VCE and VPC Loading | ||
| AA | Amount TAFE Loading | ||
| AB | Fee Exemption Concession Type ID Locked | ||
| AC | Amount Fee Concession | ||
| AD | Amount Fee Waiver | ||
| AE | Free TAFE | ||
| AF | Invoice Number | Invoice | String |