Transcript CCAP DQ Presentation 010512

DATA QUALITY FOR
CRIMINAL JUSTICE
FRAMEWORK
PROJECT
INTRODUCTIONS
Implementation Team
County Chief
Adult Probation
and Parole
Officers
Association of
Pennsylvania
County
Commissioners
Association of
Pennsylvania
Pennsylvania District
Attorney’s Association
Steering Committee






Administrative Office of Pennsylvania Courts
(AOPC)
CDI, Inc. (District Attorney records
management system)
County Chief Adult Probation & Parole Officers’
Association of Pennsylvania
County Commissioners Association of
Pennsylvania (CCAP)
County Jails - Berks, Indiana, Lancaster
Digital Solutions, Inc. (AP & Jail records
management systems)
Steering Committee (con’t.)










Pennsylvania Justice Network (JNET)
Juvenile Detention Centers Association of PA
(JDCAP)
PA Board of Probation & Parole
PA Commission on Crime & Delinquency
(PCCD)
PA Commission on Sentencing
PA Department of Corrections
PA District Attorneys Association/Institute
PA Juvenile Court Judges' Commission (JCJC)
PA Office of Attorney General
PA State Police
DATA QUALITY OVERVIEW
What is the concern?

Good quality data and consistent data within
criminal justice records management systems.
Who does it impact?

All users of criminal justice information.
Where do we start?

County District Attorney, Adult Probation, and
Jails.
User Enters
Data
PCCD Grant Funded
DQ Program
Data standardization
and clean-up using
NIEM toolkit
Records Management System
DQ Goal:
90% OTN & SID Reporting Rate
Reports
Display Data
Data Entry Standard
The National Information Exchange Model (NIEM)
has been the standard provided for entering data.
This model has been adopted by the national
government, PA state agencies and local
agencies.
Benefits to Participating
Counties

NIEM compliance and data
standardization at the county level.

Access to additional resources to assist
with historical record clean-up.

Improvement in JNET and PSP data
submission and acceptance.
PA CRIMINAL HISTORY RECORDS SYSTEM
Law
Enforcement
 Criminal
Complaint
 Warrant
 Arrest
Booking Agency
 Suspect
information
 Fingerprints
o Photos




PA Courts
Arraignment
Charges
Disposition
Sentencing
State
Incarceration
 Intake
 Release
County
Incarceration
 Intake
 Release
State Parole
 Begin
 Complete
County Parole
 Begin
 Complete
State Attorney
General
 Investigation

AFIS
Fingerprint
Data Base
PA State Police
Records &
Identification
Division
 Computerized Criminal
History Records
Data Base
SID key
CLEAN
PA Insurance
Department?
 Fingerprints
County District
Attorneys?
PICS
PA Dept. of
Education?
 Fingerprints
Juvenile Court
Judges Comm
 Juvenile
Records
o CPIN
Commonwealth
Photo
Identification
Network
National Crime
Information
Center (NCIC)
PA Dept. of
Public Welfare?
 Fingerprints
PILOT
Pilot Results


Creation of toolkit that identifies data
elements critical to criminal history.
Five participating counties:





Allegheny
Berks
Franklin
Mifflin
Venango
Pilot Results

Over 80 percent improvement in submission
success rates to PSP and JNET.
DQ2 UPDATE
Initial NIEM Compliance
Averages
County by Class
Class 2A Average
Class 2 Average
Class 3 Average
Class 4 Average
Class 5 Average
Class 6 Average
Class 7 Average
PROJECT AVERAGE BY DEPT
PROJECT AVERAGE
Initial AP Initial DA
Score
Score
23%
0%
28%
14%
27%
16%
17%
17%
24%
23%
15%
0%
22%
14%
23%
Post
Initial Jail Launch Post DA Post Jail
AP
DA
Jail
AP %
DA %
Score AP Score Score
Score Difference Difference Difference Change Change
20%
58%
68%
40%
135%
37%
74%
92%
46%
54%
412%
20%
173%
28%
91%
70%
29%
92%
91%
70%
305%
32%
85%
91%
88%
62%
54%
58%
290%
Jail %
Change
253%
271%
Lessons Learned

Judge names and religion consistently
ranked as most error prone fields
Judge List Example






ALLEGHENY COUNTY
AMMERMAN
AMMERMAN, FREDRIC
AMMERMAN, FREDRIC J
ARNER, JAMES G
ARNER, JAMES G.









BELL, JANET
BELTRAMI
BIGLEY, GERARD
BIGLEY, GERARD M
BLAHOVEC
BLAHOVEC,
BLAHOVEC, JOHN
BLAHOVEC`
BLAHOVED
Dashboarding Examples
Lessons Learned (con’t)

Development environment necessary

Verify backup and restore process
DQ ACTION PLAN
Next Steps





Review initial reports and score
Create development environment
DQ Team implements recommendation in
development
County reviews changes and finalizes in
development
Deployment in production scheduled and
executed during system downtime
ADULT PROBATION
JAIL
Timeframe


Execution is approximately 10 business
days AFTER development environment
availability
Engage DSI, county IT, County CJ team
ADD’L CCAP PROGRAMS
OF INTEREST
User Enters
Data
Records Management System
Reports
Display Data
PCCD Grant Funded
DQ Program
Data standardization
and clean-up using
NIEM toolkit
CJIEP
Optional Program
CJIEP takes AOPC
Court Case Event
message and populates
DSI System
electronically
Crystal Support
Optional Program
Crystal Reports Support
program
writes/customizes
reports
DQ Goal
90% OTN & SID Reporting Rate
CJIEP electronically
populates missing
information!
Criminal Justice Information
Exchange Project (CJIEP)




Registration and setup coordinated by
CCAP.
Installation requires technical coordination
between the county, CCAP, JNET, and
AOPC.
Annual maintenance/service fees apply.
May subscribe to receive messages for
one or all three offices (DA, AP, Jail).
Criminal Justice Information
Exchange Project (CJIEP)




County enters CPCMS information
AOPC generates a Court Case Event
Message (CCE)
CCE is delivered through JNET
CJIEP picks up message and updates
available DSI/CDI/ITI systems
Criminal Justice Information
Exchange Project (CJIEP)

Message types - Bind case over, Report
Probation Sentence, Noncompliance
Sentence Modification, Sentence Modified.
Benefits

Update DSI software directly with
Criminal Complaint information


Offender SSN, OTN, SID, Address
Charges – imported instead of typed!
Website:
http://pacounties.org/TechnologyServices/Pages/Criminal
JusticeProjects-CJIEP.aspx
CRYSTAL REPORTS
SUPPORT
Crystal Reports Support
•
•
•
Crystal Reports assistance/writing
Crystal Reports training
Online virtual report repository
PARTICIPATION
Program Fees
QUESTIONS?
Amy Rehmeyer
Contracted Project Manager
[email protected]
Mark Proper
Deputy Director of
Technology Development
[email protected]
Heather Brown
Contracted Project Manager
Assistant
[email protected]
Conway Bushey
Adult Probation and Parole
Officers Assoc of PA
Rita Reynolds
Director of Technology Services
and Telecommunications
[email protected]
Richard Long
PA District Attorneys Association
Executive Director
[email protected] [email protected]