Site and Location table: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
← Older editNewer edit →
TOstryzniuk (talk | contribs)
CCMDB_legit, approved, Bureaucrats, Administrators
27,522 edits
m minor
m added smw link and started clean-up moving unit information to individual unit articles.
Line 1: Line 1:
<!-- As generated by [[Semantic Mediawiki]] -->
{{#ask: [[Category:Collection Location]]
| searchlabel=Collection Locations
| ?Collection Location Startdate
| ?Collection Location Enddate
| ?Collection Location Program
| ?Collection Location Hospital
| ?Collection Location Service Type
| ?Collection Location Service Type Legacy
| ?Collection Location workload split
| format=table
}}


[[:User:Ttenbergen#location_table Go here for Site and location table- rework in progress]]
[[:User:Ttenbergen#location_table Go here for Site and location table- rework in progress]]
Line 115: Line 128:
|}
|}


== 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. The other side of this ward is days surgery patients that we do not collect data on.
== Details for Grace W3 / E3 / S3 ==
The data for Grace W3 actually includes the east(E) and west(W) wings of the third floor. The Grace refers to W3 & E3 as 3-South (S3). 3-South includes the both the east and west corridor.  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: [[Overflow to other units - Critical Care HSC and STB only#STB_CICU overflow patient in MICU/SICU  (Under CICU care)|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.[[User:WGobert|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   
==STB ward change B5 to 5B==
*ward B4(5B)- started November 1, 2004
*ward B4 (5B)- Moved to 5B - November 17, 2009


===SAS data check ===
===SAS data check ===

Revision as of 11:18, 27 August 2015

 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"