L-tables: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
No edit summary
m (m)
 
(21 intermediate revisions by the same user not shown)
Line 1: Line 1:
The L_ files and tables are where the actual patient data is stored. L_ stands for "Local", in contrast to the [["S" Files]].  
The "L_"-tables 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.  


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.
Copies of the L-tables exist at specific [[File Locations|file locations]] on the laptop and on the [[Regional Server]].
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:
'''See [[:Category:L Table]]'''
*[[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)


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]]


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

Latest revision as of 23:04, 2017 September 16

The "L_"-tables 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.

See Category:L Table

Some legacy L_ tables no longer used or present are

Retrieved from "https://ccmdb.kuality.ca/index.php?title=L-tables&oldid=57780"