CT Summary Discharges FiscalYear query: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
Created page with "P_Summary_discharges_FiscalYear is a query in CFE. Category:CFE Data Integrity Checks Category:Centralized data front end.accdb"
 
mNo edit summary
Line 1: Line 1:
P_Summary_discharges_FiscalYear is a query in [[CFE]].  
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


[[Category:CFE Data Integrity Checks]]
[[Category:CFE Data Integrity Checks]]
[[Category:Centralized data front end.accdb]]
[[Category:Centralized data front end.accdb]]

Revision as of 14:03, 7 February 2018

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