Print Friendly and PDF
Follow

Construction Skills Queensland (CSQ) Payment Import file

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  
Back to Top
    Tags:
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.