Skip to content

WebBank WIP

Stakeholders

External Recipient: WebBank

Product Owner: [internal Name/Team]

Technical Owner: Data Engineering

Purpose

Regulatory and compliance reporting delivered to WebBank as part of the credit card and secured deposit banking partnership. These reports cover loan account positions, credit transactions, security deposit accounts, application data, and reconciliation required under the bank agreement.

Data

  • rpt_webbank_application — One row per credit application per report date. Application lifecycle data including status, approved amounts, APR, tier, income, DTI, and borrower details. Corresponds to WB1.
  • rpt_webbank_credit_transaction — One row per credit transaction per report date. Credit card transaction records including principal, interest, fee amounts, and next payment due date. Corresponds to WB7.
  • rpt_webbank_funding — One row per report date. Daily Lithic settlement summary including receivables, chargebacks, interchange fees, and total settlement amount. Corresponds to OR 13.1.
  • rpt_webbank_loan_account_position — One row per credit account per report date. Comprehensive loan account snapshot including balances, payment history, delinquency status, chargeoff details, SCRA/bankruptcy flags, and credit scores. Corresponds to WB2.
  • rpt_webbank_security_deposit_position — One row per security deposit account per report date. Daily snapshot of security deposit balances, accrued interest, account status, and closure reason. Corresponds to OR 13.5.
  • rpt_webbank_security_deposit_reconciliation — One row per report date. Reconciliation of Majority vs WebBank ledger balances with variance for security deposit accounts. Corresponds to OR 13.7.
  • rpt_webbank_security_deposit_transaction — One row per security deposit transaction per report date. Transaction-level detail for security deposit accounts including type, amount, settlement date, and reversal tracking. Corresponds to OR 13.6.

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