Transfer Delay (Critical Care): Difference between revisions

Starting Oct 1,2020, transfer time is always present.

I have not yet added this part to the query. Does this just mean that before Oct 1 2020 it was reported this way, or is it still reported this way for values from before? If the latter, would it make sense to generate these values and update the old transfer ready dttms to this? If I include it in the question this will forever run slowly. Having said that... the same is true for the other values: I use an iif function to determine if we are before or after, and functions like that are slow. Should we automatically generate transfer ready tmp entries for the old data once and then not have to worry about this again? Especially for the second part, we have nothing to lose, the data would remain the same, just stored in new place. For the first part we would change data, but if you have always reported it that way that is just as well.  

**I have checked my program and the substitution applies only when the entry in the transfer ready dttm field is just date which presumably  when the entry of dt and tm are in  separate two fields.  now when the entry became in the format dttm , the substitution no longer happened. so this was a long time ago then, even before Oct 2020.    what was the entry when there is no time?  00:00??