CT Summary Discharges query: Difference between revisions

← Older edit Newer edit →

@@ Line 1: / Line 1: @@
-P Summary Discharges is a query in [[CFE]].
+{{PAGENAME}} is a query in [[CFE]].
-=== View 1 - quarterly count of discharges ===
+===Purpose===
-*'''Purpose''' : Summarizes the total discharges included in the periodic report for each site and quarter period.
+workload analysis
-*Column:   Dbase (CC /Med) x HOSP_LOC
-*Row: yyyy/qtr of DISCHARGE DATE
-*Data:  will be counts of completes
-=== View 2 - count of discharges by calendar year ===
+===Description===
-*'''Purpose''' : Summarizes the total discharges included in the periodic report for each site and calendar year period.
+Counts the discharges (profiles with discharge dates) for each laptop/site/program.
-*Column:   Dbase (CC /Med) x HOSP_LOC
-*Row: yyyy of '''DISCHARGE DATE'''
-*Data:  will be counts of completes
+{{DJ |
+* This said "included in the periodic report for each site and quarter period". Is this query actually used for a report? Or who uses it for what?
+}}
-[[Category:CFE Data Integrity Checks]]
+=== by calendar year ===
+To view the results by calendar year, just change
+<code> Format(dispo_dttm, "YYYY-MM")</code> to <code> Format(dispo_dttm, "YYYY")</code>
+=== See also ===
+* [[P Summary discharges FiscalYear query]] - same but by fiscal year
+== Related articles ==
+{{Related Articles}}
+[[Category:Data Processing]]
+[[Category:Database Manager]]
 [[Category:Centralized data front end.accdb]]
-[[Category:P Query]]
+[[Category:CT Query]]