wiki:Hicdep_1.110/TableLabViro

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_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

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
tblLAB_VIROCrossTableLVC001Patient doesn't have a record in BASYES
tblLAB_VIROWithinTableLVW002Missing patient YES
tblLAB_VIROWithinTableLVW003Missing VS_IDYES
tblLAB_VIROWithinTableLVW004Missing VS_DYES
tblLAB_VIROWithinTableLVW005Missing VS_RYES
tblLAB_VIROWithinTableLVW006Missing VS_VYES
tblLAB_VIROWithinTableLVW007Missing VS_UYES
tblLAB_VIROWithinTableLVW008More or less than exactly 1 positive HIV test per patientYES
tblLAB_VIROWithinTableLVW009More than 1 negative HIV test for a patientYES
tblLAB_VIROWithinTableLVW010Date of negative test after date of positive testYES
tblLAB_VIROWithinTableLVW011Duplicate recordsYES
Last modified 9 months ago Last modified on 08/07/17 11:16:57