VETtrak Data Insight Help

Version 17.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
• ANZSCO
• ANZSIC
• Attendance
• Attendance type
• Attribute
• Award
• Award history
• Award type
• Cancellation reason
• Class
• Client
• Client attribute
• Client class
• Client enrolment
• Client enrolment staff
• Client event
• Client prior education
• Contract
• Contract staff
• Contract type
• Country
• Credential
• Credential type
• Delivery strategy
• Delivery type
• Disability
• Division
• Employer
• Employer attribute
• Employer contact
• Employer event
• Employer type
• Employment category
• Enrolled unit
• Enrolment type
• Event type
• Fee exemption
• Field of education
• Funding model
• Funding source
• Funding source national
• Group
• Language
• Location
• NSW Smart and Skilled enrolment
• NSW Smart and Skilled payment
• Occurrence
• Occurrence event
• Occurrence staff
• Organisation
• Outcome
• Payment history
• Payment history import batch
• Placement
• Position
• Position classification
• Prior education
• Programme
• Programme type
• Purchasing contract
• Qualification
• Qualification category
• Qualification recognition status
• Referral source
• Region
• Result type
• Room
• School level
• Specific funding identifier
• Staff
• Staff credential
• Staff type
• State
• Status
• Status history
• Study reason
• Task
• Task category
• Task enrolment
• Task status
• Training package
• Unit
• VET Student Loan client details
• VET Student Loan enrolment
• VET Student Loan higher education provider
• VET Student Loan related enrolment
• VET Student Loan unit of study
• VET Student Loan unit of study enrolment
• Visa type
• Vocation
• Waitlist

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.

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.

Relations

Name	Description
Attendance type	Type of attendance

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 of the award.
Year	Whole number	Year of award issue.
Issued	Yes or no	Whether the award has been 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.

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.

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.
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.
Commencement date	Date	Date the client commenced.
Last assessment date	Date	Date the client was last assessed.
Termination date	Date	Date the client was terminated.
Salary	Dollar Amount	Salary or hourly rate of the 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	Employer of the client.
Usual address	Usual address of the client, in AVETMISS 7 format.
Postal address	Postal address of the client, in AVETMISS 7 format.
Position	Position of the client.
Manager	Client that is the manager of this client.
Managed clients	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

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.

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 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 course 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.
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.

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.

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.

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.

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.

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.
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.

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 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.

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.

Relations

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

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 course 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.
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 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.

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.

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 course 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.
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.

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 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 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.

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.

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.

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.

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.
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.
Commencement date	Date	Date the client commenced.
Last assessment date	Date	Date the client was last assessed.
Termination date	Date	Date the client was terminated.
Salary	Dollar Amount	Salary or hourly rate of the 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	Employer of the client.
Usual address	Usual address of the client, in AVETMISS 7 format.
Postal address	Postal address of the client, in AVETMISS 7 format.
Position	Position of the client.
Manager	Client that is the manager of this client.
Managed clients	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.

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.

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.

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 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 year	Whole number	Year of completion. Only relevant if Completion status is "Completed"
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.

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.

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.