Total admissions ICU/Med: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m Text replacement - "Definition of a Medicine Laptop Admission" to "Definition of a Medicine Program Admission" |
Ttenbergen (talk | contribs) updated to get its numbers from templates so we can ensure consistency across the wiki. |
||
| Line 13: | Line 13: | ||
|- valign="bottom" | |- valign="bottom" | ||
|| [[Definition of a Critical Care Program Admission|Critical Care]] | || [[Definition of a Critical Care Program Admission|Critical Care]] | ||
|| | || {{formatnum: {{N CC}} }} | ||
|- valign="bottom" | |- valign="bottom" | ||
|| [[Definition of a Medicine Program Admission|Medicine]] | || [[Definition of a Medicine Program Admission|Medicine]] | ||
|| | || {{formatnum: {{N Med}} }} | ||
|- valign="bottom" | |- valign="bottom" | ||
|| Total | || Total | ||
|| | || {{formatnum: {{#expr:({{N CC}} + {{N Med}}) }} }} | ||
|} | |} | ||
Revision as of 16:10, 2 June 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: |