Total admissions ICU/Med: Difference between revisions

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


{{Article needing periodic review
{{Article needing periodic review
  | NextReviewDate = 2019-09-01
  | NextReviewDate = 2022-03-10
}}
}}


{| class="wikitable" border=1 <hiddentext> set to 0 for no borders</hiddentext>
As of 2021-03-10:
|- style="font-size:11pt"  valign="bottom"
{| class="wikitable"  
| width="90" height="20" | Database
|-  
| width="67" | Total Records
||  
| width="120" | current to date
|| Number of profiles


|-  valign="bottom"
|-  valign="bottom"
|style="font-weight:bold" height="14" | Critical Care
|| Critical Care
|style="font-size:11pt" | 127,885
|| 133831
|style="font-size:11pt" | 2019-12-31
 
|-  valign="bottom"
|-  valign="bottom"
|style="font-weight:bold" height="14" | Medicine
|| Medicine
|style="font-size:11pt" | 185,441
|| 201470
|style="font-size:11pt" | 2019-12-31
 
|-  valign="bottom"
|-  valign="bottom"
|style="font-weight:bold" height="14" | TOTAL
|| Total
|style="font-size:11pt" | 313,326
|| 335301
|style="font-size:11pt" | 2019-12-31
 
|}
|}



Revision as of 14:41, 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;