VETtrak Data Insight Help

Version 18.1.0.0

This resource is a complete listing of the database objects available to you as part of the VETtrak Data Insight System. A list of tables is provided on the left for quick reference and access to the relevant section.

Address

Holds addresses for clients, employers and locations.

Fields

Name Type Description
Unit Text The level/unit details of the address in AVETMISS 7 format. eg. "Apartment 113", "Unit N15", "Level 4", "Suite 21A Level 8".
Building Text The building/property details of the address in AVETMISS 7 format. eg. "Government House", "Downton Abbey".
Street number Text The street number of the address in AVETMISS 7 format. eg. "103", "340-346", "Lot 65".
Street name Text The street name of the address in AVETMISS 7 format. eg. "Smith Avenue", "The Avenue West", "Brown Road North East", "The Esplanade", "High Street Road".
City Text The suburb/city/town of the address in AVETMISS 7 format.
Postcode Text The postcode of the address in AVETMISS 7 format.
PO Box Text Postal delivery box details. Only used for postal addresses, do not populate this field for physical (client residential/usual and business) addresses. eg. "PO Box 88", "RMB 123", "CARE PO".

Relations

Name Description
State State of the address.

ANZSCO

Holds Australian and New Zealand Standard Classifications of Occupations.

Fields

Name Type Description
Name Text Name of ANZSCO.
Code Text Code of ANZSCO.
Archived Yes or no Whether the ANZSCO is archived.

ANZSIC

Holds Australian and New Zealand Standard Industrial Classifications.

Fields

Name Type Description
Name Text Name of the ANZSIC.
Code Text Code of the ANZSIC.
Archived Yes or no Whether the ANZSIC is archived.

Application

Contains applications that use the database.

Fields

Name Type Description
Name Text Name of application.
Short name Text Short name of application.

Attendance

Holds client class attendance.

Fields

Name Type Description
Start date Date and time Start date of attendance.
Finish date Date and time Finish date of attendance.
Notes Text Block Notes for attendance.
Created date Date and time Date record was created.
Last updated date Date and time Date attendance was last updated.
Duration minutes Whole number Duration of attendance, in minutes, excluding breaks.

Relations

Name Description
Attendance type Type of attendance
Client class Client in the class.
Attendance reason Reason for the attendance. Not applicable for positive attendance types.
Application Application that was used to record the attendance. Has only been recorded since VETtrak version 18.1.

Attendance reason

Holds reasons for attendance.

Fields

Name Type Description
Name Text Name of attendance reason.
Code Text Code of attendance reason.
Approved Yes or no Whether this is an approved reason for absence.
Archived Yes or no Whether the attendance reason is archived.
Description Text Block Description of attendance reason.

Attendance type

Holds types of attendance.

Fields

Name Type Description
Name Text Name of attendance type.
Code Text Code of attendance type.
Type Lookup list Type of attendance type.
Archived Yes or no Whether the attendance type is archived.
Description Text Block Description of attendance type.

Attribute

Holds attributes.

Fields

Name Type Description
Name Text Name of attribute.
Code Text Code of attribute.
Archived Yes or no Whether the attribute is archived.
Description Text Block Description of the attribute.
Important Yes or no Whether the attribute is marked as important.

Award

Holds awards issued to clients.

Fields

Name Type Description
Parchment number Text Parchment number for the award.
Recorded date Date Date the award was recorded.
Completed date Date Date the training that lead to the award was completed. For awards in or prior to 2017, this will be the 01/01 of the completion year.
Issued Yes or no Whether the award has been issued.
Issued date Date Date the award was issued.
Reportability Lookup list Reportability of the award.
Licence number Text Licence number of the award.
Expiry date Date Expiry date of the award.
Document reference Text Reference to a file associated with the award.
Notes Text Block Notes for the award.
Created date Date and time Date the record was created.
Last updated date Date and time Date the record was last updated.
CVS submission status Lookup list Whether the award has been submitted to the online Certificate Verification Service. "Requires submission" can mean that the award has never been submitted, or it has been updated since it was last submitted and it needs to be re-submitted.

Relations

Name Description
Award type Type of the award.
Client Client that has the award.
Qualification Qualification/course of the award.
Enrolments Enrolments that are linked to the award.
Enrolled units Units that are linked to the award.
Organisation Organisation that issued the award.
Location Location that issued the award.
History History entries for the award.

Award history

Holds history for an award.

Fields

Name Type Description
Date Date Date of the award history entry.
Notes Text Block Notes for the award history entry.

Award type

Holds types of awards, such as Certificate and Statement of Attainment.

Fields

Name Type Description
Name Text Name of award type.
Code Text Code of award type.
Type Lookup list Type of award type.
Archived Yes or no Whether the award type is archived.
Description Text Block Description of the award type.

Cancellation reason

Holds reasons for enrolment cancellation.

Fields

Name Type Description
Name Text Name of cancellation reason.
Code Text Code of cancellation reason.
Archived Yes or no Whether the cancellation reason is archived.
Description Text Block Description of cancellation reason.

Class

Holds classes in occurrences.

Fields

Name Type Description
Code Text Code of class.
Start date Date and time Start date of class.
Finish date Date and time Finish date of class.
Notes Text Block Notes of class.
Total clients Whole number Total number of clients currently in the class.
Created date Date and time Date record was created.
Last updated date Date and time Date record was last updated.
Capacity Whole number Capacity of class.
Duration minutes Whole number Duration of the class in minutes, excluding breaks.

Relations

Name Description
Room Room of class.
Staff Staff member assigned to class.
Occurrence Occurrence that class is in.
Clients Clients that are in the class.
Units Occurrence enrolled units linked to the class.
Class type Type of the class.

Class type

Holds types of classes.

Fields

Name Type Description
Name Text Name of class type.
Code Text Code of class type.
Archived Yes or no Whether the class type is archived.
Description Text Block Description of class type.
Default Yes or no Whether this class type is the default for new classes.
Allow online check-in Yes or no Whether online check-in (through the Student Portal) is available for the class.

Client

Holds people, including students, staff members, and employer contacts.

Fields

Name Type Description
Code Text Unique VETtrak code of the client.
Surname Text Surname (or single name) of the client.
Given name Text Given name of the client. For a single name client, this field must be empty.
Other names Text Other names of the client, such as middle names. For a single name client, this field must be empty.
Title Text Title of client (Mr, Mrs, Miss, Ms, Dr etc).
Preferred name Text Preferred name of client.
Former surname Text Former surname of the client.
Gender Lookup list Gender of the client.
Date of birth Date Date of birth of the client.
Username Text Username of the client.
Password Text Password of the client.
Login disabled Yes or no Whether the client is barred from logging onto any VETtrak software.
Staff member Yes or no Whether the client is a staff member.
Archived Yes or no Whether this client is archived.
USI Text Unique Student Identifier of the client.
USI verification status Lookup list Verification status of the client's Unique Student Identifier.
USI verification date Date and time When this client's USI was last verified.
USI exempt Yes or no Whether this client is exempt from the USI scheme.
Email Text Email address of the client.
Email secondary Text Secondary email address for the client.
Email both Yes or no Whether to send email to both of the client's email addresses.
Mobile phone Text Mobile phone number of the client.
Mobile phone secondary Text Secondary mobile phone number for the client.
SMS both Yes or no Whether to send SMS messages to both of the client's mobile phone numbers.
Home phone Text Home phone number of the client.
Work phone Text Work phone number of the client.
Fax number Text Fax number of the client.
Preferred contact method Lookup list Preferred contact method for the client.
Exclude from marketing Yes or no Whether the client should be excluded from marketing emails and SMS messages.
Notes Text Block Notes for client.
External code Text Code for this client in an external system.
Emergency contact person Text Name of the emergency contact person for this client.
Emergency contact relationship Text Relationship of the emergency contact person for this client.
Emergency contact phone Text Phone number of the emergency contact person for this client.
Emergency contact mobile Text Mobile number of the emergency contact person for this client.
Citizenship status Lookup list Citizenship status of the client.
Identification confirmed Yes or no Whether the student's identification details have been confirmed.
Identification details Text Details of student identification provided.
Passport number Text Passport number of the client.
Visa number Text Visa number of the client.
Visa effective date Date Effective start date of the client's visa
Visa expiry date Date Expiry date of the Visa for the client.
Address type Lookup list Type of address for the client.
Problem payer Yes or no Whether the client is marked as a problem payer.
STA client number Text State training authority client identifier. The exact meaning depends on the state: VIC: DELTA Student No QLD: Learner Unique Id TAS: Trg Agmt Client ID SA: VETA/S4A Student No Other states: STA Client No
At school Lookup list Whether the client is still at school.
Year school completed Whole number Year client completed school.
Where school completed Text Where client completed school.
Proficiency in spoken English Lookup list Client's proficiency in spoken English.
Indigenous status Lookup list Client's indigenous status.
Has disability Lookup list Whether the client has disabilities.
Has prior education Lookup list Whether the client has prior education.
Web published Yes or no Whether the client is web published.
Town/city of birth Text Town/city of birth for client.
International residential area Text Client's international address residential area.
International residential address Text Block Client's international residential address.
International postal area Text Client's international address postal area.
International postal address Text Block Client's international postal address.
VIC VSN Text Victorian Student Number of client.
VIC VSN status Lookup list Status of VIC VSN.
VIC industry of employment Lookup list Victorian industry of employment of the client.
VIC occupation Lookup list Victorian occupation of client.
SA SACE student ID Text South Australian Certificate of Education identifier for the client.
Nationality Text Nationality of the client.
Job seeker ID Text Centrelink Job Seeker ID for the client.
Centrelink reference number (CRN) Text Centrelink Reference Number (CRN) for the client.
CRN expiry date Date Centrelink Reference Number expiry date for the client.
Created date Date and time Date the record was created.
Last update date Date and time Date the record was last updated.

