August 29, 2007
Steering Meetings Notes
FIS Warehouse:
New lead programmer introduced.
New steering commitee formed.
New features of Bi-Q 9 shown. The export to excel is very nice. Documentation on main menu buttons now.
Priorities set
May need to get report writer working on the thin client
New web page with queries common across 5th sites
HRIS Warehouse
New main menu buttons actually now has stuff like data dictionary that gives banner source for fields.
History added to jobs. Can be transactional or periodic. Transactional given highest priority.
Rank and tenure information requested to be added.
Posted by wendlerb at 10:05 AM | Comments (0)
June 7, 2007
IDTS Status
IDTS is the OUS wide project to transfer high school transcripts from the high school to the college via EDI. Overall, the high school sends a transcipt that goes to an OUS sever which in turn sends it to an EDI server in Texas which sends it to us. The second part of this project is a Bi-Query model (IDTS) that lets you query high school transcript records. Here is where we are at today:
We have sucessfully recieved a transcript sent from an Oregon high school via EDI.Smart and sent an acknowledgement. These will show up with Nathan's normal college transcripts.
I have installed the model tables locally on aero and have sucessfully loaded them with test data from OUS. We are in the process of setting up a nightly cron job to do this automatically. The Bi-Query model is on the V drive next to the others. The connect file for it is aero.con This model uses Bi-Query version 9.0.1 and will not work with older versions. Currently, Dorothy is the only user with the 9.0.1 installed. Let me know who will be using the IDTS model and we'll install 9.0.1 on their machine. The HR and FIS models still require 7.0 OSU is looking for someone to inspect the quality of the data for the next month or so.
Posted by wendlerb at 9:08 AM | Comments (0)
April 18, 2007
IDTS
IDTS
Corvallis sent us a preview of the biquery model they designed for the electronic high school transcripts. I set up the tables behind it on Aero and gave it the IDTS scheme. Had to do a little editing on the model to change the database name on all the objects.
Posted by wendlerb at 10:36 AM | Comments (0)
April 17, 2007
SIS BiQuery Model
Mike and I came up with a fairly basic sis model for BiQuery since we were having so many problems with Jeremy's old one. We have an accounts receivable module and a admissions module. Admissions has been most affected by the loss of Jeremy's model so we used his functions and logic to create views on wouprd and then brought them into the model. The user logs into wouprd using normal Banner password.
Ran into some problems with access for normal users so ETS had to grant these users additional priviledges than normal. Found they could see a table with no problem but couldn't see a view. Response time to the admission piece has been much quicker. Using th sis spriden view slows things way down since there is no way to join with the compiler hint. Suspect this won't be a problem after the database merge.
Posted by wendlerb at 8:39 AM | Comments (0)