View source for Total admissions ICU/Med

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

{{Article needing periodic review
 | NextReviewDate = 2026-01-01
}}

As of 2024-12-31: 
{| 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]]