tblLAB_VIRO - Laboratory values - viro-/serology


holds test results for viro-/serological tests (hepatitis etc.)

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
Viral test
yyyy-mm-dd
Measurement date
optional precision annotation for date of measurement

numeric:

  • 1 = Positive
  • 0 = Negative
  • 9 = Unknown/borderline
Measurement result
numeric
Measurement value (HCV-RNA & HBV-DNA only) (copies/ml)
character. see coding table for valid codings.
Measurement unit

Additional Fields

Field name
Format
Description
numeric
IF AVAILABLE, Lower limit of assay
numeric
IF AVAILABLE, Upper limit of assay
character. see coding table for valid codings.
IF AVAILABLE, type of ASSAY used for this measurement
character
Specimen type

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
tblLAB_VIROCrossTableLVC001Patient doesn't have a record in BAS Yes
tblLAB_VIROWithinTableLVW002Missing patient Yes
tblLAB_VIROWithinTableLVW003Missing VS_ID Yes
tblLAB_VIROWithinTableLVW004Missing VS_D Yes
tblLAB_VIROWithinTableLVW005Missing VS_R Yes
tblLAB_VIROWithinTableLVW006Missing VS_V Yes
tblLAB_VIROWithinTableLVW007Missing VS_U Yes
tblLAB_VIROWithinTableLVW008More or less than exactly 1 positive HIV test per patient Yes
tblLAB_VIROWithinTableLVW009More than 1 negative HIV test for a patient Yes
tblLAB_VIROWithinTableLVW010Date of negative test after date of positive test Yes
tblLAB_VIROWithinTableLVW011Duplicate records Yes