CT Summary Discharges query: Difference between revisions
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) mNo edit summary |
||
| Line 1: | Line 1: | ||
P Summary Discharges is a query in [[CFE]]. | P Summary Discharges is a query in [[CFE]]. | ||
=== View 1 - quarterly count of discharges === | |||
*'''Purpose''' : Summarizes the total discharges included in the periodic report for each site and quarter period. | *'''Purpose''' : Summarizes the total discharges included in the periodic report for each site and quarter period. | ||
*Column: Dbase (CC /Med) x HOSP_LOC | *Column: Dbase (CC /Med) x HOSP_LOC | ||
*Row: yyyy/qtr of DISCHARGE DATE | *Row: yyyy/qtr of DISCHARGE DATE | ||
*Data: will be counts of completes | *Data: will be counts of completes | ||
=== View 2 - count of discharges by calendar year === | |||
*'''Purpose''' : Summarizes the total discharges included in the periodic report for each site and calendar year period. | |||
*Column: Dbase (CC /Med) x HOSP_LOC | |||
*Row: yyyy of '''DISCHARGE DATE''' | |||
*Data: will be counts of completes | |||
[[Category:CFE Data Integrity Checks]] | [[Category:CFE Data Integrity Checks]] | ||
[[Category:Centralized data front end.accdb]] | [[Category:Centralized data front end.accdb]] | ||