Skip to main content
  • Research article
  • Open access
  • Published:

Linkage of primary care prescribing records and pharmacy dispensing Records in the Salford Lung Study: application in asthma

Abstract

Background

Records of medication prescriptions can be used in conjunction with pharmacy dispensing records to investigate the incidence of adherence, which is defined as observing the treatment plans agreed between a patient and their clinician. Using prescribing records alone fails to identify primary non-adherence; medications not being collected from the dispensary. Using dispensing records alone means that cases of conditions that resolve and/or treatments that are discontinued will be unaccounted for. While using a linked prescribing and dispensing dataset to measure medication non-adherence is optimal, this linkage is not routinely conducted. Furthermore, without a unique common event identifier, linkage between these two datasets is not straightforward.

Methods

We undertook a secondary analysis of the Salford Lung Study dataset. A novel probabilistic record linkage methodology was developed matching asthma medication pharmacy dispensing records and primary care prescribing records, using semantic (meaning) and syntactic (structure) harmonization, domain knowledge integration, and natural language feature extraction. Cox survival analysis was conducted to assess factors associated with the time to medication dispensing after the prescription was written. Finally, we used a simplified record linkage algorithm in which only identical records were matched, for a naïve benchmarking to compare against the results of our proposed methodology.

Results

We matched 83% of pharmacy dispensing records to primary care prescribing records. Missing data were prevalent in the dispensing records which were not matched – approximately 60% for both medication strength and quantity. A naïve benchmarking approach, requiring perfect matching, identified one-quarter as many matching prescribing records as our methodology. Factors associated with delay (or failure) to collect the prescribed medication from a pharmacy included season, quantity of medication prescribed, previous dispensing history and class of medication. Our findings indicate that over 30% of prescriptions issued were not collected from a dispensary (primary non-adherence).

Conclusions

We have developed a probabilistic record linkage methodology matching a large percentage of pharmacy dispensing records with primary care prescribing records for asthma medications. This will allow researchers to link datasets in order to extract information about asthma medication non-adherence.

Peer Review reports

Background

Medication data can be used in research to assess changes in medication prescribing trends over time [1], for pharmacovigilance studies, and to investigate patients not adhering to the treatment plans agreed upon with their General Practitioner (GP) [2,3,4]. Investigating medication data enables researchers to estimate the frequency, burden, and costs of non-adherence [5,6,7], identify the most at-risk to suboptimal clinical outcomes, evaluate the effectiveness of adherence interventions [8,9,10], and appropriately adjust for the impact of non-adherence on safety and efficacy data in clinical trials [11, 12].

In studies of linked (or integrated) prescribing and dispensing records, failure to collect the initial asthma prescription (primary non-adherence) has reported incidence between 12 and 45% [13,14,15,16,17], with high variance due to differences in the right censoring point. Studies across multiple chronic conditions reported a pooled general primary non-adherence rate of 9–17% [18,19,20].

In England, prescribing and dispensing of medications are recorded by separate processes. After a medication prescription is issued to a patient by a GP or another authorized prescriber [21], the prescription is taken to a dispensing outlet such as a community pharmacy [22]. When the prepared medicine is released to the patient, details relating to payment for medications are recorded and managed by the NHS Business Services Authority (NHSBSA). While analysis of medication adherence can be estimated using either the GP’s prescribing records or the NHSBSA medication dispensing records alone, there are limitations to each approach. Without linking the records together, it is not possible to ascertain whether a prescribed medication was collected, or to rule out other reasons for irregularities in collection such as treatment conclusion or sanctioned treatment interruptions [1, 23, 24].

Since 2015, NHSBSA dispensing data have included a patient identifier (NHS number) [25]; this is, however, not routinely linked to primary care prescribing records held by Public Health England (PHE). The NHSBSA and PHE records also do not have a common unique prescribing event identifier. Therefore, even with a data sharing agreement in place, matching records (one-to-one) using common identifiers (known as deterministic linkage) is currently impossible.

Therefore, it is necessary to link records probabilistically; estimating the likelihood that two records will match given the data they contain. Neither pharmacy nor primary care records are written with future linkage in mind, and as such they often require substantial pre-processing. The quality of the data linkage can be improved by integrating domain knowledge to identify non-matching but equivalent values, for example converting between units of dose strength.

The distinction between what should be considered deterministic or probabilistic is often disputed, as even complex probabilistic linkage processes can be broken down into their rule-based components and both linkage types can allow for imperfect (or fuzzy) matching on certain features [26], such as the dates of events in our case (which we would not expect to match all the time). The nature of administrative data source linkage, such as with Electronic Health Records, necessitates the use of fuzzy matching to overcome such prevalent qualities as missing data, free-text values, non-standardised units, and generic medication substitutions (resulting in different medication names). There are cases in which deterministic linkage will not only reduce the overall accuracy of the linkage, but may also introduce bias [27, 28].

Padmanabhan et al. have previously demonstrated the methodology used for linking UK health datasets when the unique patient identifier (NHS number) contained missing and erroneous values prohibiting deterministic linkage, including the creation of a ranking system for candidate links based on the matching information between them [29].

Methods

Aim

The linkage of prescribing and dispensing records can enable the extraction of information about adherence to prescribed medications, including the identification of uncollected medications. In this study, we sought to develop a novel methodology linking primary care prescribing and dispensing records without a common identifier, using heuristics and features extracted from free-text fields.

The GUILD [30] and RECORD [31] guidelines for data linkage reporting were applied where necessary information was not reported elsewhere [32,33,34]).

Data source

The Salford Lung Study (SLS) was a prospective, 12-month, open-label, parallel group, randomised controlled trial (RCT) conducted in 74 general practice clinics in Salford and South Manchester, UK [35]. A total of 4233 participants with asthma were recruited in primary care settings by the healthcare professionals who provided their normal everyday care, and randomly allocated to either initiate a combination fluticasone furoate/vilanterol treatment or to continue their maintenance therapy (“usual care”).

Participants were at least 18 years old at the time of recruitment, with a clinical diagnosis of symptomatic asthma made by a GP and had to be taking regular maintenance inhaler therapy with Inhaled CorticoSteroids (ICS) either alone or in combination with a Long-Acting β2-Agonist (LABA). The main exclusion criteria were a recent history of life-threatening asthma, a history of Chronic Obstructive Pulmonary Disease (COPD), or concomitant life-threatening disease [34, 36]. Many of the participants in the study cohort would have been excluded from conventional RCTs due to their multi-morbidities [33, 36], which increased the representativeness of the study cohort to the target population.

The trial was registered in the National Institute of Health’s database of clinical studies [32] (clinicaltrials.gov identifier NCT01706198). The study was conducted in accordance with the standards dictated by the National Research Ethics Service Committee North West (reference 12/NW/0455), as well as the International Conference on Harmonisation, Good Clinical Practice, all applicable data protection requirements and the ethical principles outlined in the Declaration of Helsinki 2013.

Data format

The dispensing data contained 225,235 records, for 4197 unique participants, between 27th November 2012 and 9th December 2016. The prescribing dataset contained 339,792 records for 4233 unique participants between 22nd November 2012 and 17th January 2017, however records outside of the dispensing data period were excluded.

Both datasets contained a (common) subject ID, free text drug description, date (prescription or dispensing, respectively), the dose strength, dose instructions, and a numeric quantity of medication prescribed (e.g. “200 dose inhaler”). Between the two datasets, there were 8291 unique (free text) drug descriptions.

Inclusion and exclusion criteria

All unique drug descriptions, in either the prescribing or dispensing records, were searched for the presence of one or more of the keywords listed in Appendix A. From here, the drug classes were assigned: Short-Acting β2-Agonist (SABA), Long-Acting Muscarinic receptor Antagonist (LAMA), LABA, theophylline, ICS, LeukoTriene Receptor Antagonist (LTRA), cromoglicate, steroid, or immuno-suppressant. If only one candidate class was identified, the drug class was coded according to the drug class keyword. A drug was coded as an ICS and LABA combination medication (ICS + LABA) if active ingredients of both ICS and LABA varieties were flagged, a SABA if a medicine containing both SABA and LAMA ingredients were flagged. Medications that did not match any of the keywords in Appendix A were considered to be non-asthma medications and were removed. A medication class keyword was generated, containing a composite of the active ingredients, to be used in the matching algorithm.

Furthermore, drug descriptions were searched for any of the exclusion keywords and brand names listed in Appendix B, which signalled that a medication was being used for an indication other than asthma (such as nasal spray corticosteroids for rhinitis).

Variable recoding

Several free text variables were recoded using custom look-up tables, to allow semantically identical, but syntactically variant (such as “128mcg” vs “128 micrograms”, and other type abbreviations and variations) records to be aligned. Of note, we modified the recorded medication quantity to estimate the number of doses (puffs), rather than the number of units (inhalers). This variable integrates domain knowledge of the number of doses per unit for each medication strength combination (high potency medications are often dispensed at lower volumes), calculated using the most common volumes in the data. In order to avoid candidate links being ruled out as potential matches on the basis of our quantity variable modifications, we included a so called ‘alias’ quantity [27], to be considered if the ‘primary’ quantity values did not match. The process is summarized in Appendix C.

Identification of duplicates

Duplicates of prescribing and dispensing records are common due to errors in data entry [37,38,39]. Duplicate records in the data would have a strong adverse effect on the matching algorithm, as it would be forced to incorrectly match distinct records in one set to duplicates in the other. We identified duplicate records by searching for commonalities within the same person, date (dispensing or prescribing respectively), medication brand name, and medication (active ingredient) keyword, in addition to the following combinations of (modified) variables:

  • Matched on quantity and dose

  • Matched on dose, and the quantity was not matched due to data missingness

  • Matched on quantity, and the dose was not matched due to data missingness.

Data linkage

The datasets of prescribing and dispensing records were merged such that a record (a candidate link) was generated for each eligible (common patient identifier and medication class) pair of records for matching. We note that the medication class keyword, composed of the active ingredients identified, was used in the place of a brand name such that generic substitutions would be identified as appropriate candidates for matching records. Pairs of records were eligible if the suggested dispensing date occurred after the prescription was written, but no more than 6 months after the prescription was written, at which point the prescription became invalid.

Probabilistic linkage, which aims to match records based on multiple non-unique features, utilizes weights to determine the strength of a link. These weights are numerical values representing the similarity of two records, derived using domain knowledge about the prevalence of dissimilarities between features in true matches.

In this linkage, a rule-based approach, based on a simplified posterior multivariate distribution of clerically reviewed data and previous literature, was used to weight candidate links for estimated likelihood of being a true match. Candidate links could then be ranked, and those with a linkage weight (calculation detailed in Appendix D) less than 70% excluded (combinations of features by match status that resulted in inclusion are listed, along with their sum weights, in Appendix E).

Generic substitution for brand named medications are common (when permitted by the prescriber, known as open generic prescribing) in asthma controller medications [15, 40, 41]. As such, brand name was assigned a lower maximum feature weight (20%) than the dose strength (35%, which will vary only when one record has a missing value, or in the rare case that a generic substitution requires a slightly different dosage) and quantity (35%, varying when a quantity was both uncommon and missing, and was imputed with a more prevalent but incorrect value). The final 10% weight corresponded to the time between the prescribing and dispensing events. Prescriptions issued less than 1 month prior to the dispensing were awarded the additional 10% weight, in line with the findings by Williams et al. that 95% of asthma prescriptions are filled within this time window [14], however a higher weight was not implemented due to the use of the time between weights in the final match selection process. That is, each set of dispensing records for each person-medication combination were looped through from the last to first through, as follows:

  1. 1.

    Identified the candidate in which the dispensing record occurs most recently after the prescription was written (record with highest match weight chosen if two candidate links on the same day were identified); this is a match between records,

  2. 2.

    Removed all other candidate links which contain the dispensing record or the prescribing records relating to this match,

  3. 3.

    Progressed to the previous dispensing for this person-medication.

This process, illustrated in Fig. 1, is also described in more detail in Appendix F.

Fig. 1
figure 1

Diagram representing the data linkage algorithm

The most recent prescribing record before the dispensing was prioritised over more distant records with a higher match weight, as we considered it more likely that prescription records for the same person within such a short time window were for the same medication, recorded differently, rather than a new treatment.

