Difference between revisions of "CT Count of Admissions query"

From CCMDB Wiki
Jump to navigation Jump to search
m
m
 
(6 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
=== 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:Database Manager]]
[[Category:CT Query]]

Latest revision as of 11:16, 2021 August 26

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

Related articles: