Page Comparison

updated the mpns of the following:

17053 Admission Screening - Overall Rate17054 Physical Restraint - Overall Rate17055 Seclusion - Overall Rate17056 Multiple Antipsychotic Medications at Discharge - Overall Rate17057 Multiple Antipsychotic Medications at Discharge with Appropriate Justification - Overall Rate17058 Post Discharge Continuing Care Plan - Overall Rate17059 Post Discharge Continuing Care Plan Transmitted - Overall Rate17060 Admission Screening - Children (1 through 12 years)17061 Physical Restraint - Children (1 through 12 years)17062 Seclusion - Children (1 through 12 years)17063 Multiple Antipsychotic Medications at Discharge - Children (1 through 12 years)17064 Multiple Antipsychotic Medications at Discharge with Appropriate Justification - Children (1 through 12 years)17065 Post Discharge Continuing Care Plan - Children (1 through 12 years)17066 Post Discharge Continuing Care Plan Transmitted - Children (1 through 12 years)17067 Admission Screening - Adolescent (13 through 17 years)17068 Physical Restraint - Adolescent (13 through 17 years)17069 Seclusion - Adolescent (13 through 17 years)17070 Multiple Antipsychotic Medications at Discharge - Adolescent (13 through 17 years)17071 Multiple Antipsychotic Medications at Discharge with Appropriate Justification - Adolescent (13 through 17 years)17072 Post Discharge Continuing Care Plan - Adolescent (13 through 17 years)17073 Post Discharge Continuing Care Plan Transmitted - Adolescent (13 through 17 years)17074 Admission Screening - Adult (18 through 64 years)17075 Physical Restraint - Adult (18 through 64 years)17076 Seclusion - Adult (18 through 64 years)17077 Multiple Antipsychotic Medications at Discharge - Adult (18 through 64 years)17078 Multiple Antipsychotic Medications at Discharge with Appropriate Justification - Adult (18 through 64 years)17079 Post Discharge Continuing Care Plan - Adult (18 through 64 years)17080 Post Discharge Continuing Care Plan Transmitted - Adult (18 through 64 years)17081 Admission Screening - Older Adult (≥65 years)17082 Physical Restraint - Older Adult (≥65 years)17083 Seclusion - Older Adult (≥65 years)17084 Multiple Antipsychotic Medications at Discharge - Older Adult (≥65 years)17085 Multiple Antipsychotic Medications at Discharge with Appropriate Justification - Older Adult (≥65 years)17086 Post Discharge Continuing Care Plan - Older Adult (≥65 years)17087 Post Discharge Continuing Care Plan Transmitted - Older Adult (≥65 years)

AL
2014-07-17:
Removed the entity_hospices table and the entity_hospice_attributes table.Folded Hospice rows into entity_home_healths as a result of suggestions from John Schoneboom, Jaz King, and Ti-Kuang Lee2014-07-16:  Updated measure descriptions for measures 10049 through 10054 to read "kept clean" or "kept quiet" where applicable.  Also updated description long to remove text implying they may be composite measures2014-07-15: Added the following measures from Nursing Home Compare and Home Health Compare:

16984 Reported CNA Staffing Hours per Resident per Day

16985 Reported LPN Staffing Hours per Resident per Day

16986 Reported RN Staffing Hours per Resident per Day

16987 Reported Licensed Staffing Hours per Resident per Day

16988 Reported Total Nurse Staffing Hours per Resident per Day

16989 Reported Physical Therapist Staffing Hours per Resident Per Day

16990 Expected CNA Staffing Hours per Resident per Day

16991 Expected LPN Staffing Hours per Resident per Day

16992 Expected RN Staffing Hours per Resident per Day

16993 Expected Total Nurse Staffing Hours per Resident per Day

16994 Adjusted CNA Staffing Hours per Resident per Day

16995 Adjusted RN Staffing Hours per Resident per Day

16996 Adjusted LPN Staffing Hours per Resident per Day

16997 Adjusted Total Nurse Staffing Hours per Resident per Day

16998 Cycle 1 Total Number of Health Deficiencies

16999 Cycle 1 Number of Standard Health Deficiencies

