Axiom WIP
Stakeholders
External Recipient: Axiom Bank
Product Owner: [internal Name/Team]
Technical Owner: Data Engineering
Purpose
Regulatory and operational reporting delivered daily to Axiom Bank. These reports support customer identification (CIP), account balance reconciliation, transaction records, and fee tracking required under the bank partnership agreement.
Data
- rpt_axiom_ach — One row per ACH transaction per report date. Daily ACH debit/credit transactions enriched with user and account identifiers.
- rpt_axiom_balance — One row per user per report date. Daily snapshot of ledger and available balance for all accounts.
- rpt_axiom_check_deposit — One row per check deposit transaction per report date. Check deposit events with submission, acceptance, and completion dates.
- rpt_axiom_cip — One row per user with CIP changes per report date. Customer Identification Program data for users whose PII or KYC status changed.
- rpt_axiom_fee — One row per monthly subscription fee transaction per report date. Fee and subscription charge records.
- rpt_axiom_overdraft — One row per account with a negative balance per report date. Overdraft exposure tracking including first negative date and days in overdraft.
Delivery
- Frequency: Daily
- Schedule: Airflow DAG
- Weekend Delivery: [Yes/No]
- Empty Files: [Yes/No]
Repository
GitHub Repository: dt-reporting
Change Log
| Date | Change | Author |
|---|---|---|
| 2026-03-02 | Initial documentation | Data Engineering |