Georgia Bureau of Investigation July Monthly Report FY2019 Presented to the Board of Public Safety September 20, 2018 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 19 2 Vacant State Positions FY2019 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 29 18 2 5 23 32 3 DOFS Backlog Chart Unworked Reports over 30 Days Old FY2019 Discipline Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun Chemistry 17,832 Data Conversion 1 Firearms 3,525 Forensic Biology 6,154 Impressions 55 Latent Prints 4,385 Medical Examiners 218 Miscellaneous Services 0 Operations Support 2 Toxicology 1,041 Trace Evidence 644 Total 33,857 4 GBI Administration Office of Privacy & Compliance/Open Records Open Records Request Archives July 2018 401 23 Total FY2019 401 23 Personnel Employee Totals Investigative Division Georgia Crime Information Center Division of Forensic Sciences Administration Total July 2018 State Funded Positions 369 44 314 43 770 Grant Funded Positions 24 77 37 4 142 Total 393 121 351 47 912 Investigative Division Georgia Crime Information Center Division of Forensic Sciences Administration Total Total State Funded Positions Vacant 32 2 29 5 68 State Funded Vacancies Under Active Recruitment 17 0 0 1 18 5 INVESTIGATIVE DIVISION July 2018 Fiscal YTD Total Sworn Employees 271 (filled-includes grant) Total Investigative Hours Expended 30,575.75 30,575.75 Crimes Against Persons, includes Death Investigations Child Abuse Sex Crimes Missing Persons Assault, Kidnapping, Robbery, Terrorist Acts, Fugitive, Human Trafficking, etc. 12,019.00 5,902.00 3,175.00 424.00 1,054.00 1,464.00 12,019.00 5,902.00 3,175.00 424.00 1,054.00 1,464.00 Property Crimes, including Theft, Burglary, Forgery 2,597.25 2,597.25 Drug Investigations 4,602.00 4,602.00 Meth Lab Investigations 4.00 4.00 Polygraph Examinations 993.00 993.00 Background Investigations 203.00 203.00 Other Investigations, including Preliminary Investigations 5,148.50 5,148.50 Bomb Disposal Services 1,253.00 1,253.00 Crime Analysis 35.00 35.00 Crime Scene Specialists 3,721.00 3,721.00 All figures above represent Investigative Hours Total Seizures 13,061,438.00 $13,061,438.00 6 Investigative Hours Expended YTD FY2019 Crime Analysis >1% Background Investigations 1% Bomb Disposal Services 4% Crime Scene Specialists 12% Crimes Against Persons 39% Other Investigations 17% Polygraph Investigations 3% Meth Lab Investigations >1% Drug Investigations 15% Property Crimes 9% 7 8 Crime Lab Medical Examiners (includes all laboratories) July 2018 FY2019 YTD Autopsies Consultations Total ME Cases Managed 188 188 129 129 317 317 Clayton County Death Certificates 45 45 Percentage of Cases Released in 90 days: 73.2% Medical Examiner Activity, FY2019 Consultations 37% Autopsies 63% Confirmed CODIS Hits for July 2018 State Offender Hits 58 State Forensic Hits 11 National Offender Hits 11 National Forensic Hits 1 Total 81 Samples entered into CODIS for July 2018 1,283 Profiles in CODIS Forensic Casework Profiles Convicted Offender Profiles Missing Person/Unidentified Human Remain Profiles Staff/QC File Total 9 22,909 332,313 7 523 355,752 Laboratory Production Report Turnaround for July 2018 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,586 22 73 305 1,604 36 53 Total % Released in Released 45 Days 3,967 65% 317 7% 547 13% 459 66% 1,890 85% 272 13% 302 18% System-wide Totals 4,679 7,754 60% Note: 68% Casework Reports were released within 90 days. Report Turnaround for Year-to-Date, FY2019 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,586 22 73 305 1,604 36 53 Total % Released in Released 45 Days 3,967 65% 317 7% 547 13% 459 66% 1,890 85% 272 13% 302 18% System-wide Totals 4,679 7,754 60% 10 Crime Lab Reports Processed for July 2018 Department Requested Total Released Chemistry (includes Drug ID) Firearms Forensic Biology Impressions Latent Prints Medical Examiners Operations Support Toxicology Trace Evidence 3,654 145 1,790 3 175 467 15 2,444 84 3,064 76 1,983 2 108 472 19 2,457 45 Total 8,777 8,226 Crime Lab Reports Processed FY2019 Department Requested Total Released Chemistry (includes Drug ID) Firearms Forensic Biology Impressions Latent Prints Medical Examiners Operations Support Toxicology Trace Evidence 3,654 145 1,790 3 175 467 15 2,444 84 3,064 76 1,983 2 108 472 19 2,457 45 Total 8,777 8,226 11 Georgia Crime Information Center CJIS Network Statistics System Uptime: Messages Processed: CJIS Operations 1. Sex Offender Registry Records Added July 2018 NCIC SERVICES 100% 75,549,124 Month 142 FY2019 142 Database Totals 31,249 2. Protection Order Registry Records Added Month 2,470 FY2019 2,470 Database Totals 150,034 3. National Data Exchange (N-DEx) Number of Georgia agencies contributing to N-DEX: 33 (5 direct, 28 LInX) Agencies/Users with N-DEx Inquiry Access Only (no data contributed) Added Removed Total with Inquiry Access Agencies 0 3 16 Users 0 1 22 4. Off-Line Search Requests Type of Request Administrative (Criminal Justice Agency) Open Records Subpoena Media Possible CJIS Security Violations Month 24 3 2 0 4 FY2019 24 3 2 0 4 CJIS Audits GCIC conducted 25 CJIS Audits 12 INFORMATION SERVICES Criminal History/Identification Services 1. Criminal Fingerprint Transactions Received Submissions Submissions w/Palms Submissions w/Photos Month 42,921 18,394 15,388 Transactions processed within 2 hours of receipt: 95% 2. Applicant Fingerprint Transactions Received Submissions Month 42,325 Transactions processed with 24 hours of receipt: 100% 3. Final Disposition Received Local Agency GCIC TOTAL Month 77,132 5,992 83,124 4. RAPID Identification Transactions Submissions AFIS Hits NCIC Hits FBI RISC Hits Month 11,576 69% 44% 9% 5. Non-criminal Justice Audits, Visits and Trainings In Compliance Out of Compliance TOTAL AUDITS Advisement Memos Agency Visits Attendees Trainings Month 13 11 24 8 60 6 FY2019 42,921 18,394 15,388 FY2019 42,325 FY2019 77,132 5,992 83,124 FY2019 11,576 69% 44% 9% FY2019 13 11 24 8 60 6 13 6. Disposition Recovery Project Submitted to Vendor Dispositions Processed Month 1,610 2,512 Project to Date 100,866 98,535 The chart below shows the number of serious/violent felony offenses that were previously restricted but are now returned for licensing and employment purposes because a disposition of guilt was obtained and entered in the criminal history database. 14 PLANS & PROGRAM DEVELOPMENT APPLICATION DEVELOPMENT - Protective Order Registry Project Description - 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 new POR system continues to operate successfully as more users are added to the system. Several monthly and user reports were designed and implemented. 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 is continuing to work on developing a SSIS (SQL Server Integration Services) package. 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 - GBI, GTA, Consultants, Statewide Stakeholders and vendors continue to meet and work towards the completion of project data exchanges by the October 2018 release date. GBI is working with the vendor on applying patches for Transport Layer Security (TLS) which will allow HTTPS communications to web services. GBI is waiting on an Oracle solution for the problem with the database not returning client certificates to the Enterprise Serial Bus (BUS) as part of the SSL secure handshake. CUSTOMER SUPPORT - TRAINING Project Description - The Customer Support Training group provides training in 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. 15 Monthly Update - The GBI online Learning Management System contains several videos and online classroom training available to agencies and vendors of law enforcement agencies. The trainings completed online and within the classrooms for the month are included in the charts. The LMS Staff handled 201 phone calls, 790 emails and managed LMS user account additions. The Customer Support Training team also developed and delivered agency training on GCIC programs/applications, and the training staff completed teach backs to gain insight and feedback for improving overall quality of training content and delivery. 16 DEPARTMENT OF REVENUE (DOR) DRIVES PROJECT Project Description - The purpose of this project is to document, configure, integrate, and test two interfaces with the new Georgia Department of Revenue (DOR) Driver Record and Integrated Vehicle Enterprise System (DRIVES). The two new interfaces will use existing LEMS Web Services capabilities with National Information Exchange Model (NIEM) Extensible Markup Language (XML) message formats. One interface will be used to send and receive vehicle registration queries and responses to and from DRIVES. The other interface will be used to receive stolen vehicle requests and responses to and from DRIVES. Monthly Update - GBI continues to work through several troubleshooting issues with vendors to address port access between DOR and GBI test environments. GBI completed the checklist requirements for the web service line and followed up with NCIC to confirm the IP addresses. GBI's IT Network group is working on securing the needed certificate for the web service. Once received, the certificate will be sent to NCIC. FINANCE ACCOUNTS RECEIVABLE (AR) SYSTEM PROJECT Project Description - GBI Finance/Accounting requested a new accounts receivable system to process fee invoices and payments. Monthly Update - The Project Completion document was submitted to the project sponsors and is awaiting final signature from the Finance Director. This project is complete and will be removed from the monthly report. 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 - The project team continues to complete tasks for the symposium. Over 800 paid registrations have been received. 17 GEORGIA APPLICANT PROCESSING SYSTEM REPLACEMENT (GAPS) PROJECT Project Description - The Georgia Crime Information Center Information Services is seeking to obtain the services of a qualified and experienced vendor to provide an applicant fingerprinting solution that will electronically capture and submit applicant fingerprints to the Automated Fingerprint Identification System (AFIS). In addition, the selected vendor shall handle receiving fingerprint search results and disseminate the results to the requestor. Monthly Update - The project kick-off meeting was held. Weekly meetings were scheduled to define requirements for development of the new GAPS. HUMAN RESOURCES (HR) TIMESHEET PROJECT Project Description - Enhancement of the application used by non-sworn units of the GBI for tracking time. Monthly Update - No accomplishments for this reporting period. 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 is currently placed on hold. There are no accomplishments this reporting period. 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 to take advantage of new features and advances in technology, GCIC is looking to upgrade or replace this system. Monthly Update - Recommendations from the Georgia Technology Authority and the project sponsors were included in the requirements and submitted to the project team for review. 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 - The Family Violence FTP data transmissions were shut down by GBI and the CJIS Ops team began testing uploads to the NIBRS system for Family Violence. Local agencies began successfully entering Family Violence data directly into NIBRS. 18 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 - The vendor continues to support the integration of the SORT application with the IntegraID application through testing & internal access to SORT. The vendor copied the test environment to production while the GBI application developer fully tested the integration and ensured errors were corrected. The GBI developer has installed scanning software into the SORT application which will provide end users with the ability to scan documentation directly into the SORT application. Watch Systems (Offender Watch) receives bi-weekly updates on GBI's vendor progress and continues to support the vendor's application development. 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 - No accomplishments for this reporting period. 19