CT Summary Discharges FiscalYear query: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
← Older edit
JMojica (talk | contribs)
CCMDB_legit, admin, approved, Administrators
2,835 edits
m →Description: Thanks for the clarification; I had already set it to not consider complete/incomplete status, so no further documentation or action needed.
 
Line 7: Line 7:
===Description===
===Description===
Counts the profiles discharged from each site and location during a Fiscal year period.
Counts the profiles discharged from each site and location during a Fiscal year period.
{{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?
** 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 ===

Latest revision as of 13:42, 9 February 2022

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

Related articles

Related articles:
Retrieved from "https://ccmdb.kuality.ca/index.php?title=CT_Summary_Discharges_FiscalYear_query&oldid=154533"