Total admissions ICU/Med: Difference between revisions
Jump to navigation
Jump to search
TOstryzniuk (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) m m |
||
| Line 25: | Line 25: | ||
==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 == | |||
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; | |||
Revision as of 12:25, 27 August 2015
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 | 93,858 | Nov 18.13 |
| Medicine | 102,956 | Nov 18.13 |
| TOTAL | 199,814 | Nov 18.13 |
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;