17000 Cycle 1 Number of Complaint Health Deficiencies

17001 Cycle 1 Health Deficiency Score

17002 Cycle 1 Number of Health Revisits

17003 Cycle 1 Health Revisit Score

17004 Cycle 1 Total Health Score

17005 Cycle 2 Total Number of Health Deficiencies

17006 Cycle 2 Number of Standard Health Deficiencies

17007 Cycle 2 Number of Complaint Health Deficiencies

17008 Cycle 2 Health Deficiency Score

17009 Cycle 2 Number of Health Revisits

17010 Cycle 2 Health Revisit Score

17011 Cycle 2 Total Health Score

17012 Cycle 3 Total Number of Health Deficiencies

17013 Cycle 3 Number of Standard Health Deficiencies

17014 Cycle 3 Number of Complaint Health Deficiencies

17015 Cycle 3 Health Deficiency Score

17016 Cycle 3 Number of Health Revisits

17017 Cycle 3 Health Revisit Score

17018 Cycle 3 Total Health Score

17019 Total Weighted Health Survey Score

17020 Number of Facility Reported Incidents

17021 Number of Substantiated Complaints

17022 Number of Fines

17023 Total Amount of Fines in Dollars

17024 Number of Payment Denials

17025 Total Number of Penalties

17048 Patients who reported YES, they would definitely recommend the home health agency to friends and family

17049 Patients who gave their home health agency a rating of 9 or 10 on a scale from 0 (lowest) to 10 (highest)

17050 Patients who reported that their home health team gave care in a professional way

17051 Patients who reported that their home health team communicated well with them

17052 Patients who reported that their home health team discussed medicines, pain, and home safety with them

Added measure_groups and measure_groups_measures for NH_compare and HH_compare: 

161 HHA Outcome Measures (OBQI)

162 Home Health HCAHPS

163 Nursing Home Compare

2014-07-15: Edited existing Nursing Home and Home Health Measures so that author_measure_ids match the Measure IDs used in the CMS Nursing Home Compare and Home Health Compare Databases2014-07-08: Uploaded new complaints and citations data for NYprofiles, both hospitals and nursing homes were included in the update2014-06-10: Recalculated sig_var_state or sig_var_nation for EDT, costs/charges, and HCAHPS measures using the 0.5 IQR method instead of the 1.5 IQR method2014-05-10: Uploaded new CMS data from Quarterly CMS update2014-03-20: Inserted 2012 maternity data for NY hospitals2014-03-19: Added measure_id 16899 for CMS Value Based Readmissions Adjustment Factor2014-02-01: Added 150 new measures corresponding to AHRQ Observed/Risk Adjusted/Observed to Expected measures2014-01-20: Inserted new rows for TX and FL hospitals based on state discharge data:2014-01-08: Updated CMS HCAHPS measures.  CMS re-released an additional date range for Satisfaction measures2014-01-01:  Updated CMS hospital compare measures.  Batch_id like 'CMS20140101%'2013-12-17:  Added the following new measures into pellucid, from NYS report on Costs and Charges16641     NYS_AvgCost_MSDRG_065     Average Cost for Stroke (with complications)
16642     NYS_AvgCharge_MSDRG_065     Average Charge for Stroke (with complications)
16643     NYS_AvgCharge_MSDRG_101     Average Charge for Seizures
16644     NYS_AvgCost_MSDRG_101     Average Cost for Seizures
16645     NYS_AvgCharge_MSDRG_192     Average Charge for Chronic Obstructive Pulmonary Disease
16646     NYS_AvgCharge_MSDRG_194     Average Charge for Pneumonia (with complications)
16647     NYS_AvgCharge_MSDRG_195     Average Charge for Pneumonia
16648     NYS_AvgCost_MSDRG_192     Average Cost for Chronic Obstructive Pulmonary Disease
16649     NYS_AvgCharge_MSDRG_203     Average Charge for Bronchitis and Asthma
16650     NYS_AvgCost_MSDRG_194     Average Cost for Pneumonia (with complications)
16651     NYS_AvgCost_MSDRG_195     Average Cost for Pneumonia
16652     NYS_AvgCost_MSDRG_203     Average Cost for Bronchitis and Asthma
16653     NYS_AvgCharge_MSDRG_247     Average Charge for Angioplasty (PTCA) with drug-eluting stent
16654     NYS_AvgCost_MSDRG_247     Average Cost for Angioplasty (PTCA) with drug-eluting stent
16655     NYS_AvgCharge_MSDRG_291     Average Charge for Heart Failure (with multiple complications)
16656     NYS_AvgCharge_MSDRG_292     Average Charge for Heart Failure (with complications)
16657     NYS_AvgCharge_MSDRG_293     Average Charge for Heart Failure
16658     NYS_AvgCost_MSDRG_291     Average Cost for Heart Failure (with multiple complications)
16659     NYS_AvgCost_MSDRG_292     Average Cost for Heart Failure (with complications)
16660     NYS_AvgCost_MSDRG_293     Average Cost for Heart Failure
16661     NYS_AvgCharge_MSDRG_313     Average Charge for Chest Pain
16662     NYS_AvgCost_MSDRG_313     Average Cost for Chest Pain
16663     NYS_AvgCharge_MSDRG_343     Average Charge for Appendectomy
16664     NYS_AvgCost_MSDRG_343     Average Cost for Appendectomy
16665     NYS_AvgCharge_MSDRG_392     Average Charge for Digestive Disorders
16666     NYS_AvgCost_MSDRG_392     Average Cost for Digestive Disorders
16667     NYS_AvgCharge_MSDRG_419     Average Charge for Laparascopic Gallbladder Removal
16668     NYS_AvgCost_MSDRG_419     Average Cost for Laparascopic Gallbladder Removal
16669     NYS_AvgCharge_MSDRG_470     Average Charge for Major Joint Replacement (hip, knee)
16670     NYS_AvgCost_MSDRG_470     Average Cost for Major Joint Replacement (hip, knee)
16671     NYS_AvgCharge_MSDRG_639     Average Charge for Diabetes
16672     NYS_AvgCost_MSDRG_639     Average Cost for Diabetes
16673     NYS_AvgCharge_MSDRG_690     Average Charge for Urinary Tract Infections
16674     NYS_AvgCost_MSDRG_690     Average Cost for Urinary Tract Infections
16675     NYS_AvgCharge_MSDRG_765     Average Charge for Cesarean Section (with multiple complications)
16676     NYS_AvgCharge_MSDRG_766     Average Charge for Caesarian Section
16677     NYS_AvgCharge_MSDRG_774     Average Charge for Vaginal Birth (with complicating diagnoses)
16678     NYS_AvgCharge_MSDRG_775     Average Charge for Vaginal Birth
16679     NYS_AvgCost_MSDRG_765     Average Cost for Cesarean Section (with multiple complications)
16680     NYS_AvgCost_MSDRG_766     Average Cost for Caesarian Section
16681     NYS_AvgCost_MSDRG_774     Average Cost for Vaginal Birth (with complicating diagnoses)
16682     NYS_AvgCost_MSDRG_775     Average Cost for Vaginal Birth
16683     NYS_AvgCharge_MSDRG_795     Average Charge for Normal Newborn
16684     NYS_AvgCost_MSDRG_795     Average Cost for Normal Newborn
16685     NYS_AvgCharge_MSDRG_871     Average Charge for Septicemia (with multiple complications)
16686     NYS_AvgCost_MSDRG_871     Average Cost for Septicemia (with multiple complications)2013-12-17:  Added sig_var_state to ED timeliness measures.  Had to use the interquartile range method.  Made the update to p2 and to NYRDS areas2013-12-13:  Added new measures based on the December CMS release:

