ENR_STAT_SNAPSHOT_VET

The Person ID of the Student's Enrolment or Advanced Standing. Used for various internal reports. Reported in the following AVETMISS files:

• Client (NAT00080)
• Client Disability (NAT00090)
• Client Prior Educational Achievement (NAT00100)
• Enrolment (NAT00120)
• Qualification Completed (NAT00130)
• Unit Of Competency Completed - NAT00180

Reported in the following Centrelink files:

• Student Record
• Unit Record

The Course Version that the student enrolled in or has Advanced Standing in. Used for various internal reports. If a Qualification Reference Code is not recorded for the Course Version, then the Course Code will be reported in the following AVETMISS files:

• Course - NAT00030
• Enrolment - NAT00120
• Qualification Completed - NAT00130.

Reported in the following Centrelink file:

• Unit Record

The Unit Version that the student enrolled in or has Advanced Standing in. Used for various internal reports. If a Unit Of Competency Reference Code is not recorded for the Unit Version, then the Unit Code will be reported in the following AVETMISS files:

• Module/Unit Of Competency (NAT00060)
• Enrolment (NAT00120)
• Unit Of Competency Completed - NAT00180

Reported in the following Centrelink file:

• Unit Record

The Location of the Student's Unit Enrolment. For Advanced Standing the value will be the Location of the Student's Course Enrolment. Used for various internal reports. Reported in the following AVETMISS files:

• Training Provider Location (NAT00020)
• Enrolment (NAT00120)

Defined in ORGF0131 - Maintain Locations

Indicates whether or not the student is enrolling in the Course for the first time within the Training Organisation. Used for various internal reports. (for Enrolments and Advanced Standing):

• If the Student Course Attempt Commencement Date is before 01/01/<Submission Year> then set Commencing Course ID to to 3, otherwise, set it to 4.

Reported in the following AVETMISS files:

• Enrolment (NAT00120)

The Government Training Organisation of the Course that the student is enrolled in or has Advanced Standing in. Government Submissions are for a Training Organisation. For example, Charles Darwin University (CDU) are required to submit data to the Department of Employment, Education and Training - DEET (formerly the Northern Territory Employment and Training Authority - NTETA) and to the South Australian State authority. These fields will identify the relevant data to be included in each submission. Used for various internal reports. Reported in the following AVETMISS file:

• Training Organisation (NAT00010)

Defined in STAF112U - Maintain Govt Training Organisation.

The Course Type (Qualification Category) of the Course Version the student is enrolled in or has Advanced Standing in. Used for various internal reports, especially for aggregating contact hours. Reported in the following AVETMISS file:

• Course (NAT00030)

Course Types are defined in CRSF1110 - Maintain Course Types and Government Course Types in STAF1121 - Maintain Government Course Types.

The Scheduled Hours for the Student's Enrolment.

The full scheduled hours is always reported in the Scheduled Hours element on the NAT00120 file. Therefore, if the student unit attempt is Enrolled, Completed or Discontinued, the full scheduled Hours as recorded against the unit version will be recorded in the SCHEDULED_HOURS field on the ENR_STAT_SNAPSHOT_VET table. 

For Advanced Standing the Scheduled Hours will be sourced from the Unit Version definition. Used for various internal reports. Will generally be aggregated by Funding Source, Industry Group, Course Type, etc. Reported in the following AVETMISS file:

• Enrolment (NAT00120)

Reported in the following Centrelink file:

• Unit Record

Indicates whether or not the student has participated in the Student Unit Attempt as at the Current Date. For Student Unit Attempts the participation is determined by invoking the Participation Rule. The Participation Rule is institution defined. Set to 'N' for Advanced Standing. Used for various internal reports. May be used to identify Invalid Module Enrolments. User defined.

Defined in RULF2001 - Maintain Group Rules

For example, one component of the rule can be defined in ENRF30B0 - Maintain Student Attempt Participation.

The Enrolment Activity Start Date of the Student's Enrolment. The Enrolment Activity Start Date may be overridden at many levels. For Advanced Standing the value will be the date the Advanced Standing was granted. Used for various internal reports. Will typically be aggregating by other criteria. Reported in the following AVETMISS file:

• Enrolment (NAT00120)

Reported in the following Centrelink file:

• Unit Record.

The Enrolment Activity End Date of the Student's Enrolment. The Enrolment Activity End Date may be overridden at many levels. For Advanced Standing the value will be the date the Advanced Standing was granted. Used for various internal reports. Will typically be aggregating by other criteria. Reported in the following AVETMISS file:

• Enrolment (NAT00120)

Reported in the following Centrelink file:

