Create VET Government Snapshot

STAJ8005 - Create VET Government Submission Snapshot - VET only

Purpose	To produce a point in time snapshot of Enrolment, Government Fee Liability and Load data contained in the system for use in producing Government Statistical Returns.
SubSystem	Statistics
Sector	VET
Normally Run By	Run as a batch job by the Statistics Specialist, as required.
Anticipated Frequency	Must be run once for each Government Submission, but is likely to be run a number of times for each Submission in order to identify missing or errant data. Can be run to reproduce previous Exception Reports.
Structure	Block	Create VET Government Submission Snapshot
	Tabs	New Submission
		Previous Submission
		Report Production Details

The Government Submission Snapshot process is run in order to capture a snapshot of data from Callista. The 'snapshot' consists of collecting data from throughout Callista and storing it in separate Callista tables. Separate jobs are run to create each extract file from the Government Snapshot.

Government Snapshot tables can be used:

to check data,
to trial data through the Government Submission process for the purpose of ensuring data integrity, and
as a source of statistical information if the institution desires.

At an appropriate time after the Census Date, one of the VET Enrolment Statistics Snapshots is selected as being representative of the enrolment situation at the Census Date, and is used in the production of the VET Government Submission Snapshot. The VET Enrolment Statistics Snapshot used is specified as a parameter for this job.

This job receives information from STAJ8000 - Create VET Enrolment Statistics Snapshot and passes it on to STAJ8800 - Create VET Government Submission Files.

The tables involved in STAJ8005 are:

GOVT_SNAPSHOT_CTL_VET
This table defines the Submission Year and Submission Number for the AVETMISS Submission. This process (STAJ8005) will link this table to the relevant VET Enrolment Statistics Snapshot, that is the basis of the VET Government Submission Snapshot. Once a submission is considered complete, the Completion Date can be set via STAF8005.
GOVT_SNAPSHOT_LOAD_CAL_VET
Defines the Load Periods that will determine the contents of the VET Government Submission Snapshot. The data on this table is used by the process that creates the VET Enrolment Statistics Snapshot (STAJ8000), which forms the basis of the Government Submission Snapshot.
GOVT_SNAPSHOT_TRAINING_ORG_VET
Defines the government training organisations within a submission. An institution may deliver courses for more than one government training organisation. The institution is required to report details of enrolments for each of the government training organisations. For example, CDU deliver courses for DEET and for the South Australian state authority, hence, they will be required to create a government submission for each of these training organisations. This table contains the reportable data to be included in the Training Organisation File (NAT00010).
GOVT_SNAPSHOT_TRAINING_LOC_VET
All unique locations for a Submission and Government Training Organisation on the VET Government Snapshot Enrolment table will be included on this table. The data on this table will be included in the Training Provider Location File (NAT00020).
GOVT_SNAPSHOT_COURSE_VET
All unique courses for a Submission and Government Training Organisation on the VET Government Snapshot Enrolment table and VET Government Snapshot Qualification Completed table will be included on this table. Where more than one version of the course exists on the source tables, details from the highest version will be used. The data on this table will be included in the Course File (NAT00030).
GOVT_SNAPSHOT_UNIT_VET
All unique units for a Submission and Government Training Organisation on the VET Government Snapshot Enrolment table and VET Government Snapshot Unit Of Competency Completed table will be included. Where more than one version of the unit exists on the source tables, details from the highest version will be used.
The data on this table will be included in the Module/Unit Of Competency File (NAT00060).
GOVT_SNAPSHOT_PERSON_VET
All unique person ID’s for a Submission and Government Training Organisation on the VET Government Snapshot Enrolment table and VET Government Snapshot Qualification Complete table will be included on this table. The data on this table will be included in the Client File (NAT00080).
GOVT_SNAPSHOT_PERSON_ADDR_VET
Address details for all unique person ID’s for a Submission and Government Training Organisation on the VET Government Snapshot Enrolment table and VET Government Snapshot Qualification Complete table will be included on this table. The data on this table will be included in the Client File (NAT00085)
GOVT_SNAPSHOT_DISABILITY_VET
Disability details of all unique person ID’s for a Submission and Government Training Organisation on the VET Government Snapshot Person table will be included on this table. The data on this table will be included in the Client Disability File (NAT00090).
GOVT_SNAPSHOT_PRIOR_ED_VET
Prior educational achievements of all unique person ID’s for a Submission and Government Training Organisation on the VET Government Snapshot Person table will be included on this table. The data on this table will be included in the Client Prior Educational Achievement File (NAT00100)
GOVT_SNAPSHOT_ENROLMENT_VET
Government reportable enrolments and advanced standing for a Submission and Government Training Organisation will be included on this table.
The data on this table will be included in the Enrolment File (NAT00120).
GOVT_SNAPSHOT_QUAL_COMP_VET
Student course attempts that have been completed in the submission year or the year prior to the submission year (but not already reported) will be included on this table. The data on this table will be included in the Qualification Completed File (NAT00130).
GOVT_SNAPSHOT_UOC_COMP_VET
Student unit attempts, for unit of competencies, that have been completed in the submission year, but not included in the VET Government Snapshot Enrolment will be included on this table. This scenario will only ever occur for superior/subordinate units, where the superior/subordinate is a unit of competency and the subordinate/superior is a module, and the module unit is reported in the Enrolment File. The data on this table will be included in the Unit Of Competency Completed File (NAT00180).
GOVT_SNAPSHOT_APPRENTICE_VET
This data is no longer used. The data on this table was included in the New Apprenticeship File (NAT00200).
GOVT_SNAPSHOT_ENROL_VET_VIC
Victorian Government reportable enrolments and advanced standing for a Submission and Victorian Government Training Organisation are included on this table. This table is an extension of the GOVT_SNAPSHOT_ENROL_VET table, but stores Skills VIC data only, specific to the state of Victoria. The data on this table is included in the Enrolment File (NAT00120).

The Create VET Government Submission Snapshot block contains:

New Submission Tab

Submission (LOV)
Govt Training Organisation (LOV)
VET Enrolment Statistics Snapshot (LOV)
OR
Use Most Recent Enrolment Statistics Snapshot check box
Refresh Qualification Completed Data Only check box
Incomplete Government Outcome Code
Include Incomplete Enrolment check box

Previous Submission Tab

Previous Log Creation Date

Report Production Details Tab

Report Level
Message Number

Rules/Notes:

To run a VET Government Submission Snapshot, select Statistics/VET Statistics Reports and Jobs/STAJ8005 - Create VET Government Submission Snapshot from the main menu. Enter values in the following parameters:

New Submission Tab

Submission: Used to specify the submission for which the Government Snapshot is being run, (for example, 2004 1, 2004 2). Select a submission from the list of values (LOV).

Govt Training Organisation: Use the LOV to specify the Government Training Organisation for this Submission.

VET Enrolment Statistics Snapshot: Used to specify the Enrolment Statistics Snapshot to be used by this job. Either specify a Snapshot here, or leave this parameter blank and select (tick) the Use Most Recent Enrolment Statistics Snapshot check box.

Use Most Recent Enrolment Statistics Snapshot: Select (tick) this check box to use the most recently produced Enrolment Snapshot. If the check box is selected, you must leave the previous parameter, VET Enrolment Statistics Snapshot, blank.
Leave the check box unselected if you specified a snapshot in the previous parameter, VET Enrolment Statistics Snapshot.

Refresh Qualification Completed Data Only: Select this check box if the submission has already been created. (i.e. if the job has been run previously for the same parameters.)

Incomplete Government Outcome Code: Use the LOV to select the required Incomplete Government Outcome Code.

Included Incomplete Enrolments: Select this check box to include incomplete enrolments in the Snapshot.

Previous Submission Tab

Previous Log Creation Date: Specify a Previous Log Creation Date, to reproduce the Exception Report from a previous run of this job. Use the LOV to select a previous log record. If this parameter is used, the VET Enrolment Statistics Snapshot parameter must be left blank and the Use Most Recent Enrolment Statistics Snapshot parameter must be left blank (unselected).

Report Production Details Tab

Report Level: Use the LOV to select 'SUMMARY ONLY' or 'ALL'. SUMMARY ONLY is used for an initial run of this job for a particular Government submission. This produces a statistical summary of the various errors (exceptions) logged during the process. Large volume errors can then be addressed en-masse.
Use the ALL option for subsequent runs so that lower volume errors can be addressed on a record by record basis.

Message Number: Specify an error log message number to display only those records with this message number, in the Exception Report. This is useful for isolating and dealing with one error at a time.

The GOVT_SNAPSHOT_ENROL_VET_VIC table is only populated if the Govt State code is 02 (Victoria) in the GOVT_SNAPSHOT_TRAINING_ORG_VET table.

Details of the data included in the tables involved in STAJ8005 are listed below:

GOVT_SNAPSHOT_CTL_VET	Reason/Explanation
SUBMISSION_YR	This field describes the Submission Year as four digits numeric. For example, 2005. Defined in STAF8005.
SUBMISSION_NUMBER	This field describes the Submission Number up to three digits numeric. For example, 401 or simply 1. Defined in STAF8005.
REP_NOM_HRS_FOR_SCHD_HRS_IND	This field indicates if scheduled or nominal hours are to be reported. Found in STAF8005 as 'Report Nominal Hours' check box.
ESSV_SNAPSHOT_DT_TIME	Indicates the Vet Enrolment Snapshot that was used as the basis for the Vet Government Snapshot. Taken from the Snapshot Date/Time field in the Submissions Tab of STAJ8005.
COMPLETION_DT	The date on which the Submission was made. The Enrolments Statistics Snapshot Date and Time cannot be updated if this field is set. Defined in STAF8005.
UPDATE_WHO	The name of the user who last updated the record.
UPDATE_ON	The Date and Time the record was last updated.

GOVT_SNAPSHOT_LOAD_CAL_VET	Reason/Explanation
SUBMISSION_YR	This field describes the Submission Year as four digits numeric. For example, 2005. Defined in STAF8005.
SUBMISSION_NUMBER	This field describes the Submission Number up to three digits numeric. For example, 401 or simply 1. Defined in STAF8005.
LOAD_CAL_TYPE	Specifies the Load Periods that will form the basis of the Enrolment Statistics Snapshot. Defined in STAF8005.
LOAD_CI_SEQUENCE_NUMBER	The Load Period (Sequence Numbering) of the Student’s Enrolment. Defined in STAJ8005.
UPDATE_WHO	The name of the user who last updated the record.
UPDATE_ON	The Date and Time the record was last updated.

