« July 2006 | Main | September 2006 »
August 31, 2006
Banner 7.3 Entity Relationship Diagrams
I downloaded Banner student 7.3 ERD documents today and put them in the I:\programmers\banner docs\banner 7.3 ERD\ folder. These are very useful for figuring out how the tables are related in banner and also provides a good description of every table.
Posted by soukupm at 04:17 PM | Comments (0)
August 30, 2006
Shrtrat Non-Standard Update
I ran a non-standard update on SHRTRAT on 8/29 that added new records for courses that transferred in as 1XX and 2XX courses. This update added the attribute "LOWR" for all of these courses. It corrects a problem where CAPP was including these courses in the core requirements when it shouldn't. The code for this update is in wou_misc.p_fix_shrtrat. I saved a copy of the table as shrtrat_bak before I did the update. All the records that were inserted are located in the table shrtrat_upd.
Posted by soukupm at 04:07 PM | Comments (0)
August 25, 2006
Scarf Degree Report
The Scarf Degree Report changed this year so I've spent some time this week adding in all the changes. There's a few new fields that were added so that Institutional Research can better identify students in their data warehouse. Most of the changes I made were to the scarf data model degree section. Luckily the data was already being collected from the queries so I didn't have to rewrite any of them. I also added in some error checking code for data quality problems. It's now complete and ready to use.
I sent in a test file this week and been working on data quality problems with the registrar's office. All the problems have been fixed so far and I'm just waiting for response from OUS on the latest submission. If it passes, I'll just need to validate the numbers.
Posted by soukupm at 01:40 PM | Comments (0)
August 18, 2006
Work Report: Soil,lots of reports, ede/dltools upgrade
It's been a very busy week. Some of the things I did this week:
The format for the SOIL data file changed from tab separated to comma separated and 2 new columns were added, month and year. This broke our existing script so I had to fix it. It should be working fine now.
I spoke with DOR and this should be the final changes that they're making to the file.
Wrote lots of different small reports for various departments:
Advising - number of students per faculty.
Admissions - major from list.
Registrar - hours earned for recent grads, invalid major codes, degree listing for undergrads.
Financial Aid - list of students who had certain detail codes in tbraccd and were WUE or NR.
I looked at the NCAA graduation rate reports and verified the numbers on their website.
I tested out the $5 add/drop fee in dev and it works fine.
Did an EDExpress 06-07 update (few dll files) and dltools upgrade to version 6 this morning.
Posted by soukupm at 03:25 PM | Comments (0)
Application of payments in TGRFEED: skipped records
Skipped records that are reported in the application of payments log file after TGRFEED runs is actually fairly common. It occurs when a transaction is posted after the feed runs, usually from a late night add/drop. As long as the tbrapppl_acct_feed_ind = 'Y' on those records, it'll feed them the next day.
Posted by soukupm at 02:33 PM | Comments (0)
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 03:40 PM | Comments (0)