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.
- Locate the file to be imported.
- Click Load data.
- The grid fills with the data in the spreadsheet.
- Click here to drop down a list that allows you to change or rearrange the fields that you see in the wizard.
- 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.
- Tick the rows you want to import, or tick the Use heading to tick all boxes. Only green or yellow rows can be ticked.
- 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) |
A | Activity Period | |
B | Reference ID | Commitment ID |
C | Surname | Surname |
D | First Name | First name |
E | Other Name | |
F | Gender | |
G | Date Of Birth | DOB |
H | Enquiry Date | |
I | Notified Date | Notified date |
J | Expiry | Expiry |
K | Planned Start | Start date |
L | Planned End | |
M | Cancelled Date | Cancelled date |
N | Status | Status |
O | Code | Qual code |
P | PAS No. | |
Q | Name | |
R | Program | |
S | Region | |
T | Student Fee | Student Fee |
U | Subsidy | Subsidy |
V | Standard Subsidy | |
W | Needs Loading | Needs Loading |
X | Location Loading | Location Loading |
Y | CT/RPL Entered | |
Z | National Provider ID | |
AA | Provider Student ID | |
AB | Bulk Upload File Name | |
AC | Fee/Waiver Code | |
AD | USI Validation Status | |
AE | USI Invalid Message |