L-tables

Data in CCMMDB.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_ files currently in use are:

• L_Como
• L_Dxs
• L_Green - not used, legacy only
• L_Labs - only used on Critical Care PDAs, but present on all
• L_Log
• L_Pharm - only used on Critical Care PDAs, but present on all
• L_TmpV2