wiki:Hicdep_1.80/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_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

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 4 years ago Last modified on 11/08/13 10:35:27