Developer Programs
Getting Started
Get started working with Jack Henry's developer programs today.
Fintech Integration Network (FIN)
Jack Henry's Integration Program for Fintechs.
Technical Account Manager (TAM)
Get technical integration help from a single point of contact.
Developer Account
Create a developer acccount to access resources that help you integrate with Jack Henry.
Learn
Shared Responsibility
Learn about shared roles and responsibilities of customers and Jack Henry in open banking.
Developer Use Cases
Find a use case that fits your development needs.
Developer Video Gallery
Watch the latest demos, webinars, and more.
Developer Conference
Connect with industry leaders, gain insights from expert speakers, and explore our latest innovations.
Docs
Admin API
Create solutions for an institution's back office support tools.
Authentication Framework
Map customer identities to your existing system IDs.
Consumer API
Access financial data for user accounts, transactions, and more.
Data Hub
Get deeper access to financial institution data.
Enterprise Event System
Respond to events in real-time using this powerful pub/sub-based solution.
jXchange - REST API
Translate business information between Jack Henry and 3rd-party apps using a REST-based API.
jXchange - SOAP API
Translate business information between Jack Henry and 3rd-party apps using a SOAP-based API.
Operational Data Integration (ODI)
Get customized queries for bulk data needs.
Payments
Embed check deposits, ACH, bill pay, cards, and real-time payments.
Plugin Framework
Embed the best of the fintech world directly into your user's dashboard.
SymXchange
Query Symitar core member accounts, post transactions, run PowerOn scripts, and more.
Full List of APIs
Begin working with Jack Henry's public APIs to build financial applications today.

Exception Item Processing

Pipelined Data Sets > Exception Item Processing

Introduction

The goal of this pipeline is to make the Exception Item Processing dataset available in Google BigQuery 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 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 Jack Henry Data Hub 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

The data import process runs every 15 minutes, however the pipeline is extensible to change it to any schedule as needed in the future.

Table Partition Info

The Exception Item Processing dataset contains tables that are partitioned by a date column.

Partition Information for Tables in Dataset ’exception_item_processing_us'

Table NamePartition ColumnPartition Type
accountdetail_fct_cddCreatedDateTimeDAY
achdetail_fct_cddTransactionDateDAY
eipitem_fct_cddCreatedDateTimeDAY
eipitemfeedetail_fct_cddNoneNone
eipitemmutable_fct_cddEffectiveDateDAY
eipitemnote_fct_cddCreatedDateTimeDAY
gldetail_fct_cddCreatedDateTimeDAY
nsfdetail_fct_cddCreatedDateTimeDAY

Topics in this section

Have a Question?
Have a how-to question? Seeing a weird error? Get help on StackOverflow.
Register for the Developer Office Hours where we answer technical Q&A from the audience.
Did this page help you?
Last updated Wed Oct 1 2025