Query L Pharm total: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
Created page with "Lines in this table L Pharm Flowsheet give an incremental picture of how many pharmacy entries were counted since last count for this patient. For a total count of pharmac..."
 
m link fix
Line 1: Line 1:
Lines in this table [[L Pharm Flowsheet]] give an incremental picture of how many pharmacy entries were counted since last count for this patient. For a total count of pharmacy for a patient see ''query L_Pharm_total''.
Lines in this table [[L Pharm Flowsheet table]] give an incremental picture of how many pharmacy entries were counted since last count for this patient. For a total count of pharmacy for a patient see ''query L_Pharm_total''.


This query eliminates the entry_date field, groups by D_ID, and sums all other fields.
This query eliminates the entry_date field, groups by D_ID, and sums all other fields.


[[Category: Pharmacy]]
[[Category: Pharmacy]]

Revision as of 17:04, 28 December 2016

Lines in this table L Pharm Flowsheet table give an incremental picture of how many pharmacy entries were counted since last count for this patient. For a total count of pharmacy for a patient see query L_Pharm_total.

This query eliminates the entry_date field, groups by D_ID, and sums all other fields.