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 16: | Line 16: | ||
[[Category:CFE Data Integrity Checks]] | [[Category:CFE Data Integrity Checks]] | ||
[[Category:Centralized data front end.accdb]] | [[Category:Centralized data front end.accdb]] | ||
[[Category:P Query]] | |||
Revision as of 10:04, 2021 July 27
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