S dispo.loc type

From CCMDB Wiki
Revision as of 11:08, 2022 June 7 by JMojica (talk | contribs)
Jump to navigation Jump to search
Data Element (edit)
Field Name: loc type
CCMDB Label:
CCMDB tab:
Table: s_dispo table
Data type: string
Length: 20
Program: Med and CC
Created/Raw: Raw
Start Date: 2016-07-01
End Date: 2300-01-01
Sort Index: 8

The list provides a broader description of service and/ location of the patient's Previous Location,Pre-admit Inpatient Institution or Dispo field and found useful when providing reports.

  • SMW

Legacy implementation right in the table

  • Cargo


  • Categories
  • Forms



  • Thanks for updating the field description. Do we need more info on this, though, e.g. which indicators use this? In which case it should probably be added to the indicators. It almost seems like taking it to a bit of an extreme to document this, but on the other side, it's one of those things that only you know, Julie, so it would be hard to recreate a report and get this right unless it's documented. Ttenbergen 12:09, 2022 April 27 (CDT)
    • this is meant for integrating where the patients came from or where the patients went in a broader groupings and is useful for filtering the population of interest for database requests or indicators being reported. Commonly combine with the Geog of s_dispo table. Ex. Out of City ER/ward/ICU/PCH, WPG ER/Ward/ICU/PCH, etc. Indicators like Interfacility transfers considers only those discharges to WPG ICU or Medicine Readmission considers those who went to hospice, PCH, ambulatory care of out of WPG/MB/CAN in addition to others. -JMojica 11:08, 2022 June 7 (CDT)
  • SMW


  • Cargo


  • Categories

location type values

loc_type description
ambulatory care ambulatory care clinics at the hospitals where we collect data
Boarding not used anywhere, just legacy fields
ER ...
hospice Hospice
ICU ...
legacy for legacy records where the field is inconsistent
NICU e.g. home, a place where person would no lone be a patient
non-patient e.g. home, a place where person would no longer be a patient
Nursing Station nursing stations usually on first nations
OR operating room
PCH personal care home
RR recovery room
TCE Transitional Care Environment (see Transitional Care)
TCU Transitional Care Unit (see Transitional Care)
UC Urgent Care
unknown/other ...
Ward ...