16621 STK-4 Ischemic stroke patients who got medicine to break up a blood clot within 3 hours after symptoms started16622 STK-5 Ischemic stroke patients who received medicine known to prevent complications caused by blood clots within 2 days of arriving at the hospital16623 STK-1 Ischemic or hemorrhagic stroke patients who received treatment to keep blood clots from forming anywhere in the body within 2 days of arriving at the hospital16624 STK-2 Ischemic stroke patients who received a prescription for medicine known to prevent complications caused by blood clots before discharge16625 STK-3 Ischemic stroke patients with a type of irregular heartbeat who were given a prescription for a blood thinner at discharge16626 STK-6 Ischemic stroke patients needing medicine to lower cholesterol, who were given a prescription for this medicine before discharge16627 STK-8 Ischemic or hemorrhagic stroke patients or caregivers who received written educational materials about stroke care and prevention during the hospital stay16628 VTE-1 Patients who got treatment to prevent blood clots on the day of or day after hospital admission or surgery16629 VTE-2 Patients who got treatment to prevent blood clots on the day of or day after being admitted to the intensive care unit (ICU)16630 VTE-3 Patients with blood clots who got the recommended treatment, which includes using two different blood thinner medicines at the same time16631 VTE-4 Patients with blood clots who were treated with an intravenous blood thinner, and then were checked to determine if the blood thinner was putting the patient at an increased risk of bleeding16632 VTE-5 Patients with blood clots who were discharged on a blood thinner medicine and received written instructions about that medicine16633 VTE-6 Patients who developed a blood clot while in the hospital who did not get treatment that could have prevented it16634 PC-01 Percent of newborns whose deliveries were scheduled too early (1-3 weeks early), when a scheduled delivery was not medically necessary16635 HAI-5 Methicillin-resistant Staphylococcus aureus (or MRSA) blood infections16636 HAI-6 Clostridium difficile (or C.diff.) Infections16637 PSI 04_CMS Rate of Death among Surgical Inpatients with Serious Treatable Complications for Medicare Patients16638 PSI 90_CMS Complications/Patient Safety for Selected Indicators (Composite Score) for Medicare Patients16639 ACCPCIreadm American College of Cardiology Percutaneous Coronary Intervention (PCI) Readmission Measure

