L Labs Flowsheet table
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.
It is linked to L_Log table by D_ID.
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
| FieldName | FieldDataType | order in table | |
|---|---|---|---|
| Pat ID field | Pat_ID | number | 1 |
| D ID field | D_ID | string | 1 |
| CBC | CBC | integer | 4 |
| PT PTT | PT_PTT | integer | 5 |
| FFP | FFP | integer | 7 |
| Platelets | Platelets | integer | 8 |
| Albumin 25pct | Albumin_25pct | integer | 9 |
| Albumin 5pct | Albumin_5pct | integer | 10 |
| Creatinine (labs) | Creatinine | integer | 11 |
| Magnesium (labs) | Magnesium | integer | 12 |
| SGPT ALT (labs) | SGPT_ALT | integer | 13 |
| Troponin | Troponin | integer | 14 |
| CXR | CXR | integer | 15 |
| CT Scan (labs) | CT_Scan | integer | 16 |
| Angio coronary field | Angio_coronary | integer | 17 |
| Angio others field | Angio_others | integer | 18 |
| Echocardiogram | US_Echo | number | 19 |
| Abdominal ultrasound | US_Abd | integer | 20 |
| Sputum C+S | Sputum_CS | integer | 21 |
| Blood culture | Blood_CS | not entered | 22 |
| Urine CS | Urine_CS | integer | 23 |
| Arterial blood gas (labs) | ABG | integer | 24 |
| Venous blood gas (labs) | VBG | integer | 25 |
| Pentaspan | Pentaspan | integer | 26 |
| MRI (labs) | MRI | integer | 27 |
| Voluven | Voluven | integer | 28 |
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