Data Changelog

2018-05-02:

Added new batch of CMS hospital data to pellucid

Generally the new data covers 17Q1 - 17Q4

Data affects footnotes_values and entity_values

2018-02-20:

Added new batch of CMS hospital data to pellucid

Generally the new data covers 16Q4 - 17Q3

Data affects footnotes_values and entity_values

2017-11-03:

Added new batch of CMS hospital data to pellucid

Generally the new data covers 16Q3 - 17Q2

Data affects footnotes_values and entity_values

2017-08-28:

Added new batch of CMS hospital data to pellucid

Generally the new data covers 16Q2 - 17Q1

Data affects footnotes_values and entity_values

2017-05-23:

Added new batch of CMS hospital data to pellucid

Generally the new data covers 16Q1 - 16Q4

Data affects footnotes_values and entity_values

2017-02-15:

Added new batch of CMS hospital data to pellucid

Generally the new data covers 15Q4 - 16Q3

Data affects footnotes_values and entity_values

2016-11-01:

Added new batch of CMS hospital data to pellucid

Generally the new data covers 15Q3 - 16Q2

Data affects footnotes_values and entity_values

2016-08-22:

Added new batch of CMS hospital data to pellucid

Generally the new data covers 15Q2 - 16Q1

Data affects footnotes_values and entity_values

2016-08-16:

Added new batch of CMS hospital data to pellucid.

Generally, the new data covers 14Q4 through 15Q3

Data affects footnotes_values and entity_values

2016-07-14:

Added 94 new home healths to pellucid
affects the entities and entity_home_health tables

Closed 252117 based on becky's recommendations

2016-05-10:

Added new CMS Home Health Compare Data to pellucid2

503000 new entity_values rows

140000 new footnotes_values rows

batch_id = 'CMSHH14Q4_15Q3'

2016-04-30:

Added new Nursing Home Compare data to pellucid2.

1000000 new entity_values rows added

25000 footnotes_values rows added

batch_id = 'CMSNH20160201'

2016-02-09:

Inserted newest CMS Dialysis Facility run into pellucid2

Affects 118000 rows in entity_values

Affects 21000 rows in footnotes_values

batch_id = 'CMSDF20160201'

2016-02-08:

Inserted 32 new entity_clinics for NY into the entities and entity_clinics tables

Information verified and sent by the NY DOH

2016-02-05:

Brought over newest Nursing Home Compare data to pellucid.

Approximately 1,100,00 entity_values rows

Approximately 25,000 footnotes_values rows

2016-02-04:

Added 5 new measures for Star Ratings for Home Health data (HHCompare)

17232
HH55
Home health patient experience survey summary star rating

17233
HH56
Star Rating for health team gave care in a professional way

17234
HH57
Star Rating for health team communicated well with them

17235
HH58
Star Rating team discussed medicines, pain, and home safety

17236
HH59
Star Rating for how patients rated overall care from agency

2016-01-29:

Added 67 new entities for home_healths starting with entity_id 1167196: Found through CMS Home Health Compare update

Added 51 new dialysis_facilities starting with entity_id 1167263: Found through CMS Dialysis Facilities Compare update

Added 36 new entities for nursing_homes starting with entity_id 1167160: Found through CMS Nursing Home Compare update

        Closed 9 nursing homes that are no longer reporting to CMS where entity_id in (227170,261208,236367,236515,238025,1166965,1166972,1160420,1166967)

2016-01-26:

Updated the names descriptions and default units of 124 measures where it had previously referred to "patients" when it should have said "cases". The measures include number of cases by MS-DRG, number of cases by CCS and number of medicare cases by MS-DRG

Updates were run in pellucid2.measures and pellucid_wntb,measures.

All entity_values related to these measures  had their units updated as well.

2015-12-15:

Added 12 new hospitals based on most recent CMS Hospital Data Compare: 

1167119 ST VINCENTS BLOUNT ONEONTA AL
1167120 DIGNITY HEALTH - ARIZONA GENERAL HOSPITAL LAVEEN AZ
1167121 LOMA LINDA UNIVERSITY CHILDREN'S HOSPITAL LOMA LINDA CA
1167122 HOLY CROSS GERMANTOWN HOSPITAL GERMANTOWN MD
1167123 MERCY HOSPITAL CARTHAGE CARTHAGE MO
1167124 LEWIS COUNTY GENERAL HOSPITAL LOWVILLE NY
1167125 CAPE FEAR VALLEY HOKE HOSPITAL RAEFORD NC
1167126 BLUE RIDGE REGIONAL HOSPITAL, INC SPRUCE PINE NC
1167127 TITUSVILLE HOSPITAL TITUSVILLE PA
1167128 PIONEER COMMUNITY HOSPITAL OF SCOTT ONEIDA TN
1167129 MEDICAL CENTER OF ALLIANCE FORT WORTH TX
1167130 PEARLAND MEDICAL CENTER PEARLAND TX

2015-10-28:

Introduced CMS NH data to pellucid2.  Over 1,000,000 rows of entity_values data and 25,000 footnotes_values rows introduced with the batch_id = 'CMSNH14Q315Q2'

2015-09-23:

Updated measures 12307, 12308, and 12309 to include IQR sig_var_nations for historical batch CMS20150101.  Missing sig_vars came to light as a result of digestible dev inspection of historical measure display

2015-09-11

For Average Covered Charges (author_id AVGcovCHARGE_MSDRG_XXX) and Average Medicare Payment (author_id AVGtotPAYMENT_MSDRG_XXX) measures I removed the text “(MS-DRG XXX)” from the end of the description_friendly field of the table and updated the other “DRG XXX” to “MS-DRG XXX”.

2015-09-08:

Removed the text;

"Hospital list prices (more commonly referred to as gross charges) are standard prices established by hospitals each year for all services. All patients are charged the same list price for the same service before applying discounts. The median refers to the midpoint of all charges. Charges are for facility services and accommodation and may not include physician or surgeon fees."

from any measures description_friendly where is was present. (measure IDs 15658, 15547, 15982, 15981, 15637, 15536, 15885, 15698, 15861, 15887, 15965, 16000, 16061, 16067, 16097, 15617, 15616, 15615, 15716, 15755, 16001, 15539, 16053, 15924, 15988, 14201, 14234, 14237, 14251, 14252, 14838, 14864, 14942, 14977, 15038, 15044, 15074, 14301, 14334, 14337, 14351, 14352, 10640, 10649, 10638, 10639, 10642, 10643, 10646, 10650, 10647, 10641, 10644, 10637, 12092, 10645)

2015-09-04:

updated 850 entity_dialaysis facilities to include a leading zero in their MPN

      This update affected pellucid2 and pellucid_wntb

2015-09-02:

Inserted new CMS data into pellucid2 and pellucid_wntb
-updated 900,000 rows in entity_values, batch_id like 'CMS20150901%'
-updated 815,000 rows in footnotes_values, batch_id = 'CMS20150901'

2015-08-25: Edited 1450 measures to remove a microsoft-specific spacing character that caused problems with display for projects.  This character only needed to be replaced with spaces.  Measures_copy and measures_copy_copy were created, but will be removed once we are confident they are not needed further

2015-08-19: Removed approximately 350 measures from the measures table that have not been populated with data since their creation

2015-08-05: Imported 1,000,000 rows for entity_values and footnotes_values batch_id = 'CMSNH20150801' 

2015-08-04: Updated entity_uccs with data from Oleg and the dev team.  Added approximately 6000 rows to entities and entity_uccs.  Entity_ids between 1161142 and 1166321

2015-08-03: added 43 nursing homes to pellucid2 and pellucid wntb (affects entities and entity_nursing_homes -comes as a result of updated data from CMS nursing home compare quarterly release)

Also closed 14 nursing homes (227126 227141 230544 230892 261207 261198 261195 261201 261202 239378 239379 239380 239381 240121)

• updated QI measures to reflect correct author_measure_id 
• removed any mention of RA/O/OE [ed: from where?]and just have them match the author denoted QI tag
• IQI/PSI/PDI/PQI/NQI etc [ed: more detail here]

2015-07-22: Added 2 measures for CMS compare data: 

• PAYM_30_HF Payment for heart failure patients 17208
• PAYM_30_PN Payment for pneumonia patients 17209

Added 2 Home health footnotes from CMS data:

• 147 There were problems with the data and they are being corrected.
• 148 This measure currently does not have data or provider has been certified/recertified for less than 6 months.

2015-07-20: Added 98 new home_healths to entities and entity_home_healths based on most recent CMS Home Health Compare Data release

