Total admissions ICU/Med: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
updated to get its numbers from templates so we can ensure consistency across the wiki.
m Text replacement - "[[Category: " to "[[Category:"
 
(One intermediate revision by the same user not shown)
Line 21: Line 21:
|-  valign="bottom"
|-  valign="bottom"
|| Total
|| Total
|| {{formatnum: {{#expr:({{N CC}} + {{N Med}}) }} }}
|| {{N Tot}}


|}
|}
Line 38: Line 38:
{{Related Articles}}
{{Related Articles}}


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

Latest revision as of 11:01, 30 July 2025

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 2026-01-01.

As of 2024-12-31:

Number of profiles
Critical Care 153,300
Medicine 243,573
Total 396,873

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: