Site and Location table: Difference between revisions

m Text replacement - "[[Category: " to "[[Category:"
 
(30 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 '''[[Location field]]'''.
This page is outdated, see [[Collection location documentation]].


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
'''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}}
{{Collapsable | always = this table is probably outdated, pending [[Collection location documentation]]
|full=
<!-- As generated by [[Semantic Mediawiki]] -->
<!-- As generated by [[Semantic Mediawiki]] -->
{{#ask: [[Category:Collection Location]]  
{{#ask: [[Category:Collection Location]]  
[[Collection Location Enddate::>{{CURRENTDAY}} {{CURRENTMONTHNAME}} {{CURRENTYEAR}}]]
[[Collection Location Startdate::<{{CURRENTDAY}} {{CURRENTMONTHNAME}} {{CURRENTYEAR}}]]
| searchlabel=Collection Locations
| searchlabel=Collection Locations
| ?Collection Location Startdate
| ?Collection Location Startdate
| ?Collection Location Enddate
| ?Collection Location Program
| ?Collection Location Program
| ?Collection Location Hospital
| ?Collection Bed Nrs
| ?Collection Location Service Type
| ?Collection Location Service Type Legacy
| ?Collection Location workload split
| format=table
| 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.


*Also see: [[S Locations]]
== Related Articles ==
*Go to [[Database Total ICU/Med]] to see TOTAL number of admissions currently in ICU and Medicine database.
{{Related Articles}}
 
*[[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
 
 
 


[[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]]