How Revisions Data is Derived

The Revisions Table Data

This section includes:

Government Student Revisions
Government Student Liability Revisions
Government External Study Loan Revisions

The activities involved in preparing a Revision Submission are described in Understanding HE Revisions.

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 DIISRTE. Refer to the relevant DIISRTE manuals (bibliography) as the definitive source of this information.

Government Student Revisions

Data in the Government Student Revisions table is inserted by Create Government Revision Submission Snapshot (STAJ1610). The primary purpose of the Government Student Revisions data is for the creation of the Revisions (RF) File by Create SLE/HELP Revisions File (STAJ1620).

GOVT_STUDENT_REVISION (Government Student Revisions)
Data Element	Description	DEST Element	Source for Comparison to Load Liability Value
REVISION_SUBMISSION_YR	Revisions Submission Year and Number	-	STAJ1610 input parameter
REVISION_SUBMISSION_NUMBER	Revisions Submission Year and Number	-	STAJ1610 input parameter
REVISION_S_SUBMISSION_TYPE	Revisions System Submission Type	-	STAJ1610 input parameter
PERSON_ID	ID number of the student	313	-
COURSE_CD	The course code of the student’s course attempt	307	Change in SCA.COURSE_CD + SCA.VERSION_NUMBER
CRV_VERSION_NUMBER	The course version number of the student’s course attempt	307	Change in SCA.COURSE_CD + SCA.VERSION_NUMBER
UNIT_CD	The unit code of the student’s unit attempt	354	Change in SUA.UNIT_CD
UV_VERSION_NUMBER	The unit version of the student’s unit attempt	-	Change in SUA.VERSION_NUMBER
UNIT_CENSUS_DT	The date representing the Census date of the Unit of Study	489	Change in the value for CENSUS data alias in the relevant Teaching Calendar
TR_ORG_UNIT_CD	The Organisational Unit with Teaching Responsibility for the Unit	333	DEST Academic Organisation Unit If the UNIT_VERSION.RESEARCH_UNIT_IND = ‘Y’ and Research Supervisor data exists THEN for CENSUS_DT If % is grater than 0 use Research Supervisor ORG_UNIT and OU_START_DT percentage ELSE use change in TR.ORG_UNIT_CD and TR.OU_START_DT and/or change in TRO.TR.ORG_UNIT_CD and TR.OU_START_DT for the UOO_ID
TR_OU_START_DT	The Organisational Unit with Teaching Responsibility for the Unit	333
SUBMISSION_YR	Year and Submission Number of the current Submission	415	STAJ1610 input parameter
SUBMISSION_NUMBER	Year and Submission Number of the current Submission	415	STAJ1610 input parameter
S_SUBMISSION_TYPE	Submission Type	-	STAJ1610 input parameter
VARIATION_REASON_CD	A numeric code which identifies the reason for the Revision	446	Derived Value
STUDENT_STATUS	HECS-HELP, FEE-HELP or OS-HELP Student Status Codes	-	Change in the record GOVT_HECS_PAYMENT_OPTION.GOVT_HECS_PAYMENT_OPTION derived from the STUDENT_STATUS recorded in STDNT_UNIT_STDNT_STS_SNPSHT.STUDENT_STATUS or if the snapshot value is null STUDENT_UNIT_STUDENT_STATUS.STUDENT_STATUS if defined else STUDENT_COURSE_HECS_OPTION.HECS_PAYMENT_OPTION
GOVT_STUDENT_STATUS	HECS-HELP, FEE-HELP or OS-HELP Student Status Codes	490	Student Status - Government Student Status Mapping
AUTHORISING_OFFICER_PERSON_ID	The person ID of the authorising officer in the Higher Education Provider	543	STAJ1610 input parameter
UPDATE_WHO	User running the Government Submission Snapshot job	-	Username
UPDATE_ON	The Date this record was updated (created)	-	System Date

Deriving the GOVT_STUDENT_REVISION variation reason code

Variation reason code of 2 – Administrative Error

If the previously reported student’s existing GOVT_STUDENT_LOAD_LIABILITY details for Person ID, Course Code + Course Version Number, Unit Code, Unit of Study Census Date and Teaching Responsibilities match the new values for the same but there is a change in any of Citizen/ Resident Indicator, Permanent Residency, EFTSL, Amount paid up front, Total amount charged, Loan Fee, Student status code, Discipline code, Maximum student contribution indicator, Work experience in industry indicator or Summer School indicator then:

If there is an existing GOVT_STUDENT_REVISION record, delete the existing record.

Insert a record in the GOVT_STUDENT_REVISION table with the variation reason code of 2.

Variation reason code of 4 - Deletion

If the previously reported student’s record in GOVT_STUDENT_LOAD_LIABILITY does not match the current Person ID, Course Code + Course Version Number, Unit Code, Unit of Study Census Date and Teaching Responsibilities for the student then:

If there is an existing GOVT_STUDENT_REVISION record, delete the existing record then

Insert a record in the GOVT_STUDENT_REVISION table with the variation reason code of 4.

Variation reason code of 5 - Addition

If a student’s Person ID, Course Code + Course Version Number and Unit of Study Census Date has been previously reported in the GOVT_STUDENT_LOAD_LIABILITY table but there is no match for the current Person ID, Course Code + Course Version Number, Unit Code, Unit of Study Census Date and Teaching Responsibilities for the student (i.e. the Unit of Study Code or Teaching Responsibility has not been previously reported) then:

If there is an existing GOVT_STUDENT_REVISION record, delete the existing record then

Insert a record in the GOVT_STUDENT_REVISION table with the variation reason code of 5.

Government Student Liability Revisions

Data in the Government Student Liability Revisions table is inserted by Create Government Revision Submission Snapshot (STAJ1610). The primary purpose of the Government Student Revisions data is for the creation of the Revised Load Liability (RL) File by Create Government Submission Snapshot (STAJ0110) and Create Student Load/Liability File (STAJ0140) and the Revised HELP Due (HD) File by Create HELP Due File (STAJ0050).

