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
PATIENT
character (or numeric if possible)
Code to identify patient (Cohort Patient ID)
VS_ID
character. see coding table
Viral test
VS_D
yyyy-mm-dd
Measurement date
VS_D_A
character: see coding of date precision
optional precision annotation for date of measurement
VS_R

numeric:

  • 1 = Positive
  • 0 = Negative
  • 9 = Unknown/borderline
Measurement result
VS_V
numeric
Measurement value (HCV-RNA & HBV-DNA only) (copies/ml)
VS_TT

numeric:

  • 1 = Quantitative
  • 2 = Qualitative
Test type
VS_U
character. see coding table for valid codings.
Measurement unit

Additional Fields

Field name
Format
Description
VS_LL
numeric
IF AVAILABLE, Lower limit of assay
VS_UL
numeric
IF AVAILABLE, Upper limit of assay
VS_T
character. see coding table for valid codings.
IF AVAILABLE, type of ASSAY used for this measurement
VS_ST
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