CT Summary Discharges FiscalYear query: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m (Ttenbergen moved page P Summary Discharges FiscalYear query to CT Summary Discharges FiscalYear query without leaving a redirect) |
|||
| Line 9: | Line 9: | ||
{{DJ| | {{DJ| | ||
* The previous query said "*Data: will be counts of Completes in RecordStatus field" - why would this be only completes? Wouldn't we still report on incompletes that have dispo dttm filled in? | * The previous query said "*Data: will be counts of Completes in RecordStatus field" - why would this be only completes? Wouldn't we still report on incompletes that have dispo dttm filled in? | ||
}} | ** This should include all discharges with dispo dttm regardless of complete or incomplete. not sure which query you are referring to saying only completes? --[[User:JMojica|JMojica]] 16:59, 2022 February 8 (CST) }} | ||
=== by calendar year === | === by calendar year === | ||
Revision as of 17:59, 2022 February 8
CT Summary Discharges FiscalYear query is a query in CFE.
Purpose
- workload analysis
- cross-check for reporting
Description
Counts the profiles discharged from each site and location during a Fiscal year period.
|
|
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 query - same but by calendar year or year-month
Related articles
| Related articles: |