Directors Quarterly and Annual Report (Critical Care): Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
No edit summary
 
(5 intermediate revisions by 2 users not shown)
Line 5: Line 5:
|Recipients= * Critical Care Directors and Site  Managers* see also: [[Distribution of Annual and Quarterly Reports]]
|Recipients= * Critical Care Directors and Site  Managers* see also: [[Distribution of Annual and Quarterly Reports]]
|MailingList=[[Distribution of Annual and Quarterly Reports]]
|MailingList=[[Distribution of Annual and Quarterly Reports]]
|DataDependencies=Severity of illness; Invasive Ventilated Cases; 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
|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
|SASFiles=<path for SAS files>
|SASFiles=<path for SAS files>
}}
}}
* Tabular Critical Care Activity Summary - comparative of all ICUs
* Tabular Critical Care Activity Summary - comparative of all ICUs
* Uploaded in the [[Critical Care Sharepoint ExtraNet]] by the Database Program Statistician, Julie Mojica
* 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
* Reporting period is quarterly and fiscal year from April 1 to March 31
== Distribution ==
== Distribution ==
[[Distribution of Annual and Quarterly Reports]]
[[Distribution of Annual and Quarterly Reports]]
Line 17: Line 19:
*Electronic copy of report:
*Electronic copy of report:
**[[X:\]]Reports\CriticalCareReport
**[[X:\]]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 ==  
== Related articles ==  
{{Related Articles}}
{{Related Articles}}

Latest revision as of 15:31, 2023 March 20

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 : 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


  • 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:
    • X:\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

Related articles: