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)
LAB_ID	character. see coding table for valid codings.	Code representing the measurement
LAB_D	yyyy-mm-dd	Date of measurement/sample
LAB_D_A	character: see coding of date precision	optional precision annotation for date of measurement/sample
LAB_R	1 = Positive (including trace, 1+, 2+, etc.) 0 = Negative 9 = Unknown/borderline 10 = Monoresistance 11 = MDR-TB 12 = pre-XDR 13 = XDR	Measurement result (10-13 for LAB_ID=TBRES)
LAB_V	numeric: -1 = undetectable or detection limit as negative value	Value of measurement
LAB_U	numeric. see coding table for valid codings.	Unit of measurement

Additional Fields

Other detailed information regarding the patient and the measurement would be relevant, like the proposed fasting information shown below.

Field name	Format	Description
LAB_FA	numeric: 0 = No 1 = Yes 9 = Unknown	Was the blood sample taken while fasting?
LAB_ST	character. see coding table for valid codings.	Code representing the specimen type

Depending on the set of measurements collected and the mandatory fields applicable to these individual measurements, it might be useful to separate the LAB table into several sub tables. This is already shown for the CD4 and RNA measurements: the level of detail needed for CD4 is less than for the LAB variables in general (no unit since it’s always the same), while for RNA the data required is more detailed (assay and detection limit).

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	WithinTable	LW001	Duplicate records		Yes
tblLAB	WithinTable	LW002	Missing LAB_D		Yes
tblLAB	WithinTable	LW003	Missing LAB_V		Yes
tblLAB	WithinTable	LW004	Missing LAB_U		Yes
tblLAB	WithinTable	LW005	Missing LAB_ID		Yes
tblLAB	WithinTable	LW008	Missing LAB_FA		Yes
tblLAB	WithinTable	LW009	Missing LAB_ST		Yes
tblLAB	WithinTable	LW010	LAB_V out of range for unit LAB_U		Yes
tblLAB	CrossTable	LC001	Patient has no record in BAS table		Yes