The Evergreen State College Administrative Computing Project Tracking Outline Projects 2.9.2 HECC requirement to accept EDI transcripts from community colleges 2.9.1 Implement Banner Web for Recruitment & Web for Admissions Priority Status high 3-n/a Area Admissions Contact Leona Walker Estimated Estimated Start Complete Hours Date 0% 120 hrs n/a End Date n/a Last updated: 3/26/20083:33 PM high 4-on hold Admissions Leona Walker 0% 0 hrs n/a n/a Staff Notes Lead Might be a requirement Dale depending on HECBoard decisions. Hired consultant to do this Tony work. Will implement after web credit card pymts system to collect admissions fee. Must be done to replace NOLIJ and CollegeNet. Banner 7.1 upgrade affected NOLIJ and it's not supported. Ralph 1.8.6.5 Update Interfaces from Ruffalo Cody to Banner high 1-in process Advancement Debbie Garrington 0% 120 hrs n/a 1.8.6.7 Auto write off of annual fund pledges high 2-scheduled Advancement Jo Vaughn 0% 100 hrs n/a 1.8.6.6 Process to make constituents from SOAFOLK 2.6.3 high 3-n/a Advancement Jo Vaughn 0% 80 hrs n/a Automatic address correction updates high 3-n/a Advancement Jo Vaughn 0% 40 hrs n/a 2.1.16 Dup pidm cleanup scripts for advancement 2.6.1 Implement Web for Alumni/Development medium 3-n/a medium 3-n/a Advancement Jo Vaughn Advancement Sharon Harrison 0% 0% 100 hrs 40 hrs n/a n/a 12/15/06 March 1-April 16: Phased implementation of information returning to Banner.... 06/01/06 Auto Write Off of Annual Fund Pledges by the end of each FY. (Need by June 2005) n/a Here at the University of Idaho we have built a form that helps migrate... n/a This was a request from Advancement, but has additional possiblities for the mailroom. Ralph has the documentation that Alsion got from SUMMIT on this topic - it is a system developed by Western. Could be used by entire college - move to misc tasks. n/a n/a This is the implementation of Banner Web for Alumni/and Development Officers. Ralph Ralph Ralph Ralph Ralph D:\Docstoc\Working\ActivePDF\Input\$ASQOperating Capital Budget Request Report.xls.xls 18 2.6.2 Add APANAME equivalent to the Web medium 3-n/a Advancement Sharon Harrison 0% 120 hrs n/a n/a 1.2.2 Replace Form B system medium 3-n/a Budgeting Steve Trotter 25% 300 hrs n/a Last updated: 3/26/20083:33 PM This is a request to Ralph accommodate viewing preferred name type on the Web for Development Officers. 02/01/06 Possible use of system Randy Steve Trotter found. charter close to finalization for short term solution. Allow the entry of credit Tony card payments and verification over the phone. Still waiting on User working on contacting OFM for alternatives. Eastern Washington also has an alternative to this issue.... Randy 1.5.4 Web Credit Card Payment System purchase and implement vendor hosted solution. high 1-in process Business Services Collin Orr 10% 480 hrs n/a n/a 1.1.6 Automation of Finance Reporting n/a 5-done Business Services Collin Orr 100% 100 hrs n/a AFRS Automation - run from JOBSUB low AFRS Matrix - insert column and clean up Bank Reconciliation process automation in JOBSUB New implementation of the Grants Module 1.1.4 1-in process Business Services medium 3-n/a Business Services low 1-in process Business Services 3-n/a Business Services Business Services Clifford Fredrickson Clifford Fredrickson Collin Orr 50% 0% 80% 80 16 80 hrs n/a n/a 12/29/06 per Laura B. Not sure we want to use scheduler for daily processes. 12/31/06 n/a Randy Randy Randy 2.8.9 n/a Clifford Fredrickson Ladonna Herigstad 100% 60 hrs 1.1.8 Change payroll interface to consider low activity dates in exception processing 3-n/a 0% 80 hrs to comply with OFM change in data structure Jan-06 12/31/06 Randy still runs monthly; users should be able to run as needed. n/a n/a Remove. They're comfortable with the current process. n/a Dec-06 Problem: Payroll batches error out when fed because the fund used is not effective. This is especially true for grant funds that automatically terminate when the end date of the grant is reached. Updating the fund results in a current effective date which Tony Partha D:\Docstoc\Working\ActivePDF\Input\$ASQOperating Capital Budget Request Report.xls.xls 18 Payroll negative amount feeds twice because of interface treating it as an absolute value. low 3-n/a Business Services Ladonna Herigstad 0% 40 n/a n/a Last updated: problem. We PM This is still a 3/26/20083:33 Partha notice it immediately when we do the payroll transfer. Currently I have to fix it with a JV. It also causes issues in Bank reconciliation if I don’t get the JV done by month end. This only applies to the R03 records. If we process a refund to the employee then it posted correctly in the R05 record as a debit but posts incorrectly in the R03 record also as a debit so it doesn’t clear correctly – negative values seem to work fine otherwise. 2.8.2 Combine document reporting on n/a 3-n/a Payroll interface 2.8.4 Provide a way to maintain/update low 3-n/a FTE Table 2.1.17 Dup pidm cleanup scripts for Finance medium 3-n/a 1.3.22 Changing Util file in programs high Business Services Business Services Business Services 1-in process C&C Ladonna Herigstad Clifford Fredrickson Laura Bergman Technical team 100% 0% 0% 0% 8 hrs 40 hrs 100 hrs 80 hrs n/a n/a n/a n/a n/a n/a n/a Remove. No one knows what this refers to. Partha Randy Partha 1.8.6.10 Security plan update - require periodic password change Banner. high 1-in process C&C Team Leaders 0% 100 hrs n/a 03/15/06 This is clean up of util file Dale calls to prepare for unix conversion 06/01/06 This was a recommendation Tony from the state auditors. 06/01/06 Tony Security plan update - require high periodic PIN change for Banner self service (web). Security plan update - create a high process for dealing with stale dated PINs for Banner self service (web). Security plan update - create a high process for network/Banner account issuance/revocation/suspension/deleti on. Security plan update - user awareness training program Security plan update - update risk overview for admin systems high high 1-in process C&C Team Leaders 0% n/a n/a 1-in process C&C Team Leaders 0% n/a n/a 06/01/06 Tony 1-in process C&C Team Leaders 0% n/a n/a 06/01/06 Tony 1-in process C&C 1-in process C&C Team Leaders Team Leaders 0% 0% n/a n/a n/a n/a 06/01/06 06/01/06 Tony Tony 18 D:\Docstoc\Working\ActivePDF\Input\$ASQOperating Capital Budget Request Report.xls.xls Security plan update - create ecommerce security policy Security plan update - review HIPPA encryption requirements for compliance. Security plan update - assess risk of data loss and back up policies, data recovery processes - microfiche & imaging system. Review JOBSUB account usage and create work around 1.3.12 Migrate to Access 2003 high high 1-in process C&C 1-in process C&C Team Leaders Team Leaders 0% 0% n/a n/a n/a n/a 06/01/06Last updated: 3/26/20083:33 PM Tony 06/01/06 Tony high 1-in process C&C Team Leaders 0% n/a high high 1-in process C&C 1-in process C&C Technical team Technical Team 0% 10% n/a 40 hrs 1.3.25 1.3.27 1.3.33 1.3.34 Finaid 7.4 upgrade VMS Cluster Testing Fin aid upgrade - August Oracle 10G/Bannerdb on UNIX testing Unix training Replace job scheduler high high high high high high 2-scheduled 2-scheduled 2-scheduled 2-scheduled C&C C&C C&C C&C Technical team Technical team 0% 0% 0% 0% 0% 0% 20 hrs 40 hrs 20 hrs 40 hrs n/a n/a 06/01/06 Andrea is working w/internal auditor to obtain permission to use imaging system as official records. n/a meet w/Brian & Leona to determine need n/a n/a Will be moving to MS Access 2003 and skip 2000 because of problems with migrating datamart code in MS access 97. This reduced the time involved in fixing broken queries substantially. Mar-06 Mar-06 n/a May-06 n/a Aug-06 n/a Aug-06 n/a n/a n/a Aug-06 Jan-07 Tony Tony Tony Tony Dale Randy Dale 2-scheduled C&C 2-scheduled C&C James might be purchased Tony solution or written in house Partha Ralph Randy Tony Ralph Dale Dale Debbie Randy 1.3.21 Banner Self serve development low walkthrough 1.3.23 Walkthrough/training of local mods to low forms and forms in general 1.3.24 Evisions walkthrough for the team low 1.3.26 Implement Clientelle for the team 1.3.28 Adhoc Reporting Cleanup 1.3.31 Address Function improvement 1.3.32 Datamart Optimization 1.3.29 Version Control solution 2.8.7 Archiving Banner Data - process for long term storage low low low low high low 2-scheduled C&C 2-scheduled C&C 2-scheduled C&C 2-scheduled C&C 2-scheduled C&C 2-scheduled C&C 2-scheduled C&C 2-scheduled C&C 3-n/a C&C Technical Team Technical Team Technical Team Technical Team Technical Team Technical Team Technical Team Technical team Technical team 0% 0% 0% 0% 0% 0% 0% 0% 0% 10 hrs 10 hrs 10 hrs 100 hrs 160 hrs 40 hrs 150 hrs 100 hrs 100 hrs Apr-06 Apr-06 n/a n/a Apr-06 Apr-06 Jul-06 Jul-06 Jun-06 Jun-06 Jul-06 Jul-06 Aug-06 Sep-06 n/a n/a 11/01/06 may build or buy it. n/a D:\Docstoc\Working\ActivePDF\Input\$ASQOperating Capital Budget Request Report.xls.xls 18 1.3.1 Simplify and speed up TESC_ah_detail view low 3-n/a C&C Technical team 0% 16 hrs n/a n/a Last updated: 3/26/20083:33 PM This needs to be Tony streamlined in order to be placed on the datamart. Also TESC_AS_STUDENT DATA view - same situation.The extracts that we received were only partial data so that we could look at demographic trends for enrolled students. Many of the eleme 1.3.30 Taking out digital Trash Datamart expansion to include finance 2.4.1 Transfer history view of data low low low 3-n/a 3-n/a 3-n/a C&C C&C C&C Technical Team 0% 0% 0% 80 hrs n/a 40 hrs n/a n/a n/a n/a n/a n/a View of Transfer History Data modified from Object Access View for reporting purposes. THis will only be needed if the system begins slowing down with users running jobsub requests during the day. It enables the user to use the date/time options that currently are not functional on the banner jobsub screen. Debbie Randy Dale 3.1 2.4.2 TSS Workorder tie to CAFM Connect the CA Scheduler to JOBSUB low 3-n/a medium 3-n/a C&C C&C Rob Rensel Technical Team 0% 0% 0 hrs 120 hrs n/a n/a n/a n/a Tony Dale 2.11.4 Redo Campus Directories 2.11.5 Cable record database system 1.3.9 medium 3-n/a medium 3-n/a 4-on hold 4-on hold C&C C&C C&C C&C Technical Team Technical Team 0% 0% 0% 0% 200 hrs 200 hrs 80 hrs 20 hrs n/a n/a n/a n/a n/a n/a 04/18/06 n/a n/a Randy Roll out admin computing web page - low so it gets used! 1.3.20 Banner 7.2 upgrade low 01/16/06 Will do only if no academic Tony history impact - will give ipeds race/ethnicity upgrades for the system 12/31/03 IT web sites campus wide Tony are being evaluated and a recommendation is to be made to C&C Director for a total redesign. 18 1.3.8 Develop Admin Computing Web Page low 4-on hold C&C Technical Team 50% 80 hrs n/a D:\Docstoc\Working\ActivePDF\Input\$ASQOperating Capital Budget Request Report.xls.xls 2.3.4 Redo Counseling system database low 3-n/a Counseling & Elizabeth Health McHugh 0% 40 hrs n/a 01/02/04Last updated: 3/26/20083:33 PM This is similar to the health Tony services database in that it could connect to Banner and be cleaned up. Dale and I need to talk to the user together.The user has contacted me to setup the current system for fall. The process takes a couple of hours. Thei worked on RFP & hiring Tony consultant. After consultant delivers reports will need to assist with determining next step. researching technical Ralph solution and options Deans database requirements gathering, design & planning high 1-in process Deans area Amy Betz 50% n/a n/a 2.11.6 Evaluation Processing System Phase 2- next stage to get evaluations stored in the Oracle database - depends on storing formatted text 2.11.3 Student self eval - interim solution Evaluation Processing System complete Phase 1 requirements Evaluation Processing System Generate the RAA from Banner. high 1-in process Deans area Amy Betz 10% 300 hrs n/a n/a high high high 1-in process Deans area 1-in process Deans area 1-in process Deans area Amy Betz Amy Betz Amy Betz & Andrea CokerAnderson 0% 50% 0% 0 hrs n/a 160 hrs n/a n/a n/a n/a 1.8.3 n/a Dave Metzler is working on Dave prototype. see Amy Betz's project plan Ralph for details The RAA (Record of Ralph Academic Achievement) is currently typed manually from information printed from Banner. There are several solutions to this, one would be to take the baseline progress report and massage it through Evisions. Move the Evaluation red... 1.8.1 Evaluation Processing System financial aid report Evaluation Processing System Access reports for program secretaries high high 1-in process Deans area 1-in process Deans area Amy Betz & Brian Shirley Amy Betz 0% 60% 8 Feb-06 02/27/06 need to meet re: function to Tony select records. Ralph 1,100 hrs n/a 01/01/06 This project is an access database system for the program secretaries to track the status of evaluations.... n/a n/a This is taking time to get everything scoped and started out. Tony 1.8.4 Coordination of the Evaluation Process Redesign Project high 1-in process Deans area Amy Betz 85% 120 hrs D:\Docstoc\Working\ActivePDF\Input\$ASQOperating Capital Budget Request Report.xls.xls 18 2.11.1 Deans database implementation low 3-n/a Deans area Amy Betz 0% 1,000 hrs n/a 1.8.6.4 ILC/INT business process redesign high 4-on hold Deans area Amy Betz 0% 1,000 hrs n/a 1.8.6.4.1ILC/INT design work 1.8.6.4.2ILC/INT development work 1.8.6.11 Student self eval automation - long term solution 2.11.2 Student visit scheduling system. Evaluate vendor solutions available. 2.1.3 Install and implement SEM high high high 4-on hold 4-on hold 4-on hold Deans area Deans area Deans area Amy Betz Amy Betz Amy Betz Steve Hunter & Diane Kahaumia Steve Hunter 0% 0% 0% 0% 200 hrs 800 hrs 200 hrs 200 hrs n/a n/a n/a Last updated: 3/26/20083:33 PM Requirements gathering to Tony be outsourced, but this task is the development of the systems needed to support data management in the deans areas. n/a Very rough estimate at this Tony point - large web based system, prototype is complete. Includes incorporation of Banner Security and data. n/a Partha n/a Partha 09/01/06 Dale Added to Admin list but not Tony sure of implementation. n/a Implementation of the Strategic Enrollment Management functionality in BannerDelayed until after major go-lives are complete Scholarship processing is n/a currently tracked on an Access data base. This will continue until this project is undertaken. Michele Elhhart currently maintains this data base.This can be expanded to cover scholarships through advancement, fin aid, and d... n/a This could mean expansion Partha to areas such as Financial Aid, Admissions, AR, HR and Finance - need to determine priorities for this work.... n/a medium 1-in process Enrollment Feb-06 n/a low 3-n/a Enrollment 0% 320 hrs n/a n/a 2.1.1 Implement scholarship processing in Banner medium 3-n/a Enrollment Steve Hunter 0% 160 hrs n/a n/a Web Emergency Operations Center medium 3-n/a software 2.1.14 Expansion of Imaging applications to High 3-n/a Financial aid 3.2 Facilities Financial Aid Bob Worley Brian Shirley 0% 0% 0 hrs 200 hrs n/a n/a n/a n/a D:\Docstoc\Working\ActivePDF\Input\$ASQOperating Capital Budget Request Report.xls.xls 18 1.2.1 Complete migration of Powerfaids to Datamart high 4-on hold Financial Aid Brian Shirley 0% 80 hrs n/a 11/03/03Last updated: 3/26/20083:33 PM Per Anna turnover, not an James issue. David not concerned as much about failures - will put this on hold. Partha 09/29/06 Possibly look at the new imaging system as a means of storing this information. n/a n/a This is a leftover task from the RMS interface project. Collin to talk with Ken Holstein on this n/a Tony 1.8.6.1 Storage of ID cards centrally high 2-scheduled Housing Noel McHugh 0% 100 hrs n/a 2.1.18 Automate the RMS to Banner finance low interfaces 2.1.20 Applicant tracking system for HR low Evaluate vendor solutions available. 3-n/a Housing Noel McHugh Ken Holstein 0% 0% 80 hrs 200 hrs n/a n/a 1-in process HRS 2.1.19 Implement charges interface from the medium 3-n/a Parking system to Banner. Parking Susie Seip 0% 80 hrs n/a n/a I hope you have some time n/a and will take a moment and scroll down to the first email and read up. Parking and Student Accounts have been experiencing some inefficiency in reconciling Parking's A/R from Ticketrack to Student Accounts' Banner system. This Randy n/a 1.7.2 1.7 1.7.1 Other CIS Migration work CIS Migration Migrate all code from DataExpress low low low 3-n/a 3-n/a 3-n/a Payroll Payroll Payroll Ladonna Herigstad Ladonna Herigstad Ladonna Herigstad 20% 23% 40% 160 hrs 192 hrs 32 hrs n/a n/a n/a 05/18/06 Specifics TBD - whatever CIS needs from us… n/a 05/18/06 Meetings with CIS - they Randy converted a majority of the code already. Need to arrange training in January time frame. CIS is migrating their systems and all dataexpress functionality will go away. That will mean that all of the dataexpress code generat... n/a n/a 2.8.6 PPMS Online Time Sheets medium 3-n/a Payroll Ladonna Herigstad 0% 80 hrs n/a D:\Docstoc\Working\ActivePDF\Input\$ASQOperating Capital Budget Request Report.xls.xls 18 2.5.1 Uniform Crime Reporting low 3-n/a Police Services Chief 0% 80 hrs n/a n/a Last updated: 3/26/20083:33 PM This data will not be in n/a Banner at this time. It was identified as one of the external reports required for the institution. This could be accomplished with the proposes emergency operations center system. n/a 2.8.8 Implement Encumbrance system in Banner 1.8.6.15 Pechees Reporting Updates Add the college seal as a watermark to official transcripts low high high 3-n/a Purchasing 1-in process Registration 3-n/a Registration Kathleen Haskett Andrea Andrea CokerAnderson Andrea CokerAnderson Andrea CokerAnderson 0% 0% 0% 60 hrs 80 hrs 20 hrs n/a n/a n/a n/a 06/15/06 New files required for export Dale n/a This is new functinality that Partha can be used with the new imaging system. n/a I hope you have some time n/a and will take a moment and scroll down to the first email and read up. Parking and Student Accounts have been experiencing some inefficiency in reconciling Parking's A/R from Ticketrack to Student Accounts' Banner system. This n/a Thank you! n/a n/a Must complete the RAA n/a project first plus the tracking course equivalencies so that the data is available. Debbie 2.2.5 2.1.4 2.2.1 Expanding of duplicate pidm reporting low Improve process for academic Standing 3-n/a Registration Registration 0% 0% 40 hrs 160 hrs n/a n/a n/a n/a medium 3-n/a 2.2.2 2.2.3 2.2.4 2.2.6 Process to automate pre-registration for year long programs Write OSPI Report medium 3-n/a medium 3-n/a Registration Registration Registration Registration Automate immunization hold process medium 3-n/a Automation of linking RAA to the imaging system when it is produced. low 3-n/a Andrea CokerAnderson Andrea Coker Anderson Andrea CokerAnderson Andrea CokerAnderson 0% 0% 0% 0% 320 hrs 8 hrs 40 hrs 80 hrs n/a n/a n/a n/a n/a n/a n/a n/a 1.8.6.14 Banner work flow system analysis low 3-n/a Senior Staff John Hurley 0% 80 hrs n/a 06/30/06 This is to determine costs, options, and interest in implementing the Banner Workflow system that we purchased with Banner. n/a 2.1.2 Implementation of Banner work flow medium 3-n/a Senior Staff John Hurley D:\Docstoc\Working\ActivePDF\Input\$ASQOperating Capital Budget Request Report.xls.xls 0% 500 hrs n/a n/a 18 1.8.6.13 One card system analysis low 3-n/a Senior Staff & John Hurley & Business Collin Orr Services Student Accounts Student Affairs Tami Johnson Art Constantino 0% 80 hrs n/a 2.8.5 2.7.1 Upgrade to billing process/printing maybe use Evisions? E-Portfolios medium 3-n/a low 3-n/a 0% 0% 80 hrs 240 hrs n/a n/a 06/30/06Last updated: 3/26/20083:33 PM This is to determine costs, Debbie options and interest in a one card system implemenation n/a n/a n/a Kitty to check with Barbara n/a Smith - no admin computing work at this point. Payroll produces a report of n/a the hours that students have worked in workstudy. For go-live, starting in October 2001, this information will be manually entered into Banner for tracking against Financial Aid work study awards. It is the automatic update Tony 2.3.2 Payroll data populating Student Employment low 3-n/a Student Employment Michelle Bartlet 0% 120 hrs n/a n/a 1.8.6.9.1Student Internship Link (SILK) expansion - forms development to add student employment & community based jobs. high 4-on hold high 1.8.6.9.2Student Internship Link (SILK) expansion - self serve development to add student employment & community based jobs. 4-on hold 2.3.1 Replace disablility Access data base medium 3-n/a Student Employment, Internship & Community Based Learning Student Employment, Internship & Community Based Learning Student Services Kitty Parker 0% 150 hrs n/a 08/31/06 Kitty Parker 0% 150 hrs n/a 08/31/06 Partha Linda Pickering 0% 80 hrs n/a n/a The Disability/ Special n/a Services area is tracking more information on an access database than what Banner accomodates. The conversion of the DEC information and reporting needs have been addressed, this entails only the replacement of the Access data bas D:\Docstoc\Working\ActivePDF\Input\$ASQOperating Capital Budget Request Report.xls.xls 18 2.1.12 Tracking Proficiency Assessments for low acc???? Don't know what this is. 3-n/a Shannon Stewart 0% 80 hrs n/a n/a Last updated: the media loan PM This is what 3/26/20083:33 n/a system accomplishes - only allowing the use of certain rooms if a level of proficiency in the use of the equipment has been demonstrated. 1.1.2 AFRS - change in file layout required high by OFM 5-done Business Services Collin Orr 100% 100 hrs n/a 1.2 1.1.9 Close out legacy systems 1099 Support for 2006 - Address E and F charts high high 5-done 5-done Business Services Business Services Collin Orr Collin Orr 100% 100% 1,080 hrs n/a 80 hrs n/a This includes running the Randy manual process while getting an automated process place. Method has been established and tested. 12/30/2004 file layout is changed FTP is set up. One step launch, but analyst must do it. Putting it in Jobsub can come later. 12/31/06 Team 01/16/06 This problem will persist Randy next year unless SCT corrects the open defect so putting it into the plan n/a After Analysis was Ralph completed with Kate June 12-15 it was determined that there is not a way to track the faculty responsible for a students evaluation within baseline Banner. The recommended solution is to add one small table and corresponding form th... 06/30/05 Ongoing meetings and planning Debbie n/a 1.8.2 Tracking Faculty responsible for Eval high 5-done Deans area Amy Betz 100% 80 hrs n/a 1.8.5 ILC/INT committee work high 5-done Deans area Amy Betz 100% 60 hrs n/a D:\Docstoc\Working\ActivePDF\Input\$ASQOperating Capital Budget Request Report.xls.xls 18 1.5.3.1 Replace R25 or upgrade it high 5-done Facilities Patti Zimmerman 100% 120 hrs n/a 2.5.3 Operating Capital Budget Request Reports Wait list replacement choice high 5-done Facilities Paul Smith 100% 0 hrs n/a 1.4.2 high 5-done Registration Andrea CokerAnderson 100% 80 hrs n/a 1.4.3 Waitlist Letter high 5-done Registration Andrea CokerAnderson 100% 8 hrs n/a 07/05/05Last updated: 3/26/20083:33 PM TBD still. Now examining Debbie keeping R25 - had Demo June 7The new system will be the responsibility of Facilities, unless it is an R25 upgrade.This estimate s only for the Admin Computing effort on this project. Depending on solution could take significan... n/a Completed due to Tony emergency in Facilities at bienium. Partha 08/02/04 Currently a student can specify which class to drop if the wait list class becomes available. This needs to happen in Banner. Could be through a comment that the student enters about their preference or something like that. Otherwise there will need... 08/02/04 This report is created once Debbie a student is moved from the waitlist and into the program. It notifies the student that a waitlist movement has occurred and provide the student all of his/her enrollment for the quarter. Sample on FileCould use labels printed 07/05/05 Schedule information needs to be displayed on the web. Without Meeting place and time information in April, 2001... 07/05/05 If not implemented in CAFM this will happen by upgrading R25. n/a Completed mostly by end users with little support n/a they found a work around Partha 1.5.3.2 Dynamic display of Schedule Info on the WEB low 5-done Facilities Scheduling Team 100% 160 hrs n/a 1.5.3.3 Security Fix to R25 Speed book low 5-done Facilities Patti Zimmermen 100% 0.1 hrs n/a Debbie 2.8.3 2.6.4 Implement positive Pay for checks Imaging system for advancment n/a n/a 5-done 5-done Business Collin Orr Services Advancement Jo Vaughn 100% 100% 0 hrs 0 hrs n/a n/a n/a n/a 18 D:\Docstoc\Working\ActivePDF\Input\$ASQOperating Capital Budget Request Report.xls.xls 2.6.5 1.1.3 Process to get single household mailing addresses Office of Minority and Womens Business Enterprises n/a n/a 5-done 5-done Advancement Jo Vaughn Business Services Collin Orr 100% 100% 0 hrs 0.1 hrs n/a n/a n/a n/a Last updated: 3/26/20083:33 PM addressed by Banner n/a This report is used, but the data comes from FRS so the date due is 07/01/2003 to be refined later.Put on hold until decision on it's need. work around found will be part of deans database project Tony Modifications to Baseline FUPLOAD process 2.1.21 Web catalog project support for web team 2.3.3 2.8.1 n/a n/a 5-done 5-done Business Services Deans area Collin Orr Amy Betz & Susan Bustetter Steve Hunter 100% 100% 0 hrs 0 hrs n/a n/a n/a n/a n/a n/a E-mail distribution list connection with n/a Banner E-mail lists 5-done Enrollment 100% 0 hrs n/a n/a 2.10.1 Imaging implementation for financial n/a aid forms 2.1.5 Implementation of WEB HR from CIS n/a 5-done 5-done Financial Aid HRS Brian Shirley Ken Holstein 100% 100% 0 hrs 0 hrs n/a n/a n/a n/a A future nice to have would n/a be sending e-mail distributions from lists of email addresses. This is possible in WEB for Prospects that will be coming out soon with Web for Student and through Campus Pipeline - it will be entered as a future enhancement re n/a Policy work around security n/a to be completed - this has been implemented. - it was done without admin computing resources There is a need to connect n/a data entered in Police Services templates on events directly to a data base so that completing the form also updates a database for searching and reporting. Currently a former employee did set up a separate Access database t... they bought something Completed as project change for R25 project. n/a 18 2.1.8 Police Services Data Base n/a 5-done Police Services Chief 100% 0 hrs n/a n/a 2.1.22 Implement Web portion of R25 scheduling for requests and viewing n/a 5-done Space Scheduling Patti Zimmerman 100% 0 hrs n/a n/a D:\Docstoc\Working\ActivePDF\Input\$ASQOperating Capital Budget Request Report.xls.xls 2.1.15 Implement Budgeting system n/a 5-done Budgeting Steve Trotter 100% 0 hrs n/a n/a Last updated: year 1 is to The goal for 3/26/20083:33 PM n/a speed up the loading of budget balances in Banner from existing processes, this task to be prioritized to implement a common budgetting system that will feed Banner in the future.... Needs research - get back n/a to committee on time that may be involved and assess what is needed short/long term. - completed with R25 upgrade This report is used by Betty n/a McGovern to track program secretary Assignments. This data is currently not entered in BannerData is now in Banner for starting info - changes still not tracked in Banner for accurate reporting. This will document the n/a requests for enhancements to the Catalog/Schedule reports produced in Feb 2001.... This is needed to n/a implement faculty load reporting in Banner. Display of all other n/a schedule information on the web - probably static page format - to be determined.... 2.1.13 Changes to the display of schedules on the web - prior to CAFM n/a 5-done Registration Andrea CokerAnderson 100% 0 hrs n/a n/a 2.1.9 Faculty office assignment report n/a 5-done Deans area Amy Betz 100% 0 hrs n/a n/a 2.1.10 Enhancements to Catalog Schedule Reports n/a 5-done Deans area Amy Betz 100% 0 hrs n/a n/a 2.1.11 Implement Faculty Load in Banner n/a 5-done Deans area Amy Betz 100% 0 hrs n/a n/a 2.1.7 Display Non-Program Schedules on the WEB n/a 5-done Space Scheduling Kirk Knittle 100% 0 hrs n/a n/a 1.6.1 Noel Levitz first two download files n/a 5-done Admissions Leona Walker 100% 80 hrs n/a 1.6.2 Putting Noel Levitz batch download request into production Noel Levitz Regular files generation n/a 5-done Admissions Leona Walker 100% 80 hrs n/a 12/13/04 Emergency files prioritized Debbie in ahead of wait list processing. 10/11/05 Putting into production Partha original extracts Debbie did 01/31/05 Automation of the base files Partha and generation of regular files 18 1.6.3 n/a 5-done Admissions Leona Walker 100% 80 hrs n/a D:\Docstoc\Working\ActivePDF\Input\$ASQOperating Capital Budget Request Report.xls.xls 1.5.1 1.2.3 Implement Banner Budgeting Replace Position Control System n/a n/a 5-done 5-done Budgeting Budgeting Steve Trotter Steve Trotter 100% 100% 400 hrs 160 hrs n/a n/a 1.1.1 Development of Finance Management Reports n/a 5-done Business Services Collin Orr 100% 80 hrs n/a 1.1.1.1 Grants Report n/a 5-done Business Services Collin Orr 100% 40 hrs n/a 1.1.5 1099 support (upgrade and address E n/a and F chart issues) 5-done Business Services Collin Orr 100% 80 hrs n/a 1.1.10 Correct Duplicate payroll run problem n/a 1.1.11 Set up capital projects and new security for finance/budget/facilities n/a 5-done 5-done Business Services Business Services Production problem production problem 100% 100% 80 hrs 80 hrs n/a n/a Last updated: 3/26/20083:33 PM Maybe be solved with the Randy Position control resolution 07/01/05 Wil have a proposal for the Dale Budget coordinators. Proposal made and accepted with minor homework. Second meeting in May for final plan. 01/01/04 This is a place marker for Tony the development of up to 5 management reports depending on the needs of senior staff.This task needs to be broken out into the 5 requests first. 400 hours reserved in schedule for these tasks. n/a This is a grants report Tony Tony is working on and to correct the problems with Grants Veiws 12/15/04 There is no upgrade Randy needed, but the E and F chart issues will take time to accommodate also included Evisions upgrade and template download n/a Partha n/a Tony led a group to Tony configure faciliies capital projects to get needed reporting, set up rule class security so facilities and budget directors can now manage budgets in Banner Tony n/a 1.1.12 State Smart Buy Purchasing report 1.2.4 Replace Telephone charge processing system n/a n/a 5-done 5-done Business Services Business Services Emergency request Technical Team 100% 100% 20 hrs 80 hrs n/a n/a n/a 07/01/05 Pursuing purchasing a Dale package for this - much less time to implement.... D:\Docstoc\Working\ActivePDF\Input\$ASQOperating Capital Budget Request Report.xls.xls 18 1.2.5 Replace Copy system n/a 5-done Business Services Collin Orr 100% 40 hrs n/a 07/01/05Last updated: 3/26/20083:33 PM Currently the user is using a Debbie purchased package to collect the data. They are considering replacing the system. Like with the previous system , we would only be responsible for the monthly billing and interface with Banner. The estimate is assuming we 10/01/05 Gathering info from other Randy schools that have done this. n/a Provide assistance in analysis of request from Julian Pietras This request was expanded to include Marshall and Kathleen. Tony 1.2.7 Convert all IA history to Datamart n/a 5-done Business Services C&C Collin Orr 100% 320 hrs n/a 1.1.7 Report for Julian n/a 5-done Julian Pietras 100% 40 hrs n/a 1.3.2 Ensure Valid Archive data n/a 5-done C&C Technical team 100% 160 hrs n/a 1.3.3 Upgrade Datamart to handle snapshot files n/a 5-done C&C Technnical Team 100% 240 hrs n/a 1.3.4 1.3.5 1.3.6 Convert Library circulation processing n/a from powerhouse Jobsub to change media Loan Terms n/a Documentation of payroll processing system n/a 5-done 5-done 5-done C&C C&C C&C Technical team Techncial Team Debbie 100% 100% 100% 40 hrs 20 hrs 80 hrs n/a n/a n/a Debbie 01/02/04 As the system has been live, various requirements to maintain snapshots of Banner data have arisen. The most prevelant example has been the 10th day snapshot information. There is a task to manage this on the datamart howver - there is currently no ar Dale 03/01/04 Currently the datamart is rebuilt nightly- a second application needs to be built that will allow for the management of snapshot data to remain on the datamart permanently and be managed there. n/a Dale n/a n/a This is an internal goal to provide cross training in support of this technology Dale Partha D:\Docstoc\Working\ActivePDF\Input\$ASQOperating Capital Budget Request Report.xls.xls 18 1.3.10 Upgrade to Banner 7.x n/a 5-done C&C 100% 200 hrs n/a 1.3.11 Apply Banner 7.x baseline mods n/a 5-done C&C 100% 80 hrs n/a 1.3.13 Fin Aid 6.6 and possibly Student 6.2 with AH upgrade 1.3.14 Finance Patches 1.3.15 Oracle 9.2.06 n/a 5-done C&C Brian Shirley 100% 20 hrs n/a n/a n/a 5-done 5-done C&C C&C Collin Orr 100% 100% 40 hrs 20 hrs n/a n/a Debbie 11/01/05Last updated: 3/26/20083:33 PM Banner 6 will be desupported by December of 05 - so April is our only business process window to complete this. Testing will be significant because Banner 7.x is a total replatform of the software. Good in the long run, but it's like a new product! 10/03/05 Mods must be reapplied Ralph with every new upgrade to Banner 01/21/05 Student 6.2 is not needed, Ralph eliminates need to rewrite AH mod 02/18/05 Tony 07/20/05 This is an estimated date - Tony not release as of Jan. Will affect Pro-C and Pro-Cobol compiled objects Will take a Friday down day. n/a In test, will go to PROD n/a June 2 06/15/05 Will go to PROD right after Tony Finance 6.1 upgrade batch in June 08/08/05 Tony 06/01/05 We need to go to each Team desktop to implement this. 1.3.16 Upgrade to Finance 6.1, AR 6.1 1.3.17 Fin Aid 6.7 n/a n/a 5-done 5-done C&C C&C 100% 100% 40 hrs 20 hrs n/a n/a 1.3.18 Fin aid 6.8 1.3.19 INB Rollout and testing n/a n/a 5-done 5-done C&C C&C 100% 100% 20 hrs 60 hrs n/a n/a 1.3.7.1.1Implement INB (Internet Native Banner) n/a 5-done C&C Technical Team 100% 20 hrs n/a 1.2.6 Replace the Key system n/a 5-done Facilities Bob Worley 100% 100 hrs n/a 1.5.3 1.4.5 1.5.2 1.4.4 Resource 25 upgrad and interface project RMS interface fix Parking system reports Production development of Student Rool n/a n/a n/a n/a 5-done 5-done 5-done 5-done Facilities Housing Parking Registration Noel Susie Seip Andrea CokerAnderson 100% 100% 100% 100% 280.1 hrs n/a 20 hrs 20 hrs 40 hrs n/a n/a n/a 12/01/04 Turns out only minor Kelli training and phasing in areas will be required. Good News! 07/01/05 Ralph will be doing some of Team the forms work for this project. 07/05/05 n/a 03/11/05 Partha 02/08/05 Taken over from Barbara Tony due to other priorities 01/28/05 Debbie ran manual updates Partha in Fall -this needs to be put into Jobsub. 18 D:\Docstoc\Working\ActivePDF\Input\$ASQOperating Capital Budget Request Report.xls.xls 1.4.6 SZPPGPR Fix n/a 5-done Registration Andrea 100% 40 hrs n/a 03/11/05Last updated: 3/26/20083:33 PM Correct display of Extended Partha ed and other open credit and combined level activity. 04/14/06 Depends on scope of proposed project. 04/12/06 Debbie Randy 1.8.6.2 Expand R25 to serve Labs inventory needs 1.8.6.8 Expand Attention to: line on evisions po 1.4.1 Wait list edit - limit to 1 list high high high Move to 1 Move to 1 Move to 1 Labs Purchasing Registration Marty Beagle Kathleen Haskett Andrea CokerAnderson 0% 0% 35% 80 hrs 150 hrs 80 hrs n/a n/a n/a 08/02/04 This is an edit on the Web Partha for Student registration that would prohibit a student from registering in more than one Wait list.A work around could be created and through information published, we could inform students NOT to do it. The possibility for stu 04/03/06 James 1.8.6.12 Upgrade to R25 3.3 high Move to 1 Move to 1 1.8.6.3 Students will use Evergreen Email as high main communication from the college Space Scheduling Student Affairs Kirk Knittle Andrea CokerAnderson & Art Costantino Kitty Parker 0% 0% 20 hrs 100 hrs n/a n/a 1.8.6.9 Gather requirements and design high enhancement of the internship system (SILK) to accommodate work study and other employment opportunities for students. Evaluate vendor solutions available. Move to 1 Student Employment, Internship & Community Based Learning 0% 300 hrs n/a 02/01/07 Might take Evisions Randy purchase of e-mail functionality and interface to camp. Partha 09/01/06 This is a request from the Student employment area to develop a system that would track paid internships along with student work study and other employment for web access by students for searching for jobs. Perhaps can enhance SILK to address this need a n/a Student Credit Hours per n/a faculty memberThis report is generated manually now. Banner has been configured to produce this report in the future, but it is not needed for go-live 2.5.2 Sch/Fac. Is a component of Dean's database project not a separate project. low 5-done Institutional Research Laura Coghlan 100% 0 n/a D:\Docstoc\Working\ActivePDF\Input\$ASQOperating Capital Budget Request Report.xls.xls 18