Top of STA Index Table of Contents Feedback

STAJ8800 - Create VET Government Submission Files - VET only

Purpose

To retrieve data from the VET Government Submission Snapshot (STAJ8005), and write it to the AVETMISS files. Exceptions are logged to the job run log.

SubSystem

Statistics
Sector VET
Normally Run By Run as a batch job by the Statistics Specialist, as required or as a Standing Request.
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. May be run to reproduce previous Exception Reports.
Structure Block Create VET Government Submission Files
Tab Parameters

 

The purpose of this function is to create the following AVETMISS files:

  • Training Organisation (NAT00010)
  • Training Provider Location (NAT00020)
  • Course (NAT00030)
  • Module/Unit of Competency (NAT00060)
  • Client (NAT00080)
  • Client Postal Details (NAT00085)
  • Client Disability (NAT00090)
  • Client Prior Educational Achievement (NAT00100)
  • Enrolment (NAT00120)
  • Qualification Completed (NAT00130)
  • Unit of Competency Completed (NAT00180)
  • New Apprenticeship (NAT00200)

The parameter form enables users to define which of the above AVETMISS files are to be generated during the running of this job.

This function retrieves data from the VET Government Submission Snapshot (STAJ8005), to produce the AVETMISS files. Exceptions are logged to the job run log.

Each file is a 'flat' file, consisting of a sequence of data records. All records consist of a set of fixed length fields and are terminated by two extra bytes containing a carriage return/line feed combination (ASCII codes 13 and 10).

Files are written to the KEEP directory (as defined on the System Job Control table, see below).

Refer to AVETMISS: The Standard for VET Providers, for exact detail about each of the files. This function will allow for State-specific data to be appended to the end of the file.

This form is accessed via Statistics/VET Statistics Reports and Jobs from the main menu.

The following table S_JOB_CONTROL stores control information for Job Scheduling. The values in here will be used by jobs, for example, to determine where files can be found and also where outputs should go.

S_JOB_CONTROL Reason/Description:
CONTROL_ITEM Control item is a system recognised value. For example 'KEEP' are the files to be kept.
DESCRIPTION Description of the Control Item. Institution-defined.
CONTROL_VAL

This field contains the value of the Control Item. For example, it may contain the path name for a directory.
UPDATE_WHO The name of the user who last updated the table.
UPDATE_ON The Date and Time the record was last updated.  

 

The Create VET Government Submission Files block contains:

Parameters Tab

  • Submission Details

VET File Selection

Check the check box for each of the following files to be created for the Submission Details defined above:

  • NAT00010 - Training Organisation check box
  • NAT00020 - Training Organisation Delivery Location check box
  • NAT00030 - Course check box
  • NAT00060 - Module/Unit of Competency check box
  • NAT00080 - Client check box
  • NAT00085 - Client Postal Details check box
  • NAT00090 - Disability check box
  • NAT00100 - Prior Educational Achievement check box
  • NAT00120 - Enrolment check box
  • NAT00130 - Qualification Completed check box
  • NAT00180 - Unit of Competency Completed check box

Rules/Notes:

For further information on tables and fields for each 'NAT' file, see DIISRTE guidelines and Understanding VET Statistics and the VET Government Submission Snapshot (STAJ8005).

All fields are mandatory. Check boxes must be either checked or unchecked.

To run a VET Government Submission File job, complete the following parameters:

  • Submission Details: - Specify the submission for which the Government Snapshot is to be run, for example, 2004 1, 2004 2. Use the list of values (LOV) to select a submission.

  • VET File Selection: - De-select the check box for each file not required for the selected Submission details defined in the previous parameter (above). These files will not be created.

 

Rules/Notes:

When the State Identifier is equal to ‘02’ (Victoria), the following fields are included in some of the AVETMISS files to report Government data for the state of Victoria:

Field: SMS Source: Position: Length:
Training Organisation (NAT00010) File:
Contact Name CONTACT_NAME 269 60
Telephone Number PHONE_NUMBER 329 20
Facsimile Number FAX_NUMBER 349 20
E-mail Address EMAIL_ADDR 369 20
Software Product Name

'Callista SMS nn.n' where ‘Callista SMS’ is concatenated with the software release number at the time of the Load Type End Date.
Where nn.n is the current release number. e.g. 12.1 rounded to one decimal place. e.g. 'Callista SMS 12.1'

 449 20
Client (NAT00080) File:
Victorian Student Number S_PERSON_ID_TYPE = SGSN 155 9
Enrolme00120) File:
Outcome Identifier - Training Organisation OUTCOME_CD 93 3
Funding Source - State Training Authority V_STATE_FS 96 3
Client Tuition Fee No value, must be blank. 99 3
Fee Exemption/Concession Type Tthe Government Concession Type (that the Person Concession Type is mapped to) where the Person Concession Type has a System Status of Verified and the Concession start date is less than or equal to the SUA enrolment activity start date and the Concession end date is null or greater than or equal to the SUA enrolment activity start date. 103 1
Purchasing Contract Identifier Derived and reported for a SUA where a Student Course Attempt's has a Course Category Skills Reform Indicator as Y. 104 12
Purchasing Contract Schedule identifier No value, must be blank 116 3
Hours Attended Value based on ENRF3000. Derived in SUA T-List Override Hours (SUA.DSP_HRS_ATTENDED). 119 4
Course Commencement Date Derived by reporting the Earliest Enrolment Activity Start Date (SUA.ENR_ACTIVITY_START_DT_ALIAS) out of all of the SUA units (including Adv Std units -granted date) where the SUA Enrolment Status does not have a status of UNCONFIRM for the SCA. 123 8
Eligibility Exemption indicator SCA.FUNDING_SOURCE_EXEMPT_IND 131 1
VET FEE-HELP (Income Contingent Loan) Indicator If the Funding Source has Vet Fee indicator as true and Student Status is 401 – 409 or 501 – 509 then the Vet Fee-Help Indicator will be Y, otherwise N. 132 1
Industry code (ANZSIC) The value to be captured will be the SUA Override Govt Industry CD if it is not null, otherwise report the SCA Govt Industry CD if it is not null, otherwise the field can be blank. 133 2
Carriage Return/Line Feed (ASCII 13/10)   135 2

 

Last Modified on December 9, 2010

History Information

Release Information Project Change to Document
13.1 1323 - Online Help Consolidation Changed colour, updated link.
12.1.0.1 1647 - VIC AVETMISS Reporting Added list of new fields in Notes section, and transferred the S_JOB_CONTROL table here from the Vet Statistics process Help page.
10.1.0.3 1506 - AVETMISS NAT85 Added NAT00085 - Client Postal Details and edited this online Help page.