GOVT_STDNT_LIABILITY_REVISION (Government Student Liability Revisions)
Data Element	Description	DEST Element	Source for comparison to Load Liability Value
REVISION_SUBMISSION_YR	Revisions Submission Year and Number	-	STAJ1610 input parameter
REVISION_SUBMISSION_NUMBER	Revisions Submission Year and Number	-	STAJ1610 input parameter
REVISION_S_SUBMISSION_TYPE	Revisions System Submission Type	-	STAJ1610 input parameter
PERSON_ID	ID number of the student	313	-
COURSE_CD	The course code of the student’s course attempt	307	Change in SCA.COURSE_CD + SCA.VERSION_NUMBER
CRV_VERSION_NUMBER	The course version number of the student’s course attempt	307	Change in SCA.COURSE_CD + SCA.VERSION_NUMBER
UNIT_CD	The unit code of the student’s unit attempt	354	Change in SUA.UNIT_CD
UV_VERSION_NUMBER	The unit version of the student’s unit attempt	-	Change in SUA.VERSION_NUMBER
UNIT_CENSUS_DT	The date representing the Census date of the Unit of Study	489	Change in the value for CENSUS data alias in the relevant Teaching Calendar
TR_ORG_UNIT_CD	The Organisational Unit with Teaching Responsibility for the Unit	333	DEST Academic Organisation Unit If the UNIT_VERSION.RESEARCH_UNIT_IND = ‘Y’ and Research Supervisor data exists THEN for CENSUS_DT If % is grater than 0 use Research Supervisor ORG_UNIT and OU_START_DT percentage ELSE use change in TR.ORG_UNIT_CD and TR.OU_START_DT and/or change in TRO.TR.ORG_UNIT_CD and TR.OU_START_DT for the UOO_ID
TR_OU_START_DT	The Organisational Unit with Teaching Responsibility for the Unit	333
OLD_STUDENT_STATUS	The original institution defined student status code	-	Change in the record GOVT_HECS_PAYMENT_OPTION.GOVT_HECS_PAYMENT_OPTION derived from the STUDENT_STATUS recorded in STDNT_UNIT_STDNT_STS_SNPSHT.STUDENT_STATUS or if the snapshot value is null STUDENT_UNIT_STUDENT_STATUS.STUDENT_STATUS if defined else STUDENT_COURSE_HECS_OPTION.HECS_PAYMENT_OPTION
NEW_STUDENT_STATUS	The revised institution defined student status code	-
OLD_GOVT_STUDENT_STATUS	The original government defined student status code	490	Student Status - Government Student Status Mapping
NEW_GOVT_STUDENT_STATUS	The revised government defined student status code	490	Student Status - Government Student Status Mapping
OLD_CITIZENSHIP_CD	The original institution-defined code indicating a student's citizenship and residence status	-	Change in the PS.CITIZENSHIP_CD where the value for the CENSUS date alias falls between the PS.START_DT and PS.END_DT for the record
NEW_CITIZENSHIP_CD	The revised institution-defined code indicating a student's citizenship and residence status	-
OLD_GOVT_CITIZENSHIP_CD	The original government defined citizenship code	358	Citizenship – Government Citizenship mapping
NEW_GOVT_CITIZENSHIP_CD	The revised government defined citizenship code	-	Citizenship – Government Citizenship mapping
OLD_PERM_RESIDENT_CD	A original institution-defined code which identifies whether the student has permanent resident status or not	-	Change in the PERM_RESIDENT_CD.GOVT_PERM_RESIDENT_CD derived from PS.PERM_RESIDENT_CD where the value for the CENSUS date alias falls between the PS.START_DT and PS.END_DT for the record. If ‘Derive Permanent Residence Eligibility for HELP Assistance’ parameter is selected the government code will be derived during processing. Else the value will be sourced from based on above
NEW_PERM_RESIDENT_CD	The revised institution-defined code which identifies whether the student has permanent resident status or not	-
OLD_GOVT_PERM_RESIDENT_CD	The original government defined permanent resident status code	390	Permanent Resident – Government Permanent Resident mapping
NEW_GOVT_PERM_RESIDENT_CD	The revised government defined permanent resident status code	390	Permanent Resident – Government Permanent Resident mapping
NEW_SUMMER_SCHOOL_IND	The original government defined Summer School Indicator	551	Change in the UOP.SUMMER_SCHOOL_IND for the UO.UNIT_CD and UO.VERSION_NUMBER
OLD_SUMMER_SCHOOL_IND	The revised government defined Summer School Indicator	551
NEW_INDUSTRIAL_IND	The original government defined Work Experience in Industry Indicator	337	Change in the UNIT_VERSION.INDUSTRIAL_IND
OLD_INDUSTRIAL_IND	The revised government defined Work Experience in Industry Indicator	337	Change in the UNIT_VERSION.INDUSTRIAL_IND
NEW_MAX_STDNT_CONTRIBUTION_IND	The original government defined Maximum student contribution indicator	392	See Max Student Contribution Indicator below
OLD_MAX_STDNT_CONTRIBUTION_IND	The revised government defined Maximum student contribution indicator	392	See Max Student Contribution Indicator below
NEW_GOVT_DISCIPLINE_GROUP_CD	The original government defined Discipline Code	464	Change in UD. DISCIPLINE _GROUP_CD mapped to GD.GOVT_DISCIPLINE_ GROUP_CD
OLD_GOVT_DISCIPLINE_GROUP_CD	The revised government defined Discipline Code	464
NEW_GOVT_COHORT_YR	The original government defined Cohort Year code	522	Not checked
OLD_GOVT_COHORT_YR	The revised government defined Cohort Year code	522	Not checked
NEW_TOTAL_AMOUNT_CHARGED	The original government defined Total Amount Charged	384	See Transaction Amount below
OLD_TOTAL_AMOUNT_CHARGED	The revised government defined Total Amount Charged	384	See Transaction Amount below
NEW_AMOUNT_PAID_UPFRONT	The original government defined Amount Paid Up Front	381	See Amount Paid Up Front below
OLD_AMOUNT_PAID_UPFRONT	The revised government defined Amount Paid Up Front	381	See Amount Paid Up Front below
NEW_LOAN_FEE	The original government defined Loan Fee	529	See Loan Fee below
OLD_LOAN_FEE	The revised government defined Loan Fee	529	See Loan Fee below
NEW_TOTAL_EFTSL	The original government defined EFTSL	339	Change in the EFTSL calculated for each unique combination of Load Calendar, Student, Course Attempt, Unit Attempt, Teaching Calendar, Teaching Responsibility Organisational Unit and Discipline Group, before being truncated and totaling to arrive at the EFTSL for a SUA or a change in EFTSL as a result of the calculated value being overridden
OLD_TOTAL_EFTSL	The revised government defined EFTSL	339
LOAD_LBLTY_NEW_REC_IND	This indicator identifies current records that should have been reported in a prior submission but are not present in the GOVT_STUDENT_LOAD_LIABILITY table	-	-
SUBMISSION_YR	Year and Submission Number of the current Submission	415	STAJ1610 input parameter
SUBMISSION_NUMBER	Year and Submission Number of the current Submission	415	STAJ1610 input parameter
S_SUBMISSION_TYPE	Submission Type	-	STAJ1610 input parameter
UPDATE_WHO	User running the Government Submission Snapshot job	-	Username
UPDATE_ON	The Date this record was updated (created)	-	System Date

