L Labs Flowsheet table: Difference between revisions
Jump to navigation
Jump to search
TOstryzniuk (talk | contribs) m →Data Structure: minor |
TOstryzniuk (talk | contribs) m minor |
||
| Line 1: | Line 1: | ||
The '''L_Labs_Flowsheet''' table in the [[CCMDB.mdb]] and [[Centralized_data.mdb]] contains the data we collect as part of [[Lab Collection Process]]. | 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 == | == Data Structure == | ||
Revision as of 11:44, 30 October 2015
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
- D_ID - link to L_Log
- Entry_dt - date line was entered, see #Meaning of lines
- CBC
- PT_PTT
- Packed_Cells
- FFP
- Platelets
- Albumin_25pct
- Albumin_5pct
- Creatinine
- MG
- SGPT_ALT
- Troponin (TNT)
- CXR
- CT_Scan
- Angio_coronary
- Angio_others
- US_Echo
- US_Abd
- Sputum_CS
- Blood_CS
- Urine_CS
- ABG
- MRI
- Pentaspan -no longer collected
- Voluven - no longer collected
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.
Template:Discussion Does everyone count ABG from labs in EPR at their site or from paper in charts? Thank you. -Trish Ostryzniuk 12:35, 2015 October 30 (CDT)