HECS Notice of Liability Extract - View Details


HECS Liability Extract View Details

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

HECS_LBLTY_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 (num(10))

CORRESPONDENCE_TYPE

the type of correspondence created by the job run

job run parameter (char(10)

FEE_CAL_TYPE

the calendar type of the fee period for which the job was run

job run parameter

(char(10)

(num(6))

FEE_CI_SEQUENCE_NUMBER

the calendar instance sequence number of the fee period for which the job was run

FEE_TYPE

fee type

job run parameter (char(10))

FEE_CAT

fee category

job run parameter (char(10))

COURSE_CD

course code

job run parameter (char(6))

PERSON_ID

individual person ID number

job run parameter (num(10))

PERSON_GROUP_ID

the code of a person ID group

job run parameter (num(6))

INSTITUTION_CD

institution code

job run parameter (char(10))

ADDR_TYPE

institution address type

job run parameter (char(10))

DATE_OF_ISSUE

planned date of issue of HECS Liability Notices

job run parameter (dd/mm/yyyy)

EXTRACT_COMMENT

comments for inclusion on all HECS Liability Notices

job run parameter (up to char(60))

TEST_EXTRACTION

indicates whether or not FINJ6190 was run as a test extraction only.

job run parameter (Y or N)

REQUEST_JOB_RUN_ID

system generated ID number of the request job run

passed by job scheduler (num(10))

REQUEST_NUM

system generated number of the request in which the job was run

derived from request job run ID (num(9))

UPDATE_WHO

 audit detail of person who created the extract

system (up to char(30))

UPDATE_ON

 audit detail of when the extract was created

system (dd/mm/yyy hh24:mi:ss)

  


HECS Liability Record View Details

The table provides details of the different record types presented by this view and the fields in each record type.

HECS_LBLTY_RECORD_V

NOTE:

All references to source database tables and columns are in italics.
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

FEE_CAL_TYPE

the fee assessment period for which the extract was run

10

char

job run parameter

FEE_CI_SEQUENCE _NUMBER

6

num

PERSON_ID

the student to which this record refers

10

num

'0000000000'

COURSE_CD

 

 

 

blank

MAJOR_SORT_ SEQUENCE

 

 

 

blank

FEE_TYPE

 

 

 

blank

MINOR_SORT_ SEQUENCE

 

 

 

blank

KEY8

 

 

 

blank

KEY9

 

 

 

blank

RECORD_TYPE

record type

20

char

'HEADER'

FIELD1

comment

60

char

parameter

FIELD2

fee calendar type

10

char

cal_instance.cal_type

FIELD3

fee calendar description

60

char

cal_type.description

FIELD4

fee calendar start date

DD/MM/YYYY

date

cal_instance.start_dt

FIELD5

fee calendar end date

DD/MM/YYYY

date

cal_instance.end_dt

FIELD6

address type

10

char

institution_addr .addr_type

FIELD7

address line 1

40

char

institution_addr .addr_line_1

FIELD8

address line 2

40

char

institution_addr .addr_line_2

FIELD9

address line 3

40

char

institution_addr .addr_line_3

FIELD10

address line 4

40

char

institution_addr .addr_line_4

FIELD11

address line 5

40

char

institution_addr .addr_line_5

FIELD12

Australian postcode

4

num

institution_addr .aust_postcode

FIELD13

overseas postal code

10

char

institution_addr .os_code

FIELD14

phone 1

20

char

institution_addr .phone_1

FIELD15

phone 2

20

char

institution_addr .phone_2

FIELD16

phone 3

20

char

institution_addr .phone_3

FIELD17

other details

40

char

institution_addr .other_details

FIELD18

correspondence indicator

1

char

addr_type .correspondence_ind

FIELD19-22

 

 

 

blank

2. PERSON

CREATION_DT

date and time of creation of the extract

DD/MM/YYYY HH24:MI:SS

date

system

FEE_CAL_TYPE

the fee assessment period for which the extract was run

10

char

job run parameter

FEE_CI_SEQUENCE _NUMBER

6

num

PERSON_ID

the student to which the record refers

10

num

person.person_id

COURSE_CD

 

 

 

blank

MAJOR_SORT_ SEQUENCE

 

 

 

blank

FEE_TYPE

 

 

 

blank

MINOR_SORT_ SEQUENCE

 

 

 

blank

KEY8

 

 

 

blank

KEY9

 

 

 

blank

RECORD_TYPE

record type

20

char

'PERSON'

FIELD1

person ID

10

num

person.person_id

FIELD2

title

10

char

person.title

FIELD3

surname

30

char

person.surname

FIELD4

given names

40

char

person.given_names

FIELD5

payment advice number

20

char

alternate_person_id .api_person_id

FIELD6

date of issue

DD/MM/YYYY

date

outgoing _correspondence .issue_dt

FIELD7

last notice date

DD/MM/YYYY

date

correspondence_item .create_dt

FIELD8-22

 

 

 

blank

3. ADDRESSES

CREATION_DT

date and time of creation of the extract

DD/MM/YYYY HH24:MI:SS

date

system

FEE_CAL_TYPE

the fee assessment period for which the extract was run

10

char

job run parameter

FEE_CI_SEQUENCE _NUMBER

6

num

PERSON_ID

the student to which the record refers

10

num

person.person_id

COURSE_CD

 

 

 

blank

MAJOR_SORT_ SEQUENCE

 

 

 

blank

FEE_TYPE

 

 

 

blank

MINOR_SORT_ SEQUENCE

 

 

 

blank

KEY8

 

 

 

blank

KEY9

 

 

 

blank

RECORD_TYPE

record type

20

char

'ADDRESSES'

FIELD1

person ID

10

num

person.person_id

FIELD2

address type

10

char

person_addr .addr_type

FIELD3

address line 1

40

char

person_addr .addr_line_1

FIELD4

address line 2

40

char

person_addr .addr_line_2

FIELD5

address line 3

40

char

person_addr .addr_line_3

FIELD6

address line 4

40

char

person_addr .addr_line_4

FIELD7

address line 5

40

char

person_addr .addr_line_5

FIELD8

Australian postcode

4

num

person_addr .aust_postcode

FIELD9

overseas postal code

10

char

person_addr .os_code

FIELD10

phone 1

20

char

person_addr .phone_1

FIELD11

phone 2

20

char

person_addr .phone_2

FIELD12

phone 3

20

char

person_addr .phone_3

FIELD13

other details

40

char

person_addr .other_details

FIELD14

correspondence indicator

1

char

addr_type .correspondence_ind

FIELD15-22

 

 

 

blank

4. SYSTEM CREDIT

CREATION_DT

date and time of creation of the extract

DD/MM/YYYY HH24:MI:SS

date

system

FEE_CAL_TYPE

the fee assessment period for which the extract was run

10

char

job run parameter

FEE_CI_SEQUENCE _NUMBER

6

num

PERSON_ID

the student to which the record refers

10

num

person. .person_id

COURSE_CD

 

 

 

blank

MAJOR_SORT_ SEQUENCE

 

 

 

blank

FEE_TYPE

 

 

 

blank

MINOR_SORT_ SEQUENCE

 

 

 

 blank

KEY8

 currency of the credit

 3

char

currency.currency_cd

KEY9

 

 

 

blank

RECORD_TYPE

record type

20

char

'SYSTEM-CREDIT

FIELD1

person ID

10

num

person.person_id

FIELD2

curency code

3

char

derived

FIELD3

currency description

60

char

currency.description

FIELD4

local currency indicator

1

char

currency .local_currency_ind

FIELD5

credit amount

999999.99

num

calculated

FIELD6-22

 

 

 

blank

5. HECS LIABLE COURSES

CREATION_DT

date and time of creation of the extract

DD/MM/YYYY HH24:MI:SS

date

system

FEE_CAL_TYPE

the fee assessment period for which the extract was run

10

char

job run parameter

FEE_CI_SEQUENCE _NUMBER

6

num

PERSON_ID

the student to which the record refers

10

num

person.person_id

COURSE_CD

in conjunction with person_id, the student course attempt to which this record refers

6

char

 student_course _attempt .course_cd

MAJOR_SORT_ SEQUENCE

 

 

 

 blank

FEE_TYPE

 

 

 

blank

MINOR_SORT_ SEQUENCE

 

 

 

blank

KEY8

 

 

 

blank

KEY9

 

 

 

blank

RECORD_TYPE

record type

20

char

'HECS-LIABLE- COURSES'

FIELD1

person ID

10

num

person.person_id

FIELD2

course code

6

char

student_course_ attempt .course_cd

FIELD3

last effective assessment date

DD/MM/YYYY

date

greatest fee_ass.effective_dt

FIELD4

version

6

num

student_course_ attempt .version_number

as at date in field3

FIELD5

title

90

char

course_version.title

FIELD6

short title

40

char

course_version .short_title

FIELD7

course type

10

char

course_version .course_type

FIELD8

location

10

char

student_course_ attempt .location_cd

as at date in field3

FIELD9

attendance mode

2

char

student_course_ attempt .attendance_mode

as at date in field3

FIELD10

attendance type

2

char

student_course_ attempt .attendance_type

as at date in field3

FIELD11

derived attendance mode

2

char

student_course_ attempt .derived_att_mode

as at date in field3

FIELD12

derived attendance type

2

char

student_course_ attempt .derived_att_type

as at date in field3

FIELD13

status

10

char

student_course_ attempt .course_attempt_ status

as at date in field3

FIELD14

commencement date

DD/MM/YYYY

date

student_course_ attempt .commencement_dt

as at date in field3

FIELD15

discontinued date

DD/MM/YYYY

date

student_course_ attempt .discontinued_dt

as at date in field3

FIELD16

fee category

10

char

student_course_ attempt .fee_cat

as at date in field3

FIELD17

fee category description

60

char

fee_cat.description

as at date in field3

FIELD18

funding source

10

char

student_course_ attempt .funding_source

as at date in field3

FIELD19

correspondence category

10

char

student_course_ attempt .correspondence_cat

as at date in field3

FIELD20

HECS payment option

10

char

student_course_hecs _option .hecs_payment _option

as at census date associated with fee period

FIELD21

differential HECS

1

char

student_course_hecs _option .differential_hecs_ind

as at census date associated with fee period

FIELD22

 

 

 

blank

6. ASSESSED LIABILITIES

CREATION_DT

date and time of creation of the extract

DD/MM/YYYY HH24:MI:SS

date

system

FEE_CAL_TYPE

the fee assessment period for which the extract was run

10

char

job run parameter

FEE_CI_SEQUENCE _NUMBER

6

num

PERSON_ID

the student to which the record refers

10

num

person.person_id

COURSE_CD

in conjunction with person_id, the student course attempt to which this record refers

6

char

student_course_ attempt .course_cd

MAJOR_SORT_ SEQUENCE

 used to group records according to parent/child relationship of data

 2

num

 '06'

FEE_TYPE

 assessed HECS fee type

10

char

fee_ass.fee_type

MINOR_SORT_ SEQUENCE

 

 

 

 blank

KEY8

 

 

 

blank

KEY9

 

 

 

blank

RECORD_TYPE

record type

20

char

'ASSESSED- LIABILITIES'

FIELD1

person ID

10

num

person.person_id

FIELD2

course code

6

char

student_course _attempt .course_cd

FIELD3

fee type

10

char

fee_type.fee_type

FIELD4

fee type description

60

char

fee_type.description

FIELD5

fee calendar type

10

char

cal_instance.cal_type

FIELD6

fee calendar description

60

char

cal_type.description

FIELD7

fee calendar start date

DD/MM/YYYY

date

cal_instance.start_dt

FIELD8

fee calendar end date

DD/MM/YYYY

date

cal_instance.end_dt

FIELD9

fee assessment period start

DD/MM/YYYY

date

dt_alias_instance_v .alias_val

FIELD10

fee assessment period end

DD/MM/YYYY

date

dt_alias_instance_v .alias_val

FIELD11

system fee type

10

char

fee_type.s_fee_type

FIELD12

system fee trigger category

10

char

fee_type .s_fee_trigger_cat

FIELD13

charge method

10

char

fee_type_cal_instance .s_chg_method_type or fee_cat_fee_liability .s_chg_method_type

FIELD14

last transaction date

DD/MM/YYYY

date

greatest fee_ass.transaction_dt

FIELD15

last effective assessment date

DD/MM/YYYY

date

greatest fee_ass.effective_dt

FIELD16

last notification date

DD/MM/YYYY

date

greatest fee_ass.notification_dt

FIELD17

manual entry

1

char

Y or N (Y if any manual fee_ass entries exist)

FIELD18-22

 

 

 

blank

7. HECS-LIABLE-UNITS

CREATION_DT

date and time of creation of the extract

DD/MM/YYYY HH24:MI:SS

date

system

FEE_CAL_TYPE

the fee assessment period for which the extract was run

10

char

job run parameter

FEE_CI_SEQUENCE _NUMBER

6

num

PERSON_ID

the student to which this record refers

10

num

person.person_id

COURSE_CD

in conjunction with person_id, the student course attempt to which this record refers

6

char

student_course _attempt .course_cd

MAJOR_SORT_ SEQUENCE

 used to group records according to parent/child relationship of data

 2

num

'06'

FEE_TYPE

 assessed HECS fee type

10

char

fee_ass.fee_type

MINOR_SORT_ SEQUENCE

 used to group records according to parent/child relationship of data

 2

num

'07'

KEY8

 code of contributing unit

6

char

student_unit_attempt .unit_cd

KEY9

 

 

 

blank

RECORD_TYPE

record type

20

char

'HECS-LIABLE-UNITS'

FIELD1

person ID

10

num

person.person_id

FIELD2

course code

6

char

student_course_attempt .course_cd

FIELD3

fee type

10

char

fee_type.fee_type

FIELD4

unit code

10

char

student_unit_attempt .unit_cd

FIELD5

last effective assessment date

DD/MM/YYYY

date

greatest fee_ass .effective_dt

FIELD6

version number

6

num

student_unit_attempt .version_number

as at date in field5

FIELD7

unit short title

40

char

unit_version .short_title

FIELD8

teaching period of the student unit attempt

10

char

student_unit_attempt .cal_type

as at date in field5

FIELD9

6

num

student_unit_attempt .ci_sequence_number

as at date in field5

FIELD10

teaching calendar description

60

char

cal_type.description

FIELD11

teaching calendar start date

DD/MM/YYYY

date

cal_instance .start_dt

FIELD12

teaching calendar end date

DD/MM/YYYY

date

cal_instance .end_dt

FIELD13

teaching period code

10

char

cal_instance .alternate_code

FIELD14

location

10

char

student_unit_attempt .location_cd

as at date in field5

FIELD15

class

10

char

student_unit_attempt .unit_class

as at date in field5

FIELD16

status

10

char

student_unit_attempt .unit_attempt_status

as at date in field5

FIELD17

administrative status

10

char

student_unit_attempt .administrative_unit _status

as at date in field5

FIELD18

enrolled date

DD/MM/YYYY

date

student_unit_attempt .enrolled_dt

as at date in field5

FIELD19

discontinued date

DD/MM/YYYY

date

student_unit_attempt .discontinued_dt

as at date in field5

FIELD20

EFTSU

 

num

calculated

FIELD21

credit points

 

num

calculated

FIELD22

liability amount

999999.99

num

calculated

calculated liability for unit. This may differ from the actual debt if there has been a manual adjustment. Refer to TRANSACTION DETAIL & TRANSACTION SUMMARY records.

8. HECS CONTRIBUTION BANDS

CREATION_DT

date and time of creation of the extract

DD/MM/YYYY HH24:MI:SS

date

system

FEE_CAL_TYPE

the fee assessment period for which the extract was run

10

char

job run parameter

FEE_CI_SEQUENCE _NUMBER

6

num

PERSON_ID

the student to which the record refers

10

num

person.person_id

COURSE_CD

in conjunction with person_id, the student course attempt to which this record refers

6

char

student_course_attempt .course_cd

MAJOR_SORT_ SEQUENCE

 used to group records according to parent/child relationship of data

 2

num

'06'

FEE_TYPE

 assessed HECS fee type

10

char

fee_ass.fee_type

MINOR_SORT_ SEQUENCE

 used to group records according to parent/child relationship of data

 2

num

'07'

KEY8

 code of contributing unit

6

char

student_unit_attempt .unit_cd

KEY9

 HECS contribution band

2

num

govt_dscpln_hecs_cntrbt .govt_hecs_cntrbtn_band

RECORD_TYPE

record type

20

char

'HECS-CONTRIB -BANDS'

FIELD1

person ID

10

num

person.person_id

FIELD2

course code

6

char

student_course_attempt .course_cd

FIELD3

fee type

10

char

fee_type.fee_type

FIELD4

unit code

10

char

student_unit_attempt .unit_cd

FIELD5

version number

6

num

student_unit_attempt .version_number

FIELD6

discipline group

 

 

unit_discipline .discipline_group_cd

FIELD7

percentage

 

 

unit_discipline .percentage

FIELD8

government discipline group

 

 

govt_discipline .govt_discipline _group_cd

FIELD9

HECS contribution band

 

 

govt_dscpln_hecs_cntrbt .govt_hecs_cntrbtn_band

FIELD10-22

 

 

 

blank

9. TRANSACTION DETAILS

CREATION_DT

date and time of creation of the extract

DD/MM/YYYY HH24:MI:SS

date

system

FEE_CAL_TYPE

the fee assessment period for which the extract was run

10

char

job run parameter

FEE_CI_SEQUENCE _NUMBER

6

num

PERSON_ID

the student to which the record refers

10

num

person.person_id

COURSE_CD

in conjunction with person_id, the student course attempt to which this record refers

6

char

student_course_attempt .course_cd

MAJOR_SORT_ SEQUENCE

 used to group records according to parent/child relationship of data

 2

num

'06'

FEE_TYPE

 assessed HECS fee type

10

char

fee_ass.fee_type

MINOR_SORT_ SEQUENCE

 used to group records according to parent/child relationship of data

 2

num

'07'

KEY8

 transaction date

dd/mm/yyyy

date

If transaction category is PAYMENT, fee_ass.effective_dt OR if transaction category is DEBT, person_payment _schedule .payment_due_dt

KEY9

 

 

 

 blank

RECORD_TYPE

record type

20

char

'TRANSACTION-DETAILS'

FIELD1

person ID

10

num

person.person_id

FIELD2

course code

6

char

student_course_attempt .course_cd

FIELD3

fee type

10

char

fee_type.fee_type

FIELD4

transaction category

10

char

s_transaction_type .transaction_cat

FIELD5

transaction type

10

char

fee_ass .s_transaction_type

FIELD6

transaction date

DD/MM/YYYY

date

If transaction category is PAYMENT, fee_ass.effective_dt OR if transaction category is DEBT, person_payment _schedule .payment_due_dt

FIELD7

transaction amount

999999.99

num

If transaction category is PAYMENT, fee_ass .transaction_amount OR if transaction category is DEBT, person_payment_schedule .payment_amount_due

FIELD8

transaction ID

6

num

fee_ass.transaction_id

Note, payment details only, otherwise blank

FIELD9

sponsored amount

999999.99

num

sponsored_amount

FIELD10

sponsor code

10

char

sponsor_cd

FIELD11

sponsorship status

10

char

stdnt_crs_atmpt_fee _spnsrshp .fee_sponsorship_status OR fee_liability_sponsorship .fee_sponsorship_status

FIELD12

discount percentage

999.99

num

discount_percentage

Note, assessment details only, otherwise blank

FIELD13

discount amount

999999.99

num

discount_amount

Note, assessment details only, otherwise blank

FIELD14

discount minimum payment

999999.99

num

discount_min_payment

Note, assessment details only, otherwise blank

FIELD15

currency

3

char

currency_cd

FIELD16

exchange rate

9999.9999

num

exchange_rate

FIELD17

discount available

9999.9999

num

calculated (assessment details only), else blank

FIELD18

expected payment

9999.9999

num

calculated (assessment details only), else blank

FIELD19-22

 

 

 

blank

10. EXTERNAL REFERENCES

CREATION_DT

date and time of creation of the extract

DD/MM/YYYY HH24:MI:SS

date

system

FEE_CAL_TYPE

the fee assessment period for which the extract was run

10

char

job run parameter

FEE_CI_SEQUENCE _NUMBER

6

num

PERSON_ID

the student to which the record refers

10

num

person.person_id

COURSE_CD

in conjunction with person_id, the student course attempt to which this record refers

6

char

student_course_attempt .course_cd

MAJOR_SORT_ SEQUENCE

 used to group records according to parent/child relationship of data

 2

num

'06'

FEE_TYPE

 assessed HECS fee type

10

char

fee_ass.fee_type

MINOR_SORT_ SEQUENCE

 used to group records according to parent/child relationship of data

 2

num

'09'

KEY8

 transaction date

dd/mm/yyyy

date

fee_ass.transaction_dt

KEY9

 transaction ID

6

num

fee_ass.transaction_id

RECORD_TYPE

record type

20

char

'EXTERNAL- REFERENCES'

FIELD1

person ID

10

num

person.person_id

FIELD2

course code

6

char

student_course_attempt .course_cd

FIELD3

fee type

10

char

fee_type.fee_type

FIELD4

transaction ID

6

num

fee_ass.transaction_id

FIELD5

external reference code

10

char

fee_ass_external_ref .external_reference_cd

FIELD6

external reference type

10

char

fee_ass_external_ref .external_reference_type

FIELD7

external reference type description

60

char

external_reference_type .description

FIELD8-22

 

 

 

blank

11. TRANSACTION SUMMARY

CREATION_DT

date and time of creation of the extract

DD/MM/YYYY HH24:MI:SS

date

system

FEE_CAL_TYPE

the fee assessment period for which the extract was run

10

char

job run parameter

FEE_CI_SEQUENCE _NUMBER

6

num

PERSON_ID

the student to which the record refers

10

num

person.person_id

COURSE_CD

in conjunction with person_id, the student course attempt to which this record refers

6

char

student_course_attempt .course_cd

MAJOR_SORT_ SEQUENCE

 used to group records according to parent/child relationship of data

 2

num

'06'

FEE_TYPE

 assessed HECS fee type

10

char

fee_ass.fee_type

MINOR_SORT_ SEQUENCE

 used to group records according to parent/child relationship of data

 2

num

'11'

KEY8

 

 

 

 blank

KEY9

 

 

 

 blank

RECORD_TYPE

record type

20

char

'TRANSACTION- SUMMARY'

FIELD1

person ID

10

num

person.person_id

FIELD2

course code

6

char

student_course_attempt .course_cd

FIELD3

fee type

10

char

fee_type.fee_type

FIELD4

debt balance

999999.99

num

calculated

FIELD5

payment balance

999999.99

num

calculated

FIELD6

discount balance

999999.99

num

calculated

FIELD7

debt deferred for taxation balance

999999.99

num

calculated

FIELD8-22

 

 

 

blank

12. FOOTER (RECORD COUNTS)

CREATION_DT

date and time of creation of the extract

DD/MM/YYYY HH24:MI:SS

date

system

FEE_CAL_TYPE

the fee assessment period for which the extract was run

10

char

job run parameter

FEE_CI_SEQUENCE _NUMBER

6

num

PERSON_ID

the student to which the record refers

10

num

'9999999999'

COURSE_CD

 

 

 

blank

MAJOR_SORT_ SEQUENCE

 

 

 

blank

FEE_TYPE

 

 

 

blank

MINOR_SORT_ SEQUENCE

 

 

 

blank

KEY8

 

 

 

blank

KEY9

 

 

 

blank

RECORD_TYPE

record type

20

char

'FOOTER'

FIELD1

'PERSON' record count

6

num

calculated

FIELD2

'ADDRESSES' record count

6

num

calculated

FIELD3

'SYSTEM- CREDIT' record count

6

num

calculated

FIELD4

'HECS-LIABLE- COURSES' record count

6

num

calculated

FIELD5

'ASSESSED- LIABILITIES' record count

6

num

calculated

FIELD6

'HECS-LIABLE- UNITS' record count

6

num

calculated

FIELD7

'HECS-CONTRIB- BANDS' record count

6

num

calculated

FIELD8

'TRANSACTION- DETAILS' record count

6

num

calculated

FIELD9

'EXTERNAL- REFERENCES' record count

6

num

calculated

FIELD10

'TRANSACTION- SUMMARY' record count

6

num

calculated

FIELD11-22

 

 

 

blank

 

 Last modified on 21 February, 2002.