Lab identification in the DSM data: Difference between revisions
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) →Start of date range: Changed to use Admit DtTm |
||
| Line 11: | Line 11: | ||
=== Start of date range === | === Start of date range === | ||
The Lab_DtTm is compared to the admit time of the patient as follows: | The Lab_DtTm is compared to the admit time of the patient as follows: | ||
* <code>" WHERE ([ | * <code>" WHERE ([Admit_DtTm]<=" & LabDtTm_str & ") AND (" & LabDtTm_str & "<=nz([Dispo_DtTm],now())) "</code> | ||
** ie we start the range with the [[ | ** ie we start the range with the [[Admit DtTm]] | ||
{{DJ | | {{DJ | | ||
* 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? | * 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? | ||
| Line 19: | Line 19: | ||
**** Yes going forward. also this time using first service dttm. --[[User:JMojica|JMojica]] 16:36, 2022 February 16 (CST) | **** Yes going forward. also this time using first service dttm. --[[User:JMojica|JMojica]] 16:36, 2022 February 16 (CST) | ||
***** As in, use the ''Admit DtTm'' with the definition we have decided in there, right? [[User:Ttenbergen|Ttenbergen]] 19:48, 2022 February 17 (CST) | ***** As in, use the ''Admit DtTm'' with the definition we have decided in there, right? [[User:Ttenbergen|Ttenbergen]] 19:48, 2022 February 17 (CST) | ||
****** I have changed this to use the new [[Admit DtTm]]; if that addresses this issue, pls delete, otherwise explain. [[User:Ttenbergen|Ttenbergen]] 14:06, 2022 June 1 (CDT) | |||
}} | }} | ||
=== date constraints === | === date constraints === | ||