« October 2006 | Main | December 2006 »
November 29, 2006
Work Report
Here's some of the things I worked on last week and this week.
We were missing SAT test scores in our scarf 4th week submission and it turns out that the new students are now reporting SATR scores. I modified the scarf script to collect these scores. Right now the scores are being mapped as SATV scores (OUS wants them mapped to this for now). I did a resubmit of our 4th week scores to OUS.
Since I had to report test scores only for the 4th week students, I added a new parameter to the scarf job submission called "special_cohort". This parameter is a term code in the scarf.reg table (where I've been storing our scarf registration data). Basically it'll grab all pidms in the table with that specific term code. So for the 4th week students, I plugged in '20064W' and it ran a scarf report for only those specific students.
I updated our scarf_fincat_xwalk table to add the new voyager fee remission, SMART grant and ACG grant. OUS wants a resubmit of all financial aid records for 2005 and summer 2006. I'm currently working on that now.
I added a new column "high school" to the job submission SWAFREC (recruit records). This is in production now.
Biquery broke last week when maverick_nt was taken offline. I worked with Ron to move the old oracle software from maverick_nt to the v:\biquery directory. We have a new registry in the V:\BIQuery\orawin6b directory to fix these problems.
I worked with Ron to get Financial Aid access to the old dept_data directory that they used for their admission load.
There was a bug in the print credit app on Banner Web that was returning an incorrect login ID for some users. This is fixed and seems to be running correctly now.
I built 2 new research tables for 2005 4th week (research_200501_4th) and 2006 4th week (research_200601_4th) from the scarf files I saved. These can be used for reporting our official numbers for 4th week. I also built full-time first-time freshman cohorts for 2005 and 2006 4th week. The cohort codes are F05F and F06F.
I'm currently working on IPEDS graduation rate survey for Fall 2000 cohorts.
Posted by soukupm at 02:49 PM | Comments (0)
November 14, 2006
Work Report
Some of the things I've done this week:
I added a new cron job to wolfman_nt that uploads fafsafiles.csv to Banner. It runs at 4:20am.
While adding the new cron job to wolfman, I updated perl on it but apparently it broke the directlending script so I had to reinstall the old version. It's working fine now. It looks like the win32::odbc module on it is no longer supported in perl 5.8, so I'll have to convert it to DBI when I get a chance. This also means rewriting the directlending script too so that it uses DBI instead of win32::odbc.
I spent about half a day yesterday getting the survey code to work on Banner Web. It's a bit tricky debugging code on there because all it displays is the default IE "page cannot be displayed" page. I eventually got it fixed and it seems to be running fine now.
I worked on a new report for the registrar's office that displays repeated courses for the term. As soon as I get some feedback from the report, I'll make the changes if there is any and put it into production as a job submission.
I'm working on another new report for the Registrar's office that will find available classrooms based on day/time/term. I plan making this into a job submission when it's complete.
All of our programs that send out email from Banner (pinmail,soremal,wou_wrlss) broke sometime around Nov 3rd. I spent the better part of friday afternoon trying to figure out what happend to it. Our best guess is that it is being blocked by a firewall change at OSU that's preventing us from using cougar.wou.edu as our mail host. As a workaround, I changed all these apps to use smtp.ous.edu for now.
Posted by soukupm at 01:27 PM | Comments (0)
November 09, 2006
Work Report
Some of the things I did for this week and last week:
Clearinghouse report - I had to rewrite parts of the clearinghouse script because some of the columns were wrong and the line length was incorrect. I downloaded the latest programming guide from their site which shows the correct record layouts for the file (it's saved in my h:\clearinghouse directory and also has a sample file). I sent my first clearinghouse file on Thursday Nov 2. I didn't get any technical errors but I did receive a fax for students who's enrollement had changed since the last upload. All I had to do is confirm that those students had withdrawn and fax the info back to clearinghouse.
Real time schedule - I changed the courses table table code so that it gets part of term 6 courses now.
Moded job submission SWAFMSS - Got a request from SEP to add term gpa to this report. It's now in production.
Survey from UCS programmers - I used the code that the UCS student programmers wrote and modified it so that it works in Banner Web. The procedure is called wou_survey.p_survey and the storing of the data is done by wou_survey.p_survey_process. The survey will pop up when a student goes to register for their classes. This is ready to go into production as soon as the questions are added to the table.
SCHOL_LETTER job submission - SCHOL_LETTER is job submission that outputs 3 seperate reports for students that qualify for specific scholarships. Admissions wanted me to change the requirements for the existing scholarships and add a new tier to it. This is now on the development database for testing. This app is actually a complicated piece that uses population selections in banner and some custom views. I'll write up a new blog entry to explain this better.
Posted by soukupm at 03:04 PM | Comments (0)
November 02, 2006
Work Report
Some of the things I've worked on this week and last:
Finished up Scarf 4th week report.
Worked a lot on faculty transcripts mod for registrar's office/business office. The mod contains lots of textual mods to identify that the transcripts are to be used for internal advising only. Also contains watermark on page, although it doesn't print out because of browser limitations. I commented out the old logic that prevented advisors from viewing student transcripts when they had holds on their accounts. I changed the confidentiality notice so that it doesn't prevent faculty and advisors from viewing the transcript. It does display in bright red color that the student is confidential if the student has the flag set. This mod is now in production.
Did the same mod for confidentiality and holds to the transfer transcript app.
Had an issue with the pin reset on goatpad. The was nothing wrong with the button or form, but there was a lot of old pin reset data in gurmail that was never cleared out of the tables. I did a non standard update to clean these up.
Moded the health insurance procedure so that it now selects from 4 different address types: SB,DO,CU,PR.
Went to Atlas/IDTS meeting at U of O.
Put medical holds on for new students with M2, NI and NULL GOAMEDI records ( had to rewrite the old script because it only looked at null records). Ran labels and lists for these students.
Changed real time schedule so that Honors classes are now listed in the Honors department ( any course number with a course like '%H' belongs in this department).
Fixed a bug in the research table script. If the script was run for a prior term, the transfer, institutional, and overall hours would be incorrect because it was getting this data from the history table shrlgpa. It's now fixed so that it does a sum of credit hours up to the current term from shrtgpa.
Worked on a solution to display selective part of term courses on the web. I wrote a short blog entry on it here.
Worked on retention list for provost office, send list to registrar to double check the numbers.
Worked on faculty staff directory.
Moded real time schedule of classes so that it looks at ssbsect_voice_avail column set to 'Y' just like Banner Web. This is the display on web indicator for courses.
All the registration times are setup and emails were sent out yesterday.
Posted by soukupm at 08:59 AM | Comments (0)
November 01, 2006
Preventing a course from displaying on Banner Web class search
There's a way to prevent courses from displaying on the class search page but still allow students to register for the course. All you have to do is go into SSASECT and uncheck the "Voice Responce and Self-Service Available" box. Students will still be able to register but they will have to know the CRN number for the course.
Posted by soukupm at 09:44 AM | Comments (0)