Query L Labs total

From CCMDB Wiki
Revision as of 13:08, 16 April 2015 by Ttenbergen (talk | contribs) (Created page with "Lines in this table L Labs Flowsheet give an incremental picture of how many labs were counted since last count for this patient. For a total count of labs for a patient s...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

Lines in this table L Labs Flowsheet give an incremental picture of how many labs were counted since last count for this patient. For a total count of labs for a patient see Query L_Labs_total.

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