Table 3 Integration of clinical data
From: Integrating historical clinical and financial data for pharmacological research
| Â | Â | Â | Â | Medication Catalog (codes used) | ||
|---|---|---|---|---|---|---|
Source | Matching Approach | Matching Attribute | Medication Catalog (reference) | 1999 | 2004 | 2009 |
Historical Inpatient System | Metadata | Charge Codes | 2442/2892 (84.44%) | 1858/2131 (87.19%) | 1916/2155 (88.91%) | 1618/1717 (94.23%) |
| Â | Â | Dispense Codes | 2622/3804 (68.93%) | 1900/2461 (77.20%) | 2037/2487 (81.91%) | 1798/1899 (94.68%) |
| Â | Vocab. | Primary NDC (Multum) | 1402/3126 (44.85%) | 903/2151 (41.98%) | 996/2260 (44.07%) | 818/1765 (46.35%) |
| Â | Â | Related NDCs (Multum) | 2574 (82.34%) | 1849 (85.96%) | 1977 (87.48%) | 1618 (91.67%) |
| Â | Â | Primary NDC (MediSpan) | 1129 (36.12%) | 725 (33.71%) | 844 (37.35%) | 686 (38.87%) |
| Â | Â | Related NDCs (MediSpan) | 1835 (58.70%) | 1234 (57.37%) | 1360 (60.18%) | 1110 (62.89%) |
| Â | Â | Primary NDC (RxNorm) | 1301 (41.62%) | 850 (39.52%) | 937 (41.46%) | 775 (43.91%) |
| Â | Â | Related NDCs (RxNorm) | 2024 (64.75%) | 1397 (64.95%) | 1502 (66.46%) | 1242 (70.37%) |
Outpatient System | Vocab. | Primary NDCs | 2786/39461 (7.06%) | 432/1158 (37.31%) | 1351/4285 (31.53%) | 1734/6990 (24.81%) |
| Â | Â | Related NDCs (Multum) | 7023 (17.80%) | 918 (79.27%) | 2608 (60.86%) | 3397 (48.60%) |
| Â | Â | Related NDCs (MediSpan) | 8140 (20.63%) | 831 (71.76%) | 2354 (54.94%) | 3160 (45.21%) |
| Â | Â | Primary NDC (RxNorm) | 2611 (6.62%) | 423 (36.53%) | 1310 (30.57%) | 1675 (23.96%) |
| Â | Â | Related NDCs (RxNorm) | 3921 (9.94%) | 556 (48.01%) | 1661 (38.76%) | 2147 (30.72%) |