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 (num(10)) |
|
CORRESPONDENCE_TYPE |
the type of correspondence created by the job run |
job run parameter (char(10) |
|
FEE_CAL_TYPE |
the calendar type of the fee period for which the job was run |
job run parameter (char(10) (num(6)) |
|
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 (char(10)) |
|
FEE_CAT |
fee category |
job run parameter (char(10)) |
|
COURSE_CD |
course code |
job run parameter (char(6)) |
|
PERSON_ID |
individual person ID number |
job run parameter (num(10)) |
|
PERSON_GROUP_ID |
the code of a person ID group |
job run parameter (num(6)) |
|
INSTITUTION_CD |
institution code |
job run parameter (char(10)) |
|
ADDR_TYPE |
institution address type |
job run parameter (char(10)) |
|
DATE_OF_ISSUE |
planned date of issue of HECS Liability Notices |
job run parameter (dd/mm/yyyy) |
|
EXTRACT_COMMENT |
comments for inclusion on all HECS Liability Notices |
job run parameter (up to char(60)) |
|
TEST_EXTRACTION |
indicates whether or not FINJ6190 was run as a test extraction only. |
job run parameter (Y or N) |
|
REQUEST_JOB_RUN_ID |
system generated ID number of the request job run |
passed by job scheduler (num(10)) |
|
REQUEST_NUM |
system generated number of the request in which the job was run |
derived from request job run ID (num(9)) |
|
UPDATE_WHO |
audit detail of person who created the extract |
system (up to char(30)) |
|
UPDATE_ON |
audit detail of when the extract was created |
system (dd/mm/yyy hh24:mi:ss) |
The table provides details of the different record types presented by this view and the fields in each record type.
HECS_LBLTY_RECORD_V |
||||
NOTE: All references to source database
tables and columns are in italics. |
||||
Field name |
Field description |
Max length |
Type |
Source / Value |
1. HEADER |
||||
CREATION_DT |
date and time of creation of the extract |
DD/MM/YYYY HH24:MI:SS |
date |
system |
FEE_CAL_TYPE |
the fee assessment period for which the extract was run |
10 |
char |
job run parameter |
FEE_CI_SEQUENCE _NUMBER |
6 |
num |
||
PERSON_ID |
the student to which this record refers |
10 |
num |
'0000000000' |
COURSE_CD |
|
|
|
blank |
MAJOR_SORT_ SEQUENCE |
|
|
|
blank |
FEE_TYPE |
|
|
|
blank |
MINOR_SORT_ SEQUENCE |
|
|
|
blank |
KEY8 |
|
|
|
blank |
KEY9 |
|
|
|
blank |
RECORD_TYPE |
record type |
20 |
char |
'HEADER' |
FIELD1 |
comment |
60 |
char |
parameter |
FIELD2 |
fee calendar type |
10 |
char |
cal_instance.cal_type |
FIELD3 |
fee calendar description |
60 |
char |
cal_type.description |
FIELD4 |
fee calendar start date |
DD/MM/YYYY |
date |
cal_instance.start_dt |
FIELD5 |
fee calendar end date |
DD/MM/YYYY |
date |
cal_instance.end_dt |
FIELD6 |
address type |
10 |
char |
institution_addr .addr_type |
FIELD7 |
address line 1 |
40 |
char |
institution_addr .addr_line_1 |
FIELD8 |
address line 2 |
40 |
char |
institution_addr .addr_line_2 |
FIELD9 |
address line 3 |
40 |
char |
institution_addr .addr_line_3 |
FIELD10 |
address line 4 |
40 |
char |
institution_addr .addr_line_4 |
FIELD11 |
address line 5 |
40 |
char |
institution_addr .addr_line_5 |
FIELD12 |
Australian postcode |
4 |
num |
institution_addr .aust_postcode |
FIELD13 |
overseas postal 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 indicator |
1 |
char |
addr_type .correspondence_ind |
FIELD19-22 |
|
|
|
blank |
2. PERSON |
||||
CREATION_DT |
date and time of creation of the extract |
DD/MM/YYYY HH24:MI:SS |
date |
system |
FEE_CAL_TYPE |
the fee assessment period for which the extract was run |
10 |
char |
job run parameter |
FEE_CI_SEQUENCE _NUMBER |
6 |
num |
||
PERSON_ID |
the student to which the record refers |
10 |
num |
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 |
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 |
outgoing _correspondence .issue_dt |
FIELD7 |
last notice date |
DD/MM/YYYY |
date |
correspondence_item .create_dt |
FIELD8-22 |
|
|
|
blank |
3. ADDRESSES |
||||
CREATION_DT |
date and time of creation of the extract |
DD/MM/YYYY HH24:MI:SS |
date |
system |
FEE_CAL_TYPE |
the fee assessment period for which the extract was run |
10 |
char |
job run parameter |
FEE_CI_SEQUENCE _NUMBER |
6 |
num |
||
PERSON_ID |
the student to which the record refers |
10 |
num |
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 |
20 |
char |
'ADDRESSES' |
FIELD1 |
person ID |
10 |
num |
person.person_id |
FIELD2 |
address type |
10 |
char |
person_addr .addr_type |
FIELD3 |
address line 1 |
40 |
char |
person_addr .addr_line_1 |
FIELD4 |
address line 2 |
40 |
char |
person_addr .addr_line_2 |
FIELD5 |
address line 3 |
40 |
char |
person_addr .addr_line_3 |
FIELD6 |
address line 4 |
40 |
char |
person_addr .addr_line_4 |
FIELD7 |
address line 5 |
40 |
char |
person_addr .addr_line_5 |
FIELD8 |
Australian postcode |
4 |
num |
person_addr .aust_postcode |
FIELD9 |
overseas postal 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 indicator |
1 |
char |
addr_type .correspondence_ind |
FIELD15-22 |
|
|
|
blank |
4. SYSTEM CREDIT |
||||
CREATION_DT |
date and time of creation of the extract |
DD/MM/YYYY HH24:MI:SS |
date |
system |
FEE_CAL_TYPE |
the fee assessment period for which the extract was run |
10 |
char |
job run parameter |
FEE_CI_SEQUENCE _NUMBER |
6 |
num |
||
PERSON_ID |
the student to which the record refers |
10 |
num |
person. .person_id |
COURSE_CD |
|
|
|
blank |
MAJOR_SORT_ SEQUENCE |
|
|
|
blank |
FEE_TYPE |
|
|
|
blank |
MINOR_SORT_ SEQUENCE |
|
|
|
blank |
KEY8 |
currency of the credit |
3 |
char |
currency.currency_cd |
KEY9 |
|
|
|
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 indicator |
1 |
char |
currency .local_currency_ind |
FIELD5 |
credit amount |
999999.99 |
num |
calculated |
FIELD6-22 |
|
|
|
blank |
5. HECS LIABLE COURSES |
||||
CREATION_DT |
date and time of creation of the extract |
DD/MM/YYYY HH24:MI:SS |
date |
system |
FEE_CAL_TYPE |
the fee assessment period for which the extract was run |
10 |
char |
job run parameter |
FEE_CI_SEQUENCE _NUMBER |
6 |
num |
||
PERSON_ID |
the student to which the record refers |
10 |
num |
person.person_id |
COURSE_CD |
in conjunction with person_id, the student course attempt to which this record refers |
6 |
char |
student_course _attempt .course_cd |
MAJOR_SORT_ SEQUENCE |
|
|
|
blank |
FEE_TYPE |
|
|
|
blank |
MINOR_SORT_ SEQUENCE |
|
|
|
blank |
KEY8 |
|
|
|
blank |
KEY9 |
|
|
|
blank |
RECORD_TYPE |
record type |
20 |
char |
'HECS-LIABLE- 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 field3 |
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 field3 |
FIELD9 |
attendance mode |
2 |
char |
student_course_ attempt .attendance_mode as at date in field3 |
FIELD10 |
attendance type |
2 |
char |
student_course_ attempt .attendance_type as at date in field3 |
FIELD11 |
derived attendance mode |
2 |
char |
student_course_ attempt .derived_att_mode as at date in field3 |
FIELD12 |
derived attendance type |
2 |
char |
student_course_ attempt .derived_att_type as at date in field3 |
FIELD13 |
status |
10 |
char |
student_course_ attempt .course_attempt_ status as at date in field3 |
FIELD14 |
commencement date |
DD/MM/YYYY |
date |
student_course_ attempt .commencement_dt as at date in field3 |
FIELD15 |
discontinued date |
DD/MM/YYYY |
date |
student_course_ attempt .discontinued_dt as at date in field3 |
FIELD16 |
fee category |
10 |
char |
student_course_ attempt .fee_cat as at date in field3 |
FIELD17 |
fee category description |
60 |
char |
fee_cat.description as at date in field3 |
FIELD18 |
funding source |
10 |
char |
student_course_ attempt .funding_source as at date in field3 |
FIELD19 |
correspondence category |
10 |
char |
student_course_ attempt .correspondence_cat as at date in field3 |
FIELD20 |
HECS payment option |
10 |
char |
student_course_hecs _option .hecs_payment _option as at census date associated with fee period |
FIELD21 |
differential HECS |
1 |
char |
student_course_hecs _option .differential_hecs_ind as at census date associated with fee period |
FIELD22 |
|
|
|
blank |
6. ASSESSED LIABILITIES |
||||
CREATION_DT |
date and time of creation of the extract |
DD/MM/YYYY HH24:MI:SS |
date |
system |
FEE_CAL_TYPE |
the fee assessment period for which the extract was run |
10 |
char |
job run parameter |
FEE_CI_SEQUENCE _NUMBER |
6 |
num |
||
PERSON_ID |
the student to which the record refers |
10 |
num |
person.person_id |
COURSE_CD |
in conjunction with person_id, the student course attempt to which this record refers |
6 |
char |
student_course_ attempt .course_cd |
MAJOR_SORT_ SEQUENCE |
used to group records according to parent/child relationship of data |
2 |
num |
'06' |
FEE_TYPE |
assessed HECS fee type |
10 |
char |
fee_ass.fee_type |
MINOR_SORT_ SEQUENCE |
|
|
|
blank |
KEY8 |
|
|
|
blank |
KEY9 |
|
|
|
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_type.fee_type |
FIELD4 |
fee type description |
60 |
char |
fee_type.description |
FIELD5 |
fee calendar type |
10 |
char |
cal_instance.cal_type |
FIELD6 |
fee calendar description |
60 |
char |
cal_type.description |
FIELD7 |
fee calendar start date |
DD/MM/YYYY |
date |
cal_instance.start_dt |
FIELD8 |
fee calendar end date |
DD/MM/YYYY |
date |
cal_instance.end_dt |
FIELD9 |
fee assessment period start |
DD/MM/YYYY |
date |
dt_alias_instance_v .alias_val |
FIELD10 |
fee assessment period end |
DD/MM/YYYY |
date |
dt_alias_instance_v .alias_val |
FIELD11 |
system fee type |
10 |
char |
fee_type.s_fee_type |
FIELD12 |
system fee trigger category |
10 |
char |
fee_type .s_fee_trigger_cat |
FIELD13 |
charge method |
10 |
char |
fee_type_cal_instance .s_chg_method_type or fee_cat_fee_liability .s_chg_method_type |
FIELD14 |
last transaction date |
DD/MM/YYYY |
date |
greatest fee_ass.transaction_dt |
FIELD15 |
last effective assessment date |
DD/MM/YYYY |
date |
greatest fee_ass.effective_dt |
FIELD16 |
last notification date |
DD/MM/YYYY |
date |
greatest fee_ass.notification_dt |
FIELD17 |
manual entry |
1 |
char |
Y or N (Y if any manual fee_ass entries exist) |
FIELD18-22 |
|
|
|
blank |
7. HECS-LIABLE-UNITS |
||||
CREATION_DT |
date and time of creation of the extract |
DD/MM/YYYY HH24:MI:SS |
date |
system |
FEE_CAL_TYPE |
the fee assessment period for which the extract was run |
10 |
char |
job run parameter |
FEE_CI_SEQUENCE _NUMBER |
6 |
num |
||
PERSON_ID |
the student to which this record refers |
10 |
num |
person.person_id |
COURSE_CD |
in conjunction with person_id, the student course attempt to which this record refers |
6 |
char |
student_course _attempt .course_cd |
MAJOR_SORT_ SEQUENCE |
used to group records according to parent/child relationship of data |
2 |
num |
'06' |
FEE_TYPE |
assessed HECS fee type |
10 |
char |
fee_ass.fee_type |
MINOR_SORT_ SEQUENCE |
used to group records according to parent/child relationship of data |
2 |
num |
'07' |
KEY8 |
code of contributing unit |
6 |
char |
student_unit_attempt .unit_cd |
KEY9 |
|
|
|
blank |
RECORD_TYPE |
record type |
20 |
char |
'HECS-LIABLE-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_attempt .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 field5 |
FIELD7 |
unit short title |
40 |
char |
unit_version .short_title |
FIELD8 |
teaching period of the student unit attempt |
10 |
char |
student_unit_attempt .cal_type as at date in field5 |
FIELD9 |
6 |
num |
student_unit_attempt .ci_sequence_number as at date in field5 |
|
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 field5 |
FIELD15 |
class |
10 |
char |
student_unit_attempt .unit_class as at date in field5 |
FIELD16 |
status |
10 |
char |
student_unit_attempt .unit_attempt_status as at date in field5 |
FIELD17 |
administrative status |
10 |
char |
student_unit_attempt .administrative_unit _status as at date in field5 |
FIELD18 |
enrolled date |
DD/MM/YYYY |
date |
student_unit_attempt .enrolled_dt as at date in field5 |
FIELD19 |
discontinued date |
DD/MM/YYYY |
date |
student_unit_attempt .discontinued_dt as at date in field5 |
FIELD20 |
EFTSU |
|
num |
calculated |
FIELD21 |
credit points |
|
num |
calculated |
FIELD22 |
liability amount |
999999.99 |
num |
calculated calculated liability for unit. This may differ from the actual debt if there has been a manual adjustment. Refer to TRANSACTION DETAIL & TRANSACTION SUMMARY records. |
8. HECS CONTRIBUTION BANDS |
||||
CREATION_DT |
date and time of creation of the extract |
DD/MM/YYYY HH24:MI:SS |
date |
system |
FEE_CAL_TYPE |
the fee assessment period for which the extract was run |
10 |
char |
job run parameter |
FEE_CI_SEQUENCE _NUMBER |
6 |
num |
||
PERSON_ID |
the student to which the record refers |
10 |
num |
person.person_id |
COURSE_CD |
in conjunction with person_id, the student course attempt to which this record refers |
6 |
char |
student_course_attempt .course_cd |
MAJOR_SORT_ SEQUENCE |
used to group records according to parent/child relationship of data |
2 |
num |
'06' |
FEE_TYPE |
assessed HECS fee type |
10 |
char |
fee_ass.fee_type |
MINOR_SORT_ SEQUENCE |
used to group records according to parent/child relationship of data |
2 |
num |
'07' |
KEY8 |
code of contributing unit |
6 |
char |
student_unit_attempt .unit_cd |
KEY9 |
HECS contribution band |
2 |
num |
govt_dscpln_hecs_cntrbt .govt_hecs_cntrbtn_band |
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_type.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 |
|
|
unit_discipline .discipline_group_cd |
FIELD7 |
percentage |
|
|
unit_discipline .percentage |
FIELD8 |
government discipline group |
|
|
govt_discipline .govt_discipline _group_cd |
FIELD9 |
HECS contribution band |
|
|
govt_dscpln_hecs_cntrbt .govt_hecs_cntrbtn_band |
FIELD10-22 |
|
|
|
blank |
9. TRANSACTION DETAILS |
||||
CREATION_DT |
date and time of creation of the extract |
DD/MM/YYYY HH24:MI:SS |
date |
system |
FEE_CAL_TYPE |
the fee assessment period for which the extract was run |
10 |
char |
job run parameter |
FEE_CI_SEQUENCE _NUMBER |
6 |
num |
||
PERSON_ID |
the student to which the record refers |
10 |
num |
person.person_id |
COURSE_CD |
in conjunction with person_id, the student course attempt to which this record refers |
6 |
char |
student_course_attempt .course_cd |
MAJOR_SORT_ SEQUENCE |
used to group records according to parent/child relationship of data |
2 |
num |
'06' |
FEE_TYPE |
assessed HECS fee type |
10 |
char |
fee_ass.fee_type |
MINOR_SORT_ SEQUENCE |
used to group records according to parent/child relationship of data |
2 |
num |
'07' |
KEY8 |
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 |
KEY9 |
|
|
|
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 |
transaction ID |
6 |
num |
fee_ass.transaction_id Note, payment details only, otherwise blank |
FIELD9 |
sponsored amount |
999999.99 |
num |
sponsored_amount |
FIELD10 |
sponsor code |
10 |
char |
sponsor_cd |
FIELD11 |
sponsorship status |
10 |
char |
stdnt_crs_atmpt_fee _spnsrshp .fee_sponsorship_status OR fee_liability_sponsorship .fee_sponsorship_status |
FIELD12 |
discount percentage |
999.99 |
num |
discount_percentage Note, assessment details only, otherwise blank |
FIELD13 |
discount amount |
999999.99 |
num |
discount_amount Note, assessment details only, otherwise blank |
FIELD14 |
discount minimum payment |
999999.99 |
num |
discount_min_payment Note, assessment details only, otherwise blank |
FIELD15 |
currency |
3 |
char |
currency_cd |
FIELD16 |
exchange rate |
9999.9999 |
num |
exchange_rate |
FIELD17 |
discount available |
9999.9999 |
num |
calculated (assessment details only), else blank |
FIELD18 |
expected payment |
9999.9999 |
num |
calculated (assessment details only), else blank |
FIELD19-22 |
|
|
|
blank |
10. EXTERNAL REFERENCES |
||||
CREATION_DT |
date and time of creation of the extract |
DD/MM/YYYY HH24:MI:SS |
date |
system |
FEE_CAL_TYPE |
the fee assessment period for which the extract was run |
10 |
char |
job run parameter |
FEE_CI_SEQUENCE _NUMBER |
6 |
num |
||
PERSON_ID |
the student to which the record refers |
10 |
num |
person.person_id |
COURSE_CD |
in conjunction with person_id, the student course attempt to which this record refers |
6 |
char |
student_course_attempt .course_cd |
MAJOR_SORT_ SEQUENCE |
used to group records according to parent/child relationship of data |
2 |
num |
'06' |
FEE_TYPE |
assessed HECS fee type |
10 |
char |
fee_ass.fee_type |
MINOR_SORT_ SEQUENCE |
used to group records according to parent/child relationship of data |
2 |
num |
'09' |
KEY8 |
transaction date |
dd/mm/yyyy |
date |
fee_ass.transaction_dt |
KEY9 |
transaction ID |
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_type.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-22 |
|
|
|
blank |
11. TRANSACTION SUMMARY |
||||
CREATION_DT |
date and time of creation of the extract |
DD/MM/YYYY HH24:MI:SS |
date |
system |
FEE_CAL_TYPE |
the fee assessment period for which the extract was run |
10 |
char |
job run parameter |
FEE_CI_SEQUENCE _NUMBER |
6 |
num |
||
PERSON_ID |
the student to which the record refers |
10 |
num |
person.person_id |
COURSE_CD |
in conjunction with person_id, the student course attempt to which this record refers |
6 |
char |
student_course_attempt .course_cd |
MAJOR_SORT_ SEQUENCE |
used to group records according to parent/child relationship of data |
2 |
num |
'06' |
FEE_TYPE |
assessed HECS fee type |
10 |
char |
fee_ass.fee_type |
MINOR_SORT_ SEQUENCE |
used to group records according to parent/child relationship of data |
2 |
num |
'11' |
KEY8 |
|
|
|
blank |
KEY9 |
|
|
|
blank |
RECORD_TYPE |
record type |
20 |
char |
'TRANSACTION- SUMMARY' |
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 |
debt balance |
999999.99 |
num |
calculated |
FIELD5 |
payment balance |
999999.99 |
num |
calculated |
FIELD6 |
discount balance |
999999.99 |
num |
calculated |
FIELD7 |
debt deferred for taxation balance |
999999.99 |
num |
calculated |
FIELD8-22 |
|
|
|
blank |
12. FOOTER (RECORD COUNTS) |
||||
CREATION_DT |
date and time of creation of the extract |
DD/MM/YYYY HH24:MI:SS |
date |
system |
FEE_CAL_TYPE |
the fee assessment period for which the extract was run |
10 |
char |
job run parameter |
FEE_CI_SEQUENCE _NUMBER |
6 |
num |
||
PERSON_ID |
the student to which the record refers |
10 |
num |
'9999999999' |
COURSE_CD |
|
|
|
blank |
MAJOR_SORT_ SEQUENCE |
|
|
|
blank |
FEE_TYPE |
|
|
|
blank |
MINOR_SORT_ SEQUENCE |
|
|
|
blank |
KEY8 |
|
|
|
blank |
KEY9 |
|
|
|
blank |
RECORD_TYPE |
record type |
20 |
char |
'FOOTER' |
FIELD1 |
'PERSON' record count |
6 |
num |
calculated |
FIELD2 |
'ADDRESSES' record count |
6 |
num |
calculated |
FIELD3 |
'SYSTEM- CREDIT' record count |
6 |
num |
calculated |
FIELD4 |
'HECS-LIABLE- COURSES' record count |
6 |
num |
calculated |
FIELD5 |
'ASSESSED- LIABILITIES' record count |
6 |
num |
calculated |
FIELD6 |
'HECS-LIABLE- UNITS' record count |
6 |
num |
calculated |
FIELD7 |
'HECS-CONTRIB- BANDS' record count |
6 |
num |
calculated |
FIELD8 |
'TRANSACTION- DETAILS' record count |
6 |
num |
calculated |
FIELD9 |
'EXTERNAL- REFERENCES' record count |
6 |
num |
calculated |
FIELD10 |
'TRANSACTION- SUMMARY' record count |
6 |
num |
calculated |
FIELD11-22 |
|
|
|
blank |
Last modified on 21 February, 2002.