2013-12-03:  Closed 36 hospitals based on the results of the 2012 AHA annual survey.  Used the following: update entity_hospitals set closed_date = '2012-12-31'
where aha_id in 
('6040218','6210390','6210397','6210990','6214417','6230064','6230090','6230330',
'6231560','6370045','6380937','6380940','6389015','6389225','6390485','6420038',
'6420039','6430660','6520012','6530319','6530382','6530605','6530750','6720111',
'6740306','6740582','6742445','6743445','6743717','6820004','6930011','6930081',
'6930085','6930248')2013-11-19:  Added 2 new measures for Nursing Home Compare.  Fine amount (16609) and Payment Denial Length in Days (16610)2013-11-18:  Added source_id 71 to value_sources and footnotes 121 and 122 to footnotes to account for data from the Nursing home compare database (CMS)2013-11-12:  Uploaded Provider data from the CMS Nursing Homes data set.  Added 15,300 nursing homes to entity_nursing_homes.  These are specific to states outside of New York2013-10-21:  Added new measures and data for national EHR adoption and HIE adoption.  Batch_id = 'EHR20131021'2013-10-21:  Added SPARCS data for NY Charges and Length of Stay to pellucid for CY 2011 and CY 2012.  Batches 'SPARCS2011' and 'SPARCS2012'2013-09-15:  Updated PSI 90, PSI 91, IQI 90, IQI 91 to include sig_var_nation2013-09-01:  Added sig_var_state values to charges and LOS data for NY State2013-08-15:  Added 15 New hospitals based on the July Leapfrog Results File2013-08-09:  Added new data for Census measures from Axis Maps2013-08-08:  Uploaded new data from CMS quarterly update.  Covers POC date range 2011-10-01 to 2012-09-302013-07-22: Added new measures for Pediatric Procedure counts.  To be used for NY Profile Reboot (ESQUIRE)2013-07-20:  Added new measures for Procedure counts.  To be used for NY Profile reboot2013-05-29: Uploaded new medlos and medcharges data to replace old data, added new values for average length of stay and average charges based on state discharge data.  3.3 Million rows total with the batch_id = 'MSDRG_medavg20130529v2'2013-05-29: Added 36 new measures for medLos, medcharges, avgLOS, and avgcharges for 9 new DRGs2013-05-23: Added 6 new entities into entity_calculations with the entity_type as 'total'.  This was added based on data sent by AHA for their HS files.  28 new measures were also created based on this file and can be found at: https://sites.google.com/a/ipro.us/pelliki/aha-measures2013-05-20: New practices added for Million Hearts Practices, the following new measures added, based on their specs:16128     Ischemic Vasular Disease Use of Aspirin or Other Antithrombotic
16129     Ischemic Vasular Disease Use of Other Antithrombotic
16130     Ischemic Vasular Disease Use of Other Antithrombotic
16131     Controlling High Blood pressure
16132     Ischemic Vasular Disease Blood Pressure Management
16133     Ischemic Vascular Disease (IVD): Blood Pressure Management
16134     Ischemic Vascular Disease (IVD): Complete Lipid Panel and LDL Control
16135     CMP Specific Ischemic Vascular Disease (IVD) & Diabetes: Complete Lipid Panel and LDL Control
16136     Percent Smoking Cessation
16137     Smoking Cessation
16138     Practice TBD Smoking Cessation2013-05-19: New IL AHRQ added to pellucid2013-05-16: 1478 new measures added for Average Length of Stay and Average Charges for 739 MSDRGs.  Measure_ids are between 14366 and 161272013-05-15: New CLABSI ICU, NICU, PICU data added for IL.  CY2012.  New Measure added: 14365, CLABSI in Cardiothoracic Unit 2.  Batch_id = 'ILCLABSI20130515'2013-05-14: Introduced new CMS data into pellucid and pellucid_wntb.  Over 800,000 rows loaded into entity_values and footnotes_values (each).  Batch_id = 'CMS20130430'.  Process of Care measure dates cover 2011-07-01 to 2012-06-30.  Batch_ids later updated to CMS20130430a, CMS20130430b, CMS20130430c, CMS20130430d, CMS20130430e, CMS20130430f, CMS20130430g due to size limitations2013-05-13: Created new Measure for overall Healthcare Facility Onset Incidence Rate of Clostridium difficile infections (includes Molecular and Non-Molecular Infections).  Assigned to measure_id 14364.  Populated entity_values and footnotes_values for this measure and the MRSA measure (12285) for CY2012 for IL hospitals.  Batch_id = 'ILCDIFMRSA20130513'2013-05-10: Replaced and updated data for IL AHRQ race striations and IL Breast Feeding measure values2013-05-09: Added 200 new measures and 350,000 new values for hospital level average covered costs and average total payment. Source: CMS Medicare Provider Charge Data: http://www.cms.gov/Research-Statistics-Data-and-Systems/Statistics-Trends-and-Reports/Medicare-Provider-Charge-Data/index.html.  Batch_id = 'CMSCharges2011_20130509'2013-05-04:  Added 1.5 Million rows to entity_values for Median Stay and Median Charges for 739 DRGs across 18 states and the national average2013-05-03: Added 6 new CLABSI measures associated with IDPH reporting (Burn ICU, Trauma ICU, Cardiac ICU, CT ICU, Neurological ICU, and Neurosurgical ICU)2013-05-02: Added 1400+ measures to the measures table.  Applicable to Median Length of Stay and Median Charges for MSDRG diagnosis codes2013-04-24: Revised the hospital designations for IL hospitals based on designation details sent by IDPH2013-04-23: Uploaded new data for AHRQ measures for Maine and Illinois.  Based on state discharge data.  Batch_id = 'AHRQ_ILME20130423'2013-04-19: Uploaded data for the additional County Health Rankings Data measure set (measure_ids 12383 through 12395).  Batch_id = 'CHRaddl20130419'2013-04-19: Added new value_sources for Maine Discharge Data (source_id 65) and Utah Discharge Data (source_id 66)2013-04-18: Added new measures to the measures table and new authors to measure_authors.  Added were the following measures:

12383 Percent of the population not proficient in English12384 Percent of the Population with Diabetes12385 HIV prevalence rate12386 Child Mortality Rate12387 Infant Mortality Rate12388 Mental health providers oer 100,000 population12389 Health care costs12390 Uninsured adults12391 Uninsured children12392 The percentage of people who reported they could not see doctor due to cost12393 Percentage of Children Eligible for Free Lunch12394 Homicide Rate12395 Percentage of the population with access to parks

