wiki:Hicdep_1.50/TableLabRna

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_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 HICDEP?
AllTablesCrossTableATC001any date in database after DEATH_D in tblLTFUYES
AllTablesCrossTableATC002any date in database after DROP_D in tblLTFUYES
AllTablesCrossTableATC003any date in database before BIRTH_D in tblBASYES
AllTablesCrossTableATC004any date in database in the futureYES
AllTablesCrossTableATC005patients submitted previously who have been missed outYES
AllTablesCrossTableATC006Any fields not coded as coding lists on table definitionYES
tblLAB_RNAWithinTableRW001Duplicate records for same RNA_DYES
tblLAB_RNAWithinTableRW002RNA_V=-1 and RNA_L missingYES
tblLAB_RNAWithinTableRW003RNA_V=+1 and RNA_U missingYES
tblLAB_RNAWithinTableRW004Missing RNA_D YES
tblLAB_RNAWithinTableRW005Missing RNA_V YES
tblLAB_RNAWithinTableRW006RNA_V > 10 millionYES
tblLAB_RNAWithinTableRW007RNA_V < RNA_LYES
tblLAB_RNAWithinTableRW008RNA_V > RNA_UYES
tblLAB_RNAWithinTableRW009RNA_V < 0YES
tblLAB_RNACrossTableRC001Patient has no record in BASYES
Last modified 7 years ago Last modified on 04/18/11 13:35:39