CT Summary Discharges query: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
mNo edit summary
 
Line 13: Line 13:


=== See also ===
=== See also ===
* [[CT_Summary_discharges_FiscalYear query]] - same but by fiscal year
* [[CT_Summary_Discharges_FiscalYear query]] - same but by fiscal year


== Related articles ==  
== Related articles ==  

Latest revision as of 17:25, 15 December 2021

CT Summary Discharges query is a query in CFE.

Purpose

  • workload analysis
  • cross-check for reporting

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 Format(dispo_dttm, "YYYY-MM") to Format(dispo_dttm, "YYYY")

See also

Related articles

Related articles: