Author Archives: Marcella Smith

Update from Administrative Systems

Submitted by Marcella Smith

Here’s what we’re doing:

* Working on change management methodology for the lockdown project
* Hyperion System 9 preparations
* Banner 8 research, new functionality investigation, and database cleanup


* In a cooperative effort between the Administrative Systems group, Database Applications and Systems group, the Budget Office and the CCAL office, a new application for student organization budget reports was put into place for the start of fall term (as reported in the recent issue of Unbound).
* Developing new journal upload for Reprographics
* Working with Facilities Services to get P-card file uploaded to FAMIS
* Analysis of load process for potential loading of Monterey budget adjustments
* Applying Banner patches to all Banner modules (version 7)</
* Acting as change management lead for promoting objects into Production database


* Analyzing and preparing data for Monterey general student data load to enable programmatic email account generation
* Implementing Banner security, review and cleanup of Banner Student module access
* Cleaning up Hyperion folders, removing unused reports, removing outdated access to reporting groups
* Developed new Hyperion dashboard for Donna McDurfee in the office of Academic Affairs


* In conjunction with Karin Hall-Kolts in the office of the Dean of the College, implementing the 4/2 residential life system in the Commons (junior and senior room designations will be tracked with a singular commons code scheme).
* Setup access to housing reports for Keith Bishop in Public Safety
* Working with other LIS staff to resolve directory population issues


* Open Enrollment changes and enhancements for 2009
* Spending a significant amount of time on the Hyperion and Banner upgrades (learning about what’s changing and database cleanup work
* Set up scripts to enable the Student Employment Coordinator to terminate student jobs en masse at the end of the summer
* Researching problems, assisting HR with cleanup of data entered incorrectly, and changes to move from summer to fall term


* Conducted workshop on how to identify and correct Banner duplicate person records, which was very popular and well-attended by staff from Admissions, Registrar’s Office, College Advancement, Language Schools, Bread Loaf School of English, and LIS
* Analysis and research for Monterey general student data load to enable programmatic email account generation
* Assisting John Nordmeyer in resolution of duplicate person data, debugging SQL code used in Hyperion reports, and changes to the Alumni Program application
* Educating himself on the Student Employment module and the payroll data feed to the Financial Aid module; working with Student Financial Services to develop a way to ensure award amounts are not exceeded when work study funds are exhausted
* Training users in the Bread Loaf School of English; resolving change of term issues on inquiry reports; correcting duplicate person data


* Developing two new applications for Public Safety, Open Container Citations and Fire Safety Violations, which will include new Oracle forms, shell scripts, and several PL/SQL scripts to post fines to the Banner Accounts Receivable module


* Banner 8 work has begun with the build of a new database with UTF8 character set; installation and testing of new Oracle application server software; cleanup and reorganization of tablespaces; testing a new Pro C compiler which Mark installed for us on diamond
* Managing work for lockdown project (creation and maintenance of Oracle data privileges and developing Banner change management process)
* Automating startup of Banner java payment client for Banner credit card processing
* Implementing Financial Aid Self Service as a separate product (for delivery of upgrades independent of the Student Self Service product
* Attended NERCOMP IT Manager’s Workshop in Boston
* Setup and review of Banner accounts for student work study employment across campus