Relations

Name Description
Enrolments Enrolments for the client, including contract, non-contract, occurrence and employee enrolments.
Contracts Contracts for the client.
Awards Awards issued to the client.
Employer (primary) Primary employer of the client.
Employment Employment records and history for the client.
Usual address Usual address of the client, in AVETMISS 7 format.
Postal address Postal address of the client, in AVETMISS 7 format.
Manager (primary) Client that is the primary manager of this client.
Managed clients (primary) Primary clients that are managed by this client.
Division Security division that this client is in.
Visa type Type of Visa for the client.
Events Events for the client.
Attributes Attributes that are assigned to the client.
Groups Groups that this client is in.
Classes Classes that the client is in.
Placements Workplace placements for the client.
Waitlist Programmes that the client is on the waitlist for.
Contact for employers Employers that the client is a contact for.
Country of birth Country of birth of the client. Empty if not stated.
Language spoken at home Client's language spoken at home. Empty if not stated.
Labour force status Employment category (labour force status) of client. Empty if not stated.
School level School level of client. Empty if not stated.
Disabilities Disabilities of the client.
Prior education Prior education of the client.
International residential country Client's international residential address country.
International postal country Client's international postal address country.
VET FEE-HELP client details Personal-level information for VET FEE-HELP about a client.
VET FEE-HELP enrolments A list of the selected client's VET FEE-HELP enrolments.
Passport country County of the client's passport
Holding Amounts transferred to or from holding for the client.
Survey contact status Client's survey contact status.
Skills Skills for the client.

Client attribute

Holds attributes assigned to clients.

Fields

Name Type Description
Notes Text Block Notes for the attribute assigned to the client.
Created date Date and time Date that this attribute was assigned to this client.

Relations

Name Description
Attribute Attribute that is assigned to the client.

Client class

Holds clients in classes.

Fields

Name Type Description
Created date Date and time Date the client was added to the class.
Confirmation status Lookup list Confirmation status for the client in the class.
Online check-in date Date and time The date when the client checked into the class online (via the Student Portal). Empty if the client has not checked-in online.

Relations

Name Description
Client Client that is in the class.
Class Class that the client is in.
Attendance Client attendance in the class.
Client enrolment Client occurrence enrolment related to this client in this class.

Client employment

Holds employment records for clients. Also holds a history of client employment.

Fields

Name Type Description
Primary Yes or no Whether the client employment record is the primary one for the client.
Archived Yes or no Whether the client employment record is archived.
Employee code Text Employee code for the client employment.
Salary Dollar Amount Salary for client employment.
Commencement date Date Commencement date for the client employment.
Date last assessed Date Last assessment date of the client employment.
Termination date Date Termination date of the client employment.

Relations

Name Description
Client Client that has the employment record.
Employer Employer for the client employment record.
Position Position for the client employment.
Employment type Type of the client employment.
Employer branch Employer branch of the client employment.
Manager Client employment record for the manager of this client employment.

Client employment type

Holds types of client employment.

Fields

Name Type Description
Name Text Name of client employment type.
Code Text Code of client employment type.
Archived Yes or no Whether the client employment type is archived.
Description Text Block Description of client employment type.

Client enrolment

Holds client enrolments, including contract and non-contract enrolments, client occurrence enrolments and employee enrolments.

Fields

Name Type Description
ID Whole number ID of enrolment.
Type Lookup list Type of the enrolment.
Start date Date Start date of enrolment.
Finish date Date Finish date of enrolment.
Notes Text Block Notes for enrolment.
Date of status change Date Date that the status of the enrolment was last changed.
Reportability Lookup list Reportability of the enrolment.
Amount Dollar Amount Total pricing amount for the enrolment, including any GST.
GST Dollar Amount Total GST pricing amount for the enrolment.
Amount paid Dollar Amount Total amount paid for the enrolment.
Amount adjusted Dollar Amount Total amount adjusted from the enrolment.
Government amount Dollar Amount Total amount of the enrolment to be government funded.
Payment status Lookup list Status of payment for the enrolment.
Confirmation status Lookup list Confirmation status for the enrolment.
Commencing status Lookup list AVETMISS commencing status for the enrolment.
VET in schools Yes or no Whether this is a VET In Schools enrolment.
Report employer as location Yes or no Whether to report the enrolment's employer as the location of the enrolment in AVETMISS.
Online enrolment date Date and time Date that the enrolment was made online. Empty if it is not an online enrolment.
Occurrence ID Whole number ID of occurrence the enrolment belongs to. Empty for a non-occurrence enrolment.
Transfer history Text Block History of transfer of this enrolment between occurrences. Only applicable for occurrence enrolments that have been transferred.
VIC enrolment date Date Date when the student legally agreed to undertake the training and incur any related costs for the enrolment.
VIC program commencement date Date Victorian training activity start date for the enrolment.
VIC PSTACD Date VIC Program Supervised Teaching Activity Completion Date for the enrolment.
VIC PUSH Whole number VIC Program Unique Supervised Hours for the enrolment.
VIC PUSH calculation method Lookup list How the enrolment's Program Unique Supervised Hours are automatically calculated for the enrolment.
VIC funding eligibility key Text VIC funding eligibility key for the enrolment.
VIC eligibility exemption Yes or no Whether the enrolment meets VIC eligibility exemption criteria.
VIC VET FEE-HELP Yes or no Whether enrolment is being delivered under VET FEE-HELP in VIC.
VIC VSN transfer Yes or no Whether to include the enrolment in VIC VSN transfers.
VIC eligibility Yes or no Whether evidence of student eligibility verified for the VIC enrolment.
VIC declaration Yes or no Whether student declaration signed in VIC.
NSW report type Lookup list How the NSW enrolment should be reported.
NSW enrolment status Lookup list Smart and Skilled reportable status of the NSW enrolment.
NSW provider calculator export Yes or no Whether the enrolment is to be included in NSW Smart and Skilled Provider Calculator exports, until it has a commitment ID.
QLD full time learning Yes or no Whether the enrolment is QLD full time learning.
WA intake number Text WA intake number for the enrolment.
WA fee model Lookup list How WA fees should be calculated for the enrolment.
ACT student file number Text ACT student file number for the enrolment.
Delivery modes Text Delivery modes for the enrolment. This is a string containing one letter per delivery mode, with the predominant delivery mode first.
Created date Date and time Date the record was created.
Date last updated Date and time Date the record was last updated.

Relations

Name Description
Client Client whom this enrolment belongs to.
Qualification Qualification/course for the enrolment.
Enrolled units Enrolled units in the enrolment.
Enrolled tasks Enrolled tasks in this enrolment.
Location Delivery location of enrolment.
Status Status of enrolment.
Cancellation reason Reason for the cancellation of the enrolment. Will be empty if not cancelled.
Employer Employer associated with client enrolment.
Employer contact Employer contact for the enrolment.
Events Events linked to this client enrolment.
Awards Awards linked to enrolment.
Organisation Organisation this enrolment belongs to.
Division Division for enrolment.
Enrolment type Type of the enrolment.
Referral source Referral source for enrolment.
Staff Staff members assigned to enrolment.
Occurrence Occurrence the client enrolment is in. Empty if this is not an occurrence enrolment.
Contract Contract that the enrolment is on.
Placements Placements associated with the enrolment.
Funding source Funding source for the enrolment. Empty if not government funded.
Purchasing contract Purchasing contract for the enrolment.
Delivery provider employer Employer that is the delivery provider for the enrolment.
Vocation Vocation for the enrolment.
Delivery type AVETMISS delivery type of enrolment.
Fee exemption Fee exemption type for the enrolment.
Study reason Study reason for enrolment.
Specific funding identifier Specific funding identifier for enrolment.
Funding model Funding model for pricing for the enrolment.
Linked child enrolments Client occurrence enrolments that are linked as children of this one.
Linked parent enrolments Client enrolments that are linked as parents of this one.
ANZSIC Australian and New Zealand Standard Industrial Classification for the enrolment.
Status history Status history entries for the enrolment.
VIC superseded enrolment Enrolment that is superseded by this enrolment.
VIC superseding enrolments Enrolments that supersede this enrolment.
NSW Smart and Skilled enrolment NSW Smart and Skilled data for the enrolment.
Related VET Student Loan enrolments The client's VET Student Loan courses of study that are related to this enrolment.
Client classes Client's classes that relate to this occurrence enrolment. Only relevant if this is an occurrence enrolment.
Payment history Imported payment history for the enrolment and all units in it.
Pricing Prices for the client enrolment.
VIC program enrolment Victorian program enrolment that is related to the enrolment.

Client enrolment staff

Staff assigned to a client enrolment.

Fields

Name Type Description
Primary Yes or no Whether this is the primary staff member for the enrolment.

Relations

Name Description
Staff type Type of staff member assigned to enrolment.
Staff Staff member assigned to enrolment.
Client enrolment Client enrolment the staff member is assigned to.

Client event

Holds events assigned to clients.

Fields

Name Type Description
Start date Date and time Start date of the client event.
Finish date Date and time Finish date of the client event. Will be empty for a milestone event.
Complete Yes or no Whether this client event is complete.
Notes Text Block Notes for the client event.
Show in calendar Yes or no Whether to show this event in the calendar.
Document reference Text Reference to a document linked to the client event.
Date last complete Date and time Date the event was last completed.