2015-07-17: Added 3 Measures for use with Home Health Compare Data

• 261170 Home Health Quality of Patient Care Star Rating
• 261171 How often patients, with a recent hospital stay, had to be re-admitted to the hospital
• 261172 How often patients, with a recent hospital stay, received care in the hospital emergency room without being re-admitted to the hospital

2015-07-13:

Updated ny entity_hospital_attributes by removing old ones and inserting new rows for NY hospitals services, opcerts, and bed data

2015-07-10:

Reorganized measures table to include http:// where applicable for author_measure_specs field.  Previously, it had not been consistent

2015-07-02:

Added entity_physician_locations table.  Tracks all combinations of entity_ids and addresses.  Keeps track of all addresses where a physician operates.  Over 2 million rows added

2015-07-01:

Retired old physicians setup.  Renamed entity_physicians to entity_depricated_physicians.  New physicians table created using CMS Physician Compare data.  Structure is completely changed, and physicians page will be updated to reflect this shortly.  Over 900,000 physicians rows updated or added.  Old entity_ids archived as depricated_physicians

Also retired physicians attributes.  Old table renamed entity_depricated_physician_attributes.  New attributes added for CCN and specialties.  Over 2 million rows of data added for this table.  Structure remains unchanged

2015-06-30:

Added entity_uccs table to pellucid2.  This may or may not be used publicly for ucc geolocation apps.  Yet to be decided if the data will be added to public, but structure details to be added shortly

2015-06-15:

Inserted regional IL data for PNU readmissions area rates

batch_id = 'ILpnuregions20150615'

2015-06-12:

TK provided updated data for VTE measures that handles less_is_better evidence for composite.  This affects and updates data for STK, AMI, and other PROCESS of CARE measure calculations.  Batch_id for this update is 'CMS20150501STKAMIVTEpatch'

2015-06-10: 

The Following Batch_ids were inserted with updates and corrections for IL data:

2015-06-03:

Corrected Breast Feeding Data inserted for IL state under batch_id 'IL_BF_20150603'

2015-05-29:

Added IL Area level Risk Adjusted PQI data from becky.

Batch_id = 'IL_rapqi20150529'

2015-05-28:

Added new NY Maternity Data using Maternity_2015-05-26

Added patches to CMS data that include benchmarks and missing calculations:2015-05-20:

Batch_ids are 

2015-05-11:

Added IL CT Scan data using batch_id = 'ILCT_20150511'

Updated CMS Hospital data, now has the batch_id = 'CMS20150501rerun'

2015-05-08:

Uploaded 1,000,000 rows of new CMS data to pellucid.  Corresponds with date range 2013-07-01 to 2014-06-30, and has been assigned the batch_id 'CMS20150501'

Also uploaded 900,000 footnotes rows with the same batch_id

Created 280 new entity_calculations.  Entity_ids between 261212 and 261491.  These are given to state and US territory averages for Low/Moderate/High/Very High/All volume hospitals.

2015-05-05:

Updated pellucid and alpha with new Illinois CDiff and MRSA data provided by IDPH

Measure 17200 added for H_STAR_RATING, the star rating value for all HCAHPS measures

2015-05-04:

Uploaded 1,000,000 new rows of data for CMS Nursing Home Compare.  Date range is CY2014.

Batch_id = 'CMS_NH20150501'

Updated pellucid and alpha with new Illinois CLABSI data provided by IDPH

2015-05-01:

400000 entity_values and 90000 footnotes_values added for refresh of CMS HH compare.

Affects pellucid and pellucid_wntb.  Entities and Entity_home_healths brought over to pellucid_wntb as well

Added 42 new nursing_homes to the entity_nursing_homes table (entity_ids 261170 through 261211).  Closed 7 older ones with outdated MPNs

These changes were made based on analysis of the CMS Nursing Home Compare Data release

2015-04-29

New data added for IL AHRQ QI and OS/IS data. Batch_id = 'ILAHRQ_QI_OS20150430'

2015-04-27:

Added 31 hospitals to pellucid and pellucid_wntb based on TKs CMS run.  These hospitals had previously unrecorded mpn_ids

2015-04-24:

Added the following to entity_calculations to be used across all measures
"261061";"Average among “Very High” volume hospitals"
"261062";"Average among “High” volume hospitals"
"261063";"Average among “Moderate” volume hospitals"
"261064";"Average among “Low” volume hospitals"
"261065";"Average among All volume hospitals"

added 72 home healths to entity_home_healths based on HHcompare
-changes made to pellucid and p_wntb

Added 400 rows of data for manged care measure values.

(39 mcos accross 11 measures, some not reported)
batch_id = 'NY_mco_consumer_guide2014'

2015-04-23:

Created 36 new entities for MCOs in NY

also created 36 new entity_mcos for NY:

261022,Univera Healthcare: Commercial HMO
261023,HIP (EmblemHealth): Commercial HMO
261024,HIP (EmblemHealth): Commercial PPO
261025,HIP (EmblemHealth): Medicaid Managed Care
261026,Independent Health: Commercial HMO
261027,Independent Health: Medicaid Managed Care
261028,MVP Health Care: Commercial HMO
261029,MVP Preferred PPO: Commercial PPO
261030,MVP Health Care: Medicaid Managed Care
261031,CDPHP: Commercial HMO
261032,CDPHP Universal Benefits, Inc.: Commercial PPO
261033,CDPHP: Medicaid Managed Care
261034,MetroPlus Health Plan: Medicaid Managed Care
261035,HealthNow New York Inc.: Commercial HMO
261036,HealthNow New York Inc.: Medicaid Managed Care
261037,Aetna: Commercial HMO
261038,Aetna Life Insurance Company - New York: Commercial PPO
261039,Oxford Health Plans of New York: Commercial HMO
261040,Oxford Health Insurance of New York: Commercial PPO
261041,CGLIC/CHLIC: Commercial PPO
261042,WellCare of New York: Medicaid Managed Care
261043,UnitedHealthcare Community Plan: Medicaid Managed Care
261044,UnitedHealthcare Insurance Company of New York, Inc.: Commercial PPO
261045,Empire BlueCross BlueShield HMO: Commercial HMO
261046,Empire BlueCross BlueShield PPO: Commercial PPO
261047,Excellus Blue Cross BlueShield: Commercial HMO
261048,Excellus Blue Cross BlueShield: Medicaid Managed Care
261049,Easy Choice Health Plan of NY: Commercial HMO
261050,Affinity Health Plan: Medicaid Managed Care
261051,Total Care, Today's Options of New York Health Plan: Medicaid Managed Care
261052,Fidelis Care New York, Inc.: Medicaid Managed Care
261053,Healthfirst PHSP, Inc.: Medicaid Managed Care
261054,HealthPlus, an Amerigroup Company: Medicaid Managed Care
261055,Univera Community Health: Medicaid Managed Care
261056,GHI (EmblemHealth): Commercial PPO
261057,Hudson Health Plan: Medicaid Managed Care

Created over 500 attributes for these new mcos, including:
counties served,
ncqa_status
enrollment

Created new measures for these mcos as well
17189:Adult Care MCO
17190:Cardiovascular Care MCO
17191:Care for Respiratory Conditions MCO
17192:Child and Adolescent Care MCO
17193:Diabetes Care MCO
17194:Maternal Health MCO
17195:Mental Health MCO
17196:Satisfaction with Adult Care MCO
17197:Satisfaction with Children's Care MCO
17198:Women's Preventive Care MCO
17199:Overall Care for Managed Care Organization MCO

Created a new measure_group for these measures:
measure_group_id: 144, MCO measures

2015-04-22:

Updated pellucid and alpha with new Illinois breast feeding data provided by IDPH

2015-04-21:

Updated pellucid and alpha with new Illinois hospital designations that were provided by IDPH

2015-04-20:

Updated pellucid and alpha with new Illinois nurse staffing and Emergency Department data provided by IDPH

Updated pellucid and alpha with Illinois hospital and ascs data provided by IDPH

2015-04-16:

Added Measure_id 17188, Emergency Department Volume to the measures table.  Tracks volume of patients seen by the Emergency Department of a Hospital as submitted through CMS

2015-04-07:

