Exception Item Processing
Introduction
The goal of this pipeline is to make the Exception Item Processing dataset available in Google Big Query where it can be queried using the SQL interface for business purposes and to drive downstream business processes.
Scenarios
Gain comprehensive insights into your institution’s Exception Item Processing with the EIP dataset. This dataset includes detailed records of exception items, associated fees, and associated notes. Supplementary information from ACH transactions, core Account Details, and NSF occurrences provide a holistic view of the decision making surrounding the exception items. Utilize this dataset to streamline exception handling, monitor transaction anomalies, and enhance compliance reporting.
Pipelines
The Exception Item Processing pipeline utilizes BigQuery External Connections in the Data Broker project, to the Publisher Spanner database in their project. Federated Queries are used with these External Connections to pull data from the Spanner Database into the BigQuery dataset / tables.
Schedule
Initially, the data import process is expected to run nightly, however the pipeline is extensible to change it to any schedule as needed in the future.
