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

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

• 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

• 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 within the Institution for the first time.

• If the student is commencing a new course = 3
• If the course is continuing a course from previous year = 4
• If the unit marked as a unit-only enrolment, the Commencing Course Identifier = 8.

Note: If a unit has come under a new arrangement during enrolment, which has triggered a new Program (Course) Commencement Date for the unit, then the Commencing Program (Course) Identifier will be reported as a 4 to indicate that the unit is in a continuing course.

If a student course attempt is a Replacement course and the course commencement date of the Superseded course is in the current Collection year, then =3.
If a student course attempt is a Replacement course (set in ENRF3000) and  the course commencement date of the Superseded course is NOT in the current Collection year, then = 4.

If the student’s course is mapped to multiple superseded courses then the earliest course commencement date of the superseded course(s) will be used in deriving the Commencing Program (Course) Identifier.

Reported in the following AVETMISS file:

• Enrolment (NAT00120)

The Government Training Organisation of the Course that the student is enrolled in or for which the student has Advanced Standing. 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.

• Course (NAT00030)

The Scheduled Hours for the Student Unit Attempt where the SUA status is Enrolled, Completed or Discontinued.

If the Report Nominal Hours indicator is selected in the Government Snapshot Control form (STAF8005) then the Supervised Contact Hours recorded for the Unit Version in CRSF2210 is used. Otherwise, this value is determined according to apportionment of these hours according to the load calendars associated with the submission. It is recommended that the Report Nominal Hours indicator is selected for the submission in the Government Snapshot Control form (STAF8005)

If the Report Nominal Hours indicator is selected and the SCA has the Replacement Course indicator set and the current government state is Victoria (02), the scheduled hours is set to the value of the Override Supervised hours from the context Student Unit attempt.  If that value is not set, the Supervised Contact Hours from the context Unit Version record is used.

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)

• 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 more information, see the Statistics Subsystem Data Prerequisites Help page.)

Used for various internal reports. Will typically be aggregating by other criteria.
Reported in the 'Unit Record' Centrelink file, and in the AVETMISS file: Enrolment (NAT00120).

This system uses the following logic to derive this date:
1. Use the Override date recorded against the Student Unit Attempt (SUA) (ENRF3000).
If no Override date is found, then:
2. Use the maximum date recorded in the Delivery Group (ENRF3600).
If no maximum Delivery Group date is found, then:
3. Use the date recorded in the Unit Offering Option (via CRSF2210).
If no Unit Offering Option date is found, then:
4. Use the date recorded in the Unit Offering Pattern (via CRSF2210).
If no Unit Offering Pattern Date is found, then:
5. Use the date recorded in the Unit Offering (via CRSF2210).
If no Unit Offering date is found, then:
6. Use the date recorded in the Teaching Period Date Alias (CALF0220/CALF0512). (The Date Alias recorded in the Enrolment Configuration form (ENF01F0) is used to determine which date, assigned to the Teaching period, to use.)
If no Date Alias is found, then:
7. Use the Start Date recorded for the Teaching period.

For Advanced Standing units with a status of GRANTED, the value will be the date the Advanced Standing was granted.
For Advanced Standing units with a status of NOT-APPRVD, but with an Advanced Standing Source of RPL and an Outcome Code of 52 or 54, the value will be the Unit Not Approved Date.

The source of the Enrolment Activity Start Date.
The Enrolment Activity Start Date may be recorded at many levels. This column will indicate the level at which the Enrolment Activity Start Date was sourced.
This field is also the lamp value that is displayed next to the Enrolment Activity Start Date fields in ENRF3000, CRSF2500 and CRSF2310.

The Enrolment Activity End Date of the Student's Enrolment; used for reporting purposes.

The Enrolment Activity End Date may be overridden at many levels. (For more information, see the Statistics Subsystem Data Prerequisites Help page.)

Used for various internal reports. Will typically be aggregating by other criteria.
Reported in the 'Unit Record' Centrelink file, and in the AVETMISS file: Enrolment (NAT00120).

This system uses the following logic to derive this date:
1. Use the Override date recorded against the Student Unit Attempt (SUA) (ENRF3000).
If no Override date is found, then:
2. Use the most recent Enr Activity End Date recorded for this SCA in ENRF3600.
If no Delivery Group date is found, then:
3. Use the Enr. Activity End Date recorded for the Unit Offering Option in CRSF2210.
If no Unit Offering Option date is found, then:
4. Use the Enr. Activity End Date recorded for the Unit Offering Pattern in CRSF2210.
If no Unit Offering Pattern Date is found, then:
5. Use the Enr. Activity End Date recorded for the Unit Offering in CRSF2310).
If no Unit Offering date is found, then:
6. Use the date recorded in the Teaching Period Date Alias (CALF0220/CALF0512). (The Date Alias recorded in the Enrolment Configuration form (ENF01F0) is used to determine which date, assigned to the Teaching period, to use.)
If no Date Alias is found, then:
7. Use the End Date recorded for the Teaching Period in CALF0220.

