Exhibit 3 - NIMS-PRISM-DELPHI Interface.pdf

This is a system architecture diagram illustrating the dataflow process for integrating Prism and Delphi databases into NIMS/KFDB systems.

The diagram depicts a two-source data integration workflow where Prism DB and Delphi DB serve as the primary data sources. Each database undergoes independent staging and extraction processes through Prism Staging and Delphi Staging components, which generate their respective Prism Extracted Base and Delphi Extracted Base. Both extracted bases funnel into a Prism + Delphi Integrated Base, which consolidates the data from both sources. The integrated base then proceeds through a Prism + Delphi Integrated Delta operation that applies delete operations to generate final delta records. These processed records are subsequently loaded into the target NIMS DB. Archiving Operations are associated with multiple stages throughout the workflow—occurring after each extracted base, following the integrated base, and after the integrated delta—to preserve intermediate and final data states. This architecture demonstrates a systematic approach to data harmonization and integration from multiple legacy systems into a unified NIMS/KFDB environment with built-in archival capabilities at each transformation stage.