Query L Labs total

From CCMDB Wiki
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.