Inserted new CMS data into pellucid2 and pellucid_wntb
Pellucid data update#
This update affected pellucid2 and pellucid_wntb Updated 850 entity_dialaysis facilities to include a leading zero in their MPN Charges are for facility services and accommodation and may not include physician or surgeon fees."įrom any measures description_friendly where is was present. The median refers to the midpoint of all charges. All patients are charged the same list price for the same service before applying discounts. "Hospital list prices (more commonly referred to as gross charges) are standard prices established by hospitals each year for all services. Missing sig_vars came to light as a result of digestible dev inspection of historical measure displayįor 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”. Updated measures 12307, 12308, and 12309 to include IQR sig_var_nations for historical batch CMS20150101. Over 1,000,000 rows of entity_values data and 25,000 footnotes_values rows introduced with the batch_id = 'CMSNH14Q315Q2' Updates were run in asures and pellucid_wntb,measures.Īll entity_values related to these measures had their units updated as well.Īdded 12 new hospitals based on most recent CMS Hospital Data Compare:ġ167120 DIGNITY HEALTH - ARIZONA GENERAL HOSPITAL LAVEEN AZġ167121 LOMA LINDA UNIVERSITY CHILDREN'S HOSPITAL LOMA LINDA CAġ167122 HOLY CROSS GERMANTOWN HOSPITAL GERMANTOWN MDġ167123 MERCY HOSPITAL CARTHAGE CARTHAGE MOġ167124 LEWIS COUNTY GENERAL HOSPITAL LOWVILLE NYġ167125 CAPE FEAR VALLEY HOKE HOSPITAL RAEFORD NCġ167126 BLUE RIDGE REGIONAL HOSPITAL, INC SPRUCE PINE NCġ167127 TITUSVILLE HOSPITAL TITUSVILLE PAġ167128 PIONEER COMMUNITY HOSPITAL OF SCOTT ONEIDA TNġ167129 MEDICAL CENTER OF ALLIANCE FORT WORTH TXġ167130 PEARLAND MEDICAL CENTER PEARLAND TX The measures include number of cases by MS-DRG, number of cases by CCS and number of medicare cases by MS-DRG Updated the names descriptions and default units of 124 measures where it had previously referred to "patients" when it should have said "cases". Star Rating for how patients rated overall care from agencyĪdded 67 new entities for home_healths starting with entity_id 1167196: Found through CMS Home Health Compare updateĪdded 51 new dialysis_facilities starting with entity_id 1167263: Found through CMS Dialysis Facilities Compare updateĪdded 36 new entities for nursing_homes starting with entity_id 1167160: Found through CMS Nursing Home Compare updateĬlosed 9 nursing homes that are no longer reporting to CMS where entity_id in (227170,261208,236367,236515,238025,1166965,1166972,1160420,1166967) Star Rating team discussed medicines, pain, and home safety Star Rating for health team communicated well with them
Pellucid data professional#
Star Rating for health team gave care in a professional way Home health patient experience survey summary star rating Information verified and sent by the NY DOHīrought over newest Nursing Home Compare data to pellucid.Īpproximately 1,100,00 entity_values rowsĪpproximately 25,000 footnotes_values rowsĪdded 5 new measures for Star Ratings for Home Health data (HHCompare) Inserted 32 new entity_clinics for NY into the entities and entity_clinics tables Inserted newest CMS Dialysis Facility run into pellucid2 Generally, the new data covers 14Q4 through 15Q3Īffects the entities and entity_home_health tablesĬlosed 252117 based on becky's recommendationsĪdded new CMS Home Health Compare Data to pellucid2Īdded new Nursing Home Compare data to pellucid2. Generally the new data covers 15Q2 - 16Q1Īdded new batch of CMS hospital data to pellucid. Generally the new data covers 15Q3 - 16Q2 Generally the new data covers 15Q4 - 16Q3 Generally the new data covers 16Q1 - 16Q4
Generally the new data covers 16Q2 - 17Q1 Generally the new data covers 16Q3 - 17Q2 Generally the new data covers 16Q4 - 17Q3 Generally the new data covers 17Q1 - 17Q4ĭata affects footnotes_values and entity_values Added new batch of CMS hospital data to pellucid
0 kommentar(er)
