Level of care hierarchy

From CCMDB Wiki
Jump to navigation Jump to search

We use the concept of a level of care hierarchy in the context of Transfer Delays. See Transfer Delay to understand how it is used. Level of care applies to a patient's combination of Boarding Loc item and comment entry (which together define a physical location). Which location has which level of care is stored in the s_level_of_care table.

Levels of Care

The actual levels of care are:

  • WRHA ICU, same level of care includes: MICU, SICU, CICU, ACCU, CCU (also for PACU or OR)
  • Other MB RHA ICU or Other Province ICU
  • WRHA IICU
  • WRHA HOB ward (examples: HSC_HOBS, STB_IMCU as of 2020-10)
  • WRHA regular ward (CTU or NTU or other ward where we do not collect e.g. surgery, family med, OB, etc)
  • WRHA lower acuity ward in acute care hospital, whatever flavour of the month word they use for this, incl. rehab, geri-rehab, etc
  • ward outside WRHA
  • PCH or home
  • morgue (e.g. in case of Brain death)

Special case - ER, OR and PACU

These are considered the highest level of care collected by that program. So,

  • for a medicine patient on a med laptop, an ER/OR/PACU location is considered the same level of care as a HOBS unit
  • for a critical care patient on a cc laptop, an ER/OR/PACU location is considered the same level of care as an MICU/SICU

Actual listing of care levels for different Boarding Locs

The s_level_of_care table in CCMDB.accdb (and automatically linked into CFE contains a mapping of our Boarding Locs to their level of care.

  • I populated most of the s_level_of_care table; for the rest I would need a list of all locations tracked in comment and what level of care we would attribute to them. List needs to be pulled from CFE, and then levels added, and I don't know what those would be, so we need someone (Lisa?) to help us fill that in. This will be needed by Julie for reporting, but not for collectors to be able to work tomorrow, so I am leaving this for now. It if becomes important before I get back to it, catch me. Ttenbergen 19:35, 2020 October 15 (CDT)
    • where is the list? cannot see it in CFE. I got the ver2020-10-15. --JMojica 11:56, 2020 October 20 (CDT)
      • List is in CCMDB.accdb, would need to be linked into CFE if you want to see it from there. Ttenbergen 11:01, 2020 October 22 (CDT)
        • I have added the table to re-connecting so it will show in CFE as of version 2021-02-04. Ttenbergen 13:06, 2021 February 4 (CST)
  • SMW


  • Cargo


  • Categories

Related articles

Related articles: