Database Anniversary Dates: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
TOstryzniuk (talk | contribs)
m m
 
(31 intermediate revisions by 2 users not shown)
Line 1: Line 1:
Anniversary dates in 2016 for:
Anniversary dates for:
*HSC ICU - '''28 yrs''' '''(Jul 1988)'''
*GRA ICU - '''18 yrs''' (Sep 1998)
*STB ICU - '''17 yrs''' (May 1999)
**STB_CICU - '''9 yrs''' (Jan 15.2007)
*CON ICU - '''17 yrs''' (May 1999)
*OAK ICU - '''17 yrs''' (Jun 1999)
*VIC ICU - '''17 yrs''' (Jun 1999)
*HSC Med A4 - '''13 yrs''' (Oct 2003)
**HSC Med - '''12 yrs''' (Mar-Apr 2004)
*Gra Med - '''12 yrs''' (Jan 2004)
*STB Med - '''12 yrs''' (Aug-Dec 2004)
*VIC Med - '''11 yrs''' (Aug-Oct 2005)


<!-- this will self-update the age BUT NOT THE UNITS as they are added and removed -->
== Current ==
{{#cargo_query:
tables=CollectionLocation
|fields=_pageName=unit,
StartDate=start,
DATEDIFF(COALESCE(EndDate, CURRENT_DATE()),StartDate)=days,
CONCAT("{{age{{!}}EndDate=",COALESCE(EndDate, CURRENT_DATE()),"{{!}}StartDate=",StartDate,"}}")=years
|where=EndDate IS NULL
|order by=unit
|limit=100
|default=no results were found
}}


<!-- this will self-update the age but the list is slightly different... Trish, keep which one you prefer.-->
== Legacy ==
{{Discussion}} - where are the dates below is drawing from?-Trish
{{#cargo_query:
* {{Location Age | Location =CON MICU }}
tables=CollectionLocation
* {{Location Age | Location =GRA EMIP }}
|fields=_pageName=unit,
* {{Location Age | Location =GRA MICU }}
StartDate=start,
* {{Location Age | Location =GRA N3 }}
EndDate=end,
* {{Location Age | Location =GRA N5 }}
DATEDIFF(COALESCE(EndDate, CURRENT_DATE()),StartDate)=days,
* {{Location Age | Location =GRA OVER }}
CONCAT("{{age{{!}}EndDate=",COALESCE(EndDate, CURRENT_DATE()),"{{!}}StartDate=",StartDate,"}}")=years
* {{Location Age | Location =GRA W3 }}
|where=EndDate IS NOT NULL
* {{Location Age | Location =HSC A4 }}
|order by=unit
* {{Location Age | Location =HSC B3 }}
|limit=100
* {{Location Age | Location =HSC CCU }}
|default=no results were found
* {{Location Age | Location =HSC D4 }}
}}
* {{Location Age | Location =HSC D5 }}
 
* {{Location Age | Location =HSC H4 }}
== Wiki ==
* {{Location Age | Location =HSC H4H }}
* the first account on this wiki was set up 2008-03-11
* {{Location Age | Location =HSC IICU }}
 
* {{Location Age | Location =HSC MICU }}
== Related articles ==
* {{Location Age | Location =HSC SICU }}
{{Related Articles}}
* {{Location Age | Location =OAK MICU }}
 
* {{Location Age | Location =STB 5B }}
[[Category:Site and Location]]
* {{Location Age | Location =STB B4 }}
* {{Location Age | Location =STB B5 }}
* {{Location Age | Location =STB CCU }}
* {{Location Age | Location =STB CICU }}
* {{Location Age | Location =STB E5 }}
* {{Location Age | Location =STB E6 }}
* {{Location Age | Location =STB MICU }}
* {{Location Age | Location =STB SICU }}
* {{Location Age | Location =VIC EMIP }}
* {{Location Age | Location =VIC MICU }}
* {{Location Age | Location =VIC N3F }}
* {{Location Age | Location =VIC N4 }}
* {{Location Age | Location =VIC N5 }}
* {{Location Age | Location =VIC S3 }}
* {{Location Age | Location =VIC S4 }}
* {{Location Age | Location =VIC S5 }}

