CT Outstandings Dispo query: Difference between revisions

Latest revision as of 11:04, 25 August 2021

CT Outstandings Dispo query is a query in CFE.

Counts the profiles with RecordStatus="Incomplete" who are no longer in the unit or ward for grouped by their laptop, site, program and Dispo DtTm month.

@@ Line 1: / Line 1: @@
-Query P_Outstandings_Dispo is a query in [[CFE]].
+{{PAGENAME}} is a query in [[CFE]].
-*'''Purpose''' : Summarizes the pending patients who are no longer in the unit or ward for each laptop by their [[Dispo DtTm]] month and provides the counts of patients.
+===Purpose===
+* Backlog review
-*Data: will be counts of Incompletes in [[RecordStatus]] field WITH a [[Dispo DtTm]].
+=== Definition ===
+* Counts the profiles with [[RecordStatus]]="Incomplete" who are no longer in the unit or ward for grouped by their laptop, site, program and [[Dispo DtTm]] month.
+=== See also ===
+* [[CT_Outstandings query]] - count of all profiles currently on laptops
 == Related articles ==
@@ Line 9: / Line 14: @@
 [[Category:Data Processing]]
-[[Category:CFE Data Integrity Checks]]
+[[Category:Database Manager]]
 [[Category:Centralized data front end.accdb]]
-[[Category:P Query]]
+[[Category:CT Query]]