• Unit Record

Indicates whether or not the Student's Unit Enrolment or Advanced Standing is for a Unit Of Competency. Used for various internal reports. Reported in the following AVETMISS files:

• Module/Unit of Competency (NAT00060)

Defined in CRSF2210.

The Qualification Reference Code for the Course Version. This will typically only have a value when the Course Code is not the National Code. The Qualification Reference Code will represent the National Code. Used for various internal reports. If specified, this value will be reported in the following AVETMISS files (instead of the Course Code):

• Course - NAT00030
• Enrolment - NAT00120
• Qualification Completed - NAT00130

If specified, this value will be reported in the following Centrelink file:

• Unit Record

Defined in CRSF11C0

The Unit Of Competency Reference Code for the Unit Version. This will typically only have a value when the Unit Code is not the National Code. The Unit Of Competency Reference Code will represent the National Code. Used for various internal reports. If specified, this value will be reported in the following AVETMISS files (instead of the Unit Code):

• Course - NAT00030
• Enrolment - NAT00120
• Qualification Completed - NAT00130

If specified, this value will be reported in the following Centrelink file:

• Unit Record

Defined in CRSF11C0

The Funding Source for the Student's Enrolment. If an override Funding Source is recorded at the Student Unit Attempt level, then this will be used as the data source for this field. However, if the Funding Source is not overridden at the Student Unit Attempt level, then this will be used in the Funding Source recorded against the Student Course Attempt. For Advanced Standing the value will always be sourced from the Student Course Attempt. The Government value is looked up from the Funding Source reference data table. Used for various internal reports, especially for aggregating contact hours. Reported in the following AVETMISS file:

• Enrolment (NAT00120)

Defined in CRSF12A0 - Maintain Restricted Funding Source. See also STAF1127 Maintain Government Funding Source.

The Delivery Type of the Student's Enrolment. For Advanced Standing this value will be set to the Government-defined value '09 Not Applicable', and the corresponding institution-defined mapping. The Government value is looked up from the Delivery Type reference data table. Used for various internal reports. Reported in the following AVETMISS file:

• Enrolment (NAT00120).

The Outcome of the Student's Enrolment, or for Advanced Standing the Outcome of the Advanced Standing source. The Government value is looked up from the Provider Outcome Reference Data table. Used for various internal reports. Reported in the following AVETMISS file:

• Enrolment (NAT00120)

Reported in the following Centrelink file:

• Unit Record.

Defined in ASSF01P0 - Maintain Provider Outcome Indentifier or STAF112T - Maintain Government Outcome Identifier.

The Industry Sector and Industry Group of the Course Version the student is enrolled in or has Advanced Standing in. Used for various internal reports, especially for aggregating Contact Hours.

Defined in CRSF11N0 -Maintain Industry Group or STAF112V - Maintain Government Industry Group.

The Administrative Location Code of the Student's Enrolment. If an Administrative Location Code is recorded against the Unit Offering Option of the Student Unit Attempt, then this field will contain that value. Otherwise, if an Administrative Location Code is recorded against the Course Offering Pattern of the Student Course Attempt, then this field will contain that value. For Advanced Standing the value will be null. Used for various internal reports, especially for aggregating Contact Hours, and tracking who is responsible for the Student's Enrolment. If an Administrative Location Code has not been specified for a Student's Enrolment (no value at the Unit Offering Option level or the Course Offering Pattern level), then institutions may choose to use the Student Course Attempt location or the Student Unit Attempt location for internal reporting.

Defined in ORGF0131 - Maintain Locations.

The Remoteness Area of the Student's Enrolment. If a Remoteness Area is recorded against the Location of the Student Unit Attempt, then this field will contain that value. Otherwise, if a Remoteness Area is recorded against the Location of the Student Course Attempt, then this field will contain that value. Because the Student Course Attempt and Student Unit Attempt Locations are sourced from the same set of values (Open Locations of Type Campus), it is most likely that the Remoteness Area will be sourced from the Student Unit Attempt. For Advanced Standing the value will be sourced from the Location of the Student Course Attempt. Used for various internal reports, especially for aggregating Contact Hours, and tracking who is responsible for the Student's Enrolment.

Defined in ORGF0131 - Maintain Locations.

The Enrolled Date of the Student's Enrolment. For Advanced Standing the value will always be null. Used for various internal reports. Reported in the following Centrelink file:

• Unit Record

The Discontinued Date of the Student's Enrolment. Will only be set if the student has discontinued from the Unit. For Advanced Standing the value will always be null. Used for various internal reports. Reported in the following Centrelink file:

• Unit Record

