Statement of Account Extract

Statement of Account Extract - View Details

Statement of Account Extract View Details - This view presents information about each individual instance on which the Statement of Account Extract (FINJ6120) and the Reminder Notice Extract (FINJ6121) creation processes are run. Student and student finance records relating to an individual run instance are presented in the Statement of Account Record view.
Statement of Account Record View Details - This view presents statement of account records. Each record is for a particular Student Course Attempt.

Statement of Account Extract View Details

The table shows details of the fields presented by this view.

ACC_STMNT_EXTRACT_V
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	Job run parameter
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	Job run parameter
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 (HECS Contribution Bands)
11. Transaction Details
12. External References
13. Fee Encumbrances
14. Encumbrance Effects
15. Fee Capping Details
16. 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.
1. HEADER
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	The financial Period for which the Extract was run	6	num	Job run parameter
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
2. PERSON
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	The financial Period for which the Extract was run	6	num	Job run parameter
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	Name Format Code	10	char	person.name_format_cd
FIELD9-30				blank
3. ADDRESS
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	The financial Period for which the Extract was run	6	num	Job run parameter
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
4. OPENING BALANCE
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	The financial Period for which the Extract was run	6	num	Job run parameter
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
5. SYSTEM CREDIT
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	The financial Period for which the Extract was run	6	num	Job run parameter
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
6. ASSESSED COURSES
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	The financial Period for which the Extract was run	6	num	Job run parameter
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
7. UNIT SETS
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	The financial Period for which the Extract was run	6	num	Job run parameter
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
8. ASSESSED LIABILITIES
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	The financial Period for which the Extract was run	6	num	Job run parameter
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	Fee Assessment Period	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
9. ASSESSED UNITS
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	The financial Period for which the Extract was run	6	num	Job run parameter
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	Teaching Period	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	9999	num	calculated
FIELD23	Unit Student Status	10	char	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	1	char	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	Unit Offering Option ID	7	num	STUDENT_UNIT_ATTEMPT.UOO_ID
FIELD26-30				blank
10. DISCIPLINE BAND (HECS Contribution Band)
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	The financial Period for which the Extract was run	6	num	Job run parameter
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-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	Student Contribution Band	2	num	govt_dscpln_hecs_cntrbt.govt_hecs_cntrbtn_band
FIELD10-30				blank
11. TRANSACTION DETAILS Note: This Record Type does not differentiate between different types of debt.
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	The financial Period for which the Extract was run	6	num	Job run parameter
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.
FIELD30	Unit Offering Option ID	7	num	These fields are only applicable when the Fee Type is managed at the UNIT level.
12. EXTERNAL REFERENCES
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	The financial Period for which the Extract was run	6	num	Job run parameter
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	7	num	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
13. FEE ENCUMBRANCES
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	The financial Period for which the Extract was run	6	num	Job run parameter
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
14. ENCUMBRANCE EFFECTS
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	The financial Period for which the Extract was run	6	num	Job run parameter
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
15. FEE-CAP-DETAILS
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	The financial Period for which the Extract was run	6	num	Job run parameter
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.effect_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	20	char	student_unit_attempt.unit_cd
KEY10				blank
RECORD_TYPE	Record Type	20	char	'FEE-CAP-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	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 FIELD5)
FIELD7	Unit Short Title	40	char	unit_version.short_title
FIELD8	Uoo_id	7	num	The unit offering option ID of the unit
FIELD9	Unit Enrolment Activity Start Date	DD/MM/YYYY	date	From in order of preference: Student_unit_Attempt Unit_offering_option Unit_offering_pattern Unit_offering System enrolment Calendar config UOO teaching period start date
FIELD10	Concession Type	10	char	The person concession applicable on the unit enrolment activity start date. i.e. where the person concession exists on the unit start date and a fee type fee cap concession override exists for the units fee cap period.
FIELD11	Concession Explanation	3000	char	The first 3000 characters of Concession_type.explanation. SUBSTR(Concession_type.explanantion, 1, 3000) Note: The text field in the extract tables only stores a maximum of 4000 chracters, so it was decided to limit the extracted explanation to 3000 characters.
FIELD12	Concession Description	60	char	Concession_type.description
FIELD13	Government Concession Type	1	char	Concession_type.govt_concession_type
FIELD14	Concession Start Date	DD/MM/YYYY	date	Person_concession.start_dt
FIELD15	Concession End Date	DD/MM/YYYY	date	Person_concession.end_dt
FIELD16	Cap Minimum	999999.99	num	Derived. Fee type group fee cap minimum charge if a record is found that matches the student course and unit attributes. Otherwise the Fee Type Group Cal Instance Minimum Charge.
FIELD17	Cap Maximum	999999.99	num	Derived. Fee type group fee cap maximum charge if a record is found that matches the student course and unit attributes. Otherwise the Fee Type Group Cal Instance maximum Charge.
FIELD18	Fee cap cal type	10	char	The fee_type_group_cal_instance.cal_type for the unit_enrolment_activity_start_dt and fee type.
FIELD19	Fee cap ci_sequence_number	999999	num	The fee_type_group_cal_instance.ci_Sequence_number for the unit_enrolment_activity_start_dt and fee type.
FIELD20	Fee cap Start Date	DD/MM/YYYY	date	The start date of the fee cap period.
FIELD21	Fee cap end date	DD/MM/YYYY	date	The end date of the fee cap period.
FIELD22	Raw Assessment	999999.99	num	Sum of the transactions of category debt for the unit excluding Capping transactions.
FIELD23	Capping amount	999999.99	num	The sum of the capping transactions for the unit.
FIELD24	Fee Type Group code	10	char	Fee_type_group.Fee_type_group_code
FIELD25	Default Course Category	10	char	The Course Offering Instance default course category or the Course Catergorisation default course category.
FIELD26	Course Funding Source	10	char	Student_Course_Attempt.funding_Source
FIELD27	Apprenticeship Indicator	1	char	The apprenticeship indicator on the student course attempt funding source.
FIELD28	Fee Maintenance Indicator	1	char	Student_course_attempt.fee_maintenance_ind
FIELD29	Overall Minimum Assessment	999999.99	num	Fee_type_group_cal_instance.minimum_charge
FIELD30	Overall Maximum Assessment	999999.99	num	Fee_type_group_cal_instance.maximum_charge
16. FOOTER (RECORD COUNTS)
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	The financial Period for which the Extract was run	6	num	Job run parameter
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

Last Modified on 02-Nov-2010 10:35 AM

History Information

Release Version	Project	Change to Document
12.0.0.2	1617 - VU - SV-FEE-HELP (Release 2)	Added new fields to FEE-CAP-DETAILS for Fee Type Groups
12.1	1636 - Callista Wiki	Merged VET help file content into this page
12.0.0.2.0.0	1540 - VU Development - Fees	Added FEE-CAP-DETAILS record type and added UOO ID to ASSESSED-UNIT record type
11.0.0.0.0.0	1353 - International Name	Added Student's Name Format Code to PERSON section of ACC_STMNT_RECORD_V

ACC_STMNT_EXTRACT_V

ACC_STMNT_RECORD_V