Source of Truth Delivery/Tracking

[jadudm]

Problem

The Source of Truth (SoT) aims to provide a single point of contact with the FAC's data. We need to bring this in, which involves touching multiple parts of the system. It is a blocker to other work until this lands.

Job Story(s)

To bring this in with confidence, we need:

• Monitoring. We need to make sure that the SoT transition and destination are well-covered by NR dashboards/monitoring.
• Migration. Data needs to move from the SAC table to SoT, and we need confidence that nothing changed in the process.
• API. The API needs to deliver the exact same experience after the migration.
• Testing. We want to know that both the SAC and SoT pathways yield data that is identical during the phased transition approach.
• Cog/Over. We need the cog/over work to connect to the new SoT table.
• Integration w/ the public-facing front-end. Search and Excel generation from the new SoT table.
• Integration with the admin-facing UI. So we can still answer questions.
• Hashing. We want to integrate row-level hashing as well as hashes of PDFs into the SoT tables.

What are we planning to do about it?

All those things.

How will we measure success?

We are going to have automated processes that verify and validate the data at every step of the way. We will have absolute confidence that no data changed or was lost through migration between structures.

Security Considerations

Required per CM-4.

If all mappings are correct, then all access controls (with respect to suppressed data) will continue to "just work." As part of our E2E testing strategy, we will confirm that this is true.