Skip to content

RDF (Reporting Data Feed) WIP

Stakeholders

External Recipient: Majority (internal — RDF consumers)

Product Owner: [internal Name/Team]

Technical Owner: Data Engineering

Purpose

Consolidated reporting data feeds providing a unified, enriched view of Majority account, card, customer, and transaction data. Used as the authoritative source for internal analytics, audit, and downstream integrations.

Data

  • majority_account_and_card — One row per active or blocked account-card pair. Consolidated account and card status with identifiers, PRN, account type, ledger type, and timestamps.
  • majority_authorized_transaction — One row per authorized (non-settled) ledger transaction. Authorization-stage transactions with amounts, balances, and metadata.
  • majority_customer — One row per KYC-verified active user. Master customer record including personal details, address, contact info, and key timestamps in Mountain Time. Excludes canceled accounts.
  • majority_settled_transaction — One row per settled ledger transaction. Comprehensive settled transaction view joining processor and ledger data, including merchant details, interchange fees, and balance impact.
  • majority_settled_transaction_audit_2025 — One row per settled transaction in calendar year 2025 (Mountain Time). Audit-purpose model unifying Galileo (pre-December 2025) and Majority (December 2025 onward) transaction sources with a source field identifying origin.

Delivery

  • Frequency: Daily
  • Schedule: Airflow DAG
  • Weekend Delivery: [Yes/No]
  • Empty Files: [Yes/No]

Repository

GitHub Repository: majority_rdfs / dt-reporting

Change Log

Date Change Author
2026-03-02 Initial documentation Data Engineering