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% |