CT Outstandings query

From CCMDB Wiki
Revision as of 17:41, 7 February 2018 by Ttenbergen (talk | contribs) (Ttenbergen moved page P Outstandings to P Outstandings query without leaving a redirect)
Jump to navigation Jump to search

P_Outstandings is a query in CFE.

  • Purpose : Summarizes the pending patients who still in the unit or ward for each site by their admit month and provides the counts of long stayed patients.
  • Column: yyyy/mmm of ADMIT DATE
  • Row: Dbase (CC/Med) x Hosp_Loc
  • Data: will be counts of Incompletes in RecordStatus field WITH and WITHOUT a discharge date.