| Top of STA | Index | Table of Contents | Feedback | |
This section of the user manual provides an overview of the Statistics Subsystem and its use for the production of Government statistical returns.
This is a highly specialised part of Callista, intended for the use of statistics specialists only.
Statistics Reference Data is maintained in other Subsystems. Refer to the Statistics Subsystem Table of Contents (above) for details.
To Understand HE Statistics, see hyperlink below.
| Understanding HE Statistics |
Topics covered here include:
Users of the Statistics Subsystem and Required Knowledge
The production of Government Statistics is a job for the Specialist Statistics Officer. It requires an intimate knowledge of both the requirements of AVETMISS statistical reporting and the data sources within Callista. Users of this Subsystem need to be familiar with the contents of the AVETMISS manual. It is the basis upon which this Subsystem is designed. They need a broad understanding of System wide functionality and a detailed operation of the Enrolments and Job Control and Scheduling Subsystems. This manual provides the necessary information in the System Overview, Enrolments Subsystem and Job Control and Scheduling Subsystem chapters. Help for a specific topic can be found using the Index.
Setting up the Statistics subsystem prior to its first use requires some programmer/analyst activity. This is detailed in Statistics Subsystem Data Pre-requisites.
Maintenance of Statistics Related Data in Callista
The entry of data used by the Statistics Subsystem is distributed throughout other Subsystems. For instance, Course and Unit information originates in the Course Structure and Planning Subsystem and is used in the Enrolments Subsystem. Users entering this data do not require detailed knowledge of the Statistics Subsystem.
For the Statistics Subsystem to function, specific reference data must be created and maintained in other Subsystems (for example, specific Calendar Instances and Date Alias Instances must be created in the Calendar Subsystem). These pre-requisites are detailed below. This data is usually created by a System Administrator or by the Specialist responsible for the Subsystem concerned.
Government Codes, as specified in the AVETMISS manual, are recorded throughout the System. In most cases one or more institution defined codes map to a Government Code and it is the institution defined code which is used by the majority of users. Institution and Government Codes are usually created and maintained by a System Administrator or by the Specialist responsible for the Subsystem concerned.
Pre-requisites for Government Statistics Processing
Setup
Specific data must be created in other Subsystems in order for the Statistics Subsystem to function correctly. This data is detailed in Statistics Subsystem Data Pre-requisites and must be established prior to running data 'snapshots'.
Statistics Reference/Control Data
Two reference data/control forms related to Statistics Snapshots exist in the Statistics Subsystem:
The VET Enrolment Statistics form must be used to set up control details for a particular submission prior to the Government Submission Snapshot process (STAJ8005).
The Government Statistics Process
The broad processes involved in preparing a Government Statistics Submission are described here. Where more detailed explanations are required, refer to How the Government Statistics Process Works.
Government reportable data is maintained routinely in Callista. For example, Student Addresses and Course and Unit details are maintained as part of the business of the institution. A set of specific codes used for Government reporting is also maintained in the System. An example is Government Attendance Types.
Enrolment Statistics Snapshots
Preparations for Government Statistics Submissions commence with the creation of an Enrolment Statistics Snapshot. These snapshots are produced as frequently as the institution requires (by running STAJ8000 in the Job Control and Scheduling Subsystem) and can be used for pre-submission data checking (by utilising the Government Statistics Process to identify validation errors) or other institution purposes such as Enrolment Analysis. The snapshots record Course and Unit data for all students except those with Unit Attempt Status UNCONFIRM, INVALID or DUPLICATE at the point in time at which the capture process takes place. Each record is broken down to the level of Teaching Responsibility and Discipline Group within a Student Unit Attempt within a Student Course Attempt. Precise information about the data included in the Enrolment Snapshot is contained in How the Government Statistics Process Works.
An Enrolment Statistics Snapshot Exception Report (STAR8000) is produced which lists those records not included in the snapshot, as errors. A reason is provided for each exception, permitting identification and resolution of problems.
Unwanted Enrolment Snapshots should be deleted using the Delete Enrolment Statistics Snapshots process (STAJ8002) on a regular basis, due to the large amount of storage space they consume.
Government Submission Snapshots
A Government Submission Snapshot is the snapshot used to create the extract files used in AVETMISS. These snapshots can be created as required and used in AVETMISS to check data at any time prior to the actual submission being produced. (Note: For a particular Submission Year, number and type, only one Government Snapshot is retained in the System. Running the Government Snapshot process again, overwrites the existing version.) The data to be included in a snapshot is determined by the parameters specified in the Maintain Government Snapshot Control form (STAF8005), the parameters specified when job STAJ8005 is run and by database routines which extract and derive data in accordance with the file specifications detailed in the AVETMISS manual. The documentation for STAF8005 provides some general information on data selection but the AVETMISS manual should be referred to for specific detail. Precise information about the data included in the Government Snapshot is contained in How the Government Statistics Process Works.
Production of the AVETMISS Submission involves determining that a particular Enrolment Snapshot reflects the Enrolment situation at the Census Date. This Enrolment Snapshot may by necessity have been created after the Census Date, to allow for processing of retrospective Enrolment/Discontinuation transactions (by staff with Override Variation Cut-off Date authority). The Government Submission Snapshot process (STAJ8005) is run via Job Scheduler. It uses the chosen Enrolment Snapshot to identify which records to consider for reporting in the Government Submission and as a source of some data. The remaining required data is extracted or derived from other parts of the System. Other checks are performed by the System to determine if records should be included in the Government Submission (for example, 'Is unit enrolled as at the Census Date?). These are detailed in the AVETMISS manual.
Creating the Government Extract Files
Having created the Government Submission Snapshot, the following jobs are run in Job Scheduler (regardless of the submission number and type) to create the extract files required for AVETIMISS.
(Note: Not all files are created for each submission. Refer to the documentation for each file and the AVETMISS manual - Section 6: File Specifications, for a list of those files included in each submission.)
| Description |
Details |
|
STAJ8000 |
Create VET Enrolment Statistics Snapshot |
|
| STAF8000 | VET Enrolment Statistics Snapshot Control | Details |
STAJ8002 |
Delete VET Enrolment Statistics |
|
STAJ8005 |
Create VET Government Submission Snapshot |
|
| STAF8005 | VET Government Snapshot Control | Details |
STAJ8800 |
Create Government Submission Files |
|
STAJ0120 |
Copy Extract File to Secure Area |
The extract files are output to a secure directory specified by the 'KEEP' environment variable. Files in the 'KEEP' directory cannot be accessed by users. The files can be copied from this secure directory, to a user directory in which they can be accessed, using the Copy Extract Files From Secure Area process (STAJ0120). The user directory is specified by the 'USER' environment variable (refer to your System Administrator).
Use of extract files is covered by 'Steps in Preparing and Sending Returns to AVETMISS and the ATO', of the AVETMISS manual.
Errors produced should be fixed by amending data in the 'live' database and repeating the process above.
Note: After any of the Statistics jobs have been run, the Job Run Log should be checked. It will identify both the reasons for a job failing, and missing and incorrect data.
Finalising the Submission
The final step in Callista, following the forwarding of a submission to AVETMISS is to 'close off update access' to the submission. This is done by setting the Completion Date for the submission in the Government Snapshot Control form (STAF8005). A logical date to use would be the date the submission was forwarded to AVETMISS.
Last Modified on 17 August, 2006