GOVT_SNAPSHOT_TRAINING_ORG_VET	Reason/Description
SUBMISSION_YR	This field describes the Submission Year as four digits numeric. For example, 2005. Defined in STAF8005.
SUBMISSION_NUMBER	This field describes the Submission Number up to three digits numeric. For example, 401 or simply 1. Defined in STAF8005.
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
TITLE	The Title is taken from STAF112U - Maintain Government Training Organisation.
ADDR_LINE_1	The Address Line may be taken from ORGF0142 - Maintain Organisational Unit Addresses. See Institution Address field. Note: The following fields down to FAX_NUMBER (excluding GOVT_STATE), are determined by institutions, and can be sourced from wherever the institution nominates. See Section 3.2 Training Organisation Address in stats_vet.doc for further details.
ADDR_LINE_2	The Address Line may be taken from ORGF0142 - Maintain Organisational Unit Addresses.
LOCALITY	The Locality may be taken from ORGF0142 - Maintain Organisational Unit Addresses.
POSTCODE	The Postcode may be taken from ORGF0142 - Maintain Organisational Unit Addresses. See Institution Postcode field.
GOVT_STATE	The Government State is defined in STAF112W - Maintain Government State. The System State Table (S_STATE) fields list the differences between HE/VET. For example, VET for NSW is 01, VIC is 02, where as HE for NSW is NSW and VIC is VIC. To identify Skills Vic data, the GOVT_STATE code is equal to 02 (Victoria).
CONTACT_NAME	The Contact Name may be taken from ORGF0142 - Maintain Organisational Unit Addresses. See Contact Person field
PHONE_NUMBER	The Phone Number may be taken from ORGF0142 - Maintain Organisational Unit Addresses. See Contact Phone Number field.
FAX_NUMBER	The Fax Number may be taken from ORGF0142 - Maintain Organisational Unit Addresses. See Contact Fax Number field. This field may be blank.
TRAINING_ORG_TYPE	The Training Organisational Type is taken from ORGF0119 - Maintain Training Provider Type.
GOVT_TRAINING_ORG_TYPE	The Government Training Organisational Type is taken from STAF112Q - Maintain Government Training Provider Type.
UPDATE_WHO	The name of the user who last updated the record.
UPDATE_ON	The Date and Time the record was last updated.
EMAIL_ADDR	E-mail Address. Populated from OAGVV.EMAIL_ADDR for all states. This field may be blank.

GOVT_SNAPSHOT_TRAINING_LOC_VET	Reason/Description
SUBMISSION_YR	This field describes the Submission Year as four digits numeric. For example, 2005. Defined in STAF8005.
SUBMISSION_NUMBER	This field describes the Submission Number up to three digits numeric. For example, 401 or simply 1. Defined in STAF8005.
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
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).
TITLE	The Title of the Training Location. Defined in ORGF0131 - Maintain Locations. See Locations Classification Tab for field.
TRAINING_PROVIDER_TYPE	This field is no longer populated.
GOVT_TRAINING_PROVIDER_TYPE	This field is no longer populated.
GOVT_TRAINING_CNTRY_CD	The Government Training Country Code. Defined in ORGF0131 - Maintain Locations. See Validations.
GOVT_STAT_LOCAL_AREA_CD	The Government Statistical Local Area Code. Defined in ORGF0131 - Maintain Locations. See Locations Classification Tab for field.
GSLA_S_STATE_CD	The Government State Code. Defined in ORGF0131 - Maintain Locations. See Government Location Tab for field.
GOVT_STATE	The Government State is defined in STAF112W - Maintain Government State. The System State Table (S_STATE) fields list the differences between HE/VET. For example, VET for NSW is 01, VIC is 02, where as HE for NSW is NSW and VIC is VIC.
POSTCODE	The Postcode may be taken from ORGF0142 - Maintain Organisational Unit Addresses. See Institution Postcode field. The Locality is taken from ORGF0142 - Maintain Organisational Unit Addresses. See Institution Suburb field. Note: These two fields are determined by institutions, and can be sourced from wherever the institution nominates. See Section 3.3 Training Provider Location Address in stats_vet.doc for further details.
LOCALITY
UPDATE_WHO	The name of the user who last updated the record.
UPDATE_ON	The Date and Time the record was last updated.

