Total admissions ICU/Med

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

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:

CCMDB ‎ (← links) Site and Location table ‎ (← links) Database Total ICU/Med (redirect page) ‎ (← links) Articles needing periodic review ‎ (← links) Data dictionary ‎ (← links)