added dialysis measures to pellucid, pellucid_wntb, nyprofiles
(17171, 'Dialysis Facility Five-Star Rating'),
(17172, 'Percentage of Adult Medicare Hemodialysis Patients with Kt/V >=1.2'),
(17173, 'Percentage of Pediatric Medicare Hemodialysis Patients with Kt/V>=1.2'),
(17174, 'Percentage of Adult Medicare Peritoneal Dialysis Patients with Kt/V>=1.7'),
(17175, 'Percentage of dialysis patients with Hgb <10 g/dL'),
(17176, 'Percentage of Medicare Dialysis Patients who had an average ESA-Treated Hemoglobin Greater than 12.0 g/dL'),
(17177, 'Percentage of Medicare Hemodialysis Patients with Arteriovenous Fistulae in Place'),
(17178, 'Percentage of Medicare Hemodialysis Patients with Vascular Catheter in use for 90 Days or Longer'),
(17179, 'Standardized Mortality Ratio'),
(17180, 'Standardized Hospitalization Ratio'),
(17181, 'Standardized Transfusion Ratio'),
(17182, 'Percentage of Adult Patients with Hypercalcemia'),
(17183, 'Percentage of Adult Patients with Serum Phosphorus less than 3.5 mg/dL'),
(17184, 'Percentage of Adult Patients with Serum Phosphorus between 3.5-4.5 mg/dL'),
(17185, 'Percentage of Adult Patients with Serum Phosphorus between 4.6-5.5 mg/dL'),
(17186, 'Percentage of Adult Patients with Serum Phosphorus between 5.6-7.0 mg/dL'),
(17187, 'Percentage of Adult Patients with Serum Phosphorus greater than 7.0 mg/dL')

Added the following Dialysis Facilty Compare footnotes
140;The number of patients is too small to report.
141;The facility does not provide hemodialysis to pediatric patients
142;CMS determined that the percentage was not accurate.
143;The facility does not provide hemodialysis
144;The facility does not provide peritoneal dialysis.
145;Not enough quality measure data to calculate a star rating
146;CMS determined that at least one measure included in the star rating calculation was not accurate for this facility

2015-03-30: 

Created a table for entity_dialysis_facilities and imported 6000 rows of data for it

2015-03-23:

updated pellucid and pellucid_wntb with new geographic variation data created by becky for IOM measures

2015-03-12:

 located duplicate entries in entity_home_healths

-home health lhcsa 

-closed 312 duplicate home healths based on created date and max(entity_id)

-closed_date set to '2015-03-12' should they need to be reversed

2015-03-04

Added batch_id to Becky's 4 most recent Home health CMS runs.

Added the data to pellucid2.entity_values and pellucid2.footnotes_values
-a bug was detected where percentile was missing for most recent batch
-she wanted to include ranking information in the values rows
-was best to just rerun entirely and replace
batch_id = 'CMS_HH20150301update'

2015-02-26

updated pellucid2 with new NH rerun data that becky ran
over 3 million entity_values rows
about 1 million footnotes_values rows
affects previous 3 date ranges
batch_id = 'CMS_NHrerun20150226'

2015-02-23

added new footnotes for
physical therapy staffing values
staffing values
for nursing home compare

2015-02-17:

Added 10 new hospitals based on LF Roster additions

select * from entity_hospitals where entity_id between 254683 and 254692

2015-02-10:

Added new CMS nursing home compare data to pellucid.  Relevant date range: 2013-10-01 to 2014-09-30

Batch_id = 'CMSNH20150201'

2015-02-09:

Added 2 new footnotes:
134 "This agency provides services to a special needs population."
135 "This agency provides services under a federal waiver program to non-traditional, chronic long term population."

2015-02-05:

Added 83 new nursing_homes to entity_nursing_homes based on CMS NH Compare data run

2015-02-03:

Replaced ED Acuity data for regional IL data

2015-01-27:

Added the following 3 measures:
-17168 CDI not my hospital
-17169 CDI possibly my hospital
-17170 Risk Adjusted CDI

2015-01-22:

Uploaded additional benchmark data to pellucid and pellucid_wntb.  This data has the batch_id 'CMS20150101_benchmarks' and is a supplement to 'CMS20150101'.  Overall, 80,000 entity_values rows and 200,000 footnotes_values rows were added

2015-01-15

Uploaded 900,000 ev rows and 800,000 fv rows to pellucid and pwntb

Uploaded 30,000 ev rows and 30,000 fv rows to il database

All data associated with CMS data upload and given batch_id = 'CMS20150101'

2015-01-14
uploaded IL observed PQI data striated by race (originally created by becky) to pellucid and IL map databases
Approximately 2600 rows added with the batch_id 'IL_opqi20150114'

