tblLAB_RES_LVL_2 - Mutations
holds mutations and positions of these.
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 |
| GENE | character:
|
Type of sequence/gene (PRO, RT, GP41, GP120) |
| AA_POS | numeric | Position of the mutation in the sequence |
| AA_POS_SUB | character:
|
Subposition used to code insertions |
| AA_FOUND_1 | character. empty = Amino acid has been deleted. | Mutation (Amino acid) found in the sequence |
| AA_FOUND_2 | character. empty = Amino acid has been deleted. | Mutation (Amino acid) found in the sequence (if more than 1) |
| AA_FOUND_3 | character. empty = Amino acid has been deleted. | Mutation (Amino acid) found in the sequence (if more than 2) |
| AA_FOUND_4 | 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 | 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_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 |