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 |
1.
HEADER |
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-30 |
|
|
|
blank |
Field
Name |
Field
Description |
Max
Length |
Type |
Source
/ Value |
2.
PERSON |
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-30 |
|
|
|
blank |
Field
Name |
Field
Description |
Max
Length |
Type |
Source
/ Value |
3.
ADDRESSES |
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-30 |
|
|
|
blank |
Field
Name |
Field
Description |
Max
Length |
Type |
Source
/ Value |
4.
OPENING BALANCE |
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
The opening balance will not include amounts which have been paid (or
are expected to be paid) by a Loan Scheme Sponsor. It will only report
the outstanding debt for the student.
For example, if an outstanding debt exists for $1000 and the Loan Scheme
is paying $800, then the student’s opening balance will be reported as
$200
|
FIELD6-30 |
|
|
|
blank |
Field
Name |
Field
Description |
Max
Length |
Type |
Source
/ Value |
5.
SYSTEM CREDIT |
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-30 |
|
|
|
blank |
Field
Name |
Field
Description |
Max
Length |
Type |
Source
/ Value |
6.
ASSESSED COURSES |
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 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 |
Differential
HECS |
1 |
char |
student_course_hecs_option.differential_hecs_ind
(as at the Census Date associated with the Fee Period) No longer applicable
from 2005. Remains to run retrospective extracts. |
FIELD21 |
Student
Status |
10 |
char |
student_course_hecs_option.hecs_payment_option
(as at the Census Date associated with the Fee Period) No longer applicable
from 2005. Remains to run retrospective extracts. |
FIELD22-30 |
|
|
|
blank |
Field
Name |
Field
Description |
Max
Length |
Type |
Source
/ Value |
7.
UNIT SETS |
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-30 |
|
|
|
blank |
Field
Name |
Field
Description |
Max
Length |
Type |
Source
/ Value |
8.
ASSESSED LIABILITIES |
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 (The greatest Transaction Date for the units contributing
to the Fee Type is reported) |
FIELD17 |
Last
Effective Assessment Date |
DD/MM/YYYY |
date |
greatest
fee_ass.effective_dt (The greatest Effective Date for the units contributing
to the Fee Type is reported) |
FIELD18 |
Last
Notification Date |
DD/MM/YYYY |
date |
greatest
fee_ass.notification_dt (The greatest Notification Date for the units
contributing to the Fee Type is reported) |
FIELD19 |
Retained
Debt Amount |
9999999.999 |
num |
calculated.
If the Fee Type is managed at the UNIT level, retention is calculated
and stored at the unit level. The value here is the total retained amount
for the Fee Type. If the Fee Type is managed at the COURSE level then
existing logic remains. |
FIELD20 |
Manual
Entry |
1 |
char |
Y
or N (Y if any manual fee assessment entries exist) If the Fee Type is
managed at the UNIT level, then manual entries will be in context of a
unit. When this is the case, this check box is set to ‘Y’ if any manual
Fee Assessments exist for the Fee Type. If the Fee Type is managed at
the COURSE level then existing logic remains. |
FIELD21 |
Payment
Overdue |
1 |
char |
calculated
(Y/N) (Y if overdue) If the Fee Type is managed at the UNIT level then
there is the potential for individual units to have different Due Dates.
This check box is set to ‘Y’ if the Due Date for any of the units has
passed. If the Fee Type is managed at the COURSE level then existing logic
remains. |
FIELD22 |
Fee
Contract Type |
10 |
char |
fee_contract_type.fee_contract_type |
FIELD23 |
Contract
Start Date |
DD/MM/YYYY |
date |
contract_fee_ass_rate.start_dt |
FIELD24 |
Contract
End Date |
DD/MM/YYYY |
date |
contract_fee_ass_rate.end_dt |
FIELD25 |
Contract
Creation Type |
10 |
char |
contract_fee_ass_rate.creation_type |
FIELD26 |
Variable
Rate check box |
1 |
char |
fee_contract_type.variable_rate_ind |
FIELD27 |
Manual
Override check box |
1 |
char |
contract_fee_ass_rate.manual_ovrd_ind |
FIELD28 |
Percentage
Variation |
999.99 |
num |
derived |
FIELD29 |
Charge
Rate |
999999.99
|
num
|
derived |
FIELD30 |
|
|
|
blank |
Field
Name |
Field
Description |
Max
Length |
Type |
Source
/ Value |
9.
ASSESSED UNITS |
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 If the Fee Type is managed at the UNIT level the
last Effective Assessment Date for the unit then is reported. If the Fee
Type is managed at the COURSE level then existing logic remains. |
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 |
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 |
EFTSL |
9999999.999 |
num |
calculated |
FIELD21 |
Credit
Points |
9999999.999 |
num |
calculated |
FIELD22 |
Contact
Hours |
|
|
calculated |
FIELD23 |
Unit
Student Status |
|
|
If
an override exists at the Student Unit Attempt level then that value is
used, otherwise, the Student Status defined at the Course Attempt level
is used (as at the Census Date for the Unit Teaching Period). |
FIELD24 |
Differential
HECS |
|
|
student_course_hecs_option.differential_hecs_ind
As at the Census Date associated with the Unit Teaching Period. This check
box is recorded for a course (student_course_hecs_option). It is reported
for each unit and the Unit Teaching Period Census Date is used instead of
the Census Date associate with the Fee Period. |
FIELD25-30 |
|
|
|
blank |
Field
Name |
Field
Description |
Max
Length |
Type |
Source
/ Value |
10.
DISCIPLINE BAND (HECS Contribution Band) |
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 Status 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 Commonwealth Supported Place 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 |
'DISCIPLINE-BAND' |
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 |
Student
Contribution Band |
2 |
num |
govt_dscpln_hecs_cntrbt.govt_hecs_cntrbtn_band |
FIELD10-30 |
|
|
|
blank |
Field
Name |
Field
Description |
Max
Length |
Type |
Source
/ Value |
11.
TRANSACTION DETAILS
Note:
This Record Type does not differentiate between different types of debt. |
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
NOTE
The Transaction Details record type does not differentiate between
different types of debt. This field will only return a value of
ASSESSMENT or PAYMENT |
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
OR if transaction category is DEBT, person_payment_schedule.tax_amount |
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. Maximum payment limit is now in the context of a unit. |
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 |
FIELD28 |
Loan
Scheme Discount Expected Amount |
|
|
Person_payment_schedule.loan_discount_amount |
FIELD29 |
Unit
Code |
20 |
char |
These
fields are only applicable when the Fee Type is managed at the UNIT level.
When the Fee Type is managed at the COURSE level the existing logic remains. |
FIELD30 |
Unit
Offering Option ID |
|
|
These
fields are only applicable when the Fee Type is managed at the UNIT level.
When the Fee Type is managed at the COURSE level the existing logic remains |
Field
Name |
Field
Description |
Max
Length |
Type |
Source
/ Value |
12.
EXTERNAL REFERENCES |
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 |
Unit
Code |
20 |
char |
These
fields are only applicable when the Fee Type is managed at the UNIT level.
When the Fee Type is managed at the COURSE level the existing logic remains. |
FIELD9 |
Unit
Offering Option ID |
|
|
These
fields are only applicable when the Fee Type is managed at the UNIT level.
When the Fee Type is managed at the COURSE level the existing logic remains. |
FIELD10-30 |
|
|
|
blank |
Field
Name |
Field
Description |
Max
Length |
Type |
Source
/ Value |
13.
FEE ENCUMBRANCES |
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
Encumbrances may now be triggered by units where the Fee Type is managed
at the UNIT level, however, the Encumbrance is still recorded at the Course. |
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-30 |
|
|
|
blank |
Field
Name |
Field
Description |
Max
Length |
Type |
Source
/ Value |
14.
ENCUMBRANCE EFFECTS |
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
Encumbrances may now be triggered by units where the Fee Type is managed
at the UNIT level, however, the Encumbrance is still recorded at the Course.
|
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-30 |
|
|
|
blank |
Field
Name |
Field
Description |
Max
Length |
Type |
Source
/ Value |
15.
FOOTER (RECORD COUNTS) |
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 DISCIPLINE BAND |
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-30 |
|
|
|
blank |