Site and Location table

From CCMDB Wiki
Revision as of 20:09, 2010 January 5 by TOstryzniuk (talk | contribs)
Jump to navigation Jump to search

This table shows Hospitals/Sites and locations where we collect data and their codes for entry into the Location field. 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).

items in blue are links to details recorded below

Hospital/Site ICU Locations Medicine Locations
HSC MICU, SICU, CCU, IICU
STB
  • CCU
  • 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
  • --TOstryzniuk 22:13, 26 October 2009 (CDT)
    • Med overflow tracking to the following units: (A5, A6 & E6)
VIC MICU
GRA MICU
CON MICU 0
OAK MICU 0


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 and STB_SICU were combined into one unit called STB_MICU on Jan.15, 2007
  • Cardiac Care Unit STB_CICU was established Jan 15, 2007

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.TOstryzniuk 12:45, 3 December 2008 (CST)
    • <Tina could you expand on this part of the PDA story>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. 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.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.TOstryzniuk 18:59, 5 January 2010 (CST)
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Site_and_Location_table&oldid=16518"