Transaction Amount

Sum TRANSACTION_AMOUNT for a UOO_ID from FEE_ASS where the System Fee Type is TUITION or COMSUPPORT and is associated with a category of DEBT and is not associated with a Transaction Type of Retention (RETENTION, RET_ADJ or RET_WRTOFF).

Split by the ENR_STATISTICS_SNAPSHOT.TR_ORG_UNIT_CD % recorded in TEACHING_RESPONSIBILITY_OVRD where it is defined or more commonly TEACHING_RESPONSIBILITY. If no percentage is recorded then the amount returned will be zero.

Only included for a Student Statuses 110, 111, 112, 201, 202, 203, 220, 230, 231, 232, 233, 301, 302, 303, 304, 305, 340, 341.

Reported at a Unit Level and Academic Organisational Unit level (Split by teaching responsibility percentage)TEACHING_RESPONSIBILITY_OVRD.

Must be a right-justified unsigned number with all leading zeros.

If Student Status code is 250, 260, 261, 262, 270, 271, 310, 311, 320, 330 THEN Total Amount Charged must be zero.

Note: The Total Amount Charged will include any retention amounts. The Total Amount Charged cannot exceed 1 million dollars.

Amount Paid Up Front

Sum TRANSACTION_AMOUNT for a UOO_ID from FEE_ASS where the System Transaction Category is PAYMENT and the System Fee Type is TUITION or COMSUPPORT.

And for both types (Tuition and COMSUPPORT) only count payments made by students or NON-LOAN Scheme Sponsors.

Split by the ENR_STATISTICS_SNAPSHOT.TR_ORG_UNIT_CD % recorded in TEACHING_RESPONSIBILITY_OVRD where it is defined or more commonly TEACHING_RESPONSIBILITY. . If no percentage is recorded then the amount returned will be zero.

Only included for a commonwealth Supported Students (Student Statuses 110, 111, 112, 201, 202, 203, 220, 230, 231, 232, 233, 301, 302, 303, 304, 305, 340, 341)

If Student status code is 250, 260, 261, 262, 270, 271, 310, 311, 320, 330 THEN Amount paid up front must be zero.

Note: The Amount Paid Up Front cannot exceed 1 million dollars.

Loan fee

Sum LOAN_FEE for a UOO_ID from FEE_ASS where the System Transaction type is FEEHELPLOAN.

If Student Status code is 110, 111, 112, 201, 202, 203, 220, 250, 260, 261, 262, 270, 271, 301, 302, 303, 304, 305, 310, 311, 320, 330, 340, 341, 342 THEN Loan Fee must be zero.

A Loan fee will only be derived if the student status is 230, 231, 232 or 233.

Note: The Loan fee cannot exceed 1 million dollars.

Max Student Contribution Indicator

Derived from Student Status and Differential HECS Indicator.

For further information go to Govt submission -derived values

Government External Study Loan Revisions

Data in the Government External Study Loan Revisions table is inserted by Create Government Revision Submission Snapshot (STAJ1610). The primary purpose of the Government External Study Loan Revisions data is for the creation of the Revisions(RF) File by Create SLE/HELP Revisions File (STAJ1620) and the Revised OS-HELP (RO) File by Create OS-HELP File (STAJ0160).

