wiki:Hicdep_1.80/TableLabResLvl3

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

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 HICDEP?
AllTablesCrossTableATC001any date in database after DEATH_D in tblLTFUYES
AllTablesCrossTableATC002any date in database after DROP_D in tblLTFUYES
AllTablesCrossTableATC003any date in database before BIRTH_D in tblBASYES
AllTablesCrossTableATC004any date in database in the futureYES
AllTablesCrossTableATC005patients submitted previously who have been missed outYES
AllTablesCrossTableATC006Any fields not coded as coding lists on table definitionYES
tblLAB_RES_LVL_3WithinTableL3W001Duplicate records for same TEST_ID and ATC_CODEYES
tblLAB_RES_LVL_3WithinTableL3W002Missing TEST_IDYES
tblLAB_RES_LVL_3WithinTableL3W003Missing ATC_CODEYES
tblLAB_RES_LVL_3WithinTableL3W004Missing RES_SCORYES
tblLAB_RES_LVL_3CrossTableL3C001TEST_ID not in tblLAB_RES.TEST_IDYES
Last modified 4 years ago Last modified on 11/08/13 10:35:27