February 3, 2012
Mods - hris32,PZRDUES,SWBXCOT
I made some modifications this week to a few scripts/programs.
HRIS32 - added some logic to not insert a record if there is a record with the same effective date to avoid constraint errors.
PZRDUES - added 'U2C','U2D','UDA' codes to the classified report.
SWBXCOT - added logic so it accepts lowercase "v" for vnumbers.
Posted by soukupm at 2:50 PM| Comments (0)
Degreeworks - Misc logins
I was able to create a generic login in Degreeworks by copying an existing account and modifying these fields:
shp_access_id - put the new login name here
shp_box_id - put the new login name here
unique_id - use a low number because this comes from a sequence number
unique_key - copy from existing account and change one digit,
shp_access_code - new password
Posted by soukupm at 2:43 PM| Comments (0)
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)