January 25, 2008
1098T Records 2007
There were about 166 1098Ts for 2007 that had erroneous date in box 6 because of adjustments to financial aid prior to 2006. The business office did not have rules set up to handle adjustments that far back. So they pulled these forms out of the 7900 that got printed and asked me to fix them in Banner avoiding having to do the entire process over. I nulled out the ttbtaxn_amount_5 field on the records for 2007 and then had to deal with the tbraccd records. On tbraccd I nulled the tbraccd_tax_amount for these records where tbraccd_tax_rept_year was 2007 and tbraccd_tax_rept_box was AS. There were also two records with erroneous data in box 5 for grant adjustments. I followed a similar plan for those. The name of the form to view these records is TSATAXN
Posted by wendlerb at 9:48 AM | Comments (0)
January 11, 2008
Third party ID - GOKTPTY
Well our decision to remove a bunch of gorpaud records really came back to bite us. We were getting errors trying to do a an admit decision, errors trying to do a curriculm change, errors in GOATPAD trying to make a new pin. All related to a table trigger on gobtpac that creates a third party gorpaud record. We kept getting a unique constraint error. Turns out goktpty procedure that checks the external user id does it in a loop counting the times it sees the external user id in gorpaud and appending a number on the end of the string. When we removed the records it no longer looped the correct number of times and returned a value for external user that already exists on gobtpac. Thus the unique constraint error. I modified goktpty to do a union looking at records in gobtpac as well as gorpaud. This seems to work.
Posted by wendlerb at 1:44 PM | Comments (0)
November 5, 2007
SPAIDN1
There is a concern that once we merge student workers would be able to see employee info set up on ppaiden. In order to be proactive I made a clone of spaiden and modified the enable_tab_pages trigger. The tabs don't get enabled if the record is an employee with an eclass code beginning with a U or C. Nothing may come of the form but it is available if needed.
Posted by wendlerb at 1:09 PM | Comments (0)
October 26, 2007
SFRENRL
Student enrollment verification report
A request for this report is done thru SFARQST. Currently the user then goes to job submission and runs sfrenrl to print the report. It is usually done on special paper and the report spits out a blank sheet, the report, and a report info footer page. Registrars only wants the middle page. I looked at the source and noticed it was set up not to print the last page when running in sleep/wake mode. It looked like the com file started to be coded for sleep wake but not finished. So I debugged the com file so it works from sleep/wake and removed the blank page in front. It is currently running on W_REGCOUNTER every 45 sec.
Posted by wendlerb at 11:38 AM | Comments (0)
October 17, 2007
Shrtaeq
Issue: The report is supposed to not print out entire line when everything is the same except the wou equivalent attribute field. Now, sometimes it does and sometimes it doesn't. There is a wou mod that checks the previous record.
Solution: The sort order didn't always put the tsubj and tcrse together do I added the two fields at the end of the sort on the main select statement
Posted by wendlerb at 9:40 AM | Comments (0)
October 2, 2007
Web pin generation and forgot pin button
Registrars asked if no character 'O' could be used in web pin generation because students got it confused with the number 0. The package goklibs contains a f_GenRandChar function that gets used in pen generation when the form GUAPPRF has pins set to random. I moded function to not use the O character.
Registrars also asked that the user question get asked first before the forgotpin button on the login page goes to the pin reset link on aero. It's set up now to give the question first. If the response is incorrect, the user can click a button to go to the aero page. If the answer is correct, it does the Banner baseline reset.
Posted by wendlerb at 1:57 PM | Comments (0)
September 26, 2007
Student web student general info (bwskgstu)
We are thinking of turning on bwskgstu.P_StuInfo in wouprd. Right now it is on in woutst. Banner team has requested that advisor email address be added along with secondary advisors and types. Delving into the package it looks like the mod need to go into bwckstu.p_getadvrinfo and
bwckstu.p_stuinfo packages. I added a few cursors and some items to the display. Waiting for approval.
Posted by wendlerb at 10:30 AM | Comments (0)
September 6, 2007
Failed SOIDEN searches
The business office noticed that some people could not be found when doing a SOIDEN search on their name. You also could not move around correctly in Spaiden with them. Some forms looked like there might be an extra space in the first name for these people. Indeed there was and it caused these banner form issues. I looked further and found they were coming from the admissions credit card piece. So I did a rtrim on the first name of all spriden records with a user id of WOU_SIS_UTIL and removed the extra space. In the package I added an update on the spriden record created to rtrim the first name.
Posted by wendlerb at 2:54 PM | Comments (0)
August 21, 2007
Advisee Listing page
We have worked on removing email anchors that we find on the advising pages in web for student. bwlkfstu.P_FacStuSchd is another page with the email anchors. In order to remove the anchor and just print the email address I had to go to bwckfrmt.f_disp_instr_email_icon and modify it.
This worked on some instructors and not others in woudev. Turns out the cursor to get the email address has to indicators that need to be set to Y. (goremal_preferred_ind = 'Y'
AND goremal_disp_web_ind = 'Y') Changing the indicators on those not showing caused them to show up.
Posted by wendlerb at 10:45 AM | Comments (0)
July 10, 2007
Inactive student accounts
Phase I of inserting new sgbstdn inactive record on graduated students completed in wouprd.
Posted by wendlerb at 8:42 AM | Comments (0)
June 27, 2007
Tuition Calculator
We were able to get the source for PSU's tuition calculator. I was able to modify the source to fit the WOU model by adding a choice for the promise. Our Web master then put in in the WOU template and it looks pretty good.
Posted by wendlerb at 8:15 AM | Comments (0)
May 23, 2007
Address filter
The old address update section on web for student had a filter on it that is a local function (f_standardize_name_addr) that looked at upper/lower case corrections on entered addresses. I added this filter to the quick start app and the admissions credit card package. We added some additional filtering. Commas are now removed and replaced with a space unless the next character already is a space. Periods are removed unless the character in front of it is a number. This was done inside the logic already written. The modified filter is in production
Posted by wendlerb at 11:44 AM | Comments (0)
May 22, 2007
High School Transcripts - IDTS
The idts/ project requires the EDI receiving of high school transcripts. OUS has sent out several test which we did not receive on 009190. Turns out we can't get it if indicator is set to test but will if set to production. Now getting like everyone else although everyone is getting an error which stil needs to be worked out. I've seen the transcript but haven't played around much with downloading into the Bi-Query Model
Posted by wendlerb at 10:09 AM | Comments (0)
May 15, 2007
Tuition Promise -- insert saradap trigger
We discovered that tis trigger stopped working correctly some time last Feb. I updated records since then to the correct rate code and then started to track down what happened to the trigger. Turns out one of the patches we installed changes the way the student level gets populated on saradap. The trigger used UG as one of its boolean keys. New.saradap_levl_code used to be UG but it is now null. I can't key off it. So I switched from using that to new.saradap_admt_code := 'FR' . The logic seems to be working again as long as I can use 'FR' as a key.
Added TR and FT as well
Posted by wendlerb at 2:31 PM | Comments (0)
May 2, 2007
Banner front menu
So, the front menu on Banner suddenly was missing menu items today even though they were set up correctly in GUTGMNU. Turns out to be a known bug that kicks in the first time somebody rebuilds the menu hierarchy. All the local menus disappear under the menu you are changing. The work around is to put the locals in twice.
Posted by wendlerb at 1:33 PM | Comments (0)
April 19, 2007
Email on student web
There are several web for student forms on the faculty menu that have an email button associated with each person on a roster. These are packages bwlkadvr and bwlkfcwl. These fill in the to field header on an email with the student's email address. The problem is that the default email client on the machine comes up which may not be supported by UCS. I modified the forms to display the email address on the form.
Posted by wendlerb at 1:52 PM | Comments (0)
March 6, 2007
Banner credit card
We noticed we started having several 200603 term charges on baseline credit card payments even though the defaults are set to 200602. Normally the student gets to the credit card through the finaid release/term summary conbo. The link is actually to a term select procedure which defaults the 200602 value. If you call the payment package directly, you go to a term select paage first which uses whatever terms are enabled for registration in a drop down menu. I figured out that students were using the search feature on student web to look up credit card and then clicking on the link to the credit card payment procedure directly. This brings up the select term choices. I changed the default in bwskcpmt to not do this.
Posted by wendlerb at 8:39 AM | Comments (0)
February 22, 2007
Tuition Promise and Saaadms
We crated a process to populate an end term for every student using the tuition promise plan.Ttuition promise
This populates the table szrchrt which has the end term. We needed staff to be able to insert, update, or delete records on this table so I decided the best thing to do was add a tab to the form SAAADMS with the required fields. It does mean another form to maintain but I figured it was the best functional place to put it. I will wait till we move to the 10.1.2 server befoore sticking it out there as well.
Posted by wendlerb at 9:42 AM | Comments (0)
February 21, 2007
State Student ID
All students in Oregon will be getting a 10 digit id number assigned to them in grade school that will get tracked all the way through high school. We will soon be required to track it in banner as well. OSU put in a request with SCT to add a field to Banner but hasn't had a positive response. So OSU has created a table and added a field to the Spaiden form in the biolography tab. We got the form and table creation code from OSU, created the table sybssid under baninst1, and added this block to Spaiden. I am going to wait till we move to the new 10.1.2 form server before sticking it out in production.
Posted by wendlerb at 9:43 AM | Comments (0)
February 8, 2007
Fee Assessment Bug
We had some web drops which happened when the refund percent went to 0 (SFARFND)and before the last day to drop on the web where the penalty was not getting charged on tsaarev. The drops the day before the 0 percent went into effect worked normally. The last day on the 5th record is set to Dec 31, 2099. After some invetigation we found out that it worked if you changed the date to 2009 so I suspected some kind of problem with a cursor using date. There is a procedure p_set_rbt_variables in the package sfkfees that makes use of the date range. It uses some library function to format the date which apparently doesn't work right with web drops. It worked ok from SFAREGS. I changed the procedure to use a standard to_date(variable,'DD-MON-YYYY') and the web drop worked correctly.
This wouldn't show up as a bug in baseline because you don't get to web drop with web fee assessment turned on in baseline anyway.
Posted by wendlerb at 9:38 AM | 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)
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)
December 5, 2006
Credit Card - Touchnet
Corvallis ETS has decided to go with a Touchnet Payment Gateway to replace the iPayment server thet are using now. They should have a test server set up some time in January. This is necessary because right now Banner only unofficially supports iPayment and doesn't even have documentation for it.
For us it means some changes to the student web credit card setup. Mostly this will be parameter settings and gtvsdax settings. There are some mods to packages that I'm not sure yet how they will need to be changed.
The admissions app will have some changes as well. Looking at the Banner baseline code for TPG, it looks like the returning authorization string is the same. Jpay still gets called so the building the url may not require much change either.
Posted by wendlerb at 9:50 AM | Comments (0)
November 30, 2006
SFARQST
This form was hanging sessions taking about 15 to 20 minutes to page down into the form. The form had several spriden selects in it which needed a compiler hint so I changed those and put the mod into production. It didn't help
I ran the sql to find the slow cursor and found a query referencing the table sfrenrl and sfvenrl. Never could find that query anywhere in database, form, or associated libraries but from past experience knew the problem had to be with the view. Sure enough, the view has about 4 unions in it all with spriden joins. First tried the driving site hint but that didn't work. Used all rows on it and it seems to be working ok now.
So there's a form mod and a view mod
Posted by wendlerb at 10:29 AM | Comments (0)
November 15, 2006
Removing Advisors
It's been requested that we create a process to remove the advisor from an inactive student record. The form SGAADVR is a little deceptive. When you hit the maintainance button and close he advisor, the fiels on the form shows updates the end term field. There is no field on the table behind the form that corresponds to this field. In reality, a new record is inserted into the table with a new effective term and nulls in the advisor field. I wrote Szpeadv as a job submission program which does this. It looks for IG or IS sgbstdn records.
Posted by wendlerb at 2:46 PM | Comments (0)
October 26, 2006
Cron job repeats
Yesterday when cedar dropped from the cluster, there was a glitch in the system causing all the cron jobs to be run multiple times. It has something to do with the system clock. The feed ran several times and so we felt it best to reset the flags and run it through again. There is a script feed_reset.sql that you have to stick a date in to use but it works well for that. The financial aid program, swbrdll, also ran multiple times putting on sometimes 9 times the amount of direct loans on a student record. I removed these records in tbrmemo and direct_pre_memo and let the process run again last night. This morning it looks like this worked real well.
Posted by wendlerb at 8:20 AM | Comments (0)
October 19, 2006
Swbmisc
This old report was not picking up any debit entries. I discovered it wouldn't any time you entered in any index or fopal in the paramters but would if you left them blank. Turns out the code was looking at charge fields only against parameters and debits are all pay fields. I stuck some or statements in there and got it to work.
Posted by wendlerb at 10:45 AM | Comments (0)
September 26, 2006
SHRTPOP
People with no degrees not showing up despite following directions and leaving degree parameter blank. The program has 3 main select macros run depending on parameters used. There is a macro2 used when using a population select which was tied to degree table during ver 7.2 to get multiple levl codes. It used to be tied to sgbstdn. We can put an outer join on it to get everyone in population selection. Also, when you use a population, most of the parameters in job submission are ignored. So you can't get people with no degrees when nothing is entered in degree parameter by changing it to an outer join and be able to select based on degree. It's one or the other.
Posted by wendlerb at 9:59 AM | Comments (0)
September 15, 2006
TSAMASS
This form was throwing a warning for every student that had a hold. The code is a program unit on the form and I commented out the hold check.
Posted by wendlerb at 2:24 PM | Comments (0)
June 28, 2006
Fee assessment bug
AR ran into a problem when rerunning fee assessment in a prior term to current. My record was one that got hit by it of all things. Several people who were on staff rates or special rates were getting the staff rate in the previous term reversed and charged the basic rate by this 2nd run of fee assessment. It turns out to be a problem with the form SFAREGS. When you change a fee rate from the option menu it not only creates a new record in SGASTDN with the new term but also updates the previous term fee rate on the old record. This is not the case if you put a record into SGASTDN directly but only if you do it from SFAREGS. So if you change someone to basic to run summer fee assessment, you're going to turn the spring SGASTDN record to basic as well. Do another spring assessment and wham...the basic rate gets applied.
This appears fixed in SFAREGS ver 7.3x
Posted by wendlerb at 1:58 PM | Comments (0)
May 19, 2006
Shrediy fun - cron job
I created a com file on shrediy to set up the cron job and ran into all kinds of fun with the input paramets. Normally this is usually pretty seemless but in this case there are some input loops when running from command line that don't cause a problem when running from proC execuatable. I had to add a blank line to the input file after transcript type and address type in the input file that gets created during the com file execution. Otherwise the program goes into an endless loop. The address type also appears to get validated when running from command line as opposed to running in proC executable mode.
Had some fun also trying to figure out how to get to the proper directories on radar from spruce using sftp. cd edi2:/shrediy seems to work
Posted by wendlerb at 2:54 PM | Comments (0)
May 10, 2006
Web advisor hold release
The package dehold is behind this page on banweb. There a re some local tables set up to allow anyone in a department to delete a hold on an individual in that department. The tables are zfacdepnd ztvdept. Advising called and wanted some new advisors to work in the same way so I put them into the table
Posted by wendlerb at 3:09 PM | Comments (0)
May 1, 2006
Woutst/Wodv refresh
ETS refreshed these two databases from production Friday morning April 28. This was done to help with departments coming on to Capp. I knew I'd have to reset the web transcript stuff. Unfortunately the Banner team forgot about the EDI stuff set up in woutst and wiped it out during the refresh. I got a setup sheet from our consultant and reentered the stuff by the end of the day so I think we're back to where we were.
Posted by wendlerb at 3:09 PM | Comments (0)
April 12, 2006
Virtual Warehouse
We lost the connection to the listener on wilbur yesterday and had to track it down. This connection is made when logging into the current student model on our query tool Bi QueryThere is a password in a file in Jeremy's home directory on wilbur that gets looked at but it is a validation type of thing to the package on wouprd and not an actual login password. It matched what it expected so that wasn't it. The network boys turned off a lot of http functionality in favor of https so we suspected that as well. Sure enough, a line of code on oracle_obj_srsv.pl was making a call to http banweb. We changed the line of code to https on this located in Jeremy's directory on wilbur and it connected.
Posted by wendlerb at 2:04 PM | Comments (0)
April 6, 2006
Shrediy and EDI Transcripts
The Banner job submission program, Shrediy, produces 4 dat files. SEDICTL.DAT, SEDIFLT.DAT, SEDILOG.DAT, and SEDISGN.DAT all get output to a directory usr$disk:[ban_woutst] for woutst. Unfortunately, this is a restricted directory and the only way to get the files moved into the spool directory is by using a com file via job submission called "Look". Summer doesn't have the access required to get the files. We eventually have to develop a sftp method to get the dat files to and from the SmartEDI server. For more info see Summer's blog
Posted by wendlerb at 3:23 PM | Comments (0)
April 5, 2006
AB Holds
The cron job that puts AB holds onto students is a jobsubmission script that calls the package wou_sis. Some people were getting holds that shouldn't be. The hold is supposed to go on when the student owes from a prior term. I also found logic that puts a hold on when the student has a balance current term and is not registered for any classes and does not have child care. The person we looked at met this qualification so I added a check to see if they had housing as well.
Posted by wendlerb at 11:34 AM | Comments (0)
March 1, 2006
Atlas
I went to a meeting for Atlas with the Chancellor's office down in Eugene. It is a tool for students to use to see how their classes would fair at different Oregon universities. In our case, it would require capp to be up and working. There is some initial money available to the small schools to finish transfer articulation rules but there are annual cost assiciated with it that are estimated to be around 8k per year.
Posted by wendlerb at 8:37 AM | Comments (0)
February 22, 2006
Faculty web grading
We got a request to only allow faculty to enter a grade of W,F, or X on students that have a course status of WS or WC in SFAREGS. Currently they can put in any grade but W which isn't enabled for web grading. In order to do this it requirss that the external code for gmodgrd be set to Y on GTVSDAX. I also had to put a mod into bwlkffgd to hardwire a cursor to select W, F, and X in the senerio
Posted by wendlerb at 8:29 AM | Comments (0)
February 21, 2006
Student web transfer articulation
Banner team recieved a report that the student web transfer articulation report was giving inconsistent results. I investigated the wou_trans_art package and found that it divided this into an inprogress section and a history section. Both were pulling couse attributes off the course instead of the individual causing the discrepancies. Campus also wanted the in progress piece removed. It now pulls from the student and in progress is removed
Posted by wendlerb at 11:43 AM | Comments (0)
January 23, 2006
Research table
SWIURCH is a sql script that runs in 3 cron jobs to populate the research table for 3 terms. This is a wou table with data coming from multiple sources and is used for a great number of sis reports. Scarf reporting makes use of this heavily as well. I noticed major/minor information was still coming from the table sgbstdn. Banner 7 has changed this to a new table sorlfos and even though sgbstdn is supposed to be getting backfilled, I've run across some instances where this is no longer the case. So I changed the swiurch script to pull major/minor info from sorlfos.
Posted by wendlerb at 8:45 AM | Comments (0)
January 20, 2006
SHATATR bug
When trying to create a new effective term for a inst course, you get the error "Unable to create attribute record" when a previous attribute exists. Searched through the form and found where bug was occuring. It looks at scrattr records and has a logic problem getting the eff term to use on the new record. I found the bug on the SCT site and it looks like it is addresed in the Banner 7.2 release. If I can find the form, maybe I can put fix on 7.1x version of form but for now we have work around.
Posted by wendlerb at 8:11 AM | Comments (0)
January 19, 2006
Tax Notification
This is on web for student and has years hard coded into the packages. I made chnges to bwskoacc to handle the administratoe look up of any student. I also looked at bwtktxys and ttkfunc to habdle the student look up. We changed it to a date range of 2003 to 2005.
Posted by wendlerb at 11:10 AM | Comments (0)
January 13, 2006
SZRLOWE
Low Enrollment Report
This report list crns that have less than 12 students enrolled. It matches the instructor teaching the class with his academic rank and salary. In order to do this I had to create some functions in wouprd under baninst1 to grab data across a database link to wops. The rank comes from the table perrank and the term salary comes from nbrjobs ann salary / 3. The request also asks for fte per course but banner only has an fte for the job. Apparently there is a field for this on student(fte per course) but it has never been entered. The numbers the provost office uses for this are a little unclear so more discussion on it is on the way.
Posted by wendlerb at 8:23 AM | Comments (0)
December 28, 2005
Official transcript request on student web
I've been investigating the student web request for official transcript packages: bwskwtrr.p_disp_transcript_address and the package to review the status of a request:bwskwtrr.p_disp_order_requests. I have these set up in woutst. There are several steps to do in order to get this up and running:
Enable packages from web tailor
Create detail code A595 and put in correct charge to hit student account
Goto form STVWSSO and define delivery method
Goto form STVWPYO and define payment method
Goto form SHATPRT and set up web control detail for OTS type
Determine if allowing EDI and 2 holds as well as whether charges accessed per copy or per request on same form.
Goto form STVTPRT to set what types of transcript available via web
Goto form STVDEGC to set degrees available on web
Goto form SHAWTRR to set courses
Same form also sets max parameters before charges
Goto STVSBGI if you want EDI
Goto SOASBGI to set up address for schools
Signature page option
Posted by wendlerb at 10:16 AM | Comments (0)
December 14, 2005
SFRFASC
MH reported that several people assessed correctly but did not show up on printout. I checked for defects for it under UDC site and found that it was a defect that was fixed in ver 7.2.0.1
I got ahold of this newer version and found fixes to two cursors,new_tbraccd_cursor and sfrfaud_cursor. I copied these corrections and placed them in the 7.1x version we are running in production. This can go back to baseline once we move to 7.2
Posted by wendlerb at 11:31 AM | Comments (0)
December 12, 2005
GJAPCTL
GJAPCTL, the job submission form, has been setup in FIS/HRIS to be able to work with the settings in GWADEST to print to a default printer or send results to yourself in an email. SIS was never set up for this. GWADEST exits already on SIS. I needed to add two records to the table gtvemal that had codes of PRNT and WORK to match what is in FIS. It turns out that osshe did a form mod to GJAPCTL to handle cases where the printer field is left null or set to email. I grabbed the source out of FIS/HRIS and recompiled it to SIS. It seems to be working in SIS now just like in FIS/HRIS.
Posted by wendlerb at 10:38 AM | Comments (0)
November 23, 2005
SWKRPSB
This is a baselinr accounts recievable report that is supposed to show charges and paymrnts for the catagories:TUI,FEE,HOU,MEA,RFN. The logic in the program for charges looked good but the numbers for paid were inaccurate. The code was summing any detail record that had a code with an indicator of P. It needed to pull payments toward the charges so it needed the TSIAPPL tables. I pulled a sum off the tbrappl table where it matched the charge detail record but found I was having problems with tuition changes from add and drops. I had to sum the negative amounts on detail and subtract from the sum of the tbrappl_amount.
Posted by wendlerb at 11:28 AM | Comments (0)
September 22, 2005
Spaiden Non-person
It looks like mods to GB_IDENTIFICATION package were not needed. We could not generate a non-person correctly on this form. The V# ended up with a spriden_change_ind = 'I' no matter what while the person generated id stuff worked fine. The insert table trigger on the spriden table works differently on person vs non-person so I thought it was that. However, it's set up to expect an id beginning with X and handle the rest. The generate id code was commented out of the 6x spaiden form. All that got moved to the package GB_IDENTIFICATION so I figured it needed to be commented out there as well. It turns out commenting it out caused me a lot of extra code in DML_SPRIDEN and it actually works ok anyway. So, GB_IDENTIFICATION is back to baseline with the generated_id code in and DML_SPRIDEN is much closer to baseline. Non-person generated ids now works.
Posted by wendlerb at 2:01 PM | Comments (0)
September 16, 2005
SZZDCRV
Admissions needs to change an admit decision once in a while and the baseline form does not allow this. I created a mod and renamed the form so as to avoid any confusion. Only the specific person requiring the mod has access to this form. It stopped working after the upgrade because the code setting a sequence number was removed from the pre-insert trigger. The error message we were getting indicated the value in the seq field was null. Hopefully this fixed the problem.
Posted by wendlerb at 10:06 AM | Comments (0)
September 14, 2005
Grade Rolls (cont)
We also get some om invalid field of study. It appears the SCT script we ran for the 4 modules didn't catch everybody. The work around for the form SFASLST involves finding the student major or field of study that is causing the problem, going to the STVMAJR form, validating the code, rolling the grade, and then going back to STVMAJR and restoring the code like it was previously. Once the individual rolls he will roll fine in other classes even though the major code is back to invalid. The mass roll is another problem. Any invalid code will abort the process. I propose we activate all codes, do the roll, and then restore the table.
Posted by wendlerb at 11:49 AM | Comments (0)
September 13, 2005
Grade Rolls
We're having a problem with some individuals with an invalid major doing a grade roll from the form SFASLST. They get the API error message:Invalid Field of Study major code. This particular person won't work in production or test so it's not something didn't get updated correctly in a package. I have brought up other CRN's in test, invalidated the majors of the students, and had them roll just fine. So why is this guy different? Jeremy and I are both looking at it and actually registered the guy for a different class in test and had it work.
Posted by wendlerb at 10:34 AM | Comments (0)
June 3, 2005
The SIS - FIS/HR link
At WOU, SIS and FIS/HR are on two separate databases. The production databases are wouprd and wops. We have tied the two systems together through the individual’s spriden id records and a Saturn link. We want an employee or student to have the same id in both systems. In order to do this we had to choose one database spriden table to hold the records for both systems and in our case, it’s the FIS/HR spriden table. The spriden records you see in SIS come from a view of this FIS/HR spriden table. There is actually no spriden table in SIS.
Baseline Banner uses a sequence to generate a new V number id and a table to generate new pidms. Our mods have not changed pidm generation and thus an individual’s pidm on FIS/HR is different from the same person’s pidm in SIS. The baseline spriden table in FIS/HR was modified to include a column (spriden_wouprd_pidm) to cross reference the two pidms. V number id generation is another story. One sequence has to be used for both systems. In order to do this a table trigger on the FIS/HR spriden table is used to generate a new V number spriden record when a new ssn record is inserted into the table. In the case when “GENERATED� is used to create a spriden record, the spriden record with the id “GENERATED� is actually inserted into the table causing the trigger to fire and creating another V number record. The record with the id of “GENERATED� is later deleted in a post-insert trigger form mod.
Posted by wendlerb at 8:41 AM | Comments (0)