| Top of ENR | Index | Table of Contents | Feedback | |
PELS Notice of Liability Extract - View Details
Note: From 2005, BOTPLS, PELS and OLDPS will be consolidated under FEE-HELP as part of changes to Commonwealth Supported Places (HECS).
PELS Liability Extract View Details
The table shows details of the fields presented by this view.
| Field Name |
Field Description |
Data Source |
|
| CREATION_DT |
Extract Creation Date |
System |
|
| REQUEST_PERSON_ID |
ID number of person who requested this job |
Job run parameter (numbers - 10) |
|
| CORRESPONDENCE_TYPE |
The type of Correspondence created by the job run |
Job run parameter (characters -10) |
|
| FEE_CAL_TYPE |
The Calendar Type of the Fee Period for which the job was run |
Job run parameter (characters - 10) (numbers - 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 (characters - 10) |
|
| FEE_CAT |
Fee Category |
Job run parameter (characters - 10) |
|
| COURSE_CD |
Course Code |
Job run parameter (characters - 6) |
|
| PERSON_ID |
Individual Person ID number |
Job run parameter (numbers - 10) |
|
| PERSON_GROUP_ID |
The code of a Person ID group |
Job run parameter (numbers - 6) |
|
| INSTITUTION_CD |
Institution Code |
Job run parameter (characters - 10) |
|
| ADDR_TYPE |
Institution Address Type |
Job run parameter (characters - 10) |
|
| DATE_OF_ISSUE |
Planned Date of issue of PELS Liability Notices |
Job run parameter (dd/mm/yyyy) |
|
| EXTRACT_Comment |
Comments for inclusion on all PELS Liability Notices |
Job run parameter (up to 60 characters) |
|
| TEST_EXTRACTION |
Indicates whether or not FINJ6180 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) |
|
PELS Liability 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. System Credit
5. PELS Liable Courses
6. Assessed Liabilities
7. PELS Liable Units
8. Transaction Details
9. External References
10. Transaction Summary
11. Footer - Record Counts
PELS_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 |
| 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 check box |
1 |
char |
addr_type .correspondence_ind |
| FIELD19-22 |
. |
. |
. |
blank |
| 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 |
| 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 |
. |
. |
. |
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 |
| 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 |
| 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 |
. |
. |
. |
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 check box |
1 |
char |
addr_type .correspondence_ind |
| FIELD15-22 |
. |
. |
. |
blank |
| 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 |
| 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 |
. |
. |
. |
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 check box |
1 |
char |
currency .local_currency_ind |
| FIELD5 |
Credit Amount |
999999.99 |
num |
calculated |
| FIELD6-22 |
. |
. |
. |
blank |
| 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 |
| 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 |
. |
. |
. |
blank |
| FEE_TYPE |
. |
. |
. |
blank |
| MINOR_SORT_ SEQUENCE |
. |
. |
. |
blank |
| KEY8 |
. |
. |
. |
blank |
| KEY9 |
. |
. |
. |
blank |
| RECORD_TYPE |
Record Type |
20 |
char |
'PELS-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 |
| 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 |
| 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 PELS 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 |
| 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 |
| 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 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 |
'PELS-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 |
EFTSL |
. |
num |
calculated |
| FIELD21 |
Credit Points |
. |
num |
calculated |
| FIELD22 |
. |
. |
. |
Blank |
| 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 |
| 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 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 | 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 |
| FIELD20 | Student Expected Amount | 999999.99 | num | calculated amount |
| FIELD21 | Sponsor Expected Amount | 999999.99 | num | calculated amount |
| FIELD22 |
Loan Scheme Expected Amount | 999999.99 |
num |
calculated amount |
| 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 |
| 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 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 |
| 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 |
| 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 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 | non-retention assessment amount | 999999.99 | num | calculated |
| FIELD8 | retention debt amount | 999999.99 | num | calculated |
| FIELD10-22 |
. |
. |
. |
blank |
| 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 |
| 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 |
'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 |
'PELS-LIABLE- COURSES' record count |
6 |
num |
calculated |
| FIELD5 |
'ASSESSED- LIABILITIES' record count |
6 |
num |
calculated |
| FIELD6 |
'PELS-LIABLE- UNITS' record count |
6 |
num |
calculated |
| FIELD7 |
. |
. |
. |
blank |
| 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 10 January, 2005