Inserted new complaints data for NY as provided by NYDOH and John, measures 16501,16505,16506

2015-01-13

Added the following measures to pellucid, idph, idph dev and live maps

(17162, 'Observed Asthma in Younger Adults'),
(17163, 'Observed Uncontrolled Diabetes'),
(17164, 'Observed Short Term Complications of Diabetes'),
(17165, 'Observed Lower Extremity Amputations'),
(17166, 'Observed Long Term Complications of Diabetes'),
(17167, 'Observed COPD or Asthma in Older Adults');

2015-01-12

approximately 80 new hospitals added to pellucid2 and pellucid_wntb
entity_id between 254446 and 254526

2015-01-08:

created new measure for hcahps composite (17161)

2015-01-05:

Created and uploaded IL KPRO and CABG infections data into pellucid2 and alpha

batch_id = 'IL_CABGKPRO2013'

2014-12-30:

 Updated IL map data for Asthma, pediatric asthma, Diabetes (all, payer, and race)

Added new IL data for ED charges and Emergency Department rates

batch_id = 'ILED20141230', date range = '2011-01-01' to '2013-12-31'

2014-12-22:

Added the following to measures:

17159, PAYM_30, Payments for heart attack patients
17160, STK-10, Ischemic or hemorrhagic stroke patients who were evaluated for rehabilitation services

2014-12-22: Added the following hospitals to p2 and pwntb

"entity_id","name"

"254387","TEMECULA VALLEY HOSPITAL"

"254388","COLLEGE MEDICAL CENTER"

"254389","POINCIANA MEDICAL CENTER"

"254390","ST VINCENTS MEDICAL CENTER - CLAY COUNTY INC"

"254391","PALMETTO HEALTH BAPTIST PARKRIDGE"

 "254392","CRESCENT MEDICAL CENTER LANCASTER"

2014-12-22:  Added the following measures based on CMS changes and data additions:

"measure_id","author_measure_id","name_friendly"
"17150","READM_30_STK ","Stroke (STK) 30-Day Readmission Rate "
"17151","READM_30_COPD ","Chronic Obstructive Pulmonary Disease (COPD) 30-Day Readmission Rate "
"17152","MORT_30_COPD ","Chronic Obstructive Pulmonary Disease (COPD) 30-Day Mortality Rate "
"17153","MORT_30_STK ","Acute Ischemic Stroke (STK) 30-Day Mortality Rate "
"17154","H_COMP_7_A ","Patients who ""Agree"" they understood their care when they left the hospital "
"17155","H_COMP_7_D_SD ","Patients who ""Disagree"" or ""Strongly Disagree"" they understood their care when they left the hospital "
"17156","H_COMP_7_SA ","Patients who ""Strongly Agree"" they understood their care when they left the hospital "

2014-12-15:  Added 1 new nursing homes and closed 32 based on information from NYDOH.  Used the following to close:

update entity_nursing_homes set closed_date = '2014-12-01'
where entity_id in (150305,150329,150717,150416,150560,150720,153980,150536,150909,150349,150552,150376,150290,
150473,150565,150542,150328,150689,150776,150516,150398,150789,150608,150303,241655,153982,
150399,150845,241169,241576,150551,150684);

2014-12-09: Added the following measures based on the County Health Rankings 2014 data (for area level reporting)

17128 Drug Poisoning Deaths
17129 Premature Age-adjusted Mortality
17130 Other Primary Care Providers
17131 Ratio of Population to Other Primary Care Physicians

2014-12-08: Updated data from CHR2014 for IL measures 16505, 16411, and 12377.  Data also needs to be moved to dev_idph and live_idph RDS sites

2014-12-04: Added 3 new measures for NQI measures:

17125 NQI_1 Neonatal Iatrogenic Pneumothorax Rate

17126 NQI_2 Neonatal Mortality Rate 

17127 NQI_3 Neonatal Blood Stream Infection Rate

2014-11-24: Uploaded data for Stroke and Blood Clot composites for the most recent CMS Batch (batch_id = 'CMS20140801comp_stk_vte').  Added these measures to talend checks

2014-11-20:  Introduced 2 new composite measures for CMS data:

17123: Overall Stroke Care (COMP_STK)

17124: Overall Blood Clot Care (COMP_VTE)

