STAJ8002 - Delete VET Enrolment Statistics Snapshots - VET only

Purpose

To delete Enrolment Statistics Snapshots that are no longer required.

SubSystem

Statistics

Sector VET
Normally Run By As a batch job, by the Statistics specialist, as required or as a standing request.
Anticipated Frequency As often as required to manage data storage.
Structure Block Delete VET Enrolment Statistics Snapshots
Tab Parameters

 

Enrolment Statistics Snapshots are created when the process STAJ8000 is run. This may be as often as nightly. Each snapshot requires the storage of large volumes of data. It is likely that only a small proportion of the snapshots created need to be saved for future reference.

The Statistics Specialist can determine which snapshots should be saved, 'flagging' these snapshot records by de-selecting the Delete check box for each, using STAF8000.

When this job is run, only snapshots with their Delete check box still set will be deleted.

There are two tables involved in this job:

For details on each of these tables, see below.

This form is accessed through the main menu.

 

The Delete VET Enrolment Statistics Snapshots block contains:

Parameters Tab

  • Number Of Snapshots To Keep
Rules/Notes:

The single parameter is used to specify the number of snapshots which should be retained. The job retains the most recent snapshots until the specified number is reached. Once the specified number is reached, all of the remaining snapshots with their Delete check box set are deleted, while remaining snapshots with their Delete check box de-selected are added to the set of retained snapshots.

Rules/Notes:

There is no output from this job.

The following tables are involved in this job:

ENR_STAT_SNAPSHOT_CTL_VET Reason/Explanation
SNAPSHOT_DT_TIME The Date of the Snapshot. Defined in STAJ8000.  
DELETE_SNAPSHOT_IND The Delete checkbox in STAF8000. Cannot delete if already used in Government Snapshot. 
UPDATE_WHO The name of the user who last updated the record.  
UPDATE_ON The Date and Time the record was last updated.  
COMMENTS User defined Comments. Defined in STAF8000.  

 

ENR_STAT_SNAPSHOT_VET

Reason / Explanation

SNAPSHOT_DT_TIME The date/time stamp that uniquely identifies the Enrolment Snapshot set of records.
PERSON_ID

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_CD

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

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.
UV_VERSION_NUMBER
SCA_LOCATION_CD The Location of the Student's Course Enrolment. Used for various internal reports. Defined in ORGF0131 - Maintain Locations.
SUA_LOCATION_CD

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.

ATTENDANCE_MODE_NOMINATED The nominated Attendance Mode of the Student's Course Enrolment. Used for various internal reports. Defined in CRSF1160 - Maintain Course Attendance Modes.
ATTENDANCE_TYPE_NOMINATED The nominated Attendance Type of the Student's Course Enrolment. Used for various internal reports, especially for aggregating contact hours. Defined in CRSF1170 - Maintain Attendance Types.
COMMENCING_COURSE_ID

Indicates whether or not the student is enrolling in the Course for the first time within the Training Organisation.Used for various internal reports.

If student_course_attempt.commencement_dt is before 01/01/<Submission Year> then set commencing_course_id to 3, otherwise, set it to 4.

Reported in the following AVETMISS files:

  • Enrolment (NAT00120)
GOVT_TRAINING_ORG_UNIT_CD

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.

GOVT_TRAINING_OU_START_DT
CRV_RESP_ORG_UNIT_CD The Responsible Organisational Unit of the Course Version the student is enrolled in or has Advanced Standing in. Used for various internal reports, and determining who is responsible for the Student's Enrolment.
CRV_RESP_OU_START_DT
COURSE_TYPE

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.

GOVT_COURSE_TYPE
SCHEDULED_HOURS

The Scheduled Hours for the Student's Enrolment. 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
PARTICIPATION_IND

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.

ENR_ACTIVITY_START_DT

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

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
ENR_ACTIVITY_END_LAMP The source of the Enrolment Activity End Date. The Enrolment Activity End Date may be recorded at many levels. This column will indicate the level at which the Enrolment Activity End Date was sourced. This field is also the lamp value that is displayed next to the Enrolment Activity End Date fields in ENRF3000, CRSF2500 and CRSF2310.
UNIT_COMPETENCY_IND

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