GOVT_SNAPSHOT_COURSE_VET	Reason/Description
SUBMISSION_YR	This field describes the Submission Year as four digits numeric. For example, 2005. Defined in STAF8005. An error is reported if this field is blank.
SUBMISSION_NUMBER	This field describes the Submission Number up to three digits numeric. For example, 401 or simply 1. Defined in STAF8005. An error is reported if this field is blank.
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. An error is reported if this field is blank.
GOVT_TRAINING_OU_START_DT
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. Sourced from GOVT_SNAPSHOT_ENROLMENT_VET and GOVT_SNAPSHOT_QUAL_COMP_VET tables. An error is reported if this field is blank.
VERSION_NUMBER
TITLE	The Title of the Course. Defined in CRSF1210 - Maintain Basic Course Details by Institution. See main block for the Title field. An error is reported if this field is blank.
COURSE_TYPE	The Course Type. Defined in CRSF1210 - Maintain Basic Course Details. See main block for the Course Type field. Institution defined, Course Type indicates the type of course. Examples are: 'Advanced Diploma', 'Diploma', 'Certificate 1-4 and 'Non Award Course'. Reported in the following AVETMISS file: Course (NAT00030) An error is reported if this field is blank.
GOVT_COURSE_TYPE	The Government 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) Defined in STAF1121 - Maintain Government Course Codes. An error is reported if this field is blank.
FIELD_OF_STUDY_MAJOR	A classification of courses based on similarity in terms of the vocational field of specialisation or the principal subject matter of the course. Defined in CRSF1260 - Maintain Course Fields of Study. See Field of Study block, then Field of Study field. An error is reported if this field is blank.
GOVT_FIELD_OF_STUDY_MAJOR	Defined in CRSF1140 - Maintain Fields of Study. See Field of Study block, then Govt Field of Study. An error is reported if this field is blank.
OCCUPATION_TYPE_MAJOR	Occupation Types are assigned to each Course Version to identify the types of occupations that may be expected for those undertaking the Course or Program of Study. This mapping will be enforced for all VET-sector courses when set to ACTIVE, and will be used to derive the required ANZSCO (Occupation Type) information for AVETMISS reporting. CRSF12H0 - Maintain Course Occupation Type. See Course Occupation Type block, then the Occupation Type field. An error is reported if this field is blank.
GOVT_OCCUPATION_TYPE_MAJOR	Each institution-defined value must map to Government Occupation Type value for reporting purposes. Defined in STAF112L - Maintain Government Occupation Types and CRSF11K0 - Maintain Occupation Types. For example, value 3112-13 equals Earth Science Technical Officer. An error is reported if this field is blank.
VET_IND	The Vet check box is found in CRSF1210 - Maintain Basic Course Details, under the VET tab. An error is reported if this field is blank.
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. An error is reported if this field is blank.
REFERENCE_CD_DESC_QUAL	The Course Qualification Reference Code. See CRSF1290 - Maintain Course Reference Codes. The Course Version block displays current Course Version record from CRSF1210 (see above). The displayed records in the Course Reference Code block, are the alternative Reference Codes for the context record. An error is reported if this field is blank.
CONTACT_HOURS	The Course Contact Hours. Defined in CRSF1210. An error is reported if this field is blank.
RECOGNITION_TYPE	The Recognition Type. Defined in CRSF1210 under the VET Tab. Recognition Types are used to distinguish courses by their level of recognition within the VET sector.Each Recognition Type is mapped to a Government Recognition Type to enable derivation of a course's highest level of recognition as used in the AVETMISS reporting. See also CRSF11J0 - Maintain Recognition Type. An error is reported if this field is blank.
GOVT_RECOGNITION_TYPE	The Government Recognition Type. Defined in STAF112K - Maintain Government Recognition Type, under Govt. Recognition Type field. For example, 11 ACCREDITED - Leads to national training package qualification. An error is reported if this field is blank.
UPDATE_WHO	The name of the user who last updated the record. An error is reported if this field is blank.
UPDATE_ON	The Date and Time the record was last updated. An error is reported if this field is blank.

GOVT_SNAPSHOT_UNIT_VET	Reason/Description
SUBMISSION_YR	This field describes the Submission Year as four digits numeric. For example, 2005. Defined in STAF8005. An error is reported if this field is blank.
SUBMISSION_NUMBER	This field describes the Submission Number up to three digits numeric. For example, 401 or simply 1. Defined in STAF8005. An error is reported if this field is blank.
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. An error is reported if this field is blank.
GOVT_TRAINING_OU_START_DT
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 Sourced from GOVT_SNAPSHOT_ENROLMENT_VET and GOVT_SNAPSHOT_QUAL_COMP_VET tables. An error is reported if this field is blank.
VERSION_NUMBER
TITLE	The Title of the Unit. This is defined in CRSF2210 - Maintain Basic Unit Details. An error is reported if this field is blank.
UNIT_COMPETENCY_IND	The Unit of Competency Check box is found under the Contact Hours Tab in CRSF2210 - Maintain Basic Unit Details. An error is reported if this field is blank.
VET_IND	The VET check box is found under the Contact Hours Tab in CRSF2210 - Maintain Basic Unit Details. An error is reported if this field is blank.
REFERENCE_CD_UOC	The type, or classification, of an 'other System' Unit Reference Code. This is defined in CRSF2270 - Maintain Unit Reference Codes. This is accessed through Other Unit Details button in CRSF2210, then the Reference Codes arrow from the overlay. An error is reported if this field is blank.
REFERENCE_CD_DESC_UOC	The description or name represented by the Reference Code with which it is associated. This is defined in CRSF2270 - Maintain Unit Reference Codes. This is accessed through Other Unit Details button in CRSF2210, then the Reference Codes arrow from the overlay. An error is reported if this field is blank.
SUPERVISED_CONTACT_HOURS	The nominal number of Supervised Contact Hours for the Unit, required of the student for completion of the course. This is defined in CRSF2210 - Maintain Basic Unit Details under the Contact Hours Tab. An error is reported if this field is blank.
DISCIPLINE_GROUP_CD_MAJOR	Describes the field of Academic learning or endeavour into which a Unit of Study can be classified. This is defined in CRSF2230 - Maintain Unit disciplines. This form can be accessed through Other Unit Details button in CRSF2210, then the Disciplines arrow from the overlay. An error is reported if this field is blank.
GOVT_DISCIPLINE_GROUP_CD_MAJOR	Describes the Government defined field of Academic learning or endeavour into which a Unit of Study can be classified. This is defined in CRSF2110 - Maintain Disciplines. Also see STAF1128 - Maintain Government Discipline Groups. An error is reported if this field is blank.
UPDATE_WHO	The name of the user who last updated the record. An error is reported if this field is blank.
UPDATE_ON	The Date and Time the record was last updated. An error is reported if this field is blank.

