Statistics Subsystem Data Pre-requisites

For VET Sector information, select the hyperlink below.

VET Information

This document describes the data which must be established, assumptions which must be met and actions which must take place prior to using the Statistics Subsystem snapshot processes.

Note: After any of the Statistics jobs have been run, the Job Run Log should be checked. It will identify the reasons for a job failing, and missing and incorrect data.

Title Description

Articulated Courses

Articulated courses (Undergraduate Courses from which students can continue directly into a related Undergraduate Honours Course or Masters Courses from which students can continue directly into a related Masters Honours Course) should be defined using the Articulated Course Rule (CRSF1700).

Attendance Types

The load ranges applying to full-time and part-time Attendance Types must be specified (in CRSF1170)

Calendar Structure

Calendars of type ACADEMIC, TEACHING must exist in (CALF0220).

TEACHING must be related to the relevant ACADEMIC Calendar Instances (CALF0330).

Student Unit Attempts are included in the Enrolment Statistics Snapshot based on their Unit of Study Census Date. For the defined Collection Year (1/1 to 31/12, not 1/9 to 31/8) the process will identify all Teaching Periods with a Census Date within the Year and return all enrolments (excluding SUA’s with a status of UNCONFIRM, INVALID or DUPLICATE) for the Teaching Periods.
If a Teaching Period has multiple Census Dates the process will use the first Census Date.

LOAD

100% load for a unit is attributed to a unit at the Unit Of Study Census Date. Load is no longer split by Load Calendars and Default Load Apportionment.

Load will continue to be split by Teaching Responsibility, Organisational Unit and Discipline.

CHESSN

CHESSN is used to manage the:

  • Student Learning Entitlements (SLE)
  • Higher Education Loan Programme (HELP) and
  • Commonwealth Learning Scholarships

There is a requirement for all students who are:

  • Commonwealth Supported (which includes students seeking HECS-HELP and OS-HELP assistance)
  • Accessing FEE-HELP assistance or
  • In receipt of a Commonwealth Learning Scholarship

to have a Commonwealth Higher Education Student Support Number (CHESSN).

CHESSNs are maintained in ADMF32W0 - Maintain CHESSN Number and are required in Record Enrolments - ENRF3000 and Direct Admissions - ADMF3000. Other related CHESSN files are:

  • ADMJ3900 - Batch CHESSN Allocation Request
  • ADMJ3910 - Batch CHESSN Allocation Results and
  • AUDF3192 - Person CHESSN Detail History

Course Categories

Course Versions that are always Government reportable should exist in a user-defined Course Category called 'GOVT-RPT'.

Course Versions that are never Government reportable should exist in a user-defined Course Category called 'GOVT-NORPT'. Types of Course Versions that should never be reported are ELICOS (English Language Intensive Courses for Overseas Students)

Existence of a Course Version in either of the above user-defined Course Categories overrides any other System logic, except Unit Categories, to report/not report a Course Version.

Course Categories are maintained in CRSF1130.

Course Field of Education

Every combined course (e.g. double degree) should have a major and supplementary field of Education recorded for it (in CRSF1260). If no supplementary field of education is recorded for a combined course, the major field of Education is reported in the Government statistics against both the Field of Education Code (element 461) and the Field of Education Supplementary Code (element 462).

Course Groups

All combined courses (e.g. double degrees) should be included in a Course Group with a System Course Group Type of 'COMBINED'.

Where students are able to (or must) move between courses considered to be equivalent, the equivalent courses must all belong to the same Course Group of System Type EQUIV. The statistics Subsystem uses course equivalence in determining whether or not a student is a commencing student.
For example, course AAA100 undergoes structural changes. The changed course is named AAA107. The courses are judged to be equivalent. The two courses are placed in a Course Group with a meaningful name. Students who were enrolled in AAA100 and now enrol in AAA107 can then be identified as returning rather than commencing students.

All courses which are 'related' for purposes of statistical reporting (including COMBINED courses) should belong to a Course Group of System Course Group type 'GOVT-RET' (Government Return). This is required for derivation of the commencing student check box.

Course Groups are maintained in CRSF11D0.

Course of Study

Different Course Versions which are essentially the same course are reported as being a particular course of study (DEST element 394). Course of study must be recorded for these 'like' courses using the course reference code function.

Create an institution defined Reference Code Type mapped to the System Reference Code Type CRSOFSTUDY, using CRSF11C0. It is recommended that the Reference Code Type also be called CRSFOFSTUDY.

Add the course of study to 'like' Course Versions using CRSF1290, accessed via CRSF1210. It is recommended that the Course Code of one of the 'like' Course Versions be used as the course of study code.

Courses

The Course Code reported to the Government is the Course Code concatenated with the Version Number of the course.

For a course to be included in the Course file there needs to be a Course Offering Instance of the course within the submission year.

