Site and Location table

This table shows Hospitals/Sites and locations where we collect data and their codes for entry into the Location field.

• Also see: S Locations
• Go to Database Total ICU/Med to see TOTAL number of admissions currently in ICU and Medicine database.

• HSC Med nonteaching contingency beds

old table

Hospital/Site	ICU ward location	Medicine ward location	Data Collection Start Date
STB STB Med Ward changes	MICU CCU CICU (STB_CICU)	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	N4-Legacy N4 N5-VMU-NTU S3-NTU (Non acute Geri rehab unit) S4-CTU - (CTU opened: August 1.09-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

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