tblLAB_RES_LVL_2 - Mutations
holds mutations and positions of these.
|
Core FieldsNote: Fields marked bold form the unique identifier for a record of the table.
|
Field name Format Description character (or numeric if possible)
|
Type of sequence/gene (PRO, RT, GP41, GP120)
|
numeric Position of the mutation in the sequence
|
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
Table | Crosstable | Error Code | Description | Study specific | 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_2 | WithinTable | L2W001 | AA_FOUND_x but nothing in AA_FOUND(x-1) | | Yes |
tblLAB_RES_LVL_2 | WithinTable | L2W002 | Duplicate records per TEST_ID, GENE, AA_POS and AA_POS_SUB | | Yes |
tblLAB_RES_LVL_2 | WithinTable | L2W003 | Missing TEST_ID | | Yes |
tblLAB_RES_LVL_2 | WithinTable | L2W004 | Missing GENE | | Yes |
tblLAB_RES_LVL_2 | WithinTable | L2W005 | Missing AA_POS | | Yes |
tblLAB_RES_LVL_2 | WithinTable | L2W006 | Missing AA_POS_SUB | | Yes |
tblLAB_RES_LVL_2 | WithinTable | L2W007 | Missing AA_FOUND_1 | | Yes |
tblLAB_RES_LVL_2 | CrossTable | L2C001 | TEST_ID not in tblLAB_RES.TEST_ID | | Yes |