CCMDB Wiki

CT Count of Admissions query: Difference between revisions

← Older editNewer edit →
mNo edit summary
mNo edit summary
Line 1: Line 1:
P_Count_of_Admissions is a query in [[CFE]].  
P_Count_of_Admissions is a query in [[CFE]].  


*'''Purpose''' : Summarizes the total patient admissions of each site by month for workload assessment.
=== Purpose ===
*(status of number of admissions)
* workload assessment
**replaces SAS run [[Statistician]] does for [[Database Manager]] for monitoring number of admission per month.
 
*Column:  Dbase (CC /Med) x HOSP_LOC x RecordStatus
=== Definition ===
*Row: yyyy/mmm of '''ADMIT Date'''
* Counts profile starts (patient admissions) of Laptop/Program/Site by year and month
*Data:  will be counts of complete and incompletes
* Includes complete and incomplete profiles


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


[[Category:CFE Data Integrity Checks]]
[[Category:Centralized data front end.accdb]]
[[Category:Centralized data front end.accdb]]
[[Category:P Query]]
[[Category:P Query]]
Retrieved from "https://ccmdb.kuality.ca/index.php?title=CT_Count_of_Admissions_query"