Critical Care Program Quality Indicator Report

From CCMDB Wiki
Revision as of 13:33, 2023 March 20 by JMojica (talk | contribs)
Jump to navigation Jump to search
Reports
Report: Critical Care Program Quality Indicator Report
StartDtTm: 2016-10-01
EndDtTm:
Contact Person : Carmen Hrymak
Recipients: Distribution of Annual and Quarterly Reports
Frequency: quarterly
MailingList: Distribution of Annual and Quarterly Reports
Data Dependencies : Age Avoidable Days (Critical Care) Beds occupied by transferrable patients (Critical Care) CXR Creatinine (labs) Delirium days Duration of Mechanical Ventilation ICU Acquired Antibiotic Resistant Organism (ARO) rate ICU Acquired Catheter-associated Urinary Tract Infection (CAUTI) rate ICU Acquired Sepsis ICU Acquired Ulcer Rate ICU Diagnosis APACHE Category Rate ICU Interfacility Transfer ICU Primary Diagnosis ICD10 Chapter Rate ICU Resource Utilization - Creatinine Tests LOS Per Service Length of Time for Transfer from ED to ICU within same facility Night Time Discharges Nursing Workload Over Census at Midnight Patient flow Primary Admit Diagnosis Readmission Rate to ICU Severity of illness Transfer Delay (Critical Care) Unit Mortality Ventilated patient flow Ventilator Associated Pneumonia Rate Ventilator Utilization Ratio
SASFiles: <path for SAS files>
 
  • Cargo


  • Categories
  • Default form:

Also known as "Outcomes Improvement Team Quarterly ICU Report" or "Directors Quarterly Report (Critical Care)".

Contents

There are multiple versions of this report that essentially contain the same indicators but has them aggregated slightly differently.

Critical Care Program Quality Indicator Report

( also refer as the Regional Report)

  • contains cumulative of all units except HSC CCU, STB ACCU and STB ICCS
  • Started Oct 2016 by Kendiss Olafson

Individual ICU Quality Indicator Report

Same

WRHA Critical Care Quality Indicator Report

  • contains comparison of indicators among all units
  • Start date - Oct 2016 for all units (except HSC CCU, STB ACCU, STB ICCS which started Jan 2019)
  • End Date -

Distribution

Distribution of Annual and Quarterly Reports

File Locations

  • Hard Copy of Report kept at desk of Database Program Statistician, Julie Mojica
  • Electronic copy of report:
    • Tabular : X:\Reports\CriticalCareReport
    • Graphical: R:\Critical Care QIT\Director_Report\Report

Legacy

Tabular Report

  • Tabular report
    • Report Label- Critical Care Activity Summary Report for the current quarter for each Unit
    • Start Date - 2003
    • End Date - Sept 2016 for all units (except HSC CCU, STB ACCU, STB ICCS which ended Dec 2018)
    • Part of the tabular report continues to be reported
      • label as Critical Care Comparative Report for the current quarter
      • one table containing 13 summary activity indicators of individual units for the current quarter
      • second table containing the VAP and CLBSI rates of all for the current quarter

SAS and SQC Programs

  • First part - Run the SAS programs saved in S:\MED\MED_CCMED\Julie\SAS_CFE\CC_reports\ChartReport in the following order:
    • 1-prepCC_QI_startJan2023_WithIncompleteBedHeld.sas - prepares the data to be used in the report and exported to excel file
      • Make sure all the data are cleaned already by the Data Processor.
      • Check the exported excel file for suspicious data by comparing the common period from the previous file.
    • 2-prepCCChart_demog_93_Sex_start1Oct2019.sas - generates the bar chart for Age Groups, Sex
    • 3-prepCCChart_ApacheDxGrp_94_startJan2020.sas - generates the bar chart for eight Diagnostic Categories from APACHE II Predicted Death Model in ICD10
    • 4-prepCCChart_ICD10PrimaryDx_ChapterName_startingJuly2019.sas - generates the table of ranked primary Diagnosis using ICD10 Chapter Name

Related articles

Related articles: