tblLAB_RNA - Laboratory values

holds date, value, detection limit and type of viral assay.

Core Fields

Note: Fields marked bold form the unique identifier for a record of the table.
Field name
character (or numeric if possible)
Code to identify patient (Cohort Patient ID)
Date of Measurement/Sample
Precision annotation variable for date of measurement
numeric: -1 = undetectable or detection limit as negative value
HIV-RNA measurement value
Lower Limit of HIV-RNA Assay
numeric. see coding table for valid codings.
IF AVAILABLE, What type of VIRAL ASSAY was used for this measurement?

Additional Fields

Field name
IF AVAILABLE, Upper Limit of assay

QA Checks

TableCrosstableError CodeDescriptionStudy specificHICDEP?
AllTablesCrossTableATC001any date in database after DEATH_D in tblLTFU Yes
AllTablesCrossTableATC002any date in database after DROP_D in tblLTFU Yes
AllTablesCrossTableATC003any date in database before BIRTH_D in tblBAS Yes
AllTablesCrossTableATC004any date in database in the future Yes
AllTablesCrossTableATC005patients submitted previously who have been missed out Yes
AllTablesCrossTableATC006Any fields not coded as coding lists on table definition Yes
tblLAB_RNAWithinTableRW001Duplicate records for same RNA_D Yes
tblLAB_RNAWithinTableRW002RNA_V < 0 and RNA_L missing Yes
tblLAB_RNAWithinTableRW003RNA_V > 10 000 and (RNA_V modulo 1000) = 1 and RNA_UL missing Yes
tblLAB_RNAWithinTableRW004Missing RNA_D Yes
tblLAB_RNAWithinTableRW005Missing RNA_V Yes
tblLAB_RNAWithinTableRW006RNA_V > 10 million Yes
tblLAB_RNAWithinTableRW007RNA_V < RNA_L and RNA_V >= 0 Yes
tblLAB_RNAWithinTableRW008RNA_V > RNA_UL Yes
tblLAB_RNACrossTableRC001Patient has no record in BAS Yes