Print Friendly and PDF
Follow

VETtrak Business Intelligence User Guide

Table of Contents:

Connecting to Business Intelligence.

 

Working with Pivot Tables.

 

Measures.

 

Dimensions.

 

1.    Introduction

This user guide on the VETtrak Business Intelligence add-on contains information on getting users started on writing powerful analytical reports through the Microsoft Excel pivot table interface. It will provide a detailed reference guide to help you understand how the data is sourced from your VETtrak database.

 

2.    Connecting to Business Intelligence

VETtrak recommends that you use Microsoft Excel version 2013 or 2016 on a Windows computer to connect to your Business Intelligence data cube. Older versions of Excel do work, but you will need to install a special ODBC connector, see section 2.5 for install instructions.

Excel on Apple Macs, iOS or Android do not have the capability to connect to a Microsoft SQL Server Analysis cube.

2.1             Microsoft Excel data connections

If you have a local install of VETtrak and the Business Intelligence tool, you will need to create a connection to your Analysis Services cube from a new Excel spreadsheet. The administrator who setup the VETtrak Business Intelligence tool should supply you with a server, database name and credential details to connect to.

  1. Open Microsoft Excel and create a new spreadsheet. You can also add a VETtrak Business Intelligence pivot table to an existing spreadsheet if you wish.
  2. Go to the “Data” ribbon in Excel
  3. Click “From Other Sources”, select “From Analysis Service”
  4. Enter the Server name your administrator has provided you
  5. Log on will normally be “Use Windows Authentication”
  6. Select the database name your administrator has provided you
  7. Click Finish to create the pivot table

2.2             Hosted Customer connections

If you have a hosted install of VETtrak, you will be provided with an ODC connection file. Simply save this connection file somewhere safe, and open it with Microsoft Excel (double click will normally automatically open it with Microsoft Excel). You will be prompted for a password which you should have been provided with.

Ensure you keep the ODC connection file and password safe. Your data is accessible anywhere on the internet with this. If you think your password has fallen into the wrong hands (eg. stolen laptop) or a staff member has left, please let us know and we can generate a new password for you.

2.3             Managing connections

Once you have created your connection, you can make as many copies of the pivot table or spreadsheet. Each one can have different data and be refreshed whenever you want by clicking the “Refresh All” button on the Data ribbon.

2.4             Non-Excel client connections

There are many other software clients available that can perform MDX queries against a SQL Server Analysis Services cube. This may be required if you have a Mac version of Excel or you need more powerful control of your MDX queries than Excel can give you. VETtrak has not had any experience with any other software clients other than Excel for connecting to a SQL Server Analysis Services cube. This guide assumes that you will be using Microsoft Excel as your software client.

2.5             Excel versions prior to Excel 2013

If you try to connect to an Analysis Services cube using an Excel version prior to Excel 2013, you won’t have the OLEDB connector required to access the cube. You will get an error such as this:

 

To download the OLEDB connector, follow these steps:

  • Go to http://www.microsoft.com/en-au/download/details.aspx?id=42295
  • Click the big "Download" button
  • Scroll through the list and tick the box next to "ENU\x86\SQL_AS_OLEDB.msi" feature and click Next
  • The requested file will download, when it is complete run the file to install the tool

 

3.    Working with Pivot Tables

An Analysis Services cube is made up of “Measures” and “Dimensions”. Measures are things that you count, and Dimensions are the things to control the way you display/slice/dice or filter your measures.

3.1             Values, Rows, Columns and Filters

The layout of pivot tables is controlled with a grid of Values, Rows, Columns and Filters that is in the bottom right corner of Excel and looks like this:

3.1.1        Values

The Values part of the grid is the main content of the table, and will contain things that you count or the “Measures” of the cube. For example, a count of total Enrolments would be a measure that you could drag into the Values part of the grid. You can have more than one measure in the Values section, but normally one measure is a cleaner way of looking at your data.

A pivot table needs to have at least one measure in the Values section. If you don’t include a measure, the dimensions will behave somewhat randomly because they will still try to use a measure to determine the context to display themselves. The default is to use the first measure that is mapped in the cube, which will give you unpredictable results.

3.1.2        Rows and Columns

Drag your dimensions into either the Rows or Columns section of grid. For example, you might want to have a Qualification dimension in your rows, and Enrolment Start Date dimension in your columns. With a count of total Enrolments in the Values grid, you now have the start of a useful report.

Often you will have many dimensions in your Rows or Columns. Things to note:

  1. The order is very important
  2. Think about whether you want the dimension in Rows or Columns. Putting everything in Rows can be hard to read the report.
  3. Some dimensions will cause your report to refresh slowly. Ensure you have a filter in place so you don’t return a million rows. The cube is a powerful piece of technology and will do what you ask it, even if it will take a long time to transfer the data to your computer and display it in Excel.

The “Values” can either be displayed in Rows or Columns. By default, Values are displayed in Columns, but you can drag Values over to Rows to see a different layout.

3.1.3        Filters

An important part of any report is to apply filters. Drag as many dimensions as you would like into Filters and choose the data you would like to filter on. In our Enrolment report example, you may wish to only see Enrolments for Male students and Enrolments that have an Active status. This is where the true power of Business Intelligence shines, you can add or remove dimensions to the filter with a simple drag of your mouse. Maybe you want to now add another filter for Geographic Location, or Trainer Name, or Employer, or even Student Disabilities.

 

4.    Measures

Measures appear at the top right of Excel and are grouped into 3 sections:

  • Course Measures
  • Finance Measures
  • Student Measures

4.1 Course Measures

Course Measures are split into 3 subfolders:

  • Enrolment Measures: contain measures for your standard VETtrak enrolments, units, training contracts and contacts
  • Programme Measures: contain measures for occurrences, classes and waitlists
  • VET FEE Help Measures: contain measures for a special type of enrolment for VET FEE Help students

4.1.1        Enrolment Measures

Course Enrolments

Count of total student enrolments

  • Sourced from ENROLMENT table
  • Excludes occurrence records (WHERE CLIE_ID IS NOT NULL)

Enrolment Activities

An “Enrolment Activity” is a special Business Intelligence term used to count all of the following into a single measure:

  • Unit results (all changes to a single enrolled unit result is counted)
  • Classroom attendances
  • Events
  • Tasks
  • Contacts

 

The purpose of including these different activities into the one measure is to allow the creation of auditing reports where you want to make sure an enrolled student is getting frequent activity recorded against them that is appropriate in terms of Trainer contact with the Student. Each RTO would have a different definition of what appropriate activity looks like and this measure is designed with maximum flexibility so you can filter your dimensions to match how you use VETtrak to record Trainer contact with the student.

 

  • Unit results are sourced from ENUNHIST
  • Classroom attendance is sourced from ATTENDANCE
  • Events are sourced from CLIEEVEN
  • Tasks are sourced from TASKENRO
  • Contacts are sourced from ENROLMENTCONTACT

Enrolment Activities Max Date

This is the same as the Enrolment Activities measure except it returns the maximum date instead of a count of the records. This is useful if you want to report on when a particular student had contact with a trainer based on the way your RTO defines appropriate recorded contact.

Enrolment Contact

Count of total enrolment contacts recorded in the Contact Record Wizard in VETtrak

  • Sourced from ENROLMENTCONTACT table

Enrolment Hours

Sum of Unit hours for each enrolled unit

  • Sourced from ENROUNIT table
  • Uses ENUN_HOURS for non-withdrawn units
  • Uses ENUN_WD_HOURS for withdrawn units

Enrolment Tasks

Count of total tasks that belong to enrolments

  • Sourced from TASKENRO table

Students

Distinct count of clients that have enrolments

  • Sourced from ENROLMENT table

Training Contracts

Count of total Training Contracts

  • Sourced from CONTRACT table

Unit Enrolments

Count of total enrolled units

  • Sourced from ENROUNIT table

 

4.1.2        Programme Measures

Class Attendances

Count of total student attendances (of any status including not present)

  • Sourced from ATTENDANCE

Class Attendances Present

Sum of classes student attended

  • Sourced from ATTENDANCE
  • Sum of ATTY_TYPE (1 for present, 0 for not present, and -1 for an attendance reversal)

Classes

Count of total classes run

  • Sourced from INSTANCE

Occurrences

Count of total occurrences and bookings

  • Sourced from ENROLMENT
  • Excludes enrolments (WHERE CLIE_ID IS NULL)

Waitlist

Count of total waitlisted expressions of interest in a programme

  • Sourced from PROGCLIE

 

4.1.3        VET FEE Help Measures

VFH Amount Charged

Sum of amount charged for VET FEE Help enrolments

  • Sourced from VETFEEHELP

VFH Enrolments

Count of total VET FEE Help enrolments

  • Sourced from VETFEEHELP

VFH Loan Fee

Sum of loan fee amount for VET FEE Help enrolments

  • Sourced from VETFEEHELP

VFH Paid Upfront

Sum of amount paid upfront for VET FEE Help enrolments

  • Sourced from VETFEEHELP

 

4.2     Finance Measures

Finance measures are split into 3 subfolders;

  • Expense Measures: contain cost measures recorded for occurrences
  • Forecast Measures: contain forecasting measures for government contributions, or fee for service income
  • Income Measures: contain historical income measures for invoices, government contributions, holding account and actual disbursement payments recorded.

4.2.1        Expense Measures

Occurrence Cost Amount

Sum of actual amount of occurrence costs (excluding GST)

  • Sourced from ENROCOST

Occurrence Cost Budget Amount

Sum of budgeted amount of occurrence costs (excluding GST)

  • Sourced from ENROCOST

Occurrence Cost Budget Amount GST

Sum of budgeted amount of occurrence costs (GST portion only)

  • Sourced from ENROCOST

Occurrence Cost GST

Sum of actual amount of occurrence costs (GST portion only)

  • Sourced from ENROCOST

 

4.2.2        Forecast Measures

Forecast Funded Amount

The Forecast Funded Amount measure is a special calculation performed in the Business Intelligence tool that attempts to give you an accurate view of your forecasted income based on your VETtrak data and the way we believe government contributions are calculated for various states and territories.

 

VET FEE Help / VET Student Loan

Each VET FEE Help unit of study has a census date. The amount for that unit of study is forecasted for the month the census date falls on.

  • Sourced from VETFEEUNIT
  • Sum of VEUN_384A_AMOUNT_CHARGED

 

Victoria VTG Funding

VTG Funding is calculated on the hours for each enrolled unit.

  • Enrolment must be in Victoria
  • Any hours already paid are not used in the forecast calculation
  • Remaining unpaid hours are spread evenly between the months spanning the start and end of the unit
  • If some hours have already been paid for a unit, the remaining unpaid hours are instead spread evenly between the months spanning from the last payment to the end of the unit
  • A unit that doesn’t have either a forecasted or actual start date or a forecasted or actual end date cannot be included in the forecast.
  • An actual start date will be used in preference to a forecasted unit start date. Same logic applies to end dates.
  • Only units that are linked to an enrolment that has a funding model attached will be included in the forecast calculation. The attached funding model must have a “Government Contribution” item with a rate type of “$ per hour”

 

Queensland Funding

Queensland funding is paid at the completion of each unit.

  • The amount for each qualification should be set in the Qualification/Course wizard.
  • The forecasting calculation allocates an equal amount for each unit in the enrolment and applies it to the forecasted month for the unit to end. Actual end is preferred over planned end date.
  • Any unit without a forecasted or actual end date will be excluded from the forecasting calculation

 

 

Forecast Funded Hours

Forecasting calculation similar to Forecast Funded Amount, but only for hours in Victoria. This measure is useful for forecasting funding in Victoria where you don’t have a funding model linked to all your Victorian enrolments. You will need to manually multiply the number of forecasted hours by the “$ per hour” for each qualification.

Forecast Funded Students

 

 

4.2.3        Income Measures

Funded Payment Hours

Sum of government paid hours

  • Sourced from ENUNPAYMHIST

Holding Transfer Amount

Sum of amount in holding account

  • Sourced from HOLDING

Invoiced Amount

Sum of amount invoiced

  • Sourced from ENROPRIC/INVOICEITEM

Payment Amount

Sum of payments received for invoices and government contributions

  • Sourced from DISBURSE AND ENUNPAYMHIST

Scheduled Invoice Amount

Sum of the amount scheduled to be invoiced in the future (not yet invoiced)

  • Sourced from ENROPRIC/INVOICEITEM

 

 

4.3     Student Measures

Student Measures are for any data that sits outside an enrolment and is assigned directly to a student. There are 2 sub folders:

  • Event Measures
  • Placement Measures

Attributes

Count of student/employer attributes

  • Sourced from CLIEATTR and EMPLATTR

Student Award or Statement

Count of student awards and statements

  • Sourced from QUALCLIE

 

4.3.1        Event Measures

Event Participants

Count of event participants

  • Sourced from CLIEEVEN

Events

Count of events with participants

  • Sourced from CLIEEVEN (Distinct count of EVEN_ID)

 

4.3.2        Placement Measures

Student Placement Charge

Sum of placement amount charged

  • Sourced from PLACEMENT

Student Placement Count

Count of placements

  • Sourced from PLACEMENT

Student Placement Hours

Sum of placement hours

  • Sourced from PLACEMENT

Student Wage

Sum of student placement wages

  • Sourced from PLACEMENT

 

5.    Dimensions

5.1       Attendance Dimension

The measures below in (*) black are mapped to the Attendance dimension, those in grey are not mapped.

Course Measures

  • Enrolment Measures
    • Course Enrolments
    • (*) Enrolment Activities
    • (*) Enrolment Activities Max Date
    • Enrolment Contact
    • Enrolment Hours
    • Enrolment Tasks
    • Students
    • Training Contracts
    • Unit Enrolments
  • Programme Measures
    • (*) Class Attendances
    • (*) Class Attendances Present
    • Classes
    • Occurrences
    • Waitlist
  • VET FEE Help Measures
    • VFH Amount Charged
    • VFH Enrolments
    • VFH Loan Fee
    • VFH Paid Upfront

Finance Measures

  • Expense Measures
    • Occurrence Cost Amount
    • Occurrence Cost Budget Amount
    • Occurrence Cost Budget Amount GST
    • Occurrence Cost GST
  • Forecast Measures
    • Funded Forecast Amount
    • Funded Forecast Hours
  • Income Measures
    • Funded Payment Hours
    • Holding Transfer Amount
    • Invoiced Amount
    • Payment Amount
    • Scheduled Invoice Amount

Student Measures

  • Attributes
  • Student Award or Statement
  • Event Measures
    • Event Participants
    • Events
  • Placement Measures
    • Student Placement Charge
    • Student Placement Count
    • Student Placement Hours
    • Student Wage

 

Finish Date CYH

Date of when the attendance record finished in Calendar Year Hierarchy form

Finish Date FYH

Date of when the attendance record finished in Financial Year Hierarchy form

Start Date CYH

Date of when the attendance record started in Calendar Year Hierarchy form

Start Date FYH

Date of when the attendance record started in Financial Year Hierarchy form

Attendance Inserted By

First name and last name for VETtrak user who created the attendance record

Attendance Last Updated By

First name and last name for VETtrak user who last updated the attendance record

Attendance Type

Attendance Types can be setup in VETtrak configuration manager (defaults are Present, Sick and Absent)

Finish Date Full

The full date for the finish date for this attendance record

Start Date Full

The full date for the start date for this attendance record

 

5.2       Attribute Dimension

The measures below in (*) black are mapped to the Attribute dimension, those in grey are not mapped.

Course Measures

  • Enrolment Measures
    • Course Enrolments
    • Enrolment Activities
    • Enrolment Activities Max Date
    • Enrolment Contact
    • Enrolment Hours
    • Enrolment Tasks
    • Students
    • Training Contracts
    • Unit Enrolments
  • Programme Measures
    • Class Attendances
    • Class Attendances Present
    • Classes
    • Occurrences
    • Waitlist
  • VET FEE Help Measures
    • VFH Amount Charged
    • VFH Enrolments
    • VFH Loan Fee
    • VFH Paid Upfront

Finance Measures

  • Expense Measures
    • Occurrence Cost Amount
    • Occurrence Cost Budget Amount
    • Occurrence Cost Budget Amount GST
    • Occurrence Cost GST
  • Forecast Measures
    • Funded Forecast Amount
    • Funded Forecast Hours
  • Income Measures
    • Funded Payment Hours
    • Holding Transfer Amount
    • Invoiced Amount
    • Payment Amount
    • Scheduled Invoice Amount

Student Measures

  • (*) Attributes
  • Student Award or Statement
  • Event Measures
    • Event Participants
    • Events
  • Placement Measures
    • Student Placement Charge
    • Student Placement Count
    • Student Placement Hours
    • Student Wage

Entry Date CYH

Date of when this attribute record was entered in Calendar Year Hierarchy form

Entry Date FYH

Date of when this attribute record was entered in Financial Year Hierarchy form

Attribute Active

Attributes can set to active or inactive in the VETtrak configuration manager

Attribute Assigned By

First name and last name for VETtrak user who assigned the attribute record

Attribute Code

Attribute code as set in the VETtrak configuration manager

Attribute Name

Attribute name as set in the VETtrak configuration manager

Attribute Type

Attribute type is either “Client” for client assigned attributes, or “Employer” for employer assigned attributes

Entry Date Full

Full date of when this attribute record was entered

 

5.3       Award or Statement Dimension

The measures below in (*) black are mapped to the Award or Statement dimension, those in grey are not mapped.

Course Measures

  • Enrolment Measures
    • Course Enrolments
    • Enrolment Activities
    • Enrolment Activities Max Date
    • Enrolment Contact
    • Enrolment Hours
    • Enrolment Tasks
    • Students
    • Training Contracts
    • Unit Enrolments
  • Programme Measures
    • Class Attendances
    • Class Attendances Present
    • Classes
    • Occurrences
    • Waitlist
  • VET FEE Help Measures
    • VFH Amount Charged
    • VFH Enrolments
    • VFH Loan Fee
    • VFH Paid Upfront

Finance Measures

  • Expense Measures
    • Occurrence Cost Amount
    • Occurrence Cost Budget Amount
    • Occurrence Cost Budget Amount GST
    • Occurrence Cost GST
  • Forecast Measures
    • Funded Forecast Amount
    • Funded Forecast Hours
  • Income Measures
    • Funded Payment Hours
    • Holding Transfer Amount
    • Invoiced Amount
    • Payment Amount
    • Scheduled Invoice Amount

Student Measures

  • Attributes
  • (*) Student Award or Statement
  • Event Measures
    • Event Participants
    • Events
  • Placement Measures
    • Student Placement Charge
    • Student Placement Count
    • Student Placement Hours
    • Student Wage

Award Date CYH

Date of when this award was entered in Calendar Year Hierarchy form

Award Date FYH

Date of when this award was entered in Financial Year Hierarchy form

Award Certificate Number

The Certificate number recorded in the Parchment field of the Award Wizard or Record Awards Manager.

Award Date Full

Full date for the award

Award Issued

Possible values: “Award Issued” or “Award Not Issued”

Award Issued By

First name and last name for VETtrak user who issued the award

Award Last Updated By

Attribute type is either “Client” for client assigned attributes, or “Employer” for employer assigned attributes

Award License Expiry

