tblLAB_RES_LVL_3 - Resistance test result

holds resistance result in relation to antiretroviral drug.

Note: This table is tightly linked to tblLAB_RES.

Core Fields

Note: Fields marked bold form the unique identifier for a record of the table.
Field name
character (or numeric if possible)
Identifier linking this record to tblLAB_RES
​ATC code of the medication
Score of resistance or recommendation given from the test

Additional Fields

For phenotype test results it will be necessary to extend the table with a field to store the cut-off value:
Field name
Cut-off value for phenotype test result


  • a = first
  • b = second
  • etc.


  • S = sensitive
  • L = low level
  • I = intermediate
  • H = high level
Coded score of the resistance or recommendation given from the test
However using the amino acid sequence does not give the same detail of data as the nucleoside sequence: wobbles in the nucleoside sequence can either complicate the reading and alignment of the amino acid sequence or the wobbles can be lost and silent mutations are lost.

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_3WithinTableL3W001Duplicate records for same TEST_ID and ATC_CODE Yes
tblLAB_RES_LVL_3WithinTableL3W002Missing TEST_ID Yes
tblLAB_RES_LVL_3WithinTableL3W003Missing ATC_CODE Yes
tblLAB_RES_LVL_3WithinTableL3W004Missing RES_SCOR Yes
tblLAB_RES_LVL_3CrossTableL3C001TEST_ID not in tblLAB_RES.TEST_ID Yes