Site and Location table: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
TOstryzniuk (talk | contribs)
m minor
m HSC Boarding Loc link cleanup
 
(34 intermediate revisions by 2 users not shown)
Line 1: Line 1:
This table shows Hospitals/Sites and locations where we collect data and their codes for entry into the [[Pre-admit Inpatient Institution field]], [[Previous Location field]], [[Service/Location field]] and [[Dispo field]]s


[[http://ccmdb.kuality.ca/index.php?title=User:Ttenbergen#location_table Go here for Site and location table- rework in progress]]
'''Click the following for a list including locations where we have collected in the past:{{#cargo_query:
 
tables=CollectionLocation
This table shows Hospitals/Sites and locations where we collect data and their codes for entry into the '''[[Location field]]'''.
|fields=_pageName = ward/unit, StartDate, EndDate, Program
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).
|limit=0
 
|more results text=Complete list including legacy
*The table also shows the dates when data collection was started in each unit.
|default=no results were found}}
 
*Also see: [[S Locations]]
 
*Go to [[Database Total ICU/Med]] to see TOTAL number of admissions currently in ICU and Medicine database.
 
''items in blue are links to details recorded below''
{| class="wikitable" border=1
|-
|| '''Hospital/Site''' || '''ICU ward location''' || '''Medicine ward location''' || Data Collection Start Date
|-
|| '''HSC''' || '''MICU, SICU, CCU, IICU'''  ||
*'''A4'''-[[CTU]]
*[[Site and Location#Details for HSC_B3 | B3]]-[[CTU]]
*'''D4'''-[[CTU]]
*'''D5'''-[[NTU]] (non acute geri-rehab)
*'''H4'''-[[CTU]] 
*'''[[H4H]]'''-[[CTU]] (HOBS - high observation unit)
*[[HSC Med nonteaching contingency beds]]-[[NTU]] 
||
*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'''
*[[STB Med Ward changes]]
| width="220" |
*[[Site and Location#Details for STB ICU | MICU]]
 
*'''CCU'''
*[[Site and Location#Details for STB ICU|'''CICU''' ]] ([[STB_CICU]])
 
| width="220" |
*'''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 [[:Category: Reporting | 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''' ||'''
*'''N4'''-Legacy [[Site and Location#Details for Vic N4/S3 |'''N4''']]
*'''N5'''-[[VMU]]-[[NTU]]
*'''S3'''-[[NTU]] (Non acute Geri rehab unit)
*'''S4'''-[[CTU]] - (CTU opened: August 1.09-[[Site and Location#Details for Vic N4/S3 |'''S4''']] 
*'''S5'''-[[VMU]]-[[NTU]]
*[[EMIP]]
*[[OVER]]
||
*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]]
*[[Site and Location#Details for Grace W3 / E3 / S3 | '''W3''']]-[[NTU]] or [[METU]] (non acute geri rehab)
*[[EMIP]]
||
*MICU-September 14, 1998
*N3-January 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
|}
 
 
== 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 ===
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.[[User:TOstryzniuk|Trish Ostryzniuk]] 18:08, 2014 December 1 (CST) 
**total of 3 Var 1 with B5
**total of 71 Var 2 with B5


<!-- As generated by [[Semantic Mediawiki]] -->
{{#ask: [[Category:Collection Location]]
[[Collection Location Enddate::>{{CURRENTDAY}} {{CURRENTMONTHNAME}} {{CURRENTYEAR}}]]
[[Collection Location Startdate::<{{CURRENTDAY}} {{CURRENTMONTHNAME}} {{CURRENTYEAR}}]]
| searchlabel=Collection Locations
| ?Collection Location Startdate
| ?Collection Location Program
| ?Collection Bed Nrs
| format=table
| default=No locations found.
}}


== Also see==
* [[S_dispo table]]
* Go to [[Total admissions ICU/Med]] to see TOTAL number of admissions currently in ICU and Medicine database.


== Related Articles ==
{{Related Articles}}


[[Category: Data Collection Guide]]
[[Category: Data Collection Guide]]
[[Category: Registry Data]]
[[Category: Registry Data]]
[[Category: Site and Location | *]]
[[Category: Site and Location | *]]
[[Category: Overflow]]
[[Category: Reporting | Reporting]]
[[Category: Reporting | Reporting]]

Latest revision as of 13:52, 2022 January 6

This table shows Hospitals/Sites and locations where we collect data and their codes for entry into the Pre-admit Inpatient Institution field, Previous Location field, Service/Location field and Dispo fields

Click the following for a list including locations where we have collected in the past:

Complete list including legacy

 Collection Location StartdateCollection Location ProgramCollection Bed Nrs
GH-CC15 October 2020Critical Care
GH-MICU14 September 1998Critical Care10
GH-Med1 October 2020Medicine
GH-N31 January 2005Medicine35
GH-N51 January 2005Medicine36
GH-Recovery Room1 April 2020Critical Care15
GH-S326 May 2015Medicine35
HSC A41 October 2003Medicine31
HSC B318 October 2004Medicine10
HSC H41 April 2004Medicine30
HSC HOBS7 August 2020Medicine12
HSC IICU13 May 1997Critical Care10
HSC MICU11 July 1988Critical Care19
HSC Med15 October 2020Medicine
HSC SICU11 July 1988Critical Care15
HSC WRS215 August 2023Medicine12
HSC WRS319 March 2020Medicine24
HSC-GA7S18 October 2004Medicine
STB A6ME4 September 2024Medicine30
STB ACCU5 July 2016Critical Care9
STB B518 November 2009Medicine32
STB CICU15 January 2007Critical Care14
STB E51 December 2004Medicine32
STB E6 B14 October 2004Medicine32
STB MICU24 May 1999Critical Care14
STB Med15 October 2020Medicine

Also see

Related Articles

Related articles: