Total admissions ICU/Med

From CCMDB Wiki
Revision as of 10:42, 2019 June 26 by JMojica (talk | contribs)
Jump to navigation Jump to search

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;