tblLAB_RNA - Laboratory values
holds date, value, detection limit and type of viral assay.
|
Core FieldsNote: Fields marked bold form the unique identifier for a record of the table.
|
Field name Format Description character (or numeric if possible) Code to identify patient (Cohort Patient ID)
|
yyyy-mm-dd Date of Measurement/Sample
|
Precision annotation variable for date of measurement
|
numeric: -1 = undetectable or detection limit as negative value HIV-RNA measurement value
|
numeric Lower Limit of HIV-RNA Assay
|
IF AVAILABLE, What type of VIRAL ASSAY was used for this measurement?
|
Additional FieldsField name Format Description numeric IF AVAILABLE, Upper Limit of assay
|
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_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 |