Loading...
HomeMy WebLinkAboutContract 35728 APPLICATION SOFTWARE SUPPORT AGREEMENT FOR MUNICIPAL COURT INTEGRATED CASE MANAGEMENT SYSTEM CITY SECRETARY CONTRACT NO. I o E_ ARTICLES OF AGREEMENT THIS AGREEMENT, ("Agreement") is entered into by and between the City of Fort Worth, a home-rule municipal corporation situated in Tarrant, Denton and Wise counties, Texas, located at 1000 Throckmorton Street, Fort Worth, Texas, hereinafter referred to as the"City;" AND MAXIMUS, Justice Solutions Division, a Virginia corporation with its principal offices located at 5399 Lauby Road, Suite 200, North Canton, Ohio, hereinafter referred to as "Company." RECITALS WHEREAS, Company is experienced in the implementation and support of data processing systems and CourtView®application software, hereinafter referred to as "Systems;" and WHEREAS, pursuant to City Secretary Contract ("CSC") No. 29707, Company has provided the City with Systems as described in Schedule A of this Agreement; and WHEREAS, Company offers ongoing support services to the City; and WHEREAS,the City desires to utilize said services; and NOW,THEREFORE,the parties agree as follows: DEFINITIONS City shall mean all employees, officials, agents, representatives, or servants of the City of Fort Worth. Company shall mean all employees, officers, directors, agents, representatives, contractors, and subcontractors that provide services to the City pursuant to this Agreement. System shall mean all software and hardware created by or for the City to be utilized under this Agreement. 1. SERVICES TO BE PROVIDED Company shall provide application software support services to the City more specifically described in Schedule B of this Agreement. 2. TERM This Agreement shall commence on January 1, 2007 and expire on December 31, 2011 ("Initial Term"), for the following software application systems: 1) CourtView®Case Management Module , r,p t Application Software Support Agreement Maximus Justice Solutions/City of Fort Worth Page 1 of 19 2) Judicial Management Module 3) Financial Management Module 4) Accounts Receivable Module 5) Web-based Public Access Module Both parties understand, acknowledge and agree that Imaging and workflow are a part of the Case Management Product. The product also includes the interfaces to the DAISI IVR; however, MAXIMUS is not responsible for the operation or function of that third party software product that is provided by City. This agreement may be renewed, as provided in Section 25 herein. 3. COMPENSATION In consideration of the performance of support services as set forth in this Agreement, Company shall receive an annual fee for a total amount not to exceed Ninety Three Thousand Three Hundred and 001100 dollars ($93,300.00) each year. City will make quarterly payments as listed below due forty-five(45) days after the invoice. Quarterly Payment $ 23,325.00 MAXIMUS shall, after the initial term of this Agreement, have the right to increase the Annual Software Support Fees for any subsequent Renewal Periods, subject to the condition that MAXIMUS shall provide the City with at least sixty (60) days' prior written notice of any such increase. Further, in no event shall any subsequent annual increases exceed the lesser of: (i) five percent (5%) of the Annual Software Support Fees for the then current support period; or (ii) the cumulative percentage increase, if any, based on the local Consumer Price Index as published by the Bureau of Labor Statistics, United States Department of Labor, for the preceding twelve (12) month period. Additional services requested by the City shall be provided under the provisions of and invoiced in accordance with the time and materials rates contained in Schedule C of this Agreement. Payment of invoices is due within forty-five (45) days of the date of each billing. Failure of the City to make payment when due, providing there is no dispute with regard to the amount of billing or service(s) provided, shall entitle Company to suspend further performance of this Agreement without liability. Company shall provide the City with thirty (30) days notice of its intent to suspend performance for failure to make payment, and the City shall have an opportunity to cure within said time. When payment of invoices is current, performance of this agreement for software support shall be restored. 4. CONTRACT DOCUMENTS This Agreement shall include the following documents: a) This Application Software Support Agreement b) Schedule A- Maximus Application Software Systems c) Schedule B - Scope of Support Services Application Software Support Agreement Maximus Justice Solutions 1 City of Fort Worth Page 2 of 19 ;R JAS , d) Schedule C -Time and Materials Rates e) Schedule D—Company Observed Holidays D Schedule E—Escrow Agreement All documents as outlined in this Section 4 are attached hereto and incorporated into this Agreement for all purposes. If there is a conflict between any of the attachments and this Agreement, this Agreement controls. If there is any conflict between this Agreement and CSC No. 29707, then CSC No. 29707 controls. 5. ENTIRE AGREEMENT This Agreement, together with all documents referenced herein, comprise the complete and entire agreement between the parties and may not be altered or amended except as agreed to in writing by both parties, making specific references to the provision to be altered or amended. Any such writing altering or amending the agreement between parties must be executed by a duly authorized official of the City and by a duly authorized officer of Company. 6. CITY RESPONSIBILITIES The City shall support and assist Company in identifying and clarifying problems encountered by the City and shall make available source documents or data files as may be necessary to isolate or replicate a problem condition. The City shall provide Company with access to City facilities and the computer equipment as required in the performance of these tasks described herein, including access after normal working hours and on weekends. The City shall provide City personnel as necessary to provide such access or to maintain security of the facility as deemed appropriate by the City. The City shall, within thirty (30) days of the execution of this Agreement, at its own expense, grant remote telephone access to the City's computer system through a 56kb or T1 phone line. Such access shall be subject to and governed by the City's security policy on outside connections and access to the City's systems as agreed to in the Limited Access Agreement (LMA) executed on May 24, 2004 and styled as CSC No. 29991. 7. COMPANY RESPONSIBILITIES Company shall perform in a professional manner in providing services to the City and shall provide knowledgeable personnel experienced with the software installed at the City's site. City shall not be required to compensate Company for services provided to the City by employees or subcontractors of Company, which fail to satisfy the standards set forth herein. The City reserves the right of rejection on any project personnel provided by Company. Replacement personnel shall be provided in a timely fashion. Company shall safeguard any materials provided by the City in the performance of this Agreement in a manner as prescribed by the City. In lieu of specific guidance from the City, Company shall take reasonable care as to prevent unauthorized disclosure of the City's information. Application Software Support Agreement Maximus Justice Solutions/City of Fort Worth Page 3 of 19 8. INDEPENDENT CONTRACTOR The relationship of Company to the City shall be that of an independent contractor, and no principal-agent or employer-employee relationship is created by this Agreement. 9. SUBCONTRACTS Company reserves the right to subcontract work, as necessary, in the performance of this Agreement. Company agrees to be responsible for the accuracy, timeliness, and confidentiality of all work submitted in the fulfillment of its responsibilities under this Agreement. All the terms of this Agreement shall apply equally to any subcontractors employed by Company such that use of the term "Company" in this Agreement when describing a duty of Company to the City shall also mean a duty of "Subcontractors of Company." 10. OWNERSHIP OF DATA Data collected is the property of the City. Data used by Company in the services contemplated herein shall remain the property of the City, and no use shall be made thereof beyond that listed in this Agreement without the written permission of the City. Company further agrees that it shall treat all information provided to it by the City as confidential and shall not disclose any such information to a third party without the prior written approval of the City. Company shall store and maintain City Information in a secure manner and shall not allow unauthorized users to access, modify, delete or otherwise corrupt City Information in any way. Company shall notify the City immediately if the security or integrity of any City information has been compromised or is believed to have been compromised. 11. OWNERSHIP OF COURTVIEW SOFTWARE AND DESIGNS All software development, design, documentation, and programs necessary to operate and maintain the Systems described herein that were produced by Company shall remain the proprietary property of Company. Restriction of this proprietary property does not limit City from making such copies of programs, documentation, and Systems-related materials for internal use. Unless otherwise required by law, rule, regulation, or court order, the City will not disclose such materials to third parties or other contractors without the express written consent of Company. Company Systems are designed as standard products and not as customized systems. Company recognizes the need for some City customization; however, Company reserves the right to control the design, performance, and integration of City products and, as a result, may reject City requests for modifications or enhancements that are inconsistent with Company's product strategy. However, if such modification or enhancement is, in the City's opinion, necessary to provide proper functionality of the system, then Company shall work with City to provide such appropriate enhancement or modification for the City in accordance with the rates set forth in Schedule C of this Agreement. Any enhancements or modifications that are necessary under this Agreement shall be covered by all applicable warranties set forth herein. Rejection of any such request for modification or enhancements by Company does not forbid or prevent the City from making the requested modification or enhancement with its own forces or other contractors, bearing in mind the potential loss of warranty, which may result under Section 12 (C) of this Agreement. Application Software Support Agreement Maximus Justice Solutions/City of Fort Worth Page 4 of 19 12. WARRANTIES A. SERVICES Company warrants that Company shall provide such support services as shall permit the software to perform in accordance with industry standards and Company published documentation, and Company further warrants that it shall provide qualified personnel to perform the support services. B. SOFTWARE Company shall only be responsible to correct software defects in or resulting from software supported during this Agreement as listed in Schedule A which are submitted to it in writing during the Agreement period. Oral notification or generalized complaints shall not constitute notice under this Agreement. Company warrants that it will correct software defects. Software defects shall be defined as failure of the software to perform functions as identified in documentation supplied by Company. C. CITY MODIFICATIONS City shall inform Company in writing of any change to or modification of any of Company's software which it desires to make or has made. Company is not responsible for any errors or defects caused by modifications made to Company's software by the City. Correction of such errors or defects by Company shall be at the time and materials rates specified in Schedule C. Company does not guarantee that new releases or versions shall operate as designed if City has altered Company software. D. CITY NEGLIGENCE Company shall not, at any time during the period of this Agreement, be required to correct any defects in any Company software caused by City's negligence, improper installation or operation of Company's software. 13. LIABILITY I INDEMNIFICATION COMPANY COVENANTS AND AGREES HEREBY TO BE LIABLE TO THE CITY AND TO DEFEND, INDEMNIFY AND HOLD THE CITY, ITS OFFICERS, AGENTS, SERVANTS AND EMPLOYEES HARMLESS AGAINST ANY CLAIMS, LAWSUITS, OR ACTIONS BY THIRD PARTIES ARISING UNDER THIS AGREEMENT FOR PROPERTY LOSS, PROPERTY DAMAGE AND OR PERSONAL INJURY, INCLUDING DEATH, TO ANY PERSON, TO THE EXENT CAUSED BY THE NEGLIGENT ACT(S), OMISSION(S), MALFEASANCE OR INTENTIONAL MISCONDUCT OF COMPANY, ITS OFFICERS, AGENTS, SERVANTS, EMPLOYEES,OR SUBCONTRACTORS. CITY AGREES THAT COMPANY'S TOTAL LIABILITY TO CITY FOR ANY AND ALL DAMAGES WHATSOEVER ARISING OUT OF OR IN ANY WAY RELATED TO THIS AGREEMENT FOR ANY CAUSE, INCLUDING BUT NOT LIMITED TO CONTRACT LIABILITY OR COMPANY NEGLIGENCE, ERRORS, OMISSIONS, STRICT LIABILITY, BREACH OF CONTRACT OR BREACH OF WARRANTY SHALL NOT, IN THE AGGREGATE, EXCEED THE TOTAL AMOUNT OF FEES PAID TO COMPANY UNDER THIS AGREEMENT. Application Software Support Agreement Maximus Justice Solutions/City of Fort Worth Page 5 of 19 IN NO EVENT WILL COMPANY BE LIABLE TO THE CITY OR ANY THIRD PARTY FOR LOSS OF BUSINESS OR PROFITS OR OTHER ECONOMIC LOSS OR FOR ANY INCIDENTIAL, INDIRECT, SPECIAL OR CONSEQUENTIAL DAMAGES, UNLESS SUCH DAMAGE IS CAUSED BY THE GROSS NEGLIGENCE, INTENTIONAL OR WILLFUL MISCONDUCT OR MALFEASANCE OF THE CONTRACTOR, ITS EMPLOYEES, OFFICERS, AGENTS, OR SUBCONTRACTORS. 14. INSURANCE (1) Insurance Coverage and Limits: Company shall provide the City with certificate(s) of insurance documenting policies of the following coverage at minimum limits that are to be in effect prior to commencement of work under this Agreement: Commercial General Liability $1,000,000 each occurrence $1,000,000 aggregate Automobile Liability $1,000,000 each accident (or reasonably equivalent limits of coverage if written on a split limits basis). Coverage shall be on any vehicle used by the Company, its employees, agents, or representatives in the course of the work performed under this Agreement. Worker's Compensation Coverage A: Statutory limits Coverage B: $100,000 each accident $500,000 disease—policy limit $100,000 disease—each employee Professional Liability $1,000,000 each claim/annual aggregate Technology Liability (E&O) $1,000,000 Each Claim Limit $1,000,000 Aggregate Limit Technology coverage may be provided through an endorsement to the Commercial General Liability(CGL) policy, or a separate policy specific to Technology E&O. Either is acceptable if coverage meets all other requirements. Coverage shall be claims-made, and maintained for the duration of the contractual agreement and for two(2) years following completion of services provided. An annual certificate of insurance shall be submitted to the City to evidence coverage. (2) Certificates of insurance evidencing that the Company has obtained all required insurance shall be delivered to the City prior to Company proceeding with the work under this Agreement. (a) With the exception of Worker's Compensation and Professional Liability, policies shall be endorsed to name the City as an Additional Primary Insured thereon, as its interests may appear. The term City shall include its employees, officers, officials, agents, and volunteers in respect to the contracted services. Application Software Support Agreement Maximus Justice Solutions/City of Fort Worth 6 �II��S7n Page 6 of 19 � V (b) Any failure on part of the City to request required insurance documentation shall not constitute a waiver of the insurance requirements. (c) A minimum of thirty(30)days notice of cancellation or reduction in limits of coverage shall be provided to the City. Ten (10) days notice shall be acceptable in the event of non-payment of premium. Such terms shall be endorsed onto Company's insurance policies. Notice shall be sent to the Risk Manager, City of Fort Worth, 1000 Throckmorton, Fort Worth, Texas 76102, copy to the City Attorney at the same address. (d) Insurers for all policies must be authorized to do business in the state of Texas or be otherwise approved by the City; and, such insurers shall be acceptable to the City in terms of their financial strength and solvency. (e) In lieu of disclosure of Company's deductibles, the City reserves the right to request a copy of Company's latest audited financial statement or a letter of credit in order to determine Company's financial capacity. Such financial statements or letters of credit must be acceptable to the City. (f) The general liability, automobile liability and worker's compensation policies shall each be endorsed with a waiver of subrogation in favor of the City as respects the work performed under this Agreement. (g) The City shall be entitled, upon its request and without incurring expense, to review the Company's insurance declaration page(s) including endorsements thereto and, at the City's discretion, the Company may be required to provide proof of insurance premium payments. (h) The Commercial General Liability insurance policy shall have no exclusions by endorsement that would otherwise change the City's insurable interest or coverage. (i) In lieu of tail coverage, should a malfunction, system failure, or an incident that may give rise to a claim occur, the Company shall report the incident to their insurance carrier during the policy period. (�) The City shall not be responsible for the direct payment of any insurance premiums required by this Agreement. It is understood that insurance cost is an allowable component of Company's overhead. (k) Subcontractors to the Company shall be required to maintain the same insurance as is maintained by Company or a reasonable equivalent. Company shall provide City with documentation thereof on a certificate of insurance. Notwithstanding anything to the contrary contained herein, in the event a subcontractor's insurance coverage is canceled or terminated, such cancellation or termination shall not constitute a breach by Company of the Agreement. 15. EMPLOYMENT LAWS I NON-DISCRIMINATION Company shall comply with all applicable provisions of Federal, State, and local laws, rules, and regulations regarding employment. If the City notifies Company of any violation of such laws, ordinances, rules or regulations, Company shall immediately desist from and correct the violation. Company, for itself, its personal representatives, assigns, subcontractors and successors in interest, as part of the consideration herein, agrees that in the performance of Application Software Support Agreement Maximus Justice Solutions/City of Fort Worth Page 7 of 19 Company's duties and obligations hereunder, it shall not discriminate in the treatment or employment of any individual or group of individuals on any basis prohibited by law. If any claim arises from an alleged violation of this non-discrimination covenant by Company, its personal representatives, assigns, subcontractors or successors in interest, Company agrees to assume such liability and to indemnify and defend the City and hold the City harmless from such claim. 16. CONFLICT OF INTEREST Company shall not employ as a director, officer, employee, agent, contractor, or subcontractor, directly or indirectly in any capacity as relates to this Agreement, any elected or appointed official of the City or any member of his or her immediate family. 17. OFFICE SPACE, FACILITIES,AND RECORDS The City shall provide office space, office equipment and machines, computers, and other equipment or records as may be needed in the performance of this Agreement. 18. ASSIGNMENT OF AGREEMENT Company agrees not to assign, transfer, convey, or otherwise dispose of this Agreement or its rights, title, or interest in this Agreement without previous consent and written approval of the City. 19. CHANGES IN AGREEMENT This Agreement may be changed only upon the written agreement of City and Company. 20. GOVERNING LAW/VENUE This Agreement shall be construed in accordance with the laws of the State of Texas. If any action, whether real or asserted, at law or in equity, is brought on the basis of this Agreement, venue for such action shall lie in state courts located in Tarrant County, Texas or the United States District Court for the Northern District of Texas, Fort Worth Division. 21. SOLICITATION OF EMPLOYEES Neither the City nor Company shall, during the term of this Agreement, any renewal periods, and additionally a period of two years after its termination, solicit for employment or employ, whether as employee or independent contractor, any person who is or has been employed by the other during the term of this agreement, without the prior written consent of the person's employer. 22. SEVERABILITY If any provision of this Agreement shall be declared invalid or unenforceable, such invalidity or unenforceability shall not affect the balance of this Agreement, but the balance of this Agreement shall be construed as if not containing the provision, and the rights and obligations of the parties shall be construed and enforced accordingly, provided that the provision declared invalid or unenforceable is not of a material nature and does not substantially affect the work or the associated cost. Application Software Support Agreement Maximus Justice Solutions/City of Fort Worth Page 8of19 23. NOTICES Except as otherwise expressly provided herein, any notice required or authorized to be given shall be deemed to be given when mailed by certified or registered mail, postage prepaid, and received as evidenced by a delivery receipt, addressed as follows: if to the City: Jackie Mitchell, Acting Director Municipal Court City of Fort Worth 1000 Throckmorton Street Fort Worth, Texas 76102 if to Company: Frank Tait, President MAXIMUS—Justice Solutions Division 5399 Lauby Road, Suite 200 North Canton, Ohio, 44720. 24. TERMINATION City shall have the right to terminate this Agreement upon thirty (30) days written notice to Company. Thirty (30) days after receipt of such notice by Company, this Agreement shall be considered terminated without further obligation of the parties, except for payment by the City for all services rendered and materials furnished up to the effective date of termination. The Company may terminate on thirty (30) days notice for nonpayment, if payment is not cured within thirty days from the date of the notice. After the initial term, Company may terminate on thirty (30)days written notice. If for any reason, at any time during any term of this Agreement, or during any renewal term, the City Council fails to appropriate funds sufficient for the City to fulfill its obligations under this Agreement, the City may terminate this Agreement without penalty to be effective upon (i) expiration of thirty (30) days following delivery by the City to Company of written notice of the City's intention to terminate or (ii) the last date for which funding has been appropriated by the City Council for the purposes set forth in this Agreement, whichever occurs first. Upon termination, the City shall have the right to obtain the source code(s) from Company necessary to operate the system in accordance with the terms of the escrow agreement. City shall retain the right to reload and operate all software created by the City for this system or created by Company for use on this system pursuant to this Agreement or to CSC No. 29707. 25. RENEWAL After the expiration of the initial term, this Agreement may renew annually for a period of twelve (12) months provided that funds have been properly appropriated for such renewal. Should City not wish to renew this Agreement, City shall notify Company in writing at least thirty (30) days prior to the expiration of the current renewal term. If in any renewal period Company upgrades its current system to a system that the City does not wish to upgrade, City shall have the option to continue running its current system, and Company agrees to provide continued maintenance and support services for the City's current system for the life of this Agreement. 26. WAIVER The failure of the City or Company to insist upon the performance of any term or provision of this Agreement or to exercise any right granted herein shall not constitute a waiver of the City's or Company's respective right to insist upon appropriate performance or to assert any such right on any future occasion. i Application Software Support Agreement Maximus Justice Solutions/City of Fort Worth !!! Page 9 of 19 /+' ` 27. DISPUTES If either party has a claim, dispute, or other matter in question for breach of duty, obligations or services rendered that arises under this Agreement, that party shall promptly notify the other party in writing as to the nature of the dispute and list its reasons for such dispute. Both parties agree to make a good faith effort to resolve any claim, dispute or other matter in question that may arise out of, or in connection with this Agreement. In the event the dispute is specifically related to services rendered by the Company, the City shall determine a reasonable time in which the Company shall successfully resolve the issue(s) raised by the dispute to the satisfaction of the City. If the City does not accept the Company's resolution, the City shall have the right to withhold payment of any amounts due until such dispute has been resolved to the satisfaction of the City. No interest shall accrue on any amount due if the dispute is not resolved. The Company agrees to continue to perform all other services under the Agreement not related to the dispute. However, if the dispute is related to a service that would cause serious impairment or total failure of the system if Company ceased to perform such service, then Company agrees to continue such service under the Agreement. 28. FORCE MAJEURE The City and Company shall exercise their best efforts to meet their respective duties and obligations as set forth in this Agreement, but shall not be held liable for any delay or omission in performance due to force majeure or other causes beyond their reasonable control (force majeure), including, but not limited to, compliance with any government law, ordinance or regulation, acts of God, acts of the public enemy, fires, strikes, lockouts, natural disasters, wars, riots, material or labor restrictions by any governmental authority, transportation problems and/or any other similar causes. [Remainder of Page Intentionally Left Blank] Application Software Support Agreement Maximus Justice Solutions/City of Fort Worth Page 10 of 19 IN �IV�TNESS W RE F, th rties have executed this Agreement in duplicates hereof this the day of ,.2007. MAXIMUS: WITNESS: By: By: Frank Tait Name: /9-"F41 6- President-JWA Solutions Division Title: 6w2. I90,*I'I,) Date: FNot 2 Date: J;11,1149 7 CITY OF FORT WORTI-laATTEST: k4- By:_ By: Joe P4KIog a Marty Hendriib AssistaV Cit an r City Secretary Date: (( . Date: "l`4-0 APPROVED AST-0 FORM AND LEGALITY: CONTRACT AUTHORIZATION: By: / M&C: G-15785; Date Approved 7/17/07 Maleshi B. Farmer Assistant City Attorney Date: 1-"3 I� Application Software Support Agreement Maximus Justice Solutions/City of Fort Worth Page 11 of 19 ���tp SCHEDULE A MAXIMUS APPLICATION SOFTWARE SYSTEMS COVERED UNDER THIS AGREEMENT NOTE: Items on Schedule A will include only those that apply to the specific site being installed. (1) Case Management Module (2) Judicial Management Module (3) Financial Management Module (4)Accounts Receivable Module (5)Web-based Public Access Module Both parties understand, acknowledge and agree that Imaging and workflow are a part of the Case Management Product. The product also includes the interfaces to the DAISI IVR; however, MAXIMUS is not responsible for the operation or function of that third party software product that is provided by City. Application Software Support Agreement Maximus Justice Solutions/City of Fort Worth Page 12 of 19 SCHEDULE B SERVICES UNDER THIS AGREEMENT 1. SUPPORT SERVICES Company shall furnish City with the following services: A. Application software support services for the Products identified in Schedule A. Services available include procedural and technical assistance in troubleshooting and resolving problems/questions associated with the application(s). B. Application software warranty is extended as part of this Agreement to include the correction of software defects. Software defects shall be defined as failure of the software to perform functions as identified in documentation supplied by Company. C. City may desire to have additional modifications or minor enhancements performed; the fees for these services shall be in accordance with the time and materials rates contained in Schedule C of this Software Support Agreement. Specific services include requirements analysis, preparation of functional and programming specifications, software development, testing, documentation, installation, file conversion, training, and help desk support. Company shall provide an estimate of cost prior to performing any of the above services. Company is available to perform these modifications within the scope of this Agreement or under a separate agreement. D. Product enhancements developed by Company shall be made available to City as an update to the current Product version. Should City desire to implement these updates, City would not be charged for additional license fees and release documentation and remote installation of said updates, but would be charged for the on-site installation and training of City personnel on the update. Company shall provide an estimate of cost prior to performing any of the above services. E. New releases of the Product are made available periodically which include major and significant technical updates and functional improvements. These new Product releases shall be made available to City. New Product releases will be provided without any additional application software license fees or charges for documentation. There may be implementation charges for time incurred in on-site installation, training of City personnel, and file conversion of City's database, hardware and third party software. Company shall provide an estimate of cost prior to performing any of the above services. F. Legislative Updates which require modifications to the Software in order to maintain the existing functionality of the Software listed in Schedule A and which result from changes to the laws, regulations or rules of the State of Texas, or of the Texas State Rules of Court, will be provided in accordance with the terms and conditions set forth below. Modifications required by changes to local court rules will be provided to the City at no additional cost. The City shall timely notify Company in writing of all required Legislative Updates. The notice shall contain a summary of the modification identifying the application(s) and function(s) to be modified as well as detailed specifications of the required change(s). City shall also provide a complete text, including effective date, of the legislation and/or order mandating the modification(s). Application Software Support Agreement Maximus Justice Solutions/City of Fort Worth Page 13 of 19 .t..Y t. 9 � Company shall then prepare a detailed functional specification for written approval by City. Following receipt of City's approval, Company will undertake all reasonable efforts to complete the modifications. Legislative Updates shall only be provided for the latest release of the Company's product. There is no additional license fee for associated documentation or remote installation of said updates. Fees for on-site installation and training for Legislative Updates shall be billed to City at the time and materials rates listed in Schedule C. The City may contract with Company for Legislative Updates for old releases of Company's products under separate agreement. G. Additional technical support or consulting services outside the scope of the support services described in this Agreement may be available to City upon request. These services shall be performed on a time and materials basis as specified in Schedule C. Examples may include setting up user accounts, setting up printer queues, performing file conversions, system maintenance (defragmenting the disk, system fine-tuning, etc.), and operating system training. 2. RESPONSE TIMES AND AVAILABILITY A. Definition. The help desk is the means of communication between the City and Company regarding all hardware and software issues itemized in Schedule A. The help desk provides the most efficient means to track, manage, and resolve all hardware and software issues itemized in Schedule A. B. Procedures. A toll-free number is provided to the City for help desk access. Calls are received and logged in the Hotline Call Tracking System and reviewed to determine priority. Necessary resources are then allocated to resolve each reported issue. The City shall be kept informed as to the status of the issue until resolution. Company has a comprehensive escalation procedure in place to ensure that all calls are handled in an expeditious manner. Response times should be timely and availability (on-site or remote) should meet the City's operational schedule. Support shall be provided off-site and includes remote diagnostic capability, which provides the most responsive on-line problem identification and resolution. C. Response Time. Company shall respond to the City's request for assistance via the help desk within two (2) hours of receipt. Response time is defined as the time it takes Company to assign and deploy resources to work towards resolving the problem. Company shall adhere to the following schedule in responding to City requests for assistance: • Priority 1 = Total system failure—2 hours • Priority 2 = Serious impairment to function of the system—4 hours • Priority 3 = Minor system malfunction—7-10 business days D. Hours of Operation. Company shall be available for support services Monday through Friday, 7:45 A.M. to 9:00 P.M. Eastern Standard Time, except for Company observed holidays as specified in Schedule D. On-site support may also be requested by the City as time and materials services as specified in Schedule C. 3. INVOICING AND PAYMENTS Application Software Support Agreement Maximus Justice Solutions/City of Fort Worth Page 14 of 19 A. Payments of the fees specified in the invoices shall be made by the City in accordance with the provision of Section 3 of this Agreement. B. Invoices for additional services that have been requested by the City shall also be submitted to the City for payment. These additional services shall be billed at Company's prevailing time and materials rates as specified in Schedule C unless otherwise specified. Application Software Support Agreement Maximus Justice Solutions/City of Fort Worth Page 15 of 19 SCHEDULE C TIME AND MATERIALS RATES The labor rates for this Agreement are as follows: PER HOUR Senior Company Officer.................................................... $250.00 Project Director.................................................................. $200.00 Project Manager................................................................. $175.00 Data Conversion.................................................................. $150.00 Programmer....................................................................... $150.00 Analyst............................................................................... $150.00 Tech Services.................................................................... $150.00 Trainer............................................................................... $125.00 Customer Support Representative..................................... $125.00 DBA Services......................................................... $125.00 TRAVEL TO AND FROM THE CITY'S SITE SHALL BE PRE-APPROVED IN WRITING BY AN AUTHORIZED SIGNATORY OF THE CITY. OUT-OF-POCKET EXPENSES SHALL BE BILLED AT DIRECT ACTUAL COST. Application Software Support Agreement Maximus Justice Solutions/City of Fort Worth Page 16 of 19 SCHEDULE D COMPANY OBSERVED HOLIDAYS NEW YEAR'S DAY MARTIN LUTHER KING, JR. DAY PRESIDENT'S DAY MEMORIAL DAY INDEPENDENCE DAY LABOR DAY VETERAN'S DAY THANKSGIVING DAY DAY AFTER THANKSGIVING CHRISTMAS DAY *EMPLOYEES HAVE OPTION OF SELECTING EITHER VETERANS DAY OR THE DAY AFTER THANKSGIVING Application Software Support Agreementl o m, 1 Maximus Justice Solutions/City of Fort Worth Page 17 of 19 ,�� SCHEDULE E ESCROW ENROLLMENT Application Software Support Agreement Maximus Justice Solutions/City of Fort Worth Page 18 of 19 FLEXSAFE BENEFICIARY ENROLLMENT Account Number 1021007-01001 Pursuant to the FIexSAFE Escrow Agreement ("Agreement") between MAXIMUS, Inc. as assignee of Crawford Consulting, and Iron Mountain as successor to DSI Technology Escrow Service, Inc., Depositor hereby enrolls the following as a FIexSAFE Beneficiary: Notices and communications to FIexSAFE Invoices to FIexSAFE Beneficiary should Beneficiary should be addressed to: be addressed to: Company Name: City of Fort Worth Fort Worth Municipal Court 1000 Throckmorton Street Fort Worth, Texas 76102 Designated Contact: Municipal Court Director Telephone: (817) 392-6760 Facsimile: (817) 392-6702 E-Mail: Jackie.mitchell(a)fortworthgov.org MAXIMUS, Inc. DSI Technology Escrow Services, Inc. Depositor By: By: Name: Name: Title: Title: Date: Date: Application Software Support Agreement Maximus Justice Solutions/City of Fort Worth Page 19 of 19 City of Fort Worth, Texas Mayor and Council Communication COUNCIL ACTION: Approved on 7/17/2007 - Ordinance #17654-07-2007 DATE: Tuesday, July 17, 2007 LOG NAME: 38MAXIMUS REFERENCE NO.: **G-15785 SUBJECT: Authorize Execution of an Application Software Support and Maintenance Agreement with Maximus Justice Solutions Division for the Municipal Court Integrated Electronic Case Management and Document Management System and Adopt Appropriation Ordinance RECOMMENDATION: It is recommended that the City Council: 1. Adopt the attached appropriation ordinance increasing estimated receipts and appropriations by $466,500.00 in the Special Trust Fund from available funds for the annual support and maintenance of the Municipal Court Case Management and Document Management System; 2. Authorize the City Manager to execute a five-year application software support and maintenance service agreement with MAXIMUS Justice Solutions Division, Inc., for the Municipal Court Integrated Case Management and Electronic Document Management System for amount not to exceed $93,300.00 annually and $466,500 in total; and 3. Authorize the City Manager to enter into subsequent annual renewals of the service agreement for application software support and maintenance services, subject to funds being appropriated for such renewal periods. DISCUSSION: In January of 2003, the City Council authorized the execution of an agreement with MAXIMUS Justice Solutions Division, Inc. (MAXIMUS), for the purchase of a case management and electronic document management system for the Municipal Court Department Integrated Management System (M&C C-19450). MAXIMUS is experienced in the implementation and support of the MAXIMUS application software and the MAXIMUS software has been customized for use specifically with Municipal Court's Integrated Management System. MAXIMUS was selected by Municipal Court, through a Request for Proposal (RFP) to implement the new case management and electronic document management system. The project has been successfully implemented and on-going support and maintenance of the new system by MAXIMUS will ensure efficient procedural and technical support and maintenance services of the case management product, including application software support and maintenance of the imaging and workflow modules. The initial warranty period for the system expired in December of 2006. The fixed price contract for the maintenance agreement is structured not to exceed $93,300 annually. The initial term will be five years. Subsequent renewals shall not require further Council approval provided that sufficient funds are properly appropriated for each renewal period. Logname: 38MAXIMUS Page 1 of 2 FISCAL INFORMATIONICERTIFICATION: The Finance Director certifies that upon approval of the above recommendations and adoption of the attached appropriation ordinance, funds will be available in the current operating budget, as appropriated, of the Special Trust Fund, Municipal Court Technology Project. TO Fund/Account/Centers FROM FundlAccount/Centers FE72 539120 038535010000 $466,500.00 FE72 539120 038535010000 $466.500.00 FE72 431038 038535010000 $466,500.00 Submitted for City Manager's Office by Joe Paniagua (6191) Originating Department Head: Jackie Mitchell (6711) Additional Information Contact: Jackie Mitchell (6711) Logname: 38MAXIMUS Page 2 of 2 CourtVIEW JUSTICE SOLUTIONS Application Design Document ISSUE PRODUCT Issue Number: 160309 CourtView Description: Municipal Court State Texas OCA Reporting CLIENT CONTACT PHONE EMAIL Fort Worth Rosie Martinez (817)392-6735 Sandy Mabett(State) 512-463-1640 CJS STAFF CJS ANALYST CLIENT PROCEED DATE EXPIRE DATE Brian Murphy Pat Besselman 01/21/2011 Revision History: Name Date Reason For Changes Version Pat Besselman 02/11/2011 Initial document creation 1.0 Related Issues: Issue Number Description Dependency/Reason 81898 State Mandated TX OCA Original Reporting Specification reporting. A. Business Needs The State of Texas has added reporting requirements to the Municipal Courts. The reports are submitted to the State each month to provide information to make decisions regarding the jurisdiction, structure and needs of the court system. • A report must be submitted each month even if there is no activity. • Only activity during the month will be reported. There are Four separate reports that will be generated and sent to the State. An XML file will be created to include all four reports. The Criminal Section, The Civil/Administrative Section, the Juvenile/Minor Activity and the Additional Activity reports where included in one report on the original OCA Municipal report. The new requirements have added reporting rows to each section and have defined four separate reports. A new spreadsheet will be created to include all four reports (identified as sections on the SCR set up screen). The functionality from the original Municipal report specification will be utilized to minimize user set up. The original Municipal report will remain and a new report will be developed for the 2011 changes. Some of the docket groups may be used for both reports while other docket groups will need to be created and added to the set up. The termination codes used for reporting will need to be updated with the new report SCR form, SCR Section and SCR row. The original Texas municipal report created the screens to enter the office code and cashbook codes to determine the financial disbursements to be reported. The current set up will be utilized in the New Municipal Report. (Issue 81898) The financial disbursement requirement is separating the total amount collected into two separate rows on the new report(kept by City and Remitted to State). This enhancement will require the set up of 3 new SYSPARS that will be used in conjunction with the current financial disbursement functionality to obtain the financial statistics required. The business logic to create the report will be executed for the report and the build transmission file. This replaces the current functionality that executes 2 different business processes, one for the report and the other for the build transmission file. The functionality from the original Municipal report will be used to create these reports when developed in Uniface. If the report is developed in Crystal reports then only the UNIFACE set up screens will be utilized for the reporting. Last saved 4/21120119:37:00 AM CourtView@ Jhstice Solutions Page 2 of 78 1. Create a new OCA—MUNICIPAL CITY SYSPAR to identify the Payee Codes (PAYEE_Xref id.CHKPAY02 Via the Acct_cd.ACCT)for amounts collected and kept by the city. a. The new OCA—MUNICIPAL_CITY SYSPAR must be set up for the office of the user, the flag checked and the payee xref numbers entered in the long value that will be reported on the Additional Activity Report row 18a (Fines, Court Costs and Other Amounts collected Kept by the City). b. The payee xref numbers will be entered and separated by a comma. c. The payee xref numbers may be entered in any order. d. The Xref numbers are added to the payee name VIA the financial management modu le4 Codes4C heck Payee4Enter the X-REF ID Navigation: CourtView4System Administration4Codes4System Parameters->Select Add. CRTS9950 S sear Maintenance CouriView(2.53 MSS 2008 Q. file M—o&kn Fg-rites -— Tools tit CjO3B 011ke Code U yyspr Grote 'rr�� System leve Parameter Herne DCA Qry u Sequence 0 wake Pert[ loop Value Date.Trms I Add Flap 2 Delift Site Lae Dasdr'Counter i DUAWAM Mramt km*ed F&M Dbplipr l.ea10114 LWn AgLcaaEnhaDmw System Parameter Name Description CourtView Field Office Code Office code of the users. OFIC CD.SYSPAR SysPar Group Enter the word "OCA"for this field. SYS_GRP.SYSPAR System Level MUNI SYS_LVL.SYSPAR Parameter Name OCA—MUNICIPAL—CITY SYS_NM.SYSPAR Value N/A VAL_STR.SYSPAR Long Value Enter the XREF numbers separated by TEXT.XSYSPAR Last saved 4/21/20119:37:00 AM CourtView®Justice Solutions Page 4 of 78 B. Data Model Changes 1. Alter the ROW SECT table to include the rs trans line field. C. Modifications 1. Create a new OCA—MUNICIPAL—CITY SYSPAR to identify the Account Codes(Acct_cd.ACCT) for amounts collected and kept by the city. 2. Create a new OCA—MUNICIPAL—STATE SYSPAR to identify the Account Codes (Acct_cd.ACCT)for amounts collected and remitted to the State. 3. Create new OCA_Judge_Report SYSPAR to identify the SCR default form that will be used to match to the case disposition records when the new Texas State Municipal report is executed. 4. Create a new Dismiss—Cost—Cd SYSPAR to identify the indigency dismissed cost code. 5. Add the TXMN SCR form code for the new Texas State Municipal report. 6. Modify the Supreme Court Report Screen CRTS0033 to link to the Texas Reporting Screen CRTS0083. 7. Create a new Texas Municipal Court Report Screen CRTSXX01. (CRTS0084) 8. Complete the setup for the Texas Municipal Court SCR Form Col/Section. 9. Modify the SCR Row/Section Screen CRTS9581 to allow the entry of the Transmission Line. 10. Complete the Texas Municipal Court SCR form Row/Section using the existing functionality available from CRTS9584 SCR Row/Section maintenance screen. 11. Create the Texas Municipal Court Report queries needed to extract the data for the report. 12. Complete the Invalid Section for the Texas Municipal Court report. 13. Create a Microsoft Excel®Spreadsheet for the placement of the extracted data into the report cells. 14. Create the XML Format for the submission of the data for the new Texas Municipal Report. Last saved 4/21/20119:37:00 AM CourtView®J3jstice Solutions Page 3 of 78 a comma. Include the XREF numbers that will be included for the amount collected and kept by the City. The Application Detail Records where the XREF number (payee_xref_id.CHKPAY02)via the account code matches one of the XREF numbers entered in the long value record will be included on the report and in the XML file. Flag Enabled VAL_FLG.SYSPAR Must be checked. Last saved 4/21/2011 9:37:00 AM CourtView@ Justice Solutions Page 5 of 78 2. Create a new OCA—MUNICIPAL—STATE SYSPAR to identify the Payee Codes (PAYEE_Xref id.CHKPAY02 Via the Acct_cd.ACCT)for amounts collected and kept by the State. a. The new OCA—MUNICIPAL—STATE SYSPAR must be set up for the office of the user, the flag checked and the payee xref numbers entered in the long value that will be reported on the Additional Activity Report row 18b (Fines, Court Costs and Other Amounts collected Kept by the State). b. The payee xref numbers will be entered and separated by a comma. c. The payee xref numbers may be entered in any order. d. The Xref numbers are added to the payee name VIA the financial management module-)Codes4 Check Payee4Enter the X-REF ID Navigation: CourtView4System Administration 4 Codes4 System Parameters4Select Add. CRTS9950 S sPar Maintenance 2008 Q. Environment) FF IV,, be MOMFWartes Cj08B Office Code ® SyWr aoW Watem Level L=J Pwan w IYme OCA STATE Sequence N Value Print �------- — Long VdLw Dws.Tme 7 Add Ret2W Fba t .Delete Record Record Lad Daed,Counter 7 Deselect All Amount tndYed Field Display LengM Llrw iRYn dan Lmao.r sSsrarrr .d weh--'---' System Parameter Name Description CourtView Field Office Code Office code of the users. OFIC CD.SYSPAR SysPar Group Enter the word"OCA"for this field. SYS_GRP.SYSPAR System Level MUNI SYS_LVL.SYSPAR Parameter Name OCA—MUNICIPAL—STATE SYS_NM.SYSPAR Value VAL STR.SYSPAR Last saved 4/21/20119:37:00 AM CourtView®Zistice Solutions Page 6 of 78 Long Value Enter the payee xref numbers TEXT.XSYSPAR separated by a comma. Include the XREF numbers that will be included for the amount collected and Kept by the State. The Application Detail Records where the XREF number (payee_xref id.CHKPAY02)via the account code matches one of the XREF numbers entered in the long value record will be included on the report and in the XML file. Flag Enabled VAL_FLG.SYSPAR Must be checked. Last saved 412112011 9:37:00 AM CourtView®Justice Solutions Page 7 of 78 3. Create new OCA—Judge_Report SYSPAR to identify the SCR default form that will be used to match to the case disposition records when the new Texas State Municipal report is executed. Navigation: CourtView�System Administration�Codes4System Parameters4Select Add. CRTS990 S sPar Maintenance Ca-ur I View(2.53 MSS rt:Q. ClOSB Office Cods ® SysPW Group ® System Level Parameter ltente I=AS Sequence d sly Value tf� print Lorry Volue Date!Tirne 1 Add Record Fug 2 Delete Record Leet UsedJCountet 7 Deselect All Amount Wkect Fleld DWPW Length L _ 4Mw lapin celtr hrllmer rCmawatfwd witi.—_�—.—> System Parameter Name Description CourtView Field Office Code Office code of the users. OFIC CD.SYSPAR SysPar Group Enter the word "OCA"for this field. SYS_GRP.SYSPAR System Level MUNI SYS_LVL.SYSPAR Parameter Name OCA—MUNICIPAL—STATE SYS NM.SYSPAR Value TXM VAL STR.SYSPAR TXM is the only valid entry for this field. Long Value TEXT.XSYSPAR Flag Enabled VAL_FLG.SYSPAR Must be checked. Last saved 4/21/20119:37:00 AM CourtView®Jljstice Solutions Page 8 of 78 4. Create a new Dismiss—Cost—Cd SYSPAR to identify the indigency dismissed cost code. The dismiss cost code will be accessed for waived fees in Indigency cases. Navigation: CourtView4System Ad ministration 4Codes4 System Parameters4Select Add. rflCourtftw(2.53 MSS 11: 1. Environment) 0ii Fb Fjo:wites _ —_ _ T,vd; licb CjoeB Owe Code F�— SysPer Groty ® %*am Level L� Parameter lbme 106 -COST-CD Sequence k Value Wa Print Long Value Date,-Time 1 AM Record Flag 2 Delete ct uaedrCounter 7 Deselect All All AmoAmount Nxliect Field Display Length r Lluu Ap4haEn LsDmw System Parameter Name Description CourtView Field Office Code Office code of the users. OFIC CD.SYSPAR SysPar Group Enter the word "OCA"for this field. SYS_GRP.SYSPAR System Level MUNI SYS_LVL.SYSPAR Parameter Name DISMISS—COST—CD SYS_NM.SYSPAR Value IND VAL_STR.SYSPAR Long Value TEXT.XSYSPAR Flag Enabled VAL_FLG.SYSPAR Must be checked. Last saved 4/21/2011 9:37:00 AM CourtView®.Wstice Solutions Page 9 of 78 5. Add the TXMN SCR form code for the new Texas State Municipal report. a. Create the TXMN SCR form code for the new Texas State Municipal report. b. SCR form = TXMN for the Texas Municipal Court Report. c. The TXMN report will include the 1) The Texas Municipal Criminal Report, 2) The Texas Municipal Juvenile Report, 3) The Texas Municipal Civil report and 4) The Texas Municipal Additional Activity report. d. An SCR section will be defined for each report and set up on the SCR Row/Section screen defined in C7. e. Screen set up: SCR Form =TXMN (Required to be this code) Description =Texas Municipal Court Report(new) (user defined) File Location = [enter the file path and name of the file where the Microsoft Excel® Spreadsheet is found on the network using the filename as given] Navigation: System Administration 4Codes4 SCR Form, then click the Add Link. Enter the data as shown below: CRTS9580 SCR Form Maintenances JY: 4A Environment) .__ !Je PkdY�s F�ctbns fleports y446i Fivories _Y.ali. a,�« `�#, twl SCR Form IVIdinteadnce e X1¢79. !.._—..._.._� SCR form Rim— i�&nt - _,_. DeeagKlaY Tse lMl 1 Add Record _ CMPD DBlete Retort Fie Location 12.5"RDSRTSM4ee4_2 It-In top-LAS 4 SCR Row 5 SCR Column a Invalid ColumnfRow 7 RoWSeebon a Columnlsecaon a Irnakdl8edlon io FdrdRatiort It 011kelcashbook tr Receh*to Column Last saved 4/21/20119:37:00 AM CourtView®90stice Solutions Page 10 of 78 6. Modify the Supreme Court Report Screen CRTS0033 to link to the Texas Reporting Screen CRTS0083. This is current functionality./ a. Modify the Supreme Court Report Screen CRTS0033 to link to the Texas Reporting Screen CRTS0083 when the first three characters of SCR_cd.SCRCD =TXM. b. When the Texas Municipal Court Report is selected the Texas reporting link will be available and not grayed out. c. Navigation: CourtView4Case Management 4Functions4Supreme Court Reports CRTS0033 Supreme Court Report fb M*AArs FTKtb-a Reports �Mes }derMies F9fortes 1:'_.- wirIrts Ludy rr*j Close Search Criteria Search gear ::P.rxiMhl aeg �Juddge Open Tna r,at«S End Date i.s RowPPL- Caee Number Error �_ ar teare..l INlesing FileAleopen Date soil 1;O%q n prim a or t Search Resuhs z 7 Col lbw Stat VJ Judge Case!lumber FDe.Neopen IN Inrormal Dt Term Date PPG Error# 4 t S e f +t Texas ReporonD w Last saved 4/21/2011 9:37:00 AM CourtView®JOstice Solutions Page 11 of 78 7. Create a new the Texas Municipal Court Report Screen CRTSXX01. (CRTS0084) a. The Texas Municipal Court Report Screen will be linked from the SCR selection screen CRTS0033 and will be available when the Texas Municipal Court Report(scr cd.SCRCD =TXMN)is selected. b. The new Texas Municipal Report Screen will be based on the current Texas State Municipal report screen CRTS0083. c. Rows that include totals will not display on the screen since the rows are simply added together and records are not retrieved in the process. d. NOTE: If this process is changed the release notes will be updated with the exact process to read the case disposition records for the"TXM" Judges report. Navigation: CourtView4Case Management 4Functions4Supreme Court Reports4select the Texas Municipal Court Report. RTSXXOI Texas MUnici al Court Re ort Screen QA t k Modules FWXtlons @-Ports Cpfflz 1dvO, Fjv ices fader ek g-rc jr,* Trargmkslorrs I Search Criteria I Sealch /hear Cjoae - SCR Form Tax"Maris"Court New Cobenn Qp9a Begin Date F Row End Oda Error II Case Numbsr Total Revenue i Print Search Restdts Col Row Case Number Me gde Term Bete Term Code Ern t Fde ramapdh 1111-n1d om.CCWP OME nd awM-r Texas Muni ci al Court Report Screen CRTSXX01 field definition. Tab Screen Field Displayed Field(s) Type/Length Information/Path Req? Order Label Updated Display only of the SCR description of the SCR N/A Form DSCR.SCRCD (display only) varchar/50 Form carried to this screen N/A from the calling screen CRTS0033. Will default to null upon entry to the screen. Begin Allow this field to be 1` Date Date Field None Date changed. Y The begin date can not be reate r than the end date Last saved 4/21/20119:37:00 AM CourtView®9Astice Solutions Page 12 of 78 Tab Screen Field Displayed Fields) Type/Length Information/Path Req? Order Label Updated Else an error message will display upon selecting the search button. "The Begin date can not be greater than the end date." If the begin date is not entered and the end date is entered upon selecting Search an error message will display. "Both search dates must be entered before searching." Will default to null upon entry to the screen. Allow this field to be changed. The end date must be greater than or equal to the being date. Else an error message will display upon selecting the 2. End Date Date Field None Date search button. Y "The End date can not be less than the begin date. If the begin date is entered and the end date is not entered upon selecting Search an error message will display. "Both search dates must be entered before searching." Used to allow for the entry of an individual case Drown Arrow field number by type and tab for search and with automatic formatting Case select which will for the case number 3' Number open to the Case N/A N/A (Standard CourtView® N Selection Screen functionality)or accessing CRTS0900 the down arrow opening to CRTS0900 for standard search and selection. Dropdown field When entered, will search listing only the valid only for those records with 4. Section Section from N/A N/A the selected column and R RS SECTION. date range. Defaults to ROW_SECT null' When entered, will search only for those records with Dropdown field the selected column and 5. Column listing only the valid N/A N/A date range. Defaults to C columns from null' CS_COLCOL_SECT The column is not required when the row is selected. Last saved 4/21120119:37:00 AM CourtView®JOstice Solutions Page 13 of 78 Tab Screen Field Displayed Field(s) Type/Length Information/Path Req? Order Label Updated Dropdown field When entered, will search listing only the valid only for those records with 6. Row rows from N/A N/A the selected row and date Y RS_ROW.ROW_SECT range. Defaults to'null' Defaults to 'blank' upon entering the screen. Once Dropdown list selected, will allow for the 7. Error containing All, N/A N/A search against combined N Correct, Error. criteria requested only show for the errors selected. N/A Total (Display Only) N/A Money Calculated total from the N/A Revenue Revenue Query Search Results Area Column Label Field Displayed Information/Path 1 Sec RS SECTION. Displays the Section associated with the resulting search's record. ROW SECT 2 Col CS_COL.COL_SECT Displays the Column Code associated with the resulting search's record 3 Row RS ROW.ROW_SECT Displays the Row Code associated with the resultingsearch's record 4 Case _DSCR.CASE Displays the Case Number of the resulting search's record Number Displays the SCR Date from the resulting search's record disposition 5 File Date SCR_DT.DSP record. If query is for a DKTFILE record or a Docket Group Standard query, the DT.DKT will be displayed in this field Term Displays the Termination Date from the resulting search's record 6 Date SCR_TERM_DT.DSP disposition record 7 Term TERM_CD.DSP Displays the Termination Code from the resulting search's record Code disposition record 8 Error ERROR NBR.CRTS0033 Displays the error number if a resulting search's record contains an error. See below for complete list of errors and their meaning) File Allows the user to enter the filename and path to store the electronic 9 Name/Pa FILE-PATH(DUMMY FILE) file being created when the'Build File'dynamic link is selected. (See th Dynamic Link Array following this table 10 N/A (MORE BUTTON) Opens to the standard Microsoft Windows®'Save As' dialogue box that allows the user to browse/select the filename and path. Last saved 4121120119:37:00 AM CourtView®9dstice Solutions Page 14 of 78 e. The following error messages will be valid messages that may be given during the 'SEARCH' process for the operation of the Texas Municipal Court Report. Error Number Message 1 Termination date is less than file date 3 SCR Column is blank 4 SCR Row is blank 5 SCR Column is out of range 6 SCR Row is out of range 7 SCR Column—Row combination is in an 'X' cell invalid cell 8 Termination Date not null with Termination Code of'UNTERM' f. Create all necessary additional user messages for the operation of this report. The message shown below will be given upon accessing the REPORT Dynamic link on CRTSXX01. Do you wish to include the Total Revenue? The default for the message will be 'Yes'. When 'Yes is selected, the query for Lines/rows 23,24 and 25 of the Additional Activity Report Section D will be included in the report operation and the total for that query will display as indicated in the Search Criteria area of screen CRTSXX01. g. Create a new message to be used when the'BLD FILE' dynamic link is accessed from CRTSXX01 to ask the user if the file being created is a Correction File. Create the message as follows: IF this•C"'Mo nFYsi The default for the message is'No'. Upon 'No' the XML file will be built using the Non- Correction file with the Header information. Upon 'Yes'the file will be built using the Header information for the Correction File. Last saved 4/21/2011 9:37:00 AM CourtView®96stice Solutions Page 15 of 78 8. Complete the setup for the Texas Municipal Court SCR Form Col/Section. Navigation: System Administration 4 Codes4 SC R Forms4Open the TXMN form4select the COUSECT link. Enter the setup for the Columns and Sections as indicated in the matrix below(Required Setup): a. Report each case in the appropriate column where the SCR_FORM.DSPSCR= 'TXMN' and obtain the column information from SCR_COL.DSP for A,B,C,D,E,F,G.,H, I , J, K b. SCR Section and Time GDLN will be used to designate the order that the descriptions will be added to the XML file. The SCR column is in ascending Alpha order therefore the Time Gdln will be used to designate the actual row that is used in the XML file. c. All setup must be exactly as shown below d. Note: COLUMN B will now report on the Civil report and not be included on the Criminal report per Ft. Worth instructions. e. Note: COLUMN K is new for the Non-Traffic Penal Code Filed case types. The new case type will be set up for this column. The column of K will be set up on the action code. f. Note: The Juvenile case types JV and JVI report both in the Criminal section A and in the Juvenile Section C of the report. Navigation: System Administration4Codes4SCR Forms4Open the desired form (i.e. TXMN) and mess the COUSECT buttcrt. t'CauitVirw 2.55 Dev MSS 2008 PEN Fie _MA An Fgxb— Reports QWn Fff—tes ek.Q" Lkk— Tge1s Frk Close Description Tuail SCR R Section SCR Conon Description Thne Gdn Cohsnn Xref I, A Non-Prrhnnti Cases Filed 1 TRAFFIC_NOW A B CM-PwItI nD Cases Filed 2 -TRAFFIC-PARI Pmlt A C Non-Trdlk Odw State low filed S NONTRAFFIC_l1 A D Non_Trdik City Ordinance Cases Filed / ININmufI:_t-j 1 Add Record A J city Ordnance Filed 7 TRAFFIC CITY! 2 Delete Record A N Mon taflk Pend Code Filed 4 NONTRAFF�IC_,,1,,1 D D CIA 1 LN1EWNIBER C 1 Juvenile 1 LINEMNABER D E Seaeh VOiff nts Issued 1 LBENIIMBHt D F MsD.Mlrnnnils CAven A i B Misdemeanors 1 LNIENU BER D G Mail.YFarrigs Given Felaiee 1 LMIEND6BEIt Mea Or ' 0 N Meders for Emsrilency Protection 1 LNEMIMBIER D 1 Other Section 1 LMIEMILSIM h 1 1 4KX11 CoutView hot SoMiions + SCR SCR Description Time Column Xref Section Column GDLN A A Non-Parking Cases Filed 1 Traffic Nonparking A B CIVIL - Parking Cases Filed 2 Traffic Parkin A J City Ordinance Filed 3 Traffic Ci Ordinance A K Non-Traffic Penal Code Filed 4 NonTraffic PenalCode A C Non-Traffic Other State Law Filed 5 NonTraffic Other Last saved 4/21120119:37:00 AM CourtView®J6stice Solutions Page 16 of 78 StateLaw A D Non-Traffic City Ordinance Cases Filed 6 NonTraffic Cit Ordinance B B Civil 1 LINENUMBER C I Juvenile 1 LINENUMBER D E Mag. Orders for Emergency Protection 1 LINENUMER D F Mag. Warnings Given A& B Misdemeanors 1 LINENUMBER D G Mag. Warnings Given Felonies 1 LINENUMBER D H Ma . Orders for Emergency Protection 1 LINENUMBER D I Misc. Activity 1 LINENUMBER Last saved 412112011 9:37:00 AM CourtView®aastice Solutions Page 17 of 78 9. Modify the SCR Row/Section Screen CRTS9581 to allow the entry of the Transmission Line. a. Change the Transmission Code label to Trans Code. b. Add the column Trans Line next to the Trans Code. c. Allow the entry of Alpha and numeric values. d. The Trans Line field is required. e. The Trans Line entry will be stored in the rs_trans_line.ROW—SECT field. The rs_trans_line field is being added to the table as defined in Data Model Changes B at the end of the document. f. The new column will appear for all users. The Texas users will be entering the line numbers to correspond to the XML transmission file that is sent to the state of OCA for the new Municipal reporting requirements. No other report will be using this column at this time. g. The entered Transmission lines must match the XML file provided by the State. h. The below screen shot is an example and does not reflect the actual set up. The set up is defined in C8. Navigation: Cou rtView4 System Administration 4Codes4SCR4select a form and open to the Row/Section set up screen. CRTS9591 SCR Row/Section Maintenance Screen r!OUrlyiew(2.53 MSS rt: t. . VE b1Ddu1e5 FWCt— Reports Codes FDvortes Plug-Ins Lkg*s Tods rib C109e Deacrip - Te aNkMftiWCawt _p SCR SCR SCR Row Tram Trans Description Docket Tickler Tickler Part Section Row Code Code Line Gray Gray 1 Group 2 '� 1 d ave OPHI 7 1 Cases Filed > > '+ PfiM ? ; 2 1x1 Bond Forfeitures Prior to Trial > > ! i f a2 Fined Prior to Trial > > > J 4 2 Cases Diem Prior to Trial > > > 1 Add Record 5 5 3 Trial by hndpe-Guilty > > 2 Delete RecordN a i 4 Trial by -Bot Guilty > > T 2 5 Trial by Jury-Guilty > > > a i { Trial by Jury-Not Guilty > r I T Dismissed at Trial > > > 1 e 1e Tal Dismissed Iter Driver Safety C > > I I 11 TO Dismissed after Deferred Dispe :>) > > I 12 to Dismissed after Proof d Fkwx > > 1 t 1tb Compliance Dismissal > > i 71 1C!T= tyServiceOrdered CSORDERH > > 13 119t0 Cases Appealed APPEAL-T > > 14 olfihU 11 =11 JAE Transportation Cods Caser A4TRCF-T> 1421 1T DRTFI.E ie '12JADE Bon-Driving Alcoholic Bevy JMDALC-ORTH E 1T 11 JAM Driving under the IrAm ee JMIDIR-T)QD"TFI..E 1s .14 JAM Berth and Sfety(Tobacco' MMST-T)DRTFLE 21 1 S JAM Failure to Attend School Ca JFTAS-Ail>OItTFIP 22 1e JAM Education Code(except FAi JEDC-TXN> > I>! Y DRTIiE 35 t7 JM Violation of Local Daytime( JCtllfF-TX > If DIITfLE ?t tM JM1 AN Other Non-Truk Fine-O JNTFO-TX > fI 2# DKTTOT i22 1f JAM Waiver of Jurisdkxion of No JVWVJSDN > > > x l P 4}eie CftTS9dM Usd_bessdman Datelfime 02f25f2011 15:45:03.41 M1H C 5-5ALL20!&wcdv2 " 411 Last saved 4/21/2011 9:37:00 AM CourtView®96stice Solutions Page 18 of 78 10. Complete the Texas Municipal Court Report SCR form Row/Section using the existing functionality available from CRTS9581 SCR Row/Section maintenance screen. Navigation: System Administration 4Codes4SCR Forms4Open the form TXMN and access the ROW/SECT Link a. The row and section set up defines the process that will be executed for each row of the report. General Row code definitions: i. If the Row Code is null then the most recent disposition record within the reporting period for the case will be used to determine if the case will be reported. The case will be reported based on the set up on the termination code associated to the disposition record. ii. If the Row Code is NOT null then a defined process will be executed to determine if the case will be reported. iii. If the Row Code is Null and the docket group is NOT null then the dockets within the docket group will be used to determine if the case will be reported. iv. If the Row Code is NOT null and the docket group is NOT null then the most recent disposition record within the reporting period and the docket group is used to determine if the case will be reported. b. The docket groups can be defined by the Court and set up. The Docket Groups defined in the Matrix are a representation of rows where docket groups must be set up for reporting. c. The Trans line is a new column that must match the line defined in the XML schema. d. The following is the required Set Up for the Report. e. Note: Each criminal case can only have one charge. Multiple cases are created for each charge associated to the party. f. The Trans Code field will be used as the LINENUMBER tag in the XML file. g. The Trans Line field will be used as the LINE tag in the XML file. h. TRMDSP or DKTTOT can be used for rows A8 thru A22 and 68 thru 614. The court will decide whether to use dockets or to use the terminations to count in the rows. • The TRMDSP function will count the case when the termination row on the case disposition record equals the SCR Row defined in the SCR set up. Using this Row Code the user must set up new termination codes to be used for the first reporting period. • The DKTTOT function will count the dockets on the case that match the dockets in the docket group where the docket date is greater than or equal to the reporting begin date and less than or equal to the reporting end date. If there are multiple dockets between the reporting dates then all dockets will be counted. A case may be opened, closed and reopened within the same period and all dockets would need to be counted. Using this Row Code of DKTTOT, the user will need to set up Docket groups for the new reporting. The docket group must include all of the dockets that should report on the case. Existing Docket groups may be used if the dockets within the group are valid for the row. • The below representation is showing both DOCKET GROUP and Row code. Either the Row Code or the Docket group will be entered, NOT BOTH. SCR SCR Row Trans. Trans Description Docket Tick Tic SECT Row Code Code Line Group G 1 G A 1 BPENDTOT 1001 1 Cases Pending First of Month A 2 BPENDA 1002 la Cases pending First of Month—Active Cases A 3 BPENDIN 1003 1 b Cases Pending First of Month—Inactive Cases A 4 OPEN 1004 2 New Cases Filed A 1 5 REOPEN 1005 3 Cases Reactivated A 6 DKTTOT 1006 4 All Other Cases Added OTHROPEN A 7 TOTCASES 1007 5 Total Cases on Docket A 8 TRMDSP 1008 6a Uncontested Dispositions Prior to Court UNCONPRCRT A 9 TRMDSP 1009 6b Cases Dismissed by Prosecution Prior to Court DISSMISSPROS A 10 TRMDSP 1010 7a1 Guilty Plea or Nolo Contendere at Trial NOLOCONT Last saved 4/21/2011 9:37:00 AM CourtView®419stice Solutions Page 19 of 78 SCR SCR Row Trans. Trans Description Docket Tick Tick SECT Row Code Code Line Group G 1 G 2 A 11 TRMDSP 1011 7a2 Convictions—By Court CRTCONVIC A 12 TRMDSP 1012 7a3 Convictions—By the Jury JURYCONVIC A 13 TRMDSP 1013 7b1 Acquittals—By the Court CRTACQUIT A 14 TRMDSP 1014 7b2 Acquittals—By the Jury JURYACQUIT A 15 TRMDSP 1015 7c Cases Dismissed by Prosecution at Trial PROSDISSM A 16 TRMDSP 1016 8a Compliance Dismissals: After Driver Safety DRIVERSAFE Course A 17 TRMDSP 1017 8b Compliance Dismissals:After Deferred DISMISSDEF Disposition A 18 TRMDSP 1018 8c Compliance Dismissals: After Teen Court DISMISSTEEN A 19 TRMDSP 1019 8d Compliance Dismissals:After tobacco DISMISSTOB Awareness Course A 20 TRMDSP 1020 8e Compliance Dismissals: After Treatment for DISTREATMNT Chemical Dependency A 21 TRMDSP 1021 8f Compliance Dismissals: After proof of DISMISSFINAN Financial responsibility A 22 TRMDSP 1022 8g Compliance Dismissals: All other DISMISSTRANS Transportation Code Dismissals A 23 DKTTOT 1031 9 All Other Dispositions OTHRDSP A 24 TOTDISP 1023 10 Total Cases Disposed A 25 INACTIVE 1024 11 Cases Placed on Inactive A 26 EOMPENA 1025 1 12 Cases Pending End of Month A 27 EOMACT 1026 12a Cases Pending End of Month—Active cases 28 EOMIACT 1027 12b Cases Pending End of Month—Inactive cases A 29 DKTTOT 1028 13 Show Cause Hearings Held SCHEAR A 30 DKTTOT 1029 14a Case Appealed:After Trial APPTRIAL A 31 DKTTOT 1030 14b Case Appealed:Without Trial APPNOTRIAL B 1 BPENDTOT 1200 1 Cases pending First of Month B 2 BPENDA 1201 1 a Cases Pending First of Month—Active Cases B 3 BPENDIN 1202 1 b Cases Pending First of Month—Inactive Cases B 4 OPEN 1203 2 New Cases Filed B 5 REOPEN 1204 3 Cases Reactivated B 6 DKTTOT 1205 4 All other Cases Added OTHROPEN B 7 TOTCASES 1206 5 Total Cases on Docket B 8 TRMDSP 1207 6 Uncontested Civil Fines or Penalties B 9 TRMDSP 1208 7 Default Judgment B 10 TRMDSP 1209 8 Agreed judgments B 11 TRMDSP 1210 9 Trial/Hearin by Judge/HearingJudge/Hearing Officer B 12 TRMDSP 1211 10 Trial by Jury Old report was broken out B 13 TRMDSP 1212 11 Cases Dismissed for Want of Prosecution B 14 TRMDSP 1220 12 All Other Dispositions B 15 TOTDISPB 1213 13 Total Cases Disposed B 16 INACTIVE 1214 14 Cases Placed on Inactive Status B 17 EOMPENB 1215 15 Cases Pending End of Month B 18 EOMACTB 1216 15a Cases Pending End of Month-Active B 19 EOMIACTB 1217 15b Cases Pending End of Month—In-active B 20 DKTTOT 1218 16a Cases Appealed:After Trial APPEALTRIAL B 21 DKTTOT 1219 16b Cases Appealed:Without Trial APPEALNOTR C 1 DKTFILE 1101 1 Transportation Code Cass Filed JMTRCF C 2 DKTFILE 1102 2 Non-Driving Alcoholic Beverage Code Cases JNDALC Filed. C 3 DKTFILE 1103 3 Driving Under the Influence of Alcohol Cases JMDUI Field C 4 DKTFILE 1104 4 Drug Paraphernalia Cases Filed JMDUI C 5 DKTFILE 1105 1 5 Tobacco Cass Filed JMHST C 6 DKTFILE 1106 6 Failure to Attend School Classes Filed. JFTAS C 7 DKTFILE 1107 7 Education Code(Except Failure to Attend) JEDC Cass Filed C 8 DKTFILE 1108 8 Violation of Local Daytime Curfew Ordinance JCURF Cases Filed C 9 DKTFILE 1109 9 All Other Non-traffic Fine-Only Cases Filed JNTFO C 10 DKTFILE 1110 10a Mandatory Transfer to Juvenile Court JCMTRN C 11 DKTFILE 1111 10b Discretionary Transfer to Juvenile Court JCDTRN C 12 DKTTOT 1112 11 Accused of Contempt and Referred to Juvenile JVACNTMPT Court Fined and/or Denied Driving Privileges) C 13 DKTTOT 1113 12 Held in Contempt by Criminal Court(Fined JVCNTMPT and/or Denied Driving Privileges) C 14 1 DKTTOT 1114 13a Juvenile Statement Magistrate Warnings JVWRN Last saved 4/21/20119:37:00 AM CourtView®20stice Solutions Page 20 of 78 SCR SCR Row Trans. Trans Description Docket Tick Tic SECT Row Code Code Line Group G 7 G Administered C 15 DKTTOT 1115 13b Juvenile Statements Certified by Jude JVSTCERT C 16 DKTTOT 1116 14 Detention Hearings Held DETHELD C 17 DKTTOT 1117 15 Orders for Non-Secure Custody Issued ORDNSCUST C 18 DKTTOT 1118 16 Parent Contributing to Nonattendance Cases PTCNTRB Filed D 1 DKTFILE 1301 1a Magistrate Warnings:Class C Misdemeanors MISDC Need to discuss with users. D 2 OPENF 1302 lb Magistrate Warnings:Class A and B or Misdemeanors DKTFILE D 3 DKTFILE 1302 1b Number of Requests For Counsel REQCOUN D 4 OPENG 1303 1c Magistrate Warnings: Felonies OR DKTFILE D 5 DKTFILE 1303 1c Number of Requests For Counsel REQCOUN D 6 DKTTOT 1304 2a Arrest Warrants Issued:Class C Misdemeanors WRNTCMISD D 7 DKTTOT 1305 2b Arrest Warrants Issued:Class A and B WRNTFAB Misdemeanors D 8 DKTTOT 1306 2c Arrest Warrants Issued:Felonies WRNTF D 9 DKTTOT 1307 3 Ca iases Pro Fine Issued CAPIASES D 10 DKTTOT 1308 4 Search Warrants Issued WRNTSRC D 11 DKTTOT 1309 5 Warrants for Fire,Health and Code Inspections WRTNFH Filed D 12 DKTTOT 1310 6 1 Examining Trials Conducted EXAMTRIAL D 13 DKTTOT 1311 7 Emergency Mental Health Hearings Held EMRGHHRNG D 14 OPENH 1312 8 Magistrate's Orders for Emergency Protection or Issued DKTFILE D 15 DKTTOT 1313 9 Magistrate's Orders for Ignition Interlock Device DKTGRP Issued D 16 DKTTOT 1314 10 All Other Magistrate's Orders Issued Requiring DKTGRP Conditions for Release on Bond D 17 DKTTOT 1315 11 Driver's License Denial,Revocation or HEARDRLLIC Suspension Hearings Held D 18 DKTTOT 1316 12 Disposition of Stolen Property Hearings Held HEARPROP D 19 DKTTOT 1317 13 Peace Bond Hearings Held HEARPB D 20 DKTTOT 1318 14a Cases in Which Fine and Court Costs Satisfied COMSERPART b Community Service:Partial Satisfaction D 21 DKTTOT 1319 14b Cases in Which Fine and Court Costs Satisfied COMSERFULL by Community Service: Full Satisfaction D 22 DKTTOT 1320 15 Cases in Which Fine and Court Costs Satisfied JAILFINE by Jail Credit D 23 FINESWIC 1321 16 Cases in Which Fine and Court Costs waived INDIGENCY for Indi enc D 24 FINESWI 1322 17 Amount of Fines and Court Costs Waived for INDIGENCY Indi enc D 25 REVCITY 1323 18a Fines,Court Costs and Other Amounts: Kept by Cit D 26 REVSTATE 1324 18b Fines,Court Costs and Other Amounts: Remitted to State D 27 TOTREV 1325 18c Fines,Court Costs and Other Amounts:Total Collected Last saved 4/21/20119:37:00 AM CourtView®IOstice Solutions Page 21 of 78 11. Create the Texas Municipal Court Report queries needed to extract the data for the report. Row Extraction Process Code When extracting and using the disposition record to count cases,the Judges report(scr_form.DSPSCR) must match the selected Judges report from the report ammeter screen. BPENDTOT Sum of lines SCR rows 2 + 3 from Section A. (Trans Line 1a+ 1b). NEW This query may be used for different sections. BPENDA Count all cases where the SCR_CD.DSP= 'O' or the SCR_CD.DSP="RO" and the NEW SCR_DT.DSP is less than the reporting period BEGIN DATE and the termination date SCR_TERM_DT.DSP is'NULL' or the termination date is greater than or equal to the reporting begin date and the Judges report(scr_form.DSPSCR) matches the selected Judges report on the report parameter screen. This query may be used for different sections. BPENDIN Count all cases where the SCR_CD.DSP = 'O' or the SCR_CD.DSP="RO"and the NEW termination date SCR_TERM_DT.DSP is populated, the termination date is less than the reporting begin date and the Termination code is flagged as Inactive (stop_time.TERMCD01)and the Judges report(scr_form.DSPSCR) matches the selected Judges report on the report parameter screen. NOTE: An inactive case when it becomes active is counted as reactivated. This que may be used for different sections. OPEN Count all records where the SCR_CD.DSP = 'O' and the SCR_DT.DSP is greater than or equal to the reporting period BEGIN DATE and is less than or equal to the reporting period END DATE and the Judges report(scr form.DSPSCR) matches the selected Judges report on the report parameter screen. This query may be used for different sections. REOPEN Count all records where the SCR_CD.DSP = 'RO' and the SCR_DT.DSP is greater than NEW or equal to the reporting period BEGIN DATE and is less than or equal to the reporting period END DATE and the Judges report(scr_form.DSPSCR) matches the selected Judges re ort on the report parameter screen TOTCASES This field is the sum or rows of row codes(2 +4 +5 +6) =TOTCASES for each column NEW in the section. Ex. Section A will sum rows 2 +4+ 5+6 for columns in section A only. (Trans Line= la +2 + 3+4 =5). Ex. Section B will sum rows 2 +4 + 5 +6 for columns in section A only. (Trans Line= la +2 + 3+4 = 5). This query may be used for different sections. TRMDSP Terminations NEW Obtain all records where all of the following statements are TRUE. There may be multiple Termination report Codes associated to the Termination Code. The SCR form, SCR section and SCR row on the termination code must be found for the Form and Row for the SCR section from the set up that is being processed. • The SCR_TERM_DT.DSP is greater than or equal to the reporting period BEGIN DATE and is less than or equal to the reporting period END DATE. • The SCR_ROW.DSP=the row from the set up that is being processed. • This query may be used for different sections. TOTDISP This is the sum of rows SCR row= (8 + 9 + 10+11+12+13+14+15 +16+17+ NEW 18+19+20+21+22 +23)or (Trans Line 6a +6B + 7a1, + 7a2, +7a3, + 7b1, +7b2, +7c, +8a, +8b, +8c, +8d, +8e,+ 8f,+8g + 9 = 10) for each valid case type column. INACTIVE Report cases that have been placed on inactive status during the month. NEW Count all cases where the SCR_CD.DSP = 'O' or the SCR_CD.DSP="RO" (for the case es in the column and the SCR TERM DT.DSP is populated and the termination date Last saved 4/21/20119:37:00 AM CourtView®20stice Solutions Page 22 of 78 Row Extraction Process Code When extracting and using the disposition record to count cases,the Judges report(scr form.DSPSCR)must match the selected Judges report from the report parameter screen. is greater than or equal to the reporting begin date, the termination date is less than or equal to the Report End date and the Termination code is flagged as Inactive (stop—time.TERMCD01)and the Judges report(scr—form.DSPSCR) matches the selected Judges report on the report parameter screen EOMPENA Sum of SCR rows(27 +28) NEW Trans Lines 12a+ 12b EOMACT SCR Row(7—(24+ 25) NEW Trans lines 5— 10 + 11 = 12a EOMIACT SCR Row( 3—(5+25) NEW Trans lines 1 b— 3+ 11 = 12b EOMPENB Sum of SCR rows(18 + 19) NEW Trans Lines sum of(15a+ 15b) For Section B DKTTOT Using the docket codes belonging to the Docket Report Group listed in the Docket Group Column, find all docket codes that match where the DT.DKT is greater than or equal to the reporting period BEGIN DATE and is less than or equal to the reporting period END DATE then count the docket code(s)for this row. Multiple dockets may be find and added during the month. All will be added to the total in this row. TOTDISPB This is the sum of SCR row= ( 8 + 9 + 10+ 11+ 12+ 13 + 14) NEW for each column in section B. TransLine6 + 7 + 8 +9 + 10+ 11+ 12 = 13 EOMPENB This is the sum of SCR Row= (18+19)= 17 NEW for each valid column in section B. Trans Line 15a + 15b = 15 EOMACTB This is the sum of SCR rows(7—(15 + 16)= 18 NEW for each valid column in section B Trans Line 5— 13 + 14 = 15a EOMIACTB SCR Row(3—(5+ 16) = 19 NEW for each valid column in section B Trans lines 1 b— 3 + 14 = 15b DKTFILE This is current functionality from the old report. Using the docket codes belonging to the Docket Report Group listed in the Docket Group Column, find all docket codes that match where the DT.DKT is greater than the reporting begin date. Using the CASE—ID.DKT examine the DSP record. There may be multiple disposition records on the case but only one should have the SCR—CD.DSP ="O". Retrieve the one where the SCR—DT.DSP is greater than or equal to the reporting period BEGIN DATE and is less than or equal to the reporting period END DATE, the SCR_FORM.DSPSCR = 'TXM', the SCR—CD.DSP = 'O' and the Judges report(scr—form.DSPSCR) matches the selected Judges report on the report parameter screen. If none found then the case will not be counted. Then count the case when the dt.DKT for any of the dockets found within the docket group is greater then the SCR—DT.DSP. If there are multiple dockets of the same Docket Code for the case for the reporting time period, count only ONCE. Release Notes: issue 126174 Information only. The case file date really is not being used. The SCR DT.DSP is used. Last saved 4/21/20119:37:00 AM CourtView®20stice Solutions Page 23 of 78 Row Extraction Process Code When extracting and using the disposition record to count cases,the Judges report(scr form.DSPSCR)must match the selected Judges report from the report parameter screen. The Texas Municipal Supreme Court Report, CRTS0083, lines 16 through 24 and 29 have been modified to report and count cases once based on the case filed date within the Begin and End Date range selected regardless if the case is filed at the end of one month and the docket added the first day of the next month. OPENF Obtain all records where the SCR_CD.DSP = 'O'and the SCR_DT.DSP is greater than or equal to the reporting period BEGIN DATE and is less than or equal to the reporting period END DATE and the Judges report(scr form.DSPSCR) matches the selected Judges report on the report parameter screen. Report each case in the appropriate column where the SCR_FORM.DSPSCR = 'TXM' and Obtain the column information from SCR COL.DSP for Column 'F' onl . OPENG Obtain all records where the SCR_CD.DSP = 'O' and the SCR_DT.DSP is greater than or equal to the reporting period BEGIN DATE and is less than or equal to the reporting period END DATE and the Judges report(scr_form.DSPSCR) matches the selected Judges report on the report parameter screen. Report each case in the appropriate column where the SCR_FORM.DSPSCR= 'TXM' and obtain the column information from SCR—COL.DSP for Column 'G' only. OPENH Obtain all records where the SCR_CD.DSP = 'O' and the SCR_DT.DSP is greater than or equal to the reporting period BEGIN DATE and is less than or equal to the reporting period END DATE and the Judges report(scr form.DSPSCR) matches the selected Judges report on the report parameter screen. Report each case in the appropriate column where the SCR_FORM.DSPSCR = 'TXM'and obtain the column information from SCR COL.DSP for Column 'H' onl . FINESWI Using the docket codes belonging to the Docket Report Group listed in the Docket Group and Column, find all dismissed docket record (DISDKT associated to the docket)where the FINESWC Dt.DISCOST is within the reporting begin and end date and the Dis_cd.DISCOST NEW matches the Value in the DISMISS—COST—CD SYSPAR (Dismiss_cd.DISCOST VIA DKT_ID.DKT) I FINESWC = Report the total number of cases in row 24. f FINESWI = Report in row 25 the sum of the amt—dismissed.DISCOST. There may be multiple DISCOST dockets associated to the case within the reporting perior. Sum the amount of fines waived for indigency Amt_Dismissed.DISCOST. Note: The row should not be hard coded. MAKE sure for row D 23 that if a docket is on the case check there must be a dismissed cost. If no dismissed cost then do not count in row 16. A case should not count when a docket exists and there are NO dismissed costs. TOTREV Sum SCR row 25 and 26= SCR row 27 MOD for section C. REVCITY Note: The cash book codes are set up on the Supreme Court Office/Cashbook Codes MOD Maintenance screen that will be used to calculate the Revenue. Navigation: Cou rtview4 System Admin4Codes4SCR forms4select the TXM (new form4select the Office/Cashbook Codes Maintenance Screen link To obtain the Total Revenue for the Reporting Period, locate the Office Code of the user running the report(OFFICE.USERS for USER_NAME.USERS)and using the cashbook codes attached to the SCROFCCB record where the SCR_CD.SCROFCCB = OFFICE-USERS for USER—NAME.USERS. For all cashbooks attached to that matching office code, get the total distributed to all accounts where the ACCT_TYPE.ACCT is not equal to'H'. Include all postsets where the BOOK_DTTM.POSTSETS is equal to or greater than the begin_dt of the report parameter beginning date and less than ore ua to the end dt of the report parameter Last saved 4/21/20119:37:00 AM CourtView®20stice Solutions Page 24 of 78 Row Extraction Process Code When extracting and using the disposition record to count cases,the Judges report(scr_form.DSPSCR)must match the selected Judges report from the report parameter screen. and where all postsets have a post_set_stat_cd.postsets = 'FINAL'. Sum all distributions to all accounts for these postsets where the ACCT_TYPE.ACCT is not equal to 'H'. and the payee_xfer_id.CHKPAY02 for the account code matches the OCA_MUNICIPA_CITY SYPAR for the office of the user where the flag is checked. The XFER_ID number is included in the OCA MUNICIPAL—CITY SYSPAR for the office of the user. (This is the new functionality) All postsets found for this range MUST be Final Posted (POST—SET STAT_CD.POSTSETS = 'FINAL') or the Total Revenue Figure cannot be included on the report and the users will receive the standard message indicating that there are Postsets in the range that are NOT final. Sum the distributed_amt.APPLDTL records where the post_set_id.APPLDTL= post—set_id.POSTSETS and the Acct_cd.APPLDTL in (select acct—cd from ACCT where acct type = D) Only the disbursement types are included. 1. Where the payee_xfer_id.CHKPAY02 matches the XREF numbers defined in the SYSPAR. • There is one syspar for Kept by City where the parameter name= OCA_MUNICIPAL—CITY SYSPAR for • The office of the user and • The flag (Val_fig.SYSPAR) is populated. 2. If there are no syspars found then this field will be null on the report. 3. If the SYSPAR is found and there are no values in the long value field (text.XSYSPAR) then this field on the report will be null. 4. If there are no records found in the DATA base then this field on the report will be null. Unlike other state reporting, Texas requires that financial information be included in the report in the form of all revenue collected by the court during the time frame. The revenue calculations must include all fines, fees, court costs, fees for copies and forfeited bonds. REVSTATE Note: The cash book codes are set up on the Supreme Court Office/Cashbook Codes MOD Maintenance screen that will be used to calculate the Revenue. Navigation: Courtview4System Admin4Codes4SCR forms4select the TXM (new form4select the Office/Cashbook Codes Maintenance Screen link To obtain the Total Revenue for the Reporting Period, locate the Office Code of the user running the report(OFFICE.USERS for USER_NAME.USERS)and using the cashbook codes attached to the SCROFCCB record where the SCR_CD.SCROFCCB = OFFICE.USERS for USER—NAME.USERS. For all cashbooks attached to that matching office code, get the total distributed to all accounts where the ACCT_TYPE.ACCT is not equal to 'H'. and the payee_xfer_id.CHKPAY02 for the account code matches the OCA_MUNICIPA_STATE SYPAR for the office of the user where the flag is checked. The XFER-ID numbers are included in the OCA—MUNICIPAL—STATE SYSPAR for the office of the user. (This is the new functionality) Last saved 4/21/2011 9:37:00 AM CourtView®26stice Solutions Page 25 of 78 Row Extraction Process Code When extracting and using the disposition record to count cases,the Judges report(scr form.DSPSCR)must match the selected Judges report from the report parameter screen. Include all postsets where the BOO K_DTTM.POSTS ETS is equal to or greater than the begin_dt of the report parameter beginning date and less than or equal to the end_dt of the report parameter and where all postsets have a post_set_stat_cd.postsets= 'FINAL'. Sum all distributions to all accounts for these postsets where the ACCT_TYPE.ACCT is not equal to 'H'. All postsets found for this range MUST be Final Posted (POST_SET_STAT_CD.POSTSETS= 'FINAL')or the Total Revenue Figure cannot be included on the report and the users will receive the standard message indicating that there are Postsets in the range that are NOT final. Sum the distributed_amt.APPLDTL records where the post_set_id.APPLDTL= post_set id.POSTSETS and the Acct cd.APPLDTL in (select acct—cd from ACCT where acct type= D)Only the disbursement types are included. 1 Where the payee xfer_id.CHKPAY02 matches the XREF numbers defined in the SYSPAR. • There is one syspar for Remitted to the State where the parameter name= OCA MUNICIPAL_STATE SYSPAR for • The office of the user and • The flag (Val_fig.SYSPAR) is populated. 2 If there are no syspars found then this field on the report will be null. 3 If the SYSPAR is found and there are no values in the long value field (test.XSYSPAR)then this field on the report will be null. 4 If there are no records found in the DATA base then this field on the report will be null. Unlike other state reporting, Texas requires that financial information be included in the report in the form of all revenue collected by the court during the time frame. The revenue calculations must include all fines, fees, court costs, fees for copies and forfeited bonds. i Last saved 4/21/20119:37:00 AM CourtView®28stice Solutions Page 26 of 78 12. Complete the Invalid Section for the Texas Municipal Court report. a. The case type that is included on a row will be determined by the invalid section set up. b. Complete the necessary setup for the Texas State Municipal Court SCR Form Invalid/Sect. using existing functionality available from CRTS9581 Invalid/Section Maintenance accessed from the Link on the SCR Form Maintenance CRTS9580. c. The check mark signifies the Columns that are invalid for the row(DATA Row). d. Navigation: System Administration 4Codes4SCR Forms4Open the desired form (i.e. TXMN) and access the INVAUSECT button. When accessed for the first time, the necessary columns and rows will be built based upon the SCR column and row setup. e. Column Definitions. SCR Description Column A Non-Parking Cases Filed B CIVIL - Parking Cases Filed C Non-Traffic Other State Law Filed D Non-Traffic City Ordinance Cases Filed E Search Warrants Issued F Mag. Warnings Given A& B Misdemeanors G Mag. Warnings Given Felonies H Mag. Orders for Emergency Protection I Misc. Activit J City Ordinance Filed K Non-Traffic Penal Code Filed Section "A" Criminal NOTE: Column B will be used in the Civil report. There are case types that should display in this field but Ft.Worth is decriminalizing all cases and will report them in the Civil section of this report. The column is being included for future use if the county decides to report these cases. COU A B C D J K ROW/LINE 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 NT 20 21 22 23 24 25 Last saved 4/21/2011 9:37:00 AM CourtView@ 20stice Solutions Page 27 of 78 COU A B C D J K 26 27 28 29 30 31 Section B Civil/Administrative Section COU B ROW/LINE 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 Section "C"Juvenile/Minor Activity Column I designates that the column on the case disposition record is ignored in counting cases. The dockets within the docket group are counted for this section. COL/ I ROW/LINE 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 Last saved 4/21/20119:37:00 AM CourtView®20stice Solutions Page 28 of 78 Section "D" Additional Activity Section Client set up required: • Row 2 has been broken out into 2 reporting rows from the old report. Felony Magistrate Warnings and the Class A and B Misdemeanors will have a different docket code for reporting but the column is still G for Felony and F for A and B Misdemeanors. • The"Requests for Counsel'docket codes will need to be created, one for the Class A and B Misdemeanors and one for the Felonies. • When column "I" is valid, then the column on the case disposition record is ignored. SCR ROW COU E F G H I ROW/LINE 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 Last saved 4/21/2011 9:37:00 AM CourtView®20stice Solutions Page 29 of 78 13. Create a Microsoft Excel®Spreadsheet for the placement of the extracted data into the report cells. Refer to Attachment A for the layout. a. Create the spreadsheets for each section defined in the SCR set up for the Texas Municipal Report TXMN: b. The header is printed on each of the 4 pages of the spreadsheets that print( Criminal, Civil, Juvenile,/Minor Activity and Additional Activity Sections) c. The spreadsheet for the row and column calculations can be found on F:\COMMON\CRTVIEW\SPECS\TEXAS\Municipal—worksheet-2.xls and is also attached to this document Appendix A For the report Header Information displayed in this area: System Parameter for the Municipal Court SysPar Field Contents Label Office Office Code of the User S sPar Group SYS System Level ALL Parameter Name COURT NAME Value Court's Name, i.e.Ft Worth Municipal] Long Value [Court Identifier— Unique Code for this reporting assigned by the state] The example in the XML uses 621510022. Each court will have their assigned identifier that will be entered in the long value field. For the report Header Information displayed in this area: Each section A,B,C and D are different. The spreadsheets will be designed to match the reports defined below. Court From s s ar (variable language based on Section A Traffic misdemeanors for columns A, B and J the section) Non-Traffic Misdemeanors for columns K, C and D. On the next row print the following In the'Month' cell, using the Begin Date from the reporting period, print the MONTH in which the Begin Date Parameter falls, i.e. if the Begin Date is 02/01/2011, then print'February'. If the user enters a reporting period of more For Month than one month, then use only the month that the Begin Date falls within. This report is intended to be submitted on a monthly basis only and will be the user's responsibility to only submit one month at a time to the State of Texas. In the'Year' cell, using the Begin Date from the reporting period, print the YEAR Year in which the Begin Date Parameter falls, i.e 02/01/2011 then print'2011'. (variable language based on the section) Hard coded to match the form. Last saved 4/21/20119:37:00 AM CourtView®30stice Solutions Page 30 of 78 The following depicts the Spreadsheet format that will be created. This format is based on the report created by the State of Texas. d. CNminal Section CRBUNAL SEMON Cox" Traffic Misdemeanors Non-Traffic Misdemeanors ChrOtter State Cin- Month Year Non-Par Parking Ordinance Penal Code Law Ordiaance L Tod Cases Peeling First of Meath: L Active Cafe V hsactive Cases 2.New Cams Filed 3.Cam Readivated 1.:U Other Cams Added S.Tod Cama on Docket (Sam 4aiw 141.3 J A) 0 0 0 0 0 0 6.Dispositions Prior to Coat Appearsace or Trial: L UaeoaabtdDapoubms (DiWarai withPaf aMedn we bybem a jadg*(CCPAn- b.Da®med by Ptosecaban 7.Dispositians at Trial: L Convictions: 1)fksCy Plm orNab Conkubm d)By do Coot 3)ByA,NJWY b.Acquods: 1)Bydt Covet 2)ByImAny e Donaned by Pto®ecoa L Compliance Dismissals: L A W Driver Safety CORM(CCP."t 410511) b.Age Deferred Duporiban(CCT.—41011) c.AAB Tem Cow RrT.AN 45.012) 00 1 d.Age Tabs=Awareness Cmw MW.Sac.141.213) e Aber Tteatmmt far Chrmical Dependency=P m et.af3) f AbePmolofFnwxW RerpomtkilitytlC sac eo1.193) All Other Thsapotdum Code Dismissals 9.A0 Other Dispwidoas 10.Tod Cama Disposed (AW duan 4 7.a&.4) 0 11.Cases!laced as lwelte Stam 12.Total Cam Pending Fad of Month: a.Active Casa 0 0 0 0 0 0 b_hmctiveCalif(rua.um5aaler3r6xur11) 0 0 0 0 0 0 13.Show Can"&a inp Reld It Cases Appealed: L Age Trial b.Without Trial RF2 Last saved 4/21/20119:37:00 AM CourtView®30stice Solutions Page 31 of 78 e. Civil section UVIL/AD1IIMSTRATIVE SECTION Court Mouth Year TOTAL CASES L Total Cases Peadfas Fust of Mm&: a Active Cases b_lmdiw Cases 2.New Cases filed 3.Cases Reacti nod 4.All Otter Cases Added 5.Total Cases on Dm*0 (Sm of ma 14 2.3&4) 0 DLSPOS'IIONS 6.Uncontested Ckil Fines or Penalties 7.Ddm k Jndpats &Apeed Jodpeats !.Trialom bq by Jadp ffleariaa Officer it Trial by Jury 1L Dismissed hr Want of Prosecution It All Otter Dhpoddm 13.Total Cases Disposed (3km afL*w 6 a rwA 1?) 0 14.Cases placed on laa &e Stam 15 Total Cases Pendtap Ead of Moat&: i Active Cases (Efris law s nods tW nm of tem 13&14) 0 b.lnactm Cases (EVelr Lw 1b nano lbw 3 phs law 14) 0 16,Cases Appealed: z Ater Taal b.Witbnat Tool Pace 3 Last saved 4/21/20119:37:00 AM CourtView®39stice Solutions Page 32 of 78 f. Juvenile/Minor JUVENILEAHNOR ACTIVITY Court Mouth Year TOTAL 1.Transportation Code Cases Filed 2.Nos-Driving Alcoholic Iles erage Code Caws Filed 3.Driving Under the Influence of Alcohol Cases Filed 6.Drug Paraphernalia Caws Filed(HSC,CIL 481) S.Tobacco Cases Filed(HSC,Sr.161.252) 6.Failure to Attend School Cases Filed(MCodti Sec.25.094) 7.Education Code(Except Failure to Attend)Cases Fled L Violation of Local Daytime Curfew Ordinance Cases Filed (Local Govt Calk Sc.341.9030 9.Ali Other Non-TratBc Fine-Only Caws Filed 10.Transfer to Juvenile Court: i WWWWoty Transfer(Fam_Codr,Sac.51.08(b)(1)) b.Disaetion uy Transfer(Fox cads,Sr.51.08(b)(1)) 11.Accused of Contempt and Referred to Juvenile Court(Delinquent Conduct) (CCP,Art 45.650(c)(1)) 12.Held is Contempt by Criminal Court(Fined and/or Denied Driving Privileges) WQ,Art 45.6 6wN2)) 13.Juvenile Statement Magistrate R'arming: a.warnings Administered b.Statements Certified enwcoda,Sr.51.0951 14.Detention Hearings Held(Fam.Coda Sr.54.01) 15.Orders for Non-Secure Custody Issued 16.Parent Contributing to Nonattendance Caws Filed(Fd Cak Sr.23-931 Page 4 Last saved 412112011 9:37:00 AM CourtView®Ustice Solutions Page 33 of 78 Additional Activit ADDITIONAL ACTIVITY Curt NUmKR REQm-m Month Tear NITNWR GB EN FOR CO SII. I.Naostrate waniar a.Class C Misdemeanors b.Class A and B Misilmw mors c-Felmics TOTAL L Arrest Warrants Issued: a.Class C Misdemeanors b.Class A and B Misdemeanors c.Felonies S.Cappses Pro Fire issued i.Search Watranes Issued S.Warrants far Fire,Heakb and Code Iupecdoas Filed(C7 AN MASA G.Ezamih>t Trials Coadrted 7.Emergency Mental Health Hearings Heid R h(at6hate's Orders for Faergenry Protection Issued f.Maostrate's Orders for Ipitlon Interlock Device Issued rc'P.f.e.n.Mu 10.AN Other Magistrate's Orden Issued Requiring Conditions far Release M Band 11.Drire's License DmK Rnwadw or Suspensbn Bmdm s Held 47c;Sm 521.30 12.DisposhMn of Stolen property Hearlgs Meld KCP.M eA 13.peace Bond Hearlop Held I.I.Cases in Which Fine and Court Cosh Satisfied by Coaaauuity Service: a.Partial Satisfaction b.Full Satisfaction 15.Cases fa WNcb Fhse and Coot Costs Satisfied by Jas®Credit 10.Cases in Wbkh Fine and Coat Cosh Waited for Ldigency 17.Amount of Fhses and Coot Coin Waited for iniitency so 1R Fines,Cort Can ad Odwr Amorists Collected: a-Mao by City so b.Refitted to State so c.Total so tis Last saved 4/21/2011 9:37:00 AM CourtView®Ustice Solutions Page 34 of 78 <LINE>1a</LINE> Transmission Line rs_trans_Iline.ROW_SECT new field <LINENUMBER>1002</LINENUMBER> Trans Code.ROW_SECT from the row being processed from the TXMN table. <Traffic_NonParking>1</Traffic_NonParking> The tag = the Column Section set up based on the scr section and column that is being processed and the column. SCR Section, Column and Time GDLN will be used to designate the order that the descriptions will be added to the XML file. The numeric value is the count. Is this example there was only 1 case that is reporting. <Traffic_Parking>1</Traffic_Parking> <Traffic_City0rdinance>1</Traffic_CityOrdinance> <NonTraffic_PenaICode>2</NonTraffic_PenaICode> <NonTraffic_OtherStateLaw>2</NonTraffic_OtherStateLaw> <NonTraffic_CityOrdinance>2</NonTraffic_CityOrdinance> </CATEGORY> Specifies that this is the end of the category - <CATEGORY desc="Cases Pending First of Month-Inactive Cases"> <LINE>1b</LINE> Transmission Line rs_trans_Iline.ROW_SECT new field <LINENUMBER>1003</LINENUMBER> Trans Code.ROW_SECT from the row being processed from the TXMN table. <Traffic_NonParking>1</Traffic_NonParking> The tag = the Column Section set up. cs_col.COL_SECT. The column will be added to the XML field in the order that they are entered in the cs_col_xref.COL_SECT The numeric value is the number of cases. Etc. d. The following is the complete XML file layout with examples provided by the STATE. Last saved 412112011 9:37:00 AM CourtView®30stice Solutions Page 39 of 78 The XML file for the Municipal court report is detailed below. (Note: This is not a correction file so the correction tags will be blanks). Sample contents are included within the XML tag, and explanatory information is shown outside each set of brackets <>as applicable. The sample contents of the fields in this document do not create an in-balance report when loaded. The numbers in this example are merely examples. File Description: The file is broken down into Record Header, Number of Reported Lines and Line Details. Record Header information relates to the header of the data reported to uniquely identify the submitted file and will be committed to Records Header Table in the database. NumofLinesReported will identify total lines reported on this xml file. LineDetails identifies the actual data conveyed through this file transfer. The descriptive information relates the line details and data elements to the actual report completed either on paper or on line. Note: The xsi:nil="true" attribute is listed on a few optional fields. Only use that attribute when the field is left blank. If the field will contain a value, then do not include the xsi:nil="true"> attribute. <?xmi version="1.0" encoding="ISO-8859-1" ?> - <ROOT xmins="urn:oca-MUNICIPAL-schema" xmlns:xsi="http:/twww.w3.org/2001/XMLSchemainstance"> - <RECORDHEADER> <COURTIDENTIFIER>621510022</COURTIDENTIFIER> Court ID Number—unique identifier <REPORTINGMONTH>11</REPORTINGMONTH> Calendar month applicable for the report <REPORTINGYEAR>2003</REPORTINGYEAR> Calendar year applicable to the report <PREPAREDBY>frankp</PREPAREDBY> Identifier for person preparing the report <PREPAREDDATE>2004-04-01</PREPAREDDATE> Date prepared, expressed as YYYYMMDD <CORRECTEDFLAG>N</CORRECTEDFLAG> Denotes whether this is a corrected (Y) report or a new(N) report This one is flagged as new. If it were a correction,the following two data items would contain data. <CORRECTEDDATE xsi:nil="true" /> Format for the correction date is YYYY-MM-DD if used. <CORRECTEDBY xsi:nil="true" /> Identifier for person correcting the report. </RECORDHEADER> - <SECTIONS> - <CRIMINAL> This is the beginning of the criminal section data <NUMOFLINESREPORTED>31</NUMOFLINESREPORTED> - <CATEGORY desc="Cases Pending First of Month"> <LINE>1</LINE> <LINENUMBER>1001</LINENUMBER> <Traffic_NonParking>1</Traffic_NonParking> <Traffic_Parking>1</Traffic Parking> <Traffic–CityOrdinance>1</Traffic_CityOrdinance> <NonTraffic_PenalCode>2</NonTraffic_PenalCode> <NonTraffic_OtherStateLaw>2</NonTraffic_OtherStateLaw> <NonTraffic_CityOrdinance>2</NonTraffic_CityOrd Ina nce> </CATEGORY> - <CATEGORY desc="Cases Pending First of Month -Active Cases"> <LINE>1a</LINE> <LINENUMBER>1002</LINENUMBER> <Traffic_NonParking>1</Traffic_NonParking> <Traffic_Parking>1</Traffic_Parking> Last saved 4/21/20119:37:00 AM CourtView®40stice Solutions Page 40 of 78 <Traffic_CityOrdinance>1</Trafflc_CityOrdinance> <NonTraffic_PenalCode>2</NonTraffic_PenalCode> <NonTraffic_OtherStateLaw>2</NonTraffic_OtherStateLaw> <NonTraffic_City0rdinance>2</NonTraffic_City0rdinance> </CATEGORY> - <CATEGORY desc="Cases Pending First of Month -Inactive Cases"> <LINE>1b</LINE> <LINENUMBER>1003</LINENUMBER> <Traffic_NonParking>1</Traffic_NonParking> <Traffic_Pa rking>1</Trafflc_Pa rki ng> <Trafflc_CityOrdinance>1</Traffic_CityOrdinance> <NonTraffic_PenalCode>2</NonTraffic_PenalCode> <NonTraffic_OtherStateLaw>2</NonTraffic_OtherStateLaw> <NonTraffic_City0rdinance>2</NonTrafflc_City0rdinance> </CATEGORY> - <CATEGORY desc="New Cases Filed"> <LINE>2</LINE> <LINENUMBER>1004</LINENUMBER> <Traffic_NonParking>1</Traffic_NonParking> <Traffic_Parking>1</Trafflc_Parking> <Traffic_CityOrdinance>1</Trafflc_CityOrdinance> <NonTraffic_PenalCode>2</NonTraffic_PenalCode> <NonTraffic_OtherStateLaw>2</NonTraffic_OtherStateLaw> <NonTraffic_CityOrdinance>2</NonTraffic_CityOrdinance> </CATEGORY> - <CATEGORY desc="Cases Reactivated"> <LINE>3</LINE> <LINENUMBER>1005</LINENUMBER> <Traffic_NonParking>1</Traffic_NonParking> <Traffic_Parking>1</Traffic_Parking> <Traffic_CityOrdinance>1</Traffic_CityOrdinance> <NonTraffic_PenalCode>2</NonTraffic_PenaiCode> <NonTraffic_OtherStateLaw>2</NonTraffic_OtherStateLaw> <NonTraffic_CityOrdinance>2</NonTraffic_CityOrdinance> </CATEGORY> - <CATEGORY desc="AII Other Cases Added"> <LINE>4</LINE> <LIN ENUMBER>1006</LINENUMBER> <Traffic_Non Pa rki ng>1</Traffic_Non Park!ng> <Traffic_Parking>1</Traffic_Parking> <Traffic_CityOrdInance>1</Traffic_CityOrdinance> <NonTraffic PenalCode>2</NonTraffic_PenalCode> <NonTraffic_OtherStateLaw>2</NonTraffic_OtherStateLaw> <NonTraffic_CityOrdinance>2</NonTraffic_City0rdinance> </CATEGORY> - <CATEGORY desc="Total Cases On Docket"> - <!--(Sum of Lines la, 2, 2 & 4)--> <LINE>5</LINE> <LINENUMBER>1007</LINENUMBER> <Traffic_NonParking>1</Traffic_NonParking> <Traffic_Parking>1</Traffic_Parking> <Traffic_CityOrdinance>1</Traffic_CityOrdinance> <NonTraffic_PenalCode>2</NonTraffic_PenalCode> <NonTraffic_OtherStateLaw>2</NonTrafflc_OtherStateLaw> <NonTrafflc_CityOrdinance>2</NonTraffic_City0rdina nce> </CATEGORY> Last saved 4/21/20119:37:00 AM CourtView®40stice Solutions Page 41 of 78 - <CATEGORY desc="Uncontested Dispositions Prior to Court"> <LINE>6a</LINE> <LINENUMBER>1008</LINENUMBER> <Traffic_NonParking>1</Traffic_NonParking> <Traffic_13arking>1<[Traffic_Parking> <Traffic_CityOrdinance>1<[Traffic_CityOrdinance> <NonTraffic_PenalCode>2</NonTraffic_PenalCode> <NonTraffic_OtherStateLaw>2</NonTraffic_OtherStateLaw> <NonTraffic_CityOrdinance>2</NonTraffic_CityOrdinance> </CATEGORY> - <CATEGORY desc="Cases Dismissed by Prosecution Prior to Court"> <LINE>6b</LINE> <LINENUMBER>1009</LINENUMBER> <Traffic_NonParking>1</Traffic_NonParking> <Traffic_Parking>1<[Traffic_Parking> <Traffic_CityOrdinance>1<[Traffic_CityOrdinance> <NonTraffic_PenaICod e>2</NonTraffic_PenaICod e> <NonTraffic_OtherStateLaw>2</NonTraffic_Othe rState Law> <NonTraffic_CityOrdinance>2</NonTraffic_CityOrdinance> </CATEGORY> - <CATEGORY desc="Guilty Plea or Nolo Contendere at Trial"> <LINE>7al</LINE> <LINENUMBER>1010</LINENUMBER> <Traffic_NonParking>1</Traffic_NonParking> <Traffic_Parking>1</Traffic_Parking> <Traffic_CityOrdinance>1</Traffic_CityOrdinance> <NonTraffic_PenalCode>2</NonTraffic_PenalCode> <NonTrafi'tc_OtherStateLaw>2</NonTrafflc_OtherStateLaw> <NonTraffic_CityOrdinance>2</NonTraffic_CityOrdinance> </CATEGORY> - <CATEGORY desc="Convictions -By the Court"> <LINE>7a2</LINE> <LINENUMBER>1011</LINENUMBER> <Traffic_NonParking>1</Traffic_NonParking> <Traffic_Parki ng>1<[Traffic_Parki ng> <Traffic_CityOrdinance>1</Traffic_CityOrdinance> <NonTrafflc_PenalCode>2</NonTraffic_PenaICode> <NonTraffic_OtherStateLaw>2</NonTraffic_OtherStatel-aw> <NonTraffic_City0rdinance>2</NonTraffic_CityOrdinance> </CATEGORY> - <CATEGORY desc="Convictions -By the Jury"> <LINE>7a3</LINE> <LINENUMBER>1012</LINENUMBER> <Traffic_NonParking>1</Traffic_NonParking> <Traffic_Parki ng>1</Traffic_Parking> <Traffic_CityOrdinance>1</Traffic_CityOrdinance> <NonTrafric_PenalCode>2</NonTraffic_PenalCode> <NonTraffic_OtherStateLaw>2</NonTraffic_OtherStateLaw> <NonTraffic_CityOrdinance>2</NonTraffic_CityOrd i nance> </CATEGORY> - <CATEGORY desc="Acquittals-By the Court"> <LINE>7b1</LINE> <LIN ENUMBER>1013</LINENUMBER> <Traffic_Non Parking>1</Traffic_NonParking> <Traffic_Parking>1</Traffic_Parking> <Traffic_CityOrd i nance>1</Traffic_CityOrdi nance> Last saved 4/21/2011 9:37:00 AM CourtView®40stice Solutions Page 42 of 78 <NonTraffic_PenalCode>2</NonTraffic_PenalCode> <NonTraffic_OtherStateLaw>2</NonTraffic_OtherStateLaw> <NonTraffic_CityOrdinance>2</NonTraffic_CityOrdinance> </CATEGORY> - <CATEGORY desc="Acquittals -By the Jury"> <LINE>7b2</LINE> <LINENUMBER>1014</LINENUMBER> <Traffic_NonParking>1</Traffic_NonParking> <Traffic_Parking>1</Traffic_Parking> <Traffic_CityOrdinance>1</Traffic_CityOrdinance> •NonTraffic_PenalCode>2</NonTraffic_PenaICode> •NonTraffic_OtherStateLaw>2</NonTraffic_OtherStateLaw> •NonTraffic_City0rdinance>2</NonTraffic_City0rdinance> </CATEGORY> - <CATEGORY desc="Cases Dismissed by Prosecution at Trial"> <LINE>7c</LINE> <LINENUMBER>1015</LINENUMBER> <Traffic_NonParking>1</Traffic_NonParking> <Traffic_Parking>1</Traffic_Parking> <Traffic_CityOrdinance>1</Traffic_CityOrdinance> •NonTraffic_PenalCode>2</NonTraffic_PenalCode> •NonTraffic_OtherStateLaw>2</NonTraffic_OtherStateLaw> <NonTraffic_CityOrdinance>2</NonTraffic_CityOrdinance> </CATEGORY> - <CATEGORY desc="Compliance Dismissals: After Driver Safety Course"> <LINE>8a</LINE> <LINENUMBER>1016</LINENUMBER> <Traffic_NonParking>1</Traffic_NonParking> </CATEGORY> - <CATEGORY desc="Compliance Dismissals: After Deferred Disposition"> <LINE>8b</LINE> <LINENUMBER>1017</LINENUMBER> <Traffic_NonParking>1</Traffic_NonParking> <Traffic_Parking>1</Traffic_Parking> <Traffic_CityOrdinance>1</Traffic_CityOrdinance> •NonTraffic_PenalCode>2</NonTraffic_PenaICode> •NonTraffic_OtherStateLaw>2</NonTraffic_OtherStateLaw> <NonTraffic_CityOrdinance>2</NonTraffic_CityOrdinance> </CATEGORY> - <CATEGORY desc="Compliance Dismissals: After Teen Court"> <LINE>8c</LINE> <LINENUMBER>1018</LINENUMBER> <Traffic_NonParking>1</Traffic_NonParking> <Traffic_Parking>1</Traffic_Parking> <Traffic_CityO rd i nance>1</Traffic_CityOrd i nance> <NonTraffic_PenalCode>2</NonTraffic_PenalCode> <NonTraffic_OtherStateLaw>2</NonTraffic_OtherStateLaw> <NonTraffic—CityOrdinance>2</NonTraffic_CityOrdinance> </CATEGORY> - <CATEGORY desc="Compliance Dismissals: After Tobacco Awareness Course"> <LINE>8d</LINE> •LINENUMBER>1019</LINENUMBER> <NonTraffic_OtherStateLaw>2</No nTraffic_OtherStateLaw> </CATEGORY> - <CATEGORY desc="Compliance Dismissals: After Treatment for Chemical Dependency"> <LINE>8e</LINE> Last saved 4/21/20119:37:00 AM CourtView®40stice Solutions Page 43 of 78 <LINENUMBER>1020</LINENUMBER> <NonTraffic_PenalCode>2</NonTraffic_PenalCode> <NonTraffic_OtherStatel-aw>2</NonTraffic_OtherStateLaw> </CATEGORY> - <CATEGORY desc="Compliance Dismissals: After Proof of Financial Responsibility"> <LINE>8f</LINE> <LINENUMBER>1021</LINENUMBER> <Traffic_NonParking>1</Traffic_NonParking> </CATEGORY> - <CATEGORY desc="Compliance Dismissals: All Other Transportation Code Dismissals"> <LINE>8g</LINE> <LINENUMBER>1022</LINENUMBER> <Traffic_NonParking>1</Traffic_NonParking> <Traffic_Parking>1</Traffic_Parking> <Traffic_CityOrdinance>1</Traffic_CityOrdinance> <NonTraffic_PenalCode>2</NonTraffic_PenaICode> <NonTraffic_OtherStateLaw>2</NonTraffic_OtherStateLaw> <NonTraffic_CityOrdinance>2</NonTrafric_CityOrdinance> </CATEGORY> - <CATEGORY desc="All Other Dispositions"> <LINE>9</LINE> <LINENUMBER>1031</LINENUMBER> <Traffi4z_NonPark!ng>1</Traffic_NonParking> <Traffic_Parking>1</Traff!c_Parking> <Traffic_CityOrdinance>1</Tralf;c_CityOrdinance> <NonTraffic_PenalCode>2</NonTraffic_PenaICode> <NonTraffic_OtherStateLaw>2</NonTraffic_OtherStatef.aw> <NonTraffic_CityOrdinance>2</NonTraffic_CityOrdinance> </CATEGORY> - <CATEGORY desc="Total Cases Disposed"><!-- (sum of Lines 6, 7, 8 & 9) --> <LINE>10</LINE> <LINENUMBER>1023</LINENUMBER> <TraNic_NonParking>1</Traffic_NonParking> <Trafflc_Parking>1</Traffic_Parking> <Traffic_CityOrdinance>1</Traffic_CityOrdinance> •NonTraffic_PenalCode>2</N onTraffic_PenalCode> <NonTraffiic_OtherStateLaw>2</NonTraffic_OtherState!.aw> <NonTraffic_CityOrdinance>2</NonTrafric_CityOrdinance> </CATEGORY> - <CATEGORY desc="Cases Placed on Inactive Status"> <LINE>11</LINE> <LINENUMBER>1024</LINENUMBER> <Traffic_NonParking>1</Traffic_NonParking> <Traffic_Parking>1</Traffic_Parking> <Traffic_CityOrdinance>1</Traffic_CityOrdinance> <NonTrafric.PenalCode>2</NonTraffic_PenalCode> <NonTraffic_OtherStateLaw>2</NonTraffic_OtherStateLaw> <NonTraffic_CityOrdinance>2</NonTraffic_CityOrdinance> </CATEGORY> - <CATEGORY desc="Cases Pending End of Month"> <LINE>12</LINE> <LINENUMBER>1025</LINENUMBER> <Traffic_NonPa rking>1</Traffic_NonParking> <Traffic_Parki ng>1</Traffic_Parking> <Traffic_CltyOrdinance>1</Traffic_CityOrdinance> <N o nTrafri c_Pe na I Code>2</N o nTra ffic_Pe na I Code> Last saved 4/21/20119:37:00 AM CourtView®dbstice Solutions Page 44 of 78 <NonTraffic_OtherStateLaw>2</NonTraffic_OtherStateLaw> <NonTraffic_CityOrdinance>2</NonTraffic_CityOrdinance> </CATEGORY> - <CATEGORY desc="Cases Pending End of Month -Active Cases"> - <!-- (Equals Line 5 minus the sum c s 10 & 11" --> <LINE>12a</LINE> <LINENUMBER>1026</LINENUMBER> <Traffic_NonParking>1</Traffic_NonParking> <Traffic_Pa rki ng>1</Traffic_Pa rki ng> <Traffic_CityOrdinance>1</Traffic_CityOrdinance> <NonTraffic_PenalCode>2</NonTraffic_PenalCode> <NonTraffic_OtherStateLaw>2</NonTraffic_OtherStateLaw> <NonTraffic_City0rdinance>2</NonTraffic_City0rdinance> </CATEGORY> - <CATEGORY desc="Cases Pending End of Month Inactive Cases"> - <!-- (Equals Line lb minus Line 3 plus Line 11) --> <LINE>12b</LINE> <LINENUMBER>1027</LINENUMBER> <Traffic_NonParking>1</Traffic_NonParking> <Traffic_Parking>1</Traffic_Pa rki ng> <Traffic_CityOrdinance>1</Traffic_CityOrdinance> •NonTraffic_PenalCode>2</NonTraffic_PenalCode> <NonTraffic_OtherStateLaw>2</NonTraffic_OtherStateLaw> <NonTraffic_City0rdinance>2</NonTraffic_City0rdinance> </CATEGORY> - <CATEGORY desc="Show Cause Hearings Held"> <LINE>13</LINE> <LINENUMBER>1028</LINENUMBER> <Traffic_NonParking>1</Traffic_NonParking> <Traffic_Pa rki ng>1</Traffic_Pa rki ng> <Traffic_CityOrdinance>1</Traffic_CityOrdinance> <NonTraffic_PenalCode>2</NonTraffic_PenalCode> <NonTraffic_OtherStateLaw>2</NonTraffic_OtherStateLaw> <NonTraffic_City0rdinance>2</NonTraffic_City0rdinance> </CATEGORY> - <CATEGORY desc="Cases Appealed: After Trial"> <LINE>14a</LINE> <LINENUMBER>1029</LINENUMBER> <Traffic_NonParking>1</Traffic_NonParking> <Traffic_Parking>1</Traffic_Parking> <Traffic_CityOrdinance>1</Traffic_CityOrdinance> <NonTraffic_PenalCode>2</NonTraffic_PenaiCode> <NonTraffic_OtherStateLaw>2</NonTraffic_OtherStateLaw> <NonTraffic_CityOrdinance>2</NonTraffic_CityOrdinance> </CATEGORY> - <CATEGORY desc="Cases Appealed: Without Trial"> <LINE>14b</LINE> <LINENUMBER>1030</LINENUMBER> <Traffic_NonParking>1</Traffic_NonParking> <Traffic_Pa rki ng>1</Traffic_Pa rking> <Traffic_CityOrdinance>1</Traffic_CityOrdinance> <NonTraffic_PenalCode>2</NonTraffic_PenalCode> <NonTraffic_OtherStateLaw>2</NonTraffic_OtherStateLaw> <NonTraffic_City0rdinance>2</NonTraffic_City0rdinance> </CATEGORY> </CRIMINAL> Criminal section ends here. Last saved 4121120119:37:00 AM CourtView®ddstice Solutions Page 45 of 78 - <CIVIL> This is the beginning of the civil/administrative section data <NUMOFLINESREPORTED>21</NUMOFLINESREPORTED> - <CATEGORY desc="Cases Pending First of Month"> <LINE>1</LINE> <LINENUMBER>1200</LINENUMBER> <Total>3</Total> </CATEGORY> - <CATEGORY desc="Cases Pending First of Month-Active Cases"> <LINE>1a</LINE> <LINENUMBER>1201</LINENUMBER> <Total>3</Total> </CATEGORY> - <CATEGORY desc="Cases Pending First of Month -Inactive Cases"> <LINE>1b</LINE> <LINENUMBER>1202</LINENUMBER> <Total>3</Total> </CATEGORY> - <CATEGORY desc="New Cases Filed"> <LINE>2</LINE> <LINENUMBER>1203</LINENUMBER> <Total>3</Total> </CATEGORY> - <CATEGORY desc="Cases Reactivated"> <LINE>3</LINE> <LINENUMBER>1204</LINENUMBER> <Total>3</Total> </CATEGORY> - <CATEGORY desc="All Other Cases Added"> <LINE>4</LINE> <LINENUMBER>1205</LINENUMBER> <Total>3</Total> </CATEGORY> - <CATEGORY desc="Total Cases On Docket"><!-- (sum of Lines la, 2, 3 & 4) --> <LINE>5</LINE> <LINENUMBER>1206</LINENUMBER> <Total>3</Total> </CATEGORY> - <CATEGORY desc="Uncontested Civil Fines or Penalties"> <LINE>6</LINE> <LINENUMBER>1207</LINENUMBER> <Total>3</Total> </CATEGORY> - <CATEGORY desc="Default Judgments"> <LINE>7</LINE> <LINENUMBER>1208</LINENUMBER> <Total>3</Total> </CATEGORY> - <CATEGORY desc="Agreed Judgments"> <LINE>8</LINE> <LINENUMBER>1209</LINENUMBER> <Total>3</Total> </CATEGORY> - <CATEGORY desc="Trial/Hearing by Judge/Hearing Officer"> <LINE>9</LINE> <LINENUMBER>1210</LINENUMBER> <Total>3</Total> Last saved 4121120119:37:00 AM CourtView®46stice Solutions Page 46 of 78 </CATEGORY> - <CATEGORY desc="Trial by Jury"> <LINE>10</LINE> <LINENUMBER>1211</LINENUMBER> <Total>3<[Total> </CATEGORY> - <CATEGORY desc="Cases Dismissed for Want of Prosecution"> <LINE>11</LINE> <LINENUMBER>1212</LINENUMBER> <Total>3</Total> </CATEGORY> - <CATEGORY desc="All Other Dispositions"> <LINE>12</LINE> <LINENUMBER>1220</LINENUMBER> <Total>3</Total> </CATEGORY> - <CATEGORY desc="Total Cases Disposed"><! i,-_, u o --> <LINE>13</LINE> <LINENUMBER>1213</LINENUMBER> <Total>3</Total> </CATEGORY> - <CATEGORY desc="Cases Placed on Inactive Status"> <LINE>14</LINE> <LINENUMBER>1214</LINENUMBER> <Total>3</Total> </CATEGORY> - <CATEGORY desc="Cases Pending End of Month"> <LINE>15</LINE> <LINENUMBER>1215</LINENUMBER> <Total>3</Total> </CATEGORY> - <CATEGORY desc="Cases Pending End of Month -Active Cases"> - <!-- (Equals Lines 5 - (1 i; + 14) ) --> <LINE>15a</LINE> <LINENUMBER>1216</LINENUMBER> <Total>3</Total> </CATEGORY> - <CATEGORY desc="Cases Pending End of Month -Inactive Cases"> - <!-- (Equals Lines lb - 3 plus 14) --> <LINE>15b</LINE> <LINENUMBER>1217</LINENUMBER> <Total>3</Total> </CATEGORY> - <CATEGORY desc="Cases Appealed: After Trial"> <LINE>16a</LINE> <LINENUMBER>1218</LINENUMBER> <Total>3</Total> </CATEGORY> - <CATEGORY desc="Cases Appealed: Without Trial"> <LINE>16b</LINE> <LINENUMBER>1219</LINENUMBER> <Tota l>3</Tota I> </CATEGORY> </CIVIL> Civil/administrative section ends here. - <JUVENILE> This is the beginning of the juvenile section data Last saved 4/21/20119:37:00 AM CourtView®49stice Solutions Page 47 of 78 <NUMOFLINESREPORTED>18</NUMOFLINESREPORTED> - <CATEGORY desc="Transportation Code Cases Filed"> <LINE>1</LINE> <LINENUMBER>1101</LINENUMBER> <Total>43</Total> </CATEGORY> - <CATEGORY desc="Non-Driving Alcoholic Beverage Code Cases Filed"> <LINE>2</LINE> <LINENUMBER>1102</LINENUMBER> <Total>44</Total> </CATEGORY> - <CATEGORY desc="Driving Under the Influence of Alcohol Cases Filed"> <LINE>3</LINE> <LINENUMBER>1103</LINENUMBER> <Total>45</Total> </CATEGORY> - <CATEGORY desc="Drug Paraphernalia Cases Filed"> <LINE>4</LINE> <LINENUMBER>1104</LINENUMBER> <Total>46</Total> </CATEGORY> - <CATEGORY desc="Tobacco Cases Filed"> <LINE>5</LINE> <LINENUMBER>1105</LINENUMBER> <Total>47</Total> </CATEGORY> - <CATEGORY desc="Failure to Attend School Cases Filed"> <LINE>6</LINE> <LINENUMBER>1106</LINENUMBER> <Total>48</Total> </CATEGORY> - <CATEGORY desc="Education Code (Except Failure to Attend)Cases Filed"> <LINE>7</LINE> <LINENUMBER>1107</LINENUMBER> <Total>49</Total> </CATEGORY> - <CATEGORY desc="Violation of Local Daytime Curfew Ordinance Cases Filed"> <LINE>8</LINE> <LINENUMBER>1108</LINENUMBER> <Total>62</Total> </CATEGORY> - <CATEGORY desc="All Other Non-Traffic Fine-Only Cases Filed"> <LINE>9</LINE> <LINENUMBER>1109</LINENUMBER> <Total>62</Total> </CATEGORY> - <CATEGORY desc="Mandatory Transfer to Juvenile Court"> <LINE>10a</LINE> <LINENUMBER>1110</LINENUMBER> <Total>62</Total> </CATEGORY> - <CATEGORY desc="Discretionary Transfer to Juvenile Court"> <LINE>10b</LINE> <LINENUMBER>1111</LINENUMBER> <Total>62</Total> </CATEGORY> Last saved 4/21/2011 9:37:00 AM CourtView®48stice Solutions Page 48 of 78 - <CATEGORY desc="Accused of Contempt and Referred to Juvenile Court(Delinquent Conduct)"> <LINE>11</LINE> <LINENUMBER>I I12</LINENUMBER> <Total>62</Total> </CATEGORY> - <CATEGORY desc="Held in Contempt by Criminal Court(Fined and/or Denied Driving Privileges)"> <LINE>12</LINE> <LINENUMBER>1113</LINENUMBER> <Total>62</Total> </CATEGORY> - <CATEGORY desc="Juvenile Statement Magistrate Warnings Administered"> <LINE>13a</LINE> <LINENUMBER>1114</LINENUMBER> <Total>62</Total> </CATEGORY> - <CATEGORY desc="Juvenile Statements Certified by Judge"> <LINE>13b</LINE> <LINENUMBER>1115</LINENUMBER> <Total>62</Total> </CATEGORY> - <CATEGORY desc="Detention Hearings Held"> <LINE>14</LINE> <LINENUMBER>1116</LINENUMBER> <Total>62</Total> </CATEGORY> - <CATEGORY desc="Orders for Non-Secure Custody Issued"> <LINE>15</LINE> <LINENUMBER>1117</LINENUMBER> <Total>62</Total> </CATEGORY> - <CATEGORY desc="Parent Contributing to Nonattendance Cases Filed"> <LINE>16</LINE> <LINENUMBER>1118</LINENUMBER> <Total>50</Total> </CATEGORY> </JUVENILE> Juvenile section ends here. - <OTHER_ACTIVITIES> This is the beginning of the other section data <NUMOFLINESREPORTED>25</NUMOFLINESREPORTED> - <CATEGORY desc="Magistrate Warnings: Class C Misdemeanors"> <LINE>1a</LINE> <LINENUMBER>1301</LINENUMBER> <Number_Given>52</Number—Given> </CATEGORY> - <CATEGORY desc="Magistrate Warnings: Class A and B Misdemeanors"> <LINE>1 b</LINE> <LINENUMBER>1302</LINENUMBER> <Number Given>52</Number Given> </CATEGORY> - <CATEGORY desc="Magistrate Warnings: Felonies"> <LINE>1c</LINE> <LINENUMBER>1303</LINENUMBER> <Number_Given>52</Number Given> <Requests_For Counsel>53</Requests_For Counsel> </CATEGORY> Last saved 4/21/20119:37:00 AM CourtView®40stice Solutions Page 49 of 78 - <CATEGORY desc="Arrest Warrants Issued: Class C Misdemeanors"> <LINE>2a</LINE> <LINENUMBER>1304</LINENUMBER> <Total>56</Total> </CATEGORY> - <CATEGORY desc="Arrest Warrants Issued: Class A and B Misdemeanors"s, <LINE>2b</LINE> <LINENUMBER>1305</LINENUMBER> <Total>57</Total> </CATEGORY> - <CATEGORY desc="Arrest Warrants Issued: Felonies"> <LINE>2c</LINE> <LINENUMBER>1306</LINENUMBER> <Total>51</Total> </CATEGORY> - <CATEGORY desc="Capiases Pro Fine Issued"> <LINE>3</LINE> <LINENUMBER>1307</LINENUMBER> <Total>52</Total> </CATEGORY> - <CATEGORY desc="Search Warrants Issued"> <LINE>4</LINE> <LINENUMBER>1308</LINENUMBER> <Total>53</Total> </CATEGORY> - <CATEGORY desc="Warrants for Fire, Health and Code Inspections Filed"> <LINE>5</LINE> <LINENUMBER>1309</LINENUMBER> <Total>54</Total> </CATEGORY> - <CATEGORY desc="Examining Trials Conducted"> <LINE>6</LINE> <LINENUMBER>1310</LINENUMBER> <Total>55</Total> </CATEGORY> - <CATEGORY desc="Emergency Mental Health Hearings Held"> <LINE>7</LINE> <LINENUMBER>1311</LINENUMBER> <Total>56</Total> </CATEGORY> - <CATEGORY desc="Magistrate's Orders for Emergency Protection Issued"> <LINE>8</LINE> <LINENUMBER>1312</LINENUMBER> <Total>57</Total> </CATEGORY> - <CATEGORY desc="Magistrate's Orders for Ignition Interlock Device Issued"> <LINE>9</LINE> <LINENUMBER>1313</LINENUMBER> <Total>58</Total> </CATEGORY> - <CATEGORY desc="All Other Magistrate's Orders Issued Requiring Conditions for Release on Bond"> <LINE>10</LINE> <LINENUMBER>1314</LINENUMBER> <Total>59</Total> </CATEGORY> Last saved 4/21/20119:37:00 AM CourtView®80stice Solutions Page 50 of 78 - <CATEGORY desc="Driver's License Denial, Revocation or Suspension Hearings Held"> <LINE>11</LINE> <LINENUMBER>1315</LINENUMBER> <Total>60</Total> </CATEGORY> - <CATEGORY desc="Disposition of Stolen Property Hearings Held"> <LINE>12</LINE> <LINENUMBER>1316</LINENUMBER> <Total>10</Total> </CATEGORY> - <CATEGORY desc="Peace Bond Hearings Held"> <LINE>13</LINE> <LINENUMBER>1317</LINENUMBER> <Total>0</Total> </CATEGORY> - <CATEGORY desc="Cases in Which Fine and Court Costs Satisfied by Community Service: Partial Satisfaction"> <LINE>14a</LINE> <LINENUMBER>1318</LINENUMBER> <Total>0</Total> </CATEGORY> - <CATEGORY desc="Cases in Which Fine and Court Costs Satisfied by Community Service: Full Satisfaction"> <LINE>14b</LINE> <LINENUMBER>1319</LINENUMBER> <Total>0</Total> </CATEGORY> - <CATEGORY desc="Cases in Which Fine and Court Costs Satisfied by Jail Crediit"> <LINE>15</LINE> <LINENUMBER>1320</LINENUMBER> <Total>0</Total> </CATEGORY> - <CATEGORY desc="Cases in Which Fine and Court Costs Waived for Indigency"> <LINE>16</LINE> <LINENUMBER>1321</LINENUMBER> <Total>0</Total> </CATEGORY> - <CATEGORY desc="Amount of Fines and Court Costs Waived for Indigenc,y"> <LINE>17</LINE> <LINENUMBER>1322</LINENUMBER> <Total>0</Total> </CATEGORY> - <CATEGORY desc="Fines, Court Costs and Other Amounts: Kept by City"> <LINE>18a</LINE> <LINENUMBER>1323</LINENUMBER> <Tota I>0</Total> </CATEGORY> - <CATEGORY desc="Fines, Court Costs and Other Amounts: Remitted to State"> <LINE>18b</LINE> <LINENUMBER>1324</LINENUMBER> <Total>0</Total> </CATEGORY> - <CATEGORY desc="Fines, Court Costs and Other Amounts: Total Collected"> <LINE>18c</LINE> <LINENUMBER>1325</LINENUMBER> Last saved 412112011 9:37:00 AM CourtView®S6stice Solutions Page 51 of 78