Georgia Bureau of Investigation February Monthly Report FY2017 Presented to the Board of Public Safety April 13, 2017 Vernon M. Keenan Director Table of Contents I. Staffing and Backlog................................. 3 4 II. Administration Office of Privacy & Compliance/Open Records Personnel Staff Services........................................... 5 III. Investigative Division.................................. 6 8 IV. Crime Lab.............................................. 9 11 V. Georgia Crime Information Center................. 12 20 2 Vacant State Positions FY2017 Total Vacant Positions in DOFS Vacant Scientist Positions Total Vacant Positions in GCIC Total Vacant Positions in Admin Vacant Sworn Agent Positions Total Vacant Positions In the Investigative Division Jul Aug Sept Oct Nov Dec Jan Feb Mar Apr May Jun 24 23 23 24 26 26 23 27 8 8 7 10 11 11 16 18 1 1 1 2 2 2 3 3 4 4 5 5 5 5 5 5 24 24 28 21 9 6 8 8 31 30 33 28 16 14 17 15 3 DOFS Backlog Chart Unworked Reports over 30 Days Old FY2017 Discipline Chemistry Firearms Forensic Biology Impressions Latent Prints Medical Examiners Miscellaneous Services Operations Support Toxicology Trace Evidence Total Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun 6,546 7,175 7,822 8,482 9,237 9,453 9,648 10,156 2,520 2,878 3,031 3,051 3,094 2,997 3,015 2,942 3,110 3,191 3,466 3,724 3,863 3,863 3,859 3,991 38 40 43 42 39 37 37 41 3,137 3,234 3,309 3,446 3,550 3,551 3,503 3,572 120 97 170 165 198 194 182 192 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 827 506 829 858 1,523 1,386 971 1,038 466 503 511 520 531 513 504 484 16,764 17,624 19,181 20,288 22,035 21,994 21,719 22,416 4 GBI Administration Office of Privacy & Compliance/Open Records Open Records Request Archives February 2017 335 62 Total FY2017 2,328 205 Personnel Employee Totals February 2017 Investigative Division Georgia Crime Information Center Division of Forensic Sciences Administration Total State Funded Positions 350 42 293 43 728 Grant Funded Positions 19 75 29 1 124 Total 369 117 322 44 852 Total State Funded Positions Vacant Investigative Division 15 Georgia Crime Information Center 3 Division of Forensic Sciences 27 Administration 5 Total 50 State Funded Vacancies Under Active Recruitment 2 3 6 2 13 5 INVESTIGATIVE DIVISION February 2017 Fiscal YTD Total Sworn Employees 274 (filled-includes grant) Total Investigative Hours Expended 28,417.50 231,114.56 Crimes Against Persons, includes Death Investigations Child Abuse Sex Crimes Missing Persons Assault, Kidnapping, Robbery, Terrorist Acts, Fugitive, Human Trafficking, etc. 8,901.00 3,948.50 2,586.00 517.50 948.00 901.00 79,136.75 41,199.00 22,421.25 3,391.50 2,591.00 9,534.00 Property Crimes, including Theft, Burglary, Forgery 3,131.50 22,119.80 Drug Investigations 3,937.00 30,796.00 Meth Lab Investigations 13.00 91.00 Polygraph Examinations 768.00 6,779.00 Background Investigations 298.00 4,107.00 Other Investigations, including Preliminary Investigations 6,724.00 50,600.51 Bomb Disposal Services 921.00 7,509.00 Crime Analysis - 24.00 Crime Scene Specialists 3,724.00 29,951.00 All figures above represent Investigative Hours Total Seizures $497,624.00 $103,656,218.22 6 Investigative Hours Expended YTD FY2017 Background Investigations >1% Crime Analysis >1% Bomb Disposal Services 3% Crime Scene Specialists 13% Crimes Against Persons 34% Other Investigations 22% Polygraph Investigations 3% Meth Lab Investigations >1% Drug Investigations 13% Property Crimes 10% 7 8 Crime Lab Medical Examiners (includes all laboratories) February 2017 FY2017 YTD Autopsies Consultations Total ME Cases Managed 253 1,847 170 1,155 423 3,002 Clayton County Death Certificates 27 321 Percentage of Cases Released in 90 days: 79.7% Medical Examiner Activity, FY2017 Consultations 38% Autopsies 62% Confirmed CODIS Hits for February 2017 State Offender Hits 37 State Forensic Hits 8 National Offender Hits 13 National Forensic Hits 1 Total 59 Samples entered into CODIS for February 2017 1,117 Profiles in CODIS Forensic Casework Profiles Convicted Offender Profiles Missing Person/Unidentified Human Remain Profiles Staff/QC File Total 20,486 316,870 6 497 337,859 9 Laboratory Production Report Turnaround for February 2017 Laboratory Headquarters - Atlanta Central Regional - Macon Coastal Regional - Savannah Eastern Regional - Augusta Northeastern Regional Southwestern Regional - Moultrie Western Regional - Columbus # Released in 45 Days 2,820 19 61 339 898 98 53 Total % Released in Released 45 Days 4,388 64% 170 11% 419 15% 487 70% 1,001 90% 201 49% 198 27% System-wide Totals 4,288 6,864 62% Note: 78.2% Casework Reports were released within 90 days. Report Turnaround for Year-to-Date, FY2017 Laboratory Headquarters - Atlanta Central Regional - Macon Coastal Regional - Savannah Eastern Regional - Augusta Northeastern Regional Southwestern Regional - Moultrie Western Regional - Columbus # Released in 45 Days 16,676 798 316 2,410 7,985 593 529 Total % Released in Released 45 Days 29,436 57% 1,777 45% 3,071 10% 3,514 69% 8,910 90% 1,469 40% 1,359 39% System-wide Totals 29,307 49,536 59% 10 Crime Lab Reports Processed for February 2017 Department Requested Total Released Chemistry (includes Drug ID) Firearms Forensic Biology Impressions Latent Prints Medical Examiners Operations Support Toxicology Trace Evidence 3,011 198 2,088 5 240 473 4 2,522 171 1,849 123 1,537 2 125 497 3 3,078 147 Total 8,712 7,361 Crime Lab Reports Processed FY2017 Department Requested Total Released Chemistry (includes Drug ID) Firearms Forensic Biology Impressions Latent Prints Medical Examiners Operations Support Toxicology Trace Evidence 20,591 2,131 15,172 29 1,760 3,686 74 18,623 1,091 14,577 1,461 13,411 12 1,067 3,632 67 17,929 1,012 Total 63,157 53,168 11 Georgia Crime Information Center February 2017 CJIS Network Statistics System Uptime: Messages Processed: NCIC SERVICES 100% 66,615,597 CJIS Operations 1. Sex Offender Registry Records Added 2. Protection Order Registry Records Added Month 128 Month 2,088 FY2017 1,220 FY2017 17,201 Database Totals 29,320 Database Totals 343,332 3. National Data Exchange (N-DEx) Number of Georgia agencies contributing to N-DEX: 3 Agencies/Users with N-DEx Inquiry Access Only (no data contributed) Added Removed Total with Inquiry Access Agencies 3 0 36 Users* 3 1 43 * Effective January 2017 any LEEP account holder that has N-DEx access but hasn't used N-DEx for 90 days will be locked out of N-DEx and will not be granted access. N-DEx agency and user numbers reflect this change. 4. Off-Line Search Requests Type of Request Month FY2017 Administrative (Criminal Justice Agency) 24 207 Open Records 1 8 Subpoena 0 0 Media 0 0 Possible CJIS Security Violations 2 22 12 CJIS Audits GCIC conducted 18 CJIS Audits INFORMATION SERVICES Criminal History Identification Services 1. Criminal Fingerprint Transactions Received Submissions Submissions w/Palms Submissions w/Photos Monthly 39,205 16,756 12,028 FY2017 Transactions processed within 2 hours of receipt: 91% 2. Applicant Fingerprint Transaction Received Submissions Monthly 37,465 FY2017 Transactions processed within 24 hours of receipt: 3. Final Disposition Transactions Received Local Agency GCIC TOTAL Monthly 58,916 5,362 64,278 99% FY2017 4. RAPID Identification Transactions Submissions AFIS Hits NCIC Hits FBI RISC Hits Monthly 13,398 54% 38% 4% FY2017 5. Non-Criminal Justice (NCJ) Audits, Visits and Trainings Audits In Compliance Out of Compliance TOTAL Audits Monthly 19 11 30 FY2017 Advisement Memos 1 313,924 138,742 96,355 324,683 503,981 42,427 546,408 111,281 48% 40% 2% 35 25 60 1 13 Visits & Trainings Agency Visits Trainings Attendees Monthly 45 1 2 FY2017 109 7 168 6. Disposition Recovery Project Completed Research Counties Monthly 2,147 1 Project to Date 63,560 1 14 These are the number of dispositions added for serious and violent felony arrests for the project to date. PLANS AND PROGRAM DEVELOPMENT AFIS ENHANCEMENTS Project Description System enhancements for the Automated Fingerprint Identification System (AFIS) which include Accounts Receivable, T-Net fee changes, AFIS -SORT interface, system reports, creation of new IntegraID Document Management folders. Monthly Update The vendor resolved issues with the Document Management updates to Integra ID. The changes were approved and moved to production. The Sex Offender Registry Tool Statement of Work was approved and a cost quote was requested from the vendor. APPLICATION DEVELOPMENT - Protective Order Registry Project Description In an effort to provide better information sharing, the Georgia Protective Order Registry (POR) is being updated to improve record data quality and expanding database capabilities by replacing the existing application and infrastructure. Monthly Update The project development team continues to meet to discuss ongoing system test and the project status. The IT team are working to complete efforts to move the POR application from the development server to the production servers. CHILD FATALITY SYSTEM REVIEW PROJECT Project Description The Child Fatality Review (CFR) unit requested an enhancement to their current process to capture Medical Examiners (ME) data for child related deaths in the State of Georgia and have asked for additional reporting capabilities. Monthly Update The developer began writing a program to merge the Division of Forensic Sciences (DOFS) data into the new CFR database. Progress was made on the screens created for the coroner's questions. 15 COMPUTERIZED CRIMINAL HISTORY (CCH) ENHANCEMENTS Project Description The Computerized Criminal History (CCH) system will undergo system enhancements to meet the new State of Georgia legislative changes concerning the First Offender Act (FOA). Additional updates such as system modifications and reports will be implemented for internal users. Monthly Update The CCH vendor continues programming for the system enhancements with a scheduled completion date of April 2017. CRIMINAL JUSTICE EXCHANGE PROJECT Project Description The Georgia Bureau of Investigation will programmatically own an initiative of the Governor's Office entitled Criminal Justice Exchange Project (CJEP). CJEP will incorporate the electronic exchanges of information between state and local criminal justice agencies in Georgia. Each exchange automates a manual, paper-based criminal justice business process and will follow a criminal case lifecycle from booking through disposition and supervision. The goals of the project are to create seamless connections between systems, establish a single, consistent architecture adopted to guide all aspects of program implementation and to establish a governance structure that views criminal justice as a statewide community. The exchanges will involve the coordination of multiple agencies and vendor applications. Monthly Update The project team provided a project overview to GTA's Critical Panel Review Board and an overall status to the Executive Governance Council. A county pilot kick-off meeting was held to bring all five pilot county representatives together to review the upcoming project plan and schedule. CUSTOMER RELATIONSHIP MANAGEMENT (CRM) APPLICATION PROJECT Project Description The CRM Application Project will provide a single source of historical interaction with GCIC external customers. The application will give GCIC end users the ability to search, track and report customer interactions throughout GCIC's business units. Monthly Update The project kick-off was held and Microsoft lead discovery workshops with the project team. Based on the feedback from the workshops GCIC needed additional business processes to be included in the CRM tool. Several sessions were held to document the accurate business process flows. The flows are pending final review and approval. CUSTOMER SUPPORT - TRAINING Project Description The Customer Support Training group provides training in the area of GCIC programs, GCIC applications, GCIC/FBI compliance and other supported law enforcement training to both criminal and non-criminal justice agencies, municipal, magistrate and probate courts across the State of Georgia. The group extends the option to receive classroom training or training within an e-Learning environment. Monthly Update The LMS Staff handled 142 phone calls and managed LMS user account additions and changes. 16 17 GCIC TRAINING SYMPOSIUM Project Description The GCIC Training Symposium is designed to offer continuing education with the goal of providing vital knowledge regarding GCIC and federal law enforcement programs to both the criminal justice and non-criminal communities. Monthly Update Draft requirements for the registration website were provided and the website is under development. A tentative list of classes has been drafted and approval is dependent on the confirmed speakers. Work continues on finalizing the Articles of Incorporation required for the 501c3 application and finding a key note speaker. HUMAN RESOURCES (HR) TIMESHEET PROJECT Project Description Enhancement of the application used by non-sworn units of the GBI for tracking time. Monthly Update The project sponsor provided approval for Phase 2 requirements and for the electronic signature workflow. Application troubleshooting continues and development has begun for holiday hours worked, earned, or taken calculations. Timesheet approvals would be routed based on PeopleSoft employee hierarchy and email addresses. Support for the application was transferred to the IT Help Desk. INFORMATION SERVICES CRIMINAL HISTORY APPLICATION REDESIGN PROJECT Project Description A redesign of the web application used by Information Services staff to log and track activities performed on criminal history information as well as services performed for the public. Monthly Update The project team continues to review the CCH/AFIS application log search and edit screens updates. The code review target completion date is September 2017. 18 LAW ENFORCEMENT MESSAGE SWITCH (LEMS) Project Description The message switch provides a means of communication between federal, state and local law enforcement agencies throughout the state of Georgia, the United States and other countries and to take advantage of new features and advances in technology, GCIC is looking to upgrade or replace this system. Monthly Update The project team completed the project charter and will begin the initiation phase of the Project Management process. A kick-off meeting has been scheduled for March. LEARNING MANAGEMENT SYSTEM (LMS) PROJECT Project Description GCIC plans to replace the existing learning management system (LMS) by obtaining a new web-based LMS software application. The online learning management system will allow interactive exercises to aid in knowledge retention and administration of training information. The LMS training system will manage all learning components, security, enrollment, and course structure for course certification. Monthly Update The team met with three potential LMS vendors to review product offerings. NATIONAL INCIDENT - BASED REPORTING SYSTEM (NIBRS) PROJECT Project Description The National Incident Based Reporting System (NIBRS) collects data on each single incident and arrest for each offense coming to the attention of law enforcement for which specific facts about each crime is collected. GBI is in the process of replacing the current UCR summary-based system with an application that will collect incident-based data. Monthly Update Cross-field validations, mandatory fields for Family Violence codes and agency names and ORI numbers were provided to the vendor. The Communication Plan and the project schedule with key milestone dates were completed by the vendor. The NIBRS will be hosted by the vendor in a Microsoft Azure environment. GBI personnel participated in a FBI regional training session which was held in Orlando, FL. SEX OFFENDER REGISTRY TOOL (SORT) ENHANCEMENT PROJECT Project Description System enhancements for the SORT application. Phase 1 will consist of modifications to the application used by Sheriff's Offices, the public website, NCIC web services and SORT Reports. Phase 2 will focus on the web service between SORT and AFIS for the upload of SORT documentation. Monthly Update A new version of SORT that included the Correct Address and the Advanced Search feature was deployed into production. A request to open a port for retrieval of the Correct Address data files from the Experian SFTP server was completed. SHAREPOINT CONFIGURATION PROJECT Project Description The SharePoint tool will be used as an internal web portal for organizing and sharing information as an employee collaborative tool for internal communication. The portal will also include an Intranet application for each of the three GBI divisions that would allow content management, document repository and information sharing of announcements, news and department information. Monthly Update Changes were made to the SharePoint layout based on feedback received from GCIC managers. The main GBI SharePoint page will be developed and released along with GCIC pages. A demo will be scheduled to reveal and introduce SharePoint to other GBI divisions. 19 WEB SITES REDESIGN PROJECT Project Description Redesign of the internal and external GCIC web sites. Monthly Update The GCIC Landing Page was completed by GTA GeorgiaGov Interactive group and approved by project sponsors. The page and website enhancements will be published once the demo is presented to GCIC Command Staff. 20