Total admissions ICU/Med: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) mNo edit summary |
||
Line 12: | Line 12: | ||
|- valign="bottom" | |- valign="bottom" | ||
|| Critical Care | || [[Definition of a Critical Care Laptop Admission|Critical Care]] | ||
|| 133831 | || 133831 | ||
|- valign="bottom" | |- valign="bottom" | ||
|| Medicine | || [[Definition of a Medicine Laptop Admission|Medicine]] | ||
|| 201470 | || 201470 | ||
Revision as of 14:42, 2021 April 1
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 2022-03-10.
As of 2021-03-10:
Number of profiles | |
Critical Care | 133831 |
Medicine | 201470 |
Total | 335301 |
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;