Level of care hierarchy

From CCMDB Wiki
Revision as of 10:38, 2021 February 10 by Ttenbergen (talk | contribs) (pushed one discussion to TA, and moved question about Transfer Ready DtTm tmp entry to that page.)
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)
  • To clarify should family medicine be included in the WRHA lower acuity ward in acute care hospital category instead of the WRHA regular ward (CTU or NTU or other ward where we do not collect category ?
  • SMW


  • Cargo


  • Categories
  • WRHA lower acuity ward in acute care hospital, whatever flavour of the month word they use for this, incl. rehab, geri-rehab, palliative care unit, 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. 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: