CT Summary Discharges FiscalYear query: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
m (Ttenbergen moved page P Summary discharges FiscalYear to P Summary discharges FiscalYear query without leaving a redirect)
mNo edit summary
Line 8: Line 8:
[[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_FiscalYear is a query in CFE.

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