Swap Locations: Difference between revisions

m ex
Line 18: Line 18:
=== possible solution: exclude by filter ===
=== possible solution: exclude by filter ===
{{Discuss |
{{Discuss |
* One option would be to omit lines with current unit is a swap location from the cognos data via filter automatically, but it's not clear if this will result in the previous and subsequent records having non-matching next locations and previous locations. Can we just delete these lines from Cognos? Discussing with Lisa... Ttenbergen 14:03, 2020 August 28 (CDT)
* One option would be to omit lines with current unit is a swap location from the cognos data via filter automatically, but it's not clear if this will result in the previous and subsequent records having non-matching next locations and previous locations. Can we just delete these lines from Cognos? Ttenbergen 14:03, 2020 August 28 (CDT)
}}
}}
{{Discuss |
One problem with filtering these out would be that, I ''think'', the '''unit''' record for a swap location might be the same as the unit record for a successive stay in that unit; ie. the bed entry chagnes, but the unit remains the same. So, the unit start dttm and unit end dttm don't care if part of the unit stay was in a swap location. Is that not true? If it is true, then how would we filter these out? if I eliminate every line that has a swap/swing bed (which I can do) then we will not get any line for those pts who never get into a real bed on that unit (which may be good), but we would still get the ''same'' line with unit start and end times including the swap/swing time for patients who eventually get into a bed on that unit. [[User:Ttenbergen|Ttenbergen]] 12:07, 2020 December 2 (CST)
}}
For these reasons all swing bed entries should be filtered out if possible.


=== possible solution: exclude by manual exclude ===
=== possible solution: exclude by manual exclude ===