Pellucid Update

[Joseph Gulotta]

Hello All:

IPRO's Eservices team is currently reviewing CMS' January release of Hospital Compare data.  We will be updating Pellucid and our reporting sites shortly, after rigorous quality checks are conducted.  However, there have been several important data runs that have recently taken place.  Please see the details below to learn more about our updates and changes:

The following updates have been added to pellucid public:
1)    New measures have been added to the measures table.  Subsequent data has also been added for them in the entity_values table.  The measure_ids and their names are as follows:
Composites:
10781     Average Medicare hospital 30-day readmission rates for heart failure, heart attack, and pneumonia
12127     Average Medicare hospital 30-day mortality rates for heart failure, heart attack, and pneumonia
Measures from the Institute of Medicine:
12112     Average HCC Score expressed as a Ratio to the National Average
12113     Percent of Medicare beneficiaries with Diabetes
12114     Percent of Medicare beneficiaries with Heart Failure
12115     Standardized Risk-Adjusted Per Capita Costs
12116     Inpatient Days Per 1000 Beneficiaries
12117     Imaging (IMG) standardized per user Medicare costs
12118     Lab Tests (LABTST) service events per 1000 Medicare beneficiaries
12119     Emergency Department Visits per 1000 Beneficiaries
National and Population Measures:
12066     Average HCC Score as a Ratio to the National Average
12067     Population Per Primary Care Provider
12068     Population Per Specialist Provider
Hospital Acquired Conditions (from CMS)
12044     Foreign object retained after surgery
12045     Air embolism
12046     Blood Incompatibility
12047     Stage III and IV Pressure Ulcers
12048     Falls and Trauma
12049     Vascular Catheter-associated Infection
12050     Catheter-associated Urinary Tract Infection
12051     Manifestations of Poor Glycemic Control
Revenue Percentages (Illinois)
12069     Percent Revenue Medicaid: Hospital Inpatient
12070     Percent Revenue Medicare: Hospital Inpatient
12071     Percent Revenue Other Public Financing: Hospital Inpatient
12072     Percent Revenue Private Insurance: Hospital Inpatient
12073     Percent Revenue Private Pay: Hospital Inpatient
12074     Total Revenue: Hospital Inpatient
12075     Percent Revenue Medicaid: Hospital Outpatient
12076     Percent Revenue Medicare: Hospital Outpatient
12077     Percent Revenue Other Public Financing: Hospital Outpatient
12078     Percent Revenue Private Insurance: Hospital Outpatient
12079     Percent Revenue Private Pay: Hospital Outpatient
12080     Total Revenue: Hospital Outpatient
12081     Percent Revenue Charity Care: Hospital Inpatient
12082     Percent Revenue Charity Care: Hospital Outpatient
Patient Mix (Illinois)
12098     Percent Patients Medicaid: Hospital Inpatient
12099     Percent Patients Medicare: Hospital Inpatient
12100     Percent Patients Other Public Financing: Hospital Inpatient
12101     Percent Patients Private Insurance: Hospital Inpatient
12102     Percent Patients Private Pay: Hospital Inpatient
12103     Percent Patients Charity Care: Hospital Inpatient
12104     Percent Patients Medicaid: Hospital Outpatient
12105     Percent Patients Medicare: Hospital Outpatient
12106     Percent Patients Other Public Financing: Hospital Outpatient
12107     Percent Patients Private Insurance: Hospital Outpatient
12109     Percent Patients Private Pay: Hospital Outpatient
12110     Percent Patients Charity Care: Hospital Outpatient
Select Surgical Infections (Illinois)
12096     Surgical Site Infections Associated with Coronary Artery Bypass Graft Surgery
12097     Surgical Site Infections Associated with Total Knee Replacement Surgery

2)    The public view has been updated to include more pellucid tables.  They include:
Entity_ascs: Illinois-specific.  Consists of entity data on emergency service locations
Entity_calculations: consists of entity data on calculated entities, such as national averages, thresholds and benchmarks
Entity_geographies: entities linked to specific geographic locations, such as counties, states, and hrrs
Entity_home_healths: specific to New York.  Entity data on home health organizations
Entity_hospital_attributes: stores descriptive information on hospitals in a snap-shot format.  Links to entity_hospitals
Entity_nursing_homes: Specific to New York.  Entity data on nursing homes
Entity_physicians: entity data on physicians nation-wide
Entity_physician_attributes: stores descriptive information on physicians in a snap-shot format.  Includes program recognition and specialties
Entity_practices: entity data on practices
Entity_systems: entity data on systems.  Links to the entity_hospitals table by use of the aha_sys_id field
Entity_system_attributes: stores descriptive information on systems in snap-shot format.  Includes hospitals with Integrated Delivery System (IDS) recognition
Measure_authors: Identifies the authors of specific measures.  Links to the author_id field in the measures table
Measure_groups: Identifies the categories and types of measures
Measure_groups_measures: Links the measure_group with the individual measures in a many-to-many relationship
Value_sources: provides information on our sources for specific measures and values

Details on these tables can be found at: https://sites.google.com/a/ipro.us/pelliki/home/pellucid-elsewhere/elsewhere-tables

3)    The quarterly update for the Centers for Medicare and Medicaid Services was integrated into our data in early November.  The most recent data is for the 2010 calendar year for the majority of the measures, and was released by CMS in late October.  To quickly locate all the data added by this update, you can use the following SQL statement:
SELECT * from entity_values where batch_id = ‘CMS20111101’
4)    WNTB CLABSI Data has been updated, and supplemental CMS Medicare data has been integrated into the database
5)    A table called WYdata_application_example20111207 has been added illustrating a practical, potential display for pellucid data.  In the table, we can see all the hospitals for Wyoming, some identifying and attribute data, as well as the values for measures from different data sources.  These measures include: `Overall Recommended Care` (source: IPRO calculated on CMS data), `Percent of Patients Highly Satisfied` (source: CMS quarterly update), `Comprehensive Readmissions Rate` (source: IPRO calculated from CMS data), and `Foreign Object Retained After Surgery` (source: HAC report).
The table and its layout illustrate how our data can be reformatted to serve various purposes in research and reporting.

In order to view these changes or visit pellucid public, please visit pellucid.ipro.org/dba, using the following credentials:
User: public
Password: tryloyw

We anticipate the newest CMS Hospital Compare data to be ready shortly, and we will be sending another announcement email as soon as it is available.

Thanks for your time,
Joe Gulotta
Project Manager
Data Systems
IPRO
Improving Healthcare for the Common Good
= = = = = = = = = =  = = = = = =
1979 Marcus Avenue
Lake Success, NY 11042
direct: (516) 209-5252
main: (516) 326-7767
jos...@ipro.us
http://www.ipro.org