Relations

Name Description
Event type The type of this client event.
Client The client that this client event belongs to.
Enrolment The enrolment that this client event is linked to.
Contract Contract linked to client event.
Staff Staff member assigned to client event.
Parent employer event Employer event that the client event is grouped under.
User last complete The user that last set this event to complete.

Client prior education

Holds prior education for clients.

Fields

Name Type Description
Recognition identifier Lookup list Recognition identifier for client's prior education.

Relations

Name Description
Prior education Prior education for client.

Client skill

Holds skills belonging to clients.

Fields

Name Type Description
Date acquired Date Date the skill was acquired (start date).
Expiry date Date Date the client skill expires (end date).
Inactive Yes or no Whether the client skill is inactive.
Description Text Block Description of the client skill.

Relations

Name Description
Skill Skill that the client has.

Contract

Holds contracts, which represent apprenticeships and traineeships.

Fields

Name Type Description
Start date Date Start date of contract.
Finish date Date Finish date of contract.
Code Text Code of contract. The exact meaning depends on the state the contract is in: VIC and QLD: Regn No. NSW: TCID/TAID WA: TRS No. SA: COT No. TAS: Trg Agmt No. ACT: Sequence No.
Delta student number Text The Delta student number for the contract.
Postcode Text Postcode of contract.
Date of status change Date Date of status change for the contract.
Notes Text Block Notes for the contract.

Relations

Name Description
Client Client that is on the contract.
Employer Employer that is on the contract.
Qualification Qualification/course for the contract.
State State the contract is in.
Status Status of the contract.
Enrolments Client enrolments on the contract.
Contract type Type of the contract.
Employer contact Client that is the employer contact for the contract.
Organisation Organisation the contract belongs to.
Cancellation reason Reason for cancellation of the contract.
Vocation Vocation recorded on the contract.
RTO employer Employer that is the RTO for the contract.
NAC employer Employer that is the NAC for the contract.
Events Events linked to contract.
Staff Staff assigned to the contract.
Placements Placements associated with the contract.

Contract staff

Staff assigned to a contract.

Fields

Name Type Description
Primary Yes or no Whether this is the primary staff member for the contract.

Relations

Name Description
Staff type Type of staff member assigned to contract.
Staff Staff member assigned to contract.
Contract Contract the staff member is assigned to.

Contract type

Holds types of contracts.

Fields

Name Type Description
Name Text Name of contract type.
Code Text Code of contract type.
Archived Yes or no Whether the contract type is archived.
Description Text Block Description of contract type.

Country

Holds countries.

Fields

Name Type Description
Name Text Name of country.
Code Text AVETMISS code of country.
Archived Yes or no Whether the country is archived.

Credential

Holds definitions of credentials that can be assigned to staff members.

Fields

Name Type Description
Code Text Code of credential.
Name Text Name of credential.
Status Lookup list Status of credential.
Expiry months Whole number Number of months after which this credential expires. 0 for no expiry.
Archived Yes or no Whether the credential is archived.
Notes Text Block Notes for credential.

Relations

Name Description
Credential type Type of credential.

Credential type

Holds types of credentials.

Fields

Name Type Description
Name Text Name of credential type.

Credit term

Contains credit terms for invoices.

Fields

Name Type Description
Name Text Name of credit term.
Code Text Code of credit term.
Days Whole number Days of credit term.
Calculation method Lookup list How the days are applied to calculate invoice due dates.
Default for new clients Yes or no Whether the credit term is the default for new clients.
Default for new employers Yes or no Whether the credit term is the default for new employers.
Archived Yes or no Whether the credit term is archived.
Notes Text Block Notes for credit term.

Delivery strategy

Holds delivery strategies for units. Used mainly in WA.

Fields

Name Type Description
Name Text Name of delivery strategy.
Code Text Code of delivery strategy.
Archived Yes or no Whether delivery strategy is archived.
Description Text Block Description of delivery strategy.

Delivery type

Holds AVETMISS delivery types.

Fields

Name Type Description
Name Text Name of delivery type.
Code Text Code of delivery type.

Disability

Holds disability entries.

Fields

Name Type Description
Name Text The name of the disability.
Code Text The AVETMISS code of the disability.

Division

Divisions are a hierarchical structure. Clients are assigned to a division, and security access is granted to divisions to control which users have access to client's records.

Fields

Name Type Description
Name Text Name of the division.
Code Text Code of the division.
Archived Yes or no Whether this division is archived.
Description Text Block Description of division.

Relations

Name Description
Parent division Division that is the parent of this one.
Child divisions Divisions that are children of this one.
Ancestor divisions Divisions that are an ancestor of this one. That is, divisions that are a parent of this one, or a parent of a parent of this one etc, all the way up the division tree. Note: This will also include the division you are starting with.
Descendant divisions Divisions that are a descendant of this one. That is, divisions that are a child of this one, or a child of a child of this one etc, all the way down the division tree. Note: This will also include the division you are starting with.

Employer

Holds companies.

Fields

Name Type Description
ID Whole number Unique ID of the employer.
Name Text Unique name of the employer.
Legal name Text Legal name of employer.
Code Text User code of employer.
Email Text Email address of employer.
Phone Text Phone number of employer.
Mobile Text Mobile phone number of employer.
Fax Text Fax number of employer.
Website URL Text Website URL address for employer.
ABN Text ABN of employer.
ACN Text ACN of employer.
External code Text External code of employer.
Prefix Text Client code prefix for employer.
Type Lookup list Whether employer is an RTO (delivery provider) or NAC/AAC.
Number of employees Whole number Number of employees for employer.
Exclude from marketing Yes or no Whether the employer is excluded from marketing emails and SMS.
Notes Text Block Notes for the employer.
Problem payer Yes or no Whether the employer is flagged as a problem payer.
Address type Lookup list Type of employer address.
International business address Text Block International business address of the employer.
International postal address Text Block International postal address of the employer.
Date created Date and time Date the record was created.
Date last updated Date and time Date the record was last updated.

Relations

Name Description
Employer type Type of the employer.
Business address Business address of the employer, in AVETMISS 7 format.
Postal address Postal address of the employer, in AVETMISS 7 format.
Employees Employee clients of the employer.
Events Events for the employer.
Attributes Attributes assigned to the employer.
Associated client enrolments Client enrolments (contract, non-contract and occurrence enrolments) that are linked to the employer.
Associated occurrences Occurrences the employer is related to.
Contracts Contracts for the employer.
Placements Workplace placements for the employer.
Delivery provider for enrolments Client enrolments where this employer is the delivery provider.
Delivery provider for enrolled units Enrolled units where this employer is the delivery provider.
Parent employer Employer that is the parent of this one.
Child employers Employers that are children of this one.
Employer contacts Contact clients for the employer.
ANZSIC ANZSIC for the employer.
Holding Amounts transferred to or from holding for the employer.
Branches Branches of the employer.
International business address country Country of the international business address for the employer.
International postal address country Country of the international postal address for the employer.

Employer attribute

Holds attributes assigned to employers.

Fields

Name Type Description
Notes Text Block Notes for the attribute assigned to the employer.
Created date Date and time Date that this attribute was assigned to this employer.

Relations

Name Description
Attribute Attribute that is assigned to the employer.

Employer branch

Holds branches for employers.

Fields

Name Type Description
Name Text Name of branch.
Code Text Code of branch.
Archived Yes or no Whether the branch is archived.
Description Text Block Description of branch.
Address type Lookup list Type of the branch's address.
International address Text Block International address of the branch.

Relations

Name Description
Region Region that the branch belongs to.
Address Address of the branch.

Employer contact

Holds client contacts for employers.

Fields

Name Type Description
Is primary Yes or no Whether this client is the primary contact for this employer.
Allow portal access Yes or no Whether the employer contact has access to the Progress Web Portal.

Relations

Name Description
Employer Employer that has this contact.
Client Client that is a contact for the employer.
Contact for client enrolments Client enrolments this client is a contact on.
Contact for occurrences Occurrences this client is the employer contact for.
Contact for contracts Contracts this client is a contact on.
Contact for placements Placements the client is a contact for.

Employer event

Holds events assigned to employers.

Fields

Name Type Description
Start date Date and time Start date of the employer event.
Finish date Date and time Finish date of the employer event. Will be empty for a milestone event.
Complete Yes or no Whether this employer event is complete.
Notes Text Block Notes for the employer event.
Show in calendar Yes or no Whether to show this event in the calendar.
Document reference Text Reference to a document linked to the employer event.
Date last complete Date and time Date the event was last completed.

Relations

Name Description
Event type The type of this employer event.
Staff Staff member assigned to employer event
Client events Client events that are grouped under the employer event.
User last complete The user that last set this event as complete.

Employer type

Holds types of employers.

Fields

Name Type Description
Name Text Unique name of the employer type.
Code Text Code of the employer type.
Description Text Block Notes for the employer type.
Archived Yes or no Whether the employer type is archived.
Jobactive Yes or no Whether the employer type represents Jobactive employers.

Employment category

Holds AVETMISS employment categories (labour force statuses).

Fields

Name Type Description
Name Text Name of employment category.
Code Text AVETMISS code of employment category.

Enrolled unit

Holds enrolled units.

Fields

