L-tables

In both Access and HanDBase, data is kept either in “L_”- or in “S_”-files or 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" Files.

There are L_ files on your PDA, which is where HanDBase stores its L_ tables. Copies of these files are located on the desktop PC and on the network in the L_Handbase folder, and there in a subdirectory corresponding to the location of the PDA. The L_ files sync into the L_ tables of the same name in the CCMDB.mdb Access program.

The L_ files currently in use are:

• L_Como
• L_Dxs
• L_Green
• L_Labs (only used on Critical Care PDAs, but present on all)
• L_Log
• L_Pharm
• L_TmpV2 (only used on Critical Care PDAs, but present on all)