Prime Data

Product · Data product / dataset · Finance & accounting by Treasury Prime

A queryable warehouse behind your reporting.

Prime Data is a queryable data warehouse for banks and fintechs that provides a single source of truth for reconciliation, reporting, and audit-ready analytics. It aggregates real-time data across ledgers and payment rails to simplify program oversight and compliance monitoring.

Category: Data Warehouse

Delivery formats
Queryable Warehouse
Data Sources
Ledger, FBO, Payments, Checks, ACH, FedNow
Delivery Method
Queryable Warehouse
Audit Coverage
Persons and Businesses
Configuration Tables
ACH, FedNow, Wires, Check Issuing, Check Deposit
  • Queryable data warehouse for reconciliation and analytics
  • Real-time audit trails for person and business changes
  • Direct access to ACH, FedNow, and wire configuration tables
  • Documented columns for audit-ready evidence collection

Overview

Prime Data is a queryable data warehouse designed for banks and fintechs to manage reconciliation, reporting, and analytics from a single source. It aggregates data across ledgers, FBO accounts, payments, and checks, providing a comprehensive view of all program activity. The product solves the problem of fragmented data by offering documented columns and tables that can be queried directly for audit-ready evidence. It includes specialized datasets for audit trails, capturing changes to customer profiles and business entities in real-time. Prime Data enables financial institutions to build custom dashboards and automated alerts to monitor program health and regulatory compliance. The platform also surfaces configuration tables for ACH, FedNow, and wires to allow for granular reporting on program limits and settings.

Data and Analytics

  • Queryable Data Warehouse: The platform provides a queryable data warehouse that serves as a single source of truth for reconciliation and analytics.
  • Configuration Reporting: Users can query configuration tables for ACH, FedNow, wires, and check deposits to build custom reporting.
  • Audit Dataset: The system captures expanded audit coverage of changes to persons and businesses, including those made through fintech partners.
  • Return Tracking: The platform surfaces returned_at columns for checks and ACH transfers to track return timing.
  • Program Limit Monitoring: Banks can query greendot_deposit_config and fednow_config to build reporting around program limits and settings.

Audit and Compliance

  • Real-time Audit Trails: The audit dataset captures changes to customer profiles and business entities in real-time.
  • Partner Activity Capture: The system records when a customer's name is updated through a fintech partner automatically.
  • Data Boundary Controls: Banks see only the persons and businesses their own institution owns within the data boundary.
  • Documented Schema: The dataset includes documented columns and tables that can be queried directly for audit-ready evidence.

Use cases

  • Bank operators query configuration tables to build custom reporting around program limits and settings.
  • Compliance teams access real-time audit trails to track changes made to customer profiles by fintech partners.
  • Fintechs use the returned_at column on check datasets to report on when a check was returned.
  • Financial institutions build automated alerts on audit data to monitor for unusual changes in business entities.

Specifications

Coverage
Ledger, FBO, Payments, Checks, ACH, FedNow, Persons, and Businesses
Delivery formats
Queryable Warehouse
Data Sources
Ledger, FBO, Payments, Checks, ACH, FedNow
Delivery Method
Queryable Warehouse
Audit Coverage
Persons and Businesses
Configuration Tables
ACH, FedNow, Wires, Check Issuing, Check Deposit

How it works

  1. Data Aggregation: The platform aggregates data from ledgers, FBO accounts, and payment rails into a centralized warehouse.
  2. Direct Querying: Users access the warehouse to query documented tables and columns for specific program activity.
  3. Reporting and Monitoring: Financial institutions use the query results to build custom dashboards, automated alerts, and audit reports.

FAQ

What is Prime Data?

Prime Data provides a queryable data warehouse that aggregates data across ledgers, FBO accounts, payments, and checks to serve as a single source of truth.

What does the audit dataset include?

The audit dataset captures changes to persons and businesses, including those made through fintech partners, such as customer name updates.

Can I query program configurations?

Banks and fintechs can query configuration tables for check issuing, check deposits, wires, FedNow, and ACH directly in Prime Data.

Do I need to manually update my audit jobs?

No action is required to enable expanded coverage; changes are recorded in the audit data automatically, though users should plan for one-time step-changes in record counts when updates are applied.

Added by AntSpace from public sources (treasuryprime.com).

Related

More products by Treasury Prime