tblLAB_RES_LVL_2 - Mutations


holds mutations and positions of these.

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)
Identifier linking this record to tblLAB_RES

character:

  • PRO = PRO sequence
  • RT = RT sequence
  • GP41 = GP41 sequence
  • GP120 = GP120 sequence
Type of sequence/gene (PRO, RT, GP41, GP120)
numeric
Position of the mutation in the sequence

character:

  • a = first
  • b = second
  • etc.
Subposition used to code insertions
character. empty = Amino acid has been deleted.
Mutation (Amino acid) found in the sequence
character. empty = Amino acid has been deleted.
Mutation (Amino acid) found in the sequence (if more than 1)
character. empty = Amino acid has been deleted.
Mutation (Amino acid) found in the sequence (if more than 2)
character. empty = Amino acid has been deleted.
Mutation (Amino acid) found in the sequence (if more than 3)
AA_FOUND_# could be extended if mixtures with more than 4 amino acids are found.

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_RES_LVL_2WithinTableL2W001AA_FOUND_x but nothing in AA_FOUND(x-1) Yes
tblLAB_RES_LVL_2WithinTableL2W002Duplicate records per TEST_ID, GENE, AA_POS and AA_POS_SUB Yes
tblLAB_RES_LVL_2WithinTableL2W003Missing TEST_ID Yes
tblLAB_RES_LVL_2WithinTableL2W004Missing GENE Yes
tblLAB_RES_LVL_2WithinTableL2W005Missing AA_POS Yes
tblLAB_RES_LVL_2WithinTableL2W006Missing AA_POS_SUB Yes
tblLAB_RES_LVL_2WithinTableL2W007Missing AA_FOUND_1 Yes
tblLAB_RES_LVL_2CrossTableL2C001TEST_ID not in tblLAB_RES.TEST_ID Yes