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 09:04, 27 July 2021

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