GOVT_SNAPSHOT_PERSON_VET	Reason/Description
SUBMISSION_YR	This field describes the Submission Year as four digits numeric. For example, 2005. Defined in STAF8005.
SUBMISSION_NUMBER	This field describes the Submission Number up to three digits numeric. For example, 401 or simply 1. Defined in STAF8005.
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
PERSON_ID	Defined in ENRF3090 - Maintain VET Person Statistics. This form is accessed through the main menu, or either ENRF3000, via the Vet Statistics button (second block), or through ADMF3000, via the VET Statistics button, middle block. Sourced from GOVT_SNAPSHOT_ENROLMENT_VET and GOVT_SNAPSHOT_QUAL_COMP_VET tables.
FULL_NAME	Made up of Surname and Given Names. Defined in ADMF1213 - Maintain Person Details. Also can be defined in ENRF3000, or ADMF3000.
HIGHEST_SCHOOL_LEVEL_COMP_CD	The Highest Level Completed at School. Defined in ENRF3090 - Maintain VET Person Statistics. This form is accessed through the main menu, or either ENRF3000, or through ADMF3000.
GOVT_HIGH_SCHOOL_LEVEL_COMP_CD	Defined in ENRF01S0 - Maintain School Level Completed.
HIGHEST_SCHOOL_LEVEL_COMP_YR	The Year that the Highest Level at School was Completed. Defined in ENRF3090 - Maintain VET Person Statistics. This form is accessed through the main menu, or either ENRF3000, via the Vet Statistics button (second block), or through ADMF3000, via the VET Statistics button, middle block.
SEX	Defined in ADMF1213 - Maintain Person Details. Also can be defined in ENRF3000, or ADMF3000.
BIRTH_DT	Defined in ADMF1213 - Maintain Person Details. Also can be defined in ENRF3000, or ADMF3000.
RESIDENTIAL_POSTCODE	The Postcode of where the student is presently residing. Defined in ENRF3090 - Maintain VET Person Statistics. This form is accessed through the main menu, or either ENRF3000, via the Vet Statistics button (second block), or through ADMF3000, via the VET Statistics button, middle block.
RESIDENTIAL_LOCATION	The residential location for the VET Government Snapshot process. Reported in the following AVETMISS file: Client (NAT00080) An error is reported if the Residential Location record is blank and the Residential Postcode has a value other than 0000, @@@@ or OSPC. The field may be blank if the Postcode has a value of 0000, @@@@ or OSPC.
ABORIG_TORRES_CD	A Code to describe whether or not the student is Aboriginal or Torres Strait Islander. For example, 1 = Yes. Defined in ENRF3090 - Maintain VET Person Statistics. This form is accessed through the main menu, or either ENRF3000, via the Vet Statistics button (second block), or through ADMF3000, via the VET Statistics button, middle block.
GOVT_ABORIG_TORRES_CD	Defined in ENRF01U0 - Maintain VET Aboriginal Torres Islander Codes. See also STAF112R - Maintain VET Government ASTI Codes (has a button to ENRF01U0).
HOME_LANGUAGE_CD	The code for the language spoken at home. For example 1201 = English. Defined in ENRF3090 - Maintain VET Person Statistics. This form is accessed through the main menu, or either ENRF3000, via the Vet Statistics button (second block), or through ADMF3000, via the VET Statistics button, middle block.
GOVT_HOME_LANGUAGE_CD	Defined in ENRF0130 - Maintain Language Codes. See Government Language Code field.
EMPLOYMENT_CAT	The Employment Category for the student. For example, 03 = Self Employed. Defined in ENRF3090 - Maintain VET Person Statistics. This form is accessed through the main menu, or either ENRF3000, via the Vet Statistics button (second block), or through ADMF3000, via the VET Statistics button, middle block.
GOVT_EMPLOYMENT_CAT	Defined in ENRF01R0 - Maintain Employment Category. See also STAF112M - Maintain Government Employment Category.
BIRTH_COUNTRY_CD	The Country that the student was born in. Defined in ENRF3090 - Maintain VET Person Statistics. This form is accessed through the main menu, or either ENRF3000, via the Vet Statistics button (second block), or through ADMF3000, via the VET Statistics button, middle block.
GOVT_BIRTH_COUNTRY_CD	Defined in ENRF0120 - Maintain Country Codes. See also STAF1124 - Maintain Government Country Codes.
SPOKEN_ENGLISH_PRFCNY_CD	A code to describe how well the student speaks English. For example, 3 = Not Well. Defined in ENRF3090 - Maintain VET Person Statistics. This form is accessed through the main menu, or either ENRF3000, via the Vet Statistics button (second block), or through ADMF3000, via the VET Statistics button, middle block.
GOVT_SPOKEN_ENGLISH_PRFCNY_CD	Defined in ENRF01V0 - Maintain spoken English Proficiency. See also STAF112S - Maintain Government Spoken English Proficiency.
AT_SCHOOL_FLAG	A simple Yes/No selection. Defined in ENRF3090 - Maintain VET Person Statistics. This form is accessed through the main menu, or either ENRF3000, via the Vet Statistics button (second block), or through ADMF3000, via the VET Statistics button, middle block.
DISABILITY FLAG	Derived in ENRF3040 - Maintain Person Disability Details. See also STAF112Z - Maintain Government Disability Type.
PRIOR_EDUCATION_FLAG	Derived in ENRF30A0 - Maintain Person Prior Education.
UPDATE_WHO	The name of the user who last updated the record.
UPDATE_ON	The Date and Time the record was last updated.
STATE_GOVT_STUDENT_NUMBER	State Government Student Number. Populated for all students regardless of the State Code if ALTERNATE_PERSON_ID is configured. The State Government Student Number is reported only when the Alternate Person ID is mapped to a Person ID Type of STATE_GOVT_STUDENT_NUMBER, and the STATE_GOVT_STUDENT_NUMBER End Date (ALTERNATE_PERSON_ID.END_DT) is greater than or equal to the SUA Enrolment Activity End Date (or the Submission End Date if the SUA Enrolment Activity End Date is null.)

