Table 1

Linkage performance in claims dataset of 32 991 571 claims encounters

Linkage stepLinkage rule*†Number of flexible fields for matchingTotal linked HospitalisationsUniqueness‡
1Age at admission (±1 year), date of admission (±1 day), date of discharge (±1 day), sex, state, and primary diagnosis, by hospital ID317 85089.6
2Age at admission, date of admission (±1 day), date of discharge, sex, state, and primary diagnosis, by hospital ID110 91798.0
3Age at admission, date of admission, date of discharge (±1 day), sex, state, and primary diagnosis, by hospital ID110 44598.0
4Age at admission (±1 year), date of admission, date of discharge, sex, state, and primary diagnosis, by hospital ID114 00498.0
5Age at admission, date of admission, date of discharge, sex, state, and primary diagnosis, by hospital ID010 07999.1
  • *Unless otherwise specified, linkage rules employed exact matching of linking fields.

  • †Optum Clinformatics only includes year of birth for commercial beneficiaries, thus the linking field age at admission was always allowed to differ by 1 year.

  • ‡Uniqueness = (1−(N multiple hospitalisations in claims+N multiple hospitalisations in registry))/N linked hospitalisations] *100