Top of STA | Index | Table of Contents | Feedback | ![]() |
How the Government Statistics Process Works
This section includes:
The activities involved in preparing a Government Statistics Submission are described in Understanding Statistics.
This section of the user manual explains in greater detail some of the System processes involved in those activities. Its aim is to provide an insight (only) to the logic used during data extraction.
No attempt is made to restate the data specifications provided by DEST. Refer to the relevant DEST manuals (bibliography) as the definitive source of this information.
The Enrolments Statistics Snapshot
The Enrolment Statistics Snapshot is produced by Create Enrolment Statistics Snapshot (STAJ0100). The Snapshot can be used for pre-submission data checking or for other institution purposes such as enrolment analysis. The primary purpose of the Enrolments Statistics Snapshot is however, to identify records which are to be considered for inclusion in the Government Submission Snapshot.
The Snapshot table (ENR_STATISTICS_SNAPSHOT) contains Course and Unit related data for all students except those with a Student Unit Attempt Status of UNCONFIRM, INVALID or DUPLICATE when the snapshot process takes place.
Records are included where the Teaching Period for a Student Unit Attempt that has a Census Date within the Academic Period specified by the job run parameters. Each record is broken down to the level of Teaching Responsibility and Discipline Group, within a Student Unit Attempt within a Student Course Attempt. For example, a student will have two records for a Unit where Teaching Responsibility is split between two Organisational Units.
The Enrolment Statistics Snapshot also derives a Government Reportable Indicator for each record. 'Y' for records that are government reportable. 'N' for records that are not government reportable. The Government Reportable Indicator may also be set to 'W' (Warning). This indicates that manual checking of the record should be performed.
The following table lists the data included in the Enrolments Statistics Snapshot, the DEST Element to which it is related (where applicable) and the sources of the data. Follow the links for information regarding the Derivation of Derived Values.
ENR_STATISTICS_SNAPSHOT (Enrolments Statistics Snapshot) |
|||
Data Element |
Description |
DEST Element |
Source |
SNAPSHOT_DT_TIME |
Date the Snapshot was collected |
- |
Set by the System |
CI_CAL_TYPE |
The Load Calendar with which the record is associated |
- |
No longer populated |
CI_SEQUENCE_NUMBER |
- |
||
PERSON_ID |
ID number of the student who is the subject of this record |
313 |
Student Unit Attempt |
COURSE_CD |
The Course Code of the Student's Course Attempt |
307 |
Student Unit Attempt |
CRV_VERSION_NUMBER |
Version of the Course being undertaken |
- |
Student Course Attempt |
UNIT_CD |
The Unit Code of the Unit being undertaken by the student |
354 |
Student Unit Attempt |
UV_VERSION_NUMBER |
Version of the Unit being undertaken |
- |
Student Unit Attempt |
SUA_CAL_TYPE |
The Teaching Period in which the Student Unit Attempt is enrolled |
- |
Student Unit Attempt |
SUA_CI_SEQUENCE_NUMBER |
- |
||
TR_ORG_UNIT_CD |
The Organisational Unit with Teaching Responsibility for the Unit |
333 |
(Unit Version &/or Offering Option) Teaching Responsibility. More than one Organisational Unit may be responsible for Teaching a Unit, hence for a given Student Unit Attempt there may be more than one record. |
TR_OU_START_DT |
- |
||
DISCIPLINE_GROUP_CD |
The Unit Discipline to which the Unit belongs |
- |
Unit (version) discipline. A Unit may be identified with more than one Unit Discipline, hence for a given Student Unit Attempt there may be more than one record. |
GOVT_DISCIPLINE_GROUP_CD |
The Government Discipline to which the Unit Discipline (above) is mapped |
464 |
Unit Discipline - Government Discipline Group Mapping |
CRV_ORG_UNIT_CD |
The Organisational Unit with responsibility for the Course |
- |
Course Version |
CRV_OU_START_DT |
- |
||
COURSE_TYPE |
The institution defined Course of Study Type of the Course |
- |
Course Version |
GOVT_COURSE_TYPE |
The Government Course of Study Type to which the institution defined Course Type (above) is mapped |
310 |
Course Type - Government Course Type Mapping |
COURSE_TYPE_GROUP_CD |
The Institution defined Group to which a Course Type belongs |
- |
Course Type |
SCA_LOCATION_CD |
The Location (usually a campus) at which a Student Course Attempt is considered to be located |
- |
Student Course Attempt |
ATTENDANCE_MODE |
The mode of Attendance (e.g. on campus) of the Student Course Attempt |
- |
Student Unit Attempt |
GOVT_ATTENDANCE_MODE |
The Government Attendance Mode to which the Attendance Mode (above) is mapped |
329 |
Attendance Mode - Government Attendance Mode mapping |
ATTENDANCE_TYPE |
The Attendance Type (e.g. part-time) of the student |
- |
|
GOVT_ATTENDANCE_TYPE |
The Government Attendance Type to which the Attendance Type (above) is mapped |
330 |
Attendance Type - Government Attendance Type mapping |
FUNDING_SOURCE |
The Institution defined Funding Source of the Student Course Attempt |
- |
Student Course Attempt |
GOVT_FUNDING_SOURCE |
The Government Funding Source to which the Institution defined Funding Source (above) is mapped |
- |
Funding
Source - Government Funding Source mapping |
MAJOR_COURSE |
Indicates whether or not this Course Attempt is the Student's major Course |
- |
Derived Value - No longer reported |
COMMENCING_STUDENT_IND |
Indicates whether or not the student is considered a Commencing Student |
- |
Derived Value - No longer reported |
SCHOOL_LEAVER |
Indicates whether or not the student is considered a School Leaver |
- |
Derived using Highest Attainment (493) - No longer reported |
NEW_TO_HIGHER_EDUCATION |
Indicates whether or not the student is attempting Higher Education for the first time |
- |
Derived using Highest Attainment (493) - No longer reported |
SUA_LOCATION_CD |
The Location (usually campus) at which the student is attempting the Unit |
- |
Student Unit Attempt |
UNIT_CLASS |
The Class (e.g. evening on campus, day off campus) in which the student is attempting the Unit |
- |
Student Unit Attempt |
UNIT_LEVEL |
The year level in which the unit is normally attempted for this Course Type of the Course Attempt |
- |
|
ENROLLED_DT |
The Date the Student Unit Attempt was Enrolled |
- |
Student Unit Attempt |
DISCONTINUED_DT |
The Date the Student Unit Attempt was Discontinued |
- |
Student Unit Attempt |
EFTSL |
Effective (or equivalent) Full-Time Student Load for this record |
339 |
|
WEFTSL |
Weighted EFTSL |
- |
|
UNIT_INT_COURSE_LEVEL_CD |
Attribute assigned (optionally) to the Unit for institutional purposes (typically resource allocation) |
- |
Unit Version |
GOVT_REPORTABLE_IND |
Indicates whether or not this record should be considered for inclusion in the Government Submission Snapshot |
- |
|
COMMENCEMENT_DT | The Commencement Date of the Student's Course Attempt | 328 | Student Course Attempt |
UNIT_CENSUS_DATE | Identifies all Teaching Periods with a Census Date within the year and returns all Enrolments for the Teaching Period | 489 | Unit Offering Option Teaching Calendar |
An exception report (STAR0100) is produced from this job.
When the Create Enrolment Statistics Snapshot job (STAJ0100) is run, an exception report (Enrolment Statistics Snapshot Exception Report STAR0100) is produced. The report contains details of records that cannot be included in a particular Enrolments Statistics Snapshot.
The report identifies records where critical data is missing and reports them as exceptions. The reason for the record’s exclusion from the snapshot is also included. Two types of issues may be reported:
Callista
provides Validation Checks to ensure that Course and Unit Attempts cannot be
recorded with missing data. As a result this report will usually contain no
exceptions.
The Government Submission Snapshot
A Government Submission Snapshot is created using Create Government Submission Snapshot (STAJ0110). The snapshot is then used to create some of the extract files for use in DESTPAC.
The data included in a snapshot is controlled by the details specified in the Maintain Government Snapshot Control form (STAF1350), along with parameters provided to the job. STAJ0110 uses one of the Enrolment Statistics Snapshots (created by STAJ0100), to identify records for inclusion in the Government Submission. The Enrolment Statistics Snapshot used should reflect the institution’s current enrolment situation.
The Enrolment Statistics Snapshot is used as a source for data required in the Government Submission Snapshot. The remaining required data is extracted or derived from other parts of the System. Checks are performed by the System to determine if records should be included in the Government Submission Snapshot.
For all records, except those with an ‘X’, the Government Reportable indicator is re-derived. Only those records from the Enrolments Statistics Snapshot, which now have a Government Reportable indicator of ‘Y’ (Government Reportable), or ‘W’ (Warning), are included in the Government Submission Snapshot.
The process populates the following database tables with data obtained from both the Enrolment Statistics Snapshot and other tables in Callista:
These tables are subsequently used to create some of the extract files for submission.
The Data Elements recorded in each of the Government Snapshot tables are detailed below. Against each Data Element is shown its source and the extract (where applicable) in which it is used.
GOVT_STUDENT_ENROLMENT (Government Student Enrolment) |
||||
Data Element |
Description |
DEST Element |
Source |
Extract File |
SUBMISSION_YR |
Year and Submission Number of the current submission |
415 | Parameters to the Government Snapshot job (STAJ0110) |
HELP Due File |
SUBMISSION_NUMBER |
- |
Revisions | ||
PERSON_ID |
ID number of the student |
313 |
Enrolment Statistics Snapshot |
Unit of Study Completions (CU), HELP DUE (DU), Enrolment (EN), Load/Liability (LL), OS-HELP( OS), Past Course Completions (PS), Commonwealth Learning Scholarship (SS) , Revisions (RF) & Electronic Commonwealth Assistance (PO) |
COURSE_CD |
The Course Code of the Student's Course Attempt |
307 |
Enrolment Statistics Snapshot |
Course of Study (CO), HELP DUE (DU), Unit of Study Completions (CU), Enrolment (EN), Load/Liability (LL), OS-HELP (OS) , Past Course Completions (PS) & Revisions (RF) |
VERSION_NUMBER |
Version of the Course being undertaken |
- |
Enrolment Statistics Snapshot |
|
BIRTH_DT |
Date of Birth of the student |
315 |
Student's person record |
HELP DUE (DU), Enrolment (EN), Electronic Commonwealth Assistance (PO), Past Course Completions (PS) & Revisions (RF) |
SEX |
Sex of the student |
314 |
Student's person record |
HELP DUE (DU), Enrolment (EN), Electronic Commonwealth Assistance (PO), Past Course Completions (PS) & Revisions (RF) |
ABORIG_TORRES_CD |
The Aboriginal/Torres Strait Islander code assigned to the student |
- |
Person Statistics |
|
GOVT_ABORIG_TORRES_CD |
The Government Code to which the Institution defined Aboriginal/Torres Strait Islander Code (above) is mapped |
316 |
Institution - Government Aboriginal/Torres Strait Islander Code mapping |
Student Enrolment (EN) & Past Course Completions (PS) |
CITIZENSHIP_CD |
The Citizenship Code assigned to the student |
- |
Captured in Government Student Load/Liability |
|
GOVT_CITIZENSHIP_CD |
The Government Code to which the Institution defined Citizenship Code (above) is mapped |
358 |
Captured in Government Student Load/Liability |
No longer reported |
PERM_RESIDENT_CD |
The Permanent Residency Code assigned to the student |
- |
Derived Value Captured in Government Student Load/Liability |
No longer populated |
GOVT_PERM_RESIDENT_CD |
The Government Code to which the Institution defined Permanent Residency Code (above) is mapped |
390 |
Permanent Residency Code - Government Permanent Residency Code mapping |
No longer populated |
HOME_LOCATION |
Whichever is set out of the Student's Home Residence Postcode or Home Residence Country Code |
- |
Person Statistics |
|
GOVT_HOME_LOCATION |
The Government Country Code to which the Home Residence Country Code (above) is mapped, or if no mapping exists, the Institution value is used (it will be a valid DEST value) |
320 |
Person
Statistics or |
Student Enrolment (EN) & Past Course Completions (PS) |
TERM_LOCATION |
Whichever is set out of the Student's Semester Residence Postcode and Semester Residence Country Code |
- |
Person Statistics |
|
GOVT_TERM_LOCATION |
The Government Country Code to which the Semester Residence Country Code (above) is mapped, or if no mapping exists, the Institution value is used (it will be a valid DEST value) |
319 |
Person
Statistics or |
Student Enrolment File |
BIRTH_COUNTRY_CD |
The Country Code for the Student's Country of Birth |
- |
Person Statistics |
|
GOVT_BIRTH_COUNTRY_CD |
The Government Country Code to which the Institution defined Country of Birth is mapped, or if no mapping exists, the Institution value is used (it will be a valid DEST value) |
346 |
Country Code - Government Country Code mapping |
Student Enrolment (EN) & Past Course Completions (PS) |
YR_ARRIVAL |
The year of arrival in Australia of a student born overseas |
347 |
Person Statistics |
Student Enrolment (EN) & Past Course Completions (PS) |
HOME_LANGUAGE_CD |
The code of a language other than English spoken in the Student's home |
- |
Person Statistics |
|
GOVT_HOME_LANGUAGE_CD |
The Government Language Code to which the Institution defined Home Language Code is mapped, or if no mapping exists, the Institution value is used (it will be a valid DEST value) |
348 |
Language Code - Government Language Code mapping |
Student Enrolment (EN) & Past Course Completions (PS) |
PRIOR_UG_INST |
The code of the Institution from which the student received their last qualification |
- |
No longer Reported |
No longer populated |
GOVT_PRIOR_UG_INST |
The Government Institution Code to which the Institution defined Institution Code (above) is mapped, or if no mapping exists, the Institution value is used (it will be a valid DEST value) |
- |
No longer reported |
No longer populated |
PRIOR_OTHER_QUAL |
Prior educational qualifications of the student |
- |
No longer reported |
No longer populated |
PRIOR_POST_GRAD |
- |
No longer populated |
||
PRIOR_DEGREE |
- |
No longer populated |
||
PRIOR_SUBDEG_NOTAFE |
- |
No longer populated |
||
PRIOR_SUBDEG_TAFE |
- |
No longer populated |
||
PRIOR_SECED_TAFE |
- |
No longer populated |
||
PRIOR_SECED_SCHOOL |
- |
No longer populated |
||
PRIOR_TAFE_AWARD |
- |
No longer populated |
||
PRIOR_STUDIES_EXEMPTION |
Percentage of Course from which student has been granted exemption by virtue of approved Advanced Standing |
367 |
If not a Commencing Student or if a Commencing Student or if student commenced prior to 2008, then value is 0000. Otherwise, the value of '% of Course Requirements Granted' in Student's Advanced Standing record. If the value is greater than 9999, this field is set to 9999 |
Student Enrolment File |
EXEMPTION_INSTITUTION_CD |
The code of the Institution from which most of the Student's Advanced Standing accrued |
- |
Major exemption institution from Student's Advanced Standing record |
|
GOVT_EXEMPTION_INSTITUTION_CD |
The Government Institution Code to which the Institution defined Exemption Institution Code (above) is mapped, or if no mapping exists, the Institution value is used (it will be a valid DEST value) |
368 |
The Government Institution Code to which the Major
Exemption Institution from Student's Advanced Standing record is mapped. If a Government Institution Code mapping does not exist then the Institution Code in the Advanced Standing Record is used |
Student Enrolment File |
ATTENDANCE_MODE |
The Attendance Mode of the Student's Course Attempt |
- |
This value has been moved to the Load Liability Table. |
No longer populated |
GOVT_ATTENDANCE_MODE |
The Government Attendance Mode to which the institution defined Attendance Mode (above) is mapped |
329 |
This value has been moved to the Load Liability Table. |
No longer populated |
ATTENDANCE_TYPE |
The Attendance Type (e.g. part-time) of the student |
- |
||
GOVT_ATTENDANCE_TYPE |
The Government Attendance Type to which the Institution defined Attendance Type (above) is mapped |
330 |
Attendance Type and Government Attendance Type Mapping |
Student Enrolment (EN) & Past Course Completions (PS) |
COMMENCEMENT_DT |
The Commencement Date of the Student's Course of Study |
534 |
Enrolment Snapshot |
Student
Load/Liability (LL) |
MAJOR_COURSE |
Indicates whether or not this Course Attempt is the Student's major Course |
- |
No longer reported |
No longer populated |
TERTIARY_ENTRANCE_SCORE |
Student's Tertiary Entrance Score |
369 |
Student's Admission Application, Australian Secondary Education Score, or mapping of score to Government Score (in ADMF02W1) |
Student Enrolment File |
BASIS_FOR_ADMISSION_TYPE |
The basis for Admission of the student to a Course |
- |
Student's Admission Course Application Basis for Admission Type. If none is found, Student Course Attempt Basis for Admission Type. If neither is found, NULL. |
|
GOVT_BASIS_FOR_ADMISSION_TYPE |
The Government basis for Admission Type to which the institution defined basis for Admission Type (above) is mapped |
327 |
Basis for Admission Type - Government Basis for Admission Type mapping |
Student Enrolment File |
GOVT_DISABILITY |
The Disabilities recorded against a student, coded as per DEST specifications |
386 |
Student Enrolment (EN) & Past Course Completions (PS) |
|
CAMPUS_LOCATION |
The code representing an Australian (1) or Overseas (2) Campus Location |
- |
Moved to Load Liability Entity |
No longer populated |
PREV_RTS_EFTSU |
EFTSL from Research Training Scheme in previous course |
460 |
Previous RTS EFTSL value in RESF3211 |
Student Enrolment (EN) File |
SEPARATION_STATUS_CD |
The separation status of a student enrolled in a Higher Degree. |
465 |
Candidature
|
Student Enrolment (EN) File |
UPDATE_WHO | User running the Government Submission Snapshot job | - | Username | |
UPDATE_ON | The Date this record was updated (created) | - | System Date | |
COMMENCING_LOCATION | Holds the Australian Postcode of the Permanent Home Location of the student in the final year of their secondary education. | 476 | Person Statistics | Student Enrolment (EN) File |
COMMENCING_GEOGRAPHIC_LOC | Holds the Permanent Home Location of the student in the final year of their secondary study, (i.e. Name of Suburb/Town/Locality). | 486 | Derived Value | Student Enrolment (EN) File |
S_SUBMISSION_TYPE | Submission Type | - | Parameters to the Government Snapshot job (STAJ0110) | |
CHESSN | Records the person's CHESSN number where CHESSN status is Active or Provisional with a HEIMS Validation Date. | 488 | Person CHESSN - Must be Active or Provisional with a HEIMS Validation Date | Commonwealth Learning Scholarship (SS), Unit of Study Completions (CU), Student Enrolment (EN), Student Load/Liability (LL), OS-HELP (OS), Revisions (RF), Past Course Completions (PS) & HELP DUE (DU) |
COHORT_YR | The
year in which a Student Cohort began their Course of Study |
522 | Populated with NULL value. | Student Load/Liability (LL) |
OVERSEAS_STUDENT_FEE | The actual fee to be charged of an Overseas Student for a course in which a student is enrolled at the Higher Education Provider | 500 | Fee Assessment | Student
Enrolment (EN) |
SCHOLARSHIP_TYPE | A code which identifies the Scholarship Type Code | - | Student Scholarship | |
GOVT_SCHOLARSHIP_TYPE | The Government defined type of Scholarship associated with the student. | 487 | The
Government value mapped to the value from Student Scholarship above |
Student Enrolment (EN) & Past Course Completions (PS) |
HIGHEST_ATTAINMENT | Highest educational attainment prior to commencement (DEST element renamed 'Highest Participation') | 493 | Person Statistics | Student Enrolment File |
GOVT_VTE_PROVIDER_TYPE | Government-defined Code representing the provider of the prior VET study for which credit was granted. (e.g. University, TAFE college, High school, etc) |
564 | The Government VTE Provider Type recorded in ADMF4200. Equals 00 when no Advanced Standing Exists |
Student Enrolment (EN) File |
VTE_LEVEL_DETAIL | Government-defined Code representing the level of the prior VET study for which credit was granted | 563 | The VTE Level Detail recorded in ADMF4200. Equals 000 when no Advanced Standing Exists |
Student Enrolment (EN) File |
GOVT_CREDIT_BASIS | Government-defined Credit Basis Code indicating the basis of Advanced Standing credit.(e.g. HE, VET, etc) | 561 | The Government Credit Basis Cd value recorded in ADMF4200. |
Student Enrolment (EN) File |
VTE_FIELD_OF_EDUCATION | Government-defined Code representing the Field of Education of prior VET study for which credit was granted | 562 | The VTE Field of Education recorded in ADMF4200. |
Student Enrolment (EN) File |
GOVT_CREDIT_USED | Value representing the course EFTSL which has been granted as Advanced Standing |
560 | Derived by callista using the same logic as Element 367 and as a result will always contain the same value. This field is derived by multiplying the percentage of course requirements granted by Advanced Standing and the defined total EFTSL for the student’s course. If this value is determined to be greater than 9999, then this field is set to 9999 |
Student Enrolment (EN) File |
GOVT_STUDENT_LOAD_LIABILITY (Government Student Load Liability) |
||||
Data Element |
Description |
DEST Element |
Source |
Extract File |
SUBMISSION_YR |
Year and Submission Number of the current Submission |
415 | Parameters to the Government Snapshot job (STAJ0110) |
HELP DUE (DU), Revisions (RF) & Electronic Commonwealth Assistance (PO) |
SUBMISSION_NUMBER |
||||
S_SUBMISSION_TYPE | Submission Type | - | Parameters to the Government Snapshot job (STAJ0110) | |
PERSON_ID |
ID number of the student |
313 |
Enrolment Statistics Snapshot |
Unit of Study Completions (CU), HELP DUE (DU), Enrolment (EN), Load/Liability (LL), OS-HELP( OS), Past Course Completions (PS), Commonwealth Learning Scholarship (SS) , Revisions (RF) & Electronic Commonwealth Assistance (PO) |
COURSE_CD |
The Course Code of the Student's Course Attempt |
307 |
Enrolment Statistics Snapshot |
Course of Study (CO), HELP DUE (DU), Unit of Study Completions (CU), Enrolment (EN), Load/Liability (LL), OS-HELP (OS) , Past Course Completions (PS) & Revisions (RF) |
CRV_VERSION_NUMBER |
Version of the Course being undertaken |
- |
Enrolment Statistics Snapshot |
|
COMMENCEMENT_DT |
The Commencement Date of the Student's Course Attempt |
328 |
Enrolment Statistics Snapshot |
Past Course Completions (PS) |
TEACHING_ORG_UNIT_CD | The Organisational Unit with Teaching Responsibility for the Unit | 333 | Enrolment Statistics Snapshot | Student Load/Liability (LL) & Revisions (RF) |
TEACHING_ORG_UNIT_START_DT | The Organisational Unit with Teaching Responsibility for the Unit | - | Enrolment Statistics Snapshot | |
TOTAL_EFTSL |
Total EFTSL for the Unit of Study split by Teaching Organisational Unit. Replaces Total EFTSU |
- |
Student Load/Liability (LL) & Revisions (RF) |
|
UNIT_CD |
The Unit Code of the Student's Unit Attempt |
354 |
Enrolment Statistics Snapshot |
Student Unit of Study Completions (CU), Student Load/Liability (LL) & Revisions (RF) |
UV_VERSION_NUMBER |
The Version of the Unit being attempted |
- |
Enrolment Statistics Snapshot |
|
UNIT_CENSUS_DT | A code which indicates the year, month and day which is the Census date of that Unit of Study | 489 | Enrolment Statistics Snapshot | Student Unit of Study Completions (CU), Student Load/Liability (LL) & Revisions (RF) |
DISCIPLINE_GROUP_CD |
A code which uniquely identifies the discipline to which a unit of study is classified by the Higher Education Provider |
- |
Unit Discipline. Enrolment Statistics Snapshot where Discipline is primary |
Student Load/Liability (LL) File |
GOVT_DISCIPLINE_GROUP_CD |
The Government Discipline to which the Unit Discipline (above) is mapped |
464 |
Enrolment Statistics Snapshot |
Student Load/Liability (LL) File |
ATTENDANCE_MODE |
The Commencement Date of the Student's Course Attempt |
328 |
Enrolment Statistics Snapshot |
Past Course Completions (PS) |
GOVT_ATTENDANCE_MODE | The Government Attendance Mode to which the institution defined Attendance Mode (above) is mapped | 329 | Enrolment Statistics Snapshot | Student Load/Liability (LL) & Past Course Completions (PS) |
CAMPUS_LOCATION | Postcode or overseas country code location of Higher Education Provider campus | 477 | Enrolment Statistics Snapshot | Student Load/Liability (LL) & Electronic Commonwealth Assistance (PO) |
MAX_STUDENT_CONTRIBUTION_IND | Maximum Student Contribution Indicator. Derived from Student Status and Differential HECS Indicator. | 392 | Derived Value | Student Load/Liability (LL) File |
STUDENT_STATUS | HECS-HELP, FEE-HELP or OS-HELP Student Status Codes for each area | - | Derived Value | |
GOVT_STUDENT_STATUS | HECS-HELP, FEE-HELP or OS-HELP Student Status Codes for each area | 490 | Student Status - Government Student Status Mapping | HELP
DUE (DU), Student Load/Liability (LL), OS-HELP (OS) & Revisions
(RF) |
TOTAL_AMOUNT_CHARGED | Amount charged for the Unit of Study | 384 | Fee Assessment | Student Load/Liability (LL) & Revisions (RF) |
AMOUNT_PAID_UPFRONT | The amount which has been paid for the Unit of Study | 381 | Fee Assessment | Student Load/Liability (LL) & Revisions (RF) |
LOAN_FEE | The Loan Fee that is charged for a FEE-HELP undergraduate student or an OS-HELP student | 529 | Fee Assessment | Student Load/Liability (LL), OS-HELP (OS) & Revisions (RF) |
INDUSTRIAL_IND | An indicator of whether a unit of study consists wholly of work experience in industry. See (CRSF2210) and 'More' tab. | 337 | Unit Version | Student Load/Liability (LL) |
CITIZENSHIP_CD | The Citizenship Code assigned to the student | - | Person Statistics | |
GOVT_CITIZENSHIP_CD | The Government Code to which the Institution defined Citizenship Code (above) is mapped | 358 | Citizenship Code - Government Citizenship Code mapping | Student Load/Liability (LL) & Past Course Completions (PS) |
PERM_RESIDENT_CD |
The Permanent Residency Code assigned to the student |
- |
Derived Value Captured in Government Student Load/Liability |
Student Load/Liability (LL) |
GOVT_PERM_RESIDENT_CD |
The Government Code to which the Institution defined Permanent Residency Code (above) is mapped |
390 |
Permanent Residency Code - Government Permanent Residency Code mapping |
Student Load/Liability (LL) |
GOVT_COHORT_YR | The year in which a student cohort commenced their course of study. | 522 |
Populated with NULL value. | Student Load/Liability (LL) |
SUMMER_WINTER_SCHOOL_IND | A code indicating if a unit of study is a full-fee summer or winter school unit of study | 551 |
Student Unit Attempt unit offering pattern | Student Load/Liability (LL) |
UNIT_OF_STUDY_HELP_DEBT | The HELP debt amount due for a unit of study | 558 |
Derived Value | Student Load/Liability (LL) |
UPDATE_WHO | User running the Government Submission Snapshot job | - | Username | |
UPDATE_ON |
The Date this record was updated (created) |
- |
System Date |
The Government External Study Loan Snapshot is created by running job STAJ0160. This job creates records in the GOVT_EXTERNAL_STUDY_LOAN_SNAPSHOT table and then goes onto create the OS file for Government Submission.
The Government Scholarship Snapshot is created by running job STAJ0130. This job creates records in the GOVT_SCHOLARSHIP_SNAPSHOT table and then goes on to create the SS file for Government submission.
Last Modified on: 23-Nov-2007 3:59 PM
History Information
Release Version | Project | Change to Document |
10.1 | 1340 -DEST-2007 Pt2 | Modified details for elements 522 and 483 |
10.0.0.0.1.0.0 | 1339 -DEST-2007 | Added/changed details for elements 367, 368, 493, 560, 561, 562, 563, 564 in Govt Student Enrolment table |
10.0.0.1.0.0 | C21229 | In the MAX_STUDENT_CONTRIBUTION_IND row under the GOV_STUDENT_LOAD_LIABILITY table, changed 'Derived Value' link. |
10.0.0.0.0.0.0 | 1339 - DEST-2007 Pt 1 | Changed Summer School data element (551) to also include Winter School. |