CCMDB Wiki

Total admissions ICU/Med: Difference between revisions

← Older edit
TOstryzniuk (talk | contribs)
CCMDB_legit, approved, Bureaucrats, Administrators
27,522 edits
m Total patient in database as of Jan 12.17 (exclude 1 yr family Medicine)
m Text replacement - "[[Category: " to "[[Category:"
 
(22 intermediate revisions by 3 users not shown)
Line 1: Line 1:
Total number of encounters in the ICU and Medicine in Database: [[CCMDB]].
Total number of encounters in the ICU and Medicine in Database: [[CCMDB]].
*This article is updated intermittently.


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


{| class="wikitable" border=1 <hiddentext> set to 0 for no borders</hiddentext>
As of 2024-12-31:
|- style="font-size:11pt"  valign="bottom"
{| class="wikitable"  
| width="90" height="20" | Database
|-  
| width="67" | Total Records
||  
| width="120" | current to date
|| Number of profiles


|-  valign="bottom"
|-  valign="bottom"
|style="font-weight:bold" height="14" | Critical Care
|| [[Definition of a Critical Care Program Admission|Critical Care]]
|style="font-size:11pt" | 111,203
|| {{formatnum: {{N CC}} }}
|style="font-size:11pt" | Jan 12.17
 
|-  valign="bottom"
|-  valign="bottom"
|style="font-weight:bold" height="14" | Medicine
|| [[Definition of a Medicine Program Admission|Medicine]]
|style="font-size:11pt" | 142,010
|| {{formatnum: {{N Med}} }}
|style="font-size:11pt" | Jan 12.17


|-  valign="bottom"
|-  valign="bottom"
|style="font-weight:bold" height="14" | TOTAL
|| Total
|style="font-size:11pt" | 253,213
|| {{N Tot}}
|style="font-size:11pt" | Jan 12.17
 
|}
|}


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


== SQL ==
== SQL ==
To generate a per-unit count in Access paste the following:  
To generate a per-unit count in Access paste the following:  
SELECT s_Locations.Location, s_Locations.Active, Count(L_Log.D_ID) AS CountOfD_ID, Min(L_Log.R_AdmDate) AS MinOfR_AdmDate, Max(L_Log.R_DisDate) AS MaxOfR_DisDate
<pre>
FROM s_Locations LEFT JOIN L_Log ON s_Locations.Location = L_Log.R_Location
SELECT Count(L_Log.D_ID) AS CountOfD_ID, s_dispo.program
GROUP BY s_Locations.Location, s_Locations.Active
FROM L_Log INNER JOIN s_dispo ON L_Log.Service_Location = s_dispo.dispo_ID
ORDER BY s_Locations.Location;
GROUP BY s_dispo.program;
 
</pre>


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


[[Category: Reporting]]
[[Category:Reporting]]
[[Category: Statistical Analysis]]
[[Category:Statistical Analysis]]
[[Category:About]]
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Total_admissions_ICU/Med"