Michigan s judicial data warehouse jdw
Download
1 / 30

- PowerPoint PPT Presentation


  • 946 Views
  • Updated On :

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

Related searches for

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about '' - Faraday


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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

Why build a judicial data warehouse
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.


Who is building the judicial data warehouse
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


How is the judicial data warehouse being built
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.


Standardization process
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.


  • Unique person id upi
    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.


  • When is the judicial data warehouse being implemented
    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


    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


    Data sharing functionality highlights
    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.


    New functionality under development
    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.


    Conclusion
    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.


    Judicial data warehouse application demo
    Judicial Data WarehouseApplication Demo



    Jdw web application search options
    JDW Web ApplicationSearch Options


    Jdw web application search results screen
    JDW Web ApplicationSearch Results Screen


    Jdw web application case detail screen
    JDW Web ApplicationCase Detail Screen


    Jdw web application case detail screen continued
    JDW Web ApplicationCase Detail Screen (continued)



    Jdw bi query application predefined reports
    JDW BI Query ApplicationPredefined Reports


    Predefined report example state offense by police agency report
    Predefined Report Example State Offense By Police Agency Report



    Jdw bi query links of interest
    JDW BI Query Links of Interest


    Example adhoc query
    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


    Example 2
    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.



    Example 3
    Example #3

    Show me the number of open cases by Judge in Midland County.



    ad