The NSW Payment History Import relies upon a file provided from State Training Services.
The file required is exported from STS, after doing an eReport Payment Search.
VETtrak uses all of the columns from the file, however the order they are read in is slightly different. 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 | Invoice No | Invoice No |
B | Invoice Date | Invoice Date |
C | TC ID | TC ID |
D | Payment Instalment | Payment Installment |
E | CID | Commitment ID |
F | Surname | Surname |
G | First Name | Given Name |
H | Amt Payable | Amount |
I | PV ID | PV ID |
J | PV Approval Date | PV Approval Date |