Name Type Description
Start date Date Start date of enrolled unit result.
Finish date Date Finish date of enrolled unit result.
Reportability Lookup list Reportability of the enrolled unit.
Percentage Whole number Percentage result for the enrolled unit. -1 if no percentage is recorded.
Points Whole number Number of points for the enrolled unit. -1 if no points are recorded.
Hours Whole number Number of hours for the enrolled unit.
Hours customised Yes or no Whether the number of hours on this enrolled unit were changed from the default for the unit.
Withdrawn hours Whole number Number of actual hours for a withdrawn unit.
Notes Text Block Notes for the enrolled unit.
Claim date Date Date that the enrolled unit was claimed.
Paid date Date Date the enrolled unit was paid.
Amount Dollar Amount Total pricing amount for the enrolled unit, including any GST.
GST Dollar Amount GST amount of the enrolled unit.
Government amount Dollar Amount Total of government pricing amounts for the enrolled unit.
Tuition fee amount Dollar Amount Amount of the tuition fee last reported for the enrolled unit.
Expiry date Date Expiry date of the enrolled unit.
Sequence Whole number Sequence number for the enrolled unit.
Start order Whole number Starting order of the enrolled unit.
Stage Whole number Stage number of the enrolled unit.
Planned start date Date Planned start date of enrolled unit.
Planned finish date Date Planned finish date for the enrolled unit.
Assessment mode Text Assessment mode for the enrolled unit.
Date 1 Date Date 1 for the enrolled unit.
Comment 1 Text Comment 1 for the enrolled unit.
Date 2 Date Date 2 for the enrolled unit.
Comment 2 Text Comment 2 for the enrolled unit.
Date 3 Date Date 3 for the enrolled unit.
Comment 3 Text Comment 3 for the enrolled unit.
Date 4 Date Date 4 for the enrolled unit.
Comment 4 Text Comment 4 for the enrolled unit.
Date 5 Date Date 5 for the enrolled unit.
Comment 5 Text Comment 5 for the enrolled unit.
Commencing status Lookup list AVETMISS commencing status for the enrolled unit.
VIC enrolment date Date Date when the student legally agreed to undertake the training and incur any related costs for the enrolled unit.
VIC program commencement date Date Victorian training activity start date for the enrolled unit.
VIC funding eligibility key Text VIC funding eligibility key for the enrolled unit.
VIC eligibility exemption Yes or no Whether the enrolled unit meets VIC eligibility exemption criteria.
VIC VET FEE-HELP Yes or no Whether enrolled unit is being delivered under VET FEE-HELP in VIC.
Delivery modes Text Delivery modes for the enrolled unit. This is a string containing one letter per delivery mode, with the predominant delivery mode first.
WA funding removed Yes or no Whether WA funding has been removed for the enrolled unit.
WA employer invoiced Yes or no Whether an employer has been invoiced for this enrolled unit.
Date created Date and time Date the record was created.
Date last updated Date and time Date the record was last updated.
Date result last recorded Date and time Date that a result was last recorded for the enrolled unit.
Date result last reset Date Date when this enrolled unit's result was last reset. Empty if the result has never been reset.

Relations

Name Description
Enrolment Enrolment that the unit is in.
Unit Unit that is in the enrolment.
Result type Result type of the enrolled unit. Empty if it does not have a result.
Qualification Qualification/course for the enrolled unit.
Awards Awards linked to enrolled unit.
Staff Staff member associated with the enrolled unit.
Delivery strategy Delivery strategy for the enrolled unit.
Funding source Funding source for the enrolled unit. Empty if not government funded.
Purchasing contract Purchasing contract for the enrolled unit.
Delivery type AVETMISS delivery type for the enrolled unit.
Location Location for the delivery of the enrolled unit.
Study reason Study reason for the enrolled unit.
Fee exemption Fee exemption for the enrolled unit.
ANZSIC Australian and New Zealand Standard Industrial Classification for the enrolled unit.
Delivery provider employer Delivery provider employer for the enrolled unit.
Staff last recorded result Staff member that last recorded a result for the enrolled unit.
Related VET Student Loan units of study Client's VET Student Loan units of study that are related to this enrolled unit.
Task enrolments Enrolled tasks linked to the enrolled unit.
Payment history Imported payment history for the enrolled unit.
Enrolment pricing Enrolment pricing for enrolled unit.
Occurrence pricing Occurrence pricing for unit.
Unit cluster Cluster the unit came from.

Enrolment price

Contains prices for enrolments and contracts.

Fields

Name Type Description
Amount Dollar Amount Amount of enrolment price, including any GST.
GST Dollar Amount GST amount of enrolment price.
Surcharge amount Dollar Amount Amount of the surcharge, which is included in the total Amount.
Surcharge GST Dollar Amount GST of the surcharge, which is included in the total GST.

Relations

Name Description
Invoice item Invoice item that the enrolment price is invoiced in, or is scheduled to be invoiced in.
Client enrolment Client enrolment that the price is on. Each price will have either a Client Enrolment or Contract set, not both.
Contract Contract that the price is on. Each price will have either a Client Enrolment or Contract set, not both.
Pricing item Pricing item for enrolment price. Each price will have either a Pricing Item or an Inventory Item, not both.
Inventory item Inventory item for enrolment price. Each price will have either a Pricing Item or an Inventory Item, not both.
Enrolled unit Enrolled unit that is being priced. Will not be specified if the price is not at the enrolled unit level.
VET Student Loans unit of study VET Student Loans unit of study that is being priced. Will not be specified if the price is not at the VET Student Loans unit of study level.
Ledger Ledger for the enrolment price.

Enrolment type

Holds types of enrolments.

Fields

Name Type Description
Name Text Name of enrolment type.
Code Text Code of enrolment type.
Archived Yes or no Whether the enrolment type is archived.
Description Text Block Description of enrolment type.

Event type

Holds event types.

Fields

Name Type Description
Name Text Name of the event type.
Code Text Code of the event type.
Archived Yes or no Whether the event type is archived.
Description Text Block Description of the event type.
Included in VIC PUSH calculations Yes or no Whether events of this type are included in Program Unique Supervised Hours calculations in Victoria.

Fee exemption

Holds fee exemptions.

Fields

Name Type Description
Name Text Name of fee exemption.
Code Text Code of fee exemption.
Archived Yes or no Whether fee exemption is archived.
Description Text Block Description of fee exemption.
Tuition fee concession Lookup list How tuition fees are calculated for the fee exemption.

Relations

Name Description
State State of the fee exemption.

Field of education

Holds AVETMISS fields of education.

Fields

Name Type Description
Name Text Name of the field of education.
Code Text AVETMISS code of field of education.
Type Lookup list Whether the field of education applies to qualifications or units.

Funding model

Holds funding model for pricing enrolments.

Fields

Name Type Description
Name Text Name of funding model.
Code Text Code of funding model.
Archived Yes or no Whether the funding model is archived.
Description Text Block Description of funding model.

Relations

Name Description
State State that the funding model applies to.
Organisation Organisation that the funding model belongs to.
Qualification Qualification/course that funding model can apply to.

Funding source

Holds reportable funding sources.

Fields

Name Type Description
Name Text Name of funding source.
Code Text Code of funding source.
Archived Yes or no Whether this funding source is archived.
Description Text Block Description of funding source.

Relations

Name Description
State State that the funding source is for. Empty for a nationally-reportable funding source.
National funding source National funding source for this funding source.

Funding source national

Holds national funding sources.

Fields

Name Type Description
Name Text Name of national funding source.
Code Text Code of national funding source.

Group

Holds groups.

Fields

Name Type Description
Name Text Name of group.
Code Text Code of group.
Archived Yes or no Whether the group is archived.
Description Text Block Description of the group.

Relations

Name Description
Parent group Group that is the parent of this one.
Child groups Groups that are children of this group.
Division Division this group belongs to.
Clients Clients that are in this group.

Holding

Contains amounts in holding for clients and employers. These are unallocated amounts that have been set aside for clients or employers. Contains both amounts transferred from payments to holding, and amounts transferred from holding to payments.

Fields

Name Type Description
Amount Dollar Amount Amount of holding entry. Positive for amounts transferred to holding, negative for amounts transferred from holding.
Date Date and time Date when this amount was transferred to or from holding.
Notes Text Block Notes for holding entry.

Relations

Name Description
Payment Payment that this holding entry was transferred from or to.
Client Client that owns this holding entry, if applicable. Each holding entry will have either a Client or Employer, not both.
Employer Employer that owns this holding entry, if applicable. Each holding entry will have either a Client or Employer, not both.
Taken from holding entry The holding entry that this was transferred from, to the payment indicated by Payment. Only applicable for amounts transferred from holding to a payment, in which case the Amount will be negative.

Inventory item

Contains inventory items that can be put on invoices.

Fields

Name Type Description
Name Text Name of inventory item.
Code Text Code of inventory item.
Amount Decimal number Default price of the inventory item, including any GST.
GST Decimal number GST amount of inventory item.
Archived Yes or no Whether the inventory item is archived.
Notes Text Block Notes for the inventory item.

Relations

Name Description
Default ledger Default ledger for the inventory item when it is put on invoices.

Invoice

Contains invoices.

Fields

Name Type Description
Invoice date Date Date of invoice.
Invoice number Text Number of invoice.
Order number Text Order number of invoice.
Payment status Lookup list Current payment status of invoice.
Amount Decimal number Total amount of invoice, including any GST.
GST Decimal number GST amount of invoice.
Amount paid Decimal number Total amount of invoice that has been paid.
Amount adjusted Decimal number Total amount of invoice that has been adjusted.
Due date Date Due date of invoice.
External invoice number Text Number of this invoice in an external system.
External payment status Lookup list Payment status of invoice in an external system.
External payment date Date Payment date of the invoice in an external system.
Exported date Date Date the invoice was exported.
Exported batch Whole number Number of the batch that the invoice was exported in.
Notes Text Block Notes for invoice.
Created date Date and time Date the record was created.
Last update date Date and time Date the record was last updated.

