- Research article
- Open Access
Agreement between administrative data and the Resident Assessment Instrument Minimum Dataset (RAI-MDS) for medication use in long-term care facilities: a population-based study
BMC Geriatrics volume 15, Article number: 24 (2015)
Prescription medication use, which is common among long-term care facility (LTCF) residents, is routinely used to describe quality of care and predict health outcomes. Data sources that capture medication information, which include surveys, medical charts, administrative health databases, and clinical assessment records, may not collect concordant information, which can result in comparable prevalence and effect size estimates. The purpose of this research was to estimate agreement between two population-based electronic data sources for measuring use of several medication classes among LTCF residents: outpatient prescription drug administrative data and the Resident Assessment Instrument Minimum Data Set (RAI-MDS) Version 2.0.
Prescription drug and RAI-MDS data from the province of Saskatchewan, Canada (population 1.1 million) were linked for 2010/11 in this cross-sectional study. Agreement for anti-psychotic, anti-depressant, and anti-anxiety/hypnotic medication classes was examined using prevalence estimates, Cohen’s κ, and positive and negative agreement. Mixed-effects logistic regression models tested resident and facility characteristics associated with disagreement.
The cohort was comprised of 8,866 LTCF residents. In the RAI-MDS data, prevalence of anti-psychotics was 35.7%, while for anti-depressants it was 37.9% and for hypnotics it was 27.1%. Prevalence was similar in prescription drug data for anti-psychotics and anti-depressants, but lower for hypnotics (18.0%). Cohen’s κ ranged from 0.39 to 0.85 and was highest for the first two medication classes. Diagnosis of a mood disorder and facility affiliation was associated with disagreement for hypnotics.
Agreement between prescription drug administrative data and RAI-MDS assessment data was influenced by the type of medication class, as well as selected patient and facility characteristics. Researchers should carefully consider the purpose of their study, whether it is to capture medication that are dispensed or medications that are currently used by residents, when selecting a data source for research on LTCF populations.
Accurate measures of prescription medication use are important for understanding the health and healthcare use of long-term care facility (LTCF) residents. A large percentage of LTCF residents have complex healthcare needs for which one or more medications may be prescribed  and there is potential for inappropriate prescribing in this vulnerable population . Measures of medication use in previous studies about the quality of care and health outcomes of LTCF residents include anti-psychotic use in the absence of a psychotic disorder or related condition, anti-depressant therapy in residents without depression, and repeated use of hypnotic medications .
Data sources that capture medication information for LTCF residents include surveys, medical charts, administrative health databases, and patient clinical assessment records. Resident surveys are sensitive to self-report or recall biases, while medical chart reviews are time- and labour-intensive to conduct, particularly for multiple facilities. Population-based sources, including administrative health databases and assessment data like the Resident Assessment Instrument Minimum Data Set (RAI-MDS) [4,5], are ideal for making cross-facility or inter-jurisdictional comparisons . However, these data sources were not originally intended for developing facility-specific or jurisdiction-wide quality of care indicators or for studying health outcomes. Administrative data were developed for health system management and monitoring, while the RAI-MDS clinical assessment data were developed to improve resident care. Administrative data do not contain the rich clinical and functional information that is available in clinical assessments, but assessment data contains less information about disease diagnoses, which are essential to characterize patient risk, than administrative data. Thus, there are advantages and disadvantages to both data sources. Accordingly, studies about the comparability of the data in administrative and clinical assessment data, including data on medication use, are important to aid decisions about which source to use in studies about LTCF residents.
Given this context, the purpose of this study was to estimate agreement between medication information recorded in population-based RAI-MDS and prescription drug administrative data. This agreement analysis was conducted for three medication classes that are frequently prescribed for LTCF residents: anti-psychotic, anti-depressant, and anti-anxiety/hypnotic medications.
Data for this study were from the province of Saskatchewan, Canada, which has a population of approximately 1.1 million according to the 2011 Statistics Canada Census, and which has a universal healthcare program and therefore captures virtually all healthcare contacts for the entire population. The province maintains comprehensive health care databases in electronic format and these can be anonymously linked via a unique personal health number .
RAI-MDS Version 2.0, prescription drug, and person registry system records from the 2010/11 fiscal year (a fiscal year extends from April 1 to March 31), the most current year available at the time of the study, were used to conduct the research. The RAI-MDS, originally developed in the US by the Centers for Medicare and Medicaid Services, captures information about care and functioning of LTCF residents. This information is collected by trained assessors, usually nurses, who use interviews with the person and family members, consultation with other clinicians, and chart review, to complete a form. Forms are required to be completed within 14 days of LTCF admission, quarterly and annually thereafter, and whenever there is a major change in a resident’s health status. The RAI-MDS also captures dates of LTCF admission and discharge and some characteristics of the LTCF itself. Saskatchewan was the first Canadian province to make the RAI-MDS mandatory in all LTCFs; this requirement was introduced in April 2001, although full implementation was not achieved until 2004.
The prescription drug database contains records of outpatient drugs dispensed to provincial residents eligible for insurance coverage. It does not capture inpatient medications, medications for residents of a small number of LTCFs with in-house pharmacies, and approximately 10% of the population who are covered by a federally funded pharmacare program (e.g., military, federal police, federal prisoners, First Nations residents). Each available record includes the date of dispensation and national drug identification number (DIN). DINs are linked to codes in the American Hospital Formulary System (AHFS) Pharmacologic-Therapeutic Classification System (www.ashp.org), which is used to group drugs with similar pharmacologic, therapeutic, and/or chemical characteristics.
The person registry system captures dates of health insurance coverage, demographic information, and location of residence. The accuracy and completeness of Saskatchewan’s administrative health data for research has been well documented [8-12] although not specifically for LTCF populations. Ethics approval for database access was received from the University of Saskatchewan Biomedical Research Ethics Board. Data were accessed and analyzed at the provincial Health Quality Council in accordance with a standing data sharing agreement between that organization and the Ministry of Health.
The study cohort inclusion criteria were: (a) resident in a LTCF for at least 60 days, (b) at least one admission, quarterly, or annual RAI-MDS assessment during the residency period, and (c) at least one record for a prescription drug during the residency period. The latter criterion was used to ensure that the cohort included individuals eligible to receive prescription drug benefits.
The assessment date of the first admission, quarterly, or annual RAI-MDS assessment in 2010/11 was the study index date. The observation period extended 30 days before and 30 days after the index date. LTCF residents who did not have continuous health insurance coverage and were not eligible for prescription drug benefits during the study observation period were excluded.
Medication information was extracted from both the RAI-MDS and prescription drug databases. Socio-demographic variables were defined using the person registry data. Additional information on resident and facility characteristics were obtained from the RAI-MDS data.
The RAI-MDS captures the number of days of medication use in the seven-day period prior to the assessment reference date. The following medication classes are included in Section O of the assessment form: anti-psychotic, anti-depressant, anti-anxiety, hypnotic, and diuretic. Based on previous research, anti-anxiety and hypnotic medication classes were combined into a single category because they often have a similar indication and diuretics were excluded because they tend to have lower prevalence . In the prescription drug administrative data, anti-psychotic, anti-depressant, and anti-anxiety/hypnotic medications were identified using generic drug names (see Additional file 1) and AHFS codes from the provincial formulary (i.e., drugs covered by prescription drug benefits). The prescription drug database was searched for dispensations of the three medications in the study observation window. We selected a 60-day observation window because the medications under investigation are commonly dispensed in one-month quantities . A sensitivity analysis was conducted using a 28-day observation window (i.e., 14 days before and 14 days after the index date).
LTCF residents were described on the socio-demographic characteristics of age, sex, region of residence, and income quintile. All measures were defined at the index date. Urban or rural region of residence was assigned based on the postal code contained in the person registry. Urban residents were those living in one of the two health regions in the province that contain major urban centres, while rural residents were those individuals living in the remaining 11 health regions. Income quintile was an area-level measure assigned based on average household income from the Statistics Canada Census. Each individual’s postal code from the person registry was assigned to a dissemination area (DA), the smallest geographic unit for which Census data are reported. The entire Saskatchewan population was then divided into five approximately equal groups according to the DA average household income . Preliminary analysis of the data showed that for three quarters (i.e., 74.0%) of cohort members, the index date corresponded to the initial assessment; accordingly, the resident’s postal code would correspond to the place of resident prior to admission.
Selected chronic diseases identified in the RAI-MDS were also captured for each member of the study cohort, including Alzheimer’s disease, dementia, mood disorders (i.e., anxiety, depression, bipolar), and schizophrenia, which are potential indications for the medications under investigations. These conditions were defined at the study index date using admission and annual assessments, or the most recent admission or annual assessment if the index date was the date of a quarterly assessment because not all diagnoses (e.g., schizophrenia) were captured in quarterly assessments.
Facility characteristics captured in the RAI-MDS data in Saskatchewan include the type of facility and its affiliation. These characteristics were defined at the study index date. LTCFs were classified as special care home or other; the former are public facilities for which residence is determined based on need, while the latter are typically private facilities. LTCF affiliation includes amalgamate, affiliate, and contract. Health regions may operate facilities on their own (amalgamate), or the facility may be operated by an independent health care organisation (affiliate), or through a contract for services with an independent organization (contract).
The study cohort was described using frequencies, percentages, means, and standard deviations (SDs). Crude prevalence estimates (percentages) were calculated for each type of prescription medication. Cohen’s κ was used to estimate agreement between the RAI-MDS and administrative data; 95% confidence intervals (CIs) were also computed. The interpretation of κ adopted in this study was : κ < 0.20 is poor agreement, 0.20 ≤ κ ≤ 0.39 is fair agreement, 0.40 ≤ κ ≤ 0.59 is moderate agreement, 0.60 ≤ κ ≤ 0.79 is good agreement, and κ ≥ 0.80 is very good agreement.
Mixed-effects multiple logistic regression models were fit separately to the data for each medication to test resident and facility variables associated with disagreement between the two data sources . All individuals who were identified as medication users in one data source but not in the other data source were included in the disagreement category, while individuals who were either identified as medication users or as medication non-users in both data sources were included in the agreement category. Two models were fit to the data: (a) null model, which contained a random facility intercept only, to account for clustering of patients within facilities, and (b) full model which contained a random intercept as well as resident and facility fixed-effect covariates. Facility type was excluded because it was collinear with affiliation. The intra-class correlation (ICC) was computed for the null and full models  using a latent variable method . The Akaike Information Criterion (AIC) was used to compare model fit between the null and full models . The c-statistic, which is equal to the area under the receiver operating characteristic (ROC) curve for dichotomous outcomes, was used to assess discriminative performance ; it was estimated for the full model when the clustering effect.
All regression coefficients were exponentiated and reported as odds ratios (ORs), along with 95% CIs. Analyses were conducted using SAS software, version 9.2 .
A total of 9,913 individuals were identified as residents in a Saskatchewan LTCF for at least 60 days in 2010/11. Of this number, 350 (3.5%) did not have an RAI-MDS admission, annual, or quarterly assessment, 477 (4.8%) residents did not meet health insurance coverage or prescription drug benefit requirements and 220 residents (2.2%) did not have at least one prescription drug record during the observation period, leaving 8,866 LTCF residents in the study cohort.
The average age of the cohort members was 84.1 years (SD = 11.4; median = 86.0) and they had resided in a LTCF for an average of 912.0 days (SD = 1381.5; median = 465). More than two-thirds of the cohort was female (68.2%; Table 1). Fewer individuals were in the highest (13.8%) than in the lowest (22.2%) income quintile. More than half (51.4%) of the study cohort had a diagnosis of Alzheimer’s disease or dementia.
A total of 163 facilities were identified in the data; the majority were amalgamates and special care homes. The average number of study cohort members in each LTCF was 54.4 (SD = 53.5; median = 37.0).
Crude medication prevalence estimates were 35.7%, 37.9%, and 27.1% for anti-psychotic, anti-depressant, and anti-anxiety/hypnotic medications, respectively, from the RAI-MDS data. The corresponding estimates for the prescription drug data were 35.8%, 39.6%, and 18.0%. Figure 1 contains crude estimates by age group. Prevalence was highest for anti-depressants in residents less than 65 years of age; the estimate was 47.5% in the RAI-MDS data and 50.2% in the prescription drug data.
Overall estimates of Cohen’s κ indicated very good agreement for anti-psychotic and anti-depressant medications, but only moderate agreement for anti-anxiety/hypnotic medications (Table 2). Estimates were similar for younger and older age groups except for anti-anxiety medications, which had slightly higher agreement in younger than older individuals. Estimates were also similar for males and females, although agreement was slightly higher for females than males on anti-depressant medications. In terms of disagreement between the two data sources, the highest frequency was for residents with anti-anxiety/hypnotics identified in the RAI-MDS data but not in the prescription drug data. For the other two types of medications, there were similar percentages of disagreement between the two data sources.
Given the lower levels of agreement for anti-anxiety/hypnotic medications, we focused only on this medication when modeling the factors associated with disagreement (Table 3). The facility-level variance was significantly different from zero in the null model (variance = 0.05; standard deviation = 0.02), but not in the full model. At the same time, the ICC remained constant at 0.01 for both the null and full models, providing little evidence of a clustering effect in the data. The AIC revealed that the full model (9010.3) was a better fit to the data than the null model (9172.9). Discriminative performance of the full model was moderate (c-statistic = 0.55). The ORs for disagreement between the prescription drug administrative data and the RAI-MDS data (Table 3) revealed that the odds of disagreement were higher for residents with a mood disorder and for residents of amalgamate than contract facilities.
The sensitivity analysis conducted using the 28-day observation window, produced similar results. Specifically, Cohen’s κ ranged from 0.34 for anti-anxiety/hypnotic medications to 0.78 for anti-psychotic medications.
Deterministic record linkage techniques were used to compare LTCF resident medication information captured in prescription drug administrative data and RAI-MDS data for the entire LTCF population of a Canadian province. Agreement ranged from moderate to very good for three medication classes captured in RAI-MDS data, and was lowest for anti-anxiety/hypnotic medications. For this latter medication class, a diagnosis of a mood disorder and the regional affiliation of the facility were associated with disagreement, although the discriminative performance of resident and facility characteristics was modest.
When compared to prescription drug administrative data, which captures information on medication dispensations, it appears that the RAI-MDS clinical assessment data, which captures information on utilization of medications, contain comparable information for anti-psychotic and anti-depressant medication classes . The small size of the ICC for all medications indicates that there was little variation across facilities in the lack of capture of medication class information in either data source. However, for anti-anxiety and hypnotic medication classes, it appears that there may be some differences across facility affiliations, with those being operated by health regions having slightly higher odds of disagreement compared with those contracted to provide services by the health region. This finding suggests that requirements around completion of the RAI-MDS assessment form may not be the same for different types of facilities. Higher disagreement for residents with mental health conditions may, in part, arise because it is more time consuming to complete the assessment form for residents with complex needs, leading to a higher potential for error or incomplete capture of medication class information.
The high rate of disagreement between the RAI-MDS and prescription drug data for anti-anxiety and hypnotic medication classes may have arisen for a number of reasons that are not captured in the study variables. Not all anti-anxiety or hypnotic medications may be covered by provincial health benefits, although this number will be small . The RAI-MDS assessment form does not contain generic names or DINs, therefore LTCF staff may not be able to correctly identify anti-anxiety or hypnotic medications. A patient prescription might not always be filled through a community pharmacy for anti-anxiety or hypnotic medication classes and therefore might not be captured in the prescription drug database; some medication stocks may be kept in-house in LTCFs if they are used on an infrequent or intermittent basis. As well, for medications used on an infrequent basis, the observation window may need to be substantially widened in order to achieve a high estimate of agreement if consumption does not occur shortly after dispensation. However, we found that moving from a 28-day to 60-day window had almost no impact on prevalence estimates for this type of medication.
There are a number of considerations when choosing between prescription drug administrative data and RAI-MDS data for measuring medication use in residents of LTCFs. Databases that contain prescription drug dispensation records do not capture individuals who are not covered by prescription drug benefit programs; this may represent substantial portions of the population in some jurisdictions. In Canada for example, prescription drug dispensations are not routinely captured in some provincial electronic database, or they are captured only for individuals 65+ years of age . At the same time, some jurisdictions may not mandate collection of RAI-MDS data for all LTCF residents, which will result in less than complete population coverage and affect accuracy and generalizability of prevalence estimates. While administrative data capture all drugs prescribed on an outpatient basis, inpatient medications are not typically captured; residents of LTCFs affiliated with acute care inpatient facilities may be missed. While only a small number of medication classes are captured in Section O of the RAI-MDS form, medications administered in the last seven days are captured; this will include medications prescribed while in hospital for individuals who are transferred from an acute care facility to a LTCF.
This study has some limitations. An external validation of each data source was not conducted, although a chart abstraction study or patient medication review would be difficult to undertake given the large number of facilities and patients that would have to be sampled to produce generalizable results; as well such a study would be very expensive to undertake. The discriminative performance of the model covariates was moderate for all of the medications, suggesting that other covariates should be considered as predictors of disagreement. As well, there may be unmeasured confounding in the model due to the limited set of covariates available for consideration. For example, facility characteristics such as number and type of staff might be useful to consider, but are not currently captured in electronic databases.
This study of agreement between medication classes captured in prescription drug administrative data and clinical assessment data from the RAI-MDS suggests that the medication information contained in both data sources is consistent for anti-psychotics and anti-depressants. For anti-anxiety and hypnotic medication ascertainment, low agreement between the two data sources was not associated with resident socio-demographic characteristics and was only weakly associated with resident disease diagnoses or facility type. While we hypothesize that agreement may be associated with the pattern or frequency of use in LTCF residents, further research is required to draw conclusions about these effects.
Research about the optimal source of data to measure medication use in LTCF populations is important for a number of reasons. Medication use is a risk factor for adverse health outcomes such as hip fracture. Accordingly, failure to include measures of medication use in prediction models represents a potential source of bias due to unmeasured confounding that could lead to erroneous conclusions . Accurate measurement of medication use is also critical to minimize variations in prescribing practices.
Doshi JA, Shaffer T, Briesacher BA. National estimates of medication use in nursing homes: Findings from the 1997 Medicare Current Beneficiary Survey and the 1996 Medical Expenditure Survey. J Am Geriatr Soc. 1997;2005(53):438–43.
Lustenberger I, Schupbach B, von Gunten A, Mosimann U. Psychotropic medication use in Swiss nursing homes. Swiss Med Wkly. 2011;141:w13254.
Zimmerman DR. Improving nursing home quality of care through outcomes data: the MDS quality indicators. Int J Geriatr Psychiatry. 2003;18:250–7.
Mor V, Intrator O, Unruh MA, Cai S. Temporal and geographic variation in the validity and internal consistency of the Nursing Home Resident Assessment Minimum Data Set 20. BMC Health Serv Res. 2011;11:78.
Metge C, Grymonpre R, Dahl M, Yogendran M. Pharmaceutical use among older adults: Using administrative data to examine medication-related issues. Can J Aging. 2012;24:81–95.
Richter T, Mann E, Meyer G, Haastert B, Kopke S. Prevalence of psychotropic medication use among German and Austrian nursing home residents: A comparison of 3 cohorts. J Am Med Dir Assoc. 2012;13:187.e7–187.e13.
Downey W, Beck C, McNutt M, Stang M, Osei W, Nichol J. Health databases in Saskatchewan. In: Strom BL, editor. In Pharmacoepidemiology. 3rd ed. New York: Wiley; 2000. p. 325–45.
Edouard L, Rawson NS. Reliability of the recording of hysterectomy in the Saskatchewan health care system. Br J Obstet Gynaecol. 1996;103:891–7.
Liu L, Reeder B, Shuaib A, Mazagri R. Validity of stroke diagnosis on hospital discharge records in Saskatchewan, Canada: implications for stroke surveillance. Cerebrovasc Dis. 1999;9:224–30.
Rawson NS, Malcolm E. Validity of the recording of ischaemic heart disease and chronic obstructive pulmonary disease in the Saskatchewan health care datafiles. Stat Med. 1995;14:2627–43.
Rawson NS, D’Arcy C. Assessing the validity of diagnostic information in administrative health care utilization data: experience in Saskatchewan. Pharmacoepidemiol Drug Saf. 1998;7:389–98.
Rawson NS, Malcolm E, D’Arcy C. Reliability of the recording of schizophrenia and depressive disorder in the Saskatchewan health care datafiles. Soc Psychiatry Psychiatr Epidemiol. 1997;32:191–9.
Hutchinson AM, Milke DL, Maisey S, Johnson C, Squires JE, Teare G, et al. The Resident Assessment Instrument-Minimum Data Set 20 quality indicators: a systematic review. BMC Health Serv Res. 2010;10:166.
Ministry of Health. Government of Saskatchewan: Ministry of Health Formulary, 60th edition, April 2010 - March 2011. Regina, SK: Saskatchewan Ministry of Health; 2010.
Roos NP, Mustard CA. Variation in health and health care use by socio-economic status in Winnipeg, Canada: the system works well? Yes and no. Milbank Q. 1997;75:89–111.
Altman DG. Practical Statistics for Medical Research. London: Chapman & Hall; 2001.
Gibbons RD. Mixed-effects models for mental health services research. Health Serv Outcomes Res Meth. 2000;1:91–129.
Merlo J, Chaix B, Ohlsson H, Beckman A, Johnell K, Hjerpe P, et al. A brief conceptual tutorial of multilevel analysis in social epidemiology: using measures of clustering in multilevel logistic regression to investigate contextual phenomena. J Epidemiol Community Health. 2006;60:290–7.
Harrell Jr FE, Lee KL, Mark DB. Multivariable prognostic models: issues in developing models, evaluating assumptions and adequacy, and measuring and reducing errors. Stat Med. 1996;15:361–87.
Steyerberg EWEMJC, Harrell FE, Habbema JDF. Prognostic modelling with logistic regression analysis: a comparison of selection and estimation methods in small data sets. Stat Med. 2000;19:1059–79.
SAS Institute Inc. SAS/STAT 9.2 User’s Guide. Cary, NC: SAS Institute Inc; 2008.
Canadian Institute for Health Information. Data quality documentation, continuing care reporting system, 2011–2012. Ottawa, ON: Canadian Institute for Health Information; 2012.
Miller E, Blatman B, Einarson TR. A survey of population-based drug databases in Canada. Can Med Assoc J. 1996;154:1855–64.
Kannegaard PN, van der Mark S, Eiken P, Abrahamsen B. Excess mortality in men compared with women following a hip fracture. National analysis of comedications, comorbidity and survival. Age Ageing. 2010;39:203–9.
This study is based in part on de-identified data provided by the Saskatchewan Ministry of Health. The interpretation and conclusions contained herein do not necessarily represent those of the Government of Saskatchewan or the Ministry of Health. The research team is funded by the Ministry of Health. This research was also supported in part by career awards to the first author from the University of Saskatchewan Centennial Chair Program and the Manitoba Health Research Council Research Chair Program.
The authors declare that they have no competing interests.
LML, LY, NH, GT, DB, and VSL designed the study. LY and NH conducted the data analyses. LML, LY, GT, DB, VSL, YS drafted the manuscript. All authors reviewed and approved the manuscript for peer-review submission.
Rights and permissions
This article is published under license to BioMed Central Ltd. This is an Open Access article distributed under the terms of the Creative Commons Attribution License (http://creativecommons.org/licenses/by/4.0), which permits unrestricted use, distribution, and reproduction in any medium, provided the original work is properly credited. 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.
About this article
Cite this article
Lix, L.M., Yan, L., Blackburn, D. et al. Agreement between administrative data and the Resident Assessment Instrument Minimum Dataset (RAI-MDS) for medication use in long-term care facilities: a population-based study. BMC Geriatr 15, 24 (2015). https://doi.org/10.1186/s12877-015-0023-2
- Long-term care
- Medication system
- Electronic database
- Mental health