Wiki

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: PRO = PRO sequence RT = RT sequence GP41 = GP41 sequence GP120 = GP120 sequence Type of sequence/gene (PRO, RT, GP41, GP120)
AA_POS numeric Position of the mutation in the sequence
AA_POS_SUB character: a = first b = second etc. 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.

Table	Crosstable	Error Code	Description	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