CT Summary Discharges query: Difference between revisions

Latest revision as of 17:25, 2021 December 15

CT Summary Discharges query is a query in CFE.

Counts the discharges (profiles with discharge dates) for each site/program.

To view the results by calendar year, just change the Dispo_period column from Format(dispo_dttm, "YYYY-MM") to Format(dispo_dttm, "YYYY")

@@ 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
+* cross-check for reporting
-*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 site/program.
-*Column:   Dbase (CC /Med) x HOSP_LOC
-*Row: yyyy of '''DISCHARGE DATE'''
-*Data:  will be counts of completes
+=== 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>
-[[Category:CFE Data Integrity Checks]]
+=== 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:P Query]]
+[[Category:CT Query]]