INCL_VET_GOVT_ENR_FILE_IND Indicates whether or not a superior/subordinate unit should be included in the Enrolment File (NAT00120). If a Superior/Subordinate Unit is not marked for inclusion in the Enrolment File (NAT00120), but it is a Unit Of Competency, and has been successfully completed, then it needs to be reported in the Unit Of Competency Completed File (NAT00180). Only relevant for Superior/Subordinate Units Enrolments. Will always be set to 'Yes' for standalone units. Will always be set to 'Yes' for Advanced Standing units. Used for internal reporting and by the process that creates the VET Government Submission Snapshot (STAJ8005).
FINALISED_SUAO_IND Indicates whether or not the student has a finalised Student Unit Attempt Outcome. If a student has a finalised Student Unit Attempt Outcome, but no Outcome Code, then they will not be Government Reportable. However, if the student does not have a finalised Student Unit Attempt Outcome, and no Outcome Code, then an institution may elect to include them in the VET Government Submission as an incomplete Enrolment. Only relevant for Student Unit Attempts and will be set to 'Yes' for Advanced Standing Units. Used for internal reporting and by the process that creates the VET Government Submission Snapshot (STAJ8005).
REFERENCE_CD_QUAL

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

REFERENCE_CD_UOC

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

LOAD_CAL_TYPE The Load Period of the Student's Enrolment. The Load Period will determine the percentage of contact hours to be included against the Snapshot record (as defined by the Load Calendar Structure - ENRF01K0). The Load Period will be null for Advanced Standing data. The Load Sequence Number is defined in STAJ8005
LOAD_CI_SEQUENCE_NUMBER
TEACH_CAL_TYPE The Teaching Period that the student is enrolled in the Unit Version. The Teaching Period will be null for Advanced Standing data. These fields will be an indication that the record is a Student Unit Attempt and not an Advanced Standing unit. Used for various internal reports.
TEACH_CI_SEQUENCE_NUMBER
FUNDING_SOURCE

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.

GOVT_FUNDING_SOURCE
STUDY_REASON_CD

Displays the Study Reason defined to the Student Course Attempt. 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)
GOVT_STUDY_REASON_CD

Displays the Government Study Reason that is mapped to the Study Reason defined to the Student Course Attempt. Defined in STAF1131 - Maintain Government Study Reason Identifier. For example, 01 - To get a job.

Reported in the following AVETMISS file:

  • Enrolment (NAT00120)
DELIVERY_TYPE

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)
GOVT_DELIVERY_TYPE
OUTCOME_CD

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.

GOVT_OUTCOME_CD
INDUSTRY_GROUP_CD 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.
GOVT_INDUSTRY_GROUP_DESCRIPTOR
INDUSTRY_SECTOR_CD
GOVT_INDUSTRY_SCTR_DESCRIPTOR
ADMIN_LOCATION_CD

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.

REMOTENESS_AREA_CD

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.

SUA_ENROLLED_DT

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
SUA_DISCONTINUED_DT

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.

UNIT_CLASS The Unit Class of the Student's Unit Enrolment. For Advanced Standing the value will always be null. Used for various internal reports. Defined in CRSF2160 - Maintain Unit Classes.
SUP_UNIT_CD The Superior Unit Version of the Student's Enrolment. Will only be set if the student is enrolled in the Superior and Subordinate Unit. For Advanced Standing the value will always be null. Used for various internal reports. The Superior Unit may be nominated to incur load or to not incur load (defined by the Unit Version). Defined in CRSF2210 - Maintain Basic Unit Details under Sub Unit Controls Tab.
SUP_VERSION_NUMBER
ADVANCED_STANDING_SOURCE The institution-defined source of the Advanced Standing (for example, RPL, Credit Transfer, Exemption With Credit, Exemption). For a Student's Unit Enrolment the value will always be null. Used for various internal reports. Defined in ADVF4200 - Create Advanced Standing Details.
GOVT_STUDY_REASON_CD

Displays the Government Study Reason that is mapped to the Study Reason defined to the Student Course Attempt. Defined in STAF1131 - Maintain Government Study Reason Identifier. For example, 01 - To get a job.

Reported in the following AVETMISS file:

  • Enrolment (NAT00120)
STUDY_REASON_CD

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)
VET_IN_SCHOOLS_IND

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

Reported in the following AVETMISS file:

  • Enrolment (NAT00120)

 

Last Modified on 22-Oct-2010 10:49 PM

History Information

Release Version Project Change to Document
13.1 1323 - Online Help consolidation Added VET label.
12.1.0.1 1647 - VIC AVETMISS Reporting

Transferred relevant table details from the 'How the VET Statistics Process Works' Help page, to this page.