Difference between revisions of "scheduleNow"

From MGH Learn Pathology
 
(56 intermediate revisions by the same user not shown)
Line 1: Line 1:
 
__NOCACHE__<table class="table borderless">
 
__NOCACHE__<table class="table borderless">
−
<tr><td bgcolor="#f0f0f0" colspan="4"><center>'''{{ColorText|Anatomic pathology (AMP)|||4}}'''</center></td></tr>
+
<tr><td bgcolor="#f0f0f0" colspan="5"><center>'''{{ColorText|Anatomic pathology (AMP)|||4}}'''</center></td></tr>
 
<tr>
 
<tr>
−
<td style="width: 25%">
+
<td style="width: 20%">
 
<table class='scheduletable'><tr><td bgcolor="#f5f5f5"><center>{{ColorText|'''Service'''||#000000|}}</center></td></tr></table>
 
<table class='scheduletable'><tr><td bgcolor="#f5f5f5"><center>{{ColorText|'''Service'''||#000000|}}</center></td></tr></table>
 
{{:scheduleDictionaryAP}}
 
{{:scheduleDictionaryAP}}
 
</td>
 
</td>
−
<td style="width: 25%">
+
<td style="width: 20%">
 
<table class='scheduletable'><tr><td bgcolor="#f5f5f5"><center>'''{{ColorText|{{#tip-text:Resident|Resident}}||#000000|}}'''</center></td></tr></table>
 
<table class='scheduletable'><tr><td bgcolor="#f5f5f5"><center>'''{{ColorText|{{#tip-text:Resident|Resident}}||#000000|}}'''</center></td></tr></table>
−
{{#switch: {{#time: N|{{Timezone}}}}
+
{{#switch: {{#timel: N|{{Timezone}}}}
 
|6
 
|6
 
|7=
 
|7=
 
{{:scheduleDictionaryAPempty}}
 
{{:scheduleDictionaryAPempty}}
 
|{{#arraymap:{{scheduleDictionaryAPresident}}|;|TaskAbbreviation|
 
|{{#arraymap:{{scheduleDictionaryAPresident}}|;|TaskAbbreviation|
−
{{#cargo_query: tables=scheduleRESservice,residentMGH
+
{{#cargo_query: tables=scheduleRESservice_view
−
|join on=scheduleRESservice.ResAbbrev=residentMGH.copath_id
 
 
|fields=
 
|fields=
−
GROUP_CONCAT(DISTINCT scheduleRESservice.ResAbbrev)
+
ResAbbrev,
−
,scheduleRESservice.TaskAbbrev
+
TaskAbbrev,
−
,GROUP_CONCAT(DISTINCT residentMGH.full_name)
+
FullName,
−
,pageid
+
Pager
−
|group by=scheduleRESservice.WeekNumber
+
|group by=WeekNumber
−
|where=YEAR(Date)={{#time: Y|{{Timezone}}}} AND scheduleRESservice.WeekNumber='{{#expr: {{#time: W|{{Timezone}}}} - 0 }}' AND scheduleRESservice.TaskAbbrev='{{#explode:TaskAbbreviation|,|0}}'|default={{schtableempty|{{#explode:TaskAbbreviation|,|2}}}}|format=template|template=scheduleResident}}
+
|where=LocationAbbrev='MGH' AND Year={{#timel: Y|{{Timezone}}}} AND WeekNumber='{{#expr: {{#timel: W|{{Timezone}}}} - 0 }}' AND TaskAbbrev='{{#explode:TaskAbbreviation|,|0}}' AND scheduleRESservice_view.Date > '2025-02-02'|default={{schtableempty|{{#explode:TaskAbbreviation|,|2}}}}|format=template|template=scheduleResidentNew}}
 
|}}
 
|}}
 
}}
 
}}
 
</td>
 
</td>
−
<td style="width: 25%">
+
<td style="width: 20%">
 
<table class='scheduletable'><tr><td bgcolor="#f5f5f5"><center>'''{{ColorText|{{#tip-text:Fellow|Fellow / Elective-Resident}}||#000000|}}'''</center></td></tr></table>
 
<table class='scheduletable'><tr><td bgcolor="#f5f5f5"><center>'''{{ColorText|{{#tip-text:Fellow|Fellow / Elective-Resident}}||#000000|}}'''</center></td></tr></table>
−
{{#switch: {{#time: N|{{Timezone}}}}
+
{{#switch: {{#timel: N|{{Timezone}}}}
 
|6
 
|6
 
|7=
 
|7=
Line 35: Line 34:
 
|join on=scheduleFELLservice.FellAbbrev=residentMGH.copath_id
 
|join on=scheduleFELLservice.FellAbbrev=residentMGH.copath_id
 
|fields=scheduleFELLservice.FellAbbrev,scheduleFELLservice.TaskAbbrev,residentMGH.full_name,residentMGH.pageid
 
|fields=scheduleFELLservice.FellAbbrev,scheduleFELLservice.TaskAbbrev,residentMGH.full_name,residentMGH.pageid
−
|where=YEAR(Date)={{#time: Y|{{Timezone}}}} AND scheduleFELLservice.WeekNumber='{{#expr: {{#time: W|{{Timezone}}}} - 0 }}' AND scheduleFELLservice.TaskAbbrev='{{#explode:TaskAbbreviation|,|0}}' |format=template
+
|where=YEAR(Date)={{#timel: Y|{{Timezone}}}} AND scheduleFELLservice.WeekNumber='{{#expr: {{#timel: W|{{Timezone}}}} - 0 }}' AND scheduleFELLservice.TaskAbbrev='{{#explode:TaskAbbreviation|,|0}}' AND scheduleFELLservice.Date > '2025-02-02'|format=template
 
|group by=scheduleFELLservice.WeekNumber|default={{schtableempty|{{#explode:TaskAbbreviation|,|2}}}}|template=scheduleResident}}
 
|group by=scheduleFELLservice.WeekNumber|default={{schtableempty|{{#explode:TaskAbbreviation|,|2}}}}|template=scheduleResident}}
 
|}}
 
|}}
 
}}
 
}}
 
</td>
 
</td>
−
<td style="width: 25%">
+
<td style="width: 20%">
−
{{#switch: {{#time: N|{{Timezone}}}}
 
−
|6
 
−
|7=
 
−
<table class='scheduletable'><tr><td bgcolor="#f5f5f5"><center>'''{{ColorText|{{#tip-text:On call - att.|On call attending}}||#000000|}}'''
 
−
</center></td></tr></table>
 
−
|1
 
−
|2
 
−
|3
 
−
|4
 
−
|5=
 
 
<table class='scheduletable'><tr><td bgcolor="#f5f5f5"><center>'''{{ColorText|{{#tip-text:Attending|Attending}}||#000000|}}'''<sup>[1]</sup></center></td></tr></table>
 
<table class='scheduletable'><tr><td bgcolor="#f5f5f5"><center>'''{{ColorText|{{#tip-text:Attending|Attending}}||#000000|}}'''<sup>[1]</sup></center></td></tr></table>
−
}}
 
 
{{#arraymap:{{scheduleDictionaryAPfaculty}}|;|TaskAbbreviation|
 
{{#arraymap:{{scheduleDictionaryAPfaculty}}|;|TaskAbbreviation|
−
{{#cargo_query: table=scheduleFACservice  
+
{{#cargo_query: table=scheduleFACservice,facultyMGH|join on=scheduleFACservice.StaffAbbrev=facultyMGH.copath_id
−
|fields=GROUP_CONCAT(scheduleFACservice.StaffAbbrev),scheduleFACservice.TaskAbbrev,GROUP_CONCAT(scheduleFACservice.StaffFullName)
+
|fields=scheduleFACservice.StaffAbbrev,scheduleFACservice.TaskAbbrev,scheduleFACservice.StaffFullName,facultyMGH.pageid
 
|group by=scheduleFACservice.Color
 
|group by=scheduleFACservice.Color
−
|where=YEAR(Date)={{#time: Y|{{Timezone}}}} AND scheduleFACservice.TaskAbbrev='{{#explode:TaskAbbreviation|,|0}}' AND scheduleFACservice.DayNumber='{{#time:N|now}}' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|{{Timezone}}}} - 0}}'
+
|where=LocationAbbrev='MGH' AND YEAR(Date)={{#timel: Y|{{Timezone}}}} AND scheduleFACservice.TaskAbbrev='{{#explode:TaskAbbreviation|,|0}}' AND scheduleFACservice.DayNumber='{{#timel:N|now}}' AND scheduleFACservice.WeekNumber='{{#expr: {{#timel: W|{{Timezone}}}} - 0}}' AND scheduleFACservice.Date > '2025-02-01'
−
|default={{schtableempty|{{#explode:TaskAbbreviation|,|2}}}}|format=template|template=scheduleFaculty}}
+
|limit=1|more results text=|default={{schtableempty|{{#explode:TaskAbbreviation|,|2}}}}|format=template|template=scheduleResident}}
 
|}}
 
|}}
 +
</td>
 +
<td style="width: 20%">
 +
<table class='scheduletable'><tr><td bgcolor="#f5f5f5"><center>[[onCallAMPrules|'''{{ColorText|{{#tip-text:Call|
 +
{{:onCallAMPrules}}
 +
}}||#000000|}}''']]
 +
</center></td></tr></table>
 +
{{:learn:oncallAMP}}
 
</td>
 
</td>
 
</tr>
 
</tr>
Line 73: Line 68:
 
<td style="width: 20%">
 
<td style="width: 20%">
 
<table class='scheduletable'><tr><td bgcolor="#f5f5f5"><center>'''{{ColorText|{{#tip-text:Resident|Resident}}||#000000|}}'''</center></td></tr></table>
 
<table class='scheduletable'><tr><td bgcolor="#f5f5f5"><center>'''{{ColorText|{{#tip-text:Resident|Resident}}||#000000|}}'''</center></td></tr></table>
−
{{#switch: {{#time: N|{{Timezone}}}}
+
{{#switch: {{#timel: N|{{Timezone}}}}
 
|6
 
|6
 
|7=
 
|7=
Line 85: Line 80:
 
,pageid
 
,pageid
 
|group by=scheduleRESservice.WeekNumber
 
|group by=scheduleRESservice.WeekNumber
−
|where=YEAR(Date)={{#time: Y|{{Timezone}}}} AND scheduleRESservice.WeekNumber='{{#expr: {{#time: W|{{Timezone}}}} - 0 }}' AND scheduleRESservice.TaskAbbrev='{{#explode:TaskAbbreviation|,|0}}'|default={{schtableempty|{{#explode:TaskAbbreviation|,|2}}}}|format=template|template=scheduleResidentCP}}
+
|where=LocationAbbrev='MGH' AND YEAR(Date)={{#timel: Y|{{Timezone}}}} AND scheduleRESservice.WeekNumber='{{#expr: {{#timel: W|{{Timezone}}}} - 0 }}' AND scheduleRESservice.TaskAbbrev='{{#explode:TaskAbbreviation|,|0}}'|default={{schtableempty|{{#explode:TaskAbbreviation|,|2}}}}|format=template|template=scheduleResidentCP}}
 
|}}
 
|}}
 
}}
 
}}
Line 91: Line 86:
 
<td style="width: 20%">
 
<td style="width: 20%">
 
<table class='scheduletable'><tr><td bgcolor="#f5f5f5"><center>'''{{ColorText|{{#tip-text:Fellow|Fellow / Elective-Resident}}||#000000|}}'''</center></td></tr></table>
 
<table class='scheduletable'><tr><td bgcolor="#f5f5f5"><center>'''{{ColorText|{{#tip-text:Fellow|Fellow / Elective-Resident}}||#000000|}}'''</center></td></tr></table>
−
{{#switch: {{#time: N|{{Timezone}}}}
+
{{#switch: {{#timel: N|{{Timezone}}}}
 
|6
 
|6
 
|7=
 
|7=
Line 99: Line 94:
 
|join on=scheduleFELLservice.FellAbbrev=residentMGH.copath_id
 
|join on=scheduleFELLservice.FellAbbrev=residentMGH.copath_id
 
|fields=scheduleFELLservice.FellAbbrev,scheduleFELLservice.TaskAbbrev,residentMGH.full_name,residentMGH.pageid
 
|fields=scheduleFELLservice.FellAbbrev,scheduleFELLservice.TaskAbbrev,residentMGH.full_name,residentMGH.pageid
−
|where=YEAR(Date)={{#time: Y|{{Timezone}}}} AND scheduleFELLservice.WeekNumber='{{#expr: {{#time: W|{{Timezone}}}} - 0 }}' AND scheduleFELLservice.TaskAbbrev='{{#explode:TaskAbbreviation|,|0}}' |format=template
+
|where=YEAR(Date)={{#timel: Y|{{Timezone}}}} AND scheduleFELLservice.WeekNumber='{{#expr: {{#timel: W|{{Timezone}}}} - 0 }}' AND scheduleFELLservice.TaskAbbrev='{{#explode:TaskAbbreviation|,|0}}' |format=template
 
|group by=scheduleFELLservice.WeekNumber|default={{schtableempty|{{#explode:TaskAbbreviation|,|2}}}}|template=scheduleResidentCP}}
 
|group by=scheduleFELLservice.WeekNumber|default={{schtableempty|{{#explode:TaskAbbreviation|,|2}}}}|template=scheduleResidentCP}}
 
|}}
 
|}}
Line 106: Line 101:
 
<td style="width: 20%">
 
<td style="width: 20%">
 
<table class='scheduletable'><tr><td bgcolor="#f5f5f5"><center>'''{{ColorText|{{#tip-text:Attending|Attending}}||#000000|}}'''<sup>[1]</sup></center></td></tr></table>
 
<table class='scheduletable'><tr><td bgcolor="#f5f5f5"><center>'''{{ColorText|{{#tip-text:Attending|Attending}}||#000000|}}'''<sup>[1]</sup></center></td></tr></table>
−
{{#arraymap:{{scheduleDictionaryCP}}|;|TaskAbbreviation|
+
{{#arraymap:{{scheduleDictionaryCPfaculty}}|;|TaskAbbreviation|
−
{{#cargo_query: table=scheduleFACservice  
+
{{#cargo_query: table=scheduleFACservice,facultyMGH|join on=scheduleFACservice.StaffAbbrev=facultyMGH.copath_id
−
|fields=GROUP_CONCAT(scheduleFACservice.StaffAbbrev),scheduleFACservice.TaskAbbrev,GROUP_CONCAT(scheduleFACservice.StaffFullName)
+
|fields=GROUP_CONCAT(scheduleFACservice.StaffAbbrev),scheduleFACservice.TaskAbbrev,GROUP_CONCAT(scheduleFACservice.StaffFullName),facultyMGH.pageid
 
|group by=scheduleFACservice.Color
 
|group by=scheduleFACservice.Color
−
|where=YEAR(Date)={{#time: Y|{{Timezone}}}} AND scheduleFACservice.TaskAbbrev='{{#explode:TaskAbbreviation|,|0}}' AND scheduleFACservice.DayNumber='{{#time:N|now}}' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|{{Timezone}}}} - 0}}'
+
|where=YEAR(Date)={{#timel: Y|{{Timezone}}}} AND scheduleFACservice.TaskAbbrev='{{#explode:TaskAbbreviation|,|0}}' AND scheduleFACservice.DayNumber='{{#timel:N|now}}' AND scheduleFACservice.WeekNumber='{{#expr: {{#timel: W|{{Timezone}}}} - 0}}'
 
|default={{schtableempty|{{#explode:TaskAbbreviation|,|2}}}}|format=template|template=scheduleResidentCPfaculty}}
 
|default={{schtableempty|{{#explode:TaskAbbreviation|,|2}}}}|format=template|template=scheduleResidentCPfaculty}}
 
|}}
 
|}}
 +
{{scheduleImmunoException}}
 
</td>
 
</td>
 
<td style="width: 20%">
 
<td style="width: 20%">
−
<table class='scheduletable'><tr><td bgcolor="#f5f5f5"><center>'''{{ColorText|{{#tip-text:On call - att.|On call}}||#000000|}}'''
+
<table class='scheduletable'><tr><td bgcolor="#f5f5f5"><center>'''{{ColorText|{{#tip-text:Call|On call attending}}||#000000|}}'''
 
</center></td></tr></table>
 
</center></td></tr></table>
−
{{#arraymap:{{scheduleDictionaryCP}}|;|TaskAbbreviation|
+
{{:learn:oncallfaculty}}
−
{{#cargo_query: table=scheduleFACservice
 
−
|fields=GROUP_CONCAT(scheduleFACservice.StaffAbbrev),scheduleFACservice.TaskAbbrev,GROUP_CONCAT(scheduleFACservice.StaffFullName)
 
−
|group by=scheduleFACservice.Color
 
−
|where=YEAR(Date)={{#time: Y|{{Timezone}}}} AND scheduleFACservice.TaskAbbrev='{{#explode:TaskAbbreviation|,|0}}' AND scheduleFACservice.DayNumber='{{#time:N|now}}' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|{{Timezone}}}} - 0}}'
 
−
|default={{schtableempty|{{#explode:TaskAbbreviation|,|2}}}}|format=template|template=scheduleResidentCPfaculty}}
 
−
|}}
 
 
</td>
 
</td>
 
</tr>
 
</tr>
 
</table>
 
</table>
 
<p align="left"><sup>{{ColorText|[1]|||1}}</sup>{{ColorText|Faculty schedule displayed using the <htmltag tagname="a" href="https://app.qgenda.com/Link/view?linkKey=9a12a547-f1b4-4998-bdca-acf3204a120e&landingPageId=40221bd9-4ac1-4a0b-8a00-da4f05d88f2e" target="_blank">QGenda API</htmltag>.|||2}}</p>
 
<p align="left"><sup>{{ColorText|[1]|||1}}</sup>{{ColorText|Faculty schedule displayed using the <htmltag tagname="a" href="https://app.qgenda.com/Link/view?linkKey=9a12a547-f1b4-4998-bdca-acf3204a120e&landingPageId=40221bd9-4ac1-4a0b-8a00-da4f05d88f2e" target="_blank">QGenda API</htmltag>.|||2}}</p>

Latest revision as of 15:57, December 29, 2025

Anatomic pathology (AMP)
Service
AUT
BST
BR1
BR2
BR3
MGB CV
RP
CA
CB
CC
DPA
DPB
DPC
EYE
FSJ
FSS
GI1
GI2
GI3
GI4
GU1
GU2
GYL
GYS
OB
HN1
HN2
HPA
HPB
NP
NPAUT
PP
GR-S
AP CHIEF
Resident
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
Fellow
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
Attending[1]
Stone
Nielsen
Ly
Ly
-
-
Avillach
Ly
Ly
Ly
Hoang
Hoang
Hoang
Dryja
-
-
Zhang
Zhang
Zhang
Zhang
Hsu-Lin
Hsu-Lin
Hsu-Lin
Hsu-Lin
Dannheim
Sadow
Sadow
Louissaint
Louissaint
Stemmer-Rach
-
Hariri
-
-
Call
Stone
Nielsen
Ly
Ly
Ly
-
Avillach
Ly
Ly
Ly
Hoang
Hoang
Hoang
ANA
-
-
Zhang
Zhang
Zhang
Zhang
Hsu-Lin
Hsu-Lin
Hsu-Lin
Hsu-Lin
Dannheim
Sadow
Sadow
Louissaint
Louissaint
Stemmer-Rach
Stemmer-Rach
Hariri
-
-

Clinical pathology (LMM)
Service
BTS
COAG
CORE
MICRO
HLA - A
HLA - B
HPA
HPB
HG
MOL: Consult
MOL: HER2
MOL: A non-NGS
MOL: A NGS
MOL: B NGS
MOL: B non-NGS
MOL: B FISH
IMMUNO
CP CHIEF
Resident
BTS
COAG
CORE
MICRO
HLA - A
HLA - B
HPA
HPB
HG
MOL: Consult
MOL: HER2
MOL: A non-NGS
MOL: A NGS
MOL: B NGS
MOL: B non-NGS
MOL: B FISH
IMMUNO
CP CHIEF
Fellow
BTS
COAG
CORE
MICRO
HLA - A
HLA - B
HPA
HPB
HG
MOL: Consult
MOL: HER2
MOL: A non-NGS
MOL: A NGS
MOL: B NGS
MOL: B non-NGS
MOL: B FISH
IMMUNO
CP CHIEF
Attending[1]
Haj
Uljon
-
-
-
-
Louissaint
Louissaint
-
-
-
-
-
-
-
-
-
Call
27364
No results Uljon
15433
32443
25338
25338
Louissaint
Louissaint
none
-
-
-
-
-
-
-
MM408
-

[1]Faculty schedule displayed using the QGenda API.

Retrieved from "https://learn.mghpathology.org/index.php?title=scheduleNow&oldid=154594"
  • Powered by MediaWiki
  • Search Powered by Cargo
  • Massachusetts General Hospital