« SHATAEQ problems | Main | Application of payments in TGRFEED: skipped records »
August 03, 2006
Add/Drop ($5 Fee) Process
The Add/drop ($5 Fee) process works like this:
There's a trigger on the table sfrstca where all the adds and drops are located. It fires off before an insert row and first checks to see if a record already exists for that pidm in a temporary table called zdwdrop. Then it checks to see if the student has already been charged for a drop that day. We only charge once per day per student, so the student can drop as many times as they want and only get charged $5 for that day. Next it will check to see if it's 7 days into the term. If it is, it'll insert a record into zdwdrop for that pidm. Finally a sleep wake process called swpdwdp fires off every 15 mins that looks in zdwdrop and posts the $5 charge for each student in the table.
Posted by soukupm at August 3, 2006 03:40 PM
Comments
Post a comment
Thanks for signing in, . Now you can comment. (sign out)
(If you haven't left a comment here before, you may need to be approved by the site owner before your comment will appear. Until then, it won't appear on the entry. Thanks for waiting.)