Is this a unit we currently collect on? What is it now? Ttenbergen 13:45, 2022 October 13 (CDT)
SMW
Cargo
Categories
History
We have records with this unit as a Boarding Loc for both the CC and Med programs.
While it was used for Medicine it operated as a regular ward level of care. While used for CC it operated as a IICU level of care.
JALT
This same location has different levels of care over time. Currently the s_level_of_care table can only accommodate one, ie changes over time can't be included in it. My first thought was to include start and end times for this, but what if patients from both programs were boarding on a given unit at the same time? Can that happen? The very concept that these are boarding locations kind of means crazy things could go on. How do we best accommodate this? Would we always know as a physical location (especially a boarding one) changes LOC? Ttenbergen 13:53, 2022 October 13 (CDT)
In the meantime I am changing the LOC for this location to 50 in s_level_of_care table since I think that table is only used by the queries that derive Transfer Delay. Ttenbergen 13:45, 2022 October 13 (CDT)
SMW
Cargo
Categories
I came across this issue because Julie's data and mine had different Transfer Delay when this location was involved. This seems to mean that Julie's doesn't use the table to designate level of care. That could become a source of inconsistency. Should we do this the same way? What is the obstacle? Ttenbergen 13:45, 2022 October 13 (CDT)
I do not use the s_level_of_care table for the reson that the same location can be assigned with more than one level of care either CC or HOBS or regular. For Critical Care, since each record is based by unit, if the patient stays in more than one boarding loc i.e. ER/PACU/Home unit/offservice unit, I consider them under the same level of care. Ex an IICU pt staying at SICU/GGA7/GA7S have same level of care, an ICSM patient staying at L2ME(IMCU)/L2HA(Recovery)/home unit/offunit(ACCU/ICCS) are under same level of care. For Medicine, i just need to distinguish the HOBS locations (e.g. HSC-GH7S,HSC_HOBS,HSC_H4H,HSC_B2 (only from STB_IMCU