Full date of the award license expiry

Award Reportable

Possible values: “State Reportable”, “Not Reportable” or “Nationally Reportable”

Award Type

Possible values: “Certificate”, “Statement” or “Other”

Award Type Name

Award type name as set in the VETtrak configuration manager

 

5.4       Class Dimension

The measures below in (*) black are mapped to the Class dimension, those in grey are not mapped.

Course Measures

  • Enrolment Measures
    • Course Enrolments
    • Enrolment Activities
    • Enrolment Activities Max Date
    • Enrolment Contact
    • Enrolment Hours
    • Enrolment Tasks
    • Students
    • Training Contracts
    • Unit Enrolments
  • Programme Measures
    • (*) Class Attendances
    • (*) Class Attendances Present
    • (*) Classes
    • Occurrences
    • Waitlist
  • VET FEE Help Measures
    • VFH Amount Charged
    • VFH Enrolments
    • VFH Loan Fee
    • VFH Paid Upfront

Finance Measures

  • Expense Measures
    • Occurrence Cost Amount
    • Occurrence Cost Budget Amount
    • Occurrence Cost Budget Amount GST
    • Occurrence Cost GST
  • Forecast Measures
    • Funded Forecast Amount
    • Funded Forecast Hours
  • Income Measures
    • Funded Payment Hours
    • Holding Transfer Amount
    • Invoiced Amount
    • Payment Amount
    • Scheduled Invoice Amount

Student Measures

  • Attributes
  • Student Award or Statement
  • Event Measures
    • Event Participants
    • Events
  • Placement Measures
    • Student Placement Charge
    • Student Placement Count
    • Student Placement Hours
    • Student Wage

Class Finish Date CYH

Date of the class finish in Calendar Year Hierarchy form

Class Finish Date FYH

Date of the class finish in Financial Year Hierarchy form

Class Start Date CYH

Date of the class start in Calendar Year Hierarchy form

Class Start Date FYH

Date of the class start in Financial Year Hierarchy form

Class Code

Class code as entered into the Class Wizard in VETtrak

Class Staff Member

First name and last name for the staff member assigned to this class

Finish Date Full

Full date for the class finish

Room Code

Room code as entered into the Room Wizard in VETtrak

Room Name

Room name as entered into the Room Wizard in VETtrak

Start Date Full

Full date for the class start

 

5.5       Contact Dimension

The measures below in (*) black are mapped to the Contact dimension, those in grey are not mapped.

Course Measures

  • Enrolment Measures
    • Course Enrolments
    • (*) Enrolment Activities
    • (*) Enrolment Activities Max Date
    • (*) Enrolment Contact
    • Enrolment Hours
    • Enrolment Tasks
    • Students
    • Training Contracts
    • Unit Enrolments
  • Programme Measures
    • Class Attendances
    • Class Attendances Present
    • Classes
    • Occurrences
    • Waitlist
  • VET FEE Help Measures
    • VFH Amount Charged
    • VFH Enrolments
    • VFH Loan Fee
    • VFH Paid Upfront

Finance Measures

  • Expense Measures
    • Occurrence Cost Amount
    • Occurrence Cost Budget Amount
    • Occurrence Cost Budget Amount GST
    • Occurrence Cost GST
  • Forecast Measures
    • Funded Forecast Amount
    • Funded Forecast Hours
  • Income Measures
    • Funded Payment Hours
    • Holding Transfer Amount
    • Invoiced Amount
    • Payment Amount
    • Scheduled Invoice Amount

Student Measures

  • Attributes
  • Student Award or Statement
  • Event Measures
    • Event Participants
    • Events
  • Placement Measures
    • Student Placement Charge
    • Student Placement Count
    • Student Placement Hours
    • Student Wage

Enrolment Contact Date CYH

Date of the enrolment contact in Calendar Year Hierarchy form

Enrolment Contact Date FYH

Date of the enrolment contact in Financial Year Hierarchy form

Contact Type Active

Possible values: “Active” or “Not Active”

Contact Type Name

Contact type name as entered into the Contact Type Wizard in VETtrak

Enrolment Contact Date Full

Full date of the enrolment contact

 

5.6       Contract Staff Dimension

The measures below in (*) black are mapped to the Contract Staff dimension, those in grey are not mapped.

Course Measures

  • Enrolment Measures
    • (*) Course Enrolments
    • (*) Enrolment Activities
    • (*) Enrolment Activities Max Date
    • (*) Enrolment Contact
    • (*) Enrolment Hours
    • (*) Enrolment Tasks
    • (*) Students
    • (*) Training Contracts
    • (*) Unit Enrolments
  • Programme Measures
    • Class Attendances
    • Class Attendances Present
    • Classes
    • Occurrences
    • Waitlist
  • VET FEE Help Measures
    • VFH Amount Charged
    • VFH Enrolments
    • VFH Loan Fee
    • VFH Paid Upfront

Finance Measures

  • Expense Measures
    • Occurrence Cost Amount
    • Occurrence Cost Budget Amount
    • Occurrence Cost Budget Amount GST
    • Occurrence Cost GST
  • Forecast Measures
    • (*) Funded Forecast Amount
    • (*) Funded Forecast Hours
  • Income Measures
    • Funded Payment Hours
    • Holding Transfer Amount
    • Invoiced Amount
    • Payment Amount
    • Scheduled Invoice Amount

Student Measures

  • Attributes
  • Student Award or Statement
  • Event Measures
    • (*) Event Participants
    • Events
  • Placement Measures
    • (*) Student Placement Charge
    • (*) Student Placement Count
    • (*) Student Placement Hours
    • (*) Student Wage

Address City

City of the trainers client record

Address Postcode

Postcode of the trainers client record

Address State

State of the trainers client record

Staff Status

Is the trainer’s client record active

Staff Type Active

Is the staff type as configured in the Staff Type wizard active

Staff Type Code

Staff type code as configured in the Staff Type Wizard

Staff Type Name

Staff type name as configured in the Staff Type Wizard

Trainer Code

Code for the trainers client record

Trainer Gender

Gender of the trainers client record

Trainer Manager

First name and last name of the trainers manager

Trainer Name

First name and last name of the trainer

 

5.7       Disability Dimension

The measures below in (*) black are mapped to the Disability dimension, those in grey are not mapped.

Course Measures

  • Enrolment Measures
    • (*) Course Enrolments
    • (*) Enrolment Activities
    • (*) Enrolment Activities Max Date
    • (*) Enrolment Contact
    • (*) Enrolment Hours
    • (*) Enrolment Tasks
    • (*) Students
    • (*) Training Contracts
    • (*) Unit Enrolments
  • Programme Measures
    • (*) Class Attendances
    • (*) Class Attendances Present
    • Classes
    • Occurrences
    • (*) Waitlist
  • VET FEE Help Measures
    • (*) VFH Amount Charged
    • (*) VFH Enrolments
    • (*) VFH Loan Fee
    • (*) VFH Paid Upfront

Finance Measures

  • Expense Measures
    • Occurrence Cost Amount
    • Occurrence Cost Budget Amount
    • Occurrence Cost Budget Amount GST
    • Occurrence Cost GST
  • Forecast Measures
    • (*) Funded Forecast Amount
    • (*) Funded Forecast Hours
  • Income Measures
    • Funded Payment Hours
    • Holding Transfer Amount
    • Invoiced Amount
    • Payment Amount
    • Scheduled Invoice Amount

Student Measures

  • (*) Attributes
  • (*) Student Award or Statement
  • Event Measures
    • (*) Event Participants
    • (*) Events
  • Placement Measures
    • (*) Student Placement Charge
    • (*) Student Placement Count
    • (*) Student Placement Hours
    • (*) Student Wage

Disability Name

Disability name recorded against a client record. The list of disabilities is a fixed list provided by NCVER

 

5.8       Employer Dimension

The measures below in (*) black are mapped to the Employer dimension, those in grey are not mapped.

Course Measures

  • Enrolment Measures
    • (*) Course Enrolments
    • (*) Enrolment Activities
    • (*) Enrolment Activities Max Date
    • (*) Enrolment Contact
    • (*) Enrolment Hours
    • (*) Enrolment Tasks
    • (*) Students
    • (*) Training Contracts
    • (*) Unit Enrolments
  • Programme Measures
    • (*) Class Attendances
    • (*) Class Attendances Present
    • Classes
    • (*) Occurrences
    • (*) Waitlist
  • VET FEE Help Measures
    • (*) VFH Amount Charged
    • (*) VFH Enrolments
    • (*) VFH Loan Fee
    • (*) VFH Paid Upfront

Finance Measures

  • Expense Measures
    • (*) Occurrence Cost Amount
    • (*) Occurrence Cost Budget Amount
    • (*) Occurrence Cost Budget Amount GST
    • (*) Occurrence Cost GST
  • Forecast Measures
    • (*) Funded Forecast Amount
    • (*) Funded Forecast Hours
  • Income Measures
    • (*) Funded Payment Hours
    • (*) Holding Transfer Amount
    • (*) Invoiced Amount
    • (*) Payment Amount
    • (*) Scheduled Invoice Amount

Student Measures

  • (*) Attributes
  • (*) Student Award or Statement
  • Event Measures
    • (*) Event Participants
    • (*) Events
  • Placement Measures
    • (*) Student Placement Charge
    • (*) Student Placement Count
    • (*) Student Placement Hours
    • (*) Student Wage

Employer

Employer Name

Employer City

Employer City

Employer Postcode

Employer Postcode

Employer Size

Number of employees as set in the Employer Wizard

Employer State

Employer State

Employer Status

Employer active flag as set in the Employer Wizard

Employer Type

Possible Values: “Normal”, “RTO”, “NAC” or “RTO and NAC”

 

5.9       Enrolment Dimension

