Loading...
HomeMy WebLinkAboutResolutions - 2006.05.25 - 28248REPORT (MISC. #06096) May 25, 2006 BY: General Government Committee, William R. Patterson, Chairperson IN RE: MR #06096 — OAKLAND COUNTY CRIMINAL JUSTICE COORDINATING COUNCIL — REQUEST FOR FUNDING FOR ADDITIONAL DATA NEEDS TO MITIGATE THE USE OF THE OAKLAND COUNTY JAIL AND RELATED PROCESS IMPROVEMENTS To the Oakland County Board of Commissioners Chairperson, Ladies and Gentlemen: The General Government Committee, having reviewed Miscellaneous Resolution #06096 on May 15, 2006, reports with a recommendation that the resolution be adopted. Chairperson, on behalf of the General Government Committee, I move acceptance of the foregoing report. GENERAL GOVERNMENT COMMITTEE General Government Committee Vote: Motion carried unanimously on a roll call vote. Miscellaneous Resolution #06096 May 11, 2006 BY: Public Services Committee, Jeff Potter, Chairperson RE: OAKLAND COUNTY CRIMINAL JUSTICE COORDINATING COUNCIL - Request for Funding for Additional Data Needs to Mitigate the Use of the Oakland County Jail and Related Process Improvements TO: Oakland County Board of Commissioners Chairperson, Ladies and Gentlemen: WHEREAS the Oakland County jail continues to experience significant overcrowding of offenders over the past several years; and WHEREAS the Sheriff recently declared a jail overcrowding state of emergency ultimately resulting shortly thereafter in the early release of inmates; and WHEREAS the Oakland County Board of Commissioners has established a Criminal Justice Coordinating Council (CJCC) to explore the use of the County's jail and alternative programs, process improvement, and data requirements for stakeholders who impact the jail's use, among other responsibilities; and WHEREAS a Jail Alternatives Subcommittee and associated study group of the CJCC was established comprised of members from the Sheriffs Office, Circuit Court, Community Corrections, Probation Department and other County Executive personnel (collectively referenced as 'stakeholders' herein) and has met to discuss and address additional data needs for their daily decisions involving the jail's use; and WHEREAS the stakeholders have developed a listing of data needs and process improvements that would serve to mitigate the jail's use; and WHEREAS on February 22, 2006, the Jail Alternative Subcommittee presented its recommendations for data improvements to the CJCC; and WHEREAS the new jail management system (IMACS) will have to be modified for an unfunded State mandate involving a crime victims' rights module; and WHEREAS the IMACS will require additional funding to complete as the projections of several years ago have proven to be short of the actual amounts now necessary to complete the project; and WHEREAS the principal projects identified by the stakeholders are summarized below: • Felony Plea Bind-Over Project. To improve efficiency of the felony plea program for the ten District Courts, the Prosecutor's Office, Circuit Court Case Management and Administrator's Office, and the Community Corrections Division by eliminating manual processes and redundant data entry across entities involved so that District Courts will receive real-time information. • Real-Time Judgment of Sentence Project. To improve efficiency for all criminal justice stakeholders in Oakland County by eliminating delayed mainframe or manual processes currently in place for the preparation of Circuit Court judgments of sentence or other Court orders so that the release or transfer of incarcerated offenders, when appropriate, will be expedited. and the cost associated with preparing and mailing orders and other documents will be eliminated. Public Services Committee Vote: Motion carried unanimously on a roll call vote. • GICC Business Intelligence Projects. A series of projects of a smaller dollar amount that involve: enabling the recently adopted Circuit Court letter of agreement involving accelerated release of inmates in an overcrowding situation; extraction of data from the State system for District Courts (largely for non-52"d District Courts' benefits) and other reporting needs. • IMACS Data Warehouse Project. The development of extraction of data programs and related efforts involving the new jail management system (IMACS) into the existing data warehouse application for use by the stakeholders. • Unfunded State Mandate. The State has recently passed legislation requiring specific requirements that will now have to be addressed by the IMACS vendor. • IMACS Short-fall. The County secured funding for this project several years ago. The original estimates were less than the present costs to complete the jail system. The jail system is a critical component of the collection of data necessary for informed business decisions by stakeholders concerning its use. WHEREAS a Designated Fund Balance of $1,500.000 has been created for the Jail Alternative Program Startup. NOW THEREFORE BE IT RESOLVED that the Oakland County Board of Commissioners supports the projects cited above and appropriates funding in support of the above projects. Chairperson, I move the adoption of the foregoing resolution. PUBLIC SERVICES COMMITTEE Project Name: Felony Bind over Process Project ID: DB6351FB Oakland County • Department Of Information Technology Project Scope and Approach _ Leadership Group: Courts Department: Circuit Court Division: Court Administration Project Sponsor: John Cooperrider Date Requested: 3/16/06 PM Customer No. 351 _ Request Type: Enhancement IT Team Name: Courts IT Team No: B Project Manager/Leader: Marc Groder Account 95195 Account Circuit Court Admin Customer Number: Description: Name: Circuit Court - Grant Funded? No Mandate? No Mandate Source: _ Project Goal To improve efficiency of the felony plea program for the ten District Courts, the Prosecutors Office, Case Management, Administrators Office, and Community Corrections by eliminating manual processes and redundant data entry across entities involved so that District Courts will receive the information in real time by October 2006. Business Obiective • To have in place an improved process that would allow the district and circuit court staff to coordinate the felony plea process in less time, with more immediate information and fewer errors. The improvements are anticipated to save approximately 20 jail days off case processing time for incarcerated defendants. • To allow for the electronic transmission of the names of the assigned circuit court judge and court appointed attorney and update the District Court Register of Actions prior to the bindover taking place. • To have in place an improved technology that provides an automated way for circuit court to generate a next scheduled event (arraignment, pretrial, sentencing) with date and time, and immediately transmit that information back as an update to the district court register of actions. Project Rev.04/13/2006 Form Rev. 411712006 10:24 AM Page 1 Project Name: Felony Bind over Process Project ID: DB6351Fq Oakland County Department of Information Technology Project Scope and Approach • To automatically write a final disposition to the Circuit/Clerk Register of Actions upon taking of the plea at district court Major Deliverables • Determine business changes for the District Courts, Prosecutors, the Circuit Court offices, Community Corrections, and the need for procedural changes. • Real time updates to the District and Circuit Courts Registers of Actions. • Ability to assign a next court appearance date other than arraignment after taking a felony plea in district court. • Development of validation tables for judges calendars. Approach • Eliminate the process of manually entering the arraignment or scheduling dates by automating through validation tables. • Expand the link the data between the District Court, the Prosecutors Office, and the Circuit Court. Benefits See Return on Investment (ROI) Analysis Document Form Rev. 4/17/2006 10:24 AM Page 2 Project Rev.04/13/2006 Oakland County Department of Information Technology Project Scope and Approach Project Name: Felony Bind over Process Project ID: DB6351FB Impact Number of Users 51 Divisions - Circuit Court Admin (4) - Prosecutors Office (3) - 10 District Courts (35) - Case Management Office (6) - Community Corrections (3) Leadership Groups Risk Business Environment High — Project will negatively effect the business environment if implementation is unsuccessful. Technical Environment Low - proven and previously implemented technologies Assumptions Staffing IT Resources will be available for the hours indicated per the attached project plan. The following non-IT staff (roles and resources) availability will be as follows: Role: Name Hours per Day Project Sponsor: John Cooperrider As needed Page 3 Project Rev.04/13/2006 Form Rev, 4/17/2006 10:24 AM Oakland County Department of Information Technology Project Scope and Approach Project Name: Felony Bind over Process Project ID: DB6351FB Facilities • • Technical • • Funding • • Other • • Priority Constraints • Exclusions Form Rev. 4/17/2006 10:24 AM Page 4 Project Rev.04/13/2006 Project Name: Felony Bind over Process arigariLID: DB6351FB Grand Total Estimated Development Hours: 5g2 C71 nnn Oakland paunty Department of Information Technology Project Scope and Approach PROJECT PHASE AUTHORIZATION Phase(s): Total Estimated A • •lication Services Hours: 582 Cos • i i. Total Estimated Technical Systems Hours: Cost: Total Estimated eGovernment Services Hours: Cost: Total Estimated CLEMIS Hours: Cost: Total Estimated Internal Services Hours: Cost: IT Application Services Division Manager Approval: Date: IT Technical Systems Division Manager Approval: Date: IT eGovernment Services Division Manager Approval: Date: IT CLEMIS Division Manager Approval: Date: IT Internal Services Division Manager Approval: Date: IT Resource Manager Approval: Date: IT Resource Manager Approval: Date: IT Resource Manager Approval: Date: IT Resource Manager Approval: Date: IT Resource Manager Approval: Date: IT Mana • ement A. • royal: A•oroved: Yes No Date: Reason: Preect Sionsor A. • royal: Title: Date: PROJECT SUMMARY Authorized Development (see above) Hours: 582 Cost: $71,004 Preliminary Estimated Development for Future Phases Hours: Cost: Project Rev.04/13/2006 Form Rev. 4/17/2006 10:24 AM Page 5 Title: Date: Oakland County Department of Information Technology Project Scope and Approach Project Name: Felony Bind over Process PROJECT COMPLETION AUTHORIZATION Customer Acceptance of Product: Date: Project Office Review: Page 6 Project Rev.04/1312006 Form Rev. 4/17/2006 10:24 AM •Dpen Workbench - Ifeloni/Hind civerPrDcass 705/28-1 111.452a-i Aatl .!5J Immmm Estimate Notes Sue Estimate • Cote W Sire Emmet= -Phase Level 411:7J- hale Phase Phase Phase Phase Phase Favorites Tyne ID Size Estimates 582 $71.004.00 NUM Oakland county Department of Information Technology Project Scope and Approach Project Name: Felon Bind over Process .1011 Resources) Elle Edit Yew ioDis ffridow 41- See Estimate (10% l^ 4•50Xi Master Planning Customer Reporting Status Reporting Closed Propel Variance Reporting Scorn Change Mini Proiect Approval Project Renegotiation Enhancement Budget esurance & Compliane Task Name 000000 - PROJECT MANAGEMENT 030000 - BUSINESS AREA REQUIREMENTS 050000 - TECHNICAL DESIGN 060000 - PROGRAMMING 070000 - IMPLEMENTATION 0E10000 - POST IMPLEMENTATION SUPPORT Estimate E envie Haus Coe 24 t15,128.0(1 24 $2228.00 35 54,270.00 359 543.790.00 15 51,830.00 25 53.050.00 Weekly Analysis Weekly Tracking protect Approval Puke Planning Executing Controlling Filters & Sons For HelP. Press 51 I Start My Web Silas on-. I T3 Microsoft Cut... s' 3 Internet Expl,.. +1 t..3 Felony Bmetaker ' Open Worthen— tt VI 94C AM J255 - marl/Menu_ I Page 7 Project Rev.04/13/2006 Form Rev. 4/1712006 10:24 AM Project Name: Real Time JOS Project ID: DE36352 Oakland*County Department of Information Technology Project Scope and Approach Leadership Group: Courts Department: Circuit Court Division: Business Project Sponsor: Kevin Oeffner Date Requested: 3/20/06 1 PM Customer No 357 Request Type: New Development IT Team Name: Rick Perry IT Team No: B — Project Manager/Leader: Mary Gaissert Account Account Customer Number: Description: Name: Grant Funded? No Mandate? No Mandate Source: Project Goal Improve efficiency for all criminal justice stakeholders in Oakland County by eliminating delayed mainframe or manual processes currently in place for the preparation of Circuit Court judgments of sentence or other orders of the Court so that the release or transfer of incarcerated inmates, when appropriate (MDOC, time served, etc.), will be expedited and costs associated with preparing and mailing orders and other documents will be eliminated by July 2006. Business Objective The current judgment of sentence process involves the judicial clerk making handwritten notes as the judge sentences a defendant. The court services officer, probation liaison, prosecutor's paralegal and the defense attorney are concurrently recording the same information. The clerk's handwritten notes are then used by the judicial secretary who enters the data in the mainframe application (JCCD), which updates the docket and Law Enforcement Information Network (LEIN) interface. The secretary then prints a copy for the Judge to sign and sends the judgment to the Clerks Office for entry. The secretary may also mail copies to the defense attorney and/or defendant. The information contained within the judgment is required by multiple County departments (Fiscal Services, Sheriffs Office, Reimbursement Division, Circuit Court Probation and others). The Michigan Department of Corrections provides the sentencing judge with a Pre- sentence Investigation (PSI) report, within 48 hours of the sentence date, per statute, however delays do occur, which often result in the adjournment of cases to a future date. The MDOC prepares PSI reports for the circuit judges by entering data in the State's OMNI computer system. Hard copies of the PSI are delivered to the judges chambers for the assigned judge, defense attorney and prosecutor. The preferred solution would be to import the OMNi data entered by probation officers in the OMNI system through an electronic interface, which could be used to Page 1 Project Rev. 04/18/2006 Form Rev. 4/20/2006 8:17 AM Oakland County Department of Information Technology Project Scope and Approach Project Name: Real Time JOS Project ID: DR6352JS populate form fields in a draft judgment of sentence, thus saving time for all involved through the reduction in redundant data entry. The process could also include the electronic transfer of PSI reports, which could be accessed and printed by the judge, defense attorney and/or assistant prosecutor. With respect to the judgments of sentence, original PSI data will need to be stored electronically for reference in case of amended sentence. As an alternative, if it is not immediately. possible to retrieve data from OMNI, judicial staff could enter the data manually, prior to sentencing, (rather than after the sentencing) if given ability to do so. This functionality must allow for the creation of a confidential draft copy of the JOS that can be reviewed and amended electronically, prior to sentencing. In addition, during the actual sentencing process the judge, clerk or other court staff could make necessary changes to the document while the sentence is being pronounced. This form should use predefined validation rules to assist in reduction of data entry errors and as a result reduce the number of amended sentences. On approval it should allow for the judgment to be electronically signed, printed, and distributed to the appropriate parties immediately following the sentencing. This process would eliminate the many handwritten, often differing notes currently being taken. Once the data is entered it should update the Mainframe docket and the LEIN system as is the current practice. LEIN updates will need to comply with the protocol required by LEIN. It should also write the JOS to a PDF for entry into the imaging system and route through workflow to appropriate staff for additional processing. Currently the data is stored and can be repopulated for use in amended sentences. A similar process will need to be in place for amended sentences. An existing application was written by IT to create order templates that allow judges and/or court staff to prepare orders in the courtroom. This application is similar to what would be needed for the JOS user interface. Major Deliverables 1) Development of a user friendly JOS screen with validation rules that is pre populated with mainframe case information and allows judicial staff to enter sentence information from MDOC's PSI report prior to sentencing. 2) Continue automatic real-time docket entries and LEIN updates based on the final JOS data. 3) Ability of Judge to electronically sign document and print. 4) PDF version of JOS that is electronically transferred to Clerks Office imaging system. Approach 1) Follow standard Project Management Office model. 2) Create SQL database to store Judgment of Sentence. 3) Analyze and document existing process. 4) Develop Visual Basic application to enter the JOS data elements and create the different Judgments of Sentence. 5) Provide confidential and secure environment for JOS data entered prior to Form Rev. 4/20/2006 8:17 AM Page 2 Project Rev.99/99199 Oakland County Department of Information Technology Project Scope and Approach Project Name: Real Time JOS Protect ID: DB6352JS sentencing. 6) Develop mainframe program to retrieve data elements from VSAM files. 7) Develop mainframe program to update Docket on mainframe and send sentence information to LEIN. 8) Develop Visual Basic process to "listen" for requests to update mainframe and send JOS to imaging. 9) Perform System Testing. 10) Obtain signoff of new application. Benefits See Return on Investment (ROI) Analysis Document Impact Number of Users — All criminal justice stakeholders Divisions — Circuit Court, Clerks Office, Sheriffs Office, Prosecutor, Reimbursement Division, Fiscal Services, and Oakland County citizens. Leadership Groups - Courts Risk Business Environment — Medium — project will require some changes to existing business processes at the local level. Technical Environment - Low — proven and previously implemented technologies Assumptions Staffing IT Staffing: resources will be available for the hours indicated per the attached project plan. Other Staffing: additional staffing will be available as follows: Role: Name Hours per Day Page 3 Project Rev.99/99/99 Form Rev. 4/20/2006 8:17 AM Oakland County Department of Information Technology Project Scope and Approach Project Name: Real Time JOS Project ID: DB6352JS Project Sponsor: Facilities • • Technical • • Funding • To be determined. Other • Electronic signatures will be accepted by MDOC and other stakeholders. • Change in process is approved by SCAO. • Court Rule allows for electronically signed document in lieu of paper for official copy. Priority - High Constraints • Exclusions • Does not include receiving electronic copy of PSI from MDOC. Form Rev. 4/20/2006 8:17 AM Page 4 Project Rev.99199199 Project Name: Real Time JOS DB6352JS Oakland County Department of Information Technology Project Scope and Approach • PROJECT PHASE AUTHORIZATION Phase(s): All Total Estimated Application Services Hours: 826 Cost: $100,772 Total Estimated Technical Systems Hours: Cost: Total Estimated eGovernment Services Hours: Cost: Total Estimated CLEM'S Hours: Cost: Total Estimated Internal Services Hours: Cost: IT Application Services Division Manager Approval: Date: IT Technical Systems Division Manager Approval: Date: IT eGovernment Services Division Manager Approval: Date: IT CLEMIS Division Manager Approval: Date: IT Internal Services Division Manager Approval: Date: IT Resource Manager Approval: Date: IT Resource Manager Approval: Date: IT Resource Manager Approval: Date: IT Resource Manager Approval: Date: IT Resource Manager Approval: Date: IT Management Approval: Approved: Yes Date: Reason: Project Sponsor Approval: Title: Date: PROJECT SUMMARY Authorized Development (see above) Hours: 826 Cost: $100,772 Preliminary Estimated Development for Future Phases Hours: Cost: Project Rev.99/99/99 Form Rev. 4/2012006 8:17 AM Page 5 Hours: 826 Project Name: Real Time JOS 1 Grand Total Estimated Development Project ID: DB6352JS Cost: $100,772 Oakland County Department of Information Technology Project Scope and Approach PROJECT COMPLETION AUTHORIZATION Customer Acceptance of Product: Title: Date: Project Office Review: Date: Form Rev. 4/20/2006 8:17 AM Page 6 Project Rev.99/99199 •10pen Workbench - [Real Time 305 -Stzslatkmates-ighassimikUtraVul."-tlittlili4,:gT,Aj Ede Olt vow Iools Windom deb dirk!) Resources) Favorites Size Estimates 10:1 rm--1 Size Estimate Core Welk Site Estimates Phase Level Num See Estimate (4O% to •513'&) Master Planning Customer Reporting Status Re Po iling Closed Protect Variance Reporting Scope Change Mini Project Approval Project Renegotiation Enhancement Budget Ssurance & ComplianP Weekly Analysis Weekly Tracking roiect Approve I Packs Planning Executing C o ntroll n g Filters & Sons For MekJ, press F 826 $100772.00 Oak!anti County Department of Information Technology Project Scope and Approach PrniAt 1b ip_3_631221S_ Project Name: Real Time JOS -11912(J 2 _lc Estimate — Nlot•s Type IC Phase 000000 Phase 040000 Phase 050000 Phase 060000-0 Phase 070090 Phase 080000 Task Name _ PROJECT MANAGEMENT _ BUSINESS SYSTEM DESIGN _ TECHNICAL DESIGN _ PROGRAMMING _ IMPLEMENTATION _ POST IMPLEMENTATION SUPPORT Estimate Estimate Hours Cost 185 $22,570.00 60 $6,100.00 37 $4.514.00 480 $58,560.00 37 $4,514.00 37 $4,514.00 Project Rev.99/99199 Form Rev. 4/20/2006 8:17 AM Page 7 Project Name: IMACS Data Warehouse Project ID: Oakland County Department of Information Technology Project Scope and Approach Leadership Group: Courts Department: Circuit Court Division: Court Administration Project Sponsor: John Cooperrider Date Requested: 3/31/2006 PM Customer No, Request Type: New Development Enhancement Customer Support Planned System Maintenance or Upgrade IT Team Name: eGovernment App Svcs IT Team No: Project Manager/Leader: Account Account Customer Number: Description: Name: Grant Funded? Yes No Mandate? Yes No Mandate Source: Project Goal To implement changes to the existing Criminal Justice Data Warehouse (CJDW) so that the existing mainframe jail files can be removed as a source system of information and the new Inmate Management and Cost Recovery System (IMACS) jail operational system will become the source for the jail portion of the CJDW. These changes will enable the CJDW to continue to be available for decision support and for support of the Criminal Justice Coordinating Council (CJCC) by March, 2007. Business Objective #1 Perform a Fit/Gap analysis to ensure that all necessary data attributes currently populated from the mainframe Jail files can ultimately be populated from IMACS. Major Deliverables Gap analysis document Approach Analyze the existing mainframe Jail source data file and DW load programs. Analyze the !MACS source data tables Analyze the gap between current and new data sources. Analyze the impact of those identified gaps on Database design, ETL processes, and Business Objects universes. Business Objective #2 Form Rev. 4/13/2006 11:48 AM Page 1 Project Rev.411412006 Project Name: IMACS Data Warehouse Prnict ID Oakland'County Department of Information Technology Project Scope and Approach Accommodate new Jail System as new data source of Data Warehouse and remove the mainframe Jail data files as a source. Major Deliverables Data Model Diagram Source to Target mappings Modified Informatica Extract Transform and Load mappings Modified business objects universes CJDW test plan User acceptance of CJDW test environment Approach Modify existing CJDW structure as appropriate. Develop and test Extract Transform Load processes using standard tools (Informatica and Trillium). Create a test plan and assemble a test group for CJDW test environment. Validate and modify Business Objects Universes. Identify and Validate sampling of reports. Implement changes in production environment. Benefits See Return on Investment (ROI) Analysis Document Intangible • Continue to contribute to a reduction in pending criminal dockets in Circuit Court (currently 38.8%) • Continue to provide support during jail over-crowding emergencies by providing valuable reporting to the Circuit and District Courts • Provide support to the Criminal Justice Coordinating Council • Continue to use to support better population management • Providing reporting regarding excessive adjournments can assist in expediting cases • Increase Courts' staff productivity by eliminating the need for manual reporting as it relates to jail population and case management • Reduce Total Cost of Ownership via Vendor relationship Form Rev. 4113/2006 11:48 AM Page 2 Project Rev.4/1412006 Oakland county Department of Information Technology Project Scope and Approach Project Name: IMACS Data Warehouse Project ID: Impact Number of Users 7 Business Objects Users and 34 Report Consumers Divisions Sheriff, Circuit Court, District Courts, Community Corrections, CJCC, General Public Leadership Groups Common Services Risk Business Environment Technical Environment Assumptions LOW — little or no impact to existing business processes. LOW — proven and previously implemented technologies. Staffing IT Staffing: IT Resources will be available for the hours indicated per the attached project plan. Other Staffing: Additional staffing will be available as follows: Role: Source System Expert: Source System Expert: Source System Expert: Name Hours per Day Marge Bozarth As needed Barb Hankey As needed Gwynne Starkey As needed Facilities • Work stations are provided to all the project team members. • Information Technology Meeting Rooms will be available as needed. Technical • Necessary tools and software will be installed on the team member's workstations. Form Rev. 4/13/2006 11:48 AM Page 3 Project Rev.411412006 Oakland County Department of Information Technology Project Scope and Approach Project Name: !MACS Data Warehouse Project ID: • Project team will have access to the required Data Warehouse technical areas. • The technical project team will consist of programmers/analysts experienced in data warehouse project(s). ETL Programmers must be trained/experienced with Informatica, and universe designers must be trained/experienced with Business Objects. • IT staff will have access to new IMACS system. Funding • Fund Equity of the General Fund Other • User training is not included in this scope. • No report creation in this scope. Priority Constraints • Data Warehouse team needs access to 'MACS database or views. Exclusions • Subject areas outside of those that replace the Jail mainframe systems with IMACS will not be included. Form Rev. 4/13/2006 11:48 AM Page 4 Project Rev.4/14/2006 Oakland County Department of Information Technology Project Scope and Approach Project Name: IMACS Data Warehouse Project ID: Form Rev. 4/13/2006 11:48 AM Page 5 Project Rev.411412006 Project ID: Project Name: IMACS Data Warehouse Cost: Authorized Development (see above) Hours: Grand Total Estimated Development Hours: Cost: Oakland County Department of Information Technology Project Scope and Approach PROJECT PHASE AUTHORIZATION Phase(s): Total Estimated Application Services Hours: Cost: Total Estimated Technical Systems Hours: Cost: Total Estimated eGovernment Services Hours: Cost: Total Estimated CLEMIS Hours: Cost: Total Estimated Internal Services Hours: Cost: IT Application Services Division Manager Approval: Date: IT Technical Systems Division Manager Approval: Date: IT eGovernment Services Division Manager Approval: Date: IT CLEMIS Division Manager Approval: Date: IT Internal Services Division Manager Approval: Date: IT Resource Manager Approval: Date: IT Resource Manager Approval: Date: IT Resource Manager Approval: Date: IT Resource Manager Approval: Date: IT Resource Manager Approval: Date: IT Management Approval: Approved: Yes No Date: Reason: Project Sponsor Approval: Title: Date: PROJECT SUMMARY Preliminary Estimated Development for Future Phases Hours: Cost: Project Rev.4/14/2006 Form Rev. 4/13/2006 11:48 AM Page 6 Project ID: Project Name: !MACS Data Warehouse Oakland ,County Department of Information Technology Project Scope and Approach PROJECT COMPLETION AUTHORIZATION Customer Acceptance of Product: Titie: Date: Project Office Review: Date: Form Rev. 4/13/2006 11:48 AM Page 7 Project Rev.411412006 FISCAL NOTE M.R. #06096) May 25, 2006 BY: FINANCE COMMITTEE, CHUCK MOSS, CHAIRPERSON IN RE: OAKLAND COUNTY CRIMINAL JUSTICE COORDINATING COUNCIL - REQUEST FOR FUNDING FOR ADDITIONAL DATA NEEDS TO MITIGATE THE USE OF THE OAKLAND COUNTY JAIL AND RELATED PROCESS IMPROVEMENTS TO THE OAKLAND COUNTY BOARD OF COMMISSIONERS Chairperson, Ladies and Gentlemen: Pursuant to Rule XII-C of this Board, the Finance Committee has reviewed the above referenced resolution and finds: 1. The Criminal Justice Coordinating Council (CJCC) developed a list of data needs and process improvements that would serve to mitigate the jail's use. 2. Several projects, including the modification of the Jail Management System (IMACS), are identified as needing to be implemented. 3. The Department of Information Technology prepared a Project Scope and Approach for the requested projects. The total cost of the projects is $759,000. 4. The resolution provides funding for the projects from Designated Fund Balance allocated for Jail Alternative Program Startup (Acct. #371461). 5. A budget amendment to the FY 2006 budget is recommended as follows: FY 2006 $759,000 $759,000 $759,000 $759,000 General Fund #10100 Revenue 9010101-196020-670513 Planned Use of Fund Balance Total General Fund Revenue Expenditure 9010101-989999-788001-63600 Transfer to IT Fund Total General Fund Expenses Info Tech Fund #63600 Revenue 1080101-989999-695500-10100 Transfer from Gen. Total Info Tech Fund Revenue Expenditure 1080701-152030-731458 Professional Services 1080201-152010-731458 Professional Services Estimated Change in Fund Equity Total Info Tech Fund Expenses $759,000 $759, oop $207,000 $172,000 $380,000 $769,000 FINANCE COMMITTEE FINANCE COMMITTEE Motion carried unanimously on a roll call vote with Rogers absent. Resolution #06096 May 11, 2006 The Chairperson referred the Resolution to the General Government Committee and the Finance Committee. There were no objections. May 25, 2006 notes attached) on the Consent Ruth Johnson, County Clerk Resolution #06096 Moved by Coleman supported by Wilson the resolutions (with fiscal Agenda be adopted (with accompanying reports being accepted). AYES: Crawford, Douglas, Gershenson, Gregory, Hatchett, Middleton, Molnar, Moss, Nash, Palmer, Patterson, Potter, Woodward, Zack, Bullard, Coleman, Coulter. (25) NAYS: None. (0) A sufficient majority having voted in favor, the resolutions (with fiscal Agenda were adopted (with accompanying reports being accepted). Jamian, KowaII, Long, Melton, Rogers, Scott, Suarez, Wilson, notes attached) on the Consent I HEREBY APPROVE THE FORE= RESOLUTMN STATE OF MICHIGAN) COUNTY OF OAKLAND) I, Ruth Johnson, Clerk of the County of Oakland, do hereby certify that the foregoing resolution is a true and accurate copy of a resolution adopted by the Oakland County Board of Commissioners on May 25, 2006, with the original record thereof now remaining in my office. In Testimony Whereof, I have hereunto set my hand and affixed the seal of the County of Oakland at Pontiac, Michigan this 25th day of May, 2006.