tblLAB - Laboratory values


holds type, date, value and unit of laboratory tests.

Core Fields

Note: Fields marked bold form the unique identifier for a record of the table.
Field name
Format
Description
character (or numeric if possible)
Code to identify patient (Cohort Patient ID)
character. see coding table for valid codings.
Code representing the measurement
yyyy-mm-dd
Date of measurement/sample
optional precision annotation for date of measurement/sample
  • 1 = Positive (including trace, 1+, 2+, etc.)
  • 0 = Negative
  • 9 = Unknown/borderline
Measurement result
numeric: -1 = undetectable or detection limit as negative value
Value of measurement
numeric. see coding table for valid codings.
Unit of measurement

Additional Fields

Other detailed information regarding the patient and the measurement would be relevant, like the proposed fasting information shown below.
Field name
Format
Description

numeric:

  • 0 = No
  • 1 = Yes
  • 9 = Unknown
Was the blood sample taken while fasting?
character. see coding table for valid codings.
Code representing the specimen type
Depending on the set of measurements collected and the mandatory fields applicable to these individual measurements, it might be useful to separate the LAB table into several sub tables. This is already shown for the CD4 and RNA measurements: the level of detail needed for CD4 is less than for the LAB variables in general (no unit since it’s always the same), while for RNA the data required is more detailed (assay and detection limit).

QA Checks


TableCrosstableError CodeDescriptionStudy specificHICDEP?
AllTablesCrossTableATC001any date in database after DEATH_D in tblLTFU Yes
AllTablesCrossTableATC002any date in database after DROP_D in tblLTFU Yes
AllTablesCrossTableATC003any date in database before BIRTH_D in tblBAS Yes
AllTablesCrossTableATC004any date in database in the future Yes
AllTablesCrossTableATC005patients submitted previously who have been missed out Yes
AllTablesCrossTableATC006Any fields not coded as coding lists on table definition Yes
tblLABWithinTableLW001Duplicate records Yes
tblLABWithinTableLW002Missing LAB_D Yes
tblLABWithinTableLW003Missing LAB_V Yes
tblLABWithinTableLW004Missing LAB_U Yes
tblLABWithinTableLW005Missing LAB_ID Yes
tblLABWithinTableLW008Missing LAB_FA Yes
tblLABWithinTableLW009Missing LAB_ST Yes
tblLABWithinTableLW010LAB_V out of range for unit LAB_U Yes
tblLABCrossTableLC001Patient has no record in BAS table Yes