statement of accnt 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.

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	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	aust 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 indicator	1	char	addr_type .correspondence_ind
FIELD19-27				blank
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	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-27				blank
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	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	aust 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 indicator	1	char	addr_type .correspondence_ind
FIELD15-27				blank
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	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 indicator	1	char	currency .local_currency_ind
FIELD5	opening balance	999999.99	num	calculated
FIELD6-27				blank
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	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 indicator	1	char	currency .local_currency_ind
FIELD5	credit amount	999999.99	num	calculated
FIELD6	unmatched payment	999999.99	num	calculated
FIELD7-27				blank
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	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	20	char	student_course_attempt .course_cd
FIELD3	last effective assessment date	DD/MM/YYYY	date	greatest fee_ass .effective_dt
FIELD4	version	6	num	student_course_attempt .version_number as at date in field 3
FIELD5	title	90	char	course_version.title
FIELD6	short title	40	char	course_version.short_title
FIELD7	course type	10	char	course_version.course_type
FIELD8	location	10	char	student_course_attempt .location_cd as at date in field 3
FIELD9	attendance mode	2	char	student_course_attempt .attendance_mode as at date in field 3
FIELD10	attendance type	2	char	student_course_attempt .attendance_type as at date in field 3
FIELD11	derived attendance mode	2	char	student_course_attempt .derived_att_mode as at date in field 3
FIELD12	derived attendance type	2	char	student_course_attempt .derived_att_type as at date in field 3
FIELD13	status	10	char	student_course_attempt .course_attempt_status as at date in field 3
FIELD14	commencement date	DD/MM/YYYY	date	student_course_attempt .commencement_dt as at date in field 3
FIELD15	discontinued date	DD/MM/YYYY	date	student_course_attempt .discontinued_dt as at date in field 3
FIELD16	fee category	10	char	student_course_attempt .fee_cat as at date in field 3
FIELD17	fee category description	60	char	fee_cat.description as at date in field 3
FIELD18	funding source	10	char	student_course_attempt .funding_source as at date in field 3
FIELD19	correspondence category	10	char	student_course_attempt .correspondence_cat as at date in field 3
FIELD20	differential HECS	1	char	student_course_hecs_option .differential_hecs_ind as at the census date associated with the fee period
FIELD21	HECS payment option	10	char	student_course_hecs_option .hecs_payment_option as at the census date associated with the fee period
FIELD22	sector	10	char	course_version.s_sector_cd
FIELD23-27				blank
7. NON 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	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	'NON ASSESSED COURSES'
FIELD1	person ID	10	num	person.person_id
FIELD2	course code	20	char	student_course_attempt.course_cd
FIELD3	effective date	DD/MM/YYY	date	fee_ass_debt_v.last_effective_assessment_dt
FIELD4	version	6	num	student_course_attempt.version_number
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
FIELD9	attendance mode	2	char	student_course_attempt.attendance_mode
FIELD10	attendance type	2	char	student_course_attempt.attendance_type
FIELD11	derived attendance mode	2	char	student_course_attempt.derived_att_mode
FIELD12	derived attendance type	2	char	student_course_attempt.derived_att_type
FIELD13	status	10	char	student_course_attempt.course_attempt_status
FIELD14	commencement date	DD/MM/YYYY	date	student_course_attempt.commencement_dt
FIELD15	discontinued date	DD/MM/YYYY	date	student_course_attempt.discontinued_dt
FIELD16	fee category	10	char	student_course_attempt.fee_cat
FIELD17	fee category description	60	char	fee_cat.description
FIELD18	funding source	10	char	student_course_attempt.funding_source
FIELD19	correspondence category	10	char	student_course_attempt.correspondence_cat
FIELD20	differential HECS	1	char	student_course_hecs_option.differential_hecs_ind
FIELD21	HECS payment option	10	char	student_course_hecs_option.hecs_payment_option
FIELD22	sector	10	char	course_version.s_sector_cd
8. 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	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	20	char	*student_course_attempt .course_cd*
FIELD3	unit set code	10	char	student_unit_set_attempt .unit_set_cd
FIELD4	version number	6	num	student_unit_set_attempt .us_version_number
FIELD5	title	90	char	unit_set.title
FIELD6	short title	40	char	unit_set.short_title
FIELD7	override title	90	char	student_unit_set_attempt .override_title
FIELD8	unit set category	10	char	unit_set.unit_set_cat
FIELD9	unit set category description	60	char	unit_set_cat.description
FIELD10	rank	3	num	unit_set_cat.rank
FIELD11	primary set	1	char	student_unit_set_attempt .primary_set_ind
FIELD12	selection date	DD/MM/YYYY	date	student_unit_set_attempt .selection_dt
FIELD13	end date	DD/MM/YYYY	date	student_unit_set_attempt .end_dt
FIELD14	requirements complete date	DD/MM/YYYY	date	student_unit_set_attempt .rqrmnts_complete_dt
FIELD15-27				blank
9. NON ASSESSED 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	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	'NON ASSESSED UNIT SETS'
FIELD1	person ID	10	num	person.person_id
FIELD2	course code	20	char	student_course_attempt.course_cd
FIELD3
FIELD4	unit set code	10	char	student_unit_set_attempt.unit_set_cd
FIELD5	version number	6	num	student_unit_set_attempt.us_version_number
FIELD6	title	90	char	unit_set.title
FIELD7	short title	40	char	unit_set.short.title
FIELD8	override title	90	char	student_unit_set_attempt.override_title
FIELD9	unit set category	10	char	unit_set.unit_set_cat
FIELD10	unit set category description	60	char	unit_set_cat.description
FIELD11	rank	3	num	unit_set_cat.rank
FIELD12	primary set	1	char	student_unit_set_attempt.primary_set_ind
FIELD13	selection date	DD/MM/YYYY	date	student_unit_set_attempt.selection.dt
FIELD14	end date	DD/MM/YYYY	date	student_unit_set_attempt.end_dt
FIELD15	requirements complete date	DD/MM/YYYY	date	student_unit_set_attempt.rqrmnts_complete_dt
10. 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	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	20	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 indicator	1	char	fee_type .optional_payment_ind
FIELD15	charge method	10	char	fee_type_cal_instance .s_chg_method_type / fee_cat_fee_liability .s_chg_method_type
FIELD16	last transaction date	DD/MM/YYYY	date	greatest fee_ass .transaction_dt
FIELD17	last effective assessment date	DD/MM/YYYY	date	greatest fee_ass .effective_dt
FIELD18	last notification date	DD/MM/YYYY	date	greatest fee_ass .notification_dt
FIELD19	retained debt amount	9999999.999	num	calculated
FIELD20	manual entry	1	char	Y or N (Y if any manual fee assessment entries exist)
FIELD21	payment overdue	1	char	calculated (Y/N) (Y if overdue)
FIELD22-27				blank
11. 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	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	20	char	*student_course_attempt .course_cd*
FIELD3	fee type	10	char	*fee_type.fee_type*
FIELD4	unit code	10	char	student_unit_attemp .unit_cd
FIELD5	last effective assessment date	DD/MM/YYYY	date	greatest fee_ass .effective_dt
FIELD6	version number	6	num	student_unit_attempt .version_number as at date in field 5
FIELD7	unit short title	40	char	unit_version.short_title
FIELD8	teaching period	10	char	student_unit_attempt .cal_type as at date in field 5
FIELD9	teaching period	6	num	student_unit_attempt .ci_sequence_number as at date in field 5
FIELD10	teaching calendar description	60	char	cal_type.description
FIELD11	teaching calendar start date	DD/MM/YYYY	date	cal_instance.start_dt
FIELD12	teaching calendar end date	DD/MM/YYYY	date	cal_instance.end_dt
FIELD13	teaching period code	10	char	cal_instance .alternate_code
FIELD14	location	10	char	student_unit_attempt .location_cd as at date in field 5
FIELD15	class	10	char	student_unit_attempt .unit_class as at date in field 5
FIELD16	status	10	char	student_unit_attempt .unit_attempt_status as at date in field 5
FIELD17	administrative status	10	char	student_unit_attempt .administrative_ unit_status as at date in field 5
FIELD18	enrolled date	DD/MM/YYYY	date	student_unit_attempt .enrolled_dt as at date in field 5
FIELD19	discontinued date	DD/MM/YYYY	date	student_unit_attempt .discontinued_dt as at date in field 5
FIELD20	EFTSU	9999999.999	num	calculated
FIELD21	credit points	9999999.999	num	calculated
FIELD22	contact hours		num	calculated
FIELD23-27				blank
12. NON 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	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	used to group records according to parent/child relationship of data	2	num	'07'
KEY7
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	'NON ASSESSED UNITS'
FIELD1	person ID	10	num	person.person_id
FIELD2	course code	20	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	effective date	DD/MM/YYYY	date	fee_ass_debt_v.last_effective_assessment_dt
FIELD6	version number	6	num	student_unit_attempt.version_number
FIELD7	unit short title	40	char	unit_version.short_title
FIELD8	teaching calendar type	10	char	cal_instance.cal_type
FIELD9	teaching calendar description	60	char	cal_type.description
FIELD10	teaching calendar start date	DD/MM/YYYY	date	cal_instance.start_dt
FIELD11	teaching calendar end date	DD/MM/YYYY	date	cal_instance.end_dt
FIELD12	teaching period	10	char	cal_instance.alternative_code
FIELD13	location	10	char	student_unit_attempt.location_cd
FIELD14	class	10	char	student_unit_attempt.unit_class
FIELD15	status	10	char	student_unit_attempt.unit_attempt_status
FIELD16	administrative status	10	char	student_unit_attempt.administrative_unit_status
FIELD17	enrolled date	DD/MM/YYYY	char	student_unit_attempt.enrolled_dt
FIELD18	discontinued date	DD/MM/YYYY	char	student_unit_attempt.discontinued_dt
FIELD19	EFTSU		num	calculated
FIELD20	credit points		num	calculated
FIELD21	contact hours		num	calculated
13. HECS CONTRIBUTION BANDS
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 HECS 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 HECS record relates	10	char	student_unit_attempt .unit_cd
KEY10	the discipline group on which HECS band was determined	4	char	discipline .govt_discipline_group_cd
RECORD_TYPE	record type	20	char	'HECS-CONTRIB-BANDS'
FIELD1	person ID	10	num	*person.person_id*
FIELD2	course code	20	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	HECS contribution band	2	num	govt_dscpln_hecs_cntrbt .govt_hecs_cntrbtn_band
FIELD10-27				blank
14. TRANSACTION DETAILS
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	20	char	*student_course_attempt .course_cd*
FIELD3	fee type	10	char	*fee_type.fee_type*
FIELD4	transaction category	10	char	s_transaction_type .transaction_cat
FIELD5	transaction type	10	char	fee_ass.s_transaction_type
FIELD6	transaction date	DD/MM/YYYY	date	If transaction category is PAYMENT, fee_ass.effective_dt OR if transaction category is DEBT, person_payment_schedule .payment_due_dt
FIELD7	transaction amount	999999.99	num	If transaction category is PAYMENT, fee_ass.transaction_amount OR if transaction category is DEBT, person_payment_schedule .payment_amount_due
FIELD8	tax amount	999999.99	num	If transaction category is PAYMENT, calculated 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 indicator	1	char	if expected amount for student has been limited by the student_ crs_hecs_opt_override. maximum_payment_ limit = Y otherwise N
FIELD25	student expected amount	999999.99	num	calculated amount
FIELD26	sponsor expected amount	999999.99	num	calculated amount
FIELD27	loan scheme expected amount	999999.99	num	calculated amount
15. 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	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	20	char	*student_course_attempt .course_cd*
FIELD3	fee type	10	char	*fee_ass.fee_type*
FIELD4	transaction ID	6	num	*fee_ass.transaction_id*
FIELD5	external reference code	10	char	fee_ass_external_ref .external_reference_cd
FIELD6	external reference type	10	char	fee_ass_external_ref .external_reference_type
FIELD7	external reference type description	60	char	external_reference_type .description
FIELD8-27				blank
16. 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	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	20	char	*student_course_attempt .course_cd*
FIELD3	fee type	10	char	*fee_ass.fee_type*
FIELD4	fee encumbrance date	DD/MM/YYYY	date	*pending_fee_encumbrance .fee_encumbrance_dt*
FIELD5	encumbrance type	10	char	*pending_fee_encumbrance .s_encumbrance_type*
FIELD6	encumbrance type description	60	char	encumbrance_type .description
FIELD7	status	10	char	pending_fee_encumbrance .pending_fee_encmb_status
FIELD8	system status	10	char	pending_fee_encmb_status .s_pending_fee_encmb_status
FIELD9	status description	60	char	pending_fee_encmb_status .description
FIELD10	encumbrance category	10	char	encumbrance_type .s_encumbrance_cat
FIELD11	start date	DD/MM/YYYY	date	person_encumbrance .start_date, else blank
FIELD12	expiry date	DD/MM/YYYY	date	person_encumbrance .expiry_date, else blank
FIELD13	comment	2000	char	pending_fee_encumbrance .comments, else encumbrance_type.comments
FIELD14-27				blank
17. 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	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	20	char	*student_course_attempt .course_cd*
FIELD3	fee type	10	char	*fee_ass.fee_type*
FIELD4	fee encumbrance date	DD/MM/YYYY	date	*pending_fee_encumbrance .fee_encumbrance_dt, else date on which encumbrance will be applied*
FIELD5	encumbrance type	10	char	*pending_fee_encumbrance .encumbrance_type*
FIELD6	encumbrance effect type	10	char	*encmb_type_dflt_effect .s_encmb_effect_type, else person_encumbrance_effect .s_encmb_effect_type*
FIELD7	start date	DD/MM/YYYY	date	person_encumbrance_effect .pee_start_dt, else blank
FIELD8	expiry date	DD/MM/YYYY	date	person_encumbrance_effect .expiry_dt, else blank
FIELD9-27				blank
18. ADVANCED STANDING
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	'ADVANCED STANDING'
FIELD1	person ID	10	num	person.person_id
FIELD2	course code	20	char	ctudent_course_attempt.course_code
FIELD3	advanced standing unit	20	char	adv_stnd_unit.unit_cd
FIELD4	advanced standing unit level	1	char	adv_stnd_unit_level.unit_level
FIELD5	credit points		num	adv_stnd_unit.credit_points / adv_stnd_unit_level.credit_points
FIELD6	contact hours		num	adv_stnd_unit.contact_hrs / adv_stnd_unit_level.contact_hrs
FIELD7	approved date	DD/MM/YYYY	date	adv_stnd_unit.approved_dt / adv_stnd_unit_level.approved_dt
FIELD8	granted date	DD/MM/YYYY	date	adv_stnd_unit.granted_dt / adv_stnd_unit_level.granted_dt
FIELD9	advanced standing source	10	char	advanced_standing_source.advanced_standing_source
FIELD10	advanced standing source description	60	char	advanced_standing_source.description
FIELD11	granting status	10	char	adv_stnd_unit.s_adv_stnd_granting_status / adv_stnd_unit_levels.s_adv_stnd_granting_status
19. 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	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 HECS-CONTRIB-BANDS	6	num	calculated
FIELD9	count of record type TRANSACTION-DETAILS	6	num	calculated
FIELD10	count of record type EXTERNAL-REFERENCES	6	num	calculated
FIELD11	count of record type FEE-ENCUMBRANCES	6	num	calculated
FIELD12	count of record type ENCUMBRANCE-EFFECTS	6	num	calculated
FIELD13	count of record type OPENING BALANCE	6	num	calculated
FIELD14-27				blank

Updated 13 February 2003

Statement of Account Extract - View Details

Statement of Account Extract View Details

Statement of Account Record View Details

ACC_STMNT_RECORD_V