Versions Compared

Version Old Version 3 New Version 4
Changes made by

Alex Laird (Unlicensed)

Alex Laird (Unlicensed)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Reverted from v. 1
and b.measure_group_id = 22
The following measures belong to the group that falls into AHRQ's Patient Safety Indicator category.  This includes observed, risk-adjusted, and observed to expected measures.
SQL to acquire these measures is as follows:

All PSI measures 

select a.* from measures as a, measure_groups_measures as b
where a.measure_id = b.measure_id 
select measure_id, author_measure_id, name_friendly from measures where author_measure_id like '%PSI%';
Statistical significance is calculated using a 95% confidence interval on a standard z-test for state-wide values and populated in the sig_var_state field of pellucid2.entity_values.
CMS (Centers for Medicare and Medicaid Services) briefly calculated select hospital-level PSIs.  These calculations were based on the information they received from hospitals nationally.  They have "CMS" in their author_measure_id field.
measure_idauthor_measure_idname_friendly
10072PSI 02Unexpected Deaths
10073PSI 12Postoperative Lung Embolism or Deep Vein Thrombosis (clotting)
10074PSI 14Wound Complications in Abdominal Wall Surgery
10075PSI 15Accidental Puncture and Laceration
10076PSI 17Birth Trauma
10077PSI 04Failure to Rescue
10198PSI 03Pressure Ulcer
10200PSI 06Collapsed Lung caused by Medical Care
10201PSI 07Central Venous Catheter-related Bloodstream Infections
10202PSI 09Postoperative Hemorrhage or Hematoma
10203PSI 11Postoperative Respiratory Failure
10205PSI 13Postoperative Sepsis
10207PSI 18Obstetric Trauma - Instrument-assisted Vaginal Delivery
10208PSI 19Obstetric Trauma - Vaginal Delivery without Instrument
10212PSI 05Foreign Body Left During Procedure
10213PSI 10Postoperative Physiologic and Metabolic Derangement
10215PSI 08Postoperative Hip Fracture
10216PSI 16Blood Transfusion Reaction
10761PSI 12Observed Postoperative pulmonary embolism or deep vein thrombosis
10762PSI 04Observed Failure to Rescue
10764PSI 03Observed Pressure Ulcer
10765PSI 07Observed Central venous catheter-related blood stream infections
10766PSI 13Observed Postoperative Sepsis
10767PSI 08Observed Postoperative Hip Fracture
10846PSI 20Obstetric trauma (3rd or 4th degree lacerations): rate per 1,000 cesarean deliveries
10847PSI 21Foreign Body Left During Procedure per 100,000 population
10848PSI 22Iatrogenic Pneumothorax per 100,000 population
10849PSI 23Central Venous Catheter-related Bloodstream Infections per 100,000 population
10850PSI 24Wound Complications in Abdominal Wall Surgery
10851PSI 25Accidental puncture or laceration per 100,000 population
10852PSI 26Blood Transfusion reaction per 100,000 population
10853PSI 27Postoperative hemorrhage/hematoma requiring a procedure per 100,000 population
10859PSI 90Patient Safety for Selected Procedures Composite
10860PSI 91Patient Safety for Selected Conditions Composite
12122IOM_PSI_7_CMSCMS Patient Safety Indicator (PSI) 7: Number of central venous catheter-related bloodstream infections for Medicare beneficiaries ages 65-74 per 100,000 beneficiaries
16637PSI 04_CMSRate of Death among Surgical Inpatients with Serious Treatable Complications for Medicare Patients
16638PSI 90_CMSComplications/Patient Safety for Selected Indicators (Composite Score) for Medicare Patients
16734PSI 12_CMSPostoperative Lung Embolism or Deep Vein Thrombosis (clotting)
16735PSI 14_CMSWound Complications in Abdominal Wall Surgery
16736PSI 15_CMSAccidental Puncture and Laceration
16737PSI 06_CMSCollapsed Lung caused by Medical Care
16863oPSI 02Observed Unexpected Deaths
16864oePSI 02Observed to Expected Unexpected Deaths
16865oePSI 03Pressure Ulcer
16866oePSI 04Observed to Expected Death Rate among Surgical Inpatients with Serious Treatable Complications
16867oPSI 04aObserved Death Rate among Surgical Inpatients with Serious Treatable Complications Stratum A
16868raPSI 04aRisk Adjusted Death Rate among Surgical Inpatients with Serious Treatable Complications Stratum A
16869oePSI 04aObserved to Expected Death Rate among Surgical Inpatients with Serious Treatable Complications Stratum A
16870oPSI 04bObserved Death Rate among Surgical Inpatients with Serious Treatable Complications Stratum B
16871raPSI 04bRisk Adjusted Death Rate among Surgical Inpatients with Serious Treatable Complications Stratum B
16872oePSI 04bObserved to Expected Death Rate among Surgical Inpatients with Serious Treatable Complications Stratum B
16873oPSI 04cObserved Death Rate among Surgical Inpatients with Serious Treatable Complications Stratum C
16874raPSI 04cRisk Adjusted Death Rate among Surgical Inpatients with Serious Treatable Complications Stratum C
16875oePSI 04cObserverd to Expected Death Rate among Surgical Inpatients with Serious Treatable Complications Stratum C
16876oPSI 04dObserved Death Rate among Surgical Inpatients with Serious Treatable Complications Stratum D
16877raPSI 04dRisk Adjusted Death Rate among Surgical Inpatients with Serious Treatable Complications Stratum D
16878oePSI 04dObserved to Expected Death Rate among Surgical Inpatients with Serious Treatable Complications Stratum D
16879oPSI 04eObserved Death Rate among Surgical Inpatients with Serious Treatable Complications Stratum E
16880raPSI 04eRisk Adjusted Death Rate among Surgical Inpatients with Serious Treatable Complications Stratum E
16881oePSI 04eObserved to Expected Death Rate among Surgical Inpatients with Serious Treatable Complications Stratum E
16882oPSI 06Observed Collapsed Lung caused by Medical Care
16883oePSI 06Collapsed Lung caused by Medical Care
16884oePSI 07Central Venous Catheter-related Bloodstream Infections
16885oePSI 08Postoperative Hip Fracture
16886oPSI 09Observed Postoperative Hemorrhage or Hematoma
16887oePSI 09Postoperative Hemorrhage or Hematoma
16888oPSI 11Observed Postoperative Respiratory Failure
16889oePSI 11Postoperative Respiratory Failure
16890oPSI 10Observed Postoperative Physiologic and Metabolic Derangement
16891oePSI 10Postoperative Physiologic and Metabolic Derangement
16892oePSI 12Postoperative Lung Embolism or Deep Vein Thrombosis (clotting)
16893oePSI 13Postoperative Sepsis
16894oePSI 14Wound Complications in Abdominal Wall Surgery
16895oePSI 15Accidental Puncture and Laceration
16896oPSI 14Observed Wound Complications in Abdominal Wall Surgery
16897oPSI 15Observed Accidental Puncture and Laceration