Underpayment detection — contracted vs paid

Multi-CTE pipeline that compares actual paid_amount against the expected contractual amount (billed × payer's expected_pct_of_billed). Underpayment detection is the single highest-ROI RCM activity per analyst-hour invested; an underpayment caught and recovered is dollar-for-dollar margin, no marketing spend or patient acquisition required.