CT Summary Discharges query: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) mNo edit summary |
||
Line 1: | Line 1: | ||
{{PAGENAME}} is a query in [[CFE]]. | |||
=== | ===Purpose=== | ||
workload analysis | |||
=== | ===Description=== | ||
Counts the discharges (profiles with discharge dates) for each laptop/site/program. | |||
{{DJ | | |||
* This said "included in the periodic report for each site and quarter period". Is this query actually used for a report? Or who uses it for what? | |||
}} | |||
[[Category: | === by calendar year === | ||
To view the results by calendar year, just change | |||
<code> Format(dispo_dttm, "YYYY-MM")</code> to <code> Format(dispo_dttm, "YYYY")</code> | |||
=== See also === | |||
* [[P 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: | [[Category:CT Query]] |
Revision as of 12:17, 2021 August 25
CT Summary Discharges query is a query in CFE.
Purpose
workload analysis
Description
Counts the discharges (profiles with discharge dates) for each laptop/site/program.
|
by calendar year
To view the results by calendar year, just change
Format(dispo_dttm, "YYYY-MM")
to Format(dispo_dttm, "YYYY")
See also
- P Summary discharges FiscalYear query - same but by fiscal year
Related articles
Related articles: |