Two analysts given the same question often return different numbers. The fix is a written definition before any query:
- Unit: what one item is (a patient, a visit, a stay, a claim).
- Numerator and denominator for a rate; exclusions stated, with the reason.
- Time window: which date decides membership (admission, discharge, service, payment) and the exact bounds.
- Conventions: how a same-day stay counts, whether open stays are in, how ties and missing values are treated.
- Source: which table, which facilities, which encounter types.
A good definition also says what the number cannot tell you, such as an unadjusted rate compared across very different patient groups.