The measures below in (*) black are mapped to the Enrolment dimension, those in grey are not mapped.

Course Measures

  • Enrolment Measures
    • (*) Course Enrolments
    • (*) Enrolment Activities
    • (*) Enrolment Activities Max Date
    • (*) Enrolment Contact
    • (*) Enrolment Hours
    • (*) Enrolment Tasks
    • (*) Students
    • Training Contracts
    • (*) Unit Enrolments
  • Programme Measures
    • (*) Class Attendances
    • (*) Class Attendances Present
    • Classes
    • Occurrences
    • Waitlist
  • VET FEE Help Measures
    • VFH Amount Charged
    • VFH Enrolments
    • VFH Loan Fee
    • VFH Paid Upfront

Finance Measures

  • Expense Measures
    • Occurrence Cost Amount
    • Occurrence Cost Budget Amount
    • Occurrence Cost Budget Amount GST
    • Occurrence Cost GST
  • Forecast Measures
    • (*) Funded Forecast Amount
    • (*) Funded Forecast Hours
  • Income Measures
    • (*) Funded Payment Hours
    • Holding Transfer Amount
    • (*) Invoiced Amount
    • (*) Payment Amount
    • (*) Scheduled Invoice Amount

Student Measures

  • Attributes
  • Student Award or Statement
  • Event Measures
    • (*) Event Participants
    • (*) Events
  • Placement Measures
    • (*) Student Placement Charge
    • (*) Student Placement Count
    • (*) Student Placement Hours
    • (*) Student Wage

Course End Date CYH

Course End Date in Calendar Year Hierarchy Form

Course End Date FYH

Course End Date in Financial Year Hierarchy Form

Course Start Date CYH

Course Start Date in Calendar Year Hierarchy Form

Course Start Date FYH

Course Start Date in Financial Year Hierarchy Form

Enrolment Create Date CYH

Enrolment Create Date in Calendar Year Hierarchy Form

Enrolment Create Date FYH

Enrolment Create Date in Financial Year Hierarchy Form

Status Change Date CYH

Status Change Date in Calendar Year Hierarchy Form

Status Change Date FYH

Status Change Date in Financial Year Hierarchy Form

VIC Commencement Date CYH

VIC Commencement Date in Calendar Year Hierarchy Form

VIC Commencement Date FYH

VIC Commencement Date in Financial Year Hierarchy Form

AVETMISS Reporting Flag

Possible Values: “State Reportable”, “Not Reportable” or “Nationally Reportable”

Course End Date Full

Full date of the course end

Course Start Date Full

Full date of the course start

Enrolment Create Date Full

Full date of when this enrolment was created

Enrolment Inserted By

First name and last name of the VETtrak user who created this enrolment

Enrolment Last Updated By

First name and last name of the VETtrak user who last updated this enrolment

Enrolment Status

Enrolment status given to this enrolment. Status types are configured in the Status Type Wizard in VETtrak

National Funding

Name of the National Funding Source assigned to the enrolment

Purchasing Contract Name

Name of the Purchasing Contract as can be configured in the Purchasing Contract Wizard and then assigned to an enrolment

Purchasing Contract State

State of Australia for the assigned Purchasing Contract

Referral Name

Enrolment referral source, as configured in the Referral Wizard in VETtrak

State Funding

Name of the State Funding Source assigned to the enrolment. Funding sources are configured in the Funding Source Wizard in VETtrak

Status Change Date Full

Full date of when the enrolment status was last changed

Study Reason

Fixed list of study reasons that varies for each state

VIC Commencement Date Full

Full date of the VIC commencement field (for Victorian enrolments only)

 

5.10   Enrolment Activity Dimension

The measures below in (*) black are mapped to the Enrolment Activity dimension, those in grey are not mapped.

Course Measures

  • Enrolment Measures
    • Course Enrolments
    • (*) Enrolment Activities
    • (*) Enrolment Activities Max Date
    • Enrolment Contact
    • Enrolment Hours
    • Enrolment Tasks
    • Students
    • Training Contracts
    • Unit Enrolments
  • Programme Measures
    • Class Attendances
    • Class Attendances Present
    • Classes
    • Occurrences
    • Waitlist
  • VET FEE Help Measures
    • VFH Amount Charged
    • VFH Enrolments
    • VFH Loan Fee
    • VFH Paid Upfront

Finance Measures

  • Expense Measures
    • Occurrence Cost Amount
    • Occurrence Cost Budget Amount
    • Occurrence Cost Budget Amount GST
    • Occurrence Cost GST
  • Forecast Measures
    • Funded Forecast Amount
    • Funded Forecast Hours
  • Income Measures
    • Funded Payment Hours
    • Holding Transfer Amount
    • Invoiced Amount
    • Payment Amount
    • Scheduled Invoice Amount

Student Measures

  • Attributes
  • Student Award or Statement
  • Event Measures
    • Event Participants
    • Events
  • Placement Measures
    • Student Placement Charge
    • Student Placement Count
    • Student Placement Hours
    • Student Wage

Activity Date CYH

Activity Date in Calendar Year Hierarchy Form

Activity Date FYH

Activity Date in Financial Year Hierarchy Form

Activity Date

Full enrolment activity date

Activity Type

Possible values: “Result Recorded”, “Classroom Attendance”, “Event”, “Task” and “Contact”

Unit Result History

For Unit results, this field shows the history of all unit results recorded for a particular unit.

 

5.11   Enrolment Staff Dimension

The measures below in (*) black are mapped to the Enrolment Staff dimension, those in grey are not mapped.

Course Measures

  • Enrolment Measures
    • (*) Course Enrolments
    • (*) Enrolment Activities
    • (*) Enrolment Activities Max Date
    • (*) Enrolment Contact
    • (*) Enrolment Hours
    • (*) Enrolment Tasks
    • (*) Students
    • (*) Training Contracts
    • (*) Unit Enrolments
  • Programme Measures
    • Class Attendances
    • Class Attendances Present
    • Classes
    • Occurrences
    • Waitlist
  • VET FEE Help Measures
    • VFH Amount Charged
    • VFH Enrolments
    • VFH Loan Fee
    • VFH Paid Upfront

Finance Measures

  • Expense Measures
    • Occurrence Cost Amount
    • Occurrence Cost Budget Amount
    • Occurrence Cost Budget Amount GST
    • Occurrence Cost GST
  • Forecast Measures
    • (*) Funded Forecast Amount
    • (*) Funded Forecast Hours
  • Income Measures
    • Funded Payment Hours
    • Holding Transfer Amount
    • Invoiced Amount
    • Payment Amount
    • Scheduled Invoice Amount

Student Measures

  • Attributes
  • Student Award or Statement
  • Event Measures
    • Event Participants
    • Events
  • Placement Measures
    • Student Placement Charge
    • Student Placement Count
    • Student Placement Hours
    • Student Wage

Address City

City of the trainers client record

Address Postcode

Postcode of the trainers client record

Address State

State of the trainers client record

Staff Status

Is the trainer’s client record active

Staff Type Active

Is the staff type as configured in the Staff Type wizard active

Staff Type Code

Staff type code as configured in the Staff Type Wizard

Staff Type Name

Staff type name as configured in the Staff Type Wizard

Trainer Code

Code for the trainers client record

Trainer Gender

Gender of the trainers client record

Trainer Manager

First name and last name of the trainers manager

Trainer Name

First name and last name of the trainer

 

5.12   Event Dimension

The measures below in (*) black are mapped to the Event dimension, those in grey are not mapped.

Course Measures

  • Enrolment Measures
    • Course Enrolments
    • (*) Enrolment Activities
    • (*) Enrolment Activities Max Date
    • Enrolment Contact
    • Enrolment Hours
    • Enrolment Tasks
    • Students
    • Training Contracts
    • Unit Enrolments
  • Programme Measures
    • Class Attendances
    • Class Attendances Present
    • Classes
    • Occurrences
    • Waitlist
  • VET FEE Help Measures
    • VFH Amount Charged
    • VFH Enrolments
    • VFH Loan Fee
    • VFH Paid Upfront

Finance Measures

  • Expense Measures
    • Occurrence Cost Amount
    • Occurrence Cost Budget Amount
    • Occurrence Cost Budget Amount GST
    • Occurrence Cost GST
  • Forecast Measures
    • Funded Forecast Amount
    • Funded Forecast Hours
  • Income Measures
    • Funded Payment Hours
    • Holding Transfer Amount
    • Invoiced Amount
    • Payment Amount
    • Scheduled Invoice Amount

Student Measures

  • Attributes
  • Student Award or Statement
  • Event Measures
    • (*) Event Participants
    • (*) Events
  • Placement Measures
    • Student Placement Charge
    • Student Placement Count
    • Student Placement Hours
    • Student Wage

End Date CYH

End date of the Event in Calendar Year Hierarchy form

End Date FYH

End date of the Event in Financial Year Hierarchy form

Start Date CYH

Start date of the Event in Calendar Year Hierarchy form

Start Date FYH

Start date of the Event in Financial Year Hierarchy form

Event Code

Code of the event entered into the Event wizard in VETtrak

Event End Date Full

Full date of the event end date

Event Name

Name of the event entered into the Event wizard in VETtrak

Event Notes

Event description as entered in VETtrak

Event Staff Member

Staff member linked to this event

Event Start Date Full

Full date of the event start date

Is Client Complete

Possible values: “Complete” or “Not Complete”

Is Event Active

Possible values: “Active” or “Not Active”

 

5.13   Expense Dimension

The measures below in (*) black are mapped to the Expense dimension, those in grey are not mapped.

