CT Summary Discharges query: Difference between revisions
Jump to navigation
Jump to search
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]] | ||
Revision as of 16:44, 2018 February 7
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.
- Column: Dbase (CC /Med) x HOSP_LOC
- Row: yyyy/qtr of DISCHARGE DATE
- 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