|Project Title||The Centers for Medicare and Medicaid Services (CMS): Medicare Fee-For-Service (FFS) Claims in Sentinel Common Data Model Format|
Tuesday, October 15, 2019
Sentinel has created the Sentinel CMS DataMart, containing 100% Medicare FFS administrative claims data housed in the Center for Medicare and Medicaid Services' CMS Virtual Research Data Center (VRDC). Duke University Department of Population Health Sciences (DPHS) serves as the Sentinel Data Partner in accessing the source data in the VRDC, transforming it into a Sentinel Common Data Model (SCDM) compliant database, executing queries, and returning results to the Sentinel Operations Center (SOC). There are three components made available to the public: (1) Program Specifications; (2) Code pack; and (3) User Guide.
1. Program Specifications: Describes the required extraction, transformation, and loading (ETL) processes and mappings specific to Medicare FFS source data from 2010 through 2018. This document consists of the following sections:
Except as related to implementation within the Medicare FFS data, the specification document does not otherwise discuss the rationale or content of the SCDM.
As guiding principles, the processes and programs created to accomplish this ETL should be flexible and extensible. This includes attributes such as the ability to handle different kinds of ETLs (e.g., incremental build v. full rebuild), the ability to create intermediate files that can be easily reused in a subsequent ETL, and the ability to easily add new Medicare data sources into the process.
2. Code Pack: Includes the following features:
3. User Guide: Includes information on how to use the code pack, along with some guidance on managing use by researchers who will likely have different source files available. The target audience for this document is researchers who wish to create SCDM-compliant tables using Medicare FFS data. While the programs in the Code Pack documented above are specific to the processing of the 100% Medicare data within the VRDC, we anticipate that the mapping information, specifically, will be of use to all researchers.
The associated files on this site are for Sentinel CMS ETL version five utilizing SCDM version 7.0.0., approved by Sentinel in August 2019.
|Population / Cohort||
People age 65 and older and people under age 65 with certain disabilities
January 1, 2010 – December 31, 2018
Brad Hammill, DrPh; Department of Population Health Sciences, Duke University School of Medicine, Durham, NC
Judith Maro PhD; April Duddy MS; Department of Population Medicine, Harvard Pilgrim Health Care Institute and Harvard Medical School, Boston, MA
Robert Rosofsky MA; Health Information Systems Consulting LLC, Milton, MA
Jessica Pritchard, PhD; Department of Population Health Sciences, Duke University School of Medicine, Durham, NC
SCDM-formatted Medicare FFS Claims Data
- Vaccines, Blood & Biologics
- Devices and Radiologic Health