Relations

Name Description
Invoice items Line items that are on the invoice.
Client Invoiced client. Each invoice will have either a client or employer, but not both.
Employer Invoiced employer. Each invoice will have either a client or employer, but not both.
Employer contact Employer contact for the invoice. Only available for employer invoices.
Credit term Credit term for invoice.
Organisation Organisation of invoice.

Invoice item

Contains line items on invoices. Also contains scheduled invoice items that have not been generated onto an invoice yet.

Fields

Name Type Description
Amount Decimal number Amount of the invoice item, including any GST.
GST Decimal number GST amount of the invoice item.
Description Text Description of the invoice line item.
Quantity Whole number Quantity of the invoice item. Only applicable for "loose" inventory items added directly to the invoice.
Schedule generate date Date Date when this invoice item will be scheduled onto a generated invoice.
Schedule invoicee Lookup list Indicates the invoicee that this invoice item will be invoiced to when generated in a scheduled invoice.
Schedule separately Yes or no Whether this invoice item will go into a separate invoice when scheduled invoice is generated.
Schedule payment due Date The due date of the invoice generated from this scheduled invoice item. Only applicable if "Schedule separately" is Yes.
Created date Date and time Date that the record was created.
Last update date Date and time Date that the record was last updated.

Relations

Name Description
Invoice Invoice that the invoice item is on. Will be empty if the invoice item is scheduled, but has not yet been invoiced.
Enrolment price Enrolment price that this invoice item is invoicing. Will be empty for "loose" inventory items put directly onto the invoice.
Inventory item "Loose" inventory item that has been put directly onto the invoice. Will be empty if an enrolment price is invoiced. For inventory items that have come from an enrolment price, they are accessed via the "Enrolment price" relation instead.
Ledger Ledger for the invoice item.
Schedule employer invoicee Employer that will be invoiced when this invoice item is generated onto an invoice. Only applicable if "Schedule invoicee" is "Specific employer".
Payment disbursements Disbursements of the invoice item in payments.

Language

Holds languages.

Fields

Name Type Description
Name Text Name of language.
Code Text AVETMISS code of language.
Archived Yes or no Whether the language is archived.

Ledger

Contains ledgers that can be assigned to pricing.

Fields

Name Type Description
Name Text Name of ledger.
Code Text Code of ledger.
Archived Yes or no Whether the ledger is archived.
Notes Text Block Notes for the ledger.

Location

Holds locations for training activity.

Fields

Name Type Description
Name Text Name of location.
Code Text Code of location.
Archived Yes or no Whether the location is archived.
Description Text Block Description of location.

Relations

Name Description
State State that location is in.
Region Region that location is in.
Address Physical address of location, in AVETMISS 7 format.

NSW Smart and Skilled enrolment

Holds NSW Smart and Skilled data for an enrolment.

Fields

Name Type Description
Commitment ID Text NSW Smart and Skilled Commitment ID.
Status Lookup list NSW Smart and Skilled status.
Notified date Date NSW Smart and Skilled notified date.
Expiry date Date NSW Smart and Skilled expiry date.
Cancelled date Date NSW Smart and Skilled cancelled date.
Complete Yes or no Whether the enrolment is complete and is to no longer be reported to NSW Smart and Skilled.
Student fee Dollar Amount NSW Smart and Skilled student fee for enrolment.
Needs loading amount Dollar Amount NSW Smart and Skilled needs loading amount for the enrolment.
Location loading amount Dollar Amount NSW Smart and Skilled location loading amount for the enrolment.
Subsidy amount Dollar Amount Subsidy amount for the enrolment.
PAS number Text PAS number for enrolment.

Relations

Name Description
Payments Payments for NSW Smart and Skilled enrolment.

NSW Smart and Skilled payment

Holds payments for NSW Smart and Skilled enrolments.

Fields

Name Type Description
Invoice number Text Invoice number for NSW Smart and Skilled payment.
Invoice date Date Invoice date for NSW Smart and Skilled payment.
TCID Text Training Contract ID for NSW Smart and Skilled payment.
Instalment description Text Description of instalment for NSW Smart and Skilled payment.
Amount Dollar Amount Amount of NSW Smart and Skilled payment.
PV ID Text PV ID for NSW Smart and Skilled enrolment.
PV approval date Date PV approval date for NSW Smart and Skilled payment.

Occurrence

Holds occurrences and bookings.

Fields

Name Type Description
ID Whole number ID of occurrence.
Short code Text Short code of occurrence.
Long code Text Long code of occurrence.
Type Lookup list Type of the occurrence.
Start date Date Start date of occurrence.
Finish date Date Finish date of occurrence.
Notes Text Block Notes for occurrence.
Minimum clients Whole number Minimum number of clients for the occurrence.
Maximum clients Whole number Maximum number of clients for the occurrence.
Total clients Whole number Total number of clients currently enrolled in the occurrence.
Published for online enrolment Yes or no Whether the occurrence has been published for online enrolment.
Published for LMS Yes or no Whether the occurrence has been published for enrolment by a Learning Management System.
Date of status change Date Date that the status of the occurrence was last changed.
Reportability Lookup list Default reportability of new enrolments in the occurrence.
Amount Dollar Amount Total pricing amount for the occurrence, including any GST.
GST Dollar Amount Total GST pricing amount for the occurrence.
Government amount Dollar Amount Total amount of enrolments in the occurrence to be government funded.
Confirmation status Lookup list Confirmation status for the occurrence.
Commencing status Lookup list Default AVETMISS commencing status for new enrolments in the occurrence.
VET in schools Yes or no Whether new enrolments in the occurrence are VET In Schools enrolments.
Report employer as location Yes or no Whether to report the enrolment's employer as the location in AVETMISS for new enrolments in the occurrence.
VIC enrolment date Date Date when the student legally agreed to undertake the training and incur any related costs for new enrolments in the occurrence.
VIC program commencement date Date Victorian training activity start date for new enrolments in the occurrence.
VIC PSTACD Date VIC Program Supervised Teaching Activity Completion Date for new enrolments in the occurrence.
VIC PUSH Whole number VIC Program Unique Supervised Hours for new enrolments in the occurrence.
VIC PUSH calculation method Lookup list How the enrolment's Program Unique Supervised Hours are automatically calculated for new enrolments in the occurrence.
VIC funding eligibility key Text VIC funding eligibility key for new enrolments in the occurrence.
VIC eligibility exemption Yes or no Whether new enrolments in the occurrence meet VIC eligibility exemption criteria.
VIC VET FEE-HELP Yes or no Whether new enrolments in the occurrence are being delivered under VET FEE-HELP in VIC.
VIC VSN transfer Yes or no Whether to include new enrolments in the occurrence in VIC VSN transfers.
VIC eligibility Yes or no Whether evidence of student eligibility verified for new enrolments in the occurrence.
VIC declaration Yes or no Whether to set the student declaration signed in VIC for new enrolments in the occurrence.
NSW report type Lookup list How new enrolments in the occurrence should be reported in NSW.
NSW enrolment status Lookup list NSW Smart and Skilled reportable status for new enrolments in the occurrence.
NSW provider calculator export Yes or no Whether new enrolments in the occurrence are to be included in NSW Smart and Skilled Provider Calculator exports, until they have a commitment ID.
QLD full time learning Yes or no Whether new enrolments in the occurrence are QLD full time learning.
WA intake number Text WA intake number for new enrolments in the occurrence.
WA fee model Lookup list How WA fees should be calculated for new enrolments in the occurrence.
ACT student file number Text ACT student file number for new enrolments in the occurrence.
Delivery modes Text Delivery modes for the enrolment. This is a string containing one letter per delivery mode, with the predominant delivery mode first.
Created date Date and time Date the record was created.
Date last updated Date and time Date the record was last updated.

Relations

Name Description
Programme Programme of the occurrence.
Qualification Qualification/course for the occurrence.
Enrolled units Enrolled units in the occurrence.
Location Delivery location of occurrence.
Status Status of occurrence.
Cancellation reason Reason for the cancellation of the occurrence. Will be empty if not cancelled.
Employer Employer associated with occurrence.
Employer contact Employer contact for the occurrence.
Events Events linked to this occurrence.
Organisation Organisation this occurrence belongs to.
Division Division for occurrence.
Enrolment type Type of the occurrence.
Referral source Referral source for occurrence.
Staff Staff members assigned to occurrence.
Client enrolments Client enrolments in the occurrence.
Classes Classes that are in the occurrence.
Funding source Funding source for new enrolments in the occurrence. Empty if not government funded.
Purchasing contract Purchasing contract for new enrolments in the occurrence.
Delivery provider employer Employer that is the delivery provider for new enrolments in the occurrence.
Vocation Vocation for new enrolments in the occurrence.
Delivery type AVETMISS delivery type for new enrolments in the occurrence.
Fee exemption Fee exemption type for new enrolments in the occurrence.
Study reason Study reason for new enrolments in the occurrence.
Specific funding identifier Specific funding identifier for new enrolments in the occurrence.
Funding model Funding model for pricing for new enrolments in the occurrence.
ANZSIC Australian and New Zealand Standard Industrial Classification for new enrolments in the occurrence.
Status history Status history entries for the occurrence.
NSW Smart and Skilled enrolment NSW Smart and Skilled data for new enrolments in the occurrence.
Tasks Tasks linked to the occurrence.
Pricing Pricing for the occurrence.

Occurrence event

Holds events assigned to occurrences.

Fields

