CT Summary Discharges FiscalYear query

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.

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? --JMojica 16:59, 2022 February 8 (CST)

• SMW

• Cargo

• Categories

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