CT Summary Discharges query: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) Created page with "P Summary Discharges is a query in CFE. Category:CFE Data Integrity Checks Category:Centralized data front end.accdb" |
Ttenbergen (talk | contribs) mNo edit summary |
||
| (8 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
{{PAGENAME}} is a query in [[CFE]]. | |||
[[Category: | ===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 | |||
<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:Centralized data front end.accdb]] | ||
[[Category:CT Query]] | |||
Latest revision as of 17:25, 2021 December 15
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: |