Daniel's Law Auto NJEMS Redactions and Reporting - Work Plan 168

Description

Develop automated method to query NJEMS tables containing name/address data, flag rows that match data of registrants in the DCA database, flag these NJEMS records and ensure this data does not make it out into any DEP Report that gets made available online

Problem Statement

DOIT needs a means to automate the DCA Registry List name/address matching queries against multiple tables in NJEMS and identify/flag matching data rows for redaction from reports or other methods that this data could be posted online

Project Justification

Required by Daniel's Law

Estimated Transactions

None

Target Rollout Date

30 June 2023

Target Rollout Date Reason

Daniel's Law has mandated compliance dates

Attachments

Activity

james bridgewater 17 October 2023, 15:09

UAT ended 10/16/2023. >20,000 DCA records loaded (NJEMSDev). 350 exact matches found and auto redacted, 3,000 partial matches being reviewed by Matt C.. Production deployment Package being put together by CGI, deploy to JEMR first.

james bridgewater 24 August 2023, 14:27

Covered under CGI Work Plan 168

james bridgewater 3 May 2023, 14:55

Working with CACI to set initial meeting to discuss needs and possible solutions/integrations