CT Count of Admissions query

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)
  • replaces SAS run Statistician does for 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