Lab identification in the DSM data: Difference between revisions
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) |
||
| Line 2: | Line 2: | ||
== Matching == | == Matching == | ||
Each lab is imported with a value. | |||
=== Lab_DtTm === | |||
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> | |||
=== counts === | |||
We originally did labs as counts. | |||
A count of them can be viewed using query ''L_Labs_Flowsheet_DSM_sum''. | |||
=== individual record === | === individual record === | ||