Lemuel R Waitman1, Xing Song1, Dammika Lakmal Walpitage2, Daniel C Connolly3, Lav P Patel3, Mei Liu3, Mary C Schroeder4, Jeffrey J VanWormer5, Abu Saleh Mosa1, Ernest T Anye6, Ann M Davis7,8. 1. Department of Health Informatics, University of Missouri School of Medicine, Columbia, Missouri, USA. 2. Department of Internal Medicine, Enterprise Analytics, University of Kansas Medical Center, Kansas City, Kansas, USA. 3. Division of Medical Informatics, Department of Internal Medicine, University of Kansas Medical Center, Kansas City, Kansas, USA. 4. Division of Health Services Research, Department of Pharmacy Practice and Science, University of Iowa, Iowa City, Iowa, USA. 5. Center for Clinical Epidemiology & Population Health, Marshfield Clinic Research Institute, Marshfield, Wisconsin, USA. 6. Office of Information Security, University of Missouri Health, Columbia, Missouri, USA. 7. Department of Pediatrics, University of Kansas Medical Center, Kansas City, Kansas, USA. 8. Center for Children's Healthy Lifestyles & Nutrition, Kansas City, Missouri, USA.
Abstract
OBJECTIVE: The Greater Plains Collaborative (GPC) and other PCORnet Clinical Data Research Networks capture healthcare utilization within their health systems. Here, we describe a reusable environment (GPC Reusable Observable Unified Study Environment [GROUSE]) that integrates hospital and electronic health records (EHRs) data with state-wide Medicare and Medicaid claims and assess how claims and clinical data complement each other to identify obesity and related comorbidities in a patient sample. MATERIALS AND METHODS: EHR, billing, and tumor registry data from 7 healthcare systems were integrated with Center for Medicare (2011-2016) and Medicaid (2011-2012) services insurance claims to create deidentified databases in Informatics for Integrating Biology & the Bedside and PCORnet Common Data Model formats. We describe technical details of how this federally compliant, cloud-based data environment was built. As a use case, trends in obesity rates for different age groups are reported, along with the relative contribution of claims and EHR data-to-data completeness and detecting common comorbidities. RESULTS: GROUSE contained 73 billion observations from 24 million unique patients (12.9 million Medicare; 13.9 million Medicaid; 6.6 million GPC patients) with 1 674 134 patients crosswalked and 983 450 patients with body mass index (BMI) linked to claims. Diagnosis codes from EHR and claims sources underreport obesity by 2.56 times compared with body mass index measures. However, common comorbidities such as diabetes and sleep apnea diagnoses were more often available from claims diagnoses codes (1.6 and 1.4 times, respectively). CONCLUSION: GROUSE provides a unified EHR-claims environment to address health system and federal privacy concerns, which enables investigators to generalize analyses across health systems integrated with multistate insurance claims.
OBJECTIVE: The Greater Plains Collaborative (GPC) and other PCORnet Clinical Data Research Networks capture healthcare utilization within their health systems. Here, we describe a reusable environment (GPC Reusable Observable Unified Study Environment [GROUSE]) that integrates hospital and electronic health records (EHRs) data with state-wide Medicare and Medicaid claims and assess how claims and clinical data complement each other to identify obesity and related comorbidities in a patient sample. MATERIALS AND METHODS: EHR, billing, and tumor registry data from 7 healthcare systems were integrated with Center for Medicare (2011-2016) and Medicaid (2011-2012) services insurance claims to create deidentified databases in Informatics for Integrating Biology & the Bedside and PCORnet Common Data Model formats. We describe technical details of how this federally compliant, cloud-based data environment was built. As a use case, trends in obesity rates for different age groups are reported, along with the relative contribution of claims and EHR data-to-data completeness and detecting common comorbidities. RESULTS: GROUSE contained 73 billion observations from 24 million unique patients (12.9 million Medicare; 13.9 million Medicaid; 6.6 million GPC patients) with 1 674 134 patients crosswalked and 983 450 patients with body mass index (BMI) linked to claims. Diagnosis codes from EHR and claims sources underreport obesity by 2.56 times compared with body mass index measures. However, common comorbidities such as diabetes and sleep apnea diagnoses were more often available from claims diagnoses codes (1.6 and 1.4 times, respectively). CONCLUSION: GROUSE provides a unified EHR-claims environment to address health system and federal privacy concerns, which enables investigators to generalize analyses across health systems integrated with multistate insurance claims.
Keywords:
Amazon Web Services private cloud; Centers for Medicare and Medicaid Services; PCORnet; Patient-Centered Outcomes Research Institute; cloud computing; electronic health records; obesity
Authors: Paul A Harris; Robert Taylor; Robert Thielke; Jonathon Payne; Nathaniel Gonzalez; Jose G Conde Journal: J Biomed Inform Date: 2008-09-30 Impact factor: 6.317
Authors: Ravi K Madduri; Dinanath Sulakhe; Lukasz Lacinski; Bo Liu; Alex Rodriguez; Kyle Chard; Utpal J Dave; Ian T Foster Journal: Concurr Comput Date: 2014-09-10 Impact factor: 1.536
Authors: Jessica W Lau; Erik Lehnert; Anurag Sethi; Raunaq Malhotra; Gaurav Kaushik; Zeynep Onder; Nick Groves-Kirkby; Aleksandar Mihajlovic; Jack DiGiovanna; Mladen Srdic; Dragan Bajcic; Jelena Radenkovic; Vladimir Mladenovic; Damir Krstanovic; Vladan Arsenijevic; Djordje Klisic; Milan Mitrovic; Igor Bogicevic; Deniz Kural; Brandi Davis-Dusenbery Journal: Cancer Res Date: 2017-11-01 Impact factor: 12.701
Authors: Ryan M Carnahan; Lemuel R Waitman; Mary E Charlton; Mary C Schroeder; Aaron D Bossler; W Scott Campbell; James R Campbell; Bradley D McDowell; Nicholas C Smith; Brian M Gryzlak; Elizabeth A Chrischilles Journal: JCO Clin Cancer Inform Date: 2020-08
Authors: Enis Afgan; Dannon Baker; Nate Coraor; Hiroki Goto; Ian M Paul; Kateryna D Makova; Anton Nekrutenko; James Taylor Journal: Nat Biotechnol Date: 2011-11-08 Impact factor: 54.908
Authors: Shyam Visweswaran; Michael J Becich; Vincent S D'Itri; Elaina R Sendro; Douglas MacFadden; Nicholas R Anderson; Karen A Allen; Dipti Ranganathan; Shawn N Murphy; Elaine H Morrato; Harold A Pincus; Robert Toto; Gary S Firestein; Lee M Nadler; Steven E Reis Journal: JAMIA Open Date: 2018-08-21
Authors: Xing Song; Alan S L Yu; John A Kellum; Lemuel R Waitman; Michael E Matheny; Steven Q Simpson; Yong Hu; Mei Liu Journal: Nat Commun Date: 2020-11-09 Impact factor: 14.919
Authors: Nichelle Cobb; Elizabeth Witte; Maria Cervone; Aaron Kirby; Douglas MacFadden; Lee Nadler; Barbara E Bierer Journal: J Clin Transl Sci Date: 2019-07-29
Authors: Melissa A Haendel; Christopher G Chute; Tellen D Bennett; David A Eichmann; Justin Guinney; Warren A Kibbe; Philip R O Payne; Emily R Pfaff; Peter N Robinson; Joel H Saltz; Heidi Spratt; Christine Suver; John Wilbanks; Adam B Wilcox; Andrew E Williams; Chunlei Wu; Clair Blacketer; Robert L Bradford; James J Cimino; Marshall Clark; Evan W Colmenares; Patricia A Francis; Davera Gabriel; Alexis Graves; Raju Hemadri; Stephanie S Hong; George Hripscak; Dazhi Jiao; Jeffrey G Klann; Kristin Kostka; Adam M Lee; Harold P Lehmann; Lora Lingrey; Robert T Miller; Michele Morris; Shawn N Murphy; Karthik Natarajan; Matvey B Palchuk; Usman Sheikh; Harold Solbrig; Shyam Visweswaran; Anita Walden; Kellie M Walters; Griffin M Weber; Xiaohan Tanner Zhang; Richard L Zhu; Benjamin Amor; Andrew T Girvin; Amin Manna; Nabeel Qureshi; Michael G Kurilla; Sam G Michael; Lili M Portilla; Joni L Rutter; Christopher P Austin; Ken R Gersing Journal: J Am Med Inform Assoc Date: 2021-03-01 Impact factor: 7.942
Authors: Shawn N Murphy; Shyam Visweswaran; Michael J Becich; Thomas R Campion; Boyd M Knosp; Genevieve B Melton-Meaux; Leslie A Lenert Journal: J Am Med Inform Assoc Date: 2022-03-15 Impact factor: 7.942