Name Type Description
Start date Date and time Start date of the occurrence event.
Finish date Date and time Finish date of the occurrence event. Will be empty for a milestone event.
Complete Yes or no Whether this occurrence event is complete.
Notes Text Block Notes for the occurrence event.
Show in calendar Yes or no Whether to show this event in the calendar.
Document reference Text Reference to a document linked to the occurrence event.
Don't copy to new enrolments Yes or no Whether the occurrence event should not be copied to new enrolments in the occurrence by default.

Relations

Name Description
Event type The type of this occurrence event.
Staff Staff member assigned to occurrence event.

Occurrence price

Contains prices for occurrences.

Fields

Name Type Description
Amount Decimal number Amount of occurrence price, including any GST.
GST Decimal number GST amount of occurrence price.
Web published Yes or no Whether the occurrence price is published for online enrolments.

Relations

Name Description
Occurrence Occurrence that the price is on.
Pricing item Pricing item for occurrence price. Each price will have either a Pricing Item or an Inventory Item, not both.
Inventory item Inventory item for occurrence price. Each price will have either a Pricing Item or an Inventory Item, not both.
Enrolled unit Enrolled unit that is being priced. Will not be specified if the price is not at the enrolled unit level.
Ledger Ledger for the occurrence price.

Occurrence staff

Staff assigned to an occurrence.

Fields

Name Type Description
Primary Yes or no Whether this is the primary staff member for the occurrence.

Relations

Name Description
Staff type Type of staff member assigned to enrolment.
Staff Staff member assigned to enrolment.
Occurrence Occurrence the staff member is assigned to.

Organisation

Holds organisations.

Fields

Name Type Description
Name Text Name of organisation.
Short name Text Short name of organisation.
Trading name Text Trading name for organisation.
RTO code Text RTO code on training.gov.au for organisation.
ABN Text ABN for organisation.
Archived Yes or no Whether the organisation is archived.

Outcome

Holds AVETMISS unit outcomes.

Fields

Name Type Description
Name Text Name of outcome.
Code Text AVETMISS code of outcome.

Payment

Contains payments made against invoices.

Fields

Name Type Description
Amount Decimal number Amount of payment.
Recorded date Date Date the payment was recorded.
Payee Text Payee of payment. If empty, was paid by the invoicee.
BSB Text BSB of the payment. Only applicable if payment type is EFT or cheque.
Account number Text Account number of payment. Only applicable if payment type is EFT or cheque.
Account name Text Account name of payment. Only applicable if payment type is EFT.
Credit card type Text Credit card type of payment. Only applicable if payment type is credit card.
Credit card expiry Text Expiry date of credit card for payment. Only applicable if payment type is credit card.
Credit card holder Text Name of holder of credit card for payment. Only applicable if payment type is credit card.
Cheque drawer Text The drawer of the cheque. Only applicable for a payment type of cheque.
Cheque number Text Number of the cheque. Only applicable if payment type is cheque.
Order number Text Order number of payment. Only applicable for credit card gateways.
RRN Text Return Receipt Number of credit card payment. Only applicable for credit card gateways, or Ezidebit payments.
Notes Text Block Notes of payment.
External number Text Number of the payment in an external finance system.
Exported date Date Date the payment was exported.
Exported batch Whole number Batch number the payment was exported in.

Relations

Name Description
Payment type Type of payment.
Location Location of payment.
Disbursements Contains disbursements of this payment against invoice items.
First invoice The "first" invoice that this payment was made against. This should not be relied upon for payments that are made against multiple invoices.
Holding Amounts transferred from the payment to holding, or from holding to the payment.

Payment disbursement

Contains disbursements of a payment across invoice items.

Fields

Name Type Description
Amount Decimal number Amount of payment disbursement, including any GST.
GST Decimal number GST amount of the payment disbursement.
Description Text Description of item that this payment disbursement is for.

Relations

Name Description
Payment Payment that the disbursal is against.
Invoice item Invoice item that the payment is disbursed against.

Payment history

Contains imported payment history for enrolled units and enrolments.

Fields

Name Type Description
Amount Dollar Amount Payment amount.
Hours Whole number Number of hours the payment was made for.

Relations

Name Description
Import batch Batch that the payment history entry was imported in.

Payment history import batch

Contains batches of payment history imports.

Fields

Name Type Description
Invoice number Text Invoice number of payment history import batch.
Invoice date Date Date of payment history invoice.
Import date Date and time Date that the payment history was imported.

Relations

Name Description
Imported by user User that imported the payment history batch.

Payment type

Contains types of payments.

Fields

Name Type Description
Name Text Name of payment type.
Code Text Code of payment type.
Type Lookup list Type of payment type.
Archived Yes or no Whether the payment type has been archived.
Notes Text Block Notes for the payment type.
Default for web payments Yes or no Whether the payment type is the default for web payments.

Placement

Holds workplace placements.

Fields

Name Type Description
Start date Date Start date of placement.
Finish date Date Finish date of placement.
Wage rate Dollar Amount Wage rate of placement.
Charge rate Dollar Amount Charge rate of placement.
Hours per week Decimal number Hours to be worked per week in the placement.
Notes Text Block Notes for the placement.
Created date Date and time Date the record was created.
Last updated date Date and time Date the placement was last updated.

Relations

Name Description
Client Client being placed.
Employer Employer the client is placed with.
Employer contact Client that is the employer contact for the placement.
Staff Supervising staff member for the placement.
Enrolment Enrolment the placement is associated with.
Contract Contract the placement is associated with.

Position

Holds positions of clients.

Fields

Name Type Description
Name Text Name of the position.
Code Text Code of the position.
Archived Yes or no Whether this position is archived.
Description Text Block Description of position.

Relations

Name Description
Classification Classification of position.

Position classification

Holds classifications of positions.

Fields

Name Type Description
Name Text Name of classification.
Archived Yes or no Whether this classification is archived.
Description Text Block Description of this classification.

Pricing item

Contains pricing items.

Fields

Name Type Description
Name Text Name of pricing item.
Code Text Code of pricing item.
Type Lookup list Type of pricing item. Controls how the pricing item is used in calculations and reporting.
Archived Yes or no Whether the ledger is archived.
Include on invoices Yes or no Whether this pricing item is included on invoices by default.
Surcharge percentage Decimal number Percentage of the surcharge (or a negative for a discount) that can be applied to prices of this type.

Relations

Name Description
Default ledger Default ledger of pricing item when it is put on invoices.

Prior education

Holds prior education entries.

Fields

Name Type Description
Name Text The name of the prior education.
Code Text The AVETMISS code of the prior education.

Programme

Holds programmes for occurrences.

Fields

Name Type Description
Name Text Name of programme.
Code Text Code of programme.
Archived Yes or no Whether the programme is archived.
Description Text Block Description of programme.
Waitlistable Yes or no Whether the programme is available for waitlisting.

Relations

Name Description
Programme type Type of the programme.

Programme type

Holds types of programmes for occurrences.

Fields

Name Type Description
Name Text Name of programme type.
Code Text Code of programme type.
Archived Yes or no Whether the programme type is archived.
Description Text Block Description of programme type.

Purchasing contract

Holds state-based purchasing contracts.

Fields

Name Type Description
Name Text Name of purchasing contract.
Code Text Code of purchasing contract.
Schedule number Text Schedule number of purchasing contract. Only used in VIC and QLD.
Archived Yes or no Whether the purchasing contract is archived.
Description Text Block Description of the purchasing contract.
Target hours Whole number Target number of hours of training for the purchasing contract.

Relations

Name Description
State State of the purchasing contract.

Qualification

Holds qualifications and courses.

Fields

Name Type Description
Name Text Name of qualification/course.
Code Text Code of qualification/course.
Release Text Release number of qualification.
Status Lookup list Status of qualification.
Archived Yes or no Whether the qualification/course is archived.
Is VET Yes or no Whether the course is a VET course. Qualifications are always VET.
Core count Whole number The number of core units/modules required for the qualification/course.
Elective count Whole number The number of elective units/modules for the qualification/course.
Accredited until date Date Date that the RTO's accreditation for this qualification/course is valid until.
Description Text Block Description of the qualification/course.
Strategy Text Block Training and Assessment Strategy of the qualification/course.
In TGA Yes or no Whether the qualification is on training.gov.au

Relations

Name Description
Client enrolments Client enrolments in the qualification/course.
Training package Training package the qualification belongs to. Will be empty for a course.
Category AVETMISS category of qualification.
Recognition status AVETMISS recognition status for the qualification.
ANZSCO Australian and New Zealand Standard Classification of Occupation for the qualification.
Report this qualification as The qualification that this qualification should be reported as in AVETMISS.
Qualifications reported as this Qualifications that are reported as this one.
Superseded by Qualification that supersedes this one.
Supersedes qualifications Qualifications that are superseded by this one.

Qualification category

Holds categories of qualifications.

Fields

Name Type Description
Name Text Name of the qualification category.
Code Text AVETMISS code of the qualification category.
Archived Yes or no Whether the qualification category is archived.

Qualification recognition status

Holds a list of recognition statuses for qualifications.

Fields

Name Type Description
Name Text Name of recognition status.
Code Text AVETMISS code of recognition status.

Referral source

Holds referral sources.

Fields

Name Type Description
Name Text Name of referral source.
Code Text Code of referral source.
Archived Yes or no Whether referral source is archived.
Description Text Block Description of referral source.

Region

Holds regions that locations can be in.

Fields

Name Type Description
Name Text Name of region
Code Text Code of region
Archived Yes or no Whether the region is archived.
Description Text Block Description of region.

Result type

Holds types of unit results.

Fields

