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

▶
data warehouse
SMART_READER_LITE
LIVE PREVIEW

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

May 30, 2023 237 likes •420 views

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

slide-1
SLIDE 1

Chronic Conditions Data Warehouse

Your source for national CMS Medicare and Medicaid research data

1

Centers for Medicare & Medicaid Services

Chronic Condition Data Warehouse

slide-2
SLIDE 2

Chronic Conditions Data Warehouse

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).

2

slide-3
SLIDE 3

Chronic Conditions Data Warehouse

Your source for national CMS Medicare and Medicaid research data

History of the CCW

3

This lesson will cover the history of the CCW from its establishment to the present time.

slide-4
SLIDE 4

Chronic Conditions Data Warehouse

Your source for national CMS Medicare and Medicaid research data

Medicare Modernization Act

4

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.”

slide-5
SLIDE 5

Chronic Conditions Data Warehouse

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

5

slide-6
SLIDE 6

Chronic Conditions Data Warehouse

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

6

slide-7
SLIDE 7

Chronic Conditions Data Warehouse

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

7

slide-8
SLIDE 8

Chronic Conditions Data Warehouse

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

8

slide-9
SLIDE 9

Chronic Conditions Data Warehouse

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

9

slide-10
SLIDE 10

Chronic Conditions Data Warehouse

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)

10

slide-11
SLIDE 11

Chronic Conditions Data Warehouse

Your source for national CMS Medicare and Medicaid research data

CCW Timeline: 2012

  • Integrated Master Beneficiary Summary File
  • SAS Metadata Library
  • Business Intelligence

11

slide-12
SLIDE 12

Chronic Conditions Data Warehouse

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

12

slide-13
SLIDE 13

Chronic Conditions Data Warehouse

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

13

slide-14
SLIDE 14

Chronic Conditions Data Warehouse

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)

14

slide-15
SLIDE 15

Chronic Conditions Data Warehouse

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

15

slide-16
SLIDE 16

Chronic Conditions Data Warehouse

Your source for national CMS Medicare and Medicaid research data

  • CCW Mobile Application
  • Workbench Enhancements
  • LMS Enhancements
  • Additional Materials on Training and Support Materials Webpage
  • CARS Enhancements
  • Public AMS Dashboard

CCW Timeline: The Future

16

slide-17
SLIDE 17

Chronic Conditions Data Warehouse

Your source for national CMS Medicare and Medicaid research data

This module covered the history of the Chronic Conditions Data Warehouse (CCW).

Do you have any questions?

Questions

17