Course Measures

  • Enrolment Measures
    • Course Enrolments
    • Enrolment Activities
    • Enrolment Activities Max Date
    • Enrolment Contact
    • Enrolment Hours
    • Enrolment Tasks
    • Students
    • Training Contracts
    • Unit Enrolments
  • Programme Measures
    • Class Attendances
    • Class Attendances Present
    • Classes
    • Occurrences
    • Waitlist
  • VET FEE Help Measures
    • VFH Amount Charged
    • VFH Enrolments
    • VFH Loan Fee
    • VFH Paid Upfront

Finance Measures

  • Expense Measures
    • (*) Occurrence Cost Amount
    • (*) Occurrence Cost Budget Amount
    • (*) Occurrence Cost Budget Amount GST
    • (*) Occurrence Cost GST
  • Forecast Measures
    • Funded Forecast Amount
    • Funded Forecast Hours
  • Income Measures
    • Funded Payment Hours
    • Holding Transfer Amount
    • Invoiced Amount
    • Payment Amount
    • Scheduled Invoice Amount

Student Measures

  • Attributes
  • Student Award or Statement
  • Event Measures
    • Event Participants
    • Events
  • Placement Measures
    • Student Placement Charge
    • Student Placement Count
    • Student Placement Hours
    • Student Wage

Active

Is the Occurrence cost type active? Possible values: “Active” or “Not Active”

Cost Type

Name of the Occurrence cost type

Cost Type Code

Code of the Occurrence cost type

Enforce Staff Link

Does this Occurrence cost type enforce a link to a staff member in VETtrak? Possible values: “Staff Member Associated” or “No Staff Member”

 

5.14   Forecast Dimension

The measures below in (*) black are mapped to the Forecast dimension, those in grey are not mapped.

Course Measures

  • Enrolment Measures
    • Course Enrolments
    • Enrolment Activities
    • Enrolment Activities Max Date
    • Enrolment Contact
    • Enrolment Hours
    • Enrolment Tasks
    • Students
    • Training Contracts
    • Unit Enrolments
  • Programme Measures
    • Class Attendances
    • Class Attendances Present
    • Classes
    • Occurrences
    • Waitlist
  • VET FEE Help Measures
    • VFH Amount Charged
    • VFH Enrolments
    • VFH Loan Fee
    • VFH Paid Upfront

Finance Measures

  • Expense Measures
    • Occurrence Cost Amount
    • Occurrence Cost Budget Amount
    • Occurrence Cost Budget Amount GST
    • Occurrence Cost GST
  • Forecast Measures
    • (*) Funded Forecast Amount
    • (*) Funded Forecast Hours
  • Income Measures
    • Funded Payment Hours
    • Holding Transfer Amount
    • Invoiced Amount
    • Payment Amount
    • Scheduled Invoice Amount

Student Measures

  • Attributes
  • Student Award or Statement
  • Event Measures
    • Event Participants
    • Events
  • Placement Measures
    • Student Placement Charge
    • Student Placement Count
    • Student Placement Hours
    • Student Wage

Forecast CYH

Forecast date in Calendar Year Hierarchy form

Forecast FYH

Forecast date in Financial Year Hierarchy form

Forecast Date Full

Full date of the forecasted month (first day of the month)

Forecast Type

Possible values: “VTG Funding”, “Queensland Funding” or “VET-FEE HELP”

 

5.15   Holding Dimension

The measures below in (*) black are mapped to the Holding dimension, those in grey are not mapped.

Course Measures

  • Enrolment Measures
    • Course Enrolments
    • Enrolment Activities
    • Enrolment Activities Max Date
    • Enrolment Contact
    • Enrolment Hours
    • Enrolment Tasks
    • Students
    • Training Contracts
    • Unit Enrolments
  • Programme Measures
    • Class Attendances
    • Class Attendances Present
    • Classes
    • Occurrences
    • Waitlist
  • VET FEE Help Measures
    • VFH Amount Charged
    • VFH Enrolments
    • VFH Loan Fee
    • VFH Paid Upfront

Finance Measures

  • Expense Measures
    • Occurrence Cost Amount
    • Occurrence Cost Budget Amount
    • Occurrence Cost Budget Amount GST
    • Occurrence Cost GST
  • Forecast Measures
    • Funded Forecast Amount
    • Funded Forecast Hours
  • Income Measures
    • Funded Payment Hours
    • (*) Holding Transfer Amount
    • Invoiced Amount
    • Payment Amount
    • Scheduled Invoice Amount

Student Measures

  • Attributes
  • Student Award or Statement
  • Event Measures
    • Event Participants
    • Events
  • Placement Measures
    • Student Placement Charge
    • Student Placement Count
    • Student Placement Hours
    • Student Wage

Holding Transfer Date CYH

Holding transfer date in Calendar Year Hierarchy form

Holding Transfer Date FYH

Holding transfer date in Financial Year Hierarchy form

Holding Transfer Date Full

Full date of the holding transfer date

 

5.16   Invoice Dimension

The measures below in (*) black are mapped to the Invoice dimension, those in grey are not mapped.

Course Measures

  • Enrolment Measures
    • Course Enrolments
    • Enrolment Activities
    • Enrolment Activities Max Date
    • Enrolment Contact
    • Enrolment Hours
    • Enrolment Tasks
    • Students
    • Training Contracts
    • Unit Enrolments
  • Programme Measures
    • Class Attendances
    • Class Attendances Present
    • Classes
    • Occurrences
    • Waitlist
  • VET FEE Help Measures
    • VFH Amount Charged
    • VFH Enrolments
    • VFH Loan Fee
    • VFH Paid Upfront

Finance Measures

  • Expense Measures
    • Occurrence Cost Amount
    • Occurrence Cost Budget Amount
    • Occurrence Cost Budget Amount GST
    • Occurrence Cost GST
  • Forecast Measures
    • Funded Forecast Amount
    • Funded Forecast Hours
  • Income Measures
    • Funded Payment Hours
    • Holding Transfer Amount
    • (*) Invoiced Amount
    • (*) Payment Amount
    • (*) Scheduled Invoice Amount

Student Measures

  • Attributes
  • Student Award or Statement
  • Event Measures
    • Event Participants
    • Events
  • Placement Measures
    • Student Placement Charge
    • Student Placement Count
    • Student Placement Hours
    • Student Wage

Invoice Date CYH

Invoice date in Calendar Year Hierarchy form

Invoice Date FYH

Invoice date in Financial Year Hierarchy form

Scheduled Date CYH

Invoice scheduled date in Calendar Year Hierarchy form

Scheduled Date FYH

Invoice scheduled date in Financial Year Hierarchy form

Aged Receivables

Age of the invoice. Possible values: “90+ days”, “61-90 days”, “31-60 days” or “<=30 days”

Invoice Date Full

Full date of the invoice date

Invoice Number

Invoice number recorded in VETtrak

Invoicee

Is this a client or employer invoice? Possible values: “Client”, “Employer” or “Unknown”

Payment Status

Possible values: “No Payments”, “Part Payment”, “Paid In Full”, “Over Paid” or “Credited Out”

Price Type Active Flag

Is this Price Type an active one in VETtrak? Possible values: “Active”, “Inactive” or “Unknown”

Price Type Category

Possible values: “Normal”, “Tuition/course fee”, “Resource fee”, Loan liability”, “Government contribution”, “Corporate”, Inventory item” or “Pre 4.4.3 Invoice item”. Any invoice created in VETtrak prior to VETtrak release 4.4.3 will not have a price item linked.

Price Type Code

Code of the Price Type configured in VETtrak

Price Type Name

Name of the Price Type configured in VETtrak

Scheduled Date Full

Full date of the scheduled invoice date

 

5.17   Ledger Dimension

The measures below in (*) black are mapped to the Ledger dimension, those in grey are not mapped.

Course Measures

  • Enrolment Measures
    • Course Enrolments
    • Enrolment Activities
    • Enrolment Activities Max Date
    • Enrolment Contact
    • Enrolment Hours
    • Enrolment Tasks
    • Students
    • Training Contracts
    • Unit Enrolments
  • Programme Measures
    • Class Attendances
    • Class Attendances Present
    • Classes
    • Occurrences
    • Waitlist
  • VET FEE Help Measures
    • VFH Amount Charged
    • VFH Enrolments
    • VFH Loan Fee
    • VFH Paid Upfront

Finance Measures

  • Expense Measures
    • Occurrence Cost Amount
    • Occurrence Cost Budget Amount
    • Occurrence Cost Budget Amount GST
    • Occurrence Cost GST
  • Forecast Measures
    • Funded Forecast Amount
    • Funded Forecast Hours
  • Income Measures
    • Funded Payment Hours
    • Holding Transfer Amount
    • (*) Invoiced Amount
    • (*) Payment Amount
    • (*) Scheduled Invoice Amount

Student Measures

  • Attributes
  • Student Award or Statement
  • Event Measures
    • Event Participants
    • Events
  • Placement Measures
    • Student Placement Charge
    • Student Placement Count
    • Student Placement Hours
    • Student Wage

Active Flag

Is this Ledger active in VETtrak?

Code

Code of the ledger as configured in VETtrak

Ledger Name

Name of the ledger as configured in VETtrak

 

5.18   Location Dimension

The measures below in (*) black are mapped to the Location dimension, those in grey are not mapped.

Course Measures

  • Enrolment Measures
    • (*) Course Enrolments
    • (*) Enrolment Activities
    • (*) Enrolment Activities Max Date
    • (*) Enrolment Contact
    • (*) Enrolment Hours
    • (*) Enrolment Tasks
    • (*) Students
    • Training Contracts
    • (*) Unit Enrolments
  • Programme Measures
    • (*) Class Attendances
    • (*) Class Attendances Present
    • (*) Classes
    • (*) Occurrences
    • Waitlist
  • VET FEE Help Measures
    • VFH Amount Charged
    • VFH Enrolments
    • VFH Loan Fee
    • VFH Paid Upfront

