Skip to main content

Table 2 Integration of financial data

From: Integrating historical clinical and financial data for pharmacological research

   Financial Catalog (complete reference) Financial Catalog (codes used)
Type Match Description 1999
(N = 4532)
2004
(N = 5482)
2009
(N = 5969)
1999
(N = 2443)
2004
(N = 2638)
2009
(N = 3226)
Initial Match Match to charge codes in current inpatient EHR 51.04% 55.76% 62.42% 73.41% 82.75% 94.33%
  (rate of mismatch) (0.73%) (0.73%) (0.69%) (1.11%) (1.36%) (1.15%)
Match to Clinical Systems Clinical codes in current inpatient EHR by dispense codes 50.99% 55.67% 62.34% 73.33% 82.68% 94.27%
  Clinical codes in historical inpatient PM by dispense codes 47.26% 44.36% 40.74% 70.28% 75.82% 61.28%
  Clinical codes in outpatient EHR using primary NDC 40.29% 44.55% 50.13% 61.41% 70.43% 80.81%
  Clinical codes in outpatient EHR using related NDCs from Multum 46.89% 51.42% 57.01% 69.79% 79.19% 89.40%
Commercial Vocabularies Multum drug codes 49.14% 53.65% 59.11% 71.52% 80.44% 90.08%
  Multum MMDCs 49.14% 53.65% 59.11% 71.52% 80.44% 90.08%
  MediSpan codes using primary NDCs from inpatient EHR 44.77% 49.53% 55.12% 66.91% 76.19% 86.36%
  MediSpan codes using related NDCs from Multum 48.37% 52.94% 58.44% 71.02% 80.10% 90.02%
RxNorm RxNorm (CD) codes using primary NDCs from Inpatient EHR 46.34% 50.60% 55.59% 67.78% 76.23% 85.12%
  RxNorm (CD) codes using related NDCs from Multum 48.15% 52.57% 57.75% 70.20% 79.23% 88.38%
  RxNorm (CD) codes using Multum MMDCs 49.14% 53.65% 59.11% 71.52% 80.44% 90.08%
  RxNorm (GN) codes using Multum drug codes 49.14% 53.65% 59.11% 71.52% 80.44% 90.08%
  1. Matching and semantic enrichment of financial catalogs from the different time periods yielded the numbers below.