Site and Location table

From CCMDB Wiki
Revision as of 11:18, 27 August 2015 by Ttenbergen (talk | contribs) (added smw link and started clean-up moving unit information to individual unit articles.)
Jump to navigation Jump to search
 Collection Location StartdateCollection Location EnddateCollection Location ProgramCollection Location HospitalCollection Location Service TypeCollection Location Service Type LegacyCollection Location workload split
CON MICU1 May 199923 June 2019Critical CareCON
GH-2S14 April 202018 June 2020MedicineGRA
GH-5S7 April 202010 April 2020MedicineGRA
GH-CC15 October 20201 January 2999Critical CareGRA
GH-EMIP1 November 20101 October 2020MedicineGRA
GH-MICU14 September 19981 January 2999Critical CareGRA
GH-Med1 October 20201 January 2999MedicineGRA
GH-N31 January 20051 January 2999MedicineGRA
GH-N51 January 20051 January 2999MedicineGRA
GH-OVER9 May 20079 May 2007MedicineGRA
GH-Recovery Room1 April 20201 January 2999Critical CareGRA
GH-S326 May 20151 January 2999MedicineGRA
GH-W31 January 200526 May 2016MedicineGRA
HSC A41 October 20031 January 2999MedicineHSC
HSC B27 April 20207 August 2020MedicineHSC
HSC B318 October 20041 January 2999MedicineHSC
HSC CCU1 May 199917 June 2019Critical CareHSC
HSC D41 March 200420 March 2020MedicineHSC
HSC D4 COVID3 April 202014 May 2020MedicineHSC
HSC D519 March 202028 May 2020MedicineHSC
HSC D5 D19 March 202028 May 2020MedicineHSC
HSC D5 Pre COVID1 March 200419 March 2020MedicineHSC
HSC EMIP1 October 201615 October 2020MedicineHSC
HSC H41 April 20041 January 2999MedicineHSC
HSC H4H1 May 200514 April 2020MedicineHSC
HSC HOBS7 August 20201 January 2999MedicineHSC
HSC IICU13 May 19971 January 2999Critical CareHSC
HSC MICU11 July 19881 January 2999Critical CareHSC
HSC Med15 October 20201 January 2999MedicineHSC
HSC SICU11 July 19881 January 2999Critical CareHSC
HSC WRS215 August 20231 January 2999MedicineHSC
HSC WRS319 March 20201 January 2999MedicineHSC
HSC-GA7S18 October 20041 January 2999MedicineHSC
OAK MICU1 June 199920 September 2019Critical CareOAK
STB A6ME4 September 20241 January 2999MedicineSTB
STB A7 BMarch 202011 June 2020MedicineSTB
STB ACCU5 July 20161 January 2999Critical CareSTB
STB B41 November 200417 November 2009MedicineSTB
STB B518 November 20091 January 2999MedicineSTB
STB B5old1 August 200413 October 2009MedicineSTB
STB CCU24 May 19995 July 2016Critical CareSTB
STB CICU15 January 20071 January 2999Critical CareSTB
STB E51 December 20041 January 2999MedicineSTB
STB E6 B14 October 20041 January 2999MedicineSTB
STB E6 CMarch 202011 June 2020MedicineSTB
STB EMIP7 March 201615 October 2020MedicineSTB
STB IMCU1 October 20181 April 2019MedicineSTB
STB MICU24 May 19991 January 2999Critical CareSTB
STB Med15 October 20201 January 2999MedicineSTB
STB SICU24 May 199915 January 2007Critical CareSTB
STB-L2HA
VIC EMIP1 February 200730 September 2017MedicineVIC
VIC MICU1 June 199925 September 2017Critical CareVIC
VIC N3F1 July 200530 June 2006MedicineVIC
VIC N429 September 201712 January 2018Family MedicineVIC
VIC N4C2 October 201726 October 2018Family MedicineVIC
VIC N51 August 20051 October 2017MedicineVIC
VIC N5C3 October 201726 October 2018Family MedicineVIC
VIC S31 October 200522 September 2017MedicineVIC
VIC S41 October 20051 October 2017MedicineVIC
VIC S51 September 200530 September 2017MedicineVIC
VIC S5C3 October 201726 October 2018Family MedicineVIC


User:Ttenbergen#location_table Go here for Site and location table- rework in progress

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
  • N3-CTU (includes the east corridor and west corridor on the north side of the 3rd floor)
  • N5-NTU
  • W3-NTU or METU (non acute geri rehab)
  • EMIP
  • MICU-September 14, 1998
  • N3 NTU-January 1, 2005 - June 30 , 2005
    • N3 CTU - July 1, 2005
  • N5-January 1, 2005
  • W3 - January 1, 2005. W3 & E3 are referred to as: 3 South (S3). (includes the east and west corridors on the south side of 3rd floor)
  • EMIP - November 1,2010
CON MICU 0
  • May 1, 1999
OAK MICU 0
  • June 1, 1999


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
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Site_and_Location_table&oldid=45619"