Top of ENR | Index | Table of Contents | Feedback | ![]() |
Statement of Account Extract - View Details
For HE Sector information, select the hyperlink below.
HE Information |
Statement of Account Extract View Details
The table shows details of the fields presented by this view.
Field Name |
Field Description |
Data Source |
CREATION_DT |
Extract Creation Date |
System |
REQUEST_PERSON_ID |
ID number of person who requested this job |
Job run parameter |
CORRESPONDENCE_TYPE |
The type of Correspondence created by the job run |
Job run parameter |
FIN_CAL_TYPE |
The Calendar Type of the Financial Period for which the job was run |
Job run parameter |
FIN_CI_SEQUENCE_NUMBER |
The Calendar Instance sequence number of the Financial Period for which the job was run |
|
FEE_CAL_TYPE |
The Calendar Type of the Fee Period for which the job was run |
Job run parameter |
FEE_CI_SEQUENCE_NUMBER |
The Calendar Instance sequence number of the Fee Period for which the job was run |
|
FEE_TYPE |
Fee Type |
Job run parameter |
FEE_CAT |
Fee Category |
Job run parameter |
COURSE_CD |
Course Code |
Job run parameter |
PERSON_ID |
individual Person ID number |
Job run parameter |
PERSON_GROUP_ID |
the code of a Person ID Group |
Job run parameter |
INSTITUTION_CD |
Institution Code |
Job run parameter |
ADDR_TYPE |
Institution Address Type |
Job run parameter |
DATE_OF_ISSUE |
Planned Date of issue of statements of account |
Job run parameter |
EXTRACT_COMMENT |
Comments for inclusion on all statements of account |
Job run parameter |
TEST_EXTRACTION |
Indicates whether or not FINJ6120 was run as a test extraction only. |
Job run parameter |
REQUEST_JOB_RUN_ID |
System generated ID number of the request job run |
Passed by Job Scheduler |
REQUEST_NUM |
System generated number of the request in which the job was run |
Derived from request job run ID |
UPDATE_WHO |
system |
|
UPDATE_ON |
system |
|
RECORD_TYPE | Record Type | Opening balance |
Statement of Account Record View Details
The table provides details of the different Record Types presented by this view and the fields in each Record Type.
1.
Header
2. Person
3. Addresses
4. Opening Balance
5. System Credit
6. Assessed Courses
7. Unit Sets
8. Assessed Liabilities
9. Assessed Units
10. Discipline Bands
11. Transaction Details
12. External References
13. Fee Encumbrances
14. Encumbrance Effects
15. Footer - Record Counts
ACC_STMNT_RECORD_V |
||||
Note: All references to source database tables and columns are in italics. Fields identified by bold type are included for sorting purposes. Field names in blue are key fields, specifically included for sorting purposes. |
||||
Field Name |
Field Description |
Max Length |
Type |
Source / Value |
CREATION_DT |
Date and Time of Creation of the Extract |
DD/MM/YYYY HH24:MI:SS |
date |
System |
FIN_CAL_TYPE |
The financial Period for which the Extract was run |
10 |
char |
Job run parameter |
FIN_CI_SEQUENCE _NUMBER |
6 |
num |
||
PERSON_ID |
The student to which this record refers |
10 |
num |
'0000000000' |
ASSESSED_COURSE_CD |
blank |
|||
LAST_EFFECT_ASS_DT |
blank |
|||
MAJOR_SORT_SEQUENCE |
blank |
|||
KEY7 |
blank |
|||
MINOR_SORT_SEQUENCE |
blank |
|||
KEY9 |
blank |
|||
KEY10 |
blank |
|||
RECORD_TYPE |
Record Type |
20 |
char |
'HEADER' |
FIELD1 |
Comment |
60 |
char |
parameter |
FIELD2 |
Financial Calendar Type |
10 |
char |
cal_instance.cal_type |
FIELD3 |
Financial Calendar description |
60 |
char |
cal_type.description |
FIELD4 |
Financial Calendar Start Date |
DD/MM/YYYY |
date |
cal_instance.start_dt |
FIELD5 |
Financial Calendar End Date |
DD/MM/YYYY |
date |
cal_instance.end_dt |
FIELD6 |
Addr Type |
10 |
char |
institution_addr .addr_type |
FIELD7 |
Addr Line 1 |
40 |
char |
institution_addr .addr_line_1 |
FIELD8 |
Addr Line 2 |
40 |
char |
institution_addr .addr_line_2 |
FIELD9 |
Addr Line 3 |
40 |
char |
institution_addr .addr_line_3 |
FIELD10 |
Addr Line 4 |
40 |
char |
institution_addr .addr_line_4 |
FIELD11 |
Addr Line 5 |
40 |
char |
institution_addr .addr_line_5 |
FIELD12 |
Australian Postcode |
4 |
num |
institution_addr .aust_postcode |
FIELD13 |
OS Code |
10 |
char |
institution_addr.os_code |
FIELD14 |
Phone 1 |
20 |
char |
institution_addr.phone_1 |
FIELD15 |
Phone 2 |
20 |
char |
institution_addr.phone_2 |
FIELD16 |
Phone 3 |
20 |
char |
institution_addr.phone_3 |
FIELD17 |
Other Details |
40 |
char |
institution_addr .other_details |
FIELD18 |
Correspondence check box |
1 |
char |
addr_type .correspondence_ind |
FIELD19-27 |
blank |
|||
Field Name |
Field Description |
Max Length |
Type |
Source / Value |
CREATION_DT |
Date and Time of Creation of the Extract |
DD/MM/YYYY HH24:MI:SS |
date |
System |
FIN_CAL_TYPE |
The financial Period for which the Extract was run |
10 |
char |
Job run parameter |
FIN_CI_SEQUENCE _NUMBER |
6 |
num |
||
PERSON_ID |
The student to which this record refers |
10 |
num |
person.person_id |
ASSESSED_COURSE_CD |
blank |
|||
LAST_EFFECT_ASS_DT |
blank |
|||
MAJOR_SORT_SEQUENCE |
blank |
|||
KEY7 |
blank |
|||
MINOR_SORT_SEQUENCE |
blank |
|||
KEY9 |
blank |
|||
KEY10 |
blank |
|||
RECORD_TYPE |
Record Type |
20 |
char |
'PERSON' |
FIELD1 |
Person ID |
10 |
num |
person.person_id |
FIELD2 |
Title |
10 |
char |
person.title |
FIELD3 |
Surname |
30 |
char |
person.surname |
FIELD4 |
Given Names |
40 |
char |
person.given_names |
FIELD5 |
Payment Advice number |
20 |
char |
alternate_person_id .api_person_id |
FIELD6 |
Date of issue |
DD/MM/YYYY |
date |
Job run parameter or default system date |
FIELD7 |
Last statement |
DD/MM/YYYY |
date |
correspondence_item .create_dt |
FIELD8-27 |
blank |
|||
Field Name |
Field Description |
Max Length |
Type |
Source / Value |
CREATION_DT |
Date and Time of Creation of the Extract |
DD/MM/YYYY HH24:MI:SS |
date |
System |
FIN_CAL_TYPE |
The financial Period for which the Extract was run |
10 |
char |
Job run parameter |
FIN_CI_SEQUENCE _NUMBER |
6 |
num |
||
PERSON_ID |
The student to which this record refers |
10 |
num |
person.person_id |
ASSESSED_COURSE_CD |
blank |
|||
LAST_EFFECT_ASS_DT |
blank |
|||
MAJOR_SORT_SEQUENCE |
blank |
|||
KEY7 |
blank |
|||
MINOR_SORT_SEQUENCE |
blank |
|||
KEY9 |
blank |
|||
KEY10 |
blank |
|||
RECORD_TYPE |
Record Type |
20 |
char |
'ADDRESSES' |
FIELD1 |
Person ID |
10 |
num |
person.person_id |
FIELD2 |
Addr Type |
10 |
char |
person_addr.addr_type |
FIELD3 |
Addr Line 1 |
40 |
char |
person_addr.addr_line_1 |
FIELD4 |
Addr Line 2 |
40 |
char |
person_addr.addr_line_2 |
FIELD5 |
Addr Line 3 |
40 |
char |
person_addr.addr_line_3 |
FIELD6 |
Addr Line 4 |
40 |
char |
person_addr.addr_line_4 |
FIELD7 |
Addr Line 5 |
40 |
char |
person_addr.addr_line_5 |
FIELD8 |
Australian Postcode |
4 |
num |
person_addr .aust_postcode |
FIELD9 |
OS Code |
10 |
char |
person_addr.os_code |
FIELD10 |
Phone 1 |
20 |
char |
person_addr.phone_1 |
FIELD11 |
Phone 2 |
20 |
char |
person_addr.phone_2 |
FIELD12 |
Phone 3 |
20 |
char |
person_addr.phone_3 |
FIELD13 |
Other Details |
40 |
char |
person_addr.other_details |
FIELD14 |
Correspondence check box |
1 |
char |
addr_type .correspondence_ind |
FIELD15-27 |
blank |
|||
Field Name |
Field Description |
Max Length |
Type |
Source / Value |
CREATION_DT |
Date and Time of Creation of the Extract |
DD/MM/YYYY HH24:MI:SS |
date |
System |
FIN_CAL_TYPE |
The financial Period for which the Extract was run |
10 |
char |
Job run parameter |
FIN_CI_SEQUENCE _NUMBER |
6 |
num |
||
PERSON_ID |
The student to which this record refers |
10 |
num |
person .person_id |
ASSESSED_COURSE_CD |
blank |
|||
LAST_EFFECT_ASS_DT |
blank |
|||
MAJOR_SORT_SEQUENCE |
blank |
|||
KEY7 |
Currency of the Credit Amount |
3 |
char |
currency.currency_cd |
MINOR_SORT_SEQUENCE |
blank |
|||
KEY9 |
blank |
|||
KEY10 |
blank |
|||
RECORD_TYPE |
Record Type |
20 |
char |
'OPENING-BALANCE' |
FIELD1 |
Person ID |
10 |
num |
person.person_id |
FIELD2 |
Curency Code |
3 |
char |
derived |
FIELD3 |
Currency Description |
60 |
char |
currency.description |
FIELD4 |
Local Currency check box |
1 |
char |
currency .local_currency_ind |
FIELD5 |
Opening Balance | 999999.99 |
num |
calculated |
FIELD6-27 |
blank |
|||
Field Name |
Field Description |
Max Length |
Type |
Source / Value |
CREATION_DT |
Date and Time of Creation of the Extract |
DD/MM/YYYY HH24:MI:SS |
date |
System |
FIN_CAL_TYPE |
The financial Period for which the Extract was run |
10 |
char |
Job run parameter |
FIN_CI_SEQUENCE _NUMBER |
6 |
num |
||
PERSON_ID |
The student to which this record refers |
10 |
num |
person .person_id |
ASSESSED_COURSE_CD |
blank |
|||
LAST_EFFECT_ASS_DT |
blank |
|||
MAJOR_SORT_SEQUENCE |
blank |
|||
KEY7 |
Currency of the Credit Amount |
3 |
char |
currency.currency_cd |
MINOR_SORT_SEQUENCE |
blank |
|||
KEY9 |
blank |
|||
KEY10 |
blank |
|||
RECORD_TYPE |
Record Type |
20 |
char |
'SYSTEM-CREDIT' |
FIELD1 |
Person ID |
10 |
num |
person.person_id |
FIELD2 |
Curency Code |
3 |
char |
derived |
FIELD3 |
Currency Description |
60 |
char |
currency.description |
FIELD4 |
Local Currency check box |
1 |
char |
currency .local_currency_ind |
FIELD5 |
Credit Amount |
999999.99 |
num |
calculated |
FIELD6 |
Unmatched Payment |
999999.99 |
num |
calculated |
FIELD7-27 |
blank |
|||
Field Name |
Field Description |
Max Length |
Type |
Source / Value |
CREATION_DT |
Date and Time of Creation of the Extract |
DD/MM/YYYY HH24:MI:SS |
date |
System |
FIN_CAL_TYPE |
The financial Period for which the Extract was run |
10 |
char |
Job run parameter |
FIN_CI_SEQUENCE _NUMBER |
6 |
num |
||
PERSON_ID |
The student to which this record refers |
10 |
num |
person.person_id |
ASSESSED_COURSE_CD |
In conjunction with Person ID, the Student Course Attempt to which this record refers |
6 |
char |
student_course_attempt .course_cd |
LAST_EFFECT_ASS_DT |
The last Effective Date on which the Student Course Attempt had a Fee Assessed |
DD/MM/YYYY |
date |
greatest fee_ass .effective_dt |
MAJOR_SORT_SEQUENCE |
blank |
|||
KEY7 |
blank |
|||
MINOR_SORT_SEQUENCE |
blank |
|||
KEY9 |
blank |
|||
KEY10 |
blank |
|||
RECORD_TYPE |
Record Type |
20 |
char |
'ASSESSED-COURSES' |
FIELD1 |
Person ID |
10 |
num |
person.person_id |
FIELD2 |
Course Code |
6 |
char |
student_course_attempt .course_cd |
FIELD3 |
Last Effective Assessment Date |
DD/MM/YYYY |
date |
greatest fee_ass .effective_dt |
FIELD4 |
Version |
6 |
num |
student_course_attempt .version_number as at date in field 3 |
FIELD5 |
Title |
90 |
char |
course_version.title |
FIELD6 |
Short Title |
40 |
char |
course_version.short_title |
FIELD7 |
Course Type |
10 |
char |
course_version.course_type |
FIELD8 |
Location |
10 |
char |
student_course_attempt .location_cd as at date in field 3 |
FIELD9 |
Attendance Mode |
2 |
char |
student_course_attempt .attendance_mode as at date in field 3 |
FIELD10 |
Attendance Type |
2 |
char |
student_course_attempt .attendance_type as at date in field 3 |
FIELD11 |
derived Attendance Mode |
2 |
char |
student_course_attempt .derived_att_mode as at date in field 3 |
FIELD12 |
Derived Attendance Type |
2 |
char |
student_course_attempt .derived_att_type as at date in field 3 |
FIELD13 |
Status |
10 |
char |
student_course_attempt .course_attempt_status as at date in field 3 |
FIELD14 |
Commencement Date |
DD/MM/YYYY |
date |
student_course_attempt .commencement_dt as at date in field 3 |
FIELD15 |
Discontinued Date |
DD/MM/YYYY |
date |
student_course_attempt .discontinued_dt as at date in field 3 |
FIELD16 |
Fee Category |
10 |
char |
student_course_attempt .fee_cat as at date in field 3 |
FIELD17 |
Fee Category description |
60 |
char |
fee_cat.description as at date in field 3 |
FIELD18 |
Funding Source |
10 |
char |
student_course_attempt .funding_source as at date in field 3 |
FIELD19 |
Correspondence Category |
10 |
char |
student_course_attempt .correspondence_cat as at date in field 3 |
FIELD20 |
Differential Student Contribution |
1 |
char |
student_course_hecs_option .differential_hecs_ind as at the census date associated with the Fee Period |
FIELD21 |
Student Status |
10 |
char |
student_course_hecs_option .hecs_payment_option as at the census date associated with the Fee Period |
FIELD22-27 |
blank |
|||
Field Name |
Field Description |
Max Length |
Type |
Source / Value |
CREATION_DT |
Date and Time of Creation of the Extract |
DD/MM/YYYY HH24:MI:SS |
date |
System |
FIN_CAL_TYPE |
The financial Period for which the Extract was run |
10 |
char |
Job run parameter |
FIN_CI_SEQUENCE _NUMBER |
6 |
num |
||
PERSON_ID |
The student to which this record refers |
10 |
num |
person.person_id |
ASSESSED_COURSE_CD |
In conjunction with Person ID, the Student Course Attempt to which this record refers |
6 |
char |
student_course_attempt .course_cd |
LAST_EFFECT_ASS_DT |
The last Effective Date on which the Student Course Attempt had a Fee Assessed |
DD/MM/YYYY |
date |
greatest fee_ass .effective_dt |
MAJOR_SORT_SEQUENCE |
Used to Group Records according to parent/child relationship of data |
2 |
num |
'06' |
KEY7 |
Unit Set Code |
10 |
char |
student_unit_set_attempt .unit_set_cd |
MINOR_SORT_SEQUENCE |
blank |
|||
KEY9 |
blank |
|||
KEY10 |
blank |
|||
RECORD_TYPE |
Record Type |
20 |
char |
'UNIT-SETS' |
FIELD1 |
Person ID |
10 |
num |
person.person_id |
FIELD2 |
Course Code |
6 |
char |
student_course_attempt .course_cd |
FIELD3 |
Unit Set Code |
10 |
char |
student_unit_set_attempt .unit_set_cd |
FIELD4 |
Version Number |
6 |
num |
student_unit_set_attempt .us_version_number |
FIELD5 |
Title |
90 |
char |
unit_set.title |
FIELD6 |
Short Title |
40 |
char |
unit_set.short_title |
FIELD7 |
Override Title |
90 |
char |
student_unit_set_attempt .override_title |
FIELD8 |
Unit Set Category |
10 |
char |
unit_set.unit_set_cat |
FIELD9 |
Unit Set Category Description |
60 |
char |
unit_set_cat.description |
FIELD10 |
Rank |
3 |
num |
unit_set_cat.rank |
FIELD11 |
Primary Set |
1 |
char |
student_unit_set_attempt .primary_set_ind |
FIELD12 |
Selection Date |
DD/MM/YYYY |
date |
student_unit_set_attempt .selection_dt |
FIELD13 |
End Date |
DD/MM/YYYY |
date |
student_unit_set_attempt .end_dt |
FIELD14 |
Requirements Complete Date |
DD/MM/YYYY |
date |
student_unit_set_attempt .rqrmnts_complete_dt |
FIELD15-27 |
blank |
|||
Field Name |
Field Description |
Max Length |
Type |
Source / Value |
CREATION_DT |
Date and Time of Creation of the Extract |
DD/MM/YYYY HH24:MI:SS |
date |
System |
FIN_CAL_TYPE |
The financial Period for which the Extract was run |
10 |
char |
Job run parameter |
FIN_CI_SEQUENCE _NUMBER |
6 |
num |
||
PERSON_ID |
The student to which this record refers |
10 |
num |
person.person_id |
ASSESSED_COURSE_CD |
In conjunction with Person ID, the Student Course Attempt to which this record refers |
6 |
char |
student_course_attempt .course_cd |
LAST_EFFECT_ASS_DT |
The last Effective Date on which the Student Course Attempt had a Fee Assessed |
DD/MM/YYYY |
date |
greatest fee_ass .effective_dt |
MAJOR_SORT_SEQUENCE |
Used to Group Records according to parent/child relationship of data |
2 |
num |
'07' |
KEY7 |
Fee Type |
10 |
char |
fee_ass.fee_type |
MINOR_SORT_SEQUENCE |
blank |
|||
KEY9 |
blank |
|||
KEY10 |
blank |
|||
RECORD_TYPE |
Record Type |
20 |
char |
'ASSESSED-LIABILITIES' |
FIELD1 |
Person ID |
10 |
num |
person.person_id |
FIELD2 |
Course Code |
6 |
char |
student_course_attempt .course_cd |
FIELD3 |
Fee Type |
10 |
char |
fee_ass.fee_type |
FIELD4 |
Fee Type Description |
60 |
char |
fee_type.description |
FIELD5 |
Fee Assessment Period |
10 |
char |
cal_instance.cal_type |
FIELD6 |
6 |
num |
cal_instance .sequence_number |
|
FIELD7 |
Fee Calendar Description |
60 |
char |
cal_type.description |
FIELD8 |
Fee Calendar Start Date |
DD/MM/YYYY |
date |
cal_instance.start_dt |
FIELD9 |
Fee Calendar End Date |
DD/MM/YYYY |
date |
cal_instance.end_dt |
FIELD10 |
Fee Assessment Period Start |
DD/MM/YYYY |
date |
dt_alias_instance_v .alias_val |
FIELD11 |
Fee Assessment Period End |
DD/MM/YYYY |
date |
dt_alias_instance_v .alias_val |
FIELD12 |
System Fee Type |
10 |
char |
fee_type.s_fee_type |
FIELD13 |
System Fee Trigger Category |
10 |
char |
fee_type.s_fee_trigger_cat |
FIELD14 |
Optional Payment check box |
1 |
char |
fee_type .optional_payment_ind |
FIELD15 |
Charge Method |
10 |
char |
fee_type_cal_instance .s_chg_method_type / fee_cat_fee_liability .s_chg_method_type |
FIELD16 |
Last Transaction Date |
DD/MM/YYYY |
date |
greatest fee_ass .transaction_dt |
FIELD17 |
Last Effective Assessment Date |
DD/MM/YYYY |
date |
greatest fee_ass .effective_dt |
FIELD18 |
Last Notification Date |
DD/MM/YYYY |
date |
greatest fee_ass .notification_dt |
FIELD19 |
Retained Debt Amount |
9999999.999 |
num |
calculated |
FIELD20 |
Manual Entry |
1 |
char |
Y or N (Y if any manual fee assessment entries exist) |
FIELD21 |
Payment Overdue |
1 |
char |
calculated (Y/N) (Y if overdue) |
FIELD22-27 |
blank |
|||
Field Name |
Field Description |
Max Length |
Type |
Source / Value |
CREATION_DT |
Date and Time of Creation of the Extract |
DD/MM/YYYY HH24:MI:SS |
date |
System |
FIN_CAL_TYPE |
The financial Period for which the Extract was run |
10 |
char |
Job run parameter |
FIN_CI_SEQUENCE _NUMBER |
6 |
num |
||
PERSON_ID |
The student to which this record refers |
10 |
num |
person.person_id |
ASSESSED_COURSE_CD |
In conjunction with Person ID, the Student Course Attempt to which this record refers |
6 |
char |
student_course_attempt .course_cd |
LAST_EFFECT_ASS_DT |
The last Effective Date on which the Student Course Attempt had a Fee Assessed |
DD/MM/YYYY |
date |
greatest fee_ass .effective_dt |
MAJOR_SORT_SEQUENCE |
Used to Group Records according to parent/child relationship of data |
2 |
num |
'07' |
KEY7 |
Fee Type |
10 |
char |
fee_ass.fee_type |
MINOR_SORT_SEQUENCE |
Used to Group Records according to second level parent/child relationship of data |
2 |
num |
'08' |
KEY9 |
Unit Code |
10 |
char |
student_unit_attempt .unit_cd |
KEY10 |
blank |
|||
RECORD_TYPE |
Record Type |
20 |
char |
'ASSESSED-UNITS' |
FIELD1 |
Person ID |
10 |
num |
person.person_id |
FIELD2 |
Course Code |
6 |
char |
student_course_attempt .course_cd |
FIELD3 |
Fee Type |
10 |
char |
fee_type.fee_type |
FIELD4 |
Unit Code |
10 |
char |
student_unit_attemp .unit_cd |
FIELD5 |
Last Effective Assessment Date |
DD/MM/YYYY |
date |
greatest fee_ass .effective_dt |
FIELD6 |
Version Number |
6 |
num |
student_unit_attempt .version_number as at date in field 5 |
FIELD7 |
Unit Short Title |
40 |
char |
unit_version.short_title |
FIELD8 |
Teaching Period |
10 |
char |
student_unit_attempt .cal_type as at date in field 5 |
FIELD9 |
6 |
num |
student_unit_attempt .ci_sequence_number as at date in field 5 |
|
FIELD10 |
Teaching Calendar Description |
60 |
char |
cal_type.description |
FIELD11 |
Teaching Calendar Start Date |
DD/MM/YYYY |
date |
cal_instance.start_dt |
FIELD12 |
Teaching Calendar End Date |
DD/MM/YYYY |
date |
cal_instance.end_dt |
FIELD13 |
Teaching Period Code |
10 |
char |
cal_instance .alternate_code |
FIELD14 |
Location |
10 |
char |
student_unit_attempt .location_cd as at date in field 5 |
FIELD15 |
Class |
10 |
char |
student_unit_attempt .unit_class as at date in field 5 |
FIELD16 |
Status |
10 |
char |
student_unit_attempt .unit_attempt_status as at date in field 5 |
FIELD17 |
Administrative Status |
10 |
char |
student_unit_attempt .administrative_ unit_status as at date in field 5 |
FIELD18 |
Enrolled Date |
DD/MM/YYYY |
date |
student_unit_attempt .enrolled_dt as at date in field 5 |
FIELD19 |
Discontinued Date |
DD/MM/YYYY |
date |
student_unit_attempt .discontinued_dt as at date in field 5 |
FIELD20 |
EFSTL |
9999999.999 |
num |
calculated |
FIELD21 |
Credit Points |
9999999.999 |
num |
calculated |
FIELD22-27 |
blank |
|||
Field Name |
Field Description |
Max Length |
Type |
Source / Value |
CREATION_DT |
Date and Time of Creation of the Extract |
DD/MM/YYYY HH24:MI:SS |
date |
System |
FIN_CAL_TYPE |
The financial Period for which the Extract was run |
10 |
char |
Job run parameter |
FIN_CI_SEQUENCE _NUMBER |
6 |
num |
||
PERSON_ID |
The student to which this record refers |
10 |
num |
person.person_id |
ASSESSED_COURSE_CD |
In conjunction with Person ID, the Student Course Attempt to which this record refers |
6 |
char |
student_course_attempt .course_cd |
LAST_EFFECT_ASS_DT |
The last Effective Date on which the Student Course Attempt had a Fee Assessed |
DD/MM/YYYY |
date |
greatest fee_ass .effective_dt |
MAJOR_SORT_SEQUENCE |
Used to Group Records according to parent/child relationship of data |
2 |
num |
'07' |
KEY7 |
Fee Type of the Student Contribution assessment |
10 |
char |
fee_ass.fee_type |
MINOR_SORT_SEQUENCE |
Used to Group Records according to second level parent/child relationship of data |
2 |
num |
'08' |
KEY9 |
Unit Code to which Student Contribution record relates |
10 |
char |
student_unit_attempt .unit_cd |
KEY10 |
The Discipline Group on which Discipline Band was determined |
4 |
char |
discipline .govt_discipline_group_cd |
RECORD_TYPE |
Record Type |
20 |
char |
'HECS-CONTRIB-BANDS' |
FIELD1 |
Person ID |
10 |
num |
person.person_id |
FIELD2 |
Course Code |
6 |
char |
student_course_attempt .course_cd |
FIELD3 |
Fee Type |
10 |
char |
fee_ass.fee_type |
FIELD4 |
Unit Code |
10 |
char |
student_unit_attempt .unit_cd |
FIELD5 |
Version Number |
6 |
num |
student_unit_attempt .version_number |
FIELD6 |
Discipline Group |
4 |
char |
unit_discipline .discipline_group_cd |
FIELD7 |
Percentage |
999.99 |
num |
unit_discipline.percentage |
FIELD8 |
Government Discipline Group |
4 |
char |
govt_discipline .govt_discipline_group_cd |
FIELD9 |
Discipline Band |
2 |
num |
govt_dscpln_hecs_cntrbt .govt_hecs_cntrbtn_band |
FIELD10-27 |
blank |
|||
Field Name |
Field Description |
Max Length |
Type |
Source / Value |
CREATION_DT |
Date and Time of Creation of the Extract |
DD/MM/YYYY HH24:MI:SS |
date |
System |
FIN_CAL_TYPE |
The financial Period for which the Extract was run |
10 |
char |
Job run parameter |
FIN_CI_SEQUENCE _NUMBER |
6 |
num |
||
PERSON_ID |
The student to which this record refers |
10 |
num |
person.person_id |
ASSESSED_COURSE_CD |
In conjunction with Person ID, the Student Course Attempt to which this record refers |
6 |
char |
student_course_attempt .course_cd |
LAST_EFFECT_ASS_DT |
The last Effective Date on which the Student Course Attempt had a Fee Assessed |
DD/MM/YYYY |
date |
greatest fee_ass .effective_dt |
MAJOR_SORT_SEQUENCE |
Used to Group Records according to parent/child relationship of data |
2 |
num |
'07' |
KEY7 |
Fee Type |
10 |
char |
fee_ass.fee_type |
MINOR_SORT_SEQUENCE |
Used to Group Records according to second level parent/child relationship of data |
2 |
num |
'10' |
KEY9 |
Transaction Date |
DD/MM/YYYY |
date |
If transaction category is PAYMENT, fee_ass.effective_dt OR if transaction category is DEBT, person_payment_schedule .payment_due_dt |
KEY10 |
blank |
|||
RECORD_TYPE |
Record Type |
20 |
char |
'TRANSACTION-DETAILS' |
FIELD1 |
Person ID |
10 |
num |
person.person_id |
FIELD2 |
Course Code |
6 |
char |
student_course_attempt .course_cd |
FIELD3 |
Fee Type |
10 |
char |
fee_type.fee_type |
FIELD4 |
Transaction Category |
10 |
char |
s_transaction_type .transaction_cat |
FIELD5 |
Transaction Type |
10 |
char |
fee_ass.s_transaction_type |
FIELD6 |
Transaction Date |
DD/MM/YYYY |
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 |
999999.99 |
num |
If transaction category is PAYMENT, fee_ass.transaction_amount OR if transaction category is DEBT, person_payment_schedule .payment_amount_due |
FIELD8 |
Tax Amount |
999999.99 |
num |
If
transaction category is PAYMENT, calculated |
FIELD9 |
Transaction ID |
6 |
num |
fee_ass.transaction_id Note, payment details only, otherwise blank |
FIELD10 |
Sponsored Amount |
999999.99 |
num |
sponsored_amount |
FIELD 11 |
Sponsor Tax Amount |
999999.99 |
num |
person_payment_schedule.sponsored_tax_amount |
FIELD12 |
Sponsor Code |
10 |
char |
sponsor_cd |
FIELD13 |
Sponsorship Status |
10 |
char |
stdnt_crs_atmpt_fee_spnsrshp .fee_sponsorship_status OR fee_liability_sponsorship .fee_sponsorship_status |
FIELD14 |
Discount Percentage |
999.99 |
num |
discount_percentage Note, assessment details only, otherwise blank |
FIELD15 |
Discount Amount |
999999.99 |
num |
discount_amount Note, assessment details only, otherwise blank |
FIELD16 |
Discount Minimum Payment |
999999.99 |
num |
discount_min_payment Note, assessment details only, otherwise blank |
FIELD17 |
Currency |
3 |
char |
currency_cd |
FIELD18 |
Exchange Rate |
9999.9999 |
num |
exchange_rate |
FIELD19 |
Discount Available |
999999.99 |
num |
calculated (assessment details only), else blank |
FIELD20 |
Tax Discount Available |
999999.99 |
num |
calculated (assessment details only), else blank |
FIELD21 |
Expected Payment |
9999.99 |
num |
calculated (assessment details only), else blank |
FIELD22 |
Expected Tax Amount |
999999 |
num |
calculated (assessment details only), else blank |
FIELD23 | Tax Reference Number | 20 | char | fee_cat_cal_instance.tax_reference |
FIELD24 | Limited Payment check box | 1 | char | if expected amount for student has been limited by the student_ crs_hecs_opt_override. maximum_payment_ limit = Y otherwise N |
FIELD25 | Student Expected Amount | 999999.99 | num | calculated amount |
FIELD26 | Sponsor Expected Amount | 999999.99 | num | calculated amount |
FIELD27 |
Loan Scheme Expected Amount | 999999.99 |
num |
calculated amount |
Field Name |
Field Description |
Max Length |
Type |
Source / Value |
CREATION_DT |
Date and Time of Creation of the Extract |
DD/MM/YYYY HH24:MI:SS |
date |
System |
FIN_CAL_TYPE |
The financial Period for which the Extract was run |
10 |
char |
Job run parameter |
FIN_CI_SEQUENCE _NUMBER |
6 |
num |
||
PERSON_ID |
The student to which this record refers |
10 |
num |
person.person_id |
ASSESSED_COURSE_CD |
In conjunction with Person ID, the Student Course Attempt to which this record refers |
6 |
char |
student_course_attempt .course_cd |
LAST_EFFECT_ASS_DT |
The last Effective Date on which the Student Course Attempt had a Fee Assessed |
DD/MM/YYYY |
date |
greatest fee_ass .effective_dt |
MAJOR_SORT_SEQUENCE |
Used to Group Records according to parent/child relationship of data |
2 |
num |
'07' |
KEY7 |
Fee Type |
10 |
char |
fee_ass.fee_type |
MINOR_SORT_SEQUENCE |
Used to Group Records according to second level parent/child relationship of data |
2 |
num |
'10' |
KEY9 |
Transaction Date |
DD/MM/YYYY |
date |
fee_ass .transaction_dt |
KEY10 |
Transaction Identification Number |
6 |
num |
fee_ass .transaction_id |
RECORD_TYPE |
Record Type |
20 |
char |
'EXTERNAL-REFERENCES' |
FIELD1 |
Person ID |
10 |
num |
person.person_id |
FIELD2 |
Course Code |
6 |
char |
student_course_attempt .course_cd |
FIELD3 |
Fee Type |
10 |
char |
fee_ass.fee_type |
FIELD4 |
Transaction ID |
6 |
num |
fee_ass.transaction_id |
FIELD5 |
External Reference Code |
10 |
char |
fee_ass_external_ref .external_reference_cd |
FIELD6 |
External Reference Type |
10 |
char |
fee_ass_external_ref .external_reference_type |
FIELD7 |
External Reference Type Description |
60 |
char |
external_reference_type .description |
FIELD8-27 |
blank |
|||
Field Name |
Field Description |
Max Length |
Type |
Source / Value |
CREATION_DT |
Date and Time of Creation of the Extract |
DD/MM/YYYY HH24:MI:SS |
date |
System |
FIN_CAL_TYPE |
The financial Period for which the Extract was run |
10 |
char |
Job run parameter |
FIN_CI_SEQUENCE _NUMBER |
6 |
num |
||
PERSON_ID |
The student to which this record refers |
10 |
num |
person.person_id |
ASSESSED_COURSE_CD |
In conjunction with Person ID, the Student Course Attempt to which this record refers |
6 |
char |
student_course_attempt .course_cd |
LAST_EFFECT_ASS_DT |
The last Effective Date on which the Student Course Attempt had a Fee Assessed |
DD/MM/YYYY |
date |
greatest fee_ass .effective_dt |
MAJOR_SORT_SEQUENCE |
Used to Group Records according to parent/child relationship of data |
2 |
num |
'07' |
KEY7 |
Fee Type |
10 |
char |
fee_ass.fee_type |
MINOR_SORT_SEQUENCE |
Used to Group Records according to second level parent/child relationship of data |
2 |
num |
'12' |
KEY9 |
Fee Encumbrance Date |
DD/MM/YYYY |
date |
pending_fee_encumbrance .fee_encumbrance_dt |
KEY10 |
Encumbrance Type |
10 |
char |
pending_fee_encumbrance .encumbrance_type |
RECORD_TYPE |
Record Type |
20 |
char |
'FEE-ENCUMBRANCES' |
FIELD1 |
Person ID |
10 |
num |
person.person_id |
FIELD2 |
Course Code |
6 |
char |
student_course_attempt .course_cd |
FIELD3 |
Fee Type |
10 |
char |
fee_ass.fee_type |
FIELD4 |
Fee Encumbrance Date |
DD/MM/YYYY |
date |
pending_fee_encumbrance .fee_encumbrance_dt |
FIELD5 |
Encumbrance Type |
10 |
char |
pending_fee_encumbrance .s_encumbrance_type |
FIELD6 |
Encumbrance Type Description |
60 |
char |
encumbrance_type .description |
FIELD7 |
Status |
10 |
char |
pending_fee_encumbrance .pending_fee_encmb_status |
FIELD8 |
System Status |
10 |
char |
pending_fee_encmb_status .s_pending_fee_encmb_status |
FIELD9 |
Status Description |
60 |
char |
pending_fee_encmb_status .description |
FIELD10 |
Encumbrance Category |
10 |
char |
encumbrance_type .s_encumbrance_cat |
FIELD11 |
Start Date |
DD/MM/YYYY |
date |
person_encumbrance .start_date, else blank |
FIELD12 |
Expiry Date |
DD/MM/YYYY |
date |
person_encumbrance .expiry_date, else blank |
FIELD13 |
Comment |
2000 |
char |
pending_fee_encumbrance .comments, else encumbrance_type.comments |
FIELD14-27 |
blank |
|||
Field Name |
Field Description |
Max Length |
Type |
Source / Value |
CREATION_DT |
Date and Time of Creation of the Extract |
DD/MM/YYYY HH24:MI:SS |
date |
System |
FIN_CAL_TYPE |
The financial Period for which the Extract was run |
10 |
char |
Job run parameter |
FIN_CI_SEQUENCE _NUMBER |
6 |
num |
||
PERSON_ID |
The student to which this record refers |
10 |
num |
person.person_id |
ASSESSED_COURSE_CD |
In conjunction with Person ID, the Student Course Attempt to which this record refers |
6 |
char |
student_course_attempt .course_cd |
LAST_EFFECT_ASS_DT |
The last Effective Date on which the Student Course Attempt had a Fee Assessed |
DD/MM/YYYY |
date |
greatest fee_ass .effective_dt |
MAJOR_SORT_SEQUENCE |
Used to Group Records according to parent/child relationship of data |
2 |
num |
'07' |
KEY7 |
Fee Type |
10 |
char |
fee_ass.fee_type |
MINOR_SORT_SEQUENCE |
Used to Group Records according to second level parent/child relationship of data |
2 |
num |
'12' |
KEY9 |
Fee Encumbrance Date |
DD/MM/YYYY |
date |
pending_fee_encumbrance .fee_encumbrance_dt |
KEY10 |
Cocatenation of Encumbrance Type and System Encumbrance Effect |
20 |
char |
pending_fee_encumbrance .encumbrance_type || person_encumbrance_effect .s_encmb_effect_type |
RECORD_TYPE |
Record Type |
20 |
char |
'ENCUMBRANCE-EFFECTS' |
FIELD1 |
Person ID |
10 |
num |
person.person_id |
FIELD2 |
Course Code |
6 |
char |
student_course_attempt .course_cd |
FIELD3 |
Fee Type |
10 |
char |
fee_ass.fee_type |
FIELD4 |
Fee Encumbrance Date |
DD/MM/YYYY |
date |
pending_fee_encumbrance .fee_encumbrance_dt, else date on which encumbrance will be applied |
FIELD5 |
Encumbrance Type |
10 |
char |
pending_fee_encumbrance .encumbrance_type |
FIELD6 |
Encumbrance Effect Type |
10 |
char |
encmb_type_dflt_effect .s_encmb_effect_type, else person_encumbrance_effect .s_encmb_effect_type |
FIELD7 |
Start Date |
DD/MM/YYYY |
date |
person_encumbrance_effect .pee_start_dt, else blank |
FIELD8 |
Expiry Date |
DD/MM/YYYY |
date |
person_encumbrance_effect .expiry_dt, else blank |
FIELD9-27 |
blank |
|||
Field Name |
Field Description |
Max Length |
Type |
Source / Value |
CREATION_DT |
Date and Time of Creation of the Extract |
DD/MM/YYYY HH24:MI:SS |
date |
System |
FIN_CAL_TYPE |
The financial Period for which the Extract was run |
10 |
char |
Job run parameter |
FIN_CI_SEQUENCE _NUMBER |
6 |
num |
||
PERSON_ID |
The student to which this record refers |
10 |
num |
'9999999999' |
ASSESSED_COURSE_CD |
blank |
|||
LAST_EFFECT_ASS_DT |
blank |
|||
MAJOR_SORT_SEQUENCE |
blank |
|||
KEY7 |
blank |
|||
MINOR_SORT_SEQUENCE |
blank |
|||
KEY9 |
blank |
|||
KEY10 |
blank |
|||
RECORD_TYPE |
Record Type |
20 |
char |
'FOOTER' |
FIELD1 |
Count of Record Type PERSON |
6 |
num |
calculated |
FIELD2 |
Count of Record Type ADDRESSES |
6 |
num |
calculated |
FIELD3 |
Count of Record Type SYSTEM-CREDIT |
6 |
num |
calculated |
FIELD4 |
Count of Record Type ASSESSED-COURSES |
6 |
num |
calculated |
FIELD5 |
Count of Record Type UNIT-SETS |
6 |
num |
calculated |
FIELD6 |
Count of Record Type ASSESSED-LIABILITIES |
6 |
num |
calculated |
FIELD7 |
Count of Record Type ASSESSED-UNITS |
6 |
num |
calculated |
FIELD8 |
Count of Record Type HECS-CONTRIB-BANDS |
6 |
num |
calculated |
FIELD9 |
Count of Record Type TRANSACTION-DETAILS |
6 |
num |
calculated |
FIELD10 |
Count of Record Type EXTERNAL-REFERENCES |
6 |
num |
calculated |
FIELD11 |
Count of Record Type FEE-ENCUMBRANCES |
6 |
num |
calculated |
FIELD12 |
Count of Record Type ENCUMBRANCE-EFFECTS |
6 |
num |
calculated |
FIELD13 | Count of Record Type OPENING BALANCE | 6 | num | calculated |
FIELD14-27 |
blank |
Last Modified on 08 December, 2004