Site and Location table: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
TOstryzniuk (talk | contribs)
m /* NEW - STB_CCU service patients in STB_MICU unit - Collection Process CHANGE for LOCATION and [http://ltc.umanitoba.ca/wikis/ccmdb/index.php/Registry_Patient_Type#Registry_Patient_type_and_Site_and_Location__-_New_for_STB_as_of_October_1.2C_2010 Re
m HSC Boarding Loc link cleanup
 
(78 intermediate revisions by 3 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 '''[[Location field]]'''.
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
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).


*Also see: [[S Locations]]
'''Click the following for a list including locations where we have collected in the past:{{#cargo_query:
tables=CollectionLocation
|fields=_pageName = ward/unit, StartDate, EndDate, Program
|limit=0
|more results text=Complete list including legacy
|default=no results were found}}


''items in blue are links to details recorded below''
<!-- As generated by [[Semantic Mediawiki]] -->
{| class="wikitable" border=1
{{#ask: [[Category:Collection Location]]  
|-  
[[Collection Location Enddate::>{{CURRENTDAY}} {{CURRENTMONTHNAME}} {{CURRENTYEAR}}]]
|| '''Hospital/Site''' || '''ICU ward location''' || '''Medicine ward location''' || Data Collection Start Date
[[Collection Location Startdate::<{{CURRENTDAY}} {{CURRENTMONTHNAME}} {{CURRENTYEAR}}]]
|-
| searchlabel=Collection Locations
|| '''HSC''' || '''MICU, SICU, CCU, IICU'''  ||
| ?Collection Location Startdate
*'''A4'''-[[CTU]]
| ?Collection Location Program
*[[Site and Location#Details for HSC_B3 | B3]]-[[CTU]]
| ?Collection Bed Nrs
*'''D4'''-[[CTU]]
| format=table
*'''D5'''-[[NTU]] (non acute geri-rehab)
| default=No locations found.
*'''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


|-
== Also see==
|| '''STB'''
* [[S_dispo table]]
*[[STB Med Ward changes]]
* Go to [[Total admissions ICU/Med]] to see TOTAL number of admissions currently in ICU and Medicine database.
| width="220" |
*[[Site and Location#Details for STB ICU | MICU]]
 
*'''CCU'''
*[[Site and Location#Details for STB ICU|'''CICU''' ]]
 
| width="220" |
*'''B4'''-[[NTU]] (B4 changed to '''5B'''- [[NTU]]. Change date: Nov 17.09.  (non acute geri rehab) 
*'''B5'''- [[CTU]] change date: '''Oct 14.09''' (stop at serial 6310 move to E6), (stop at serial 4597-Deb's PDA every 86-100)
*'''E6'''- [[CTU]] change date: '''Oct 14.09''' (start at serial 6311)(start at serial 4598 -Deb's every 86-100)) 
*'''E5'''- [[CTU]]
**Med overflow tracking to the following units: (A5, A6 & E6)
||
*MICU-May 24,1999
*SICU-May 24, 1999
**Combined Unit: January 15, 2007
*CCU-May 24, 1999
*CICU-January 15, 2007
 
*B5 (E6)-August 1, 2004
**Moved to E6-October 14.09
*B4-November 1, 2004
**Moved to 5B-November 17, 2009
*E6-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]]
||
*N3F&S4F-Family Medicine-July 1, 2005 to June 30, 2006
*N5-August 1, 2005
*S5-September 1, 2005
*N4-September 1, 2005
*S3-October 1, 2005
*S4-October 1, 2005 (check trish)
**Opened as a CTU August 1, 2009
|-
|| '''GRA''' || '''MICU''' ||
*'''N3'''-[[CTU]]
*'''N5'''-[[NTU]]
*[[Site and Location#Details for Grace W3 / E3 / S3 | '''W3''']]-[[NTU]] (non acute geri rehab)
*[[EMIP]]
||
*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,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
 
====NEW - STB_CCU physician service patients physically located in STB_MICU unit - Collection Process CHANGE for LOCATION and [http://ltc.umanitoba.ca/wikis/ccmdb/index.php/Registry_Patient_Type#Registry_Patient_type_and_Site_and_Location__-_New_for_STB_as_of_October_1.2C_2010 Registry Patient Type]====
 
{{Discussion}}
some of this information is repeated in link above. Clearer details here but I am not sure how best combined since one article is about registry type and the other is about site location and both are related "changes" for STB cardiology patient overflowing into CICU and MICU.--[[User:TOstryzniuk|TOstryzniuk]] 15:03, 10 December 2010 (CST)
 
#Cardiology (CCU) Service Patients that are '''physically located''' in the '''STB MICU''' but are looked after by the Cardiology Service physician will collected and entered into the database with a '''Site_location as: STB_MICU.''' [http://ltc.umanitoba.ca/wikis/ccmdb/index.php/Overflow_to_other_units_-_Critical_Care_HSC_and_STB_only#STB-CCU_overflow_patient_in_MICU.2FSICU_.28under_cardiology_service.29 CCU overflow into STB_MICU location].
#Cardiology Service Patients that are "physically located" in the '''STB_CICU''' but are looked after the Cardiology Service physician will collected and entered into the database with a '''Site_location as: STB_CICU'''.[http://ltc.umanitoba.ca/wikis/ccmdb/index.php/Overflow_to_other_units_-_Critical_Care_HSC_and_STB_only#STB-CCU_overflow_patient_in_CICU___.28under_cardiology_care.29 CCU overlow into STB_CICU location].
#*[[Registry Patient Type]] for the above two scenerios will be coded as '''C''' to indicate the patient is under Cardiology Physician Service Care. 
#If MICU attending physician '''takes over''' their '''care''', a NEW profile will be started
#'''Site_Location''' for the NEW profile will be '''STB_MICU'''
#[[Registry Patient Type]] will be coded as  '''M''' to indicate the patient is under Medical Physician Service Care
#*The [[Statistician]] who uses [[SAS]] programs to link [[continuous admission]]s, will update her SAS program so that an admission '''FROM''' Site_Loc, STB_MICU '''TO''' Site_Loc,STB_MICU, will not be flagged as an error.    The distinguishing feature of these cases will be [[Registry Patient Type]], which will indicate the Physician Service Care the patient is under will in the STB MICU unit.
#*The [[:Category: Data Integrity Rules | data integrity rules]] in [[CCMDB.mdb]] will be changed to allow site and location STB_MICU with discharge to: BM if Registry type is C.  If registry type M or S, then not allowed.    If Site and location STB_CICU with discharge to: CV if registry type is C.  If registry type S then not allowed.     
#If the patient is moved '''FROM''' STB_MICU '''TO''' STC_CCU location on the fifth floor, a new profile will again be used: 
#Site_Location will be STB_CCU
#[[Registry Patient Type]] will be coded as '''C''' to indicate the patient is under Cardiac Physician Service Care. 
*--[[User:LKolesar|LKolesar]] 15:54, 20 October 2010 (CDT)
=====Date of change=====
*'''October 1, 2010'''.
 
== Details for Vic N4/S3 ==
*The VGH has had two floors completely renovated and has moved two complete programs around. Initially when the medicine data base started, the fourth floor (N4) was a mix between medicine and surgery. The North ward(N4) had 30 beds and the south ward (S4) had 30 beds, and the medicine/surgical patients were mixed up between the two sides.  Originally the data collection started on N4. The surgical program got moved to our old LDRP ward, on the second floor. So now 40 beds of surgery reside on second floor. The VMU ward got placed on S4 and [[Family Medicine]] totally moved to N4. We never changed the PDA's to reflect the S4 change, left with PDA setting of N4.
**According to Tina, there would be major problems with Handibase/Active Sync Programs if change was made the reflect the S4 change.[[User:TOstryzniuk|TOstryzniuk]] 12:45, 3 December 2008 (CST)
**<Tina could you expand on this part of the PDA story>[[User:TOstryzniuk|TOstryzniuk]] 12:45, 3 December 2008 (CST)
***They are using laptops now, if we want to change this we would need to decide exactly what we want to do and then implement. [[User:Ttenbergen|Ttenbergen]] 14:03, 11 September 2009 (CDT)
 
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 14th 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 13th 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 then moves data should be to E6. 
 
*If the B5 ward admit date was October 13th or “earlier” then move data is B5 even if patient is move to you on or after October 14.   
 
===Integrity Checks ===
Variable 1 & 2 of Other Wards:
 
*If the admit date of the other ward was October 13th or “earlier” then var 1 should be FROM B5.
 
*If the admit date of the other ward was “on” or after Oct 14 then var 1 should be FROM E6. 
 
*If the discharge date of the other ward was October 13th or “earlier” then var 2 should be TO B5.
 
*If the discharge date of the other ward was “on” or after Oct 14 then var 2 should be TO E6.
 
== 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.[[User:TOstryzniuk|TOstryzniuk]] 18:59, 5 January 2010 (CST)
 
 
{{Discussion}}
*Need to clean up table above further.[[User:TOstryzniuk|TOstryzniuk]] 20:37, 18 January 2010 (CST)
** Trish, you asked me a long time ago if I could help clean this up. I would like to set this up as headings and sub-headings rather than a table. If that's OK with you I'll take care of it. Just let me know. [[User:Ttenbergen|Ttenbergen]] 10:28, 3 November 2010 (CDT)
***Yes, that would be great! Thank you.-[[User:TOstryzniuk|TOstryzniuk]] 14:54, 10 December 2010 (CST)


== 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: 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: