L-tables: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
m ("L" Files moved to "L" files)
m (m)
 
(14 intermediate revisions by the same user not shown)
Line 1: Line 1:
In both Access and HanDBase, data is kept either in “L_”- or in “S_”-files or tables.  
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.  


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


Copies of the L_ Files exist at specific [[File Locations|file locations]] on your [[PDA]], on your PC and on the [[Regional Server]].
'''See [[:Category:L Table]]'''


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.
Some legacy L_ tables no longer used or present are
The L_ files [[Syncing the PDA|sync]] into the L_ tables of the same name in the [[CCMDB.mdb]] Access program.
*[[L_Green]]  
*[[L_Labs]] - only used in [[Critical Care]]
*[[L_Pharm]] - only used in [[Critical Care]]  


Since the “L_”-files contain different data for each PDA, each PDA has its own directory on the regional server. This folder will contain all “L_”-File relevant to the associated PDA, plus two folders called archive and backup. The backup folder is where all old synchronized files are place up to 10 synchronizations back.


The files with ending with “_HDF.PDB” are the HanDBase forms used to access the data in the files of the same name minus the “_HDF”.
[[Category: Standards and Conventions]]
 
[[Category: Data structure]]
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)
 
In locations where there is more than one PDA per PC, the “L_”-files will be renamed following the template <L-File name>_<HOS>_<WAR>, i.e., the Log file name for H4 at HSC would be L_Log_HSC_H4.PDB.
 
 
{{stub}}
[[Category:IT Instructions]]
[[Category:Standards and Conventions]]

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"