Difference between revisions of "CT Summary Discharges query"

From CCMDB Wiki
Jump to navigation Jump to search
m
m
Line 16: Line 16:
[[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 Summary Discharges is a query in CFE.

View 1 - quarterly count of discharges

  • Purpose : Summarizes the total discharges included in the periodic report for each site and quarter period.
  • Column: Dbase (CC /Med) x HOSP_LOC
  • Row: yyyy/qtr of DISCHARGE DATE
  • Data: will be counts of completes

View 2 - count of discharges by calendar year

  • Purpose : Summarizes the total discharges included in the periodic report for each site and calendar year period.
  • Column: Dbase (CC /Med) x HOSP_LOC
  • Row: yyyy of DISCHARGE DATE
  • Data: will be counts of completes