Version 2 (modified by stels, 7 years ago) (diff) |
---|
tblLAB - Laboratory values
- TODO
- abstract for this table
Core fields
Note: Fields marked bold form the unique identifier for a record of the table.
- PATIENT: Code to identify patient (Cohort Patient ID)
- LAB_ID: Code representing the measurement
- LAB_D: Date of measurement/sample
- LAB_V: Value of measurement
- LAB_U: Unit of measurement
Additional fields
Other detailed information regarding the patient and the measurement would be relevant, like the proposed fasting information shown below.
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).