Use of administrative data or clinical databases as predictors of risk of death in hospital: comparison of models

Objective To compare risk prediction models for death in hospital based on an administrative database with published results based on data derived from three national clinical databases: the national cardiac surgical database, the national vascular database and the colorectal cancer study. Design Analysis of inpatient hospital episode statistics. Predictive model developed using multiple logistic regression. Setting NHS hospital trusts in England. Patients All patients admitted to an NHS hospital within England for isolated coronary artery bypass graft (CABG), repair of abdominal aortic aneurysm, and colorectal excision for cancer from 1996-7 to 2003-4. Main outcome measures Deaths in hospital. Performance of models assessed with receiver operating characteristic (ROC) curve scores measuring discrimination (<0.7=poor, 0.7-0.8=reasonable, >0.8=good) and both Hosmer-Lemeshow statistics and standardised residuals measuring goodness of fit. Results During the study period 152 523 cases of isolated CABG with 3247 deaths in hospital (2.1%), 12 781 repairs of ruptured abdominal aortic aneurysm (5987 deaths, 46.8%), 31 705 repairs of unruptured abdominal aortic aneurysm (3246 deaths, 10.2%), and 144 370 colorectal resections for cancer (10 424 deaths, 7.2%) were recorded. The power of the complex predictive model was comparable with that of models based on clinical datasets with ROC curve scores of 0.77 (v 0.78 from clinical database) for isolated CABG, 0.66 (v 0.65) and 0.74 (v 0.70) for repairs of ruptured and unruptured abdominal aortic aneurysm, respectively, and 0.80 (v 0.78) for colorectal excision for cancer. Calibration plots generally showed good agreement between observed and predicted mortality. Conclusions Routinely collected administrative data can be used to predict risk with similar discrimination to clinical databases. The creative use of such data to adjust for case mix would be useful for monitoring healthcare performance and could usefully complement clinical databases. Further work on other procedures and diagnoses could result in a suite of models for performance adjusted for case mix for a range of specialties and procedures.

[1]  A. Hansell,et al.  Accessing and using hospital activity data. , 2001, Journal of public health medicine.

[2]  Nancy J. Petersen,et al.  Mortality After Cardiac Bypass Surgery: Prediction From Administrative Versus Clinical Data , 2005, Medical care.

[3]  J. Poloniecki,et al.  Operative mortality in colorectal cancer: prospective national study , 2003, BMJ : British Medical Journal.

[4]  David W. Hosmer,et al.  Applied Logistic Regression , 1991 .

[5]  J Raftery,et al.  Potential use of routine databases in health technology assessment. , 2005, Health technology assessment.

[6]  A. Bernstein,et al.  A method of uniform stratification of risk for evaluating the results of surgery in acquired adult heart disease. , 1989, Circulation.

[7]  H. Quan ICD-10-CA/CCI coding algorithms for defining clinical variables to assess outcome after aortic and mitral valve replacement surgery. , 2006, The Canadian journal of cardiology.

[8]  S. Bann,et al.  The surgical risk scale as an improved tool for risk‐adjusted analysis in comparative surgical audit , 2002, The British journal of surgery.

[9]  S. Lemeshow,et al.  European system for cardiac operative risk evaluation (EuroSCORE). , 1999, European journal of cardio-thoracic surgery : official journal of the European Association for Cardio-thoracic Surgery.

[10]  N. Black,et al.  Cross sectional survey of multicentre clinical databases in the United Kingdom , 2004, BMJ : British Medical Journal.

[11]  J. Newhouse,et al.  How much change in the case mix index is DRG creep? , 1990, Journal of health economics.

[12]  M. Mckee,et al.  Routine data: a resource for clinical audit? , 1993, Quality in health care : QHC.

[13]  Kimberlee Gauvreau,et al.  Consensus-based method for risk adjustment for surgery for congenital heart disease. , 2002, The Journal of thoracic and cardiovascular surgery.

[14]  J. Cook Hospital activity analysis , 1972, Paraplegia.

[15]  Michael L. Johnson,et al.  Mortality After Noncardiac Surgery: Prediction From Administrative Versus Clinical Data , 2005, Medical care.

[16]  W HUEGIN,et al.  [THE ROLE OF ANESTHESIA IN SURGICAL MORTALITY]. , 1965, Klinische Medizin; osterreichische Zeitschrift fur wissenschaftliche und praktische Medizin.

[17]  M McKee,et al.  Making routine data adequate to support clinical audit , 1994, BMJ.

[18]  D. Hosmer,et al.  A comparison of goodness-of-fit tests for the logistic regression model. , 1997, Statistics in medicine.

[19]  J. Dixon Payment by results—new financial flows in the NHS , 2004, BMJ : British Medical Journal.

[20]  B. Richards,et al.  Computers in Medicine Series , 1974 .

[21]  D. Henson,et al.  The effectiveness of the Heidelberg Retina Tomograph and laser diagnostic glaucoma scanning system (GDx) in detecting and monitoring glaucoma. , 2005, Health technology assessment.

[22]  P. Aylin,et al.  Descriptive study comparing routine hospital administrative data with the Vascular Society of Great Britain and Ireland's National Vascular Database. , 2007, European journal of vascular and endovascular surgery : the official journal of the European Society for Vascular Surgery.

[23]  A. Hossain,et al.  A comparative study on detection of influential observations in linear regression , 1991 .

[24]  B. Keogh Surgery for congenital heart conditions in Oxford , 2005, BMJ : British Medical Journal.

[25]  R. Cook Detection of influential observation in linear regression , 2000 .

[26]  H. Quan,et al.  New ICD-10 version of the Charlson comorbidity index predicted in-hospital mortality. , 2004, Journal of clinical epidemiology.