Hospital Revenue Cycle Management Path · Mission 23 of 25Master

Payment-timing proxy across payer mix

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.

The Brief

You'll practice

Two-pass aggregationPair grain → payer grainAVG lag