Site and Location table

From CCMDB Wiki
Jump to navigation Jump to search

This table shows Hospitals/Sites and locations where we collect data and their codes for entry into the Location field. In some circumstances you will need to use the hospital and location on their own, and in some they will be combined. If they are combined, they should be written as <hospital>_<location> (eg HSC_A4).

  • The table also shows the dates when data collection was started in each unit.

items in blue are links to details recorded below

Hospital/Site ICU ward location Medicine ward location Data Collection Start Date
HSC MICU, SICU, CCU, IICU
  • MICU-July 1, 1988
  • SICU-July 1, 1988
  • IICU-May 13, 1997
  • CCU-May 1, 1999
  • A4-October 1, 2003
  • H4-April 1, 2004
  • D4-March 1, 2004
  • D5-March 1, 2004
  • B3-February 1, 2005
  • H4H-May 1, 2005
  • HSC Med nonteaching contingency beds - 2010
STB
  • CCU
  • 5B- NTU Location started at serial 1904
    • (B4 changed 5B date: Nov 17.09). (non acute geri rehab)
      • B4 location stopped at serial 1903
  • E5- CTU
  • E6- CTU
    • change date: Oct 14.09
      • (start at serial 6313)
      • (start at serial 4596 -Deb's every 86-100)
  • B5- CTU
    • change date: Oct 14.09
      • (stop at serial 6312 MOVED to E6)
      • (stop at serial 4595-Deb's device, every 86-100)
  • Med OVER tracked to the following units: (A5, A6 & up )
  • in master database for Reporting
    • Location: STB_5B + STB B4 = STB_5B
    • Location: STB_B5 + STB_E6 = STB_E6
  • CCU-May 24, 1999
  • MICU-May 24,1999
  • SICU-May 24, 1999
    • Combined SICU/MICU Unit: January 15, 2007
  • CICU-January 15, 2007
  • B5(E6)-August 1, 2004
    • Moved to E6-October 14, 2009
  • B4(5B)-November 1, 2004
    • Moved to 5B-November 17, 2009
  • E5-December 1, 2004
VIC MICU
  • MICU-June 1, 1999
  • N5-August 1, 2005
  • S5-September 1, 2005
  • S3-October 1, 2005
  • S4-October 1, 2005 (included medicine patients on N4-legacy)
    • S4-Opened as a CTU August 1, 2009
  • N3F & S4F-Family Medicine-July 1, 2005 to June 30, 2006
  • EMIP-February 1, 2007
GRA MICU
  • MICU-September 14, 1998
  • N3-January 1, 2005
  • N5-January 1, 2005
  • W3/E3 (referred to at the Grace as 3 South) also known as W3-January 1, 2005
  • EMIP-November 1,2010
CON MICU 0
  • May 1, 1999
OAK MICU 0
  • June 1, 1999


Details for Grace W3 / E3 / S3

The data for Grace W3 actually includes the east(E) and west(W) wings of the third floor. Apparently at some point, the Grace refers to W3 & E3 as ward S3. Since we had been collecting data for a year or two before this came up, we decided not to change our location label.

Details for STB ICU

STB_MICU & SICU

  • the units were combined into "one unit" called STB_MICU
Date of change

January 15, 2007

STB_CICU

  • Cardiac Surgery Intensive Care Unit STB_CICU was established
Date of change

January 15, 2007

CICU overflow into MICU

Go to: STB_CICU overflow in STB_MICU

STB_CCU service patients physically located in STB_MICU unit

Cardiology service patients are treated differently than other patients, see STB Cardiac Care patients for details.

Details for Vic N4/S3

Unit 3 is a medical rehab ward. It has 30 beds. However, both the Family Medicine program and the VMU program admit patients here. So this S3 ward got added to the N4 ward and the same data collector collects both units. There can be anywhere from 10-20 VMU patients on unit 3 at any one time, it fluctuates. These patients are all medically stable with d/c planning issues. Are they PCH bound, Geri-rehab bound, awaiting HC, many things, but when they become unstable, they get moved off that ward. So there you have the story of the N4/S3 ward.WGobert 09:21, 28 November 2008 (CST)

STB ward change B5 to E6

October 14, 2009 all new new admits on this day change location to E6.

  • Any new patients admitted to B5 on Oct 14th onward will have LOCATION of E6. (starts at serial number 6311 Gayle’s PDA and serial 4598 Deb’s PDA for B5 patients).
  • Any patient admitted to B5 Oct 13, 2009 or earlier will retain LOCATION of B5. (Last B5 patient serial 6310 (Gayle PDA) & 4597(deb’s PDA)

Move dates:

  • If the B5 admit date was “on” or after Oct 14, 2009 then moves data should be to E6.
  • If the B5 ward admit date was October 13, 2009 or “earlier” then move data is B5 even if patient is move to you on or after October 14, 2009

SAS data check

Variable 1 & 2 of Other Wards:

  • If the admit date of the other ward was October 13, 2009 or “earlier” then var 1 should be FROM B5.
  • If the admit date of the other ward was “on” or after Oct 14, 2009 then var 1 should be FROM E6.
  • If the discharge date of the other ward was October 13, 2009 or “earlier” then var 2 should be TO B5.
  • If the discharge date of the other ward was “on” or after Oct 14, 2009 then var 2 should be TO E6.


Dec 1.14 - Updated query for CFE Var 1 & 2 - fix STB_med_B5 to 5B

  • Update query ran to fix Var 1 and 2. As of Oct 14.2009 "B5" no longer used. Should be 5B. Because it was not inactivated in S_varoptions table in ccmdb, it was still being used. Tina disabled it in Nov.2014 and cleaned up CFE Dec 1.14.Trish Ostryzniuk 18:08, 2014 December 1 (CST)
    • total of 3 Var 1 with B5
    • total of 71 Var 2 with B5

Details for HSC_B3

  • Data collection started on this unit October 18, 2004. One side of this ward is Medicine patients, mostly cardiac patients. Use to be cardiology beds. Dan might remember? The other side of this ward is days surgery patients that we do not collect data on.TOstryzniuk 18:59, 5 January 2010 (CST)