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?

• 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_FiscalYear query - same but by fiscal year