Total admissions ICU/Med: Difference between revisions

← Older edit

@@ 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.
-==TOTAL Patient in Database==
+{{Article needing periodic review
-{| class="wikitable" border=1 <hiddentext> set to 0 for no borders</hiddentext>
+ | NextReviewDate = 2026-01-01
-|- style="font-size:11pt"  valign="bottom"
+}}
-| width="90" height="20" | Database
-| width="67" | Total Records
+As of 2024-12-31:
-| width="95" | current to date
+{| class="wikitable"
+|-
+||
+|| Number of profiles
 |-   valign="bottom"
-|style="font-weight:bold" height="14" | Critical Care
+|| [[Definition of a Critical Care Program Admission|Critical Care]]
-|style="font-size:11pt" | 66,917
+|| {{formatnum: {{N CC}} }}
-|style="font-size:11pt" | Dec 23.08
 |-   valign="bottom"
-|style="font-weight:bold" height="14" | Medicine
+|| [[Definition of a Medicine Program Admission|Medicine]]
-|style="font-size:11pt" | 48,258
+|| {{formatnum: {{N Med}} }}
-|style="font-size:11pt" | Dec 23.08
 |-   valign="bottom"
-|style="font-weight:bold" height="14" | TOTAL
+|| Total
-|style="font-size:11pt" | 113,314
+|| {{N Tot}}
-|style="font-size:11pt" | Nov 5.08
 |}
-{{stub}}
+==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:Reporting]]
-[[Category: Statistical Analysis]]
+[[Category:Statistical Analysis]]
+[[Category:About]]