tblLAB - Laboratory values
holds type, date, value and unit of laboratory tests.
|
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)
|
Code representing the measurement
|
yyyy-mm-dd Date of measurement/sample
|
optional precision annotation for date of measurement/sample
|
Measurement result (10-13 for LAB_ID=TBRES)
|
numeric: -1 = undetectable or detection limit as negative value Value of measurement
|
|
Additional FieldsOther detailed information regarding the patient and the measurement would be relevant, like the proposed fasting information shown below.
|
Field name Format Description Was the blood sample taken while fasting?
|
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 | 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 |