Changes between Version 2 and Version 3 of Hicdep_1.30/TableLabRes


Ignore:
Timestamp:
12/28/10 09:00:12 (8 years ago)
Author:
stels
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • Hicdep_1.30/TableLabRes

    v2 v3  
    44 
    55 TODO:: abstract for this table 
     6 
     7 TODO:: it is somewhat unclear to me which paragraph from the .doc is mapped to which specific article -> double-check. 
    68 
    79//Note//: This table is tightly linked to [[TableLabResLvl1|tblLAB_RES_LVL_1]], [[TableLabResLvl2|tblLAB_RES_LVL_2]] and [[TableLabResLvl3|tblLAB_RES_LVL_3]]. 
     
    3436== Additional fields == 
    3537 
    36  TODO:: it is somewhat unclear to me what should be captured here ~stels~ 
     38As shown with the core fields, the //SAMP_ID// is the link between the 3 levels of data and the test background information table. The sample identifier, however, must be unique for the format to work. This might not always be the case. If needed //SAMPLE_D// could be used as an additional part of the key, or just //SAMPLE_D// along with the //PATIENT// key^1^.  
     39 
     40Some prior assessment of the assigned sample identifiers has to be done in order to avoid duplicates.  
     41 
     42In a running database the duplicate issues are easily resolved by adding a unique auto-generated key as the identifier between 3 levels of data and the test background information table //SAMP_ID//.  
     43 
     44Along with the //SAMP_ID// it might be necessary to store the ID assigned to the sample at both the testing laboratory but also the centres laboratory in order to track the sample. Each of these could also be used as the //SAMP_ID// value. 
     45 
     46^1^: However this raises the issue about several aliquots from the same day will look like duplicates in the tables. 
     47 
     48 * //[[TableLabRes/FieldSampLab|SAMP_LAB]]//: The assigned sample ID at the lab where the resistance test is preformed. 
     49 * //[[TableLabRes/FieldSampInt|SAMP_INT]]//: The assigned sample ID from the centre. 
     50