Finance Measures

  • Expense Measures
    • (*) Occurrence Cost Amount
    • (*) Occurrence Cost Budget Amount
    • (*) Occurrence Cost Budget Amount GST
    • (*) Occurrence Cost GST
  • Forecast Measures
    • (*) Funded Forecast Amount
    • (*) Funded Forecast Hours
  • Income Measures
    • (*) Funded Payment Hours
    • Holding Transfer Amount
    • (*) Invoiced Amount
    • (*) Payment Amount
    • (*) Scheduled Invoice Amount

Student Measures

  • Attributes
  • (*) Student Award or Statement
  • Event Measures
    • Event Participants
    • Events
  • Placement Measures
    • Student Placement Charge
    • Student Placement Count
    • Student Placement Hours
    • Student Wage

Geography

Dimension hierarchy for location State and City

Location

Location name

Location City

City of the location

Location Code

Code of the location as configured in VETtrak

Location Country

Country of the location

Location Postcode

Postcode of the location

Location State

State of the location

 

5.19   Occurrence or Booking Dimension

The measures below in (*) black are mapped to the Occurrence or Booking dimension, those in grey are not mapped.

Course Measures

  • Enrolment Measures
    • (*) Course Enrolments
    • (*) Enrolment Activities
    • (*) Enrolment Activities Max Date
    • (*) Enrolment Contact
    • (*) Enrolment Hours
    • (*) Enrolment Tasks
    • (*) Students
    • Training Contracts
    • (*) Unit Enrolments
  • Programme Measures
    • (*) Class Attendances
    • (*) Class Attendances Present
    • (*) Classes
    • (*) Occurrences
    • Waitlist
  • VET FEE Help Measures
    • VFH Amount Charged
    • VFH Enrolments
    • VFH Loan Fee
    • VFH Paid Upfront

Finance Measures

  • Expense Measures
    • (*) Occurrence Cost Amount
    • (*) Occurrence Cost Budget Amount
    • (*) Occurrence Cost Budget Amount GST
    • (*) Occurrence Cost GST
  • Forecast Measures
    • (*) Funded Forecast Amount
    • (*) Funded Forecast Hours
  • Income Measures
    • Funded Payment Hours
    • Holding Transfer Amount
    • (*) Invoiced Amount
    • (*) Payment Amount
    • (*) Scheduled Invoice Amount

Student Measures

  • Attributes
  • Student Award or Statement
  • Event Measures
    • (*) Event Participants
    • (*) Events
  • Placement Measures
    • (*) Student Placement Charge
    • (*) Student Placement Count
    • (*) Student Placement Hours
    • (*) Student Wage

End Date CYH

End date of the occurrence in Calendar Year Hierarchy form

End Date FYH

End date of the occurrence in Financial Year Hierarchy form

Start Date CYH

Start date of the occurrence in Calendar Year Hierarchy form

Start Date FYH

Start date of the occurrence in Financial Year Hierarchy form

Max Enrolments

Maximum number of participants configured for the Occurrence

Occurrence Code

Code of the occurrence as configured in VETtrak

Occurrence End Date Full

End date of the occurrence

Occurrence Start Date Full

Start date of the occurrence

Occurrence Status

Status of the Enrolment

Occurrence Type

Possible values: “Normal”, “Skills Audit”, “Occurrence”, “Client Occurrence”, “Employer Occurrence”, “Employee enrolment within an Employer Occurrence enrolment” or “Booking”

 

5.20   Organisation Dimension

The measures below in (*) black are mapped to the Organisation dimension, those in grey are not mapped.

Course Measures

  • Enrolment Measures
    • (*) Course Enrolments
    • (*) Enrolment Activities
    • (*) Enrolment Activities Max Date
    • (*) Enrolment Contact
    • (*) Enrolment Hours
    • (*) Enrolment Tasks
    • (*) Students
    • (*) Training Contracts
    • (*) Unit Enrolments
  • Programme Measures
    • (*) Class Attendances
    • (*) Class Attendances Present
    • (*) Classes
    • (*) Occurrences
    • Waitlist
  • VET FEE Help Measures
    • (*) VFH Amount Charged
    • (*) VFH Enrolments
    • (*) VFH Loan Fee
    • (*) VFH Paid Upfront

Finance Measures

  • Expense Measures
    • (*) Occurrence Cost Amount
    • (*) Occurrence Cost Budget Amount
    • (*) Occurrence Cost Budget Amount GST
    • (*) Occurrence Cost GST
  • Forecast Measures
    • (*) Funded Forecast Amount
    • (*) Funded Forecast Hours
  • Income Measures
    • (*) Funded Payment Hours
    • Holding Transfer Amount
    • (*) Invoiced Amount
    • (*) Payment Amount
    • (*) Scheduled Invoice Amount

Student Measures

  • Attributes
  • (*) Student Award or Statement
  • Event Measures
    • (*) Event Participants
    • (*) Events
  • Placement Measures
    • (*) Student Placement Charge
    • (*) Student Placement Count
    • (*) Student Placement Hours
    • (*) Student Wage

Organisation

Name of the organisation

Organisation Code

Code of the organisation

Organisation Postcode

Postcode of the organisation

Organisation State

State of the organisation

Organisation Type

Type of the organisation

 

5.21   Payment Dimension

The measures below in (*) black are mapped to the Payment dimension, those in grey are not mapped.

Course Measures

  • Enrolment Measures
    • Course Enrolments
    • Enrolment Activities
    • Enrolment Activities Max Date
    • Enrolment Contact
    • Enrolment Hours
    • Enrolment Tasks
    • Students
    • Training Contracts
    • Unit Enrolments
  • Programme Measures
    • Class Attendances
    • Class Attendances Present
    • Classes
    • Occurrences
    • Waitlist
  • VET FEE Help Measures
    • VFH Amount Charged
    • VFH Enrolments
    • VFH Loan Fee
    • VFH Paid Upfront

Finance Measures

  • Expense Measures
    • Occurrence Cost Amount
    • Occurrence Cost Budget Amount
    • Occurrence Cost Budget Amount GST
    • Occurrence Cost GST
  • Forecast Measures
    • Funded Forecast Amount
    • Funded Forecast Hours
  • Income Measures
    • (*) Funded Payment Hours
    • Holding Transfer Amount
    • Invoiced Amount
    • (*) Payment Amount
    • Scheduled Invoice Amount

Student Measures

  • Attributes
  • Student Award or Statement
  • Event Measures
    • Event Participants
    • Events
  • Placement Measures
    • Student Placement Charge
    • Student Placement Count
    • Student Placement Hours
    • Student Wage

Payment Date CYH

Payment date in Calendar Year Hierarchy form

Payment Date FYH

Payment date in Financial Year Hierarchy form

Funded Payment Batch ID

Batch ID of the uploaded funded payment file received from the government and uploaded into VETtrak

Payment Date Full

Full date of the payment

Payment Type Code

Code of the Payment Type as configured in the Payment Type Wizard in VETtrak

Payment Type Name

Name of the Payment Type as configured in the Payment Type Wizard in VETtrak

 

5.22   Placement Dimension

The measures below in (*) black are mapped to the Placement dimension, those in grey are not mapped.

Course Measures

  • Enrolment Measures
    • Course Enrolments
    • Enrolment Activities
    • Enrolment Activities Max Date
    • Enrolment Contact
    • Enrolment Hours
    • Enrolment Tasks
    • Students
    • Training Contracts
    • Unit Enrolments
  • Programme Measures
    • Class Attendances
    • Class Attendances Present
    • Classes
    • Occurrences
    • Waitlist
  • VET FEE Help Measures
    • VFH Amount Charged
    • VFH Enrolments
    • VFH Loan Fee
    • VFH Paid Upfront

Finance Measures

  • Expense Measures
    • Occurrence Cost Amount
    • Occurrence Cost Budget Amount
    • Occurrence Cost Budget Amount GST
    • Occurrence Cost GST
  • Forecast Measures
    • Funded Forecast Amount
    • Funded Forecast Hours
  • Income Measures
    • Funded Payment Hours
    • Holding Transfer Amount
    • Invoiced Amount
    • Payment Amount
    • Scheduled Invoice Amount

Student Measures

  • Attributes
  • Student Award or Statement
  • Event Measures
    • Event Participants
    • Events
  • Placement Measures
    • (*) Student Placement Charge
    • (*) Student Placement Count
    • (*) Student Placement Hours
    • (*) Student Wage

Student Placement Finish Date CYH

Finish date of the placement in Calendar Year Hierarchy form

Student Placement Finish Date FYH

Finish date of the placement in Financial Year Hierarchy form

Student Placement Start Date CYH

Start date of the placement in Calendar Year Hierarchy form

Student Placement Start Date FYH

Start date of the placement in Financial Year Hierarchy form

Student Placement Finish Date Full

Finish date of the placement

Student Placement Start Date Full

Start date of the placement

 

5.23   Programme Dimension

The measures below in (*) black are mapped to the Programme dimension, those in grey are not mapped.

Course Measures

  • Enrolment Measures
    • (*) Course Enrolments
    • (*) Enrolment Activities
    • (*) Enrolment Activities Max Date
    • (*) Enrolment Contact
    • (*) Enrolment Hours
    • (*) Enrolment Tasks
    • (*) Students
    • Training Contracts
    • (*) Unit Enrolments
  • Programme Measures
    • (*) Class Attendances
    • (*) Class Attendances Present
    • (*) Classes
    • (*) Occurrences
    • (*) Waitlist
  • VET FEE Help Measures
    • VFH Amount Charged
    • VFH Enrolments
    • VFH Loan Fee
    • VFH Paid Upfront

Finance Measures

  • Expense Measures
    • (*) Occurrence Cost Amount
    • (*) Occurrence Cost Budget Amount
    • (*) Occurrence Cost Budget Amount GST
    • (*) Occurrence Cost GST
  • Forecast Measures
    • (*) Funded Forecast Amount
    • (*) Funded Forecast Hours
  • Income Measures
    • (*) Funded Payment Hours
    • Holding Transfer Amount
    • (*) Invoiced Amount
    • (*) Payment Amount
    • (*) Scheduled Invoice Amount

Student Measures

  • Attributes
  • Student Award or Statement
  • Event Measures
    • (*) Event Participants
    • (*) Events
  • Placement Measures
    • (*) Student Placement Charge
    • (*) Student Placement Count
    • (*) Student Placement Hours
    • (*) Student Wage

Programme Code

Code of the Programme as configured in the Programme Wizard

Programme Name

Name of the Programme as configured in the Programme Wizard

Programme Type

Name of the Programme Type as can be configured in the Programme Type Wizard

 

5.24   Qualification Dimension

The measures below in (*) black are mapped to the Programme dimension, those in grey are not mapped.

Course Measures

  • Enrolment Measures
    • (*) Course Enrolments
    • (*) Enrolment Activities
    • (*) Enrolment Activities Max Date
    • (*) Enrolment Contact
    • (*) Enrolment Hours
    • (*) Enrolment Tasks
    • (*) Students
    • (*) Training Contracts
    • (*) Unit Enrolments
  • Programme Measures
    • (*) Class Attendances
    • (*) Class Attendances Present
    • (*) Classes
    • (*) Occurrences
    • Waitlist
  • VET FEE Help Measures
    • (*) VFH Amount Charged
    • (*) VFH Enrolments
    • (*) VFH Loan Fee
    • (*) VFH Paid Upfront

Finance Measures

  • Expense Measures
    • (*) Occurrence Cost Amount
    • (*) Occurrence Cost Budget Amount
    • (*) Occurrence Cost Budget Amount GST
    • (*) Occurrence Cost GST
  • Forecast Measures
    • (*) Funded Forecast Amount
    • (*) Funded Forecast Hours
  • Income Measures
    • (*) Funded Payment Hours
    • Holding Transfer Amount
    • (*) Invoiced Amount
    • (*) Payment Amount
    • (*) Scheduled Invoice Amount

Student Measures

  • Attributes
  • (*) Student Award or Statement
  • Event Measures
    • (*) Event Participants
    • (*) Events
  • Placement Measures
    • (*) Student Placement Charge
    • (*) Student Placement Count
    • (*) Student Placement Hours
    • (*) Student Wage

Field Of Education

Pre-defined list of AVETMISS-compliant Fields of Education assigned to the Qualification

National Or State Flag

Possible Values: “State Code” or “National Code”

Qualification

Name of the Qualification

Qualification Code

Code of the Qualification

Qualification Expiry Date

Expiry date of the Qualification

Recognition Status

The recognition / accreditation status of the Qualification

Training Package

Name of the Training Package

VET Flag

Indicates whether this Qualification is a VET course or not. Possible values: “Yes” or “No”

 

5.25   Student Dimension

The measures below in (*) black are mapped to the Student dimension, those in grey are not mapped.

Course Measures

  • Enrolment Measures
    • (*) Course Enrolments
    • (*) Enrolment Activities
    • (*) Enrolment Activities Max Date
    • (*) Enrolment Contact
    • (*) Enrolment Hours
    • (*) Enrolment Tasks
    • (*) Students
    • (*) Training Contracts
    • (*) Unit Enrolments
  • Programme Measures
    • (*) Class Attendances
    • (*) Class Attendances Present
    • Classes
    • Occurrences
    • (*) Waitlist
  • VET FEE Help Measures
    • (*) VFH Amount Charged
    • (*) VFH Enrolments
    • (*) VFH Loan Fee
    • (*) VFH Paid Upfront

Finance Measures

  • Expense Measures
    • Occurrence Cost Amount
    • Occurrence Cost Budget Amount
    • Occurrence Cost Budget Amount GST
    • Occurrence Cost GST
  • Forecast Measures
    • (*) Funded Forecast Amount
    • (*) Funded Forecast Hours
  • Income Measures
    • (*) Funded Payment Hours
    • (*) Holding Transfer Amount
    • (*) Invoiced Amount
    • (*) Payment Amount
    • (*) Scheduled Invoice Amount

Student Measures

  • (*) Attributes
  • (*) Student Award or Statement
  • Event Measures
    • (*) Event Participants
    • (*) Events
  • Placement Measures
    • (*) Student Placement Charge
    • (*) Student Placement Count
    • (*) Student Placement Hours
    • (*) Student Wage

Create Date CYH

Create date of the student in Calendar Year Hierarchy form

Create Date FYH

Create date of the student in Financial Year Hierarchy form

Address City

City of students client record

Address Postcode

Postcode of students client record

Address State

State of students client record

Age Range

Possible values: “<20”, “20-24”, “25-29”, “30-34”, “35-39”, “40-44”, “45-49”, “50-54”, “55-59”, “60-64” or “65+”

Citizenship Status

Possible values: “Australian Citizen or Eligible Resident”, “Not an Australian Citizen or Not Eligible” or “Not Stated”

Country Of Birth

Country of birth as set in the students client record

Create Date Full

Create date of the student

Division Name

Students assigned division

Employment Category

Fixed list of Employment Categories

Has Disability

Possible values: “Yes Disability”, “No Disability” or “Not Stated”

Indigenous Category

Possible values: “Yes, Aboriginal”, “Yes, Torres Strait Islander”, “Yes, both Aboriginal and Torres Strait Islander”, “No, neither Aboriginal nor Torres Strait Islander” or “Not Stated”

Is Employee

Looks at whether the student has an employer set. Possible values: “Not employee” or “Employee”

Is Student USI Exempt

Possible values: “Exempt” or “Not Exempt”

Language Spoken At Home

Language spoken at home as defined in the students client record

Preferred Contact Method

Possible values: “Email”, “Mail”, “Mobile” or “Not Stated”

Prior Education

Possible values: “Yes Prior Education”, “No Prior Education” or “Not Stated”

School Level Achieved

Possible values: “Yes At School”, “No At School” or “Not State”

Spoken English Proficiency

Possible values: “Very Well”, “Well”, “Not Well”, “Not At All” or “Not Stated”

Student Code

Client code for the student

Student DOB

Date of birth as set in the client record

Student Gender

Gender of the student

Student Manager

First and last name of the clients manager

Student Name

First and last name of the student

Student Status

Status of the students client record

Student USI

USI of the student

Student USI Verify Status

Possible values: “Unverified or Missing”, “Valid”, “Invalid”, “Deactivated”, “Mismatched name” or “Mismatched date of birth”

Town Or City Of Birth

Students town or city of birth

 

5.26   Task Dimension

The measures below in (*) black are mapped to the Task dimension, those in grey are not mapped.

Course Measures

  • Enrolment Measures
    • Course Enrolments
    • (*) Enrolment Activities
    • (*) Enrolment Activities Max Date
    • Enrolment Contact
    • Enrolment Hours
    • (*) Enrolment Tasks
    • Students
    • Training Contracts
    • Unit Enrolments
  • Programme Measures
    • Class Attendances
    • Class Attendances Present
    • Classes
    • Occurrences
    • Waitlist
  • VET FEE Help Measures
    • VFH Amount Charged
    • VFH Enrolments
    • VFH Loan Fee
    • VFH Paid Upfront

Finance Measures

  • Expense Measures
    • Occurrence Cost Amount
    • Occurrence Cost Budget Amount
    • Occurrence Cost Budget Amount GST
    • Occurrence Cost GST
  • Forecast Measures
    • Funded Forecast Amount
    • Funded Forecast Hours
  • Income Measures
    • Funded Payment Hours
    • Holding Transfer Amount
    • Invoiced Amount
    • Payment Amount
    • Scheduled Invoice Amount

Student Measures

  • Attributes
  • Student Award or Statement
  • Event Measures
    • Event Participants
    • Events
  • Placement Measures
    • Student Placement Charge
    • Student Placement Count
    • Student Placement Hours
    • Student Wage

Task Enrolment Complete Date CYH

Completion date of the task in Calendar Year Hierarchy form

Task Enrolment Complete Date FYH

Completion date of the task in Financial Year Hierarchy form

Task Enrolment Insert Date CYH

Insert date of the task in Calendar Year Hierarchy form

Task Enrolment Insert Date FYH

Insert date of the task in Financial Year Hierarchy form

Task Enrolment Start Date CYH

Start date of the task in Calendar Year Hierarchy form

Task Enrolment Start Date FYH

Start date of the task in Financial Year Hierarchy form

Task Enrolment Update Date CYH

Update date of the task in Calendar Year Hierarchy form

Task Enrolment Update Date FYH

Update date of the task in Financial Year Hierarchy form

Assigned Staff Member

First name and last name of the staff member the enrolled task is assigned to

Enrolment Task Inserted By

First name and last name of the VETtrak user who created the task

Enrolment Task Updated By

Fist name and last name of the VETtrak user who last updated the task

Task Active

Possible values: “Active” or “Not Active”

Task Category Code

Code of the Task Category as entered into the Task Category Wizard in VETtrak

Task Category Name

Name of the Task Category as entered into the Task Category Wizard in VETtrak

Task Code

Code of the Task as entered into the Task Wizard in VETtrak

Task Enrolment Complete Date Full

Completion date of the task

Task Enrolment Insert Date Full

Creation date of the task

Task Enrolment Percentage

The percentage result of this task enrolment

Task Enrolment Start Date Full

Start date of the task

Task Enrolment Update Date Full

Last update date of the task

Task Name

