From CCMDB Wiki
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


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 field of s_dispo table. Ex. Out of City ER/ward/ICU/PCH, WPG ER/Ward/ICU/PCH, etc. Indicators like ICU Interfacility Transfer consider only those discharges to WPG ICU or Readmission to MedWard 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)

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 ...