AutoDeposits

Daily process

The daily routine for locking and unlocking accounts (busilock.exe) based on imports from Sage and from Library systesms also notes and inserts deposit payments.

Configuration Files

BUSILOCK.DBF is the table that defines the configuration values for this part of that process. It has the following fields:

Field	Function
THRESHOLD	This is the dollar threshold for placing an account on hold -- this should be a positive number as positive numbers in Sage exports are balances owing.
DEPOSIT	This should be the tuition deposit for all programs except for newly admitted BEd students. This number should be a negative number as it is a credit on account (which Sage expresses as negative values) that is being sought here.
REZDEPOSIT	This should be the residence deposit and should be a negative value.
BEDDEPOSIT	This should be the residence deposit and should be a negative value. Note that this only applies to newly admitted BEd students.
INTLDEPOSI	This should be the international student deposit and should be a negative value. Note that it only applies to newly admitted international students.

Process

In general terms, this process examines each student to first determine the amount of the deposit required. Note that the flow of this is:

• Is the student registered?
  • If yes, is this a newly admitted BEd Student?
    • If yes, then add BEDDEPOSIT to the amount required
    • If no, then add DEPOSIT to the amount required
  • If no, then add zero to the amount required.
• Is the student an applicant for residence, not on the waitlist and sent notice of the deposit?
  • If yes, then add REZDEPOSIT to the amount required.
  • If no, then add zero to the amount required.
• Is the student a newly admitted international student?
  • If yes, then add INTLDEPOSI to the amount required.
  • If no, then add zero to the amount required.

Once the amount is required it is simply tested against the exported account balance. Should their be a sufficient credit for the required deposits, a PAID entry is entered in the Account Restrictions tab, along with the amount and date. If that is already filled in, but there is an insufficient balance, then an exception note is added to the report.

The Report is emailed as specified by the batch job.