CT Summary Discharges query: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m (Ttenbergen moved page P Summary Discharges query to CT Summary Discharges query without leaving a redirect: no more pivots) |
Ttenbergen (talk | contribs) mNo edit summary |
||
| Line 2: | Line 2: | ||
===Purpose=== | ===Purpose=== | ||
workload analysis | * workload analysis | ||
* cross-check for reporting | |||
===Description=== | ===Description=== | ||
Counts the discharges (profiles with discharge dates) for each | Counts the discharges (profiles with discharge dates) for each site/program. | ||
=== by calendar year === | === by calendar year === | ||
To view the results by calendar year, just change | 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> | <code> Format(dispo_dttm, "YYYY-MM")</code> to <code> Format(dispo_dttm, "YYYY")</code> | ||
=== See also === | === See also === | ||
* [[ | * [[CT_Summary_discharges_FiscalYear query]] - same but by fiscal year | ||
== Related articles == | == Related articles == | ||
Revision as of 11:01, 2021 August 26
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
Related articles
| Related articles: |