CT Count of Admissions query: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
← Older edit
Ttenbergen (talk | contribs)
CCMDB_legit, admin, approved, Bureaucrats, Interface administrators, Administrators (Semantic MediaWiki), Curators (Semantic MediaWiki), Administrators
92,608 edits
mNo edit summary
mNo edit summary
 
(8 intermediate revisions by the same user not shown)
Line 1: Line 1:
P_Count_of_Admissions is a query in [[CFE]].  
{{PAGENAME}} 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 [[:Category: Database Manager | Collection Team Manager]] for monitoring number of admission per month.
*Column:  Dbase (CC /Med) x HOSP_LOC x RecordStatus
*Row: yyyy/mmm of '''ADMIT Date'''
*Data:  will be counts of complete and incompletes


=== Definition ===
* Counts profile starts (patient admissions) of Laptop/Program/Site by year and month
* Includes complete and incomplete profiles
== Related articles ==
{{Related Articles}}


[[Category:CFE Data Integrity Checks]]
[[Category:Centralized data front end.accdb]]
[[Category:Centralized data front end.accdb]]
[[Category:Database Manager]]
[[Category:CT Query]]

Latest revision as of 11:16, 26 August 2021

CT Count of Admissions query is a query in CFE.

Purpose

  • workload assessment

Definition

  • Counts profile starts (patient admissions) of Laptop/Program/Site by year and month
  • Includes complete and incomplete profiles
Related articles:
Retrieved from "https://ccmdb.kuality.ca/index.php?title=CT_Count_of_Admissions_query&oldid=151709"