CT Summary Discharges FiscalYear query: Difference between revisions

Revision as of 11:05, 2021 August 26

CT Summary Discharges FiscalYear query is a query in CFE.

Counts the profiles discharged from each site and location during a Fiscal year period.

	The previous query said "*Data: will be counts of Completes in RecordStatus field" - why would this be only completes? Wouldn't we still report on incompletes that have dispo dttm filled in?

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_FiscalYear is a query in [[CFE]].
+{{PAGENAME}} is a query in [[CFE]].
-*'''Purpose''' : Summarizes the total discharges included in the periodic report for each site and Fiscal year period.
+===Purpose===
-*Column:   Dbase (CC /Med) x HOSP_LOC
+* workload analysis
-*Row: yyyy of DISCHARGE DATE
+* cross-check for reporting
-*Data:  will be counts of Completes in RecordStatus field
-[[Category:CFE Data Integrity Checks]]
+===Description===
+Counts the profiles discharged from each site and location during a Fiscal year period.
+{{DJ|
+* The previous query said "*Data:  will be counts of Completes in RecordStatus field" - why would this be only completes? Wouldn't we still report on incompletes that have dispo dttm filled in?
+}}
+=== 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:P Query]]
+[[Category:CT Query]]