michigan s judicial data warehouse jdw l.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Michigan’s Judicial Data Warehouse (JDW) PowerPoint Presentation
Download Presentation
Michigan’s Judicial Data Warehouse (JDW)

Loading in 2 Seconds...

play fullscreen
1 / 30

Michigan’s Judicial Data Warehouse (JDW) - PowerPoint PPT Presentation


  • 331 Views
  • Uploaded on

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

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 'Michigan’s Judicial Data Warehouse (JDW)' - fiachra


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
slide8

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