CT Summary Discharges query: Difference between revisions

← Older edit

@@ Line 1: / Line 1: @@
-P Summary Discharges is a query in [[CFE]].
+{{PAGENAME}} is a query in [[CFE]].
-*'''Purpose''' : {{discussion}}
+===Purpose===
-*Column: {{discussion}}
+* workload analysis
-*Row: {{discussion}}
+* cross-check for reporting
-*Data: {{discussion}}
-[[Category:CFE Data Integrity Checks]]
+===Description===
+Counts the discharges (profiles with discharge dates) for each site/program.
+=== by calendar year ===
+To view the results by calendar year, just change the Dispo_period column from
+<code> Format(dispo_dttm, "YYYY-MM")</code> to <code> Format(dispo_dttm, "YYYY")</code>
+=== See also ===
+* [[CT_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:CT Query]]