Latest revision as of 22:23, 11 March 2025

Anniversary dates for:

Current

unit start days years
GH-CC 2020-10-15 1628 4 years
GH-Med 2020-10-01 1642 4 years
GH-MICU 1998-09-14 9695 26 years
GH-N3 2005-01-01 7394 20 years
GH-N5 2005-01-01 7394 20 years
GH-Recovery Room 2020-04-01 1825 4 years
GH-S3 2015-05-26 3597 9 years
HSC A4 2003-10-01 7852 21 years
HSC B3 2004-10-18 7469 20 years
HSC H4 2004-04-01 7669 20 years
HSC HOBS 2020-08-07 1697 4 years
HSC IICU 1997-05-13 10184 27 years
HSC JK3
HSC Med 2020-10-15 1628 4 years
HSC MICU 1988-07-11 13412 36 years
HSC SICU 1988-07-11 13412 36 years
HSC WRS2 2023-08-15 594 1 years
HSC WRS3 2020-03-19 1838 5 years
HSC-GA7S 2004-10-18 7469 20 years
STB A6ME 2024-09-04 208 0 years
STB ACCU 2016-07-05 3191 8 years
STB B5 2009-11-18 5612 15 years
STB CICU 2007-01-15 6650 18 years
STB E5 2004-12-01 7425 20 years
STB E6 B 2004-10-14 7473 20 years
STB Med 2020-10-15 1628 4 years
STB MICU 1999-05-24 9443 25 years

Legacy

unit start end days years
CON MICU 1999-05-01 2019-06-23 7358 20 years
GH-2S 2020-04-14 2020-06-18 65 0 years
GH-5S 2020-04-07 2020-04-10 3 0 years
GH-EMIP 2010-11-01 2020-10-01 3622 9 years
GH-OVER 2007-05-09 2007-05-09 0 0 years
GH-W3 2005-01-01 2016-05-26 4163 11 years
HSC B2 2020-04-07 2020-08-07 122 0 years
HSC CCU 1999-05-01 2019-06-17 7352 20 years
HSC D4 2004-03-01 2020-03-20 5863 16 years
HSC D4 COVID 2020-04-03 2020-05-14 41 0 years
HSC D5 2020-03-19 2020-05-28 70 0 years
HSC D5 D 2020-03-19 2020-05-28 70 0 years
HSC D5 Pre COVID 2004-03-01 2020-03-19 5862 16 years
HSC EMIP 2016-10-01 2020-10-15 1475 4 years
HSC H4H 2005-05-01 2020-04-14 5462 14 years
OAK MICU 1999-06-01 2019-09-20 7416 20 years
STB A7 B March 2020 2020-06-11 102 0 years
STB B4 2004-11-01 2009-11-17 1842 5 years
STB B5old 2004-08-01 2009-10-13 1899 5 years
STB CCU 1999-05-24 2016-07-05 6252 17 years
STB E6 C March 2025 2020-06-11 -1753 -5 years
STB EMIP 2016-03-07 2020-10-15 1683 4 years
STB IMCU 2018-10-01 2019-04-01 182 0 years
STB SICU 1999-05-24 2007-01-15 2793 7 years
VIC EMIP 2007-02-01 2017-09-30 3894 10 years
VIC MICU 1999-06-01 2017-09-25 6691 18 years
VIC N3F 2005-07-01 2006-06-30 364 0 years
VIC N4 2017-09-29 2018-01-12 105 0 years
VIC N4C 2017-10-02 2018-10-26 389 1 years
VIC N5 2005-08-01 2017-10-01 4444 12 years
VIC N5C 2017-10-03 2018-10-26 388 1 years
VIC S3 2005-10-01 2017-09-22 4374 11 years
VIC S4 2005-10-01 2017-10-01 4383 12 years
VIC S5 2005-09-01 2017-09-30 4412 12 years
VIC S5C 2017-10-03 2018-10-26 388 1 years

Wiki

  • the first account on this wiki was set up 2008-03-11

Related articles

Related articles: