{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,8,15]],"date-time":"2025-08-15T01:04:25Z","timestamp":1755219865970,"version":"3.43.0"},"reference-count":0,"publisher":"IOS Press","isbn-type":[{"value":"9781643686080","type":"electronic"}],"license":[{"start":{"date-parts":[[2025,8,7]],"date-time":"2025-08-07T00:00:00Z","timestamp":1754524800000},"content-version":"unspecified","delay-in-days":0,"URL":"https:\/\/creativecommons.org\/licenses\/by-nc\/4.0\/"}],"content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":[],"published-print":{"date-parts":[[2025,8,7]]},"abstract":"<jats:p>Integrating heterogeneous healthcare datasets, such as claims and electronic health records, is important for making real-world data analytical-ready but poses challenges due to variations in data structures and clinical terminologies. We developed a systematic Extract, Transform, Load (ETL) pipeline to transform Medicare claims data into the Observational Medical Outcomes Partnership Common Data Model, enabling interoperability and standardized analytics. The ETL process was developed using the ETL-CMS framework and enhanced with updated procedures utilizing open-source ETL tools\u2014WhiteRabbit. Rigorous testing ensured data accuracy and consistency, achieving a 99.2% passing rate in quality check assessment using the Data Quality Dashboard. Comparative analysis demonstrated an accurate representation of demographics and clinical comorbidities, with slight variations attributed to syntactic errors in the source data. This scalable framework fosters interoperability, supports global standards, and enables collaborative clinical research, advancing the integration of diverse healthcare datasets for improved analytics.<\/jats:p>","DOI":"10.3233\/shti251106","type":"book-chapter","created":{"date-parts":[[2025,8,7]],"date-time":"2025-08-07T11:41:14Z","timestamp":1754566874000},"source":"Crossref","is-referenced-by-count":0,"title":["Transforming the Medicare Claims Data to the OMOP Common Data Model"],"prefix":"10.3233","author":[{"ORCID":"https:\/\/orcid.org\/0009-0008-3971-4242","authenticated-orcid":false,"given":"Yao An","family":"Lee","sequence":"first","affiliation":[{"name":"Pharmaceutical Outcomes & Policy, College of Pharmacy, University of Florida, Florida, USA"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Ying","family":"Lu","sequence":"additional","affiliation":[{"name":"Pharmaceutical Outcomes & Policy, College of Pharmacy, University of Florida, Florida, USA"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"ORCID":"https:\/\/orcid.org\/0000-0002-2238-5429","authenticated-orcid":false,"given":"Jiang","family":"Bian","sequence":"additional","affiliation":[{"name":"Biostatistics and Health Data Science, School of Medicine, Indiana University, Indiana, USA"},{"name":"Center for Biomedical Informatics, Regenstrief Institute, Indiana, USA"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"ORCID":"https:\/\/orcid.org\/0000-0001-9799-2592","authenticated-orcid":false,"given":"Jingchuan","family":"Guo","sequence":"additional","affiliation":[{"name":"Pharmaceutical Outcomes & Policy, College of Pharmacy, University of Florida, Florida, USA"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"ORCID":"https:\/\/orcid.org\/0000-0003-0290-8058","authenticated-orcid":false,"given":"Xing","family":"He","sequence":"additional","affiliation":[{"name":"Biostatistics and Health Data Science, School of Medicine, Indiana University, Indiana, USA"},{"name":"Center for Biomedical Informatics, Regenstrief Institute, Indiana, USA"}],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"7437","container-title":["Studies in Health Technology and Informatics","MEDINFO 2025 \u2014 Healthcare Smart \u00d7 Medicine Deep"],"original-title":[],"link":[{"URL":"https:\/\/ebooks.iospress.nl\/pdf\/doi\/10.3233\/SHTI251106","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2025,8,7]],"date-time":"2025-08-07T11:41:15Z","timestamp":1754566875000},"score":1,"resource":{"primary":{"URL":"https:\/\/ebooks.iospress.nl\/doi\/10.3233\/SHTI251106"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2025,8,7]]},"ISBN":["9781643686080"],"references-count":0,"URL":"https:\/\/doi.org\/10.3233\/shti251106","relation":{},"ISSN":["0926-9630","1879-8365"],"issn-type":[{"value":"0926-9630","type":"print"},{"value":"1879-8365","type":"electronic"}],"subject":[],"published":{"date-parts":[[2025,8,7]]}}}