« December 2011 | Main | February 2012 »

January 27, 2012

Degreeworks

I spent some time this week looking at the Degreeworks documentation. There's some scripts in the degreeworks_home/local/sql directory that we can use to configure which students and staff have degreeworks logins. There's also a way to load in individual logins from a text files. When we go to production, we won't need to worry about creating individual logins because we can setup the system to use Banner self service to authenticate users.

Posted by soukupm at 3:40 PM | Comments (0)

Leave accrual - non-standard updates

I finished my non-standard update scripts and ran them in production on 1/24/12. After running the scripts, some leave accrual balances were still incorrect. I spoke with Payroll and found out that the leave accruals were off by a month. The leave in Banner is always off by a month. For example, when we run leave accruals for January, the leave data is actually from December but it posts in Banner as January leave. I ended up rerunning the non-standard updates again and posted them to the correct month.

Posted by soukupm at 3:25 PM | Comments (0)

January 20, 2012

Leave accruals - non-standard updates

I've been working on two scripts to do a non-standard update to the leave accrual tables in Banner: perleav,phraccr,perlhis. A lot of employee's leave accruals are inaccurate in Banner so I'm going to reload all of the leave accrual data from spreadsheets from the Payroll office starting from July 2011. The first script will reset all of the prior balances back to July's beginning balance and zero out the used and accrued leave. The second script will reload all of the month to month leave accrual data.

Posted by soukupm at 3:15 PM | Comments (0)

Leave Accrual - PZPLEAV

I rewrote the leave accrual loading process in perl so it's easier for us developers to run. I added some new columns to the table pwbleav (temp table for holding the leave accrual data). The new columns are furlough and special leave:
pwbleav_furl_prior,
pwbleav_furl_used,
pwbleav_furl_acc,
pwbleav_furl_bal,
pwbleav_extr_prior,
pwbleav_extr_used,
pwbleav_extr_acc,
pwbleav_extr_bal

Posted by soukupm at 3:05 PM | Comments (0)

January 13, 2012

TWBKLOGN mod

I made some changes to TWBKLOGN so that it redirects back to the portal even if an ldap exception occurs. This package was also missing the http_header_close statement when it encounters an exception so I added that. I created a table to capture errors (wtailor.web_error). This can be used to debug any login problems via the portal.

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

TSRCBIL Mod

I made some changes to TSRCBIL (student bills) and modified the OMR Pitney mark code. Neopost notified the business office that our Pitney mark is not correct and the line needs to be 0.708mm thick. We had it set to a thickness of 1mm. I saved a copy of the Hp-GL/2 reference guide on my public_html folder just in case I need to make changes in the future. The guide is named HPGL2-RTL_ReferenceGuide.pdf.

Posted by soukupm at 3:16 PM | Comments (0)

January 3, 2012

Grade change request - changing email address

To change the email address for the Division admin, look in the package code for wou_grade_chg and search for @wou.edu and replace it with the new division admin's email address. There should be two entries that will need to be changed in the code. Also make sure to change the Vnumber and pidm in the table regis_grdchg_div.

Posted by soukupm at 2:11 PM | Comments (0)

Non-standard update fro TZREDRG

I did a non-standard update for the table TZREDRG (a custom table that holds information about whether a student is setup at the bank for e-disburse). Some students were incorrectly flagged as ready to receive disbursements when they actually were not setup at the bank. I changed these students back to a status of "SENT".

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