BC Corrections Operational Intelligence for Corrections OIC

1
BC Corrections Operational Intelligence for
Corrections (OIC)

• May 7, 2007

2
Agenda

• BC Corrections Overview
• OIC Project Overview
• Solution Overview
• Lessons Learned
• Questions

3
Where is BC?
British Columbia Pop. 4.2M
4
BC Corrections Overview

• Adult Custody
• Operates nine (9) correctional centres
• Adult men and women
• Remand and sentences of less than 2 years
• Community Corrections Corporate Programs
• Operates fifty three (53) probation offices
• Also research, IS, contract admin, strategic and
  capital planning
• Youth Justice (Custody and Probation)
• Part of Children and Families (separate Ministry)
• Share common systems

5
BC Corrections Locations
Key Statistics Avg. Per Year In
Custody 2,400 Custody Admissions 30,000 In
Community Supervision 20,000 Community
Admissions 35,000 Total System Users 6,000
6
Systems Overview

• Offender Management - CORNET
• Adult and Youth (Juvenile)
• Custody and Community Supervision
• Inmate Electronic Medical Record - PAC
• Integrated Justice System Justin
• Government Owned Shared Source
• Private/Public partnership
• Sold as a foundation solution

7
Adult Custody Centers 9
Adult Community Offices 64
Victim Services
Youth Community Offices 45
CORNET
Court Services
PAC
Parole Board
Prosecution Offices 44
Court / Sheriff Lockups 36
Justin
8
Agenda

• BC Corrections Overview
• OIC Project Overview
• Solution Overview
• Lessons Learned
• Questions

9
OIC Overview

• Province-wide view of offender activities
• Obtained from incident forms
• Unusual events, security, injury, visitors,
  phone, mail,
• Includes information from Police and other
  sources
• Integrates data with provincial OMS (CORNET)
• Identifies trends in illegal activities
• Drug and weapon trafficking
• Gang associations
• Locations and Participants (i.e. Offenders,
  living units, staff, etc.)
• Dimensionally Modeled for analysis purposes

10
OIC Overview

• Restricted Access
• Confidential data (i.e. personalized)
• Reporting for authorized managers only
• Replaces RISC
• Relational Intelligence System for Corrections
• Dedicated data entry staff (Cumbersome
  expensive)
• Limited analytic capabilities

11
How does it work?

• Part of a larger initiative called Cornet3
  (COR-e)
• Portal
• Access to services through Oracle Portal
• Security and Access
• Role Centric Presentation Layer
• E-Forms
• Incident Form
• Workflow, routing and approval
• Business Intelligence
• Operational Intelligence
• Reporting on Incident data from e-forms

12
OIC Benefits

• Interdiction Planning
• Security weaknesses, behavior anomalies
• Risk Assessments, Profiling
• Helps in the prevention of
• Illicit drugs, Escape Attempts, Assaults,
  Injuries, etc.
• Form-based data entry
• Intuitive interface
• Done once captures all

13
OIC Benefits

• Better analytic capabilities
• Simple Reporting for Management
• Sophisticated tools for Analysts (i.e. Cognos)
• Broader Participation
• Data entered directly by field staff
• Notifications to the Client Log
• Also used by Community Corrections
• Adaptable to users needs/capabilities
• Management vs. Analysts
• Key Performance Measurement (i.e. KPIs)

14
On-Line Systems Training

• Web-based training
• No classroom training required
• Lower cost
• Hits a wider audience
• Pulls the culture of the organization into the
  Portal framework

15
2007
2008
2009
Infrastructure 1 e-Form, 4 datamarts
UAT Jun/07
Pilot Sep/07
Provincial Rollout Nov/07
Additional e-Forms Enhanced Operation Intelligence
3rd Party Access Offender network/Secure
SubNet Enhanced OI
May 2004
Cornet3 (OIC) Timelines
16
Agenda

• BC Corrections Overview
• OIC Project Overview
• Solution Overview
• Lessons Learned
• Questions

17
POs COs
Managers
Portal
Access Layer
Authentication Authorization
OIC Analysis
E-Forms (Incident Data)
Services Layer
Cubes
CORNET OMS
Other Source Data Police, HR, Finance, etc
Data Warehouse
Data Layer
18
Portal Authentication

• Oracle Portal technology
• Oracle Single Sign-on (SSO)
• Oracle Portlets
• Authentication
• Using Oracle OID Service for Authentication
  Authorization
• Siteminder
• Initially only Corrections and Youth Justice
  users
• Auditing
• Oracle BPEL monitoring
• Business Activity Monitoring (BAM)

19
Portal
20
Portal - Incident Search Page
21
E-Forms

• Workflow enabled by Oracle BPEL Worklist
• Pre-filled using CORNET data
• Form data saved as XML
• Allows for file attachments (e.g. pictures,
  audio, video, etc.)
• Adobe for viewing/displaying completed Forms
• XML based forms
• Deployed to all Field Staff (CO -gt Warden)

22
Custody Incident eForm
23
Custody Incident eForm
24
BPEL Workflow
25
Business Intelligence

• Using Cognos 8.0 technology
• DecisionStream ETL
• ReportNet
• PowerPlay Analytics
• Subject areas (datamarts)
• Incidents
• Offender Classifications (Risk Assessments)
• Offender Movements (Admissions, Transfers,
  Releases)
• Offender Demographics (Race, Age, Gender)

26
Incident Datamart
Location
Time
Staff (HR) Information
Incident
Visit Information
Offender Demographics
Offender Classifications
27
BI Analytics - Cubes
28
Caseload by Region
29
Admissions by Age
30
High Level Architecture
31
Agenda

• BC Corrections Overview
• OIC Project Overview
• Solution Overview
• Lessons Learned
• Questions

32
Lessons Learned

• Staged Approach
• Visioning
• Prototyping
• Phased implementations
• Dont under-estimate the learning curve
• new and leading edge technology
• More integration work than anticipated
• Understand the Product Capabilities before
  doing the design
• Use the framework as much as possible
• Minimize customizations to Worklist application
• Reduce dependencies on other government
  technology initiatives (i.e. Portal)
• Manage expectations
• Our business requirements outpaced the
  capabilities of government (i.e. Security)

33
Agenda

• BC Corrections Overview
• OIC Project Overview
• Solution Overview
• Lessons Learned
• Questions