Author_ids 27 through 32 were also added
2013-04-17:  Added new data for IL nurse staffing. Batch_id = 'ILNurseStaffing20130416'.  Affects the following measures: 10665, 10666, 10667, 10668, 10669, 10670, 10671, 10672, 10673, 10674, 10675, 10676, 10677, 10678, 10679, 12038, 12039, 12040, 12041, 12042, 120432013-04-16: updated all 'Critical Access" values in entity_hospital_attributes to read as 'Critical Access AHA' and set the source to 'AHA'.  Created a new set of attributes called 'Critical Access CMS' based on CMS mpn_ids that are associated with the Critical Access Designation (select * from entity_hospitals where mpn_id like '__1%').  Critical Access hospitals have a 1 in the third position of their MPN2013-04-16: Added/updated County Health Rankings data for measures not specific to Whynotthebest.org.  Batch_id = 'CHR20130415'.  Measures contained the following: 10790, 10791, 10792, 10892, 12158, 12161, 12288, 12289, 12290, 12291, 12292, 12293, 12294, 12295, 12296, 12297, 12298, 12300, 12301, 12302, 12303, 12304, 123822013-04-15: Added the following measures, which were found in the County Health Rankings data12377     Primary Care Physicians per 100,000
12378     Dentists per 100,000 population
12379     Preventable Hospital Stays
12380     Diabetic Screening
12381     Mammography Screening
12382     Drinking Water Safety2013-04-15:2013-04-10:  New SCIP values added for IL hospitals.  Date range 2011-10-01 to 2012-09-302013-04-09: Added new values for IL hospitals.  Includes Bypass, Emergency Dept, and LAMA data2013-04-08: Added new values for IL Hospital profiles, IL asc profiles, IL hospital bed counts, and IL Hospital Breast Feeding data2013-04-02: Added 106 new acos to the entity_acos table, which were made available through CMS' 2013 list2013-04-01: Edited IL map measures 12129,12135,12136,12137,10964,10967,10970,10973,10976,10979 to display 'per 10000' as the unit instead of the old unit, 'cases'2013-03-31: Edited IL map measures 12130, 12131, 12132, 12133, 12145, 12146, 12147, 12148 to display 'per 10000' as the unit instead of 'per 100000'2013-03-12: Edited the zipcodes table to include HRR and HSA information from Dartmouth2013-03-05: Entity_acos edited to include hospital address and location information.  Geocoding to follow shortly2013-02-21: Data added for 51 new MCO performance measures.  Test entity_values data uploaded and marked as private2013-02-15: Seven new hospitals introduced into pellucid2 based on data received and ongoing interactions with the Leapfrog Group.  Their entity_ids and information is as follows:

214802 University Medical Center Fresno, CA214803 Methodist West Hospital West Des Moines, IA214804 North Philadelphia Health System - Girard Medical Center Philadelphia, PA214805 Centennial Women's Hospital Nashville, TN214806 Franklin Woods Community Hospital Johnson City, TN214807 Niswonger Children's Hospital Johnson City, TN214813 Montefiore Wakefield Campus Bronx, NY

2013-02-12: AHRQ state data uploaded for Wisconsin.  Includes data for PSI, IQI, and PQI measures2013-02-07: HRSA data added regarding the distribution of Medical Doctors in comparison to area-level population.  Measure_ids: 12324, Active MDs 12325: Active MDs per 1000 population2013-01-28: Illinois ASC revenue data added for Calendar Year 2011, batch_id ILASCrev20112013-01-20: CMS data run introduced into pellucid2.  New Process of Care measures, with the date range 2011-04-01 to 2012-03-31.  The new data includes changes to the existing measures, the introduction of new measures, and the inclusion of more OP/ED, Hospital Acquired Condtions, and CLABSI data.2012-10-11: Accountable Care Organizations introduced into pellucid2 in the entity_acos table.  Currently contains information on the name of the ACO and the areas served

AHRQ QI Software Version:
For AHRQ indicators Q4 2008 through Q3 2009 Pellucid is using WINDOWS OR SAS VERSION NUMBER