L Labs Flowsheet table

From CCMDB Wiki
Revision as of 16:53, 20 December 2016 by Ttenbergen (talk | contribs) (Data Structure: m)
Jump to navigation Jump to search

The L_Labs_Flowsheet table in the CCMDB.mdb and Centralized_data.mdb contains the data we collect as part of Lab Collection Process. Also see Labs collected list for a list.

Data Structure

  • L_Lab_Flowsheet_ID - unique record ID
  • D_ID / Pat_ID - link to L_Log
  • Entry_dt - date line was entered, see #Meaning of lines

No pages for labs that meet the semantic mediawiki criteria

Meaning of lines

Lines in this table 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.

Labs no longer collected

See: Legacy Labs