Difference between revisions of "scheduleNow"

From MGH Learn Pathology
 
(34 intermediate revisions by the same user not shown)
Line 8: Line 8:
 
<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=
 
{{: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}}
 
|}}
 
|}}
 
}}
 
}}
Line 27: Line 26:
 
<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 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}}
 
|}}
 
|}}
Line 43: Line 42:
 
<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=scheduleFACserviceDowntime,facultyMGH|join on=scheduleFACserviceDowntime.StaffAbbrev=facultyMGH.copath_id
+
{{#cargo_query: table=scheduleFACservice,facultyMGH|join on=scheduleFACservice.StaffAbbrev=facultyMGH.copath_id
−
|fields=GROUP_CONCAT(scheduleFACserviceDowntime.StaffAbbrev),scheduleFACserviceDowntime.TaskAbbrev,GROUP_CONCAT(scheduleFACserviceDowntime.StaffFullName),facultyMGH.pageid
+
|fields=scheduleFACservice.StaffAbbrev,scheduleFACservice.TaskAbbrev,scheduleFACservice.StaffFullName,facultyMGH.pageid
−
|group by=scheduleFACserviceDowntime.Color
+
|group by=scheduleFACservice.Color
−
|where=YEAR(Date)={{#time: Y|{{Timezone}}}} AND scheduleFACserviceDowntime.TaskAbbrev='{{#explode:TaskAbbreviation|,|0}}' AND scheduleFACserviceDowntime.DayNumber='{{#time:N|now}}' AND scheduleFACserviceDowntime.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>
Line 59: Line 58:
 
</tr>
 
</tr>
 
</table>
 
</table>
 +
<p></p>
 +
__NOCACHE__<table class="table borderless">
 +
<tr><td bgcolor="#f0f0f0" colspan="5"><center>'''{{ColorText|Clinical pathology (LMM)|||4}}'''</center></td></tr>
 +
<tr>
 +
<td style="width: 20%">
 +
<table class='scheduletable'><tr><td bgcolor="#f5f5f5"><center>{{ColorText|'''Service'''||#000000|}}</center></td></tr></table>
 +
{{:scheduleDictionaryCP}}
 +
</td>
 +
<td style="width: 20%">
 +
<table class='scheduletable'><tr><td bgcolor="#f5f5f5"><center>'''{{ColorText|{{#tip-text:Resident|Resident}}||#000000|}}'''</center></td></tr></table>
 +
{{#switch: {{#timel: N|{{Timezone}}}}
 +
|6
 +
|7=
 +
{{:scheduleDictionaryCP}}
 +
|{{#arraymap:{{scheduleDictionaryCP}}|;|TaskAbbreviation|
 +
{{#cargo_query: tables=scheduleRESservice,residentMGH
 +
|join on=scheduleRESservice.ResAbbrev=residentMGH.copath_id
 +
|fields=GROUP_CONCAT(DISTINCT scheduleRESservice.ResAbbrev)
 +
,scheduleRESservice.TaskAbbrev
 +
,GROUP_CONCAT(DISTINCT residentMGH.full_name)
 +
,pageid
 +
|group by=scheduleRESservice.WeekNumber
 +
|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}}
 +
|}}
 +
}}
 +
</td>
 +
<td style="width: 20%">
 +
<table class='scheduletable'><tr><td bgcolor="#f5f5f5"><center>'''{{ColorText|{{#tip-text:Fellow|Fellow / Elective-Resident}}||#000000|}}'''</center></td></tr></table>
 +
{{#switch: {{#timel: N|{{Timezone}}}}
 +
|6
 +
|7=
 +
{{:scheduleDictionaryCP}}
 +
|{{#arraymap:{{scheduleDictionaryCP}}|;|TaskAbbreviation|
 +
{{#cargo_query: tables=scheduleFELLservice,residentMGH
 +
|join on=scheduleFELLservice.FellAbbrev=residentMGH.copath_id
 +
|fields=scheduleFELLservice.FellAbbrev,scheduleFELLservice.TaskAbbrev,residentMGH.full_name,residentMGH.pageid
 +
|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}}
 +
|}}
 +
}}
 +
</td>
 +
<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>
 +
{{#arraymap:{{scheduleDictionaryCPfaculty}}|;|TaskAbbreviation|
 +
{{#cargo_query: table=scheduleFACservice,facultyMGH|join on=scheduleFACservice.StaffAbbrev=facultyMGH.copath_id
 +
|fields=GROUP_CONCAT(scheduleFACservice.StaffAbbrev),scheduleFACservice.TaskAbbrev,GROUP_CONCAT(scheduleFACservice.StaffFullName),facultyMGH.pageid
 +
|group by=scheduleFACservice.Color
 +
|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}}
 +
|}}
 +
{{scheduleImmunoException}}
 +
</td>
 +
<td style="width: 20%">
 +
<table class='scheduletable'><tr><td bgcolor="#f5f5f5"><center>'''{{ColorText|{{#tip-text:Call|On call attending}}||#000000|}}'''
 +
</center></td></tr></table>
 +
{{:learn:oncallfaculty}}
 +
</td>
 +
</tr>
 +
</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>

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
-
-
-
-
-
-
-
-
MM408
-
Call
27364
No results Fitzpatrick
15433
32443
25338
25338
Hasserjian
Hasserjian
Dighe
-
-
-
-
-
-
-
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