September 26, 2008
Changing Jobs
Moved to PCC
Posted by wendlerb at 8:35 AM | Comments (0)
September 9, 2008
CLM Overview
Campus Loan Manager
The business office manages Perkin's Loan information with this SCT application. The database behind it is a Microsoft SQL database named clm on the winchester server locally. You will need access to winchester, access to the database, and access to the web page front end. The financial aid accountant (DV) in the business office is the clm administrator and access to winchester is given by computing services. The reports she generates from it for the most part use Crystal Reports.
There are two pieces you have to deal with as a programmer: The creation of a soil report which goes to the state treasury and the Banner link that creates automatic holds. The soil stuff is in another blog entry.
The web page is https://winchester/clm/. Use the database CLM Production. Go to the Office Mgmt tab and select system configuration parameters from the dropdown. Then select Student System Interface Configuration. You will see a screen with the link info to wouprd along with info on the automatic hold process. You need a userid and link of someone's Banner account to get the connect string to work. They need maintenance Banner access for the link to connect. It uses a Microsoft Data Access Client to do the link which is a little different than Oracle's. The hold buttons are setup by the business office. If everything is correct, you will see a count of holds on the bottom.
Posted by wendlerb at 10:17 AM | Comments (0)
Perkin's Soil Overview
his file comes from CLM (perkins loan data) Microsoft SQL database which is located on winchester
First thing you do is make a backup of the table szasoil
Remote into the server winchester
Start Enterprise manager
Choose the CLM database
Under tools, start SQL Query Analyzer
Open the file soil_current which is in a folder clm in the programmers folder.
The file is a union query. You need to increment the seq no on both sides of the union. It is currently on 7. Save the file with the new seq no.
Run the query and then save the result in a file called soil.csv
close Enterprise Manager, SQL Query Analyzer, and exit winchester
FTP the soil.csv file over to apollo sqlload it into wouprd using the control file soil.ctl
run szrsoil.exe This creates the soil file for the business office that they send to revenue
Posted by wendlerb at 10:13 AM | Comments (0)
Ofax overview
Where to start?
Ofax uses the temp table ryrotmp to load the flat file in wouprd and the table ryrofax which is behind the form RYAOFAX.
The Banner program, szrofax, creates a file which gets uploaded to the ofax web site https://secure2.osac.state.or.us/fao/ You run szrofax from Banner job submission and print to database so you can grab the file. You can get login info to the state web page from financial aid. You upload the file and then download a return file. This file,ofaxout.csv, contains info from all institutions in the the dual enrolled student's program. It gets ftp'd to wou_sis$disk:[wouprd.ftp.fafsa].
This file often has the last character of a date missing on one record which will foul you up. The leading 0's on SSNs also often get dropped.
The program szpofax converts data in ryrotmp and inserts into ryrofax.
The terms of all institutions in the ofaxout.csv file have to be the same.
At the start of a term, I usually make delete and recreate a backup table of ryrofax. There is a delete statement in the program szpofax that will error out if no data exists in the new term. I left this in to prevent the cron fron processing the first entry in a new term. You save yourself a lot of headaches if you check the file to make sure all the terms are the same and run szpofax
while commenting out the delete statement for the first run. Financial aid runs it at the end of the term to get grades and often the next run has mixed terms
Posted by wendlerb at 9:47 AM | Comments (0)
September 8, 2008
Fac/staff directory creation
The pictures that telecom take need to be renamed to the appropriate V number for each person.
Install Adobe photoshop 7.0 om your computer. In the programmers folder under ucs you'll see a folder called Adobe Photoshop 7.0 Settings. Copy this folder to c:\documents and settings/userid/application data/Adobe/Photoshop/7.0 This is where batch settings for photoshop get stored.
Open up the jpg pictures from telecom. Click on the upper left "Rectangular Marquee Tool" on the tool bar palette. Up above put Feather : 0 px Style: Fixed Aspect Ratio Width: 225 Height: 225
Frame the person's head and then click on image and then crop. Save the cropped image as a tiff file with no image compression.
Place these new tiff files in a seperate directory. When you have all the tiff files done, you're ready for the next step.
Click on file,automate, and batch. In the popup window, select the action directory_photo from the dropdown choices. Select the folder you put all the tiffs in as your source folder and whatever destination folder you want. When you click ok, all the tiffs will be processed one at a time. This creates the photos.
There is a Banner job pzrcdir that creates the directory info for fac/staff in a file. This file and the photos get used by a perl program Mike S runs that creates the directory.
Posted by wendlerb at 1:13 PM | Comments (0)
Feed
TGRCLOS runs nightly before the feed kicks off. It closes and finalizes the cashiers sessions. A cashiers session will not be fed until it is finalized. The feed itself runs nightly in the cron job SWBUGLF. This is a com file that goes through a series of steps to complete a feed. This takes records form A/R and student and feeds them into the FIS system on Banner. This includes the accounting for checks done in SIS.
The first part of the feed is unapplication of payments and application of payments. TGRAPPL has only aborted once in about 10 years when a detail code from housing was fed into Banner from a third party software incorrectly. We had to fix a bunch of
tbraccd records after manually unapplying them.
TGRFEED is the main program that feeds stuff across. It puts records into tables gurfeed and gurapay that gets picked up by the FIS part of the process. If the feed bombs in the middle of tgrfeed, your best bet is to reset the feed and start over. There is a script, feed_reset.sql, that shows you how to do this. It is the usual spot where a feed bombs
Furfeed list the fdocs generated, tgrrcon is a A/R report, tgrcshr is the cashier report. The generated index report shows the SIS checks that fed across. These are all just reports
The FIS side starts up around step 16. This sets up posting and accounting for the records coming across. It's important to note you can run these FIS steps manually one at a time without hurting anything. So if you run into a problem in this section, you
don't have to back out all the stuff in the first half of the feed.
A common thing that happens is the printer runs out of paper and then queue stalls overnight. When you restart the queue, you get an error message for the lis file. Just go to the ban_spool directory and reprint the files that are missing.
Posted by wendlerb at 12:43 PM | Comments (0)
September 4, 2008
HB 3509
This is a series of reports that get run each year for A/R over in the business office. There are four categories.
Student Tuition and Fees
TUI,FEE,TUN,DCE,IED,NRF
Auxillary Enterprises
HOU,MEA,AUX,PHO,COU,TR,BKS,ATH,PAR
Student Aid
INS
Other Revenue
ADM,APF,AR,ART,ASW,BIL,CAS,CSH,CNT,DEP,FA,GRN,INT,LIB,QCD,MUS,NON,RFA,TRN,TRV,SCI,SIN,EXM,RET,CAR
The program is tzrlate.pc
Increment the Dec 31 year in the get_trans procedure and main select statement
Run it 4 times with the appropriate tbbdetc_dcat_code statement
Posted by wendlerb at 1:51 PM | Comments (0)
Troy Dimms
There are 3 Troy 4100 series check printers on campus. W_MONEYMACHINE is the AP checkprinter. W_SISCHECK is the cashier's printer for SIS checks. W_CHA_CHING is in feepayment and is a hot backup for either sis or ap printers. Remember that the Banner queue is tied to the ip address determined by the network card in the printer. Each printer has 2 dimms. One is troy firmware and one is ours. Moneymachine and cha_ching both have our check images in dimm 0. Sischeck has them in dimm 1. You can't change this. It is determined by what Troy initialized their own dimm to
In order to move files back and forth, you need to pull the network card, hook up to the printer with a bidirectional cable on lpt1, and add the printer to your machine on lpt1. The files that go in there are in the business office group.
SIS all on dimm 0:
DARIN.all
LOGO.all
PAGE0.all
SEAL.all
FIS all on dimm 0:
DARIN_AP.all
LOGO_AP.all
PAGE_AP.all
SEAL_AP.all
Initialization file:
INIT0.all
Print test:
TEST1.all
In order to execute one of these files you have to run from dos in the appropriate directory the command....... copy filename.all lpt1: They either copy a macro to the dimm or in the case of test1,make a test printout of the macro. You will see the printer flash processing job if you are talking to it correctly
The software used to generate these files is tform.exe from the versacheck disk. You create a numbered macro and then go to flash/dimms under print and download to a file
SISCHECK is all on dimm1 and the sis files above won't copy over. They're ponted to dimm 0. You can either try editing them to dimm1 with a binary editor or using tform. In tform you would open filename.grp. Go to file/print/RAM-FLASH-DISK. Select the lpt1 printer in the Driver/Port. Choose the fsa xxxx Device 0 or fsa xxxx Device 1 depending on which dimm you want the macro to go to. Select download and download to file.
Posted by wendlerb at 9:17 AM | Comments (0)
September 3, 2008
Campus Loan new input field
szppkld generates the clm input file
This new code (grade level) goes in record 1 space 101. The ; gets moved back to space 102.
Office Management / Coded Data Values – This update includes a script that will update the CDV’s for academic levels.
Verify the values in CDV field, NSL_ACLVL represent the academic levels as listed in Table B-13, Appendix B of the NSLDS Perkins Data Provider Instructions, June 2007.
Table B–13: Academic Level Codes
Code
Grade Level
1
Freshman / First Year (Including proprietary institution programs that are less than 1 year in duration.)
2
Sophomore / Second Year
3
Junior / Third Year
4
Senior / Fourth Year
5
Fifth Year / Other Undergraduate (May include sixth year undergraduate and continuing education students.)
A
First Year Graduate / Professional
B
Second Year Graduate / Professional
C
Third Year Graduate / Professional
D
Beyond Third Year Graduate / Professional
G
Graduate / Professional, Year of Study Unknown
N
Not Available (Used only for loans with Date of First Disbursement prior to July 1, 2008.)
Posted by wendlerb at 10:49 AM | Comments (0)