Total admissions ICU/Med: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m addition... |
TOstryzniuk (talk | contribs) m minor |
||
| Line 11: | Line 11: | ||
|- valign="bottom" | |- valign="bottom" | ||
|style="font-weight:bold" height="14" | Critical Care | |style="font-weight:bold" height="14" | Critical Care | ||
|style="font-size:11pt" | | |style="font-size:11pt" | 105,809 | ||
|style="font-size:11pt" | | |style="font-size:11pt" | Jan 27.16 | ||
|- valign="bottom" | |- valign="bottom" | ||
|style="font-weight:bold" height="14" | Medicine | |style="font-weight:bold" height="14" | Medicine | ||
|style="font-size:11pt" | | |style="font-size:11pt" | 130,530 | ||
|style="font-size:11pt" | | |style="font-size:11pt" | Jan 27.16 | ||
|- valign="bottom" | |- valign="bottom" | ||
|style="font-weight:bold" height="14" | TOTAL | |style="font-weight:bold" height="14" | TOTAL | ||
|style="font-size:11pt" | | |style="font-size:11pt" | 236,339 | ||
|style="font-size:11pt" | | |style="font-size:11pt" | Jan 27.16 | ||
|} | |} | ||
Revision as of 18:35, 27 January 2016
Total number of encounters in the ICU and Medicine in Database: CCMDB.
- This article is updated intermittently.
| Database | Total Records | current to date |
| Critical Care | 105,809 | Jan 27.16 |
| Medicine | 130,530 | Jan 27.16 |
| TOTAL | 236,339 | Jan 27.16 |
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 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 FROM s_Locations LEFT JOIN L_Log ON s_Locations.Location = L_Log.R_Location GROUP BY s_Locations.Location, s_Locations.Active ORDER BY s_Locations.Location;