Name Type Description
Name Text Name of result type.
Code Text Code of result type. This is not the AVETMISS outcome code.
Result status Lookup list The status of result that the result type represents.
Assessment status Lookup list Assessment status that the result type represents.
Report in AVETMISS Yes or no Whether the result type should be reported in AVETMISS.
Provider code Text Code reported for the result type in "Outcome identifier - Training Organisation" field in AVETMISS exports.
Archived Yes or no Whether the result type is archived.

Relations

Name Description
Outcome Reportable AVETMISS outcome for the result type.

Room

Holds rooms for classes.

Fields

Name Type Description
Name Text Name of room.
Code Text Code of room.
Archived Yes or no Whether room is archived.
Description Text Block Description of room.
Capacity Whole number Capacity of room.

Relations

Name Description
Location Location of room.

School level

Holds AVETMISS school levels.

Fields

Name Type Description
Name Text Name of school level.
Code Text AVETMISS code of school level.

Skill

Holds skills.

Fields

Name Type Description
Name Text Name of skill.
Code Text Code of skill.
Expiry months Whole number Number of months after which the skill expires. 0 means no expiry.
Archived Yes or no Whether the skill is archived.
Description Text Block Description of skill.

Specific funding identifier

Holds AVETMISS specific funding identifiers.

Fields

Name Type Description
Name Text Name of specific funding identifier.
Code Text Code of specific funding identifier.
Archived Yes or no Whether specific funding identifier is archived.

Staff

Holds staff members.

Fields

Name Type Description
Code Text Unique VETtrak code of the client.
Surname Text Surname (or single name) of the client.
Given name Text Given name of the client. For a single name client, this field must be empty.
Other names Text Other names of the client, such as middle names. For a single name client, this field must be empty.
Title Text Title of client (Mr, Mrs, Miss, Ms, Dr etc).
Preferred name Text Preferred name of client.
Former surname Text Former surname of the client.
Gender Lookup list Gender of the client.
Date of birth Date Date of birth of the client.
Username Text Username of the client.
Password Text Password of the client.
Login disabled Yes or no Whether the staff member is barred from logging onto any VETtrak software.
Archived Yes or no Whether this client is archived.
Email Text Email address of the client.
Email secondary Text Secondary email address for the client.
Email both Yes or no Whether to send email to both of the client's email addresses.
Mobile phone Text Mobile phone number of the client.
Mobile phone secondary Text Secondary mobile phone number for the client.
SMS both Yes or no Whether to send SMS messages to both of the client's mobile phone numbers.
Home phone Text Home phone number of the client.
Work phone Text Work phone number of the client.
Fax number Text Fax number of the client.
Preferred contact method Lookup list Preferred contact method for the client.
Notes Text Block Notes for client.
External code Text Code for this client in an external system.
Emergency contact person Text Name of the emergency contact person for this client.
Emergency contact relationship Text Relationship of the emergency contact person for this client.
Emergency contact phone Text Phone number of the emergency contact person for this client.
Emergency contact mobile Text Mobile number of the emergency contact person for this client.
Web published Yes or no Whether the client is web published.
Department/school/faculty Text Department/school/faculty for the staff member.
Employment Lookup list Employment type for the staff member.
External staff member Yes or no Whether this staff member is external.
Created date Date and time Date the record was created.
Last update date Date and time Date the record was last updated.

Relations

Name Description
Client Access to the entire client record for the staff member.
Employer (primary) Primary employer of the client.
Employment Employment records and history for the staff member.
Usual address Usual address of the client, in AVETMISS 7 format.
Postal address Postal address of the client, in AVETMISS 7 format.
Manager (primary) Primary client that is the manager of this client.
Managed clients (primary) Primary clients that are managed by this client.
Division Security division that this client is in.
Groups Groups that this client is in.
Contact for employers Employers that the client is a contact for.
Deliverable units Units that the staff member can deliver.
Credentials Credentials for the staff member.
Staff types Staff types for the staff member.
Associated client enrolments Client enrolments the staff member is associated with.
Associated contracts Contracts the staff member is associated with.
Associated client events Client events that have this staff member assigned.
Associated employer events Employer events that have this staff member assigned.
Associated occurrences Occurrences that this staff member is assigned to.
Associated occurrence events Occurrence events that this staff member is assigned to.
Associated classes Classes the staff member is assigned to.
Supervised placements Placements the staff member is supervising.

Staff credential

Contains credentials held by staff members.

Fields

Name Type Description
Status Lookup list Status of staff credential.
Start date Date Start date of staff credential.
Expiry date Date Expiry date of staff credential.
Created date Date and time Date the record was created.
Last update date Date and time Date the record was last updated.
Notes Text Block The notes for individual staff credentials.

Relations

Name Description
Credential Credential held by the staff member.
Deliverable units Units that are deliverable with this staff credential.

Staff type

Holds staff types.

Fields

Name Type Description
Name Text Name of staff type.
Code Text Code of staff type.
Archived Yes or no Whether the staff type is archived.
Description Text Block Description of staff type.

State

Holds Australian states/territories and other areas.

Fields

Name Type Description
Name Text The long name of the state, such as "New South Wales" and "Victoria".
Short name Text The short name (or code) of the state, such as "NSW" and "Vic".

Status

Holds enrolment and contract statuses.

Fields

Name Type Description
Name Text Name of status.
Code Text Code of status.
Type Lookup list Type of status.
Archived Yes or no Whether the status is archived.
Description Text Block Description of status.
Is default Yes or no Whether this status is the default.

Status history

History of status changes for an enrolment or contract.

Fields

Name Type Description
Start date Date Date that the status history applies from.
Finish date Date Date that the status history applies to.
Date of effect Date Date of effect for the status history.

Relations

Name Description
Status Status for the status history entry.

Study reason

Holds AVETMISS reasons for study.

Fields

Name Type Description
Name Text Name of study reason.
Code Text Code of study reason.
Archived Yes or no Whether the study reason is archived.

Relations

Name Description
State State that study reason applies to. Empty if study reason is national.

Survey contact status

Holds survey contact statuses for clients.

Fields

Name Type Description
Name Text Name of survey contact status.
Code Text Code of survey contact status.
Archived Yes or no Whether the survey contact status is archived.

Task

Holds definitions of tasks.

Fields

Name Type Description
Code Text Code of task.
Name Text Name of task.
Notes Text Block Notes for task.
Archived Yes or no Whether the task is archived.

Relations

Name Description
Task category Category of task.

Task category

Holds categories of tasks.

Fields

Name Type Description
Code Text Code of task category.
Name Text Name of task category.
Archived Yes or no Whether the task category is archived.

Task enrolment

Holds enrolled tasks for client enrolments.

Fields

Name Type Description
Enrolment ID Whole number ID of enrolment or occurrence that contains the task.
Start date Date Date the enrolled task was started.
Complete date Date Date the enrolled task was completed. Empty if not completed.
Date of status change Date Date of the last status change.
Due date Date Due date of enrolled task.
Percentage Whole number Percentage score of task enrolment.
Notes Text Block Notes for enrolled task.
Created date Date and time Date the record was created.
Last updated date Date and time Date the enrolled task was last updated.

Relations

Name Description
Task Task that is enrolled.
Task status Status of enrolled task.
Client enrolment Client enrolment that enrolled task is for.
Enrolled units Enrolled units linked to the enrolled task.
Assigned staff member Staff member assigned to the enrolled task.
Completed by staff member Staff member who last marked this enrolled task as completed.

Task status

Holds task statuses.

Fields

Name Type Description
Code Text Code of task status.
Name Text Name of task status.
Type Lookup list Type of task status.
Notes Text Block Notes for task status.
Archived Yes or no Whether the task status is archived.

Training package

Holds training packages.

Fields

Name Type Description
Name Text Name of training package.
Code Text Code of training package.
Archived Yes or no Whether this training package is archived.
Description Text Block Description of the training package.

Unit

Holds units and modules.

Fields

Name Type Description
Name Text Name of unit/module.
Code Text Code of unit/module.
Type Lookup list Whether this is a unit or module.
Archived Yes or no Whether the unit/module is archived.
Is VET Yes or no Whether the unit/module is VET.
Accredited until date Date Expiry date of the accreditation to deliver the unit/module.
Description Text Block Description of unit/module.
In TGA Yes or no Whether the unit is on training.gov.au

Relations

Name Description
Training packages Training packages that the unit belongs to. Will be empty for modules.
Field of education Field of education for the unit/module.

Unit cluster

Holds clusters of units in a qualification.

Fields

Name Type Description
Name Text Name of unit cluster.
Code Text Code of unit cluster.
Type Lookup list Type of unit cluster.
Archived Yes or no Whether the unit cluster is archived.
Default Yes or no Whether the unit cluster is added to new qualifications by default.
Description Text Block Description of unit cluster.

VET Student Loan client details

Contains VET Student Loan information, such as CHESSN and birth location, about a client.

Fields

Name Type Description
Term address country type Lookup list Country of residence during term.
Term address postcode Text Australian postcode of term residence. Only used if Term address country type is "Australia"
Home address country type Lookup list Country of permanent home residence.
Home address postcode Text Australian postcode of permanent home residence. Only used if Home address country type is "Australia"
Birth location Lookup list Indicates how much is known about the country of birth. This field is related to the Client's Country of Birth.
Arrival status Lookup list Arrival status. This field is related to the Client's Country of Birth. If the Client's Country of Birth is Australia, this field is set to "Born in Australia" automatically.
Arrival year Whole number Year of arrival in Australia. Only used if Arrival status is "Known year of arrival"
Language at home status Lookup list Whether English is spoken at home. This field is related to the Client's Language spoken at home. If this is not blank, this field is automatically set to "Known"
Citizenship status Lookup list Client's citizenship status.
Disability exists Lookup list Does the client have a disability?
Disability conditions Text Areas of impairment. 6 character string. Each character can be 0 or 1. 1 in a particular position indicates the client has the disability corresponding with that position, 0 indicates they do not. The character positions from left-to-right are: 1st = Hearing 2nd = Learning 3rd = Mobility 4th = Visual 5th = Medical 6th = Other eg. 010100 indicates learning and visual impairments.
Disability support Lookup list Whether the client requires disability support.
School leaver type Lookup list Was this client a domestic school leaver?
Year 12 postcode Text Postcode of year 12 permanent home residence.
Year 12 suburb Text Name of commencing suburb. Only used if Leaver type is "Yes"
CHESSN Text Commonwealth Higher Education Student Support Number
Participation type Lookup list Highest prior educational participation student status.
Highest participation Lookup list Highest educational participation
Year of last participation Text Year of last participation
Under 18 status Lookup list Under 18 status for the client. Only relevant if the client is under 18 years of age.
Has NZ Special Category Visa Yes or no Whether the client has a NZ Special Category Visa (SCV). Only relevant if the client's citizenship is New Zealand.
Entered Australia as a child (NZ) Yes or no Whether the NZ client entered Australia as a child. Only relevant if the client's citizenship is New Zealand.

Relations

Name Description
Term address country The overseas country of term residence.
Home address country The overseas country of permanent home residence.

VET Student Loan eCAF progression

Holds eCAF progressions for VET Student Loan courses of study.

Fields

Name Type Description
Progression ID Whole number ID of progression in eCAF system.
Number Whole number Sequence number of progression.
Period start date Date Start date of period that the progression is for.
Create date Date and time Date the progression was created in the eCAF system.
Modify date Date and time Date the progression was last modified in the eCAF system.
Due date Date Date the progression is due in the eCAF system.
Status Lookup list Status of the progression in the eCAF system.
Student submit date Date and time Date the student submitted the progression in the eCAF system. Empty if it has not been submitted yet.
Outcome Text Outcome selected by the student for the progression in the eCAF system. Empty if no outcome has been entered yet.

Relations

Name Description
Responses The student's responses to the questions on the eCAF progression form. Not all fields on the eCAF progression form are made available to the RTO. The fields vary depending on the outcome the student selected.

VET Student Loan eCAF progression response

Holds student's responses to the questions on their eCAF progression forms.

Fields

Name Type Description
Field name Text Name of eCAF progression form field.
Field value Text Block Value that was entered by the student in this field on the eCAF progression form.

VET Student Loan enrolment

Contains VET Student Loan courses of study for clients.

Fields

Name Type Description
Admission basis Lookup list Basis for admission to course.
Attendance type Lookup list Type of attendance.
Enrolment date Date Date the client enrolled for the VET Student Loan.
Course start date Date Commencement Date
Credit used Decimal number Credit used percentage; a number between 0 and 100.
Credit offered Decimal number Credit offered, as a percentage of full time load. Number between 1 and 100
Credit field of education Text Field of education code of prior VET credit/RPL.
Credit level of education Lookup list Level of prior study for credit/RPL was offered.
Credit provider type Lookup list Type of provider where credited study was undertaken.
Credit basis Lookup list Prior study for which credit/RPL was offered.
Study reason Lookup list Reason for study.
Completion status Lookup list Completion status.
Completion date Date Completion date for the course of study.
Exported date Date Date that this record was last exported in a VCC export. Empty if never exported.
Notes Text Block Notes
Australian resident for 10 years (NZ) Yes or no Whether the client first started to be generally living and resident in Australia at least 10 years before the test day. Only relevant if the client holds a NZ Special Category Visa.
In Australia 8 of 10 years (NZ) Yes or no Whether the client has been in Australia for at least a total of 8 out of the 10 years immediately before the test day. Only relevant if the client holds a NZ Special Category Visa.
In Australia 18 months of 2 years (NZ) Yes or no Whether the client has been in Australia for at least a total of 18 months out of the two years immediately before the test day. Only relevant if the client holds a NZ Special Category Visa.
eCAF status Lookup list Status of the Government eCAF for this VET Student Loan.
eCAF ID Whole number ID of the Government eCAF for this VET Student Loan.
eCAF upload date Date and time Date this VET Student Loan was uploaded to the Government eCAF system. Empty if never uploaded.
eCAF student submit date Date and time Date the eCAF for this VET Student Loan was submitted by the student. Empty if never submitted.
Loan scheme Lookup list Whether this is a VET Student Loan or a VET FEE-HELP loan.
VET FEE-HELP opt-in date Date Date when the student opted in to continue their old VET FEE-HELP loan.

Relations

Name Description
Enrolled units of study The list of Units of Study that make up this enrolment.
Client The client who has the VET Student Loan enrolment
Qualification The qualification that the VET Student Loan enrolment is in
Organisation The organisation delivering the VET Student Loan enrolment
Credit provider The Higher Education Provider who provided the prior credit for this enrolment.
Related enrolments Client enrolments that are related to this client's VET Student Loan course of study.
Campus location Location of the campus of the VET Student Loan enrolment.
eCAF upload user User that uploaded this VET Student Loan to the Government eCAF system.
eCAF progressions Progressions for the eCAF.

VET Student Loan higher education provider

A list of higher education providers that can be used for providing credit for a VET Student Loan enrolment.

Fields

Name Type Description
Code Text Reportable unique code of the higher education provider.
Name Text Name of the higher education provider.

VET Student Loan related enrolment

A relationship between a VET Student Loan client course of study and a VET enrolment.

Fields

Name Type Description
For pricing Yes or no Whether the enrolment is related to the client's VET Student Loan course of study for pricing purposes.
For resulting Yes or no Whether the enrolment is related to the client's VET Student Loan course of study for resulting purposes.

Relations

Name Description
VET Student Loan enrolment The related client's VET Student Loan course of study.
Client enrolment The related client's enrolment.

VET Student Loan unit of study

VET Student Loan units of study, able to be assigned to a client's VET Student Loan enrolment.

Fields

Name Type Description
Code Text Unique code of the unit of study.
Name Text Name of the unit of study
Description Text Block Optional description or notes about the Unit of Study
Archived Yes or no Whether this unit of study is archived.
Discipline code Text Discipline code for the unit of study. Possible values come from fields of education. Each code is right-padded with 0's to be 6 characters in length

VET Student Loan unit of study enrolment

The Units of Study that make up a Client's Course of Study for VET Student Loans

Fields

Name Type Description
Start date Date Start date of the unit of study
End date Date End date of the unit of study
Campus country type Lookup list Campus location country type.
Campus post code Text Australian postcode of campus location. Only relevent if Campus country type is "Australia"
Census date Date Unit of Study's Census date.
Student status Lookup list Status of the student's subsidy
RPL status Lookup list RPL status for this Unit of Study enrolment.
VLL export date Date Date that this record was last exported in a VLL export. Empty if this record has never been exported.
VDU export date Date Date that this record was last exported in a VDU export. Empty if this record has never been exported.
VCU export date Date Date that this record was last exported in a VCU export. Empty if this record has never been exported.
Mode of attendance Lookup list Mode of attendance
Equivalent full-time study load Decimal number Equivalent full-time study load, where 1 = 100%
Completion status Lookup list Completion status of the Unit of Study
Completion date Date Completion date for the unit of study.
Amount paid up front Dollar Amount Loan amount paid up front
Total amount charged Dollar Amount Total loan amount charged.
Loan fee Dollar Amount Loan fee
HELP debt Dollar Amount HELP debt
Notes Text Block Notes recorded for the unit of study
Fee notice sent date Date The date that a fee notice was last sent for this unit of study. Empty if it has never been sent.

Relations

Name Description
VET Student Loan enrolment The enrolment that this Unit of Study is a part of.
Unit of study The Unit of Study that is part of the enrolment.
Campus country The overseas campus location country. Only relevant if Campus country type is "Overseas"
Related enrolled units Enrolled VET units of competency that have been related to this enrolled unit of study.
Pricing Pricing for unit of study.

VIC program enrolment

Holds data for Victorian program enrolments.

Fields

Name Type Description
Program enrolment identifier Text Reportable unique identifier for the Victorian program enrolment.

Relations

Name Description
Program enrolment status Status of the Victorian program enrolment.
Client enrolments Client enrolments for the same client, qualification, and VIC program commencement date as the VIC program enrolment.

VIC program enrolment status

Holds Victorian program enrolment statuses.

Fields

Name Type Description
Name Text Name of Victorian program enrolment status.
Code Text Code of Victorian program enrolment status.
Archived Yes or no Whether the Victorian program enrolment status is archived.

Visa type

Holds types of Visas.

Fields

Name Type Description
Name Text Name of the Visa type.
Code Text Code of the Visa type.
Archived Yes or no Whether the Visa type is archived.
Description Text Block Description of the Visa type.

Vocation

Holds vocations.

Fields

Name Type Description
Name Text Name of vocation.
Archived Yes or no Whether vocation is archived.
Description Text Block Description of vocation.

Waitlist

Holds waitlist entries.

Fields

Name Type Description
Notes Text Block Notes for waitlist entry.
Created date Date and time Date the record was created.
Last updated date Date and time Date the waitlist entry was last updated.

Relations

Name Description
Programme Programme for the waitlist entry.
Client Client on waitlist entry.
Referral source Referral source for waitlist entry.