Top of STA | Index | Table of Contents | Feedback | ![]() |
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. This list is not meant to be exhaustive, only a reference source. The basis of this logic is contained in the definition of the relevant element as it appears in the DIISRTE student collection manual. Refer to the HEIMS Help Internet site for further information.
For the sources of other data contained in the statistics files, or for a full listing of fields, see Understanding HE Statistics and the Government Admissions Statistics Process.
Table: ENR_STATISTICS_SNAPSHOT |
|||
Data Element | Description | Element | Source |
A code which identifies whether a student is classified as being a full-time or part-time student, based on their Student Load in the half year. |
330 |
Attendance Type in the govt_student_enrolment table is currently calculated for all students. The value is calculated by:
|
|
Indicates whether or not the student is considered a commencing student. |
- |
Refer to Derivation of Commencing Student and Commencement Date. |
|
COMMENCEMENT_DT | The Commencement Date of the Student's Course Attempt | 534
|
Refer to Derivation of Commencing Student and Commencement Date. |
SCHOOL_LEAVER |
Indicates whether or not the student is considered a school leaver. |
- |
Checks the Commencing Student check box in Enrolment Statistics Snapshot. 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:
|
NEW_TO_HIGHER_EDUCATION |
Indicates whether or not the student is attempting higher education for the first time. |
- |
Checks the Commencing Student check box 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:
|
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: |
EFTSU |
Equivalent full-time Student Unit Load (EFTSL) for this record (Field remains old EFTSU). |
339 |
Refer to Calculation of EFTSL. 0000000001 to 1000000000 EFTSU value (For example, 0.125 is coded 0125000000) |
WEFTSU |
Weighted EFTSL (Field remains old WEFTSU). |
- |
Calculated for each record in the enrolments statistics file using the formula: WEFSTL = EFTSL * discipline.funding_index * unit_internal_ course_level. WEFTSU_factor where:
|
GOVT_REPORTABLE_IND |
Indicates whether or not this record should be considered for inclusion in the Government submission snapshot. |
- |
Refer to Government Reportable check box. |
Table: GOVT_STUDENT_ENROLMENT |
|||
Data Element | Description | Element | Source |
EXEMPTION_INSTITUTION_CD | The Government Exemption Institution Code. | 566 | The logic for deriving this value is provided in the Derivation of the Government Exemption Institution Code for E566 diagram. |
PERM_RESIDENT_CD | The Government Code to which the Institution defined Residency Code is mapped. | 390 | Derived from Citizenship, Student Status and Commencement Date: When the Derive Permanent Resident Eligibility checkbox is selected in STAF1000, a value is derived. If it isn't selected, and a value exists in the Permanent Resident Status field of ENRF3060, then this value is used. If it isn't selected, and there is no value in the Permanent Resident Status field of ENRF3060, the value is set to '9' and added to the error log as a warning. Value = 0 if the person is:
Value = 1 if the person is:
Value = 2 if the person is:
Value = 3 if the person is:
Value = 9 then error. See beginning paragraph. If Permanent Resident Eligibility is coded 2 or 3 THEN Student Status Code must be 112, 302, 303, 304, 305. If Student Status is 250, 260, 261, 262, 270, 271 THEN Permanent Resident Eligibility must be coded 0. If Citizen/Resident Indicator is one of 1, 4, 5 or 8 THEN Permanent Resident Eligibility must be coded 0. If Student status code is 110, 111, 201, 202, 220, 230, 231, 232, 233 THEN Permanent Resident Eligibility must be 0 or 1. |
A code which identifies whether a student is classified as being a full-time or part-time student, based on their Student Load in the half year. |
330 |
Same
as above. |
|
An eight-character code indicating responses to three questions about disabilities. |
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: 1st character - 0
- Student did not indicate the existence of a disability, impairment or
long term medical condition 2nd character - 0
- Student did not indicate she/he has a hearing disability 3rd character - 0
- Student did not indicate she/he has a learning disability 4th character - 0
- Student did not indicate she/he has a mobility disability 5th character - 0
- Student did not indicate she/he has a visual disability 6th character - 0
- Student did not indicate she/he has a medical disability 7th character - 0
- Student did not indicate she/he has an other disability 8th character - 0
- Student did not indicate that she/he has a disability |
|
SEPARATION_STATUS_CD | The Separation status of a student enrolled in a Higher Degree Research course (HDR). | 465 | This one digit code is determined using Student Course Attempt records. Code 1 Student is commencing a Higher Degree Research course and is transferring from one Higher Degree Research course to another Higher Degree Research course at the same level at the same Higher Education Provider. Code 2 Student is commencing a Higher Degree Research course and is upgrading from a Masters by Research course to a Doctorate by Research course at the same Higher Education Provider, without having successfully completed the initial degree. Code 3 Student is commencing a Higher Degree Research course and is downgrading from a Doctorate by Research course to a Masters by Research course at the same Higher Education Provider, without having successfully completed the initial degree. Otherwise a 9 is inserted. Students who transfer from a Higher Degree Research course in one Higher Education Provider to a Higher Degree Research course at another Higher Education Provider, regardless if there has been a change of level are to be recorded as '9'. |
COMMENCEMENT_DT |
A code which indicates the month and year in which the student commenced the current course for the first time. |
534 |
If Student Status Code is 201, 202, 203, 230, 231, 233, 260, 270 THEN Course of Study Commencement Date should be equal to or greater than the Calendar Value of 200501. Warning if it is not. |
COMMENCING_LOCATION | Commencing Location Code of permanent home residence. | 476 |
Code 00001 - Not a Domestic school leaver commencing an undergraduate
course. Only for Domestic
school leaver students commencing an undergraduate course. This code must reflect the permanent home residence of the student in the last year of their secondary study and is to be provided by the student when the course is first commenced. |
COMMENCING_GEOGRAPHIC_LOC | Commencing Geographic Location Deviation. | Commencing Geographic Location is inserted in the govt_student_enrolment table. This value is derived from the person_statistics table. It uses the person_statistics record which is current as at the Census Date (31st March for submission 1 and 31st August for Submission 2). If no person_statistics record is found, or the person_statistics record does not have a value for commencing_geographic_loc, then a NULL will be inserted into the field. If the student is a Commencing Student, their Government Citizenship Code is 1,2 or 3 and they are 20 years of age or under on the 30th June of the Submission Year, then an error will be logged. | |
GOVT_SCHOLARSHIP_TYPE | Government Scholarship Type. | Sourced from Govt Scholarship Type recorded in SCHF1200. If the scholarship is not recorded in SCHF1200, but instead is recorded in RESF3500, then the value comes from the govt scholarship type that is defined for the scholarship type recorded there. |
|
Table: GOVT_STUDENT_LOAD_LIABILITY |
|||
Data Element | Description | Element | Source |
Total EFTSL for a Student Course Attempt within a Government Semester. |
- |
Total EFTSL for the Unit of Study split by Teaching Organisation Unit. Replaces Total EFTSU. |
|
STUDENT_STATUS | A code which indicates the Student Status for a Unit of Study. | 490 | Contribution-liable students from 2005. Note: Codes 110, 111, 112, 220 and 250 are no longer valid for the Load Liability file but may be valid in the Revisions file Code 240 “Received loans through OS-HELP” is not to be used on the Load/Liability File. This code is only to be used in the HELP-DUE File in respect of students who are reported on the OS-HELP File. A domestic postgraduate research student who is not RTS supported may be charged tuition fees or awarded an Exemption scholarship under code 270. If regional adjustment package has been used to support such students, these students should be included under code 270. A domestic postgraduate research student charged tuition fees may receive FEE-HELP assistance. FOR ATO purposes only, Element 380 (Liability status codes) will be concorded to Element 490 (Student status):
|
An indicator of whether a unit of study consists wholly of work experience in industry. |
337 |
Code
0 - Student is not undertaking work experience in industry or student
is undertaking work experience in industry where learning and performance
is directed by the provider. Students coded as '0' are not considered to be undertaking a unit of study consisting wholly of work experience in industry. Students coded as '1' are considered to be undertaking a unit of study consisting wholly of work experience in industry and the provider may charge a student contribution amount or tuition fee. Students coded as '2' are considered to be undertaking a unit of study consisting wholly of work experience in industry and the unit of study is student contribution and tuition fee exempt. A Work Experience
in Industry unit of study for which no credit is given (and therefore
has no EFTSL value), is not to be reported to DIISRTE. |
|
MAX_STUDENT_CONTRIBUTION_IND | Derived from Student Status and Differential HECS Indicator. | 392 | If the Student Unit Attempt has a census date that falls between the start and end dates of the student status record for that course attempt, and the Override maximum student contribution field is populated (in ENRF3110) then the value from that Override Code will be used. Otherwise: Otherwise: Otherwise the Override Code is 0. |
GOVT_COHORT_YR | The year in which a student cohort commenced their course of study. | 522 | This field is populated with NULL value. |
UNIT_OF_STUDY_HELP_DEBT | The HELP debt amount due for a unit of study. | 558 | HECS-HELP IF Student Status (E490) = 110, 111, 201, or 202 THEN FOR each Student ID (E313) / Course code (E307) / Unit of study code (E354) record where Student Status (E490) = 110, 111, 201, or 202 SUM all values for Amount paid up front (E381) and Total Amount charged (E384) END FOR IF SUM of Amount paid up front (E381) >= $500 or is <$500 but >= 80% of the SUM of Total Amount charged (E384) THEN The “realvalue” of Amount paid up front (E381) = 1.25 x Amount paid up front (E381) END IF IF SUM of Amount paid up front (E381) < $500 and < 80% of the SUM of Total Amount charged (E384) THEN The “realvalue” of Amount paid up front (E381) = Amount paid up front (E381) END IF Unit of study HELP debt (E558) = Total Amount charged (E384) - “real value” of Amount paid upfront (E381) END IF FEE-HELP FOR each Student ID (E313) / Course code (E307) / Unit of study code (E354) record where Student Status (E490) = 220, 230, 231, 232, or 233 IF Amount paid up front (E381) < Total Amount charged (E384) THEN Unit of study HELP debt (E558) = Total Amount charged (E384) - Amount paid up front (E381) + Loan Fee (E529) END IF END FOR |
Table: GOVT_ADM_SNAPSHOT_APPL |
|||||||||||||||||
Data Element | Description | Element | Source | ||||||||||||||
application_id |
Application ID |
700 | A derived field based upon Person ID, application type and Admission Application Number. The following standard applies: PPPPPPPPPPXNNN where:
In the case that an Application does not exist, such as in a transfer, a number representing a pseudo application number starting at zero will be used for the Application Number represented by NNN in the above business rule. This value will be generated and will be consistent for the Person ID across submissions by assigning transfers a pseudo application number in transfer date ascending order. |
||||||||||||||
adm_appl_status | Application Status | 701 | Element 701, is derived using the Admission Application Status and its mapped Government Application Status. If the application is the result of a transfer, Element 701 will be set as ‘1’ – Current application. Applications where all preferences for the application that have a System Admission Outcome Status of WITHDRAWN will have a Government Application Status of ‘2’ – Application withdrawn by applicant, regardless of the institution mapping on Maintain Admission Application Status (ADMF02A0). |
||||||||||||||
aus_scndry_edu_ass_type |
Australian Secondary Education Assessment Type (Year 12 Result Type) | 702 (Y12-RESULT TYPE) |
Element 702 is derived by determining the Government Secondary Education Assessment Type mapping of Assessment Type from the Australian Secondary Education Assessment record. Selection criteria for the Australian Secondary Education record is as follows:
|
||||||||||||||
ib_score | International Baccalaureate Aggregate score | 710 | This element is derived as follows:
|
||||||||||||||
prior_post_grad | Prior postgraduate course year | 730 | Can be mapped from the currently collected Element 359 as follows:
|
||||||||||||||
prior_degree | Prior bachelor course year | 731 | Is mapped from the currently collected Element 360 as follows:
|
||||||||||||||
prior_subdeg | Prior sub-degree course (HE) year | 732 | Can be mapped from the currently collected Element 361 as follows:
|
||||||||||||||
prior_subdeg_vet | Prior sub-degree course (VET) year | 733 | Can be mapped from the currently collected Element 362 as follows:
|
||||||||||||||
prior_vet_award | Prior VET award course year | 734 | Can be mapped from the currently collected Element 363 as follows:
|
||||||||||||||
prior_seced_vet | Prior secondary education through VET sector year | 735 | Can be mapped from the currently collected Element 364 as follows:
|
||||||||||||||
prior_seced_school | Prior secondary education at school year | 736 | Can be mapped from the currently collected Element 365 as follows:
|
||||||||||||||
prior_other_qual | Other qualification/certificate year | 737 | Can be mapped from the currently collected Element 366 as follows:
|
||||||||||||||
teritary_entrance_score | Tertiary entrance score | 369 | Can be mapped from the currently collected values as follows:
|
||||||||||||||
Table: GOVT_ADM_SNAPSHOT_PREF |
|||||||||||||||||
Data Element | Description | Element | Source | ||||||||||||||
preference_number | Preference Ordinal Position | 713 | Preference Ordinal Position is derived as:
|
||||||||||||||
govt_adm_sector_fee_type | Sector Code | 724 | Can be derived by the Government Sector Fee Type mapping associated with the Type of Place for this preference. If there is no Government Sector Fee Type mapping, then the default value for Government Sector Fee Type will be used. | ||||||||||||||
govt_field_of_education | Field Of Education Code | 461 | Use existing rules for derivation. | ||||||||||||||
govt_field_of_education_supp | Field Of Education Supplementary Code | 462 | Use existing rules for derivation. | ||||||||||||||
attendance_mode | Mode Of Attendance Code | 329 | Can be mapped from the currently collected values as follows:
|
||||||||||||||
govt_location_cd | Course Campus Post Code | 559 | Is derived using the Government Location Code for the Admission Course Application Instance Location Code. | ||||||||||||||
intake_dt | Intake Date | 709 | Is derived using the Course Start Date Alias. (Date format is Year and Month only stored as YYYYMM.) | ||||||||||||||
Table: GOVT_ADM_SNAPSHOT_OFFER |
|||||||||||||||||
Data Element | Description | Element | Source | ||||||||||||||
basis_for_admission_type |
Basis For Admission to offered course |
327 |
Use existing rules for derivation. |
||||||||||||||
preference_number | Preference Ordinal Position | 713 | Is derived in Preference Related Details above. | ||||||||||||||
offered_dt | Date Offered | 705 | Is derived using the Offer Date. (Date format is stored as YYYYMMDD.) Where Date Offered cannot be provided, use Reference Date from the Government Admission Snapshot Control | ||||||||||||||
adm_offer_resp_status | Response Code | 723 | Can be derived using the following:
|
Last Modified on 5 October, 2010
Release Version | Project | Change to Document |
13.0.0.2 | 1323 - Online Help Consolidation | Updated link to Understanding HE Stats. |
11.0.0.3, 11.1.0.3, 12.0.0.2, 12.1 | 1573 - University Applications and Offers Data Collection | Added Admissions tables and elements |
11.1 | 1600 - Compliance 2010 | New derivation of MAX_STUDENT_CONTRIBUTION_IND. |
11.1 | 1505 - DIISRTE Compliance | Added data for elements 490, 566 and 392 |
11.0.0.0.0.0 | 1437 - Scholarships Part 2 | Added SCHOLARSHIP_TYPE for GOVT_STUDENT_ENROLMENT |
10.1 | 1340 -DIISRTE-2007 Pt2 | Modified details for elements 392 and 522 |
10.0.0.1.0.0 | C21229 | Added MAX_STUDENT_CONTRIBUTION_IND row to GOVT_STUDENT_LOAD_LIABILITY table |
10.0.0.0.0 | 1033 -Internally raised calipso | Added link to 'Derivation of Commencing Student and Commencement Date' for COMMENCING_STUDENT_IND and COMMENCEMENT_DT Data Elements. |