tblLAB_HCV - Information on Hepatitis C Virus genotype and subtype


holds information on HCV genotype and subtype

Core Fields

Field name
Format
Description
PATIENT
Numeric
Code to identify patient (Cohort Patient ID)
SAMPLE_D
Date (yyyy-mm-dd)
Date of the actual sample taken (NOT the test date)
GENOTYPE

numeric:

  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
HCV-genotype

Please supply a row for each combination of Genotype and Subtype, e.g.:
9999999 01-01-1901 1 a
9999999 01-01-1901 1 b
(the genotype and subtype should be submitted in separate columns)
SUBTYPE

Character:

  • a
  • b
  • c
  • d
  • e
  • f
  • g
  • h
  • i
  • j
HCV-subtype
If unknown leave blank

Additional Fields

Field name
Format
Description
VIROTYPE

numeric:

  • 2 = HCV
Type of Virus

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