Total admissions ICU/Med: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
No edit summary
Line 2: Line 2:


{{Article needing periodic review
{{Article needing periodic review
  | NextReviewDate = 2019-06-01
  | NextReviewDate = 2019-09-01
}}
}}


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" | 121,860
|style="font-size:11pt" | 125,002
|style="font-size:11pt" | 2018-12-05
|style="font-size:11pt" | 2019-06-24
|-  valign="bottom"
|-  valign="bottom"
|style="font-weight:bold" height="14" | Medicine
|style="font-weight:bold" height="14" | Medicine
|style="font-size:11pt" | 170,057
|style="font-size:11pt" | 177,645
|style="font-size:11pt" | 2018-12-05
|style="font-size:11pt" | 2019-06-24
|-  valign="bottom"
|-  valign="bottom"
|style="font-weight:bold" height="14" | TOTAL
|style="font-weight:bold" height="14" | TOTAL
|style="font-size:11pt" | 291,917
|style="font-size:11pt" | 302,647
|style="font-size:11pt" | 2018-12-05
|style="font-size:11pt" | 2019-06-24
|}
|}



Revision as of 10:42, 2019 June 26

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 2019-09-01.

Database Total Records current to date
Critical Care 125,002 2019-06-24
Medicine 177,645 2019-06-24
TOTAL 302,647 2019-06-24

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;