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 Format Description
PATIENT character (or numeric if possible) Code to identify patient (Cohort Patient ID)
RNA_D yyyy-mm-dd Date of Measurement/Sample
RNA_D_A character: see coding of date precision Precision annotation variable for date of measurement
RNA_V numeric: -1 = undetectable or detection limit as negative value HIV-RNA measurement value
RNA_L numeric Lower Limit of HIV-RNA Assay
RNA_T numeric. see coding table for valid codings. IF AVAILABLE, What type of VIRAL ASSAY was used for this measurement?

Additional Fields

Field name Format Description
RNA_UL numeric IF AVAILABLE, Upper Limit of assay

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_RNA WithinTable RW001 Duplicate records for same RNA_D Yes
tblLAB_RNA WithinTable RW002 RNA_V < 0 and RNA_L missing Yes
tblLAB_RNA WithinTable RW003 RNA_V > 10 000 and (RNA_V modulo 1000) = 1 and RNA_UL missing Yes
tblLAB_RNA WithinTable RW004 Missing RNA_D Yes
tblLAB_RNA WithinTable RW005 Missing RNA_V Yes
tblLAB_RNA WithinTable RW006 RNA_V > 10 million Yes
tblLAB_RNA WithinTable RW007 RNA_V < RNA_L and RNA_V >= 0 Yes
tblLAB_RNA WithinTable RW008 RNA_V > RNA_UL Yes
tblLAB_RNA CrossTable RC001 Patient has no record in BAS Yes