Total admissions ICU/Med: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m →SQL |
Ttenbergen (talk | contribs) mNo edit summary |
||
| Line 13: | Line 13: | ||
|- 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" | 121855 | ||
|style="font-size:11pt" | | |style="font-size:11pt" | 2018-12-05 | ||
|- 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" | 170049 | ||
|style="font-size:11pt" | | |style="font-size:11pt" | 2018-12-05 | ||
|- valign="bottom" | |- valign="bottom" | ||
|style="font-weight:bold" height="14" | TOTAL | |style="font-weight:bold" height="14" | TOTAL | ||
|style="font-size:11pt" | 277,425 | |style="font-size:11pt" | 277,425 | ||
|style="font-size:11pt" | | |style="font-size:11pt" | 2018-12-05 | ||
|} | |} | ||
==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 == | == SQL == | ||
To generate a per-unit count in Access paste the following: | To generate a per-unit count in Access paste the following: | ||
<pre> | <pre> | ||
SELECT | SELECT Count(L_Log.D_ID) AS CountOfD_ID, s_dispo.program | ||
FROM | FROM L_Log INNER JOIN s_dispo ON L_Log.Service_Location = s_dispo.dispo_ID | ||
GROUP BY | GROUP BY s_dispo.program; | ||
</pre> | </pre> | ||
Revision as of 16:12, 5 December 2018
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 2018-10-16.
| Database | Total Records | current to date |
| Critical Care | 121855 | 2018-12-05 |
| Medicine | 170049 | 2018-12-05 |
| TOTAL | 277,425 | 2018-12-05 |
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;