Derivation of Values in the Government Statistics Process

Various data elements included in the government statistics data extracts are derived by Callista from other information. Recorded below are broad explanations of the logic used in Callista to derive each of these values. The basis of this logic is contained in the definition of the relevant element as it appears in the DEST student collection manual. Refer to the DEST manual for further information. For the sources of other data contained in the statistics files see The Government Submission Process.

Table: ENR_STATISTICS_SNAPSHOT

ATTENDANCE_MODE

the mode of attendance (e.g. on campus) of the student's course attempt

329

for each student course attempt, records with EFTSU greater than zero (i.e. only units with load), and records with zero EFTSU but only where the unit attempts have a unit category of GOVT-RPT, are selected from the enrolments statistics snapshot. The unit mode of each of these records is determined from its unit class (refer CRSF2160). Where all records are of the same unit mode, that mode is entered in this file as the course attempt attendance mode. Where records are of different unit modes, the course attempt attendance mode is set to 'multi-modal'.

Note that the enrolment statistics snapshot considers all records (both government reportable and non-reportable) for this derivation, whereas the government submission snapshot only considers reportable units.

 ATTENDANCE_TYPE

the attendance type (e.g. part-time) of the student

330

the total EFTSU of the student, across all course/unit attempts linked to the submission (course/unit attempts in government semesters 1,3 and 5 for submission 1, and 2 and 4 for submission 2), is calculated from records for the student contained in the enrolments statistics snapshot. The calculated EFTSU is then compared to the load ranges for full and part-time attendance as specified in CRSF1170 (for the Enrolment Statistics Snapshot) and to the DEST specified load ranges for full and part-time attendance (ie. PT < 0.373 EFTSU, FT >= 0.373 EFTSU) (for the government submission snapshot).

 Note that the enrolment statistics snapshot considers all records (both government reportable and non-reportable) for this derivation, whereas the government submission snapshot only considers reportable units.

 MAJOR_COURSE

indicates whether or not this course attempt is the student's major course

331

the sum of the EFTSU is calculated for each student course attempt, from the records in this snapshot. For each student with more than one course attempt, records for the course attempt with the greatest EFTSU (where two course attempts have the same EFTSU, the one with the earliest commencement date) are set to '2 - Major Course'. Other course attempts are set to '3 - Minor Course'. Records for students with only one course attempt are set to '1'.

 COMMENCING_STUDENT_IND

indicates whether or not the student is considered a commencing student

-

refer to Derivation of a Commencing Student

 SCHOOL_LEAVER

indicates whether or not the student is considered a school leaver

-

checks the Commencing Student indicator in this file. If the student is not a commencing student, then the student is not a school leaver and 1 is inserted

for commencing students, checks the student's current statistics record (ENRF3000 or ADMF3000 > ENRF3060) and if:

  • no record is found, the student is classed as an other commencing student and 8 is inserted
  • any prior education value indicates that the student has completed all requirements of a qualification higher than secondary education, 2 is inserted
  • any prior secondary education value indicates that the student completed their final year of secondary education in the current collection year or the previous year, 3 is inserted
  • any prior secondary education value indicates that the student completed their final year of secondary education earlier than the year prior to the current collection year, 4 is inserted
  • any prior secondary education value indicates that the student has completed their final year of secondary education but no information on the year of completion is provided, 9 is inserted

 NEW_TO_HIGHER_EDUCATION

indicates whether or not the student is attempting higher education for the first time

-

checks the Commencing Student indicator in this file. If the student is not a commencing student, then the student is not new to higher education and 1 is inserted

for commencing students, checks the student's current statistics record (ENRF3000 or ADMF3000 > ENRF3060) and if:

  • no record is found, the student is classed as a commencing student but no information on prior higher education course, and 9 is inserted
  • the prior postgraduate, degree and subdegree (not TAFE) fields all =100, the student has never commenced a higher education course prior to this one, and 2 is inserted
  • either the prior postgraduate, degree or subdegree (not TAFE) fields contain values commencing with 3, the student has completed all of the requirements of a higher education course prior to starting this one, and 3 is inserted
  • either the prior postgraduate, degree or subdegree (not TAFE) fields contain values commencing with 2, the student has commenced but not completed all of the requirements of a higher education course prior to starting this one, and 4 is inserted

 UNIT_LEVEL

the year level in which the unit is normally attempted for the course type of the course attempt

-

for the unit attempt within a course attempt, either:

  • retrieves the unit level from course unit level (CRSF2210 > CRSF2240) or
  • retrieves the unit level from the unit version of the unit attempt (CRSF2210) or
  • returns NULL where no values exist in either location

 EFTSU

equivalent full-time student unit load for this record

339

refer to Calculation of EFTSU

 WEFTSU

weighted EFTSU

-

calculated for each record in the enrolments statistics file using the formula:

WEFSTU = EFTSU * discipline.funding_index * unit_internal_ course_level. WEFTSU_factor

where:

  • EFTSU is the value calculated for this record (see above)
  • funding index refers to funding index 1 as recorded for the discipline group of this record in CRSF2110
  • WEFTSU factor refers to the WEFTSU factor recorded against the unit internal course level (CRSF2180) which is an attribute of the unit version of this record (CRSF2210)