The UNIT_COMPETENCY_IND is set to N regardless of what is recorded for the unit version in CRSF1210. This information is no longer reported to government

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

• Enrolment (NAT00120)

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

The Delivery Type of the Student's Enrolment.
When reporting granted advanced standing units:
- Delivery type is reported as an institution defined value which maps to the Government delivery type of ‘NNN’
- Government Delivery Type is reported as ‘NNN’
- Government Predominant Delivery Mode is to be reported to ‘N’.

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

Reported in the following AVETMISS file: Person (NAT00080)

Note: This field is specific to Victorian government reporting data requirements.

If the Training Organisation is not Victorian, the Course Commencement Date for the SCA will be used.

If the Training organisation is Victorian, then:

• If the unit and student course enrolment has been reported before, and the prior report is for the current SUA or for a participated unit, then the previously reported Course Commencement Date for the unit is used.
• If the unit has not been reported before (or the previous unit’s report was for a non-participated unit), but the course has, and the course still contains at least one participated unit, then the earliest Course Commencement Date reported for participated units in the course is used.
• If the student course enrolment has not been reported before, or it has been reported, but all of the units were withdrawn without participation, then the Course Commencement Date is derived from the enrolment statistics snapshot, taking the earliest enrolment activity start date with a participation indicator = Y.

Reported in the following AVETMISS File: Enrolment (NAT00120).

Note: This field is specific to Victorian government reporting data requirements

A value that identifies the hours attended by a student who withdraws from a unit of competency or subject (module) without completing all training in that unit of competency or subject (module).

This value is used for reporting in the NAT00120 Enrolment File.
The value is derived as follows:
Attended Days divided by Scheduled Days multiplied by Supervised Hours of the Student Unit Attempt, where:

• Attended Days = the number of days between the Activity Start Date and the Reportable Activity End Date.
  If a Last Attended Date has not been provided, the Discontinued Date is used instead, and the Attended Days will be calculated as the number of days between the ‘Activity Start Date’ and the ‘Discontinued Date’.
  (See the 'Discontinue' T-List item in ENR3000h.)
• Scheduled Days = the number of days between the Activity Start Date and the 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 is be used.

If the resulting ‘Hours Attended’ is greater than the scheduled hours, then the scheduled hours is reported and an exception logged to the snapshot exception report.

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

If an Override Attended Hours value for a SUA is added (not null), then that value is reported instead of the Hours Attended value.

Note: This field is specific to Victorian government reporting data requirements.

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.

Reported in the following AVETMISS file: Enrolment (NAT00120).

Note: This field is specific to Victorian government reporting data requirements.

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.

Reported in the following AVETMISS file: Enrolment (NAT00120).

Note: This field is specific to Victorian government reporting data requirements.

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

Reported in the following AVETMISS file: Enrolment (NAT00120).

Note: This field is specific to Victorian government reporting data requirements.

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.

Reported in the following AVETMISS file: Enrolment (NAT00120).

Note: This field is specific to Victorian government reporting data requirements.

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.

Reported in the following AVETMISS file: Enrolment (NAT00120).

Note: This field is specific to Victorian government reporting data requirements.

The last date of attendance for the unit attempt.

• Where the unit has been discontinued and a Last Attended date has been recorded, this will be used here
• Where the unit has been discontinued and a Last Attended date has not been recorded, the discontinuation date will be recorded here.
• Where the unit has been completed with a finalised outcome date before the Activity End Date, then the outcome date will be recorded here.
• Where the unit has been completed with a finalised outcome date after the Activity End Date, then the Activity End Date is recorded here.
• Where the unit has not been discontinued or completed, the Activity End Date will be recorded in the Reportable Activity End Date.

This value is populates the ENR_ACTIVITY_END_DT field in the GOVT_SNAPSHOT_ENROLMENT_VET table generated in STAJ8005.

For reportable Student Unit Attempts, the Enrolment Identifier is made up of the following with | between each data element:

• PERSON_ID
• COURSE_CD
• UNIT_CD
• TEACH_CI_SEQUENCE_NUMBER
• TEACH_CAL_TYPE

For reportable units in Advanced Standing, the Enrolment Identifier is made up of the following with | between each data element:

• PERSON_ID
• COURSE_CD
• AS_VERSION_NUMBER
• UNIT_CD
• VERSION_NUMBER

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.