2014-11-07: Reuploaded Home Health data with small bugs for composites and measure_id 17119 fixed.  Batch_id = 'CMS_HH20141101rerun'

2014-11-05:  Added Home Health compare data to pellucid from CMS (batch_id = 'CMS_HH20141101')

2014-11-03:  Added NH compare from CMS update (batch_id = 'CMS_NH20141101')

2014-10-31: Reuploaded HCAHPS and EDT CMS data from CMS20140801, which now includes sig_var_state

2014-10-29: Introduced sig_var_state to HCAHPS and EDT measures for the most recent CMS run ('CMS20140801%')

2014-10-22: Removed Duplicate home healths from pellucid. These duplicates were created during the CMS home_health data run and were caused by MPN mismatches. They seem specific to NY and have been saved in the even of a conflict with NYSprofiles data issues in the following tables:

joseph.entity_values_deleted20141021
joseph.footnotes_values_deleted20141021
joseph.entity_home_healths_attributes_deleted20141021
joseph.entity_home_healths_deleted20141021

2014-10-15: CMS states that it will not be issuing a full quarterly update in October, instead they will only be updating Value Based Purchasing and Cost Per Patient Measures

2014-10-01: Reupload of home_health attributes due to edits made by NYS

2014-09-30: Initial import of CMS home health compare data set. Leads to the creation of over 12000 home health rows nationwide

2014-09-23: It is decided that all edits made to attributes will require a wipe and a reupload, instead of pairing/matching existing attributes and inserting new. The only exception to this exists when there are minimal additions or value edits to a handful of rows

2014-08-13: update national values for OE PSIs and OE IQIs displayed on NYProfiles to have a denominator of 30 and a value of 1.  This was to have them display properly on the app

2014-08-11:  Replaced TKs CMS nursing home data (date_end = '2014-03-31') with updated values.  This was primarily due to a bug in the code that produced reversed rankings and percentiles.  New rows fixed this and provide data that includes new ranking and percentile data.  This bug only affects pellucid and NYSprofiles databases (dev, preview, and live)

2014-08-01:  Added measures 17088 through 17108.  They are new measures for NYDOH.  They are  very similar in title to CMS measures for NH, by NYDOH addes extra levels to the calculations (risk-adjustment of some measures, etc).  John feels it is best to store separately because of calculation differences.  They have been added to measure group 164 and should not be confused with the CMS Nursing home measures, group 163

2014-07-24

Generated reports for values having a difference over 25% since last run, and their measure and entity_id distribution (file: 25percentdiffinvalues.xls)

Generated report showing measures where the threshold value is equal to the average value (should not be) and the value is not 0 or 100.  TK is reviewing

Generated reports for null counts by entity and null counts by measure (files: null_byentity_newandold20140801.xls and null_bymeasure_newandold20140801)

Generated reports showing the count of nulls to the total count for both measures and entities

Current issues uncovered: HCAHPS data does not have sig_var_nation generated: Resolved

2014-07-22:

Added 2 nursing homes: 

241576 St Josephs Hospital

241577 Vestal Park Rehabilitation and Nursing Center

Closed 6 nursing homes:

150290 Erie County Home

150315 Vestal Park Rehabilitation and Nursing Center

150329 Arnot-Ogden Medical Center Residential Health Care Facility

150416 Blossom South Nursing and Rehabilitation Center

150542 Kinney Nursing Home

Updated home_healths using the following files from John Schoneboom sent 2014-07-22:

homes_health_not_in_pellucid, home_health_update, home_health_not_in_doh (See attached to this page)

2014-07-22:

Eight new hospitals introduced into pellucid2 based on data found in the CMS file.  Their entity_ids and information is as follows:

241172 CASTLE ROCK ADVENTIST HOSPITAL
241173 METHODIST HEALTHCARE - OLIVE BRANCH HOSPITAL
241174 KAISER FOUNDATION HOSPITAL - WESTSIDE
241175 LANDMARK HOSPITAL OF SALT LAKE CITY LLC
241176 LONE PEAK HOSPITAL
241177 SCOTT & WHITE EMERGENCY HOSPITAL AT CEDAR PARK
241178 SCOTT & WHITE HOSPITAL- COLLEGE STATION

241179 NIX COMMUNITY GENERAL HOSPITAL

Added the following measures from CMS update: