Total admissions ICU/Med: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
No edit summary
 
(31 intermediate revisions by 3 users not shown)
Line 1: Line 1:
Total number of encounters in the ICU and Medicine in Database: [[CCMDB]].
Total number of encounters in the ICU and Medicine in Database: [[CCMDB]].
*This article is updated intermittently.


{{Article needing periodic review
| NextReviewDate = 2023-01-01
}}


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


|-  valign="bottom"
|-  valign="bottom"
|style="font-weight:bold" height="14" | Critical Care
|| [[Definition of a Critical Care Laptop Admission|Critical Care]]
|style="font-size:11pt" | 85,669
|| 138141
|style="font-size:11pt" | May 17.12


|-  valign="bottom"
|-  valign="bottom"
|style="font-weight:bold" height="14" | Medicine
|| [[Definition of a Medicine Laptop Admission|Medicine]]
|style="font-size:11pt" | 86,497
|| 211415
|style="font-size:11pt" | May 17.12


|-  valign="bottom"
|-  valign="bottom"
|style="font-weight:bold" height="14" | TOTAL
|| Total
|style="font-size:11pt" | 172,166
|| 349556
|style="font-size:11pt" | May 17.12


|}
|}


==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:
<pre>
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;
</pre>
== Related articles ==
{{Related Articles}}


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

Latest revision as of 14:07, 2022 January 5

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

As of 2021-12-31:

Number of profiles
Critical Care 138141
Medicine 211415
Total 349556

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:
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Total_admissions_ICU/Med&oldid=153818"