L-tables: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
mNo edit summary
Line 5: Line 5:
Copies of the L-tables exist at specific [[File Locations|file locations]] on the laptop and on the [[Regional Server]].
Copies of the L-tables exist at specific [[File Locations|file locations]] on the laptop and on the [[Regional Server]].


The L_ files currently in use are:  
The L_ tables are:  
*[[L_Como]]
*[[L_Como]]
*[[L_Dxs]]
*[[L_Dxs]]
*[[L_Green]] - not used, legacy only
*[[L_Labs]] - only used on [[Critical Care]] PDAs, but present on all
*[[L_Log]]
*[[L_Log]]
*[[L_Pharm]] - only used on [[Critical Care]] PDAs, but present on all
*[[L_TmpV2]]  
*[[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...)


[[Category: IT Instructions]]
[[Category: IT Instructions]]
[[Category: Standards and Conventions]]
[[Category: Standards and Conventions]]
[[Category: Data structure]]
[[Category: Data structure]]

Revision as of 19:24, 2011 December 8

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:


Some legacy L_ tables no longer used or present are