Two-pass aggregation: collapse fact_remits + fact_claims to one row per (payer, claim) pair with lag and dollars, then aggregate that result up to payer grain. The shape is the canonical RCM 'payment-timing proxy' — without true cash-deposit dates, the claim → remit lag is the closest proxy for how fast each payer turns claims into cash.