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.