This article has Open Peer Review reports available.
Variability in prescription drug expenditures explained by adjusted clinical groups (ACG) case-mix: A cross-sectional study of patient electronic records in primary care
© Aguado et al; licensee BioMed Central Ltd. 2008
Received: 28 September 2007
Accepted: 04 March 2008
Published: 04 March 2008
In view of rapidly increasing prescription costs, case-mix adjustment should be considered for effective control of costs. We have estimated the variability in pharmacy costs explained by ACG in centers using patient electronic records, profiled centers and physicians and analyzed the correlation between cost and quality of prescription.
We analyzed 65,630 patient records attending five primary care centers in Spain during 2005. Variables explored were age, gender, registered diagnosed episodes of care during 2005, total cost of prescriptions, physician and center. One ACG was assigned to each patient with ACG case-mix software version 7.1. In a two-part model, logistic regression was used to explain the incurrence of drug expenditure at the first stage and a linear mixed model that considered the multilevel structure of data modeled the cost, conditional upon incurring any expense. Risk and efficiency indexes in pharmacy cost adjusted for ACG were obtained for centers and physicians. Spearman rank correlation between physician expenditure, adjusted for ACG, and a prescription quality index was also obtained. Pediatric and adult data were analyzed separately.
No prescription was recorded for 13% of adults and 39.6% of children. The proportion of variance of the incurrence of expenditure explained by ACGs was 0.29 in adults and 0.21 in children. For adults with prescriptions, the variance of cost explained by ACGs was 35.4%, by physician-center was 1.8% and age 10.5% (residual 52.3%). For children, ACGs explained 22.4% of cost and physician-center 10.9% (residual 66.7%). Center efficiency index for adults ranged 0.58 to 1.22 and for children 0.32 to 2.36.
Spearman correlation between expenditure and prescription quality index was -0.36 in family physicians (p = 0.019, N = 41) and -0.52 in pediatricians (p = 0.08, N = 12).
In our setting, ACG is the variable studied that explains more variability in pharmacy cost in adults compared to physician and center. In children there is greater variability among physicians and centers not related to case-mix. In our sites, ACG is useful to profile physicians and centers using electronic records in real practical conditions. Physicians with lower pharmaceutical expenditure have higher scores for a prescription quality index.
Prescription drug costs are rapidly increasing in most countries. The pharmaceutical expenditure in Catalonia, Spain is 25% of total health cost . Since patient complexity is a major determinant of expenditure, in order to control drug costs more effectively and with equity, methods for case mix adjustment should be considered.
The adjusted clinical groups (ACGs) system was developed at the Johns Hopkins University in Baltimore [2, 3]. It estimates individual health status and risk for health service use based on age, gender and diagnoses assigned over a defined time interval, typically one year. Each diagnosis is assigned to one of 32 aggregated diagnostic groups (ADGs). Each ADG is a cluster of similar conditions based on their expected impact on health services resource consumption. Patients are then classified into one ACG based on age, gender and constellation of ADGs.
Even though this system was developed in the USA, it has been used and assessed in other countries. In Spain, most of the studies available have been performed in experimental conditions. There is little information on the utility of the system in real conditions of the daily clinical practice and using the physicians encounter data. Recently, Primary Care centers in the Catalan Institute of Health have substituted patient clinical records from paper to electronic format. This makes it possible to test the ACG system in real conditions.
Physicians are sometimes reluctant to accept a control of their expenditure. It is often argued that a reduction in cost implies a reduced quality of health care. But the selection of low cost health providers as compared with others of higher cost does not necessarily mean health care service is adversely affected . In Spain, older medications are usually cheaper than new drugs and their safety and efficacy profile is often best known. Physicians might accept better a control of their expenditure if they knew that quality is not compromised.
In this study we have three aims: 1) to estimate the variability in prescription drug costs explained by ACG in centers using electronic patient records, 2) to profile centers and physicians after adjusting for ACG, and 3) to analyze the correlation between pharmacy costs adjusted for ACG and quality of prescription.
This is a cross-sectional observational study. Data were obtained retrospectively from electronic records in five primary care centers. All family physicians and pediatricians working in these centers for the whole year and their patients who attended at least once during the period January to December of 2005 have been studied. The centers are located in Baix Llobregat Centre, close to Barcelona and are referred as center A (assigned population: 21,748), center B (15,848), center C (26,768), center D (14,281) and center E (15,937). These centers have been using exclusively electronic records (software OMI AP version 6.0) for more than 2 years.
Data retrieval and processing
Data available per patient from electronic records was: encrypted identity number, age, gender, registered diagnosed episodes of care during 2005, drug prescriptions (type and amount), assigned physician (with an encrypted identity code) and center. The diagnosed health problems were coded with the International Classification for Primary Care (ICPC-2). A file with the drug prices from Catsalut, a public agency responsible for contracting and paying for health services in Catalonia, Spain, was used to obtain the cost of prescribed medication per patient (in euros). Electronic printed prescriptions are an overestimation of prescribed drugs that are obtained from the pharmacy store and invoiced to Catsalut. A correction to the patient prescription cost was applied according to the deviation within each center of the prescription cost obtained from electronic files and the real expenditure invoiced.
A conversion (mapping) from ICPC-2 codes to ICD-9-CM has been performed . For this process a working team (a documentalist, 2 clinical doctors and 2 consulters) was created. There were three different groups according to the relations among the two system codes: 1) no relation (one code in ICPC-2 with no equivalent in ICD-9-CM), 2) univocal relation (one code in ICPC-2 had a single correspondence in the ICD-9-CM, this was the optimal situation) and 3) multiple relations (one code in ICPC-2 had several possible codes in ICD-9-CM). For codes in group 1, the documentalist, with the agreement of the rest of the team, codified the descriptors to the closest ICD-9-CM category. For codes in group 3, if all possible ICD codes had the same Adjusted Diagnostic Group, then this ADG was adopted. But if several ADGs were possible, then the most frequent ICD-9-CM code was considered.
From coded diagnoses of episodes, the Johns Hopkins ACG case-mix system software version 7.1 classified subjects into 32 binary (present/absent) Aggregated Diagnosis Groups (ADGs). In a second step, a single ACG category was assigned to each patient based on age, gender and the number and type of ADGs.
Each physician and center had a score for quality of prescription assigned by a computerized program of the Catalan Institute of Health. This institution has developed a quality index for family physicians and for pediatricians according to their prescription. For our study we used the version available for 2005 [see Additional file 1]. In the Catalan Institute of Health official web, the procedures for the construction of the updated 2007 version is available . For family physicians the maximum score is 130 and consists of general and specific indicators that consider mostly the efficacy and safety, and also the efficiency of therapeutic options for the most common conditions in primary care. Global indicators include the use of generics and new drugs, and specific indicators include the use of non steroidal anti-inflammatory drugs, antibiotics and drugs for hypertension, ulcer, hyperlipidemia, asthma, depression, anxiety/insomnia and diabetes. Pediatricians can have a maximum score of 70 according to global indicators that include the use of generics and new drugs, and specific indicators about the use of antibiotics and drugs for asthma.
The distribution of ACG in the population was described separately for pediatric (<15 years) and adults. ACGs with similar mean cost were grouped in resource utilization bands (RUBs) based on quintiles in order to have a reduced number of homogeneous categories. We added one to all values of cost data and then log transformed to reduce the skewness of the distribution and make it close to normal. Only one patient with an extremely high expenditure was excluded from the analysis.
Variability in prescription drug expenditures
Age was fitted as a fixed effect, with linear and quadratic terms. ACG and physician (nested within center) were considered random effects. The values observed were supposed to follow a normal distribution with zero mean and a given variance. These variances (σ2 1 and σ2 2) were the parameters of interest for the ACG and physician variables. The residual variance was also a relevant term, because indicated the amount of variability unexplained by these terms. The variances per se were not important, because they depend on the actual data observed. We calculated the relative contribution of each term to the total variance as indicator of the importance of the variable in the variability of pharmaceutical expenditure.
Since the calculation of ACGs considered age and gender, including all these terms in the model would make difficult the interpretation due to colinearity. Gender was not relevant in explaining cost, and we decided to exclude this term, which would have a zero parameter. For age, we first fitted a linear model with ACG as random effect and calculated the residuals for each subject. The residuals can be interpreted as the variability in age not accounted for already in the ACGs terms. Then we used these residuals in a linear and quadratic term as fixed effects in the models to explore the variability in cost. This way, the variance component for age should be interpreted as that not already explained by ACG. These models were estimated using the restricted maximum likelihood method.
A two-part model was also used. In a first step, a binary logistic regression using ACG as a covariate was applied to predict the incurrence of drug expenditure. Nagelkerke R2 was used to estimate the proportion of variance explained. We chose this measure knowing its limitations as an approximation to the coefficient of determination in a linear model. In logistic regression models the concept of residual variance is not easy to define because the response variable is binary. These models are fitted by maximum likelihood and the likelihood value can be used as a relative measure of model fit. The problem is that, when modeling individual data, as in our study, the actual likelihood value depends on sample size and has no interpretation. Nagelkerke  defined an equivalent value to the coefficient of determination based on the ratio of likelihoods between the "null" model (with only a constant) and fitted model, appropriately corrected to have a maximum of 1. This coefficient can be interpreted as the goodness of the model in predicting the response from the covariates, similar to R2 in linear regression. We have assumed approximate additivity in the proportion of variance explained by multiple factors, which is appropriate when these are not too large.
In a second step of the two part model, the variability in pharmacy costs restricted to patients with prescriptions were estimated using variance components analysis of linear mixed models as before. ACGs with less than 30 subjects were excluded from the analysis.
Profiling of centers and physicians
Risk and efficiency indexes in pharmacy costs, adjusted for ACG, were obtained for centers and physicians. Risk index or morbidity burden was calculated for each center and physician. It shows the complexity of visited population in relation to a standard and is calculated as the ratio between the predicted mean pharmaceutical cost considering the ACG distribution and the mean pharmaceutical cost of the whole population studied. Efficiency index compares pharmaceutical expenditure among centers and physicians assuming similar population complexity. It is calculated as the ratio between the observed mean expenditure and the predicted mean expenditure adjusted for ACG. Expenditure of centers and physicians were compared after adjusting for ACG using linear mixed models.
The Spearman rank correlation between physician pharmacy cost adjusted for ACG and the prescription quality index was calculated.
Description of population and variables
Characteristics of the population.
Pharmaceutical expenditure Median (euros)
Prescription quality score
More frequent ACGs and ACGs with more expenditure
Acute Minor, Age 6+
2–3 Other ADG Combinations, Age 35+
6–9 Other ADG Combinations, Age 35+, 0–1 Major ADGs
Acute Minor/Likely to Recur, Age 6+, w/o Allergy
4–5 Other ADG Combinations, Age 45+, no Major ADGs
Acute Minor/Acute Major
4–5 Other ADG Combinations, Age 45+, 1 Major ADGs
Likely to Recur, w/o Allergies
Acute Minor/Acute Major/Likely to Recur/Chronic Medical: Stable
Acute Minor/Acute Major/Likely to Recur, Age 12+, w/o Allergy
Acute Minor/Chronic Medical: Stable
4–5 Other ADG Combinations, Age 18 to 44, no Major ADGs
6–9 Other ADG Combinations, Age 35+, 2 Major ADGs
Acute Minor/Psychosocial, w/o Psychosocial Unstable
Acute Minor/Likely to Recur/Psychosocial
6–9 Other ADG Combinations, Age 35+, 4+ Major ADGs
10+ Other ADG Combinations, Age 18+, 3 Major ADGs
10+ Other ADG Combinations, Age 18+, 2 Major ADGs
6–9 Other ADG Combinations, Age 35+, 3 Major ADGs
10+ Other ADG Combinations, Age 18+, 4+ Major ADGs
6–9 Other ADG Combinations, Age 35+, 2 Major ADGs
10+ Other ADG Combinations, Age 18+, 0–1 Major ADGs
4–5 Other ADG Combinations, Age 45+, 2+ Major ADGs
Psychosocial, w/Psychosocial Unstable, w/o Psychosocial Stable
4–5 Other ADG Combinations, Age 45+, 1 Major ADGs
6–9 Other ADG Combinations, Age 35+, 0–1 Major ADGs
Chronic Medical: Unstable
Acute Minor/Psychosocial, w/Psychosocial Unstable/Psychosocial Stable
6–9 Other ADG Combinations, Males, Age 18 to 34, 2+ Major ADGs
Distribution in Resource Utilization Bands (RUBs)
Explained variability in pharmaceutical expenditure
When considering individual variables (univariate analysis), the proportion of variance explained (R2) of pharmaceutical expenditure was, for adult patients: 0.31 for age, 0.01 for gender, 0.03 for physician and 0.39 for ACG. For pediatric patients R2 values were: 0.04 for age, 0 for gender, 0.33 for physician and 0.19 for ACG. Between centers, R2 for ACGs in adult population showed little variability (0.32 to 0.45) while in pediatric patients the proportion of cost explained by ACGs was smaller and more disperse between centers (0.09 to 0.39).
Cost modeling approaches for prediction of pharmaceutical expenditure.
Level of expenditure
Linear mixed models
Linear mixed models
Risk and efficiency index for centers.
Correlation between physician pharmaceutical expenditure and quality score
When using crude expenditure, in family physicians the Spearman rank correlation was -0.18 (N = 41, p = 0.26) and in pediatricians it was -0.54 (N = 12, p = 0.07). After adjusting for ACGs using a linear model, the correlation in adults was -0.36 (p = 0.019) and in pediatricians -0.52 (p = 0.08).
In this study we show that patient case-mix measured with ACGs is the major determinant of pharmaceutical expenditure variability in our setting. Adjustment for ACGs allows a much fair comparison of expenditures among centers and physicians. We also show that pharmaceutical expenditure correlates negatively with a prescription quality index more strongly when adjusted for ACGs, which can be interpreted as evidence that, when complexity of the patients is accounted for, better quality of prescription is associated with lower expenditure.
In this analysis adult and pediatric data have been analyzed separately because their distribution is different and the proportion of expenditure variance explained for the main factors is also different. In adults, the expenditure is higher. A significant percentage of patients attended the centers but had no prescription (13%, figure 1). The distribution of the logarithmic expenditure looks like a mixture of two overlapped normal populations. Possibly this shape is due to the patients with chronic medication that have higher costs, but we have no data to prove it because this variable was not available. In pediatric patients, the proportion attending the centers without prescription is higher, 40% and the distribution of the logarithmic expenditure looks like a single normal population.
Healthcare cost data usually have mixed distributions with a high percentage of non-users and a right-skewed distribution for users . Two-part modeling has been used to address the issue of a mixed distribution of data. This approach first estimates the probability of incurring any cost and subsequently models the amount of cost conditional on having incurred any cost . ACG explain 28.8% of the variability in the incurrence of drug prescriptions in adults and 20.6% in children. In subjects with prescriptions, the variability in expenditure explained by ACG accounts for 35.4% in adults and 22.4% in children. We should emphasize that the results obtained here are site specific and need not generalize to other sites with different patient population profiles, non-primary care settings or structure of care provision. However, these results are similar to those obtained by other authors in real practice conditions. Orueta  in the Basque Country, Spain proved ACG was useful in real conditions of daily practice to explain 50% of the variance in visits to primary care physicians, 25 – 40% of prescriptions, 25 – 30% of referrals and requests of laboratory tests and 14–16% of radiographs. The coefficients of determination remained almost invariable after the addition of hospital diagnosis or correction of coding errors by the research team. Sicras  found that 20% of the variability in pharmacy costs was explained by ACGs in a non-public primary care health center in Catalonia, Spain, using a retrospective setting.
Only one patient with extremely high expenditure was excluded from the analysis. No other data were truncated to remove the effect of outliers. This would have improved the fit of the models. But a small proportion of the population accounts for a large amount of pharmaceutical expenditure . So if data are not truncated, the ability to predict pharmacy costs for the patients with the highest expenditures that often contribute a disproportionate amount of total cost is preserved.
More than half of the variability in prescription drug expenditure still remains to be explained. Context variables, summarized in center, show little impact in variability. And physician related factors are only relevant in pediatric population. Some other variables not recorded and measurement error may play a role in the observed variability. The accumulation of different kind of errors may be heterogeneous among centers and professionals. The main sources of errors are: deficient quality in patient record files, errors in diagnostic coding and in recoding from ICPC-2 to ICD-9-MC. Our source of information for prescription cost was the patient electronic files, which records information of printed prescriptions. This is an overestimation of real cost invoiced to the health system for several reasons: a prescription might be printed several times because of technical problems. Also, not all patients with a prescription go to the pharmacy store to get the drug. As a result of this, the real pharmacy cost invoiced to the health system is not as high as that obtained from the patient electronic file. In our study we estimated a deviation of 25%, and an appropriate correction was applied when estimating the sources of variability. Although the deviation is important, and it is a limitation of the study, we cannot analyse in detail these unfilled prescriptions because the real cost per person invoiced to the health system is not available. Only the global deviation per center was available and that is what we used for correction.
ACG system has proved useful in the profiling of centers and physicians when data are obtained from electronic records in real conditions of usual practice. It is possible to identify physicians and centers with high expenditure but with a good efficiency index after adjusting for case-mix. Also some centers and professionals have an apparent low cost but considering their case mix, a lower expenditure would be expected.
In center B, the median expenditure per visited patient in adults is one of the highest. After adjusting for ACG, it becomes apparent the population visited has more burden of morbidity (risk index 1.9) and has the best efficiency index (0.58). On the other hand, center A has the lowest median expenditure per patient in adults. After adjusting for ACG, the population has the lowest burden of morbidity (risk index: 0.78) and the efficiency is less than satisfactory (efficiency index: 1.16). When considering the median expenditure per pediatric patient, center C has an extremely high value. After adjusting for ACG, the burden of morbidity of their patients is slightly above average and the efficiency index is very poor (an index of 2.36). Similar observations can be performed considering each physician's prescription. Other authors have also used ACG system for profiling of physicians and showed similar results [13, 14].
Sites D and E have lower paediatric expenditure with a median of 0 per paediatric patient (table 1). As it is evident in table 5, the mean observed cost for paediatric patient in sites D and E patient is lower than the expected expenditure according to ACG distribution, and so the efficiency index in these centers is better. Globally in our setting, 40% of total children had no prescription and there was a high variability in cost explained by physician and center. In paediatric care, the case-mix does not account for so much variability in prescription cost as in adults. Most of the children visited in primary care setting have not serious diseases and there seems to be a different prescription approach according to the physician involved.
It is important to check that the quality of care is not compromised when expenditure is controlled. In fact, family physicians with higher quality scores have lower expenditure and this correlation is improved after adjusting for ACGs. The number of pediatricians studied is very low (N = 12), but still the Spearman rank correlation approaches a significant value. In this case, adjusting for ACG does not improve the correlation. Medications with a long time in the market usually have a lower cost than new drugs. Older medications often have a better known safety and efficacy profile. Because quality is not reduced when prescription cost is low, it might be easier for physicians to accept a control of their expenditure.
In our setting, case-mix, measured with the ACG system, is the variable studied that explains more variability in prescription drug expenditure in adults. In pediatric population there is greater variability among physicians and centers which is not related to case-mix. The implementation of clinical guidelines might be helpful to reduce this variability.
For our sites, ACG is a useful tool to analyze efficiency and compare physicians and centers when data are obtained from electronic records in real conditions of usual practice. It is possible to identify physicians and centers with high expenditure but with a good efficiency index after adjusting for case-mix, and also centers and professionals with apparent low cost but considering their case mix, a lower expenditure would be expected. Physicians with lower pharmaceutical expenditure have higher scores for the prescription quality index studied and in adult population the correlation increases when expenditure is adjusted for ACG.
This study was granted by the Fondo de Investigaciones de la Seguridad Social Instituto de Salud Carlos III, Spanish Ministry of Health (FIS PI052331), and by Catsalut and Jordi Gol i Gurina Foundation, sponsored by Lilly (Primary Care research grant for Costa de Ponent, 2004).
- Pla de Salut de Catalunya 2002-2005. 2003, Barcelona , Generalitat de CatalunyaGoogle Scholar
- Weiner JP, Starfield BH, Steinwachs DM, Mumford LM: Development and application of a population-oriented measure of ambulatory care case-mix. Med Care. 1991, 29 (5): 452-472. 10.1097/00005650-199105000-00006.View ArticlePubMedGoogle Scholar
- The Johns Hopkins University ACG Case-Mix System. [http://www.acg.jhsph.edu]
- Starfield B, Powe NR, Weiner JR, Stuart M, Steinwachs D, Scholle SH, Gerstenberger A: Costs vs quality in different types of primary care settings. JAMA. 1994, 272 (24): 1903-1908. 10.1001/jama.272.24.1903.View ArticlePubMedGoogle Scholar
- Sicras Mainar A: Impacto económico de las enfermedades y pacientes atendidos en atención primaria. Adaptación de los grupos clínicos ajustados (ACGs) en nuestro medio. 2002, Barcelona , University of Barcelona, PhD.Google Scholar
- Estàndard de qualitat de prescripció farmacèutica dels equips d’atenció primària. [http://www.gencat.net/ics/professionals/pdf/eqpf_2007.pdf]
- Nagelkerke NJD: A note on a general definition of the coefficient of determination. Biometrika. 1991, 78 (3): 691-692. 10.1093/biomet/78.3.691.View ArticleGoogle Scholar
- Veazie PJ, Manning WG, Kane RL: Improving risk adjustment for Medicare capitated reimbursement using nonlinear models. Med Care. 2003, 41 (6): 741-752. 10.1097/00005650-200306000-00007.PubMedGoogle Scholar
- Powers CA, Meyer CM, Roebuck MC, Vaziri B: Predictive modeling of total healthcare costs using pharmacy claims data: a comparison of alternative econometric cost modeling techniques. Med Care. 2005, 43 (11): 1065-1072. 10.1097/01.mlr.0000182408.54390.00.View ArticlePubMedGoogle Scholar
- Orueta JF, Urraca J, Berraondo I, Darpon J, Aurrekoetxea JJ: Adjusted Clinical Groups (ACGs) explain the utilization of primary care in Spain based on information registered in the medical records: a cross-sectional study. Health Policy. 2006, 76 (1): 38-48. 10.1016/j.healthpol.2005.04.005.View ArticlePubMedGoogle Scholar
- Sicras-Mainar A: Aplicacion retrospectiva de los grupos clinicos ajustados (ACG) en un centro de atencion primaria. Aten Primaria. 2006, 37 (8): 439-445. 10.1157/13088882.View ArticlePubMedGoogle Scholar
- Isacson D, Haglund B: Heavy users of prescription drugs--mortality and stability in use patterns. Scand J Prim Health Care. 1989, 7 (3): 149-155. 10.3109/02813438909087232.View ArticlePubMedGoogle Scholar
- Serrat Tarres J, Sicras Mainar A, Llopart Lopez JR, Navarro Artieda R, Codes Marco J, Gonzalez Ares JA: Estudio comparativo de la eficiencia, medida a partir de los Ambulatory Care Groups, entre 4 centros de salud. Aten Primaria. 2006, 38 (5): 275-282. 10.1157/13092986.View ArticlePubMedGoogle Scholar
- Tucker AM, Weiner JP, Honigfeld S, Parton RA: Profiling primary care physician resource use: examining the application of case mix adjustment. J Ambul Care Manage. 1996, 19 (1): 60-80.View ArticlePubMedGoogle Scholar
- The pre-publication history for this paper can be accessed here:http://www.biomedcentral.com/1472-6963/8/53/prepub
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/2.0), which permits unrestricted use, distribution, and reproduction in any medium, provided the original work is properly cited.