| Top of FIN | Index | Table of Contents | Feedback | |
Commonwealth Assistance Notice of Liability Extract - View Details
Note: From 2005, BOTPLS, PELS and OLDPS will be consolidated under FEE-HELP as part of changes to Commonwealth Supported Places (HECS).
From 2005, the Commonwealth Assistance Notice replaces BOTPLS, PELS and OLDPS. CAN_RECORD_V has the the following information:
1. HEADER
2. PERSON
3. ADDRESSES
4. SYSTEM CREDIT
5. COMMONWEALTH SUPPORTED AND ASSISTED COURSES
6. ASSESSED LIABILITIES
7. COMMONWEALTH SUPPORTED AND ASSISTED UNITS (HECS-LIABLE-UNITS
IN FINJ6190)
8. STUDENT CONTRIBUTION BANDS
9. TRANSACTION DETAILS
10. EXTERNAL REFERENCES
11. TRANSACTION SUMMARY
12. EXTERNAL STUDY LOAN
13. FOOTER (RECORD COUNTS)
CAN_RECORD_V
The table shows details of the fields presented by this view. In most cases the existing functionality is the same as FINJ6190, with the following considerations:
| Field Name |
Field Description |
Source/Value |
|
| CREATION_DT |
Date and Time of Creation of the Extract |
System |
|
| FEE_CAL_TYPE |
The Fee Assessment Period for which the Extract was run |
Job Run parameter |
|
| FEE_CI_SEQUENCE_NUMBER |
|||
| PERSON_ID |
The student to which this record refers |
'0000000000' |
|
| COURSE_CD |
blank |
||
| MAJOR_SORT_SEQUENCE |
blank |
||
| FEE_TYPE |
blank |
||
| MINOR_SORT_ SEQUENCE | blank |
||
| KEY8 | blank | ||
| KEY9 |
blank |
||
| RECORD_TYPE | Record Type | 'HEADER' | |
| FIELD1 | Comment | parameter | |
| FIELD2 | Fee Calendar Type | cal_instance.cal_type | |
| FIELD3 | Fee Calendar Description | cal_type.description | |
| FIELD4 | Fee Calendar Start Date | cal_instance.start_dt | |
| FIELD5 | Fee Calendar End Date | cal_instance.end_dt | |
| FIELD6 | Address Type | institution_addr.addr_type | |
| FIELD7 | Address Line 1 | institution_addr.addr_line_1 | |
| FIELD8 | Address Line 2 | institution_addr.addr_line_2 | |
| FIELD9 | Address Line 3 | institution_addr.addr_line_3 | |
| FIELD10 | Address Line 4 | institution_addr.addr_line_4 | |
| FIELD11 | Address Line 5 | institution_addr.addr_line_5 | |
| FIELD12 | Australian Postcode | institution_addr.aust_postcode | |
| FIELD13 | Overseas Postal Code | institution_addr.os_code | |
| FIELD14 | Phone 1 | institution_addr.phone_1 | |
| FIELD15 | Phone 2 | institution_addr.phone_2 | |
| FIELD16 | Phone 3 | institution_addr.phone_3 | |
| FIELD17 | Other Details | institution_addr.other_details | |
| FIELD18 | Correspondence check box | addr_type.correspondence_ind | |
| FIELD19-25 | blank | ||
| Field Name |
Field Description |
Source/Value |
|
| CREATION_DT |
Date and Time of Creation of the Extract |
System |
|
| FEE_CAL_TYPE |
The Fee Assessment Period for which the Extract was run |
Job Run parameter |
|
| FEE_CI_SEQUENCE_NUMBER |
|||
| PERSON_ID |
The student to which this record refers |
person.person_id |
|
| COURSE_CD |
blank |
||
| MAJOR_SORT_SEQUENCE |
blank |
||
| FEE_TYPE |
blank |
||
| MINOR_SORT_ SEQUENCE | blank |
||
| KEY8 | blank | ||
| KEY9 |
blank |
||
| RECORD_TYPE | Record Type | 'PERSON' | |
| FIELD1 | Person ID | person.person_id | |
| FIELD2 | Title | person.title | |
| FIELD3 | Surname | person.surname | |
| FIELD4 | Given Names | person.given_names | |
| FIELD5 | Payment Advice Number | alternate_person_id.api_person_id | |
| FIELD6 | Date of Issue | outgoing_correspondence.issue_dt | |
| FIELD7 | Last Notice Date | correspondence_item.create_dt | |
| FIELD8 | CHESSN | person_chessn.pchsn_chessn | |
| FIELD9-25 | blank | ||
| Field Name |
Field Description |
Source/Value |
|
| CREATION_DT |
Date and Time of Creation of the Extract |
System |
|
| FEE_CAL_TYPE |
The Fee Assessment Period for which the Extract was run |
Job Run parameter |
|
| FEE_CI_SEQUENCE_NUMBER |
|||
| PERSON_ID |
The student to which this record refers |
person.person_id |
|
| COURSE_CD |
blank |
||
| MAJOR_SORT_SEQUENCE |
blank |
||
| FEE_TYPE |
blank |
||
| MINOR_SORT_ SEQUENCE | blank |
||
| KEY8 | blank | ||
| KEY9 |
blank |
||
| RECORD_TYPE | Record Type | 'ADDRESSES' | |
| FIELD1 | Person ID | person.person_id | |
| FIELD2 | Address Type | person_addr.addr_type | |
| FIELD3 | Address Line 1 | person_addr.addr_line_1 | |
| FIELD4 | Address Line 2 | person_addr.addr_line_2 | |
| FIELD5 | Address Line 3 | person_addr.addr_line_3 | |
| FIELD6 | Address Line 4 | person_addr.addr_line_4 | |
| FIELD7 | Address Line 5 | person_addr.addr_line_5 | |
| FIELD8 | Australian Postcode | person_addr.aust_postcode | |
| FIELD9 | Overseas Postal Code | person_addr.os_code | |
| FIELD10 | Phone 1 | person_addr.phone_1 | |
| FIELD11 | Phone 2 | person_addr.phone_2 | |
| FIELD12 | Phone 3 | person_addr.phone_3 | |
| FIELD13 | Other Details | person_addr.other_details | |
| FIELD14 | Correspondence check box | addr_type.correspondence_ind | |
| FIELD15-25 | blank | ||
| Field Name |
Field Description |
Source/Value |
|
| CREATION_DT |
Date and Time of Creation of the Extract |
System |
|
| FEE_CAL_TYPE |
The Fee Assessment Period for which the Extract was run |
Job Run parameter |
|
| FEE_CI_SEQUENCE_NUMBER |
|||
| PERSON_ID |
The student to which this record refers |
person.person_id |
|
| COURSE_CD |
blank |
||
| MAJOR_SORT_SEQUENCE |
blank |
||
| FEE_TYPE |
blank |
||
| MINOR_SORT_ SEQUENCE | blank |
||
| KEY8 | Currency of the Credit | currency.currency_cd | |
| KEY9 |
blank |
||
| RECORD_TYPE | Record Type | 'SYSTEM-CREDIT' | |
| FIELD1 | Person ID | person.person_id | |
| FIELD2 | Currency Code | derived | |
| FIELD3 | Currency Description | currency.description | |
| FIELD4 | Local Currency check box | currency.local_currency_ind | |
| FIELD5 | Credit Amount | calculated | |
| FIELD6-25 | blank | ||
| Field Name |
Field Description |
Source/Value |
|
| CREATION_DT |
Date and Time of Creation of the Extract |
System |
|
| FEE_CAL_TYPE |
The Fee Assessment Period for which the Extract was run |
Job Run parameter |
|
| FEE_CI_SEQUENCE_NUMBER |
|||
| PERSON_ID |
The student to which this record refers |
person.person_id |
|
| COURSE_CD |
In conjunction with Person ID, the Student Course Attempt to which this record refers |
student_course_attempt.course_id |
|
| MAJOR_SORT_SEQUENCE |
blank |
||
| FEE_TYPE |
blank |
||
| MINOR_SORT_ SEQUENCE | blank |
||
| KEY8 | blank | ||
| KEY9 |
blank |
||
| RECORD_TYPE | Record Type | 'COMM-SUPP-ASSIST-CRS' | |
| FIELD1 | Person ID | person.person_id | |
| FIELD2 | Course Code | student_course_attempt.course_id | |
| FIELD3 | Last Effective Assessment Date | greatestfee_ass.effective_dt | |
| FIELD4 | Version | student_course_attempt.version_number (as at date in FIELD3) | |
| FIELD5 | Title | course_version.title | |
| FIELD6 | Short Title | course_version.short_title | |
| FIELD7 | Course Type | course_version.course_type | |
| FIELD8 | Location | student_course_attempt.location_cd (as at date in FIELD3) | |
| FIELD9 | Attendance Mode | student_course_attempt.attendance_mode (as at date in FIELD3) | |
| FIELD10 | Attendance Type | student_course_attempt.attendance_type (as at date in FIELD3) | |
| FIELD11 | Derived Attendance Mode | student_course_attempt.derived_att_mode (as at date in FIELD3) | |
| FIELD12 | Derived Attendance Type | student_course_attempt.derived_att_type (as at date in FIELD3) | |
| FIELD13 | Status | student_course_attempt.course_attempt_status (as at date in FIELD3) | |
| FIELD14 | Commencement Date | student_course_attempt.commencement_dt (as at date in FIELD3) | |
| FIELD15 | Discontinued Date | student_course_attempt.discontinued_dt (as at date in FIELD3) | |
| FIELD16 | Fee Category | student_course_attempt.fee_cat (as at date in FIELD3) | |
| FIELD17 | Fee Category Description | fee_cat.description (as at date in FIELD3) | |
| FIELD18 | Funding Source | student_course_attempt.funding_source (as at date in FIELD3) | |
| FIELD19 | Correspondence Category | student_course_attempt.correspondence_cat (as at date in FIELD3) | |
| FIELD20 | Cohort | student_course_attempt.gov_cohort_yr | |
| FIELD21 | Total amount by which student's SLE is reduced | calculated | |
| FIELD22-25 | blank | ||
| Field Name |
Field Description |
Source/Value |
|
| CREATION_DT |
Date and Time of Creation of the Extract |
System |
|
| FEE_CAL_TYPE |
The Fee Assessment Period for which the Extract was run |
Job Run parameter |
|
| FEE_CI_SEQUENCE_NUMBER |
|||
| PERSON_ID |
The student to which this record refers |
person.person_id |
|
| COURSE_CD |
In conjunction with Person ID, the Student Course Attempt to which this record refers |
student_course_attempt.course_id |
|
| MAJOR_SORT_SEQUENCE |
Used to group records according to parent/child relationship of data |
'06' |
|
| FEE_TYPE |
Assessed Government Loan Scheme Fee Type |
fee_ass.fee_type |
|
| MINOR_SORT_ SEQUENCE | blank |
||
| KEY8 | blank | ||
| KEY9 |
blank |
||
| RECORD_TYPE | Record Type | 'ASSESSED-LIABILITIES' | |
| FIELD1 | Person ID | person.person_id | |
| FIELD2 | Course Code | student_course_attempt.course_id | |
| FIELD3 | Fee Type | fee_type.fee_type | |
| FIELD4 | Fee Type Description | fee_type.description | |
| FIELD5 | Fee Calendar Type | cal_instance.cal_type | |
| FIELD6 | Fee Calendar Description | cal_type.description | |
| FIELD7 | Fee Calendar Start Date | cal_instance.start_dt | |
| FIELD8 | Fee Calendar End Date | cal_instance.end_dt | |
| FIELD9 | Fee Assessment Period Start | dt_alias_instance_v.alias_val | |
| FIELD10 | Fee Assessment Period End | dt_alias_instance_v.alias_val | |
| FIELD11 | System Fee Type | fee_type.s_fee_type | |
| FIELD12 | System Fee Trigger Category | fee_type.s_fee_trigger_cat | |
| FIELD13 | Charge Method | fee_type_cal_instance.s_chg_method_type or fee_cat_fee_liability.s_chg_method_type | |
| FIELD14 | Last Transaction Date | greatestfee_ass.transaction_dt | |
| FIELD15 | Last Effective Assessment Date | greatestfee_ass.effective_dt | |
| FIELD16 | Last Notification Date | greatestfee_ass.notification_dt | |
| FIELD17 | Manual Entry | Y or N (Y if any manual fee_ass entries exist) Yes, in context of a unit. When this is the case, this check box should be set to ‘Y’ if any manual Fee Assessments exist at the Unit Level for the Fee Type. | |
| FIELD18-25 | blank | ||
| 7. COMMONWEALTH SUPPORTED AND ASSISTED UNITS (HECS-LIABLE-UNITS IN FINJ6190) |
|||
| Field Name |
Field Description |
Source/Value |
|
| CREATION_DT |
Date and Time of Creation of the Extract |
System |
|
| FEE_CAL_TYPE |
The Fee Assessment Period for which the Extract was run |
Job Run parameter |
|
| FEE_CI_SEQUENCE_NUMBER |
|||
| PERSON_ID |
The student to which this record refers |
person.person_id |
|
| COURSE_CD |
In conjunction with Person ID, the Student Course Attempt to which this record refers |
student_course_attempt.course_id |
|
| MAJOR_SORT_SEQUENCE |
Used to group records according to parent/child relationship of data |
'06' |
|
| FEE_TYPE |
Assessed Government Loan Scheme Fee Type |
fee_ass.fee_type |
|
| MINOR_SORT_ SEQUENCE | Used to group records according to parent/child relationship of data |
'07' |
|
| KEY8 | Code of Contributing Unit | student_unit_attempt.unit_cd | |
| KEY9 |
blank |
||
| RECORD_TYPE | Record Type | 'COM-SUPP-ASSIST-UNIT' | |
| FIELD1 | Person ID | person.person_id | |
| FIELD2 | Course Code | student_course_attempt.course_id | |
| FIELD3 | Fee Type | fee_type.fee_type | |
| FIELD4 | Unit Code | student_unit_attempt.unit_cd | |
| FIELD5 | Last Effective Assessment Date | greatestfee_ass.effective_dt | |
| FIELD6 | Version Number | student_unit_attempt.version_number (as at date in FIELD5) | |
| FIELD7 | Unit Short Title | unit_version.short_title | |
| FIELD8 | Teaching Period of the Student Unit Attempt | student_unit_attempt.cal_type (as at date in FIELD5) | |
| FIELD9 | student_unit_attempt.ci_sequence_number (as at date in FIELD5) | ||
| FIELD10 | Teaching Calendar Description | cal_type.description | |
| FIELD11 | Teaching Calendar Start Date | cal_instance.start_dt | |
| FIELD12 | Teaching Calendar End Date | cal_instance.end_dt | |
| FIELD13 | Teaching Period Code | cal_instance.alternate_code | |
| FIELD14 | Location | student_unit_attempt.location_cd (as at date in FIELD5) | |
| FIELD15 | Class | student_unit_attempt.unit_class (as at date in FIELD5) | |
| FIELD16 | Status | student_unit_attempt.unit_attempt_status (as at date in FIELD5) | |
| FIELD17 | Administrative Status | student_unit_attempt.administrative_unit_status (as at date in FIELD5) | |
| FIELD18 | Enrolled Date | student_unit_attempt.enrolled_dt (as at date in FIELD5) | |
| FIELD19 | Discontinued Date | student_unit_attempt.discontinued_dt (as at date in FIELD5) | |
| FIELD20 | EFTSL | calculated. EFTSU has been replaced with EFTSL. Underlying tables may still refer to this filed as EFTSU. | |
| FIELD21 | Credit Points | calculated | |
| FIELD22 | Liability Amount | calculated liability for unit. This may differ from the actual debt if there has been a manual adjustment. Refer to 9. TRANSACTION DETAIL and 11. TRANSACTION SUMMARY records | |
| FIELD23 | Census Date | student_unit_student_status_v.census_dt This date field is the Census Date for the UNIT | |
| FIELD24 | SLE Reduced | Only calculated for units with one of the following student status values '110', '111', '112', '201', '202', and '203'. SLE Reduced = EFTSL value of these units. Where the Government WEI value = 0 (NOT UNDERTAKING WORK EXPERIENCE IN INDUSTRY). This field is the amount by which the student’s SLE is reduced | |
| FIELD25 | Unit Student Status (at Unit Student Status Snapshot) | stdnt_unit_stdnt_sts_snpsht_v/unit_attempt_status (as at Census Date associated with a Teaching Period). Record at the Student Status Snapshot Unit Level | |
| FIELD26 | Elected Student Status | student_unit_student_status_v.student_status ( as at Census Date associated with a Teaching Period). This is the Student Status declared at the Course Level or the Student Status declared at the Unit Level as an override | |
| Field Name |
Field Description |
Source/Value |
|
| CREATION_DT |
Date and Time of Creation of the Extract |
System |
|
| FEE_CAL_TYPE |
The Fee Assessment Period for which the Extract was run |
Job Run parameter |
|
| FEE_CI_SEQUENCE_NUMBER |
|||
| PERSON_ID |
The student to which this record refers |
person.person_id |
|
| COURSE_CD |
In conjunction with Person ID, the Student Course Attempt to which this record refers |
student_course_attempt.course_id |
|
| MAJOR_SORT_SEQUENCE |
Used to group records according to parent/child relationship of data |
'06' |
|
| FEE_TYPE |
Assessed Government Loan Scheme Fee Type |
fee_ass.fee_type |
|
| MINOR_SORT_ SEQUENCE | Used to group records according to parent/child relationship of data |
'07' |
|
| KEY8 | Code of Contributing Unit | student_unit_attempt.unit_cd | |
| KEY9 |
Student Contribution Band |
govt_dscpln_hecs_cntrbt.gov_hecs_cntrbtn_band |
|
| RECORD_TYPE | Record Type | 'STUDENT-CONTRIB-BANDS' | |
| FIELD1 | Person ID | person.person_id | |
| FIELD2 | Course Code | student_course_attempt.course_cd | |
| FIELD3 | Fee Type | fee_type.fee_type | |
| FIELD4 | Unit Code | student_unit_attempt.unit_cd | |
| FIELD5 | Version Number | student_unit_attempt.version_number | |
| FIELD6 | Discipline Group | unit_discipline.discipline_group_cd | |
| FIELD7 | Percentage | unit_discipline.percentage | |
| FIELD8 | Government Discipline Group | govt_discipline.govt_discipline_group_cd | |
| FIELD9 | Student Contribution Band | govt_dscpln_hecs_cntrbt.gov_hecs_cntrbtn_band | |
| FIELD10-25 | blank | ||
| Field Name |
Field Description |
Source/Value |
|
| CREATION_DT |
Date and Time of Creation of the Extract |
System |
|
| FEE_CAL_TYPE |
The Fee Assessment Period for which the Extract was run |
Job Run parameter |
|
| FEE_CI_SEQUENCE_NUMBER |
|||
| PERSON_ID |
The student to which this record refers |
person.person_id |
|
| COURSE_CD |
In conjunction with Person ID, the Student Course Attempt to which this record refers |
student_course_attempt.course_id |
|
| MAJOR_SORT_SEQUENCE |
Used to group records according to parent/child relationship of data |
'06' |
|
| FEE_TYPE |
Assessed Government Loan Scheme Fee Type |
fee_ass.fee_type |
|
| MINOR_SORT_ SEQUENCE | Used to group records according to parent/child relationship of data |
'09' |
|
| KEY8 | Transaction Date | If Transaction Category is PAYMENT, fee_ass.effective_dt OR if Transaction Category is DEBT, person_payment_schedule.payment_due_dt | |
| KEY9 |
blank |
||
| RECORD_TYPE | Record Type | 'TRANSACTION-DETAILS' | |
| FIELD1 | Person ID | person.person_id | |
| FIELD2 | Course Code | student_course_attempt.course_cd | |
| FIELD3 | Fee Type | fee_type.fee_type | |
| FIELD4 | Transaction Category | s_transaction_type.transaction_cat | |
| FIELD5 | Transaction Type | s_transaction_type.transaction_type | |
| FIELD6 | Transaction Date | If Transaction Category is PAYMENT, fee_ass.effective_dt OR if Transaction Category is DEBT, person_payment_schedule.payment_due_dt | |
| FIELD7 | Transaction Amount | If Transaction Category is PAYMENT, fee_ass.transaction_amount OR if Transaction Category is DEBT, person_payment_schedule.payment_amount_due | |
| FIELD8 | Transaction ID | fee_ass.transaction_id Note, payment details only, otherwise blank | |
| FIELD9 | Sponsored Amount | sponsored_amount | |
| FIELD10 | Sponsor Code | sponsor_cd | |
| FIELD11 | Sponsorship Status | stdnt_crs_atmpt_fee_spnsrshp.fee_sponorship_status OR fee_liability_sponsorship.fee_sponsorship_status | |
| FIELD12 | Discount Percentage | discount_percentage Note, assessment details only, otherwise blank | |
| FIELD13 | Discount Amount | discount_amount Note, assessment details only, otherwise blank | |
| FIELD14 | Discount Minimum Payment | discount_min_payment Note, assessment details only, otherwise blank | |
| FIELD15 | Currency | currency_cd | |
| FIELD16 | Echange Rate | exchange_rate | |
| FIELD17 | Discount Available | calculated. Note, assessment details only, otherwise blank | |
| FIELD18 | Expected Payment | calculated. Note, assessment details only, otherwise blank | |
| FIELD19 | Expected Payment Limited check box | blank | |
| FIELD20 | Student Expected Amount | blank | |
| FIELD21 | Sponsor Expected Amount | blank | |
| FIELD22 | Loan Scheme Expected Amount | blank | |
| FIELD23 | Unit Code | student_unit_attempt.unit_cd | |
| FIELD24 | Unit Offering Option ID | blank | |
| FIELD25 | Loan Fee | fee_ass.loan_fee | |
| FIELD25 | blank | ||
| Field Name |
Field Description |
Source/Value |
|
| CREATION_DT |
Date and Time of Creation of the Extract |
System |
|
| FEE_CAL_TYPE |
The Fee Assessment Period for which the Extract was run |
Job Run parameter |
|
| FEE_CI_SEQUENCE_NUMBER |
|||
| PERSON_ID |
The student to which this record refers |
person.person_id |
|
| COURSE_CD |
In conjunction with Person ID, the Student Course Attempt to which this record refers |
student_course_attempt.course_id |
|
| MAJOR_SORT_SEQUENCE |
Used to group records according to parent/child relationship of data |
'06' |
|
| FEE_TYPE |
Assessed Government Loan Scheme Fee Type |
fee_ass.fee_type |
|
| MINOR_SORT_ SEQUENCE | Used to group records according to parent/child relationship of data |
'09' |
|
| KEY8 | Transaction Date | fee_ass.transaction_dt | |
| KEY9 |
Transaction ID |
fee_ass.transaction_id |
|
| RECORD_TYPE | Record Type | 'EXTERNAL-REFERENCES' | |
| FIELD1 | Person ID | person.person_id | |
| FIELD2 | Course Code | student_course_attempt.course_cd | |
| FIELD3 | Fee Type | fee_type.fee_type | |
| FIELD4 | Transaction ID | fee_ass.transaction_id | |
| FIELD5 | External Reference Code | fee_ass_external_ref.external_reference_cd | |
| FIELD6 | External Reference Type | fee_ass_external_ref.external_reference_type | |
| FIELD7 | External Reference Type Description | external_reference_type.description | |
| FIELD8-25 | blank | ||
| Field Name |
Field Description |
Source/Value |
|
| CREATION_DT |
Date and Time of Creation of the Extract |
System |
|
| FEE_CAL_TYPE |
The Fee Assessment Period for which the Extract was run |
Job Run parameter |
|
| FEE_CI_SEQUENCE_NUMBER |
|||
| PERSON_ID |
The student to which this record refers |
person.person_id |
|
| COURSE_CD |
In conjunction with Person ID, the Student Course Attempt to which this record refers |
student_course_attempt.course_id |
|
| MAJOR_SORT_SEQUENCE |
Used to group records according to parent/child relationship of data |
'06' |
|
| FEE_TYPE |
Assessed Government Loan Scheme Fee Type |
fee_ass.fee_type |
|
| MINOR_SORT_ SEQUENCE | Used to group records according to parent/child relationship of data |
'11' |
|
| KEY8 | blank | ||
| KEY9 |
blank |
||
| RECORD_TYPE | Record Type | 'TRANSACTION-SUMMARY' | |
| FIELD1 | Person ID | person.person_id | |
| FIELD2 | Course Code | student_course_attempt.course_cd | |
| FIELD3 | Unit Code | student_unit_at_tempt.unit_cd | |
| FIELD4 | UOO ID | student_unit_at_tempt.uoo_cd | |
| FIELD5 | Fee Type | fee_type.fee_type | |
| FIELD6 | Upfront Payment | calculated. Sum of all transaction_amount (where s_transaction_type = PAYMENT) | |
| FIELD7 | Non Retention Debt Balance | calculated. Same as FINJ6180 | |
| FIELD8 | Retention Debt Balance | calculated. Same as FINJ6180 | |
| FIELD9 | HECS-HELP discount | calculated. Sum of transactions with a s_transaction_type = HCSHLPLOAN-D | |
| FIELD10 | HECS-HELP debt | calculated. Sum of transactions with a s_transaction_type = HCSHLPLOAN | |
| FIELD11 | FEE-HELP assistance | calculated. Sum of all transactions with a s_transaction_type of FEEHLPLOAN | |
| FIELD12 | FEE-HELP Loan Fee | calculated. fee_ass.loan_fee | |
| FIELD13 | FEE_HELP debt | calculated. Sum of all FIELD7 (FEE-HELP assistance) plus FIELD8 (FEE_HELP Loan Fee) | |
| FIELD14-25 | Total Debt | blank | |
Field Name |
Field Description |
Source/Value |
|
CREATION_DT |
Date and Time of Creation of the Extract |
System |
|
FEE_CAL_TYPE |
The Fee Assessment Period for which the Extract was run |
Job Run parameter |
|
FEE_CI_SEQUENCE_NUMBER |
|||
PERSON_ID |
The student to which this record refers |
person.person_id |
|
COURSE_CD |
In conjunction with Person ID, the Student Course Attempt to which this record refers |
student_course_attempt.course_id |
|
MAJOR_SORT_SEQUENCE |
Used to group records according to parent/child relationship of data |
'06' |
|
FEE_TYPE |
Assessed Government Loan Schem Fee Type |
blank |
|
| MINOR_SORT_ SEQUENCE | Used to group records according to parent/child relationship of data |
blank |
|
| KEY8 | blank | ||
KEY9 |
blank |
||
| RECORD_TYPE | Record Type | 'EXT-STUDY-LOAN' | |
| FIELD1 | Person ID | person.person_id | |
| FIELD2 | Course Code | student_course_attempt.course.cd | |
| FIELD3 | Student Status | loan_scheme_hpo.govt_hecs_payment_option where loan_scheme = stdnt_crs_external_study_loan.loan_scheme | |
| FIELD4 | Loan Scheme | stdnt_crs_external_study_loan.loan_scheme | |
| FIELD5 | Ext Study Loan Amount | stdnt_crs_external_study_loan.loan_amount | |
| FIELD6 | Ext Study Loan Fee | stdnt_crs_external_study_loan.loan_fee | |
| FIELD7 | Ext Study Loan Total | calculated |
|
| FIELD8 | Ext Study Incurral Date | stdnt_crs_external_study_loan.incurral_date | |
| FIELD9 | Ext Study Loan Period Start Date DD/MM/YYYY | stdnt_crs_external_study_loan.study_commencement_date | |
| FIELD10 | Ext Study Loan Period End Date DD/MM/YYYY | Ext Study Loan Period Start Date + 6 months | |
| FIELD11 | Loan Status | stdnt_crs_external_study_loan.external_study_loan_status | |
| FIELD12-25 | blank | ||
| Field Name |
Field Description |
Source/Value |
|
| CREATION_DT |
Date and Time of Creation of the Extract |
System |
|
| FEE_CAL_TYPE |
The Fee Assessment Period for which the Extract was run |
Job Run parameter |
|
| FEE_CI_SEQUENCE_NUMBER |
|||
| PERSON_ID |
The student to which this record refers |
'9999999999' |
|
| COURSE_CD |
blank |
||
| MAJOR_SORT_SEQUENCE |
blank |
||
| FEE_TYPE |
blank |
||
| MINOR_SORT_ SEQUENCE | blank |
||
| KEY8 | blank | ||
| KEY9 |
blank |
||
| RECORD_TYPE | Record Type | 'FOOTER' | |
| FIELD1 | 1 | '1' | |
| FIELD2 | 'PERSON' record count | calculated | |
| FIELD3 | 'ADDRESSES' record count | calculated | |
| FIELD4 | 'SYSTEM-CREDIT' record count | calculated | |
| FIELD5 | 'COMMONWEALTH SUPPORTED AND ASSISTED COURSES' record count | calculated | |
| FIELD6 | 'ASSESSED-LIABILITIES' record count | calculated | |
| FIELD7 | 'COMMONWEALTH SUPPORTED AND ASSISTED UNITS' record count | calculated | |
| FIELD8 | 'STUDENT-CONTRIB-BANDS' record count | calculated | |
| FIELD9 | 'TRANSACTION-DETAILS' record count | calculated | |
| FIELD10 | 'EXTERNAL REFERENCES' record count | calculated | |
| FIELD11 | 'TRANSACTION-SUMMARY' record count | calculated | |
| FIELD12 | 'EXTERNAL STUDY LOAN' record count | calculated | |
| FIELD13-25 | blank | ||
Last modified on 24 January, 2008 5:30 PM
History Information
| Release Version | Project | Change to Document |
| 10.1.0.0.0.0 | C22582 | Under 12. EXTERNAL STUDY LOAN' added FIELD 11 |
| 8.0.0.0.0.0 | 0949 - OS Help | Added Field 12 to Footer |
| 7.0.2.0.0.0 | ? | Changes to Field Names and 11 modified |
| 7.0.2.0.0.0 | ? | New form |