1 / 30

Michigan’s Judicial Data Warehouse (JDW)

Michigan’s Judicial Data Warehouse (JDW). Why Build a Judicial Data Warehouse?.

Faraday
Download Presentation

Michigan’s Judicial Data Warehouse (JDW)

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Michigan’s Judicial Data Warehouse (JDW)

  2. Why Build a Judicial Data Warehouse? Currently, Michigan’s 241 trial court locations are supported by 29 different case management systems deployed on 150 different servers. A statewide court database does not exist and this creates a void in the knowledge about individuals and cases in the Michigan Court system. Centralized Name Index • Provides Court Personnel with the ability to find a person known to the Michigan Judicial System for all cases in which he/she is involved. Statewide Database • Provides the SCAO and Court Personnel with the ability to build queries for statistical analysis or summary information from trial courts with different case management systems. Standardization • Provides the SCAO and Court Personnel the ability to execute those queries, without having to understand the data specific to a county or court system.

  3. Who is building the Judicial Data Warehouse? State Court Administrative Office Mark Dobek/Margo Runkle Judicial Information Systems State of Michigan Department of Information Technology Bull Information Systems Neal Zuzga Project Manager

  4. How is the Judicial Data Warehouse being built? Bull Services utilizes the following key processes to build the Judicial Data Warehouse: • Extract, Load, and Transformation (ELT) Process • Update Process • Auto Balance Process • Standardization Process • Address Cleansing and Standardization • Unique Person Identification Process Field Staff can access the Judicial Data Warehouse via: • Web-based Name Search Application, • Hummingbird BI-Query (reporting tool). Sensitive and non public data is restricted to proper personnel.

  5. Standardization Process • Standard Values have been established for: • Alternate Name Type (examples AKA, DBA, MIN) • Attorney Type (A, I, R, U, W) • Case Security (P, N) • Case Status (C, D, O, P, U) • Disposition Code (examples: AMD, DIS, GTY, JGE, SET) • Gender (F, M, U) • Party Type (examples: BUS, D, FOC, GDN, JUV, P) • Offense Code Type (M, L, S) • Offense Original or Amended Indicator (O, A) • Offense Modifier (A, C, L, S) • Race (A, B, H, I, M, W, U) • Standardization and cleansing of Addresses • Postal Soft is used to standardized addresses. Unique Addresses are stored and address history is maintained. • Translation Tables • Each source system has a conversion table listing their source codes along with the converted JDW standard codes.

  6. Unique Person ID (UPI) • ID assigned to uniquely identify an individual. • ID is assigned based on pre-defined matching criteria. • Currently, matching criteria is based on: • Driver’s License Number • Social Security Number • State Identification Number • Name/Date of Birth/Address • Conservative approach used to match and assign the same UPI number to an individual.

  7. When is the Judicial Data Warehouse being implemented? When implemented Statewide (EST 12/2008) • 83 Counties • 241 Courts • 29 Software Providers • 100 plus software applications Currently Implemented (2/2007) • 80 Counties • 181 Courts • 22.8 million cases in the warehouse now

  8. Roscommon Roscommon KEWEENAW HOUGHTON ONTONAGON BARAGA Gogebic LUCE MARQUETTE CHIPPEWA ALGER SCHOOLCRAFT IRON DICKINSON MACKINAC DELTA EMMET MENOMINEE CHEBOYGAN PRESQUE ISLE CHARLEVOIX ANTRIM OTSEGO ALPENA MONTMORENCY LEELANAU OSCODA BENZIE GRAND TRAVERSE KALKASKA ALCONA CRAWFORD IOSCO MANISTEE WEXFORD MISSAUKEE ROSCOMMON OGEMAW GLADWIN ARENAC MASON LAKE OSCEOLA CLARE HURON OCEANA NEWAYGO MECOSTA ISABELLA MIDLAND BAY TUSCOLA SANILAC SAGINAW MONTCALM GRATIOT MUSKEGON KENT LAPEER GENESEE ST. CLAIR OTTAWA IONIA CLINTON SHIAWASSEE MACOMB OAKLAND ALLEGAN BARRY EATON INGHAM LIVINGSTON VAN BUREN KALAMAZOO CALHOUN JACKSON WAYNE WASHTENAW BERRIEN CASS ST. JOSEPH BRANCH HILLSDALE LENAWEE MONROE JDW Implementation Map February 2007 Implemented Partially Implemented. Refer to Regional Implementation Map. Partially Implemented On Hold (Application DecisionPending) Partially Implemented and Application Decision Pending

  9. Data Sharing/Functionality Highlights • DLN Matching with MDOS – compares the court’s DLN with the DLN from MDOS. This results in more accurate matches when assigning the UPI number. The MDOS DLN, Address, Gender, and DOB is displayed in BI-Query and the Name Search Application. • Death Record Matching with MDCH – compares Name and DOB with individuals with court records to the MDCH Death Record Database, allowing court personnel to cease collection efforts or cancel outstanding warrants on deceased individuals. Report available in BI Query only.

  10. New FunctionalityUnder Development • Sweep Reports – Matching data with Department of Corrections to provide information on inmates who owe the courts fees. A predefined query will be developed so users can easily generate reports on these individuals and initiate the process to collect those fees. • Updating Data in the JDW – This is currently a monthly process. Efforts are underway to change this to a more frequent basis. • New Data – Efforts are underway to add new data to the JDW. This includes Parole and Probation information from the Department of Corrections, and Sentencing and Financial data from the courts.

  11. Conclusion There are several benefits to implementing a Judicial Data Warehouse, namely: • One statewide court database • User-friendly applications (web-based Name Search application and the BI-Query reporting tool) • On Demand, Adhoc Reporting capabilities (BI Query) – allowing field staff to retrieve information within minutes. • The JDW brings the courts into the 21st century with information technology resulting in better decision making, quicker turnaround time, and the ability to easily exchange information with other agencies to serve and protect Michigan citizens.

  12. Judicial Data WarehouseApplication Demo

  13. JDW Web Application Main Menu

  14. JDW Web ApplicationSearch Options

  15. JDW Web ApplicationSearch Results Screen

  16. JDW Web ApplicationCase Detail Screen

  17. JDW Web ApplicationCase Detail Screen (continued)

  18. JDW BI Query ApplicationMain Menu

  19. JDW BI Query ApplicationPredefined Reports

  20. Predefined Report Example State Offense By Police Agency Report

  21. JDW BI Query Road Map Adhoc Queries

  22. JDW BI Query Links of Interest

  23. Example Adhoc Query Show me the total number of Personal Protection Orders filed in Genesee County in 2005. PPO Case Types: PH - Stalking PJ - Juvenile PP - Domestic PO – Protective Orders

  24. Example #2 Show me everyone with an Outstanding Warrant in Lake County. I want to see the person’s name, address, date of birth, and DLN.

  25. Lake County Outstanding Warrants - total 563

  26. Example #3 Show me the number of open cases by Judge in Midland County.

  27. MIDLAND COUNTY – OPEN CASES BY JUDGE

More Related