Data from prior submissions

It is assumed that data from prior submissions is converted from Legacy Systems to Callista. Data for the GOVT_STUDENT_ENROLMENT is all that is required. Institutions may want to transfer data to other table (e.g. GOVT_STUDENT_LOAD_LIABILITY) in order to have a complete set of data in Callista. Data should be transferred from as far back in time as possible in order to make the statistics more accurate. The routine to determine whether a student is a commencing student or not requires this data. Also, specific files, such as the Past Course Completions file, require this data.

Government Snapshot Details

The Government Snapshot Details will need to be set up before the Enrollment Statistics Snapshot is run (STAF1350).

Government Values

It is assumed that Government values reported to DEST are set up according to the definitions in the DEST manual.

Institution Address

The institution address is reported to the Government in the Student Contribution Due file. An address of type 'GOVT-CNTCT' must be created for the institution so that DEST address elements can be identified.

On the Address Type table (ORGF0116) create an address type of 'GOVT-CNTCT'. The following components of the address type are mandatory -

  • Address Line 1 (Represents DEST element 427 - Institution Address Part 1.)
  • Address Line 2 (Represents DEST element 428 - Institution Address Part 2. )
  • Address Line 3 (Represents DEST element 429 - Institution Suburb.)
  • Address Line 4 (Represents DEST element 430 - Institution State.)
  • Postcode (Represents DEST element 431 - Institution Postcode.)
  • Phone 1 (Represents DEST element 425 - Institution Contact Phone Number.)
  • Phone 2 (Represents DEST element 426 - Institution Contact Fax Number.)

Create an Institution Address of address type 'GOVT-CNTCT' (ORGF0122)

On the Institution Address table the Contact Person will map to DEST element 424 - Institution Contact Name.

Ensure the institution address is effective as at the semester date of the Student Contribution Due File (DEST element 421 - Semester Date).

Organisational Units

Local Organisational Units are those belonging to the local institution.

If the Govt Org Unit Code field in ORGF0141 contains a value then that value will be reported to the Government, however if there is nothing in this field then a value derived from the Org Unit Code is reported. ( If the Org Unit Code value is less than 4 characters in length then it is reported, however, if it is 4 characters or more in length then the 2nd, 3rd and 4th characters are reported. )

Person Addresses

Student address details (postal and permanent) are reported to the Government in the Student Contribution Due file. Two views have been created to be able to determine the student address details -

PERSON_ADDR_GOVT_POST_V (Permanent Address)

Columns are -

  • person_id
  • start_dt
  • end_dt
  • addr_part_1 DEST element 406
  • addr_part_2 DEST element 407
  • addr_part_3 DEST element 408
  • postcode DEST element 409
  • os_addr_ind (Whether or not the address is an overseas address.)

PERSON_ADDR_GOVT_PERM_V (Postal Address)

Columns are -

  • person_id
  • start_dt
  • end_dt
  • addr_part_1 DEST element 410
  • addr_part_2 DEST element 411
  • addr_part_3 DEST element 412
  • postcode DEST element 413
  • os_addr_ind (Whether or not the address is an overseas address.)

These views are based on user-defined address types and they will need to be customised for each institution. (This will require assistance from your MIS/IT specialists)

For example, the student's permanent address is represented by the address types 'HOME' or 'OS-HOME' and the student's postal address is represented by the address types 'POSTAL' or 'OS-POSTAL'. The local address will be used in preference to an overseas address.

Ensure addresses for student's are effective as at the semester date of the Student Contribution Due File (DEST element 421 - Semester Date).

Research Units

Research Units may or may not be set up with an Enrolled Credit Point value (CRSF2210). These units are put into the GOVT-RPT Category to ensure that they will be reported to Government. If a student undertakes a Research Unit in a research Teaching Period, the credit point value is not considered. If a Research Unit is undertaken in an 'ordinary' Teaching Period, the credit point value is considered and must be recorded for the unit.

Submission Census Dates

A Census Date is no earlier than 20% of the way through each Unit of Study Teaching Period.

If required, submissions for government reporting normally take place six weeks after the Census Date, or if required, following SLE/HELP Revisons File (STAJ1620)

Teaching Calendar Census Date

The user-defined Census Date Alias that will be used as the Census Date for each Teaching Calendar must be defined on the System General Calendar Configuration table (ENRF01F0).

Unit Categories

Unit versions that are always Government reportable should exist in a user-defined Unit Category called 'GOVT-RPT' (unless EFTSL = 0).

Unit versions that are never Government reportable should exist in a user-defined Unit Category called 'GOVT-NORPT'. Types of unit version that should never be reported are complementary units, continuing units.

Existence of a unit version in either of the above user-defined Unit Categories overrides any other system logic to report/not report a unit version.

Unit categories are maintained in CRSF2120.

 

Last Modified on 10 January, 2005