wiki:Hicdep_1.80/TableLab

Version 1 (modified by admin, 4 years ago) (diff)

Copy from Hicdep 1.70

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

PATIENT

character (or numeric if possible)

Code to identify patient (Cohort Patient ID)

LAB_ID

character. see coding table for valid codings.

Code representing the measurement

LAB_D

yyyy-mm-dd

Date of measurement/sample

LAB_V

numeric: -1 = undetectable or detection limit as negative value

for dipstick results:

  • 0 = Negative
  • 9 = Trace
  • 1 = 1+
  • 2 = 2+
  • 3 = 3+
  • 4 = 4+

Value of measurement

LAB_U

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

LAB_FA

numeric:

  • 1 = Yes
  • 0 = No
  • 9 = Unknown

Was the blood sample taken while fasting?

LAB_ST

  • WB = Whole Blood
  • P = Plasma
  • S = Serum
  • U24 = 24h Urine
  • U = Urine

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

Table Crosstable Error Code Description Study specific HICDEP?
AllTablesCrossTableATC001any date in database after DEATH_D in tblLTFUYES
AllTablesCrossTableATC002any date in database after DROP_D in tblLTFUYES
AllTablesCrossTableATC003any date in database before BIRTH_D in tblBASYES
AllTablesCrossTableATC004any date in database in the futureYES
AllTablesCrossTableATC005patients submitted previously who have been missed outYES
AllTablesCrossTableATC006Any fields not coded as coding lists on table definitionYES
tblLABWithinTableLW001Duplicate recordsYES
tblLABWithinTableLW002Missing LAB_DYES
tblLABWithinTableLW003Missing LAB_VYES
tblLABWithinTableLW004Missing LAB_UYES
tblLABWithinTableLW005Missing LAB_IDYES
tblLABWithinTableLW008Missing LAB_FAYES
tblLABWithinTableLW009Missing LAB_STYES
tblLABWithinTableLW010LAB_V out of range for unit LAB_UYES
tblLABCrossTableLC001Patient has no record in BAS tableYES