CT Outstandings query: Difference between revisions

mNo edit summary
mNo edit summary
Line 1: Line 1:
P_Outstandings is a query in [[CFE]].  
P_Outstandings is a query in [[CFE]].  


*'''Purpose''' : {{discussion}}
*'''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: {{discussion}}
** {{discussion}} how is that different from [[P_Outstandings]]?
*Row: {{discussion}}
*Column: yyyy/mmm of ADMIT DATE
*Data: {{discussion}}
*Row: Dbase (CC/Med) x Hosp_Loc
 
*Data: will be counts of Incompletes in RecordStatus field WITH and WITHOUT a discharge date.


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