GOVT_SNAPSHOT_POST_ADDR_VET	Reason/Description
SUBMISSION_YR	This field describes the Submission Year as four digits numeric. For example, 2005. Defined in STAF8005.
SUBMISSION_NUMBER	This field describes the Submission Number up to three digits numeric. For example, 401 or simply 1. Defined in STAF8005.
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
PERSON_ID	Unique identifier for a person.
TITLE	Person Title. e.g. Mr, Mrs, Sir, etc. This field may be blank if the State Code is 02 (Victoria) in the GOVT_SNAPSHOT_TRAINING_ORG_VET table.
FIRST_GIVEN_NAME	First given name for Person.
LAST_NAME	Person Surname.
ADDR_LINE_1	Address line 1 from correspondence address (recorded in ENRF3030). This field may be blank if the State Code is 02 (Victoria) in the GOVT_SNAPSHOT_TRAINING_ORG_VET table, and if POSTCODE has a value of 0000, @@@@ or OSPC.
ADDR_LINE_2	Address line 2from correspondence address (recorded in ENRF3030). This field may be blank if the State Code is 02 (Victoria) in the GOVT_SNAPSHOT_TRAINING_ORG_VET table.
SUBURB	Suburb from correspondence address (recorded in ENRF3030). This field may be blank if the State Code is 02 (Victoria) in the GOVT_SNAPSHOT_TRAINING_ORG_VET table, and if POSTCODE has a value of 0000, @@@@ or OSPC.
POSTCODE	Postcode from correspondence address (recorded in ENRF3030).
STATE	State from correspondence address (recorded in ENRF3030).
TELEPHONE_HOME	Home Telephone number from correspondence address (recorded in ENRF3030). This field may be blank if the State Code is 02 (Victoria) in the GOVT_SNAPSHOT_TRAINING_ORG_VET table.
TELEPHONE_WORK	Home Telephone number from correspondence address (recorded in ENRF3030). This field may be blank if the State Code is 02 (Victoria) in the GOVT_SNAPSHOT_TRAINING_ORG_VET table.
TELEPHONE_MOBILE	Home Telephone number from correspondence address (recorded in ENRF3030). This field may be blank if the State Code is 02 (Victoria) in the GOVT_SNAPSHOT_TRAINING_ORG_VET table.
EMAIL_ADDR	Email Address from correspondence address (recorded in ENRF3030). This field may be blank if the State Code is 02 (Victoria) in the GOVT_SNAPSHOT_TRAINING_ORG_VET table.
UPDATE_WHO	The name of the user who last updated the record.
UPDATE	The Date and Time the record was last updated.

GOVT_SNAPSHOT_DISABILITY_VET	Reason/Description
SUBMISSION_YR	This field describes the Submission Year as four digits numeric. For example, 2005. Defined in STAF8005. An error is reported if this field is blank and if a disability is reportable (i.e. if Person has a Disability of Y reported in the GOVT_SNAPSHOT_PERSON_VET table).
SUBMISSION_NUMBER	This field describes the Submission Number up to three digits numeric. For example, 401 or simply 1. Defined in STAF8005. An error is reported if this field is blank and if a disability is reportable (i.e. if Person has a Disability of Y reported in the GOVT_SNAPSHOT_PERSON_VET table).
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. An error is reported if this field is blank and if a disability is reportable (i.e. if Person has a Disability of Y reported in the GOVT_SNAPSHOT_PERSON_VET table).
GOVT_TRAINING_OU_START_DT
PERSON_ID	Data from GOVT_SNAPSHOT_PERSON_VET when Disability flag = 'Y'. An error is reported if this field is blank and if a disability is reportable (i.e. if Person has a Disability of Y reported in the GOVT_SNAPSHOT_PERSON_VET table).
DISABILITY_TYPE	Defined in ENRF3040 - Maintain Person Disability Details. Accessed via ADMF3000 - Direct Admissions Person or ENRF3000 - Record Enrolments. For example, Disability Types could be defined as, HEARING, INTELLECTUAL, LEARNING, MEDICAL, MOBILITY, SIGHT, etc. An error is reported if this field is blank and if a disability is reportable (i.e. if Person has a Disability of Y reported in the GOVT_SNAPSHOT_PERSON_VET table).
GOVT_DISABILITY_TYPE	Defined in STAF112Z - Maintain Government Disability Type. For example, 11 = Hearing/Deaf, while 13 = Intellectual. An error is reported if this field is blank and if a disability is reportable (i.e. if Person has a Disability of Y reported in the GOVT_SNAPSHOT_PERSON_VET table).
UPDATE_WHO	The name of the user who last updated the record. An error is reported if this field is blank and if a disability is reportable (i.e. if Person has a Disability of Y reported in the GOVT_SNAPSHOT_PERSON_VET table).
UPDATE_ON	The Date and Time the record was last updated. An error is reported if this field is blank and if a disability is reportable (i.e. if Person has a Disability of Y reported in the GOVT_SNAPSHOT_PERSON_VET table).

GOVT_SNAPSHOT_PRIOR_ED_VET	Reason/Description
SUBMISSION_YR	This field describes the Submission Year as four digits numeric. For example, 2005. Defined in STAF8005. An error is reported if this field is blank.
SUBMISSION_NUMBER	This field describes the Submission Number up to three digits numeric. For example, 401 or simply 1. Defined in STAF8005. An error is reported if this field is blank.
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. An error is reported if this field is blank.
GOVT_TRAINING_OU_START_DT
PERSON_ID	Data from GOVT_SNAPSHOT_PERSON_VET when Prior Education flag = 'Y'. An error is reported if this field is blank.
PRIOR_EDUCATION_TYPE	Defined in ENRF30A0 - Maintain Person Prior Education. This form is accessed from the main menu, or through either ADMF3000, via the Prior Ed'n button, middle block, or ENRF3000, via the Prior Ed'n button, middle block. For example, 3 = Post Secondary Education. An error is reported if this field is blank.
GOVT_PRIOR_EDUCATION_TYPE	Defined in ENRF01T0 - Maintain Prior Education Type. See also STAF112P - Maintain Government Prior Education Type. This has a button mapped to ENR01T0. An error is reported if this field is blank.
UPDATE_WHO	The name of the user who last updated the record. An error is reported if this field is blank.
UPDATE_ON	The Date and Time the record was last updated. An error is reported if this field is blank.

Each field in the following table comes from the ENR_STAT_SNAPSHOT_VET Table, except the first four fields and 'VET_IN_SCHOOLS_IND' field which are STAJ8005 parameters..

GOVT_SNAPSHOT_ENROLMENT_VET	Reason/Description
SUBMISSION_YR	This field describes the Submission Year as four digits numeric. For example, 2005. Defined in STAF8005.
SUBMISSION_NUMBER	This field describes the Submission Number up to three digits numeric. For example, 401 or simply 1. Defined in STAF8005.
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
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 An error is reported if the COURSE_CODE (Qualification/Course Identifier) is blank and the Module/Unit of Competency Identifier is part of a qualification or course enrolment.
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
CRV_VERSION_NUMBER	See COURSE_CD above.
UV_VERSION_NUMBER	See UNIT_CD above.
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)
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_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
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
GOVT_OUTCOME_CD
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
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 0, otherwise, set it to 1. Reported in the following AVETMISS files: Enrolment (NAT00120)
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
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.
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
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
TRAINING_CONTRACT_ID	The student's Training Contract Identifier. This number is allocated to a specific course (apprenticeship). Reported in the following AVETMISS files: Enrolment (NAT00120) If Govt State in GOVT_SNAPSHOT_TRAINING_ORG_VET is 02 (Victoria), then the Training Contract ID must be numeric.
APPRENTICE_CLIENT_ID	The student's Client Identifier. This number is given to the apprenticed student for life. Reported in the following AVETMISS files: 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)
STUDY_REASON_CD	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)
UPDATE_WHO	The name of the user who last updated the record.
UPDATE_ON	The Date and Time the record was last updated.

The following table, the VET Government Snapshot Qualification Completed Table has a variety of processes that need to be considered.

Determine data to be included. The data is sourced from the following tables:

Student Course Attempt
Student Course Apporved Alternative Exit

where the following conditions are met:

Completed within the submission Period or the prior Submission Period, but not already reported in the Qualification Completed File (NAT00130) in a previous submission.
The Requirements Complete check box is selected.
The Student Course Attempt is Government Reportable.
The Government Course Type is NOT:
- 999 - Education not elsewhere classified
The Course is not designed to fulfil part requirements of an AQF qualification and therefore does not lead to a recognised qualification. This is identified in Callista by a Government Course Type of:
- 912 - Other Non-Award Courses
- 991 - Statement of Attainment not Identifiable by Level
- 992 - Bridging and Enabling Courses not Identifiable by Level
- 999 - Education not elsewhere classified
The Course is not a Statement of Attainment. This is identified in Callista by a Government Course Code of:
- 991 - Statement of Attainment not Identifiable by Level

A student may have completed more than one qualification or Course entitling the student to more than one qualification. However, some qualifications or Courses have more than one approved exit qualification. Where a client has completed one qualification or Course that entitles the client to receive more than one qualification only the highest qualification conferred in the Collection Year for that particular qualification or Course should be reported.

If the Qualification Completed File (NAT00130) is being re-submitted:

