Skip to main content

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%)
  1. Integration of orderables from historical inpatient and current outpatient to the current inpatient EHR system yielded the numbers below.