CT Summary Discharges query

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

• CT_Summary_Discharges_FiscalYear query - same but by fiscal year