Print Friendly and PDF
Follow

Qld Cert III Guarantee (QS) Payment History Import

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

0 Comments

Please sign in to leave a comment.