Total admissions ICU/Med: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
No edit summary
 
(One intermediate revision by one other user not shown)
Line 2: Line 2:


{{Article needing periodic review
{{Article needing periodic review
  | NextReviewDate = 2022-03-10
  | NextReviewDate = 2023-01-01
}}
}}


As of 2021-03-10:  
As of 2021-12-31:  
{| class="wikitable"  
{| class="wikitable"  
|-  
|-  
Line 13: Line 13:
|-  valign="bottom"
|-  valign="bottom"
|| [[Definition of a Critical Care Laptop Admission|Critical Care]]
|| [[Definition of a Critical Care Laptop Admission|Critical Care]]
|| 133831
|| 138141


|-  valign="bottom"
|-  valign="bottom"
|| [[Definition of a Medicine Laptop Admission|Medicine]]
|| [[Definition of a Medicine Laptop Admission|Medicine]]
|| 201470
|| 211415


|-  valign="bottom"
|-  valign="bottom"
|| Total
|| Total
|| 335301
|| 349556


|}
|}
Line 35: Line 35:
</pre>
</pre>


== Related articles ==
{{Related Articles}}


[[Category: Reporting]]
[[Category: Reporting]]
[[Category: Statistical Analysis]]
[[Category: Statistical Analysis]]
[[Category: About]]

Latest revision as of 14:07, 2022 January 5

Total number of encounters in the ICU and Medicine in Database: CCMDB.

This article is tagged to be reviewed periodically. The next scheduled review is on 2023-01-01.

As of 2021-12-31:

Number of profiles
Critical Care 138141
Medicine 211415
Total 349556

Data Collection Start Dates for each Hospital in Region Go to: Site and Location table

SQL

To generate a per-unit count in Access paste the following:

SELECT Count(L_Log.D_ID) AS CountOfD_ID, s_dispo.program
FROM L_Log INNER JOIN s_dispo ON L_Log.Service_Location = s_dispo.dispo_ID
GROUP BY s_dispo.program;

Related articles

Related articles: