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
Format
Description
TEST_ID
character (or numeric if possible)
Identifier linking this record to tblLAB_RES
ATC_CODE
character
​ATC code of the medication
RES_SCOR
character
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
Format
Description
RES_CUT
character
Cut-off value for phenotype test result
RES_SCOR_ID

character:

  • a = first
  • b = second
  • etc.

character:

  • 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