Lab identification in the DSM data: Difference between revisions
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) |
||
| Line 7: | Line 7: | ||
The field '''Lab_DtTm''' in [[L_Labs_DSM table]] is generated as follows from the inconsistenly populated fields in the export: <!-- as of 2019-12-09--> | The field '''Lab_DtTm''' in [[L_Labs_DSM table]] is generated as follows from the inconsistenly populated fields in the export: <!-- as of 2019-12-09--> | ||
* <code>LabDtTm_str = "CDate(Nz([COLLECTEDDATE], [arriveddate])) + CDate(Nz([CollectedTime], [LabarrivedTime]))"</code> | * <code>LabDtTm_str = "CDate(Nz([COLLECTEDDATE], [arriveddate])) + CDate(Nz([CollectedTime], [LabarrivedTime]))"</code> | ||
** ie use collected dttm if available, else use arrived dttm | |||
=== counts === | === counts === | ||