CT Count of Admissions query: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
mNo edit summary
Line 14: Line 14:
[[Category:CFE Data Integrity Checks]]
[[Category:CFE Data Integrity Checks]]
[[Category:Centralized data front end.accdb]]
[[Category:Centralized data front end.accdb]]
[[Category:P Query]]

Revision as of 10:04, 2021 July 27

P_Count_of_Admissions is a query in CFE.

  • Purpose : Summarizes the total patient admissions of each site by month for workload assessment.
  • (status of number of admissions)
  • Column: Dbase (CC /Med) x HOSP_LOC x RecordStatus
  • Row: yyyy/mmm of ADMIT Date
  • Data: will be counts of complete and incompletes

Related articles

Related articles: