Total admissions ICU/Med: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
m Text replacement - "[[Category: " to "[[Category:"
 
(16 intermediate revisions by 3 users not shown)
Line 2: Line 2:


{{Article needing periodic review
{{Article needing periodic review
  | NextReviewDate = 2018-10-16
  | NextReviewDate = 2026-01-01
}}
}}


{| class="wikitable" border=1 <hiddentext> set to 0 for no borders</hiddentext>
As of 2024-12-31:
|- 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
|| [[Definition of a Critical Care Program Admission|Critical Care]]
|style="font-size:11pt" | 121855
|| {{formatnum: {{N CC}} }}
|style="font-size:11pt" | 2018-12-05
 
|-  valign="bottom"
|-  valign="bottom"
|style="font-weight:bold" height="14" | Medicine
|| [[Definition of a Medicine Program Admission|Medicine]]
|style="font-size:11pt" | 170049
|| {{formatnum: {{N Med}} }}
|style="font-size:11pt" | 2018-12-05


|-  valign="bottom"
|-  valign="bottom"
|style="font-weight:bold" height="14" | TOTAL
|| Total
|style="font-size:11pt" | 277,425
|| {{N Tot}}
|style="font-size:11pt" | 2018-12-05
 
|}
|}


Line 36: Line 35:
</pre>
</pre>


== Related articles ==
{{Related Articles}}


[[Category: Reporting]]
[[Category:Reporting]]
[[Category: Statistical Analysis]]
[[Category:Statistical Analysis]]
[[Category:About]]

Latest revision as of 11:01, 30 July 2025

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 2026-01-01.

As of 2024-12-31:

Number of profiles
Critical Care 153,300
Medicine 243,573
Total 396,873

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;

Related articles

Related articles: