Data Warehouse Chronic Conditions Data Warehouse 1 Your source for - PowerPoint PPT Presentation

Centers for Medicare & Medicaid Services Chronic Condition Data Warehouse Chronic Conditions Data Warehouse 1 Your source for national CMS Medicare and Medicaid research data

Introduction Module 1 Data Overview In this module, you will learn about the history of the Chronic Conditions Data Warehouse (CCW). Chronic Conditions Data Warehouse 2 Your source for national CMS Medicare and Medicaid research data

History of the CCW This lesson will cover the history of the CCW from its establishment to the present time. Chronic Conditions Data Warehouse 3 Your source for national CMS Medicare and Medicaid research data

Medicare Modernization Act Medicare Modernization Act of 2003, Section 723, mandated a plan to “improve the quality of care and reduce the cost of care for chronically ill Medicare beneficiaries.” Chronic Conditions Data Warehouse 4 Your source for national CMS Medicare and Medicaid research data

CCW Timeline: 2004 to 2005 • CCW Star schema design concept established • Data loading begins with Medicare 5% sample • Eligibility and enrollment records • Fee-for-service claims • Assessments • Unique Beneficiary Identifier, or BENE_ID, is developed Chronic Conditions Data Warehouse 5 Your source for national CMS Medicare and Medicaid research data

CCW Timeline: 2006 to 2007 • 21 chronic conditions algorithms developed • CMS Denominator file assigned BENE_ID • Research summary files developed • Beneficiary Summary file • Chronic Conditions Summary file Chronic Conditions Data Warehouse 6 Your source for national CMS Medicare and Medicaid research data

CCW Timeline: 2006 to 2007 Continued • Encryption/extraction/delivery processes established • Grand opening launched at the Academy Health Annual Research Meeting • www.ccwdata.org released Chronic Conditions Data Warehouse 7 Your source for national CMS Medicare and Medicaid research data

CCW Timeline: 2008 to 2009 • Part D data integrated (2006 forward) • Part D Denominator • Part D Events • Part D Characteristics (Drug Characteristics) • Beneficiary Annual Summary File (BASF) • Analytic “thin” files developed for CMS internal use Chronic Conditions Data Warehouse 8 Your source for national CMS Medicare and Medicaid research data

CCW Timeline: 2010 to 2011 • 100% Medicare Parts A & B Claims back to 1999 • Medicaid MAX data 1999 – 2010 • National Death Index Data 1999 – 2008 • 6 new chronic conditions added Chronic Conditions Data Warehouse 9 Your source for national CMS Medicare and Medicaid research data

CCW Timeline: 2010 to 2011 Continued • Part D data enhancements included more Characteristics Files: • Pharmacy • Plan • Prescriber • Formulary (2010 forward) Chronic Conditions Data Warehouse 10 Your source for national CMS Medicare and Medicaid research data

CCW Timeline: 2012 • Integrated Master Beneficiary Summary File • SAS Metadata Library • Business Intelligence Chronic Conditions Data Warehouse 11 Your source for national CMS Medicare and Medicaid research data

CCW Timeline: 2012 Continued • Data Enclave Pilot • Workbench • Infrastructure Enhancements • Clustered Servers • Up to 2 PB of Storage Chronic Conditions Data Warehouse 12 Your source for national CMS Medicare and Medicaid research data

CCW Timeline: 2013 • Production Virtual Research Data Center (VRDC) Environment • Ccwdata.org Website Re-design Chronic Conditions Data Warehouse 13 Your source for national CMS Medicare and Medicaid research data

CCW Timeline: 2013 Continued • SAS Grid • Stata Software • Improved File Upload/Download • VM Enhancements • CCW Access Request System (CARS) Chronic Conditions Data Warehouse 14 Your source for national CMS Medicare and Medicaid research data

CCW Timeline: 2014 • Over 15 years of 100% linked CMS data (over 325 billion records) • Training and Support Materials • LMS (Learning Management System) • Cost Estimate Application • AMS (Access Monitoring System) • CARS Enhancements Chronic Conditions Data Warehouse 15 Your source for national CMS Medicare and Medicaid research data

CCW Timeline: The Future • CCW Mobile Application • Workbench Enhancements • LMS Enhancements • Additional Materials on Training and Support Materials Webpage • CARS Enhancements • Public AMS Dashboard Chronic Conditions Data Warehouse 16 Your source for national CMS Medicare and Medicaid research data

Questions This module covered the history of the Chronic Conditions Data Warehouse (CCW). Do you have any questions? Chronic Conditions Data Warehouse 17 Your source for national CMS Medicare and Medicaid research data