Internal Demo · Version 1

NOT POPULATED WITH ACTUALS YET

Remittance Report Data Suite

Automated Medallion Architecture — BigQuery on GCP

391

Loans Processed

$50.3M

Total UPB

3,519

Validations

38

Tables + Views

9

Procedures

$5-10

Monthly Cost

91.6%

3.1

2.3

Current: 358 ($46.3M) 1-29 DPD: 8 ($913K) 30-59: 12 ($1.5M) 60-89: 4 ($438K) 90+: 9 ($1.1M)

Report Period: 2025-12-31 Bank Partner: ROGUE Sub-Servicer: Midwest Pipeline: 150 min Approved by: [email protected]

Why This Matters

Running Totals

← / → Navigate Space Pause Esc Exit Click tracker nodes to jump

Data Lifecycle Journey

The complete path of a single REMIT_DATA transaction line-item through the PorchPass Remittance Report Data Suite — from Midwest SFTP ingestion to V4 Final Approved.

📦 Rogue Portfolio 📅 December 2025 EOM 🏗️ Medallion Architecture ⏱️ 150 min pipeline

🔎

Tracking Data Point

$847.07 Interest Payment

Table View Procedure Transform Audit/Log