All public lab computers are connected to OCS Papercut Printing Management system for payment control.
To feed the database on the academic SQL Server with current student enrollment information, process entails the following steps:
Initial datafile is provided 1-2 business days after the end of the previous academic session/semester.
Every 2-3 business days afterwards, 2 datafiles are created: newly registered students and the students whose academic load changed since their initial load. The files usually stop after the "late add" period is over
Archive the snapshot of the last semester's data prior to cleanup.
Insert new students or update balances of existing students with continuous enrollment.
Move from production into an archive on SALI SQL Server the "old" students with remaining cash balance.
How to Submit a Request:
Call or email Email Andrey Postoyanets in ITS Database Group.
Turnaround Time:
Typically takes at minimum 3 minimum 2 business days.
Required User Input:
"Green light" to purge the previous semester free balancesNA
Prerequisites or Restrictions:
Request must come from WEB lab manager AIT (James Liu) only.
