Top of STA | Index | Table of Contents | Feedback |
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. |
The Delete VET Enrolment Statistics Snapshots block contains: Parameters Tab
|
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:
Reported in the following Centrelink files:
|
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:
Reported in the following Centrelink file:
|
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:
Reported in the following Centrelink file:
|
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:
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:
|
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:
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 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:
Reported in the following Centrelink file:
|
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:
Reported in the following Centrelink file:
|
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:
Reported in the following Centrelink file:
|
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:
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):
If specified, this value will be reported in the following Centrelink file:
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):
If specified, this value will be reported in the following Centrelink file:
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:
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:
|
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:
|
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:
|
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:
Reported in the following Centrelink file:
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:
|
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:
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:
|
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:
|
VET_IN_SCHOOLS_IND | This field identifies whether a unit of competency/modules of a course. Reported in the following AVETMISS file:
|
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. |