Lab identification in the DSM data: Difference between revisions

Line 13:

* <code>" WHERE ([Arrive_DtTm]<=" & LabDtTm_str & ") AND (" & LabDtTm_str & "<=nz([Dispo_DtTm],now())) "</code>

** ie we start the range with the [[Arrive_DtTm]], not the [[Accept_DtTm]]

{{Discuss |We should change this; however, do we only change it going forward or do we also re-import back data? Julie is about to re-import back data until 2019-01-01, so maybe we should reimport back data for all that far?

{{Discuss |

* shouldn't it be [[Accept_DtTm]] and use [[Arrive_DtTm]] if [[Accept_DtTm]] is blank. We have discussed that in the Project Boarding Loc, we can still determine the counts in between [[Accept_DtTm]] and [[Arrive_DtTm]] if needed. --[[User:JMojica|JMojica]] 10:25, 2019 December 10 (CST) }}

* We should change this; however, do we only change it going forward or do we also re-import back data? Julie is about to re-import back data until 2019-01-01, so maybe we should reimport back data for all that far?

** shouldn't it be [[Accept_DtTm]] and use [[Arrive_DtTm]] if [[Accept_DtTm]] is blank. We have discussed that in the Project Boarding Loc, we can still determine the counts in between [[Accept_DtTm]] and [[Arrive_DtTm]] if needed. --[[User:JMojica|JMojica]] 10:25, 2019 December 10 (CST)

*** That is pretty much what I mean, it should be as you say. Do we want to do this going back in data as you re-import, or just going forward for future imports? Ttenbergen 09:41, 2019 December 11 (CST)}}

=== counts ===

@@ Line 13: / Line 13: @@
 * <code>" WHERE ([Arrive_DtTm]<=" & LabDtTm_str & ") AND (" & LabDtTm_str & "<=nz([Dispo_DtTm],now())) "</code>
 ** ie we start the range with the [[Arrive_DtTm]], not the [[Accept_DtTm]]
-{{Discuss |We should change this; however, do we only change it going forward or do we also re-import back data? Julie is about to re-import back data until 2019-01-01, so maybe we should reimport back data for all that far?
+{{Discuss |
-* shouldn't it be [[Accept_DtTm]] and use [[Arrive_DtTm]] if [[Accept_DtTm]] is blank. We have discussed that in the Project Boarding Loc, we can still determine the counts in between [[Accept_DtTm]] and [[Arrive_DtTm]] if needed.  --[[User:JMojica|JMojica]] 10:25, 2019 December 10 (CST) }}
+* We should change this; however, do we only change it going forward or do we also re-import back data? Julie is about to re-import back data until 2019-01-01, so maybe we should reimport back data for all that far?
+** shouldn't it be [[Accept_DtTm]] and use [[Arrive_DtTm]] if [[Accept_DtTm]] is blank. We have discussed that in the Project Boarding Loc, we can still determine the counts in between [[Accept_DtTm]] and [[Arrive_DtTm]] if needed.  --[[User:JMojica|JMojica]] 10:25, 2019 December 10 (CST)
+*** That is pretty much what I mean, it should be as you say. Do we want to do this going back in data as you re-import, or just going forward for future imports? Ttenbergen 09:41, 2019 December 11 (CST)}}
 === counts ===