L Labs Flowsheet table: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m →Data Structure: m |
Ttenbergen (talk | contribs) |
||
| Line 17: | Line 17: | ||
== Meaning of lines == | == 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]]. | 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]]. | ||
==Collection Method== | ==Collection Method== | ||
Revision as of 16:37, 5 December 2016
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.
Collection Method
- HSC: off EPR in labs
- Grace: manually from paper chart
- Con: manually from paper chart
- STB: EPR
- Oak: ???
- VIC: manually from paper chart. ABG's aren't entered into the EPR at this site.
Labs no longer collected
See: Legacy Labs