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 - only used in Critical Care (soon to be...)