Name of the Task as entered into the Task Wizard in VETtrak

Task Status Name

Status name of the Task as can be configured in the Task Status Wizard

 

5.27   Training Contract Dimension

The measures below in (*) black are mapped to the Training Contract dimension, those in grey are not mapped.

Course Measures

  • Enrolment Measures
    • (*) Course Enrolments
    • (*) Enrolment Activities
    • (*) Enrolment Activities Max Date
    • (*) Enrolment Contact
    • (*) Enrolment Hours
    • (*) Enrolment Tasks
    • (*) Students
    • (*) Training Contracts
    • (*) Unit Enrolments
  • Programme Measures
    • Class Attendances
    • Class Attendances Present
    • Classes
    • Occurrences
    • Waitlist
  • VET FEE Help Measures
    • VFH Amount Charged
    • VFH Enrolments
    • VFH Loan Fee
    • VFH Paid Upfront

Finance Measures

  • Expense Measures
    • Occurrence Cost Amount
    • Occurrence Cost Budget Amount
    • Occurrence Cost Budget Amount GST
    • Occurrence Cost GST
  • Forecast Measures
    • (*) Funded Forecast Amount
    • (*) Funded Forecast Hours
  • Income Measures
    • Funded Payment Hours
    • Holding Transfer Amount
    • (*) Invoiced Amount
    • (*) Payment Amount
    • (*) Scheduled Invoice Amount

Student Measures

  • Attributes
  • Student Award or Statement
  • Event Measures
    • (*) Event Participants
    • (*) Events
  • Placement Measures
    • (*) Student Placement Charge
    • (*) Student Placement Count
    • (*) Student Placement Hours
    • (*) Student Wage

Contract Commence Date CYH

Commence date of the training contract in Calendar Year Hierarchy form

Contract Commence Date FYH

Commence date of the training contract in Financial Year Hierarchy form

Contract Complete Date CYH

Completion date of the training contract in Calendar Year Hierarchy form

Contract Complete Date FYH

Completion date of the training contract in Financial Year Hierarchy form

Contract Code

Code as entered into page 1 of the Contract Wizard in VETtrak. This code field has different names depending on the State:

ACT - Sequence No.

NSW - TCID/TAID

NT - Contract code

QLD - Regn No

SA - COT No

Tas - Trg Agmt No

Vic - Regn No

WA - TRS No

Other/Overseas - Contract code

Contract Commence Date Full

Commence date of the training contract

Contract Complete Date Full

Completion date of the training contract

Contract Status

Current status of the training contract

Contract Type

Contract type as selected in the Contract Wizard in VETtrak

Training Contract Inserted By

First and last name of the VETtrak user who created this contract

Training Contract Last Updated By

First and last name of the VETtrak user who last updated this contract

 

5.28   Unit Dimension

The measures below in (*) black are mapped to the Unit dimension, those in grey are not mapped.

Course Measures

  • Enrolment Measures
    • Course Enrolments
    • (*) Enrolment Activities
    • (*) Enrolment Activities Max Date
    • Enrolment Contact
    • (*) Enrolment Hours
    • Enrolment Tasks
    • Students
    • Training Contracts
    • (*) Unit Enrolments
  • Programme Measures
    • Class Attendances
    • Class Attendances Present
    • Classes
    • Occurrences
    • Waitlist
  • VET FEE Help Measures
    • VFH Amount Charged
    • VFH Enrolments
    • VFH Loan Fee
    • VFH Paid Upfront

Finance Measures

  • Expense Measures
    • Occurrence Cost Amount
    • Occurrence Cost Budget Amount
    • Occurrence Cost Budget Amount GST
    • Occurrence Cost GST
  • Forecast Measures
    • (*) Funded Forecast Amount
    • (*) Funded Forecast Hours
  • Income Measures
    • Funded Payment Hours
    • Holding Transfer Amount
    • (*) Invoiced Amount
    • (*) Payment Amount
    • (*) Scheduled Invoice Amount

Student Measures

  • Attributes
  • Student Award or Statement
  • Event Measures
    • Event Participants
    • Events
  • Placement Measures
    • Student Placement Charge
    • Student Placement Count
    • Student Placement Hours
    • Student Wage

End Date CYH

Actual end date of the enrolled unit in Calendar Year Hierarchy form

End Date FYH

Actual end date of the enrolled unit in Financial Year Hierarchy form

Planned End Date CYH

Planned end date of the enrolled unit in Calendar Year Hierarchy form as entered into the Training Plan Wizard

Planned End Date FYH

Planned end date of the enrolled unit in Financial Year Hierarchy form as entered into the Training Plan Wizard

Planned Start Date CYH

Planned start date of the enrolled unit in Calendar Year Hierarchy form as entered into the Training Plan Wizard

Planned Start Date FYH

Planned start date of the enrolled unit in Financial Year Hierarchy form as entered into the Training Plan Wizard

Start Date CYH

Actual start date of the enrolled unit in Calendar Year Hierarchy form

Start Date FYH

Actual start date of the enrolled unit in Financial Year Hierarchy form

AVETMISS Reporting Flag

Possible values: “State Reportable”, “Not Reportable” or “Nationally Reportable”

Result Name

Current result of the unit. Result names can be configured in the Result Type Wizard

Result Recorded By

First name and last name of the VETtrak user who recorded the current result of the unit

Unit Code

Code of the Unit or Module

Unit Code Type

Possible values: “National Code” or “State Code”

Unit End Date Full

Actual end date of the unit

Unit Name

Name of the Unit or Module

Unit Planned End Date Full

Planned end date of the unit as entered into the Training Plan Wizard

Unit Planned Start Date Full

Planned start date of the unit as entered into the Training Plan Wizard

Unit Start Date Full

Actual start date of the unit

 

5.29   VETFEE Help Dimension

The measures below in (*) black are mapped to the VETFEE Help dimension, those in grey are not mapped.

Course Measures

  • Enrolment Measures
    • Course Enrolments
    • Enrolment Activities
    • Enrolment Activities Max Date
    • Enrolment Contact
    • Enrolment Hours
    • Enrolment Tasks
    • Students
    • Training Contracts
    • Unit Enrolments
  • Programme Measures
    • Class Attendances
    • Class Attendances Present
    • Classes
    • Occurrences
    • Waitlist
  • VET FEE Help Measures
    • (*) VFH Amount Charged
    • (*) VFH Enrolments
    • (*) VFH Loan Fee
    • (*) VFH Paid Upfront

Finance Measures

  • Expense Measures
    • Occurrence Cost Amount
    • Occurrence Cost Budget Amount
    • Occurrence Cost Budget Amount GST
    • Occurrence Cost GST
  • Forecast Measures
    • Funded Forecast Amount
    • Funded Forecast Hours
  • Income Measures
    • Funded Payment Hours
    • Holding Transfer Amount
    • Invoiced Amount
    • Payment Amount
    • Scheduled Invoice Amount

Student Measures

  • Attributes
  • Student Award or Statement
  • Event Measures
    • Event Participants
    • Events
  • Placement Measures
    • Student Placement Charge
    • Student Placement Count
    • Student Placement Hours
    • Student Wage

Commencement Date CYH

Commencement date of the VET Fee Help enrolment in Calendar Year Hierarchy form

Commencement Date FYH

Commencement date of the VET Fee Help enrolment in Financial Year Hierarchy form

Admission Basis

Possible values: “Not a commencing student”, “Higher education course”, “Secondary education”, “VET award course”, “Mature aged special entry provision”, “Professional qualification”, “Other basis” or “Not specified”

Attendance Type

Possible values: “Full time”, “Part time” or “Not specified”

Commencement Date Full

Full date of the VET Fee Help enrolment commencement date

Completion Status

Possible values: “Not completed”, “Completed” or “Riscind Completion”

Completion Year

Year of the VET Fee Help enrolment completion

Study Reason

Reason for study. Possible values are the same as the national study reason list (STUDYREASON.STRE_CODE where STAT_ID is null), and the following additional entries:

0 = Not a commencing student

99 = No information provided

 

5.30   Waitlist Dimension

The measures below in (*) black are mapped to the Waitlist dimension, those in grey are not mapped.

Course Measures

  • Enrolment Measures
    • Course Enrolments
    • Enrolment Activities
    • Enrolment Activities Max Date
    • Enrolment Contact
    • Enrolment Hours
    • Enrolment Tasks
    • Students
    • Training Contracts
    • Unit Enrolments
  • Programme Measures
    • Class Attendances
    • Class Attendances Present
    • Classes
    • Occurrences
    • (*) Waitlist
  • VET FEE Help Measures
    • VFH Amount Charged
    • VFH Enrolments
    • VFH Loan Fee
    • VFH Paid Upfront

Finance Measures

  • Expense Measures
    • Occurrence Cost Amount
    • Occurrence Cost Budget Amount
    • Occurrence Cost Budget Amount GST
    • Occurrence Cost GST
  • Forecast Measures
    • Funded Forecast Amount
    • Funded Forecast Hours
  • Income Measures
    • Funded Payment Hours
    • Holding Transfer Amount
    • Invoiced Amount
    • Payment Amount
    • Scheduled Invoice Amount

Student Measures

  • Attributes
  • Student Award or Statement
  • Event Measures
    • Event Participants
    • Events
  • Placement Measures
    • Student Placement Charge
    • Student Placement Count
    • Student Placement Hours
    • Student Wage

Insert Date CYH

Insert date of the waitlist entry in Calendar Year Hierarchy form

Insert Date FYH

Insert date of the waitlist entry in Financial Year Hierarchy form

Client Waitlist Inserted By

First and last name of the staff member in VETtrak who created the waitlist entry

Insert Date Full

Full date of when the waitlist entry was inserted

Referral Source

Referral source of the waitlist entry

 

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.