The Course/Unit Discontinuation button (depending whether in Student Course Attempt or Student Unit Attempt block in ENRF3000 - Record Enrolments). Once selected a further button asks user to continue. Once 'Yes' is accepted the date is then set.

Reported in the following AVETMISS file:

• Enrolment (NAT00120)

Where Study Reason Identifier data exists against a Student Course Attempt eligible for inclusion in a snapshot, the corresponding Government and Institution defined Study Reason Identifier Codes are included in the VET Enrolment Snapshot. For example, 01 - To get a job, 02 - To develop my existing business, etc. Defined in ENRF01X0 - Maintain Institute Study Reason Identifier.

Reported in the following AVETMISS file:

• Enrolment (NAT00120)

This field identifies whether a unit of competency/modules of a course.

Reported in the following AVETMISS file:

• Enrolment (NAT00120)

This field is identified when an Alternate Person ID is mapped to a Person ID Type of SGSN and the SGSN End Date is greater than or equal to the SUA Enrolment Activity End Date. For example, the State Government Student Number is used by Victoria University to record the Victorian Student Number. This field will be populated for all students regardless of the State Code if the Alternate Person ID is configured.

This value is used for reporting in the NAT00080 Person File.

Note: This field is specific to Skills VIC data requirements for the state of Victoria.

The date is derived by reporting the Earliest Enrolment Activity Start Date (SUA.ENR_ACTIVITY_START_DT_ALIAS) out of all of the SUA units being reported for the entire course, where the SUA Enrolment Status does not have a status of UNCONFIRM for the SCA. The same logic used for deriving the Enr Activity Start Dt in the ENR_STAT_ SNAPSHOT_VET table is used.

This value is used for reporting in the NAT00120 Enrolment File.

Note: This field is specific to Skills VIC data requirements for the state of Victoria.

The value is derived as follows:

Attended Days / Scheduled Days x Supervised Hours of the Student Unit Attempt, where:

• Attended Days = The number of days between (the greater of the ‘Enrolled Date’ and the ‘Enrolment Activity Start Date’) and the ‘Last Attended Date’.
  If a Last Attended Date was not provided, the Discontinued Date is used instead, and the Attended Days will be calculated as the number of days between (the greater of the ‘Enrolled Date’ and the ‘Activity Start Date’) and the ‘Discontinued Date’. (See the 'Discontinue' T-List item in ENR3000h.)
• Scheduled Days = The number of days between (the greater of the ‘Enrolled Date’ and the ‘Enrolment Activity Start Date’) and the ‘Enrolment Activity End Date’.
• Supervised Hours = The Supervised Hours value as recorded against the Unit Version, unless the hours have been overridden against the individual’s Student Unit Attempt (SUA). If the hours have been overridden at the SUA level then the ‘Override Hours’ value (SUA.DSP_HRS_ATTENDED) will be used.

If the Last Attended Date (or the 'Discontinued Date', if no Last Attended Date exists) is greater than the Activity End Date of the unit, then the HOURS_ATTENDED value = Supervised Hours.

This value is used for reporting in the NAT00120 Enrolment File.

Note: This field is specific to Skills VIC data requirements for the state of Victoria.

If the Funding Source has the Vet Fee indicator as true and the Student Status is 401 – 403 then the Vet Fee-Help Indicator will be Y, otherwise it is N.

This value is used for reporting in the NAT00120 Enrolment File.

Note: This field is specific to Skills VIC data requirements for the state of Victoria.

The value to be captured is the SUA Override Govt Industry CD if it is not null, otherwise the SCA Govt Industry CD is reported if it is not null, otherwise the field is null.

This value is used for reporting in the NAT00120 Enrolment File.

Note: This field is specific to Skills VIC data requirements for the state of Victoria.

If the SCA.FUNDING_SOURCE_ EXEMPT_IND is checked, then the value ‘Y’ is reported, otherwise ‘N’ must be reported.

This value is used for reporting in the NAT00120 Enrolment File.

Note: This field is specific to Skills VIC data requirements for the state of Victoria.

Report the Government Concession Type (that the Person Concession Type is mapped to) where the Person Concession Type has a System Status of Verified, and the Concession Start Date is less than or equal to the SUA Enrolment Activity Start Date and the Concession End Date is null or is greater than or equal to the SUA Enrolment Activity Start Date.

This value is used for reporting in the NAT00120 Enrolment File.

Note: This field is specific to Skills VIC data requirements for the state of Victoria.

Added a list of new fields included in the ENR_STAT_SNAPSHOT_VET table.
Transferred tables and their details from the How the Vet Statistics Process Works Help page, into this Help page.