Query L Pharm total

From CCMDB Wiki
Jump to navigation Jump to search

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.