« December 2006 | Main | February 2007 »
January 29, 2007
Attributes
This can be very confusing so I thought I would try and document it. We even had a view transcript package that was looking at the wrong tables before I fixed it.
Institution course records
scrattr is tied to scbcrse Catalog
shrattc is tied to shrtckn Student
ssrattr is tied to ssbsect Section
Transfer
indiv (SHATRNS) shrtatt tied to shrtrcr, shrtrce, shrtrit, and shrtram
inst (SHATATR) shrtrat tied to shrtatc and shbtatc
Student attributes
saraatt tied to saradap (admissions record)
sgrsatt tied to sgbstdn (general student record)
Posted by wendlerb at 10:08 AM | Comments (0)
January 25, 2007
W2 Web
We were getting an error after setting up the year in ptrinst when trying to display 2006. It said that essentially 2005 was an invalid year even though we chose 2006. I Traced the error in wotr ro the package pp_w2_common. It looked like the package pp_w2 was making a validation call and not pp_w2_2006. It made no sense in wotr. It turns out that the package bwpkxtxs was newer in wops than wotr and the call is indeed to pp_w2. I changed the constant in pp_w2 from 2005 to 2006 and the year displays now. We checked against data and the numbers look good.
Posted by wendlerb at 2:28 PM | Comments (0)
January 18, 2007
1098 T
The package that controls the year displayed is bwskoacc and its in the procedure p_get_year.
Posted by wendlerb at 1:06 PM | Comments (0)
Woupark - wops
I got a report that secondary permits weren't working on web for employee. I brought the wife's car to work so I figured I would try it out. The front page worked ok where you enter the info in. I chose a payroll deduction option. When hitting submit you get the popup telling you your selection. After hitting ok, you get the generic error screen on the procedure process_parking2. I tried again selecting to make payment to cashiers but got the same error ruling ut any problem with the table pwbpark like we've had in the past. All tables hit in the code looked good. It looks like a if you don't make a selection on the pick up at cashiers or mail radio button, you get the error. Maybe we need to default one of the choices. Not having the baninst1 access made this difficult to trace down. Hopefully when we go to one database, this will be easier. In the meantime, I got a parking ticket! The parking office reversed it for me, lol.
Posted by wendlerb at 10:27 AM | Comments (0)
January 11, 2007
SOATEST
We got a request to have the test date also get picked up when you hit duplicate record to enter a new test code. Baseline sets it null. The mod is on key_dupl trigger on sortest block. Add another form to wou mods.
Posted by wendlerb at 10:38 AM | Comments (0)
January 10, 2007
SMRRULE
Registrars was having problems with some compliances and in working directly with SCT asked that some code be added to Smrrule. I noticed an old 6x version of this in the wou_sis_mods directory so it looks like we must have been running an older version. I can see any mods to it so I don't know why it was there. So I grabed the 7.3 baseline and put the code in that. Seems to be working ok since it was compiled.
Posted by wendlerb at 11:41 AM | Comments (0)
January 3, 2007
Tuition Promise - SZPECHT
We need a way to track TP cohorts and after discussion I decided it would be best to populate a end term field. Unfortunately, the Saaadms cohorts don't have a pidm specific start term and end term. So I created a wou table, szrchrt_end, to hold the end term data. Szpecht is a job submission program that populates the end term. It uses the table prom_term and a basis of 15 hrs per transfer term to calculate the ending term of the promise. 4 years = 16 terms so a TP07 new freshman admitted in 200701 would have an end term of 201100. A transfer student with 46 earned transfer hours admitted in 200701 would have 3 terms already used up so 201001 is his last term
Posted by wendlerb at 2:44 PM | Comments (0)