| analysis_id |
unique analysis number |
| sample_id |
unique sample identification number |
| lab_ref_no |
labs internal analysis number |
| vap_ref_no |
internal PLAP sample number |
| analyte |
obsolete unique identification number. Replaced by analyte_id |
| analysis_result |
result value |
| res_unit |
result unit |
| lab_code |
unique code for laboratory. Defined in Labs table |
| method_code |
obsolete, 12-05-2023. Labs internal method code translated to standat |
| control_date |
laboratory registration date for sample batch - autogenerated from the laboratory |
| result_date |
inorganic samples, |
| detlimit |
detection limit of analysis, unit same as res_unit |
| comments |
any comments to the analysis from the laboratory |
| indate |
time stamp for data insertion in database |
| corrdate |
date of correction |
| status |
check constraint |
| status_comment |
comments on analysis status if analysis is invalid |
| analyte_id |
unique analyte number. Analyte_id is defined in the analyte table |
| lab_ref_method |
labs internal method code |
| lagringsform |
kode for lagringsform |