At Deakin University only:

  • if the discipline group is 201, the teaching responsibility org unit is 03 and the unit internal course level is 1, funding index 2 is used in the calculation
  • if the discipline group code is 503 and the unit level of the unit version is either 3, 4, 8 or 9, funding index 2 is used in the calculation

 GOVT_REPORTABLE_IND

 indicates whether or not this record should be considered for inclusion in the government submission snapshot

-

refer to Government Reportable Indicator

Table: GOVT_STUDENT_ENROLMENT

ATTENDANCE_TYPE

the attendance type of the student

330

as for the Enrolments Statistics Snapshot

MAJOR_COURSE

indicates whether or not this course attempt is the student's major course

331

as for the Enrolments Statistics Snapshot

 GOVT_DISABILITY

the disabilities recorded against a student, coded as per DEST specifications

386

An eight character code is derived for each student based on any disabilities recorded against the student (ENRF3000 or ADMF3000 > ENRF3040). Each character of the code has specific meaning.

  • If no disabilities are recorded, the entire code is zero filled.
  • If the person has a disability, the first character is '1'
  • If the person indicated that they did not have a disability (government type NONE) the first character is '2'
  • If the disability is of government type HEARING the second character is '1', otherwise it is zero.
  • If the disability is of government type LEARNING the third character is '1', otherwise it is zero.
  • If the disability is of government type MOBILITY the fourth character is '1', otherwise it is zero.
  • If the disability is of government type VISION the fifth character is '1', otherwise it is zero.
  • If the disability is of government type MEDICAL the sixth character is '1', otherwise it is zero.
  • If the disability is of government type OTHER the seventh character is '1', otherwise it is zero.
  • If the Contact indicator is selected (=Y) and a disability is recorded for the student, the eighth character is '1'.

OR

  • If the Contact indicator is not selected (=N) and a disability is recorded for the student, the eighth character is '2'.

OR

  • if no disability data exists for the student, the eighth character is zero.

SEPARATION STATUS CODE

Separation status applies to Higher Degree by Research (HDR) courses.

465

This one digit code is determined using Student Course attempt records

If student is transferring from one HDR course to another at the same level (at this university) then 1 is inserted.

If student is commencing an HDR course and upgrading from Masters to Doctorate without having completed the masters degree. (at this university) then 2 is inserted

If student is commencing an HDR course and downgrading from Doctorate to Masters without having completed the masters degree. (at this university) then 3 is inserted

Otherwise (including students who transfer from an HDR in another university to an HDR course in this university), a 9 is inserted.

Table: GOVT_STUDENT_LIABILITY

GOVT_SEMESTER

 the government semester for which the record is being reported

353

For the current submission year and submission number and for each government reportable (or warning) record in the enrolments statistics snapshot, the government semester to which the student unit attempt teaching period is related (either via Government Semester Load Override or Government Semester Load Calendar)(STAF1340) is determined.

 TOTAL_EFTSU

total EFTSU for a student course attempt within a government semester.

379

the sum of the EFTSU of all records for a student course attempt, by government semester, contained in the GOVT_STUDENT_LOAD table.

 INDUSTRIAL_EFTSU

 total EFTSU for a student course attempt within a government semester, calculated from those student unit attempts within the course attempt where the unit version has its industrial indicator selected (CRSF2210).

383

for a student course attempt (within a government semester), the sum of the EFTSU of all records contained in the GOVT_STUDENT_LOAD table, where the Industrial indicator is set (Y).

 HECS_PREXMT_EXIE

 The HECS liability calculated for an amount of EFTSU for
non-work experience in industry student load

384

using the load calendar associated with the student course attempt, the related fee assessment period is determined (FINF2800 or FINF2100 > FINF1720). The HECS liability for this assessment period is obtained from the Student Finance subsystem. (FINF3610)

 HECS_AMOUNT_PAID

 The amount which has been paid by a student for the Higher Education Contribution Scheme liability for a semester

381

using the load calendar associated with the student course attempt, the related fee assessment period is determined (FINF2100 > FINF1720). HECS payments recorded for this assessment period are totalled. (FINF3610)

 TUITION_FEE

 Tuition fee charged in respect of the amount of EFTSU (for the student course attempt) being reported

391

using the load calendar associated with the student course attempt, the related fee assessment period is determined (FINF2800 or FINF2100 > FINF1720). The total tuition fee for this assessment period is calculated. (FINF3610)

Table: GOVT_STUDENT_LOAD

GOVT_SEMESTER

 the government semester for which the record is being reported

353

for the current submission year and submission number and for each government reportable (or warning) record in the enrolments statistics snapshot, the government semester to which the student unit attempt teaching period is related (either via Government Semester Load Override or Government Semester Load Calendar)(STAF1340) is determined.

 UNIT_COMPLETION_STATUS

A code which identifies whether a student has completed, failed, withdrawn from, will commence later in the year or is still in the process of completing a unit of study

355

the unit completion status is determined for each record in the Enrolments Statistics Snapshot.

If the unit attempt no longer exists, the student must have withdrawn without penalty and the status is set to 1

grades are checked for the remaining student unit attempts and from the grading schema, grade - result mapping (ASSF5110), the result for the unit attempt is obtained.

If the result is WITHDRAWN, the unit completion status is set to 1

If the result is FAIL, the status is set to 2

If the result is PASS, the status is set to 3

Otherwise the status is set to 4 (Unit of study to be commenced later in the year or still in process of completing or completion status not yet determined)

 

 

Updated 11 March 2002