FINJ6120a - Statement Of Account Extract/Reminder Notice Extract

For VET Sector information, select the hyperlink below.

VET Information

 

Find all student debts matching the run parameters.

IF any students will be included in the extract:

  • Write HEADER detail
  • Create a Correspondence Item

For each student with a debt:

  • Write PERSON and ADDRESSES details
  • Create an Outgoing Correspondence record for the student
  • Write OPENING BALANCE details

IF person has unmatched Payment Credits:

  • Write SYSTEM CREDIT details

For each student debt:

  • IF targeting overdue debts (i.e. from Reminder Notices job):
    • IF current debt is not overdue
    • Process the next student debt
      • IF parameter conditions for reporting overdue debt are met
      • Record the new Reminder Date
  • IF debt is for a non-institution Fee Type (i.e. course_code not null):
    • IF current Student Course Attempt has not been included in the extract
      (and is eligible for a Statement of Account)
      • Write ASSESSED COURSES detail
      • Write UNIT SETS details
    • IF NOT finpl_ins_elgbl_detail
      • Count error
    • IF current Student Course Attempt is eligible for a Statement of Account/Reminder Notice
      • Write ASSESSED LIABILITIES detail
      • Create an Outgoing Correspondence reference record for the Liability
      • Write ASSESSED UNITS details
      • For each Assessed Unit:
        • IF student is on Differential Student Contribution Amount
        • Write DISCIPLINE BAND details
      • Write ASSESSMENT TRANSACTIONS details
      • For each Assessment Transaction:
        • Write EXTERNAL REFERENCES details
        • Write FEE ENCUMBRANCE details
          • For each Fee Encumbrance:
            • IF Fee Encumbrance APPLIED
            • Write Person ENCUMBRANCE EFFECT details
          • ELSE
            • Write default ENCUMBRANCE EFFECT details

IF debt is for an institution Fee Type:

  • For each Student Course Attempt liable for the Fee Type
    (and eligible for a Statement of Account/Reminder Notice):
    • IF current Student Course Attempt has not been included in the extract:
      • Write ASSESSED COURSES detail
      • Write UNIT SETS details
    • If NOT finpl_ins_elgbl_detail
      • Count error
    • Write ASSESSED LIABILITIES detail
    • Create an Outgoing Correspondence reference record for the Liability
    • Write ASSESSED UNITS details
    • For each Assessed Unit:
      • IF student is on Differential Student Contribution Amount
        • Write DISCIPLINE BAND debt
    • Write ASSESSMENT TRANSACTIONS details
    • For each Assessment Transaction:
      • Write EXTERNAL REFERENCES details
      • Write FEE ENCUMBRANCE details:
        • For each Fee Encumbrance:
          • IF Fee Encumbrance APPLIED
          • Write Person ENCUMBRANCE EFFECT details
    • ELSE:
      • Write default ENCUMBRANCE EFFECT details
  • IF any student were included in the extract:
    • Write FOOTER detail

 

 Last Modified on 08 December, 2004