Loading...
HomeMy WebLinkAboutRES 199 Draft 01 2006-2008 ,,~1MZY as p'~ COUNTY OF HAWAII STATE OF HAWAII RESOLUTION NO. 199 0'7 RESOLUTION AUTHORIZING THE OFFICE OF THE MAYOR TO ENTER INTO AN AGREEMENT WITH THE STATE OF HAWAII DEPARTMENT OF THE ATTORNEY GENERAL, PURSUANT TO HRS 46-7, FOR THE HORIZONTAL INTEGRATION PROJECT WHEREAS, the Hawaii Criminal Justice Data Center of the State of Hawaii Department of the Attorney General's Crime Prevention & Justice Assistance Division has authorized funding to the Hawaii Office of the Prosecuting Attorney for the Horizontal Integration Project; and WHEREAS, The County of Hawaii has been selected as a pilot site to implement a computer system interface between the Hawaii Police Department's "Green Box" booking system and the Prosecuting Attorney's HITS case tracking system; and WHEREAS, these monies, derived from the Federal funds, will be used to hire a consultant to design and implement the system interface which will eliminate double entry of information into the separate systems and will help to improve efficiency for intaking of arrest cases; and WHEREAS, Hawaii Revised Statutes, Section 46-7, requires that county departments obtain the consent of the council to enter into agreements with the federal or state governments respecting action to be taken pursuant to any of the powers granted by law to furnish, expend, and receive any funds or other assistance in connection with projects being or to be undertaken pursuant to those powers. NOW, THEREFORE, BE IT RESOLVED BY THE COUNCIL OF THE COUNTY OF HAWAII, in accordance with section 46-7, Hawaii Revised Statutes, that the Mayor of the County of Hawaii is authorized to execute, on behalf of the County, an agreement with the State of Hawaii Department of the Attorney General, to enable the County to implement its Horizontal Integration Project, as described in the Prosecuting Attorney's project summary, attached hereto and incorporated herein by reference as Exhibit "A". BE IT FURTHER RESOLVED that the Mayor of the County of Hawaii is authorized to sign the above-referenced agreement and any related documents on behalf of the Office of the Mayor and the County of Hawaii pursuant to the Hawaii County Charter. BE IT FURTHER RESOLVED that the County Clerk of the County of Hawaii shall transmit copies of this resolution to the Office of the Mayor, the Office of the Prosecuting Attorney, and the Finance Department. Dated at xilo ,Hawaii, this 16th day of May , 2007. INT ODUCED BY: Uw--. COUNCIL MEMB , C U Y OF HAWAII COUNTY COUNCIL ROLL CALL VOTE County of Hawaii AYES NOES ABS EX Hilo, Hawaii FORD I hereby certify that the foregoing RESOLUTION was by the HiGA vote indicated to the right hereof adopted by the COUNCIL of HOPPMANN X the County ofHawai`ion May 16, 2007 IKEDA X JACOBSON X ATTEST NAEOLE X ' PILAGO X YAGONG X YOSHIMOTO 9 0 0 0 e ce C-404/Waived F'C r~ n 199 0'7 CO Y CLERK CHAIRMAN P RES LUTION NO. Hawaii Horizontal Integration Pilot (HIP) Project Project Background and User Requirements Introduction Key justice officials in Hawaii have long recognized the need to build integrated information sharing capabilities between justice agencies and other governmental entities throughout the State. Through a host of initiatives over the past ten yeazs State representatives have built and strengthened critical justice information systems (e,g., CJIS system, AFIS and live-scan capabilities, planning and development of the Judicial Information Management System (JIMS), and others) and have established much of the foundation to support Statewide integrated justice information sharing (IJIS). In 2002, the Hawaii Criminal Justice Data Center (HCJDC) received funding from the U.S. Bureau of Justice Assistance (BJA), in cooperation with the National Governors' Association (NGA), to develop the Horizontal Integration Pilot (HIP) project. The HIP project is designed to demonstrate the technical feasibility and business value of electronically sharing critical information at key decision points in a real-time and secure manner. The project is limited in scope, focusing initially on a single jurisdiction (Hawaii County), a single document (the OBTS/CCH Arrest Report), and a limited number of electronic exchanges, utilizing an IJIS Message Broker methodology. This pilot project relies on national models (e.g., the Justice Information Exchange Model (JIEM), developed by SEARCH and funded from BJA) and information exchange standazds (i.e., the Global Justice XML Data Model (GJXDM), developed by U.S. Department of Justice), which are appropriately referenced below. The Need Justice agencies in Hawaii County (specifically the Hawaii Intake Service Center (HISC), Hawaii County Prosecutor, Third Circuit Court, Hawaii County Community Corrections (HCCC)) today must rely on facsimile transmission of arrest booking reports created by the Hawaii County Police Department, and must re-enter into their internal agency information systems a considerable amount of data already captured in these automated arrest/booking reports in order to initiate, schedule and manage cases. As a consequence of this largely manual process, additional and redundant effort is required by each participating agency to enter relevant information already automated on the booking/azrest report into their internal agency information systems. Moreover, information maybe delayed or incorrectly entered (through multiple re-entry and as a result of diminishing quality of the facsimile images), potentially resulting in improper decisions or unwarranted delays of legal proceedings. The HIP project is designed to enable real-time, secure exchange of relevant arrest and booking information, so that the authorized justice agencies identified above will have timely, accurate and complete information on persons arrested, confined and waiting judicial proceedings. EXHIBIT "A" HORIZONTAL INTEGRATION PILOT 10/10/2005 PAGE 1 Purpose of the HIP Project The HIP project is designed to demonstrate the ability and value of implementing an automated IJIS framework that will enable real-time sharing of critical information at key decision points between relevant justice agencies throughout Hawaii County, and potentially throughout the State of Hawaii at some point in the future. Information captured by the Hawaii County Police Department at booking will be electronically transferred to other relevant justice agencies (i.e., HISC, Hawaii County Prosecutor, Third Circuit Court, HCCC), thereby immediately notifying them of the status of the case and obviating their need to re-enter the same information into their internal agency information systems. Additional functionality contemplated down line may enable automated notification of an'est to authorized users (e.g., notification to a supervising Probation Officer of the arrest of a person assigned to their caseload), and real-time exchange of subsequent legal actions and events (e.g., electronic exchange of court dispositions between the Judiciary and law enforcement, prosecution and correctional officials). As a first step in this process, the HIP project will demonstrate real-time electronic sharing of booking information captured in the "Green Box" booking system between Hawaii County Police Department and the HISC, Hawaii County Prosecutor, Third Circuit Court and HCCC. The objective is to electronically transmit booking information (specifically, the OBTS/CCH Arrest Report) from the Green Box system to a state- operated IJIS Message Broker (UIS Broker). The IJIS Broker, in rum, will validate the information received, validate transform of booking data into GJXDM-compliant XML standards, apply pre-defined business rules for the proper, authorized and secure routing of information to relevant justice agencies, and push that information to authorized user agencies (those identified above) in GJXDM-compliant XML standard format for incorporation into their agency information systems. Information from the OBTS/CCH Arrest Report will be transmitted to the IJIS Broker from Hawaii County Police Department's Green Box booking system, where it will be transformed into GJXDM-compliant standards. Applying business rules that have been defined and documented in the Hawaii JIEM database, the IJIS Broker will push relevant arrest and booking information to the HISC to identify persons apprehended and held in custody and, therefore, requiring pre-trial assessment prior to initial court appearance. HISC will receive the relevant arrest and booking data, which (after it has been validated) will be incorporated into their ISC case management information system, obviating their need to reenter information already automated by the Hawaii County Police Department. HISC will thereafter augment case information regarding the arrested party after they have completed their pre-trial interview with the defendant and produce the Pretrial Bail Report for the Third Circuit Court. Similarly, relevant information from the OBTS/CCH Arrest Report will also be transmitted by the IJIS Broker to the Hawaii County Prosecutor, the Third Circuit Judiciary and HCCC to initiate case files, support creation of charging documents, court HORIZONTAL INTEGRATION PILOT 10/10/2005 PAGE 2 schedules and other relevant legal proceedings, as well as correctional intake, should the defendant remain in custody pending trial and begin serving a confinement sentence. All agencies will continue to operate their own information systems and data will be exchanged using eXtensible Mark-up Language (XML) standards developed and approved by the U.S. Department of Justice and the Hawaii Criminal Justice Data Center.I Current Business Practice & Background Hawaii County Police Department: Current business processing requires the Hawaii County Police Department to generate a "roster" of all persons arrested and confined in their cell block. A detailed roster of all persons arrested and confined can be generated from their records management system (RMS) system, but it is extensive and represents multiple printed pages. For continuity and easy reference by correctional officers and other agencies, the Police Department also manually writes basic information on parties arrested and booked in a "Prisoner Loglist." Additionally, this information is also recorded in the "Prisoner Log", which is an Excel spreadsheet created by a booking officer operating on a floppy diskette in one of the personal computers in the Department's booking office. This "Log" is the roster which the Hawaii County Police Department faxes, together with the individual OBTS/CCH Arrest Reports generated by the Green Box booking system, and any supporting wanants for arrest, to HISC and the Hawaii County Prosecutor's office each morning. There is some level of integration between the Green Box booking system and the Department's Records Management System (RMS). Information entered into the Green Box is pushed to the RMS, but there is no reciprocal exchange between RMS and Green Box. In addition, when the court disposes a case, that disposition information must be entered into the RMS, as well as manually recorded in the "Prisoner Loglist." Implementation of the IJIS Broker technology contemplated in the HIP Pilot project may eliminate the need for the Police Department to print and fax the roster of inmates and their individual OBTS/CCH Arrest Reports. In all likelihood, however, the roster will initially still be produced as simple quality control, to ensure that in fact all relevant OBTS/CCH Arrest Reports have been received by the appropriate agencies. In addition, copies of the arrest warrants for persons arrested on warrant will still need to be faxed to ~ The U.S. Department of Justice has spent several years, working through the Office of Justice Programs and the Global Justice Information Shazing Initiative, to create the Global Justice XML Data Model (GJXDM), which defines universal data exchange standazds in the justice arena. The GJXDM is based on industry standards with significant practitioner input, and is constantly evolving and presently in release 3.03. See htt~•//www it oin eov/to~isu~topic id=43 for more information on the GJXDM. Additionally, as part of the HIP initiative, the Hawaii Criminal Justice Data Center (HCJDC) has mapped all OBTS/CCH Arrest Report elements to the GJXDM and has documented all relevant data exchanges using the Justice Information Exchange Model (JIEM), developed by SEARCH, The National Consortium for Justice Information and Statistics. See ~ //www search org/proerams/info/iiem asp for mare information on JIEM. HORIZONTAL INTEGRATION PILOT 10/10/2005 PAGE 3 relevant justice agencies, as the State does not currently operate an automated state-wide warrant information system. As a consequence of the need to manually retrieve and fax warrants, the Police Department will likely see little direct time savings through implementation of the HIP project. Hawaii Intake Service Center (HISC) HISC receives the roster of persons arrested by the Hawaii County Police Department and the relevant OBTS/CCH Arrest Reports and copies of the warrants either by fax, or by picking-up photocopies at the Police Department each morning. HISC in turn faxes these forms to the Third Circuit Court, so they can begin retrieving Traffic Abstracts on all defendants and so that they are aware of the potential caseload facing the court each day. Additionally, HISC faxes the roster, OBTS/CCH Arrest Report and warrants to the Public Defender's Office. HISC staff begin processin cases b searchin for a State Identification Number (SID) for each defendant. If there is no SID, the staff must call Oahu ISC and get an DISC number assigned to the defendant. In addition, HISC staff visit the Third Circuit Court each morning to retrieve the Traffic Abstracts (i.e., driver's license history) for incorporation into the Pretrial Bail Report. If the person is already in the ISC database, the staff person enters a new record for this person representing the current incident b ca turin core information from the OBTS/CCH Arrest Report. This data entry builds the core of the ISC record, which the caseworker will update after they have completed their cellblock interview with the defendant at the Hawaii County Police Department. If the person is not already in the ISC database, staff must build a record for the person. Once the interviews are completed, the caseworker returns to the office and begins completing the Pretrial Bail Report (also known as the Bail Summary). Additional information gathered during the interview, as well as information from the OBTS/CCH Arrest Report is entered into the ISC system in building the case record and the Pretrial Bail Report. The Bail Report is actually a MS Word document. The caseworker must contact references supplied by the defendant and summarize the information in the Report. In addition, staff attach a copy of the defendant's criminal history record, and they must also summarize the record, providing the judge with the number of felony, misdemeanor, petty misdemeanor and contempt convictions, as well as a narrative summary of the criminal record and comments by the arresting officer. Third Circuit Court The Court schedules cases based on information received from HISC and the Hawaii County Prosecutor's Office. The HISC fax enables court clerks to begin building the docket for the Third Circuit Court and to retrieve relevant Traffic Abstracts for each defendant, which are printed and assembled, and placed in a file folder for HISC and deposited in an open file case in the front, public entry of the Clerk's office. HORIZONTAL INTEGRATION PILOT 10/10/2005 PAGE 4 The faxed OBTS/CCH Arrest Reports and supporting documents (roster and warrants) alert the clerk to the possible caseload for the day, but for cases other than Contempt (which aze entered immediately), the clerk waits for the charging decision by the Hawaii County Prosecutor before actually entering the case information into the court's case management information system. The Prosecutor will fax a copy of the original OBTS/CCH Arrest Report to the court with any change in offenses chazged handwritten on the original OBTS/CCH Arrest Report. The clerk will rely on both the HISC-faxed OBTS/CCH Arrest Report and that faxed by the prosecutor to enter basic information regarding the case into their case management information system. Because of the generally lower quality of the image of the faxed document received from the Prosecutor's Office, the clerk often refers back to the HISC- faxed version for entry of critical information. The clerk handwrites the court case number on the OBTS/CCH Arrest Report as she is entering the information. In addition to creating the initial record, the clerk must also enter information from the OBTS/CCH Arrest Re ort in the "Document Create" sub-system. Once this entry is completed, the clerk records basic information regarding the case on two forns by hand, 1) the "Order of the Court" and 2) the "Notice of Entry of Judgment and/or Order", which will be completed by clerks in the courtroom during and immediately following the judicial proceeding. These two forms could be electronically produced, but it is simply more efficient for the clerk to handwrite the information on these two documents, unless there are a large number of the documents to produce. Once all of the information regarding cases scheduled for court proceedings each day has been entered into the Court's case management system, court calendars for the day are created and printed. Hawaii County Prosecutor The Prosecutor's office receives faxed copies of the roster of those arrested, together with the relevant OBTS/CCH Arrest Reports and any warrants from the Hawaii County Police Depaztment each morning. Once a prosecutor has reviewed each case and has made decisions regarding the charges they will pursue, they handwrite the information on the OBTS/CCH Arrest Report and it is faxed to the court. Information regarding the case is then entered from the OBTS/CCH Arrest Re ort into the Prosecutor's HITS system. In addition to basic information regarding the case, the clerk also enters information in the system regarding the prosecutor assigned to the case, scheduled court appearances, etc. The record will be updated with disposition information pending subsequent action by the court. Benefits As noted above, the HIP project is designed to demonstrate the feasibility and potential value of implementing a centralized IJIS Broker to manage real-time, secure information HORIZONTALINTEGRATION PILOT 10/10/2005 PAGE 5 exchange between independent and varied justice agency information systems utilizing US DOJ-endorsed standards. The pilot project will assess the use of IJIS Broker technology to manage information exchange using business rules defined by participating agencies within Hawaii County, and will focus initially on exchange of the OBTS/CCH Arrest Report. Tangible benefits expected from this automated exchange of the OBTS/CCH Arrest Report include time savings on the part of each agency, as they will not need to re-enter data already automated by the Hawaii County Police Department in their "Green Box" Booking System. Each of the three primary participating agencies (HISC, Hawaii County Prosecutor and the Third Circuit Court) can expect time savings of several minutes for each case that will be entered into their internal agency information system. In 2004, HISC handled approximately 2,200 cases; the Hawaii County Prosecutor handled approximately 19,000 charges (cases average two charges per case); and the Third Circuit Court handled 15,216 cases. Implementation of the IJIS Broker technology, therefore, can be expected to save a significant amount of time for each of the participating agencies-time better spent managing anever-increasing caseload. In addition to time savings, participants may also expect improvement in the quality (i.e., accuracy, as the data will not be subject to repeated entry and potential (if unintentional) errors in data capture) and timeliness (i.e., immediate access to information, rather than waiting for facsimile transmission and data entry by agency clerical staff) of information upon which each agency relies. Although baseline measures associated with data quality and timeliness have not been established for each agency, additional research down line may address this important dimension. HIP User Requirements User Requirements for the HIP project are displayed in Figure 1 and described below. The data exchanges portrayed in Figure 1 demonstrate the initial push of the OBTS/CCH Arrest Report data from the Hawaii County Police Department Green Box Booking System to the UIS Broker. The IJIS Broker will pull the full OBTS/CCH Arrest Report and all available data, and transform that information into GJXDM-complaint standards and apply information exchange business rules that have been defined for each participating agency. Relevant information identified in the business rules will then be pushed from the IJiS Broker to each participating agency information system. This pilot implementation of the IJIS Broker presumes that all information exchange will be executed in GJXDM-compliant standards and that agency information systems will beaz responsibility for transformation of the GJXDM-compliant data into agency-compliant formats, as described below. z This figure represents the number of Traffic Pre-Arraignments (custody cases and cannot post bail): 7,745 at Hilo/Puna and 4,610 at Kona; Criminal Pre-Arraignments: 1,627 at Hilo and 1,204 at Kona. HORIZONTAL INTEGRATION PILOT 10/10/2005 PAGE 6 Figure 1 Hawaii Horizontal Integration Pilot (HIP) Project Green Box OBTS/ Booking Booking CCH System Arrest Report Pull: OBTS/CCH Arrest Report IJISMessa a Bualnesarules:Appygency-apacRcbueineasmleslo g tlegne whet informatlon u pushetl to each intlivitluel agency Broker and antler what drwmstancea Push: OBTS/CCH Ames) Reprnt iMOrmelbn to each egenry iMOrmetion system eased on busbeas rules. AI erxhange will ba tlone in GJXDM-cemplleM XML standards. OBTS/C nest Repo eta pushed to ency informs stems Prosecutor HCCC ISC System HITS Judiciary OffenderTrak 6O gepal NO TracWy ND OTN OTN DlNrlcl 99N 59N 65N 6'D Name U6 Cltlzen Tnra In 6lale Trxkinp NO 6ea gace fine Name MaiBnp ltlareu.CMSMe DOB Rxe hex (gesumably ZlP fie: xell) POB pOB Race pn®I pale HelaM POB DO6 Mrnl Ume WNpM1I HegM POB NNxde Uatl (year/maWmcaell, 9cM1aY OLeMmO WeeM1l µq l'rcenee NUmYr, Male Realaenw OtlEreee.CIty51MNZIP N(p Rniaence MErnYCiry/SYaINEIP FInaI CM1arpe MaIIIrp Mtlrne H»r Cdd Reutlenl Phone Na. Repa'I NO. Marhal6lalua Eye Cda MaIIIIq MarnMLlly5WdLP Nox RdezeC Emeryenry CmMd 6MWI Mertllrp EmpbyarLnl EmgoyW BYI9d EmaUC^eNl pM1cee gsaence /dargYCity/61a1NZIP Oxupatim Bail gelM Marm?Ciry51Ne2P EmpbyNrLnlEmpl%N Buclnen rVtlrna/CIIyShYNEIP 6alRndq NO Mreeka Fa Bwlrm~Ib]rnbCayl6MNZIP Bucinm Pllme NC BallrBma PnIM Ey WM1O gepA No Bnlnev PM1me ND. MeeW00ificer Place MOfierna BeII SeI Emeryenry LmW case in CMel OIRnu Oab bcblery Emaryenc/Lmlxl RtlalimmM1ip DNelRenrvea 0y) Ollenee Tlme 6ynopaa Emerseery cdrmd Pnane DalNr~me wnvsn avl Inimlcwn Di~Npn.eae,om. /tlarep,Ciry5WS21v coarse MrW OMe Nrnlea Fw CM1agea Dak Final C11v0e FIneI CM1ape lPdke) MMiACallona Pep[n NUmOer 6evenly HWIReIeaW Repel No Bal6e1 Di&rid Hcw RNeasM EBall ae1 EBaiVdMa Pa1M PaM Type Parry None PaM sw DOB ~e Rxe RmaenVJSaw Reuaence PM1One Bminm Pllme MtlreaeFily5Me21P ORenee Dale misal can DNmlorvDdenlma gepoM1 Wrfien By HORIZONTAL INTEGRATION PILOT 10/10/2005 PAGE 7 Information Exchange Modeling The information exchanges represented in Figure 1 have been modeled using the Justice Information Exchange Modeling tool (JIEM), developed by SEARCH. A separate report is being prepared documenting the specific exchanges contemplated in this HIP Project. Mapping of Information to the Global Justice XML Data Model The first tier in the process of mapping information that will be exchanged for the HIP project has been completed, i.e., information from the OBTS/CCH Arrest Report, which is automated in the Green Box booking system, has been mapped to GJXDM. The GJXDM mapping of booking information is presented in a separate report. A second tier of analysis must now be completed by technical staff in each of the participating agencies to whom information will be pushed from the IJIS Broker, i.e., ISC, Third Circuit Courts, Hawaii County Prosecutor and HCCC. Technical staff (or their solution providers or technical consultants) representing each of the agencies will need to map the GJXDM data to their intemal/native information system to ensure accurate transformation of booking information into formats that are consistent with and interpretable by internal agency information systems. Three alternatives exist to facilitate information exchange between native agency information systems and the IJIS Broker: 1. Agency systems map their intemal data to GJXDM standards and all exchange with the IJIS Broker is completed in GJXDM-compliant standards; 2. Agency systems push/pull information with the IJIS Broker in native format, and the IJIS Broker actively transforms the data into GJXDM-compliant standards, maps the information to meet individual agency reporting formats, and pushes data to each agency in a format that is consistent with, and interpretable by, the internal information systems of each participating agency; and 3. An external solution provider is contracted to provide adaptors for each agency system, which will actively transform native data from agency systems into/from GJXDM, so that the IJIS Broker deals only with GJXDM-compliant data and participating agency systems receive information in native format. Alternative 1 is the preferred option from both cost and future development perspectives. Mapping agency information to GJXDM standards will in all likelihood be more efficiently accomplished by agency technical staff and their solution providers given their extensive knowledge of current systems and data. In addition, mapping agency systems to GJXDM standards will facilitate the more extensive information exchange contemplated in further implementation of the IJIS Broker, which will extend beyond the OBTS/CCH Arrest Report. Next Steps Several additional activities should be undertaken immediately: 1. This document has been distributed to each participating agency to: a. apprise them of the status of the HIP project, b. validate the information exchanges presented above, HORIZONTAL INTEGRATION PILOT 10/IO/2005 PAGE 8 c. enable them to assess their present ability to exchange the necessary information with the IJIS Broker, d. begin or complete mapping of agency information to GJXDM standards, and e. estimate costs for modifications or programming services to participate in the HIP Project. 2. Potential IJIS Broker solution providers should be identified and qualified. The technical approach of their solution should be examined to ensure compliance with the model outlined in this project and their experience in successfully implementing and operating anenterprise-wide IJIS Broker should be assessed; 3. HCJDC staff should explore options for the procurement processes that will be used to implement the HIP Project. The HIP Project includes funding for participating agencies to modify their internal information systems and presumably mapping of their data to GJXDM standards, as well as procurement and programming of the IJIS Broker at HCJDC. Given the "pilot" nature of this project, and the potential State-wide implementation of the final solution, initial testing of an IJIS Broker may well be partially underwritten by a suitable solution provider. Selection of a vendor for the HIP Project would not commit the State to implementation of that solution in any subsequent phases, but neither would it preclude the vendor from open competition in subsequent phases; 4. Convene a meeting of program and technical staff representing each of the participating agencies and HCJDC to review each of the steps outlined above, discuss and resolve questions and issues, establish timeframes and responsibilities, and initiate necessary actions. HORIZONTAL INTEGRATION PILOT 10/10/2005 PAGE 9 Appendix: OBTS/CCH Arrest Report Data Elements by Agency ISC Information: SID OTN SSN Years in State Name Sex Race DOB POB Height Weight AKA Hair Color Eye Color School Attending Residence AddresslCityl State/ZIP EmployerlLast Employed Business Address/City) State/ZIP Business Phone No. Emergency Contact Emergency Contact Relationship Emergency Contact Phone Address/City/State/ZIP Arrest Date Charged Date Final Charge (Police) Report Number How Released Bail Set HORIZONTAL INTEGRATION PILOT 10/10/2005 PAGE 10 Prosecutor Information: Report No. District SID Tracking No. SSN Name Sex Race DOB POB AKA Residence Address/CitylState/ZIP Resident Phone No. Mailing Address/City/State/ZIP Employer/Last Employed Occupation Business Address/CitylState/ZIP Business Phone No. Arresting Officer Case in Chief Date (Received by) Date/Time (Charged by) Charge Arrested For Final Charge Modifications Severity Report No. District How Released $Bail Set $BaillBond Posted Party Type Party Name Party Sex DOB Age Race ResidentNisitor Residence Phone Business Phone AddresslCity/State/ZIP Offense Date Initial Court Division/Date/Time Report Written By HORIZONTAL INTEGRATION PILOT 10/10/2005 PAGE 11 Judiciary Information: Tracking No. SSN Name Sex DOB Mailing Address, City/State (presumably ZIP code as well) Arrest Date Arrest time Vehicle Used (year/ make/model), License Number, State Final Charge Report No. How Released Bail Set Bail posted Bail Receipt No. Bail/Bond Posted by Who Place of offense Offense Date Offense Time Initial Court Division, date, time HORIZONTAL INTEGRATION PILOT 10/10/2005 PAGE 12 HCC Information: SID OTN SSN US Citizen Name DOB POB Height Weight School Attending Residence Address/ City/State/ZIP Mailing Address Marital Status Emergency Contact Relationship Emergency Phone AddresslCitylStatel ZIP Case in Chief Arrested For Report No. Bail Set Sobriety Synopsis HORIZONTAL INTEGRATION PILOT 10/10/2005 PAGE 13