GOVT_EXT_STUDY_LOAN_REVISION (Government External Study Loan Revisions)
Data Element	Description	DEST Element	Source for Comparison to OS-HELP Value
REVISION_SUBMISSION_YR	Revisions Submission Year and Number	-	STAJ1610 input parameter
REVISION_SUBMISSION_NUMBER	Revisions Submission Year and Number	-	STAJ1610 input parameter
REVISION_S_SUBMISSION_TYPE	Revisions System Submission Type	-	STAJ1610 input parameter
PERSON_ID	ID number of the student	313
COURSE_CD	The course code of the student’s course attempt	307	Change in SCA.COURSE_CD + SCA.VERSION_NUMBER
CRV_VERSION_NUMBER	The course version number of the student’s course attempt	307	Change in SCA.COURSE_CD + SCA.VERSION_NUMBER
SCESL_SEQUENCE_NUMBER	The Student Course External Study Loan sequence Number	-	STDNT_CRS_EXTERNAL_STUDY_LOAN.SEQUENCE_NUMBER
INCURRAL_DT	OS-HELP debt incurral date indicates the year, month and day on which the student incurred their OS-HELP debt	-	STDNT_CRS_EXTERNAL_STUDY_LOAN.INCURRAL_DT
VARIATION_REASON_CD	A numeric code which identifies the reason for the Revision	446	Derived Value
OLD_GOVT_STUDENT_STATUS	The original government defined student status code	490	Student Status - Government Student Status Mapping
NEW_GOVT_STUDENT_STATUS	The revised government defined student status code	490	Student Status - Government Student Status Mapping
OLD_STUDY_PERD_COMMENCE_DT	The original government defined OS-HELP Study period commencement date	521	This element is now part of the key for the OS-HELP file. Changes can no longer be made to the OS-HELP Study period commencement date
NEW_STUDY_PERD_COMMENCE_DT	The revised government defined OS-HELP Study period commencement date	521
OLD_LOAN_AMOUNT	The original government defined OS-HELP Payment Amount	528	Change in the STDNT_CRS_EXTERNAL_STUDY_LOAN.LOAN_AMOUNT
NEW_LOAN_AMOUNT	The revised government defined OS-HELP Payment Amount	528	Change in the STDNT_CRS_EXTERNAL_STUDY_LOAN.LOAN_AMOUNT
OLD_LOAN_FEE	The original government defined Loan Fee	529	Change in the STDNT_CRS_EXTERNAL_STUDY_LOAN.LOAN_FEE
NEW_LOAN_FEE	The revised government defined Loan Fee	529	Change in the STDNT_CRS_EXTERNAL_STUDY_LOAN.LOAN_FEE
GOVT_EXT_STDY_LOAN_NEW_REC_IND	This indicator identifies current records that should have been reported in a prior submission but are not present in the GOVT_EXTRNL_STUDY_LOAN_SNPSHT table	-	-
SUBMISSION_YR	Year and Submission Number of the current Submission	415	STAJ1610 input parameter
SUBMISSION_NUMBER	Year and Submission Number of the current Submission	415	STAJ1610 input parameter
S_SUBMISSION_TYPE	Submission Type	-	STAJ1610 input parameter
AUTHORISING_OFFICER_PERSON_ID	The person ID of the authorising officer in the Higher Education Provider	543	STAJ1610 input parameter
UPDATE_WHO	User running the Government Submission Snapshot job	-	Username
UPDATE_ON	The Date this record was updated (created)	-	System Date

Deriving the GOVT_EXT_STUDY_LOAN_REVISION Variation Reason Code

Variation reason code of 2

If the previously reported student’s existing GOVT_EXTRNL_STUDY_LOAN_SNPSHT details for Person ID, Course Code, and Study Period Commencement Date match the new values for the same then if there is a change in any of OS-HELP payment amount, loan fee, or student status then:

If there is an existing GOVT_EXT_STUDY_LOAN_REVISION, delete the existing record then

Insert a record in the GOVT_EXT_STUDY_LOAN_REVISION table with the variation reason code of 2.

Variation reason code of 4

If the previously reported student’s record in GOVT_EXTRNL_STUDY_LOAN_SNPSHT does not match the current Person ID, Course Code and Study Period Commencement Date for the student (i.e. the person no longer has an OS-HELP debt or was incorrectly reported) then:

If there is an existing GOVT_EXT_STUDY_LOAN_REVISION record, delete the existing record then

Insert a record in the GOVT_EXT_STUDY_LOAN_REVISION table with the variation reason code of 4.

Last Modified on 17 October. 2006

History Information

Release Version	Project	Change to Document
11.1	1505 - Compliance 2008	Modified detail for Element 392 - in the Government Student Liability Revisions table
9.1.0.0.0.0	1230 - DIISRTE 2007	New form