L-tables
Data in CCMDB.mdb is kept either in “L_”- or in s-tables.
The “L_”-repositories store the actual data collected on patients. Their structure is the same at all locations, but the content differs. L_ stands for "Local", in contrast to the s-tables.
Copies of the L-tables exist at specific file locations on the laptop and on the Regional Server.
The L_ tables are:
- L_Como
- L_Dxs
- L_Log
- L_TmpV2
- L_Labs_flowsheet - only used in Critical Care
- L_Pharm_flowsheet - only used in Critical Care
Some legacy L_ tables no longer used or present are
- L_Green
- L_Labs - only used in Critical Care
- L_Pharm_flowsheet - only used in Critical Care (soon to be...)