|
|
| Line 19: |
Line 19: |
|
| |
|
| *[[HSC Med nonteaching contingency beds]] | | *[[HSC Med nonteaching contingency beds]] |
|
| |
| ==old table==
| |
| {| class="wikitable" border=1
| |
| |-
| |
| || '''Hospital/Site''' || '''ICU ward location''' || '''Medicine ward location''' || Data Collection Start Date
| |
|
| |
| |-
| |
| || '''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
| |
| |}
| |
|
| |
|
| |
| ===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
| |
|
| |
|
| |
|
|
| |
|