Dry-run Inspection Output — paul 30th.csv

Date: 2026-07-03

This file captures the dry-run inspection that picks one sample row per resolved tier and reports which automated checklist checks pass.

Found 6 sample rows (one per resolved tier)

Row #1 -> ID: 20854327 Principal: 100000 Paid: 0
  - Normalized fields present: id_number, principal
  - Resolved Tier: BIASHARA 3 (id=3) type=sequential min=32000.00 max=100000.00 interest=25.00% duration_periods=8 installment_period=weeks
  - Calculated interest: 25000 Total payable: 125000 Periods: 8
  - Installments: 15,625.00 × 8 (sum==total_payable)
  - Officer provided: 21380625 -> resolved (user id=396)
  - No existing user with national_id=20854327 (will be created during import)
  - Row validation: OK
  - Historical paid present: none

Row #6 -> ID: 22636579 Principal: 30000 Paid: 0
  - Normalized fields present: id_number, principal
  - Resolved Tier: BIASHARA 2 (id=2) type=sequential min=24000.00 max=30000.00 interest=25.00% duration_periods=7 installment_period=weeks
  - Calculated interest: 7500 Total payable: 37500 Periods: 7
  - Installments: 5,357.14 ×6 + 5,357.16 (sum==total_payable)
  - Officer provided: 21380625 -> resolved (user id=396)
  - No existing user with national_id=22636579 (will be created during import)
  - Row validation: OK
  - Historical paid present: none

Row #7 -> ID: 14487035 Principal: 110000 Paid: 0
  - Normalized fields present: id_number, principal
  - Resolved Tier: BIASHARA 4 (id=4) type=sequential min=110000.00 max=150000.00 interest=25.00% duration_periods=10 installment_period=weeks
  - Calculated interest: 27500 Total payable: 137500 Periods: 10
  - Installments: 13,750.00 ×10 (sum==total_payable)
  - Officer provided: 21380625 -> resolved (user id=396)
  - No existing user with national_id=14487035 (will be created during import)
  - Row validation: OK
  - Historical paid present: none

Row #16 -> ID: 20145257 Principal: 60000 Paid: 14000
  - Normalized fields present: id_number, principal
  - Resolved Tier: Monthly (id=12) type=adhoc min=1.00 max=400000.00 interest=20.00% duration_periods=1 installment_period=months
  - Calculated interest: 12000 Total payable: 72000 Periods: 1
  - Installment: 72,000.00 (sum==total_payable)
  - Officer provided: 21380625 -> resolved (user id=396)
  - No existing user with national_id=20145257 (will be created during import)
  - Row validation: OK
  - Historical paid present: 14000 -> will be applied across schedule (oldest-first)

Row #26 -> ID: 28855457 Principal: 20000 Paid: 2000
  - Normalized fields present: id_number, principal
  - Resolved Tier: BIASHARA 1 (id=1) type=sequential min=8000.00 max=20000.00 interest=25.00% duration_periods=5 installment_period=weeks
  - Calculated interest: 5000 Total payable: 25000 Periods: 5
  - Installments: 5,000.00 ×5 (sum==total_payable)
  - Officer provided: 21380625 -> resolved (user id=396)
  - No existing user with national_id=28855457 (will be created during import)
  - Row validation: OK
  - Historical paid present: 2000 -> will be applied across schedule (oldest-first)

Row #57 -> ID:  (missing) Principal: 0 Paid: 0
  - Normalized fields present: (id_number missing), (principal missing)
  - Resolved Tier: NONE
  - Officer provided: (none)
  - No existing user with national_id= (will be created during import)
  - Row validation: ISSUES -> Missing ID Number; Principal <= 0
  - Historical paid present: none

Dry-run inspection complete.
