Total admissions ICU/Med: Difference between revisions

Retrieved from "https://ccmdb.kuality.ca/index.php?title=Total_admissions_ICU/Med"

@@ Line 1: / Line 1: @@
-Total number of admission in ICU Database.
+Total number of encounters in the ICU and Medicine in Database: [[CCMDB]].
-*updated intermittently.
-[{{stub}}
+{{Article needing periodic review
+ | NextReviewDate = 2026-01-01
+}}
-[[Category: Reporting]]
+As of 2024-12-31:
-[[Category: Statistical Analysis]]
+{| class="wikitable"
+|-
+||
+|| Number of profiles
+|-   valign="bottom"
+|| [[Definition of a Critical Care Program Admission|Critical Care]]
+|| {{formatnum: {{N CC}} }}
+|-   valign="bottom"
+|| [[Definition of a Medicine Program Admission|Medicine]]
+|| {{formatnum: {{N Med}} }}
+|-   valign="bottom"
+|| Total
+|| {{N Tot}}
+|}
+==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:
+<pre>
+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;
+</pre>
+== Related articles ==
+{{Related Articles}}
+[[Category:Reporting]]
+[[Category:Statistical Analysis]]
+[[Category:About]]