Prescriptions that did not match any dispensing record were marked as unclaimed. We also noted dispensing records that were not matched (implying no corresponding prescription event) to assess linkage quality.

Statistical analysis plan

As per the recommendations by Harron et al., the characteristics of the matched and unmatched records were compared in order to identify potential sources of bias [42]. Specifically, the missingness for each variable used in the matching was compared between matched and non-matched records, factors associated with prescription collection were assessed (statistical methodology described below), and the sensitivity of the algorithm parameters was tested by altering certain thresholds and requirements and comparing the proportion of records that were matched.

As well as estimating the incidence of primary non-adherence, we used our linked dataset to analyse factors effecting the collection of prescribed medications. By comparing our results to others using integrated health records (those that are linked, or linkable, inherently) we are able to demonstrate the validity of our linked dataset to answer epidemiological questions about high-risk individuals.

We used multivariate Cox survival analysis to assess the statistical relationship between the season of the prescription, the drug class of the prescription, the number of previously unclaimed prescriptions, and the strength and quantity of the medication prescribed, on the time between the prescription being written and dispensed. Survival analysis calculates the rates (hazard rates) of medications being collected at any specific time since the prescription was written. Comparing the ratios (hazard ratios) between two levels of a factor (such as male and female) allowed us to assess the difference that this factor made when everything else (age, medication, etc.) remained constant. Although a prescription could be dispensed up to 6 months after it was written, it is uncommon that their collection will be delayed for more than 7 days [14, 15]. Furthermore, a delay of beyond 1 month would likely result in a gap in medication availability and thus be considered poor adherence. As such, we wanted to find a threshold at which prescriptions could be recorded as ‘hitherto uncollected’, known as being right censored. We set this threshold at the minimum number of weeks such that fewer than 2% of subsequently collected prescriptions would be right censored.

Naïve benchmarking

We compared our results to those produced from a simplified algorithm in which records were pseudo-deterministically matched, such that candidate links required perfect matching on medication name, dose, quantity, and dose directions, without any variable recoding or removal of duplicate records. The date variable, however, still allowed flexible matching as medications can be dispensed up to 6 months following prescription.

The same iterative linkage procedure was used in the algorithm detailed previously, without the inclusion of the linkage weights as a tiebreaker between candidate links on the same day.

As the dose directions were long, free-text strings, written separately by both the prescribing and dispensing agents, we also repeated the benchmarking analysis, with imperfect matching on the dose directions permitted.

Links identified by this process should not be considered the ground truth, or the gold standard, as the algorithm will default to match records which are more distanced chronologically but similar syntactically, rather than semantically similar and chronologically closer record matches which are more likely to be estimated by the full algorithm. As such, the matches identified between approaches will not be directly compared.

Reporting

This study has been reported in accordance with the GUILD and RECORD reporting guidelines [30, 31].

Results

Data cleaning

Of the 8291 unique drug descriptions, 928 (11%) were identified as relating to asthma medications (list of keywords used in string search provided in Appendix A). Searching the drug descriptions for the set of exclusion keywords led to the removal of 71 (8%) further records (list and frequency of keywords in Appendix B). Removing the excluded medications left 88,916 prescribing records and 64,471 dispensing records (Fig. 2). Finally, duplicates were removed (12,236 prescribing records and 406 dispensing records), leaving 76,680 prescribing records (86%) and 64,065 dispensing records (99%).

Fig. 2
figure 2

Data Linkage Flow Diagram

Matching

The full join on the prescribing and dispensing records generated 265,442 candidate links for linkage weight assessment (Appendix D). Sixty two thousand and seven hundred eight-three candidate links were removed (23.7%) as they did not fulfil the minimum linkage weight threshold, leaving 202,659 candidates to be sorted through the matching algorithm. After the algorithm was applied, 53,289 candidate links were confirmed as matches: 69.5% of prescribing records (n = 76,680), and 83.2% of dispensing records (n = 64,065).

As shown in Fig. 1: Diagram representing the data linkage algorithm.

Figure 3, there was a substantial discrepancy between the time between the prescribing and dispensing for the candidate links and the matches, with 99% of matches having less than one month between prescribing and dispensing (compared to 33% of candidate links).

Fig. 3
figure 3

Distributions of linkage weight points per variable, for candidates and final matches

The median percentage of prescriptions claimed by an individual was 79%, with an interquartile range of 50–92% (range 0–100%). 23% of individuals claimed fewer than 50% of their prescriptions.

Quality assurance

We inspected 23,391 prescribing records (31%) and 10,776 dispensing records (17%) for which a match could not be made (including those with candidate links which were not matched by the matching algorithm). In the non-matched prescriptions, 9% (n = 2109/23,391) had missing medication dosage, and < 1% (n = 87/23,391) had missing data on quantity (both missing in less than < 0.1%). In the non-matched dispensing records, however, it was 62% (n = 6639/10,776) and 58% (n = 6222/10,776), respectively (both missing in 55%).

Survival analysis

31% of prescriptions (n = 23,391) were labelled as unclaimed. In claimed prescriptions (n = 53,289), the median time between the prescription being written and the medication being dispensed was 1 day (upper-lower inter-quartiles = 0–3 days), and fewer than 5% of people took longer than 1 week to claim (0.9% longer than 30 days). Considering uncollected prescriptions to be right-censored at 6-months, at which point the prescription expires, the median time to collection was 3 days (upper-lower inter-quartiles = 0–178 days; Fig. 4).

Fig. 4
figure 4

Kaplan-Meier of the time to collecting prescriptions, censored at three weeks

The multivariate Cox survival analysis model included 76,584 prescription records – having removed 96 with missing quantity. The prescriptions were claimed in 52,186 of these records, with less than 2% being collected beyond 3 weeks after the prescription was issued. As such, 21 days was set as our right censoring point. We found a lower hazard of claiming medications in summer (June–August: 3% decrease, 95% CI = 1–6%) compared to spring (Table 1), indicating that they were claimed slower in summer than in spring. There was no statistically significant difference in the claiming of medications between spring and winter or spring and autumn. Higher quantities (by number of doses) of prescribed medications were associated with modest reduction in hazard of collecting the medication (p < 0.001). Finally, proportions of previous prescriptions that were unclaimed (categorized into tertiles) were a strong predictor – with medium vs low tertiles hazard ratio of 0.57, and high vs low of 0.20 (p < 0.001). Rescue medication (SABA and steroids) had the highest hazard rates (1.433 and 1.839, respectively). Of the controller medications, those associated with higher asthma severity (according to the British Thoracic Society (BTS) treatment steps [43]), such as LAMA and LTRA medicines, had higher hazards than lower severity treatments such as ICS and combination ICS + LABA medications.

Table 1 Cox Proportional hazards model risk factors associated with time to collecting a prescribed medication

Naïve benchmarking

There were 88,916 prescribing records and 64,471 dispensing records identified relating to an asthma medication (without the removal of duplicates). Of these, 584 (0.7% of prescribing records and 0.9% of dispensing records) were pseudo-deterministically linked. Even when imperfect matching on dose-directions was permitted, only 15.4% of prescribing records and 21.2% of dispensing records could be matched (n = 13,698 matches).

Discussion

We have developed a novel methodology matching prescribing and dispensing electronic health records and demonstrated this led to matching 70% of asthma prescribing and 83% of dispensing records. Fewer than 5% of prescriptions were eventually claimed after one week of the issuing of the prescription. 30% of prescriptions were labelled as uncollected.

The key strength of this study is the variety of integrated mechanisms – incorporating domain knowledge relating to asthma medications (such as semantic harmonization from brand name to active ingredients) and rule-based natural language feature extraction and harmonization (such as converting a free-text dose to a numeric value with common units).

Using a naïve benchmarking algorithm that required perfect matching between prescribing and dispensing records (except for the date variable; pseudo-deterministic linkage), we were able to demonstrate the superiority of our proposed methodology. In this benchmark linkage, only 15% of the prescribing records and 21% of dispensing records were matched, even when imperfect matching on free-text dose directions was permitted. This was a result of syntactically variant (different formats and value units) but semantically matching data between the two sources of information.

We identified a set of records for dispensed medications (17%) for which no matching prescribing record was identified. In the non-matched dispensing records, 62% had missing medication strength, and 58% had missing quantity. In its current state, the algorithm will not match records with high amounts of missing data even if no other match is identified.

In Appendix D, we see that 3% of matches had distinct and non-missing medication brand names. This highlights that potentially brand substitutions occurring at the pharmacy need to be accounted for in the matching [44]. The variable with the biggest change in distribution between the candidate links and the final matches was whether the medication was dispensed within one month of prescribing – 33% of candidates and 99% of matches (see Fig. 1: Diagram representing the data linkage algorithm.

Figure 3). In fact, we found that only 1% of prescriptions were claimed more than a month after the prescription was written.

Our finding that 30% of prescriptions were labelled as uncollected, known as primary non-adherence, was a substantially higher proportion than the 8–20% found in previous asthma studies in US administrative health data studies [13,14,15, 41, 45]. One might assume that subsidised prescriptions, as we have in England, would result in higher primary adherence rates, as a barrier to adherence has been removed. On the contrary, a recent study in Canada, where prescriptions are subsidised and thus considerably more affordable than in the USA, found that the fill rate for new asthma prescriptions was only 69% in adults [16]. As such, future work must be conducted in order to find cost-effective interventions to reduce primary non-adherence in asthma.

As there is no true linkage event identifier (person-prescription), it is not possible to compare our identified matches to some ground truth, a common limitation highlighted in the aforementioned linkage quality assessment guidelines by Harron et al. [42]. As the benchmarking analysis allowed prescribing and dispensing date variables to differ, hence pseudo-deterministic, even this does not identify ‘perfect matches’ between records. If the ground truth was known, it would be possible to compare directly the matches estimated from the benchmark and pseudo-deterministic analyses and evaluate how well our algorithm improves the matching quality. While the ground truth may not be possible to determine in challenging real-world data, even with manual review, one could also perturb data in which the ground truth is known to closer approximate the real use case, and evaluate the algorithm’s accuracy. This would be a very interesting direction that future research work could investigate further, and would provide further insights in terms of confidence in the accuracy of the data linkage process.

In lieu of this, we conducted quality assurance comparing features of the matched and unmatched records, as recommended by Harron et al.’s guidelines [42]. We observed that prescriptions (for which the status of being non-matched might imply either medication non-initiation, or not being correctly matched using the proposed algorithm) had missed medication strength in fewer than 10% of records, and missing quantity in fewer than 1%. In the non-matched dispensing records (which should occur only in rare emergency prescriptions and indicate shortcomings in matching prescription and dispensing records), 62% had missing strength and 58% had missing quantity. This indicates that one of the biggest barriers to successful record linkage was poor medication dispensing record quality.

The frequency of non-matched dispensing records was our best indicator as to the quality of our linkage, however we found that 95% of these records that were missing quantity (58%) were also missing dose-strength. As such, reducing the weight threshold from 70 to 50%, would have had a substantial effect on the pool of candidate links allowed to be used in the matching algorithm. With so much missing data, however, the veracity of these matches would be hard to ascertain.

The strong influence of data quality on the success of the linkage algorithm makes it difficult to benchmark our results against other record linkage algorithms or even treatment initiation studies in populations with linkage conducted routinely. Comparisons to algorithms derived in other medication indications, such as in acute conditions such as tuberculosis, or in other chronic illnesses such as mental health conditions, are even harder. Furthermore, not all countries have a unique patient identifier, resulting in the use of demographic data such as gender, year of birth, and postcode, to identify entries belonging to the same person [46]. Regardless, we find other studies have reported similar levels of inconsistency between features in matched records, such as brand name, dose strength, and time between prescribing and dispensing [44, 47]. We also observed the substantial increase in matches when variables were cleaned, and recoded, and our probabilistic methodology was used in the place of a simple pseudo-deterministic matching.

As with all probabilistic matching approaches, and particularly in cases such as these with considerable number of missing entries and un-structured fields, it is possible that matches even with high assigned weights are incorrect. Indeed, it is not likely that the matches established in the benchmarking analysis are of higher accuracy than those in the primary analysis, and they cannot be directly compared. In future work, this algorithm should be tested in simulated data where the underlying ground truth is known for further validation, in order to better determine the accuracy of the linkage. There is potential that the design of the study on which this secondary analysis was conducted (a pragmatic randomised controlled trial) may have influenced the linkage in some way. Validating the proposed linkage algorithm in further additional randomised clinical trials would be needed to establish the generalizability of our findings.

In addition to testing in other datasets, in which the true links are known and can be compared to the estimated matches, further development of this study would be to test the sensitivity of the model to certain parameters such as the weights for each component, the degree of influence from the dates, and the minimum weight threshold. We remark that these intrinsic parameters can be seen as degrees of freedom that enable data modellers to explore different levels of certainty for record matching. At a higher level, these can be thought of as the equivalent free parameters which need to be explored and optimised for a given dataset: for example, in Support Vector Machines (SVM) one needs to optimise the penalty hyper-parameter (and depending on configuration additional hyper-parameters too). Consideration must also be taken to determine the acceptable limits of the false negative and positive rates, and the relative importance of the two, in specific settings. For example, in adherence studies, one might conservatively prefer to underestimate adherence than to overestimate it, and thus prioritise lowering the false positive rate.

Additionally, accounting for how much medication supply an individual currently has, or when their most recent previous prescription was issued, would allow the date component of the algorithm to correspond more meaningfully to the patient’s history. As previously discussed, matching may also be improved by the addition of an extension allowing candidate pairs for which one record had high amounts of missing data and no match was identified to be re-considered.

Conclusions

The optimal dataset for measurement of medication non-adherence includes both prescribing records and dispensing records, such that prescriptions that are not collected from the dispensing agent and resolved/discontinued treatment regimens are accounted for. These are however seldom available. We therefore developed a novel methodology that matched 83% of pharmacy dispensing records to primary care prescribing records. In the 17% of dispensing records for which a match could not be identified, missing information was prevalent; particularly regarding the strength of the medication, and the quantity dispensed. A naïve benchmarking, requiring perfect matching, identified prescribing records for only 21% of the dispensing records. The presented methodology towards probabilistic record linkage enables preliminary assessment of whether patients are collecting their prescribed asthma medications and can improve clinicians’ understanding of patient adherence. Further external validation of these promising findings on additional datasets is needed given the uncertainty around linkage quality.

Availability of data and materials

The datasets analysed during the current study are not publicly available but are available by application to, and approval from, the Salford Lung Study scientific committee. Code scripts, in the R language, for all components of the data cleaning, linkage, and subsequent analysis will be made available in the open source GitHub website (https://github.com/hollytibble/Salford-Lung-Study_Adherence-Linkage).

Abbreviations

BTS:

British Thoracic Society

COPD:

Chronic Obstructive Pulmonary Disease

GP:

General Practitioner

ICS:

Inhaled Cortico-Steroids

LABA:

Long-Acting Β2-Agonist

LAMA:

Long-Acting Muscarinic Receptor Antagonist

LTRA:

Leukotriene Receptor Antagonist

NHSBSA:

National Health Service Business Services Authority

PHE:

Public Health England

RCT:

Randomised Controlled Trial

SABA:

Short-Acting Β2-2-Agonist

SLS:

Salford Lung Study

References

  1. John D, Michael W, Twigg J. Community pharmacy: an untapped patient data resource. Integr Pharm Res Pract. 2016;5:19–25 Available from: http://youtu.be/IPZjCov6Obs [cited 2019 24 Jul].

    Google Scholar 

  2. Karter AJ, Parker MM, Moffet HH, Ahmed AT, Schmittdiel JA, Selby J V. New Prescription Medication Gaps: A Comprehensive Measure of Adherence to New Prescriptions. Health Serv Res. 2009;44(5):1640–1661. Available from: https://0-www-ncbi-nlm-nih-gov.brum.beds.ac.uk/pmc/articles/PMC2754552/pdf/hesr0044-1640.pdf[cited 2018 19 Dec].

  3. Andrade SE, Kahler KH, Frech F, Chan KA. Methods for evaluation of medication adherence and persistence using automated databases. Pharmacoepidemiol Drug Saf. 2006;15(8):565–74.

    Article  Google Scholar 

  4. Hess LM, Raebel MA, Conner DA, Malone DC. Measurement of Adherence in Pharmacy Administrative Databases: A Proposal for Standard Definitions and Preferred Measures. Ann Pharmacother. 2006;40:1280–8 Available from: www.theannals.com [cited 2018 1 Jul].

    Article  Google Scholar 

  5. Cutler RL, Fernandez-Llimos F, Frommer M, Benrimoj C, Garcia-Cardenas V. Economic impact of medication non- adherence by disease groups: a systematic review. BMJ Open. 2018;8:e016982 Available from: http:// [cited 2018 23 Apr].

    Article  Google Scholar 

  6. Patel AR, Campbell JR, Sadatsafavi M, Marra F, Johnston JC, Smillie K, et al. Burden of non-adherence to latent tuberculosis infection drug therapy and the potential cost-effectiveness of adherence interventions in Canada: a simulation study. BMJ Open. 2017;1:7.

    Google Scholar 

  7. Mckenzie SJ, Mclaughlin D, Clark J, Doi SAR, Mckenzie SJ, Mclaughlin ÁD, et al. The Burden of Non-Adherence to Cardiovascular Medications Among the Aging Population in Australia: A Meta-Analysis. Drugs Aging. 2015;32:217–25 Available from: http://www.epigear.com [cited 2019 6 Dec].

    Article  Google Scholar 

  8. Cutrona SL, Choudhry NK, Fischer MA, Servi AD, Stedman M, Liberman JN, et al. Targeting cardiovascular medication adherence interventions. J Am Pharm Assoc. 2012;52(3):381–97.

    Article  Google Scholar 

  9. Haberer JE, Sabin L, Amico KR, Orrell C, Galárraga O, Tsai AC, et al. Improving antiretroviral therapy adherence in resource-limited settings at scale: a discussion of interventions and recommendations. J Int AIDS Soc. 2017;20(1):21371 Available from: http://0-doi-wiley-com.brum.beds.ac.uk/10.7448/IAS.20.1.21371 [cited 2019 6 Dec.

    Article  Google Scholar 

  10. Normansell R, Kew KM, Mathioudakis AG. Interventions to improve inhaler technique for people with asthma [Internet]. Cochrane Database of Systematic Reviews. 2017 [cited 2020 Jan 20]. Available from: http://0-doi-wiley-com.brum.beds.ac.uk/10.1002/14651858.CD012286.pub2.

  11. Valgimigli M, Garcia-Garcia HM, Vrijens B, Vranckx P, McFadden EP, Costa F, et al. Standardized classification and framework for reporting, interpreting, and analysing medication non-adherence in cardiovascular clinical trials: a consensus report fromthe non-adherence academic research consortium (NARC). Eur Heart J. 2019;40(25):2070–85.

    Article  Google Scholar 

  12. DeWorsop D, Creatura G, Bluez G, Thurnauer H, Forselius-Bielen K, Ranganathan M, et al. Feasibility and success of cell-phone assisted remote observation of medication adherence (CAROMA) in clinical trials. Drug Alcohol Depend. 2016;163:24–30.

    Article  Google Scholar 

  13. Wu AC, Butler MG, Li L, Fung V, Kharbanda EO, Larkin EK, et al. Primary Adherence to Controller Medications for Asthma Is Poor. Ann Am Thorac Soc. 2015;12(2):161–6 Available from: https://0-www-ncbi-nlm-nih-gov.brum.beds.ac.uk/pmc/articles/PMC4342835/pdf/AnnalsATS.201410-459OC.pdf [cited 2017 21 Dec ].

    Article  CAS  Google Scholar 

  14. Williams LK, Joseph CL, Peterson EL, Wells K, Wang M, Chowdhry VK, et al. Patients with asthma who do not fill their inhaled corticosteroids: A study of primary nonadherence. J Allergy Clin Immunol. 2007;120(5):1153–9 Available from: https://0-linkinghub-elsevier-com.brum.beds.ac.uk/retrieve/pii/S0091674907015862 [cited 2019 17 Sep].

    Article  Google Scholar 

  15. Liberman JN, Hutchins DS, Popiel RG, Patel MH, Jan SA, Berger JE. Determinants of primary nonadherence in asthma-controller and dyslipidemia pharmacotherapy. Am J Pharm Benefits. 2010;2(2):111–8.

    Google Scholar 

  16. Blais L, Kettani FZ, Forget A, Beauchesne MF, Lemière C, Ducharme FM. Assessing adherence to inhaled corticosteroids in asthma patients using an integrated measure based on primary and secondary adherence. Eur J Clin Pharmacol. 2017;73(1):91–7.

    Article  CAS  Google Scholar 

  17. Ducharme FM, Noya FJD, Allen-Ramey FC, Maiese EM, Gingras J, Blais L. Clinical effectiveness of inhaled corticosteroids versus montelukast in children with asthma: prescription patterns and patient adherence as key factors. Curr Med Res Opin. 2012;28(1):111–9 Available from: https://0-www-tandfonline-com.brum.beds.ac.uk/action/journalInformation?journalCode=icmo20 [cited 2019 8 Aug].

    Article  CAS  Google Scholar 

  18. Shin J, McCombs JS, Sanchez RJ, Udall M, Deminski MC, Cheetham TC. Primary nonadherence to medications in an integrated healthcare setting. Am J Manag Care. 2012;18(8):426–34.

    PubMed  Google Scholar 

  19. Cheen MHH, Tan YZ, Oh LF, Wee HL, Thumboo J. Prevalence of and factors associated with primary medication non-adherence in chronic disease: A systematic review and meta-analysis. Int J Clin Pract. 2019;73(6):e13350 Available from: https://0-onlinelibrary-wiley-com.brum.beds.ac.uk/doi/abs/10.1111/ijcp.13350[cited 2020 3 Mar].

    Article  Google Scholar 

  20. Pottegård A, Depont Christensen R, Laust Thomsen J, dePont Christensen R, Houji A, Binderup Christiansen C, et al. Primary non-adherence in general practice: A Danish register study. Artic Eur J Clin Pharmacol [Internet]. 2014 [cited 2020 Mar 3]; Available from: https://www.researchgate.net/publication/261801606.

  21. Duerden M, Millson D, Avery A, Smart S. The Quality of GP Prescribing: An Inquiry into the Quality of General Practice in England. 2011.

  22. Dispensing Doctors’ Association. All about Dispensing Practice in England: A guide for NHS service commissioners. 2017.

  23. Feehan M, Ranker L, Durante R, Cooper DK, Jones GJ, Young DC, et al. Adherence to controller asthma medications: 6-month prevalence across a US community pharmacy chain. J Clin Pharm Ther. 2015;40(5):590–3 Available from: http://0-doi-wiley-com.brum.beds.ac.uk/10.1111/jcpt.12316 [cited 2019 27 Jun].

    Article  CAS  Google Scholar 

  24. Williams AB, Amico KR, Bova C, Womack JA. A Proposal for Quality Standards for Measuring Medication Adherence in Research. AIDS Behav. 2013;17(1):284–97 Available from: http://0-link-springer-com.brum.beds.ac.uk/10.1007/s10461-012-0172-7 [cited 2019 8 Aug].

    Article  Google Scholar 

  25. Henson KE, Brock R, Shand B, Coupland VH, Elliss-Brookes L, Lyratzopoulos G, et al. Cohort profile: prescriptions dispensed in the community linked to the national cancer registry in England. BMJ Open. 2018;8:e20980 Available from: http://0-bmjopen-bmj-com.brum.beds.ac.uk/ [cited 2019 24 Jul].

    Article  Google Scholar 

  26. Doidge JC, Harron K. Demystifying probabilistic linkage : Common myths and misconceptions. Int J Popul Data Sci. 2018;3(1):410.

  27. Tibble H, Di LH, Spittal MJ, Karmel R, Borschmann R, Hail-jares K, et al. The importance of including aliases in data linkage with vulnerable populations. BMC Med Res Methodol. 2018;18(1):76.

  28. Downs JM, Ford T, Stewart R, Epstein S, Shetty H, Little R, et al. An approach to linking education, social care and electronic health records for children and young people in South London: A linkage study of child and adolescent mental health service data. BMJ Open. 2019;9:e024355. Available from: http://0-bmjopen-bmj-com.brum.beds.ac.uk/ [cited 2020 5 Oct].

  29. Padmanabhan S, Carty L, Cameron E, Ghosh RE, Williams R, Strongman H. Approach to record linkage of primary care data from Clinical Practice Research Datalink to other health-related patient data: overview and implications. Eur J Epidemiol. 2019;34(1):91–9 Available from: https://0-doi-org.brum.beds.ac.uk/10.1007/s10654-018-0442-4 [cited 2020 19 Aug].

    Article  Google Scholar 

  30. Gilbert R, Lafferty R, Hagger-Johnson G, Harron K, Zhang LC, Smith P, et al. GUILD: GUidance for information about linking data sets. J Public Health (Bangkok). 2018;40(1):191–8.

    Article  Google Scholar 

  31. Benchimol EI, Smeeth L, Guttmann A, Harron K, Moher D, Petersen I, et al. The REporting of studies Conducted using Observational Routinely-collected health Data (RECORD) Statement. PLOS Med. 2015;12(10):e1001885 Available from: https://dx.plos.org/10.1371/journal.pmed.1001885 [cited 2019 30 Sep].

    Article  Google Scholar 

  32. Woodcock A, Bakerly ND, New JP, Gibson JM, Wu W, Vestbo J, et al. The Salford Lung Study protocol: A pragmatic, randomised phase III real-world effectiveness trial in asthma. BMC Pulmonary Med. 15(1):160. Available from: https://nweh.co.uk/uploads/documents/publications/BMC-Pulmonary-Medicine-Paper-on-SLS-Asthma-Protocol.pdf [cited 2019 9 Aug].

  33. Albertson T, Murin S, Sutter M, Chenoweth J. The Salford lung study: a pioneering comparative effectiveness approach to COPD and asthma in clinical trials. Pragmatic Obs Res. 2017;8:175–81 Available from: https://www.dovepress.com/the-salford-lung-study-a-pioneering-comparative-effectiveness-approach-peer-reviewed-article-POR.

    Article  Google Scholar 

  34. New JP, Bakerly ND, Leather D, Woodcock A. Obtaining real-world evidence: the Salford Lung Study. Thorax. 2014;69(12):1152–4 Available from: https://0-thorax-bmj-com.brum.beds.ac.uk/content/69/12/1152 [cited 2019 9 Aug].

    Article  Google Scholar 

  35. Woodcock A, Vestbo J, Bakerly ND, New J, Gibson JM, McCorkindale S, et al. Effectiveness of fluticasone furoate plus vilanterol on asthma control in clinical practice: an open-label, parallel group, randomised controlled trial. Lancet. 2017;390(10109):2247–55.

    Article  CAS  Google Scholar 

  36. Bakerly ND, Woodcock A, New JP, Gibson JM, Wu W, Leather D, et al. The Salford lung study protocol: a pragmatic, randomised phase III real-world effectiveness trial in chronic obstructive pulmonary disease. Respir Res [Internet]. 2015;16(1):1–5 Available from: https://0-doi-org.brum.beds.ac.uk/10.1186/s12931-015-0267-6.

    Article  Google Scholar 

  37. Magid S, Forrer C, Shaha S. Duplicate Orders: An Unintended Consequence of Computerized provider/physician order entry (CPOE) Implementation: Analysis and Mitigation Strategies. Appl Clin Inform. 2012;3(4):377 Available from: http://0-www-ncbi-nlm-nih-gov.brum.beds.ac.uk/pubmed/23646085 [cited 2019 25 Sep].

    Article  CAS  Google Scholar 

  38. Ekedahl A, Brosius H, Jönsson J, Karlsson H, Yngvession M. Discrepancies between the electronic medical record, the prescriptions in the Swedish national prescription repository and the current medication reported by patients. Pharmacoepidemiol Drug Saf. 2011;20:1177–83.

    Article  Google Scholar 

  39. Burden AM, Paterson JM, Gruneir A, Cadarette SM. Adherence to osteoporosis pharmacotherapy is underestimated using days supply values in electronic pharmacy claims data. Pharmacoepidemiol Drug Saf. 2015;24:67–74.

    Article  Google Scholar 

  40. Duerden MG, Hughes DA. Generic and therapeutic substitutions in the UK: are they a good thing? Br J Clin Pharmacol. 2010;70(3):335–41 Available from: http://0-doi-wiley-com.brum.beds.ac.uk/10.1111/j.1365-2125.2010.03718.x [cited 2019 25 Sep].

    Article  Google Scholar 

  41. Fischer MA, Stedman MR, Lii J, Vogeli C, Shrank WH, Brookhart MA, et al. Primary medication non-adherence: analysis of 195,930 electronic prescriptions. J Gen Intern Med. 2010;25(4):284–90 Available from: http://0-www-ncbi-nlm-nih-gov.brum.beds.ac.uk/pubmed/20131023 [cited 2017 21 Dec].

    Article  Google Scholar 

  42. Harron KL, Doidge JC, Knight HE, Gilbert RE, Goldstein H, Cromwell DA, et al. A guide to evaluating linkage quality for the analysis of linked data. Int J Epidemiol. 2017;46(5):1699–710.

    Article  Google Scholar 

  43. British Thoracic Society. British Guideline on the Management of Asthma: Quick Reference Guide [Internet]. Scottish Intercollegiate Guidelines Network. 2016. Available from: http://0-www-ncbi-nlm-nih-gov.brum.beds.ac.uk/pubmed/19209371.

  44. Hoopes M, Angier H, Raynor LA, Suchocki A, Muench J, Marino M, et al. Development of an algorithm to link electronic health record prescriptions with pharmacy dispense claims. J Am Med Informatics Assoc. 2018;25(10):1322–30 Available from: https://0-academic-oup-com.brum.beds.ac.uk/jamia/article/25/10/1322/5065692 [cited 2019 Jul 24].

    Article  Google Scholar 

  45. Berger Z, Kimbrough W, Gillespie C, Boscarino JA, Wood GC, Qian Z, et al. Lower copay and oral administration: predictors of first-fill adherence to new asthma prescriptions. Am Heal Drug Benefits. 2009;2(4):174–9.

    Google Scholar 

  46. Florentinus SR, Souverein PC, Griens FA, Groenewegen PP, Leufkens HG, Heerdink ER. Community pharmacy dispensing data to prescribing data of general practitioners. BMC Med Informatics Decis Mak. 2006;6(1):1–6. Available from: http://0-www-biomedcentral-com.brum.beds.ac.uk/1472-6947/6/18 [cited 2019 24 Jul].

  47. Johannesdottir SA, Lund M, Jens M, Hansen G, Lash TL, Pedersen L, et al. Correspondence between general practitioner-reported medication use and timing of prescription dispensation. Clin Epidemiol. 2012;4:13–18. Available from: https://0-doi-org.brum.beds.ac.uk/10.2147/CLEP.S26958 [cited 2019 24 Jul].

Download references

Acknowledgements

Not applicable.

Funding

The study was supported by HT’s College of Medicine and Veterinary Medicine PhD (eHERC/Farr Institute) Studentship from The University of Edinburgh, and is carried out with the support of the Asthma UK Centre for Applied Research [AUK-AC-2012-01]. MAM’s Newton International Fellowship is awarded by the Academy of Medical Sciences and Newton Fund. The funders had no role in study design, data collection and analysis, decision to publish, or preparation of the manuscript. The Salford Lung Study in asthma (HZA115150; NCT01706198) was funded by GlaxoSmithKline plc. GlaxoSmithKline allows the University of Edinburgh the use of (but not access to) the study data and statistician support. GlaxoSmithKline did not provide any monetary funding to this study.

Author information

Authors and Affiliations

Authors

Consortia

Contributions

HT conceived and planned the analysis. JL-F implemented the analysis scripts in the SLS data platform. HT wrote the first draft, with contributions from JL-F, AS, RH, MAM, and AT. All authors approved the final version and jointly take responsibility for the decision to submit this manuscript to be considered for publication.

Corresponding author

Correspondence to Holly Tibble.

Ethics declarations

Ethics approval and consent to participate

Not Applicable.

Consent for publication

Not Applicable.

Competing interests

The Salford Lung Study was funded by GlaxoSmithKline. JL-F was an employee of GlaxoSmithKline during the conduct of the study, and holds shares/options in the company. No other authors have any conflict pertaining to this manuscript to disclose.

Additional information

Publisher’s Note

Springer Nature remains neutral with regard to jurisdictional claims in published maps and institutional affiliations.

Appendices

Appendix 1

Table 2 String Search Keywords by Medication and Drug Class Keyword Categories

Appendix 2

Table 3 Exclusion Keywords and Frequency

Appendix 3

Variable Recoding

Quantity Recoding:

Quantities with values of over 28 were assumed to be the number of doses, rather than the number of units/inhalers. The most common recorded number of dose quantity was imputed as the most commonly occurring number of doses per unit (as the most common number of units prescribed is one) for that medication class. If the quantity was recorded in doses, this was set as the primary dose quantity, with the second most commonly occurring dose quantity as the alias value. If the quantity was recorded in units, the number of units multiplied by the most commonly occurring dose quantity was imputed as the primary value, and the second most likely as the alias.

Dose Strength Recoding:

All dose strengths were converted into upper case, spaces were removed, and the following string substitutions were made:

  • “MICROGRAMS” replaced with “MCG”,

  • “MICROGRAM” replaced with “MCG”,

  • “MICROG” replaced with “MCG”,

  • “UNITS” replaced with “U”

Strings were then searched for the first pattern of “0.5”, “500”, “400”, “320”, “200”, “184”, “160”, “125”, “100”, “92”, “80”, “50”, “25”, “20”, “10”, “5”, “4”, “2”, or “1”, followed by any of “MG”, “MCG” or “/”. ICS + LABA medications often recorded as X/X dose, in which the larger number relates to the ICS and the lower to the LABA. Some records listed the ICS + LABA combination medicines as ICS/LABA dose, and some as LABA/ICS dose; as such, the possible patterns were searched in order of size, rather than position in string.

Appendix 4

Table 4 Linkage Weight Calculator

Appendix 5

Table 5 Included Feature Weight Combinations

Appendix 6

LINKAGE ALGORITHM DESCRIPTION

The matching algorithm iteratively searches through dispensing records, finding the closest matching prescription record and subsequently removing it from future iterations, for each person and medication class keyword. The medication class keyword is generated by identifying the key active ingredients in a medication that are common between both generic and brand name equivalents, using a domain-knowledge look-up table.

Starting with the first dispensing record, all candidate prescription record links (linkage weight over the threshold and prescription date up to a maximum of six months prior to dispensing) are identified. The most recently prescribed candidate link for the dispensing is selected as the most likely match, using highest linkage weights to break ties, and the non-selected candidate links for both the matched dispensing record and the matched prescription record are excluded from future iterations. The process repeats until every dispensing record has been considered, although it is possible that no candidate links will be available for some dispensing records at later iterations if all initial prescription candidates have been successfully matched to other dispensing records.

Rights and permissions

Open Access This article is licensed under a Creative Commons Attribution 4.0 International License, which permits use, sharing, adaptation, distribution and reproduction in any medium or format, as long as you give appropriate credit to the original author(s) and the source, provide a link to the Creative Commons licence, and indicate if changes were made. The images or other third party material in this article are included in the article's Creative Commons licence, unless indicated otherwise in a credit line to the material. If material is not included in the article's Creative Commons licence and your intended use is not permitted by statutory regulation or exceeds the permitted use, you will need to obtain permission directly from the copyright holder. To view a copy of this licence, visit http://creativecommons.org/licenses/by/4.0/. The Creative Commons Public Domain Dedication waiver (http://creativecommons.org/publicdomain/zero/1.0/) applies to the data made available in this article, unless otherwise stated in a credit line to the data.

Reprints and permissions

About this article

Check for updates. Verify currency and authenticity via CrossMark

Cite this article

Tibble, H., Lay-Flurrie, J., Sheikh, A. et al. Linkage of primary care prescribing records and pharmacy dispensing Records in the Salford Lung Study: application in asthma. BMC Med Res Methodol 20, 303 (2020). https://0-doi-org.brum.beds.ac.uk/10.1186/s12874-020-01184-8

Download citation

  • Received:

  • Accepted:

  • Published:

  • DOI: https://0-doi-org.brum.beds.ac.uk/10.1186/s12874-020-01184-8