tblLAB_RES_LVL_3 - Resistance test result

holds resistance result in relation to antiretroviral drug.

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

Table Crosstable Error Code Description Study specific Is HICDEP
AllTables CrossTable ATC001 any date in database after DEATH_D in tblLTFU Yes
AllTables CrossTable ATC002 any date in database after DROP_D in tblLTFU Yes
AllTables CrossTable ATC003 any date in database before BIRTH_D in tblBAS Yes
AllTables CrossTable ATC004 any date in database in the future Yes
AllTables CrossTable ATC005 patients submitted previously who have been missed out Yes
AllTables CrossTable ATC006 Any fields not coded as coding lists on table definition Yes
tblLAB_RES_LVL_3 WithinTable L3W001 Duplicate records for same TEST_ID and ATC_CODE Yes
tblLAB_RES_LVL_3 WithinTable L3W002 Missing TEST_ID Yes
tblLAB_RES_LVL_3 WithinTable L3W003 Missing ATC_CODE Yes
tblLAB_RES_LVL_3 WithinTable L3W004 Missing RES_SCOR Yes
tblLAB_RES_LVL_3 CrossTable L3C001 TEST_ID not in tblLAB_RES.TEST_ID Yes