« June 2006 | Main | August 2006 »

July 28, 2006

SHATAEQ problems

I spent a good amount of time this week fixing two students that had transfer articulation problems from the form SHATAEQ. Both of them somehow got invalid data in their records from a cursor crashing while articulating or while rolling transfer hours into history. So I figured I write up a something about what to look for and what can be done to hopefully fix the problem.

Most of the most common problems with transfer articulation can be solved by finding the bad record in shrlgpa and shrtgpa. When I say bad record, I mean there will be a record with some random gpa amount and no earned hours, an out of range gpa, hours that don't seem to match what the student actually took, possibly a missing record, a missing school, etc. I could go on and on but you probably get the idea. You can see if admissions can delete the record from history via the form if it's possible but usually they call when they've already tried that. So the only thing to do is delete the offending record and have admissions recalculate the gpa (under equivalent roll info). Be really careful when you do this and make sure you have the correct pidm, it doesn't hurt to double check everything and possibly even make a quick backup before deleting ( create table mybackup as ( select * from shrtgpa where shrtgpa_pidm = xxxxx).

Posted by soukupm at 03:04 PM | Comments (0)

July 27, 2006

SZRFORN

I created a new job submission called SZRFORN for the business office that displays details about foreign students registered for the term. The fields are as follows: vnum,lname,fname,nation,credit_hr, tuition amount, fee remission amount, total tuition at the bottom along with total fee remissions.

Posted by soukupm at 03:57 PM | Comments (0)

July 20, 2006

SZRTRAK, Financial Aid Admissions Load

SZRTRAK is now in production as a job submission in Banner.

Financial Aid's admissions load process is a web based app that Jeremy and I created a few years ago that uses the sys.utl_file package to open and write files from a directory on wilbur. The package is called finaid.finaidstuload and it exists on aero. It has two different procedures in it:

P_Adm_Load: Used during the term to update attempted hours, hours earned, admitted code, and email address.

P_Adm_Load_Eot: Used mostly at the end of term, updates all term hours, admitted code, and I just recently added admit decision, term gpa, overall gpa, transfer gpa and institutional gpa this week.

It uses a DB link with banner and calls the package wou_finaidload2 that does all the work. In general terms, it takes a file called finaid_load.csv from wilbur and grabs an ID from this file, does a lookup in banner for a match, and collects the data it needs depending on which report was ran. The output is then stored in a file on wilbur called finaid_load.lis and finaid_load2.lis. These are fixed width files that Financial Aid will use to load into powerfaids.

Posted by soukupm at 03:45 PM | Comments (0)

July 13, 2006

SZRACAD and SZRTRAK

I made a change to SZRACAD and added another term code parameter so that the user can choose which term gpa they wish to see. This is now in production.

I'm just about finished with a new job submission that is related to SZRACAD called SZRTRAK. This is the static data for the szracad report that gives name,id,admissions details, and high school information. The parameters are term code and crn, just like with SZRACAD.

Posted by soukupm at 03:58 PM | Comments (0)

July 07, 2006

Making a file downloadable from web in pl/sql

The key to making to a file downloadable versus displaying in the web browser is to add this line before any htp.prn() calls.

owa_util.mime_header('text/csv');

Depending on what your doing, you can add any mime type the browser/server supports, choose to close/not close the header, and change the character set.

procedure mime_header(ccontent_type in varchar2,
bclose_header in boolean,
ccharset in varchar2)

Posted by soukupm at 03:28 PM | Comments (0)