The student must have already been included in the Client File (NAT00080).
The Course must have already been included in the Course File (NAT00030).
The qualification completion must not have been the result of an approved recognition process, with no training activity in the Collection Year. In Callista this is identified by completed Student Course Attempts with no Student Unit Attempt records in the Enrolment file for the Submission being processed.
The Qualification Issued Flag is updated for existing records, if it was 'No' and is now 'Yes', and
Qualifications that have been completed since the last Submission are included.

GOVT_SNAPSHOT_QUAL_COMP_VET	Reason/Description
SUBMISSION_YR	This field describes the Submission Year as four digits numeric. For example, 2005. Defined in STAF8005.
SUBMISSION_NUMBER	This field describes the Submission Number up to three digits numeric. For example, 401 or simply 1. Defined in STAF8005.
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
PERSON_ID	Data taken from Student Course Attempt (SCA) or Student Course Approval Alternative Exit (SCAAE).
SCA_COURSE_CD	Data taken from SCA or SCAAE.
COURSE_CD	Data taken from SCA or SCAAE.
VERSION_NUMBER	Data taken from SCA or SCAAE.
COURSE_RQRMNTS_COMPLETE_DT	Data taken from SCA or SCAAE.
QUALIFICATION_ISSUED_IND	'Y' if Graduand record exists for SCA or SCAAE and Conferral Date is less than or equal to Current Date.
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
UPDATE_WHO	The name of the user who last updated the record.
UPDATE_ON	The Date and Time the record was last updated.

Each field in the following table comes from the ENR_STAT_SNAPSHOT_VET Table, except the first four fields which are STAJ8005 parameters.

GOVT_SNAPSHOT_UOC_COMP_VET	Reason/Description
SUBMISSION_YR	This field describes the Submission Year as four digits numeric. For example, 2005. Defined in STAF8005.
SUBMISSION_NUMBER	This field describes the Submission Number up to three digits numeric. For example, 401 or simply 1. Defined in STAF8005.
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
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
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
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
CRV_VERSION_NUMBER	See COURSE_CD above for details.
UV_VERSION_NUMBER	See UNIT_CD above for details.
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.
UPDATE_WHO	The name of the user who last updated the record.
UPDATE_ON	The Date and Time the record was last updated.

GOVT_SNAPSHOT_APPRENTICE_VET	Reason/Description
SUBMISSION_YR	This field is no longer populated.
SUBMISSION_NUMBER	This field is no longer populated.
GOVT_TRAINING_ORG_UNIT_CD	These fields are no longer populated.
GOVT_TRAINING_OU_START_DT	These fields are no longer populated.
PERSON_ID	This field is no longer populated.
COURSE_CD	This field is no longer populated.
VERSION_NUMBER	This field is no longer populated.
API_PERSON_ID_TCI	This field is no longer populated.
REFERENCE_CD_QUAL	This field is no longer populated.
GOVT_STATE	This field is no longer populated.
POSTCODE	This field is no longer populated.
UPDATE_WHO	This field is no longer populated.
UPDATE_ON	This field is no longer populated.

The following table, GOVT_SNAPSHOT_ENROL_VET_VIC is populated when the State Code is 02 (in the GOVT_SNAPSHOT_TRAINING_ORG_VET). This table is an extension of the GOVT_SNAPSHOT_ENROLMENT_VET table (GSEV) but stores data specific to the state of Victoria only. This table is also considered in all processing that happens for GSEV, for example, when GSEV has records deleted and indexes dropped etc the same occurs for this table.

GOVT_SNAPSHOT_ENROL_VET_VIC	Reason/Description
GOVT_CONCESSION_TYPE	Fee Exemption/Concession Type Identifier. Captured in ENR-STAT_SNAPSHOT_VET. This field is mandatory.
COURSE_COMMENCEMENT_DT	Course Commencement Date. This field is mandatory and must not be blank. The date is derived by reporting the earliest Enrolment Activity Start Date (SUA.ENR_ACTIVITY_START_DT_ALIAS) out of all the SAU units where the SUA Enrolment Status does not have a status of Unconfirm for the SCA. It is captured as part of STAJ8000 from the mandatory field ENR_ACTIVITY_START_DT.
ELIGIBILITY_EXEMPTION_IND	Eligibility Exemption Indicator. Captured in ENR_STAT_SNAPSHOT_VET. This field is set as Y or N in STAJ8000. This field is mandatory.
HOURS_ATTENDED	Hours Attended. Derived for State of VIC (02). Captured in ENR_STAT_SNAPSHOT_VET. This field is mandatory.
INCOME_CONTINGENT_LOAN_IND	Vet Fee-Help (Income Contingent Loan) Indicator. Captured in ENR_STAT_SNAPSHOT_VET. This field is mandatory. This field is set as Y or N in STAJ8000.
GOVT_INDUSTRY_CD	Industry Code (ANZSIC). Captured in ENR_STAT_SNAPSHOT_VET. May be blank.

Last Modified on 01-Jun-2012 9:44 AM

History Information

Release Information	Project	Change to Document
13.1	1323 - Online Help consolidation	Added VET label. Updated links.
12.1.0.1	1647 - VIC AVETMISS Reporting	Added a new table (GOVT_SNAPSHOT_ENROL_VET_VIC) and fields, and notes for other tables. Transferred the tables from the 'How the VET Statistics Process Works' Help page to this page.
10.1.0.3	1506 - AVETMISS NAT85	Moved notes relating to parameters selection and added details relating to tables created by this job.