NSW - Provider Calculator Results Import

You can import the Commitment ID information from the spreadsheet file that the government sends to you by going to Utility > NSW claims > Provider calculator results import.

  1. Locate the file to be imported.
  2. Click Load data.
  3. The grid fills with the data in the spreadsheet.
  4. Click here to drop down a list that allows you to change or rearrange the fields that you see in the wizard.
  5. The Status column will be coloured as follows:
    • Green - The client has been matched and all data is correct. This record can be imported.
    • Yellow - The client has been matched but some details are different. This record can be imported but you should check to ensure that the data is for the correct person.
    • Red - This row has not been matched, and cannot be imported.

      Click a coloured box for more information about the error or warning.

  6. Tick the rows you want to import, or tick the Use heading to tick all boxes. Only green or yellow rows can be ticked.
  7. Click Save data.

This process will save the Commitment ID information against the relevant enrolments in VETtrak.

 

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)
AActivity Period 
BReference IDCommitment ID
CSurnameSurname
DFirst NameFirst name
EOther Name 
FGender 
GDate Of BirthDOB
HEnquiry Date 
INotified DateNotified date
JExpiryExpiry
KPlanned StartStart date
LPlanned End 
MCancelled DateCancelled date
NStatusStatus
OCodeQual code
PPAS No. 
QName 
RProgram 
SRegion 
TStudent FeeStudent Fee
USubsidySubsidy
VStandard Subsidy 
WNeeds LoadingNeeds Loading
XLocation LoadingLocation Loading
YCT/RPL Entered 
ZNational Provider ID 
AAProvider Student ID 
ABBulk Upload File Name 
ACFee/Waiver Code 
ADUSI Validation Status 
AEUSI Invalid Message 

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.
×