tblLAB - Laboratory values
holds type, date, value and unit of laboratory tests.
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 |
|
Measurement result |
| 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:
|
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 |