Directors Quarterly and Annual Report (Critical Care)

Reports
Report:	Directors Quarterly and Annual Report (Critical Care)
StartDtTm:
EndDtTm:
Contact Person :	<names, organization if outside of Shared Health>
Recipients:	* Critical Care Directors and Site Managers* see also: Distribution of Annual and Quarterly Reports
Frequency:	quarterly and annual
MailingList:	Distribution of Annual and Quarterly Reports
Data Dependencies(Reports/Indicators/Data Elements):	Severity of illness • Invasive mechanical ventilation at 2300 hrs (concept) • Ventilator Utilization Ratio • LOS Per Service • Unit Mortality • Readmission Rate to ICU • Transfer Delay (Critical Care) • Bed occupancy • Ventilator Associated Pneumonia Rate • Central Line Associated Blood-Stream Infection (CLA-BSI) rate
SASFiles:	<path for SAS files>

 

• Cargo

used to include | DataDependencies = Severity of illness; Invasive mechanical ventilation at 2300 hrs (concept); Ventilator Utilization Ratio; LOS Per Service; Unit Mortality;Readmission_Rate_to_ICU; Transfer Delay (Critical Care); Bed occupancy; Ventilator Associated Pneumonia Rate; Central Line Associated Blood-Stream Infection (CLA-BSI) rate but that is now handled by Template:Data Dependencies

• Helper template:

• Cargo

• Categories

none

• Default form: none, this is populated by Template:Report and Template:Reporting Indicators and their respective forms.

• Categories

• Default form:

• Tabular Critical Care Activity Summary - comparative of all ICUs
• Uploaded in the Critical Care Sharepoint ExtraNet by the Database Program Statistician, Julie Mojica
• Reporting period is quarterly and fiscal year from April 1 to March 31

Distribution

Distribution of Annual and Quarterly Reports

File Locations

• Electronic copy of report:
  • S:\MED\Med_CCMED\​S:\MED\Med_CCMED\Reports\CriticalCareReport

SAS Program

Run the SAS Programs in S:\MED\MED_CCMED\Julie\SAS_CFE\CC_reports in this order:

• 1a_prepCC_startJan2022.sas - prepares the data to be used in the report. Make sure all the data are cleaned already by the Data Processor.
• 1b_chkCCDeathsReadm_Jan2022.sas - checks the death and readmission rates. If the previous locations and admit locations are quesionable, have the Data Processor check, confirm with data collector/EPR and fix the database.
• 2_CCReport_part1_Jan2022,sas - generates the summary stats for the current quarter.
• 3_FY_CCReport_part1_Jan2022.sas - generates the summary stats for fiscal year. only run this program if the current quarter being reported is Jan to March.

Related articles