Georgia Bureau of Investigation November Monthly Report FY2019 Presented to the Board of Public Safety January 10, 2019 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 17 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 26 29 30 29 18 19 19 20 20 2 2 2 2 1 5 5 5 5 4 23 24 10 12 13 32 33 21 23 22 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 17,970 18,790 19,258 19,339 Data Conversion 1 1 1 1 1 Firearms 3,525 3,605 3,680 3,628 3,642 Forensic Biology 6,154 6,434 6,697 6,988 7,136 Impressions 55 52 52 54 56 Latent Prints 4,385 4,429 4,487 4,523 4,526 Medical Examiners 218 129 141 131 117 Miscellaneous Services 0 0 0 0 0 Operations Support 2 1 0 0 5 Toxicology 1,041 1088 974 969 1,039 Trace Evidence 644 681 729 736 759 Total 33,857 34,390 35,551 36,288 36,620 4 GBI Administration Office of Privacy & Compliance/Open Records Open Records Request Archives November 2018 307 2 Total FY2019 2,030 82 Personnel Employee Totals Investigative Division Georgia Crime Information Center Division of Forensic Sciences Administration Total November 2018 State Funded Positions 369 44 314 43 770 Grant Funded Positions 30 78 36 4 148 Total 399 122 350 47 918 Investigative Division Georgia Crime Information Center Division of Forensic Sciences Administration Total Total State Funded Positions Vacant 22 1 29 4 56 State Funded Vacancies Under Active Recruitment 3 1 11 2 17 5 INVESTIGATIVE DIVISION November 2018 Fiscal YTD Total Sworn Employees 286 (filled-includes grant) Total Investigative Hours Expended 23,405.25 143,849.75 Crimes Against Persons, includes Death Investigations Child Abuse Sex Crimes Missing Persons Assault, Kidnapping, Robbery, Terrorist Acts, Fugitive, Human Trafficking, etc. 7,277.75 3,990.50 1,755.25 440.00 152.00 940.00 51,217.75 26,256.50 14,520.75 2,460.00 1,855.00 6,125.50 Property Crimes, including Theft, Burglary, Forgery 2,610.00 13,219.50 Drug Investigations 3,666.00 21,476.00 Meth Lab Investigations 9.00 14.00 Polygraph Examinations 904.00 4,800.00 Background Investigations 101.00 1,191.00 Other Investigations, including Preliminary Investigations 4,560.50 27,471.50 Bomb Disposal Services 834.00 5,201.00 Crime Analysis 429.00 1,187.00 Crime Scene Specialists 3,014.00 18,072.00 All figures above represent Investigative Hours Total Seizures $991,945.40 $18,102,546.58 6 Investigative Hours Expended YTD FY2019 Crime Analysis >1% Bomb Disposal Services 4% Background Investigations 1% Crime Scene Specialists 12% Crimes Against Persons 36% Other Investigations 19% Polygraph Investigations 3% Meth Lab Investigations >1% Drug Investigations 15% Property Crimes 9% 7 8 Medical Examiners (includes all laboratories) November 2018 FY2019 YTD Autopsies Consultations Total ME Cases Managed 212 1,123 118 679 330 1,802 Clayton County Death Certificates 40 211 Percentage of Cases Released in 90 days: 78.5% Medical Examiner Activity, FY2019 Consultations 38% Autopsies 62% Confirmed CODIS Hits for November 2018 State Offender Hits 31 State Forensic Hits 4 National Offender Hits 14 National Forensic Hits 0 Total 49 Samples entered into CODIS for November 2018 1,253 Profiles in CODIS Forensic Casework Profiles Convicted Offender Profiles Missing Person/Unidentified Human Remain Profiles Staff/QC File Total 23,349 336,078 7 523 359,957 9 Laboratory Production Report Turnaround for November 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 1,961 21 47 413 1,086 13 17 Total % Released in Released 45 Days 3,408 58% 362 6% 488 10% 536 77% 1,351 80% 175 7% 134 13% System-wide Totals 3,558 6,454 55% Note: 66% 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 11,110 135 317 1,739 5,430 127 198 Total % Released in Released 45 Days 18,688 59% 1,696 8% 2,867 11% 2,502 70% 6,910 79% 1,242 10% 1,274 16% System-wide Totals 19,056 35,179 54% 10 Crime Lab Reports Processed for November 2018 Department Requested Total Released Chemistry (includes Drug ID) Firearms Forensic Biology Impressions Latent Prints Medical Examiners Operations Support Toxicology Trace Evidence 3,013 144 1,289 2 140 490 14 2,257 84 2,222 148 1,442 0 140 448 10 2,429 63 Total 7,433 6,902 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 16,521 827 8,345 12 898 2,317 52 12,114 445 13,812 635 7,391 9 696 2,462 53 12,297 286 Total 41,531 37,641 11 Georgia Crime Information Center November 2018 NCIC SERVICES CJIS Network Statistics System Uptime: Messages Processed: 100% 69,373,199 CJIS Operations 1. Sex Offender Registry Month FY2019 Database Totals Records Added 103 719 31,704 Note: Number of reported records added in October incorrect; should have been 176. 2. Protection Order Registry Records Added Month 2,077 FY2019 11,814 Database Totals 159,659 3. National Data Exchange (N-DEx) Number of Georgia agencies contributing to N-DEX: 34 (6 direct, 28 LInX) Agencies/Users with N-DEx Inquiry Access Only (no data contributed) Added Removed Total with Inquiry Access Agencies 2 2 16 Users 2 2 21 4. Off-Line Search Requests Type of Request Administrative (Criminal Justice Agency) Open Records Subpoena Media Possible CJIS Security Violations Month 22 0 0 0 5 FY2019 108 4 2 0 18 CJIS Audits GCIC conducted 35 CJIS Audits 12 INFORMATION SERVICES 1. Criminal Fingerprint Transactions Received Month Submissions 37,744 Submissions w/Palms 17,262 Submissions w/Photos 13,699 Transactions processed within 2 hours of receipt: 93% 2. Applicant Fingerprint Transactions Received Month Submissions 37,044 Transactions processed with 24 hours of receipt: 99% 3. Final Disposition Received Local Agency GCIC TOTAL Month 64,036 4,725 68,761 4. RAPID Identification Transactions Submissions AFIS Hits NCIC Hits FBI RISC Hits Month 9,388 69% 43% 8% 5. Non-Criminal Justice Audits, Visits and Trainings Month In Compliance 7 Out of Compliance 21 TOTAL AUDITS 28 Advisement Memos - Agency Visits 15 Attendees 81 Trainings 4 6. Disposition Recovery Project Submitted to Vendor Dispositions Processed Month 3304 2513 FY2019 205,776 92,204 75,168 FY2019 202,866 FY2019 336,074 24,531 360,605 FY2019 52,949 70% 44% 9% FY2019 47 70 117 53 449 34 Project to Date 108,964 107,251 13 PLANS & PROGRAM DEVELOPMENT 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 - There are no accomplishments for this reporting period. CRIMINAL JUSTICE EXCHANGE PROJECT (CJEP) Project Description - CJEP will incorporate the electronic exchanges of information between state and local criminal justice agencies in Georgia and will involve the coordination of multiple agencies and vendor applications. 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. Monthly Update - The core project team continues to discuss the progress of the exchange implementations during daily cadence meetings. A letter of interest was sent out to 31 county clerks regarding their county's participation in the Phase 1 CJEP Enterprise Roll-Out. A demo of the project was presented to the Criminal Case Data Exchange Board and the House Appropriations Public Safety Subcommittee. The e-Filing exchange for Dawson County was implemented in production on 11/6/18. 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 CRM team completed a demo of the ongoing work on CRM and issues were found with the CRM email feature. The team plans to meet with Microsoft for assistance. A web form was created for distribution to local agencies to further assist with gathering updated contact information for upload into the CRM database. CUSTOMER SUPPORT - TRAINING Project Description - The Customer Support Training group provides training in GCIC programs, GCIC applications, GCIC/FBI compliance to criminal justice agencies across the State of Georgia. The group extends the option to receive classroom training or training within an e-Learning environment. Monthly Update - The trainings completed online and within the classrooms for the month are included in the charts. The LMS Staff handled 152 phone calls, 1089 emails and managed LMS user account additions. 14 15 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 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 - The DRIVES vendor continues to work with GBI's message switch vendor for on-time completion of the project. Significant progress has been made concerning the communication exchanges in the test environment and opening necessary ports in production. GBI experienced issues with the AML message switch and its inability to attach simple PDF files. GBI modified the stylesheets but the problem still exists. GBI will work with Nlets to see if they would accept a PDF in NIEM or GJXDM formats. GETS responded to the service ticket that was submitted for upgrading the existing system to 2008 R2 (to accommodate the latest .NET framework and LEMS application versions) and stated that there is not enough time to complete by the November 30th deadline. Thus, GBI is researching the time and effort required for upgrading the server to a more current OS version such as 2016 or 2012 R2. GEORGIA APPLICANT PROCESSING SERVICE (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 - Bi-weekly meetings are held to receive status updates on development milestones. The vendor provided the first deliverable (Manage Agency Users Credentials/Approve Applicant Registration) to GBI for User Acceptance Testing. GBI encountered technical difficulties interacting with the testing website and the vendor is working to resolve the issues. HUMAN RESOURCES (HR) TIMESHEET PROJECT Project Description - Enhancement of the application used by non-sworn units of the GBI for tracking time. Monthly Update - There are no accomplishments for this reporting period. 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. 16 Monthly Update - The vendor provided four additional training videos that were posted to the GCIC SharePoint application for review. Additional NIBRS system modules were purchased by GBI and the vendor will begin development for: Automated Crime Publication, QAR Dashboard, and QAR Review Process. RAPBACK PROJECT Project Description - The Rap Back project will provide the ability to receive ongoing status notifications of criminal history activity reported on individuals holding positions of trust. Georgia's Rap Back System will include the retention of applicant fingerprints, the implementation of an FBI Rap Back Subscription on such prints, and the creation of a validation process for authorized entities to manage such subscriptions. Monthly Update - The project team met to gather high-level Rap Back information. A meeting was also held with the GBI AFIS vendor to gather change requirements. The project will require changes to three of GBI's existing systems. GBI will respectively work with these vendors to make the necessary enhancements for the Rap Back process. 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 SORT interface & IA interoperability has been completed. The testing and development of SORT Entry Service Logging and Authentication & Update Service Enhancement was completed and moved to the SORT production server. The vendor has agreed to conduct failover testing once GBI establishes the proper environment. 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 - There are no accomplishments for this reporting period. 17