- Research article
- Open Access
Assessing accuracy of an electronic provincial medication repository
BMC Medical Informatics and Decision Making volume 12, Article number: 42 (2012)
Jurisdictional drug information systems are being implemented in many regions around the world. British Columbia, Canada has had a provincial medication dispensing record, PharmaNet, system since 1995. Little is known about how accurately PharmaNet reflects actual medication usage.
This prospective, multi-centre study compared pharmacist collected Best Possible Medication Histories (BPMH) to PharmaNet profiles to assess accuracy of the PharmaNet profiles for patients receiving a BPMH as part of clinical care. A review panel examined the anonymized BPMHs and discrepancies to estimate clinical significance of discrepancies.
16% of medication profiles were accurate, with 48% of the discrepant profiles considered potentially clinically significant by the clinical review panel. Cardiac medications tended to be more accurate (e.g. ramipril was accurate >90% of the time), while insulin, warfarin, salbutamol and pain relief medications were often inaccurate (80–85% of the time). 1215 sequential BPMHs were collected and reviewed for this study.
The PharmaNet medication repository has a low accuracy and should be used in conjunction with other sources for medication histories for clinical or research purposes. This finding is consistent with other, smaller medication repository accuracy studies in other jurisdictions. Our study highlights specific medications that tend to be lower in accuracy.
Medication errors are a common source of harm or potential harm to patients [1, 2]. Types of medication errors include: medications inadvertently stopped (omission) or restarted (commission), unwanted dosage or frequency changes, and unintended drug interactions [3, 4]. In a review by Bates, prescription medication errors occurred in up to 67% of patients being admitted to hospital with 11–59% of those being clinically important [5, 6]. Poor medication histories are a common source of medication error  and better history taking, communication, and electronic tools to support medication reconciliation, such as community pharmacy databases are means by which such errors can be reduced [2, 8–12]. However, there may be unintended consequences of using Information Communication Technologies [13, 14].
PharmaNet is British Columbia’s (BC) provincial repository of medication dispensings from community pharmacies. Established in 1995, it connects all community pharmacies with the goal “to improve prescription safety and support prescription claim processing” . In 2007, it processed over 47 million prescription dispensings. Authorized clinicians in community pharmacies, hospitals, emergency departments and medical practices can access PharmaNet to view medication dispensing records. Its use is widespread among pharmacists in BC as it is also the mechanism for billing for community dispensings. A survey of BC physicians reported that there was a perceived impact on prescribing practice in 20% of treatment decisions .A study of 55 admission medication histories showed reviewing PharmaNet helped identify drug therapy problems but did not appear to improve medication histories .
PharmaNet has been used to answer research questions about prescription rates and adherence in BC [18, 19]. These studies assume the data in PharmaNet is an accurate reflection of the medications being taken. While a prospective trial on adherence to medications in 43 congestive heart failure patients showed PharmaNet to have “moderate to high” correlation to the comparative medication event monitoring system , a 20 patient study in 2005 compared pharmacist taken Best Possible Medication Histories (BPMHs) to PharmaNet profiles and discovered 60% of patients had inaccurate PharmaNet profiles . PharmaNet was designed to record the dispensing record of medications and may not reflect usage of that medication. Other ambulatory care electronic medical records have been shown to have inaccurate medication lists [22, 23]. Thus, clinicians may turn to regional repositories as a source of truth. They have been promoted to improve medication safety, one of the higher sources of medication error. However, small studies in other jurisdictions have also found low accuracy rates of jurisdictional medication repositories  suggesting that there is a real accuracy issue and that it may not be unique to PharmaNet and thus further work is needed in quantifying the gaps before changes are made to improve accuracy and usability of these systems. There may be unintended consequences if clinicians and researchers assume jurisdictional medication records are accurate and they are not.
To explore this issue, we assessed the accuracy of BC’s PharmaNet application, a well established jurisdictional dispensing repository.
How accurate is a jurisdictional dispensing record, such as PharmaNet, compared to BPMHs for patients who receive BPMH as part of routine care?
What types of discrepancies are most common in a jurisdictional repository?
What medications are most accurate and which are frequently discrepant?
What is the rate of potentially significant discrepancies amongst all discrepancies?
This six-month, multi-centre, prospective study engaged pharmacists to collect sequential patient medication profiles. Joint University of Victoria and Vancouver Island Health Authority ethics approval was received (#J2010-104, 2010). Pharmacists were recruited through information sessions at hospital pharmacy rounds and then trained for the study. Patient eligibility criteria included having clinical need for a BPMH and a recruited pharmacist having access to the PharmaNet profile at the time of the BPMH (terminals were readily available at all sites). All patients who received a BPMH by a recruited pharmacist during the study were included in our analysis.
Pharmacists documented the patient’s BPMH in a Microsoft Access database as part of routine care and were also asked to document any discrepancies discovered between their BPMH and the patient’s PharmaNet profile.a Discrepancy types were predefined: medication missing on PharmaNet profile, medication erroneously flagged as “current” on profile but not being taken, medication missing the “current” flag on PharmaNet Profile (NOTE: the current flag was an additional feature provided in the vendor software used to display PharmaNet profiles), error in dose, error in route, error in frequency, and unclear ingredient or instruction.
Anonymized data was extracted from the pharmacist’s BPMH electronic repository by one of the pharmacists and provided to the researchers electronically as an excel file. Data included: age, gender, current medication list, medication discrepancies, and any comments provided by the pharmacist pertaining to the documented medication discrepancies.
Characteristics of the anonymized profiles and of the individual medication entries were tabulated. Descriptive statistics were used in summarizing the data. For each discrepancy type (from Bates et al.) , the overall number of discrepant medication entries was tabulated. Medications were grouped by Anatomic Therapeutic Class (ATC). Most accurate and most discrepant medication classes were then identified.
A Clinical Study Panel was established with a clinical pharmacist, a pharmacologist, and a family physician to review a random sample of anonymized profiles with discrepancies to estimate the potential risk of a significant Adverse Drug Event (ADE). The Panel reviewed each profile and estimated risk for potential ADE if all medications were prescribed with the noted discrepancies. A Delphi approach was used [24, 25], modified for this study. Specifically, each panel member individually assessed the risk of a potentially significant ADE. A potentially significant ADE was defined as: requiring admission, increasing risk of serious complication, deterioration of clinical condition (e.g. infection, cancer), or worsening chronic illness (e.g. depression) that could impact daily function within a two month period. This definition is consistent with previously described scales .
A random sample of the patient profiles with discrepancies was generated from within Microsoft Access to ensure a margin of error of less than 5% at a 95% Confidence Interval. Where consensus could not be reached, an adjudicator (author, M.P.) reviewed the cases, the rationale for individual scores from the Panel, additional evidence, and made a decision on whether or not the discrepancies were potentially significant.
Profiles were grouped according to the number of medication discrepancies they contained. For each group, the number and rate of potentially significant ADEs was tabulated and the medications most frequently associated with potentially significant ADEs were identified.
21 pharmacists from two hospitals were recruited to the study. Pharmacists performed BPMHs at three locations within the hospitals: Emergency Department, inpatient wards, and pre-admission clinics as part of routine care. Data was collected from January-May 2011. 1215 anonymized patient medication profiles were sequentially collected, containing 7791 medications. The average patient age was 65.8 years, and 51.9% of patients were female. There was an average of 6.4 medications per profile. 1024/1215 profiles (84.3%) were found to contain at least one discrepancy. On average, discrepant profiles contained 3.2 discrepancies. 3256/7791 (41.8%) of medications exhibited discrepancies (Table 1). Of the 1024 total discrepant profiles, 84 were discrepant solely due to a current flag related error. If these errors were removed (as this specific feature was not part of the PharmaNet specification), the overall rate of discrepant profiles would fall from 84.3% to 77.4% (940/1215).
Medication missing from the Profile was the most frequently documented discrepancy type (45%). Medications that could be purchased over the counter accounted for the majority of these medication discrepancies (up to 82%, although many of these would be recommended by prescribers but purchased over the counter). Medication listed on the Profile, but missing the “current” flag was the second most commonly documented discrepancy with insulin, salbutamol and codeine being most frequently discrepant in this manner (26%). Discrepancies in dose or frequency accounted for a further 25.05% of all recorded discrepancies. Table 2 summarizes discrepancies by type. Appendix A provides a detailed list of the five most frequently discrepant medication classes for each discrepancy type.
Table 3 lists the top five most accurate and five most discrepant medication classes that were frequently dispensed (i.e. used by more than 5% of study patients). Ramipril was the most accurate medication in PharmaNet with discrepancies occurring in only 18/207 (8.7%) appearances. Not surprisingly, artificial tears and ibuprofen, acetaminophen and acetylsalicylic acid were among the most discrepant, largely because as over the counter medications they rarely were captured in PharmaNet unless dispensed by a pharmacist. Of prescription medications, insulin frequently exhibited discrepancies (88.6%), with discrepancies of dose and missing current flags being most frequent. Warfarin’s high discrepancy rate (82.5%) was largely due to dose and frequency errors. Codeine & codeine combinations were routinely found to be discrepant (78.4%) largely due to discrepancies in frequency and missing current flags. Opiate agonists of all types had discrepancies in 46.1% of entries (159/345) with discrepancies of frequency and missing current flags being most common.
A collection of medications including vitamins, creams and other supplements (e.g. multivitamins, psyllium and calcium carbonate) were documented more than any other (427 times). Discrepancies were noted in 77.3% of entries, and were largely due to the medications being absent from the profile, or in the case of creams, containing ingredients that were not documented in PharmaNet.
The Panel reviewed 660/1024 anonymized medication profiles with discrepancies (2.28% margin of error @ 95% confidence interval). Consensus was reached on 630 profiles (95.4%). 30 required arbitration. Potentially significant ADEs occurred in 48.2% of reviewed cases (318/660), and more frequently in patients with multiple medications (Table 4). Discrepant medications most commonly implicated in potentially serious cases included: warfarin, salbutamol, insulin, codeine and combinations, clonazepam and prednisone.
This study revealed a high number of discrepancies (84.3%) between the gold standard Best Possible Medication History and medication profiles found in the PharmaNet provincial medication database. Several of these discrepancies were expected, based on the scope of PharmaNet (e.g. absent over the counter, HIV, and hospital dispensed medications); however, many were not. The most common error was missing medications, followed by medications that did not appear as active (or “Current”) on the PharmaNet profile although they were still being used. Almost half of profiles contained discrepancies that were determined to be potentially clinically significant if not corrected (318/660). That is, if the PharmaNet profile was considered accurate and was solely used to direct prescribing, there was a significant risk for medication errors that could lead to ADEs. There are implications based on the findings in this study that relate to use of PharmaNet for clinicians, researchers and the PharmaNet program.
PharmaNet should be used by clinicians in conjunction with other clinical information (such as a patient history), clinical judgment, and follow up to prevent potential ADEs. The risk of significant error increases with the number of medications a patient is taking. Clinicians should focus attention on the common medication classes listed in Table 5 due to the frequency with which they are discrepant or absent from the PharmaNet profile. Common and accurately recorded medications (~90% accuracy in PharmaNet) tended to be cardiovascular drugs (with the exclusion of ASA, 15% accuracy), thyroid medication, and citalopram (Table 3).
For researchers using PharmaNet and potentially other, similar medication repository data, they should be aware of these limitations and not assume that PharmaNet accurately represents medication usage in a given population. Studies have assessed expected completeness of drug profiles, for example in Ontario . However, researchers should also assess accuracy of instructions (if relevant) as these were also frequently inaccurate. This study highlights that many patients are not taking the medications as they were dispensed. This study has shown several medications are often absent from the profile (e.g. over the counter medications), and many are used differently than was recorded at the time of dispensing (e.g. dose and frequency discrepancies in warfarin, insulin, opiate agonists). When employing PharmaNet data to study medication usage, it would be important to consider validating in PharmaNet the accuracy of medications of interest.
For the PharmaNet program, which is undergoing enhancement , this study suggests that there may be value in allowing trained clinicians (e.g. physicians, pharmacists, nurse practitioners) to update patient profiles in order to correct medication data when medication changes are made or discrepancies are found (e.g. while performing a BPMH). A current or regular medication list is not available in the current PharmaNet design, but could be considered for future updates. As many of the discrepancies were medications that appeared expired that were in fact not expired, the concept of clinicians flagging medications as “current” or “ongoing” may be clinically relevant. Enhancements such as these would increase the reliability of PharmaNet and thus improve the efficiency of medication reconciliation during a BPMH.
Findings here were similar to a smaller study performed in Saskatchewan, where 39/50 (78%) of patients had at least one discrepancy on their profile . Also, a study of 493 patients at Veteran Affairs found that their integrated primary care medication record was accurate in only 5.3% of patients , compared to a medication history. This suggests that the findings are not unique to BC and PharmaNet and other regional and jurisdictional repositories may have similar accuracy rates.
This study has added to our knowledge of accuracy of medication repositories by quantifying discrepancies in a large, prospective study of patients whom are typically at risk for medication errors. It has been able to describe, by medication class, some of the more common discrepancies as well as those medications that are accurately described in PharmaNet. Other jurisdictions have or are developing regionalized or national medication records such as in Australia, the US  and the NHS. Where these may rely on dispensing or prescribing information to populate their repositories, similar accuracy issues may exist.
There are several limitations to this study. First, this was not a randomized study of patients in BC; thus, the findings in this study may not be applicable to the entire population of the province. This patient population is likely more complex and on more medications than average. This study was completed within in BC with a single medication repository (PharmaNet). Medication profiles and discrepancy rates may be different in other parts of the world and where other features are incorporated into the tools (e.g. reconciliation). However, other studies suggest that there are significant error rates in other repositories [22, 23]. We did not perform chart reviews when estimating the potential impact of the observed discrepancies. Having a greater understanding of the patients’ medical history would have allowed the clinical study panel to be more precise in their estimations of severity of potential ADEs. This would not have allowed for the anonymous data collection and would have limited the number of cases that were reviewed. It is not typical that providers would rely solely on the PharmaNet profile for prescribing without follow up, and patients would likely be aware if medications missing or their symptoms were not being managed. Thus, the construct for the Panel assessment, while useful in this study, is somewhat theoretical.
This study was designed as a baseline study to assess the current version of PharmaNet. PharmaNet is being updated, with new features to be deployed in the coming years. A repeat of this study once an enhanced PharmaNet is deployed and stabilized would provide evidence to the impact of changes in the design of PharmaNet. Comparative studies could be completed in other medication repositories. Further studies could assess the rates of medication errors and potential ADEs, comparing patients who receive BPMH on admission/discharge to hospital and those who do not (i.e. those who rely more on the PharmaNet profile). Controlled studies should be performed that look at the addition and use of specific features that support medication reconciliation. These could discover what functions are needed (both social and technical) to improve accuracy of the repositories.
This study examined the accuracy of a provincial medication repository by comparing the electronic medication profile to pharmacist collected best possible medication histories in patients who were deemed in need of a BPMH. A significant number of these patients (84%) had at least one discrepancy. 48% (2.28% error; 95% CI) of those patients had discrepancies that were deemed potentially clinically significant. This study suggests that using the electronic medication profile alone is insufficient for completing a medication history and must be reviewed in the context of other elements of history from the patient and other health records. The PharmaNet system was approximately 90% accurate in describing ramipril, hydrochlorothiazide, atorvastatin, levothyroxine sodium, and citalopram. Thus, could be used effectively to help streamline the reconciliation process for those medications. A medication history, supported by PharmaNet should focus on confirming the following medication classes: insulin, warfarin, codeine, salbutamol and ibuprofen/acetaminophen/acetylsalicylic acid, which were discrepant in 80–85% of cases. As expressed in a PharmaNet bulletin, “PharmaNet is not intended as a substitute for professional judgment. Information on PharmaNet is not exhaustive and cannot be relied upon as complete” .
Top five medication discrepancies by discrepancy type, summarized by ATC class*
* The following ATC classes were combined for reporting purposes:
Acetaminophen & Combinations:
ACETAMINOPHEN (PARACETAMOL) and ACETAMINOPHEN, COMB EXCL PSYCHOLEPTICS
Acetylsalicylic Acid & Combinations:
ACETYLSALICYLIC ACID and ACETYLSALICYLIC ACID, COMB EXCL PSYCHOLEPTICS
Codeine & Combinations:
CODEINE and CODEINE, COMBINATIONS EXCL. PSYCHOLEPTICS
Ibuprofen & Combinations:
IBUPROFEN and IBUPROFEN, COMBINATIONS
SALBUTAMOL and SALBUTAMOL AND OTHER DRUGS FOR OBSTRUCTIVE AIRWAY DISEASES
INSULIN (HUMAN), INSULIN ASPART, INSULIN DETEMIR, INSULIN GLARGINE, INSULIN GLULISINE and INSULIN LISPRO
aIn BC pharmacists review PharmaNet as part of a BPMH.
Kohn LT: To Err is Human: Building a Safer Health System. 2000, Washington, National Academy Press
Ammenwerth E, Schnell-Inderst P, Machan C, Siebert U: The effect of electronic prescribing on medication errors and adverse drug events: a systematic review. J Am Med Inform Assoc. 2008, 15: 585-600. 10.1197/jamia.M2667.
Lau HS, Florax C, Porsius AJ, De Boer A: The completeness of medication histories in hospital medical records of patients admitted to general internal medicine wards. Br J Clin Pharmacol. 2000, 49: 597-603.
Cornish PL, Knowles SR, Marchesano R: Unintended medication discrepancies at the time of hospital admission. Arch Intern Med. 2005, 165: 424-10.1001/archinte.165.4.424.
Bates DW, Cullen DJ, Laird N: Incidence of adverse drug events and potential adverse drug events. JAMA. 1995, 274: 29-10.1001/jama.1995.03530010043033.
Bates DW, Leape LL, Cullen DJ: Effect of computerized physician order entry and a team intervention on prevention of serious medication errors. JAMA. 1998, 280: 1311-10.1001/jama.280.15.1311.
Pippins JR, Gandhi TK, Hamann C: Classifying and predicting errors of inpatient medication reconciliation. J Gen Intern Med. 2008, 23: 1414-1422. 10.1007/s11606-008-0687-9.
Tam VC, Knowles SR, Cornish PL, Fine N, Marchesano R, Etchells EE: Frequency, type and clinical importance of medication history errors at admission to hospital: a systematic review. Can Med Assoc J. 2005, 173: 510-10.1503/cmaj.045311.
Kuperman GJ, Bobb A, Payne TH: Medication-related clinical decision support in computerized provider order entry systems: a review. J Am Med Inform Assoc. 2007, 14: 29-40.
Bates D, Gawande A: Improving safety with information technology. N Engl J Med. 2003, 348: 2526-2534. 10.1056/NEJMsa020847.
Bassi J, Lau F, Bardal S: Use of Information Technology in Medication Reconciliation: A Scoping Review (May). Ann Pharmacother. 2010. aph. 1M699v1.
Schnipper JL, Hamann C, Ndumele CD: Effect of an electronic medication reconciliation application and process redesign on potential adverse drug events: a cluster-randomized trial. Arch Intern Med. 2009, 169: 771-10.1001/archinternmed.2009.51.
Ash JS, Mls MB, Coiera E: Some Unintended Consequences of Information Technology in Health Care: The Nature of Patient Care Information System-related Errors. J Am Med Inform Assoc. 2004, 11: 104-112.
Campbell EM, Sittig DF, Ash JS, Guappone KP, Dykstra RH: Types of Unintended Consequences Related to Computerized Provider Order Entry. J Am Med Inform Assoc. 2006, 13: 547-556. 10.1197/jamia.M2042.
PharmaNet. BC Ministry of Health, 2011: Accessed 08-April-2011, 2011, at http://www.health.gov.bc.ca/pharmacare/pharmanet/netindex.html
Kent H: BC's PharmaNet system proving convenient. Can Med Assoc J. 2000, 162: 1192-
Lo A, Shalansky S, Menezes J: Comparison of the completeness of prescription medication histories for hospitalized geriatric patients documented by different health care professionals. Can J Hosp Pharm. 2004, 57: 32-38.
Marra F, Patrick DM, Chong M, Bowie WR: Antibiotic use among children in British Columbia, Canada. J Antimicrob Chemother. 2006, 58: 830-10.1093/jac/dkl275.
Padwal R, Kezouh A, Levine M, Etminan M: Long-term persistence with orlistat and sibutramine in a population-based cohort. Int J Obes. 2007, 31: 1567-1570. 10.1038/sj.ijo.0803631.
Dahri K, Shalansky SJ, Jang L, Jung L, Ignaszewski AP, Clark C: Accuracy of a provincial prescription database for assessing medication adherence in heart failure patients. Ann Pharmacother. 2008, 42: 361-10.1345/aph.1K385.
Kalb K, Shalansky S, Legal M, Khan N, Ma I, Hunte G: Unintended medication discrepancies associated with reliance on prescription databases for medication reconciliation on admission to a general medical ward. Can J Hosp Pharm. 2009, 62: 284-
Kaboli PJ, McClimon BJ, Hoth A, Barnett MJ: Assessing the accuracy of computerized medication histories. Am J Manag Care. 2004, 10: 872-
Nassaralla C, Naessens J, Hunt V: Medication reconciliation in ambulatory care: attempts at improvement. Qual Saf Health Care. 2009, 18: 402-10.1136/qshc.2007.024513.
Okoli C, Pawlowski SD: The Delphi method as a research tool: an example, design considerations and applications. Inf Manag. 2004, 42: 15-29. 10.1016/j.im.2003.11.002.
Linstone HA, Turoff M: The Delphi method: Techniques and applications. 2002, Addison-Wesley, Boston, MA
Bates DW, Boyle DL, Vliet MBV, Schneider J, Leape L: Relationship between medication errors and adverse drug events. J Gen Microbiol. 1995, 10: 199-205.
Paterson JM, Suleiman A, Hux JE, Bell C: How complete are drug history profiles that are based on public drug benefit claims?. Can J Clin Pharmacol. 2008, 15: e108-
Canada Health Infoway, 2008: B.C. upgrades PharmaNet to advance electronic health care. Accessed 2011, at https://http://www.infoway-inforoute.ca/lang-en/about-infoway/news/news-releases/178-bc-upgrades-pharmanet-to-advance-electronic-health-care
Gunter TD, Terry NP: The emergence of national electronic health record architectures in the United States and Australia: models, costs, and questions. J Med Internet Res. 2005, 7: e3-10.2196/jmir.7.1.e3.
PharmaNet Bulletin: 2009, Accessed 24 Aug 2011, 2011, at http://www.health.gov.bc.ca/pharmacare/bulletin/09001bul.pdf
The pre-publication history for this paper can be accessed here:http://www.biomedcentral.com/1472-6947/12/42/prepub
We would like to thank the College of Pharmacists of BC for funding this study. We would like to thank Vancouver Island Health Authority for supporting this study and specifically to the pharmacists who completed the data collection with such enthusiasm. Also, we would like to thank the members of the clinical study panel for their dedication in reviewing so many anonymized profiles.
The authors declare that they have no conflict of interest.
MP was lead for the study, including initial design and primary author of the paper. MB was the research analyst on the study, designing data collection methods, completing data analysis and co-authoring the paper. FL was involved in the design of the study and in editing the paper. SB will a member of the clinical study panel and reviewed findings and edited the paper as a clinical pharmacologist. All authors read and appoved the final manuscript.
About this article
Cite this article
Price, M., Bowen, M., Lau, F. et al. Assessing accuracy of an electronic provincial medication repository. BMC Med Inform Decis Mak 12, 42 (2012). https://doi.org/10.1186/1472-6947-12-42
- Medication Error
- Insulin GLARGINE
- Community Pharmacy
- British Columbia