1. The current redaction process needs to be updated to include files in the attachment list for all PIs except Water Supply. When new redactions are processed, existing attachments need to be redacted. We will need a process for future attachments as well as a process to redact documents for Sites/PIs that have already been redacted.
2. While a process exists to unredact records by manually changing data in the history table, this has become too labor intensive due to the number of unredactions we receive. We need an automated process where a file containing unredation requests can be batch process similar to the redaction process.
3. DCA has changed the file format for processing. They removed the " Current Residence ?" column and renamed the "Revoked?" column to "Removed?" We would like the ETL to be updated to handle this new file format.