Difference between revisions of "scheduleNow"

From MGH Learn Pathology
Line 43: Line 43:
 
<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=GROUP_CONCAT(scheduleFACservice.StaffAbbrev),scheduleFACservice.TaskAbbrev,GROUP_CONCAT(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=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=scheduleFaculty}}
 
|default={{schtableempty|{{#explode:TaskAbbreviation|,|2}}}}|format=template|template=scheduleFaculty}}
 
|}}
 
|}}
Line 59: Line 59:
 
</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: {{#time: 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=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}}
 +
|}}
 +
}}
 +
</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: {{#time: 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)={{#time: Y|{{Timezone}}}} AND scheduleFELLservice.WeekNumber='{{#expr: {{#time: 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)={{#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}}
 +
|}}
 +
{{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>

Revision as of 10:32, December 20, 2021

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
KSH,OPA,PHI,RNS
KMA,KZL,RXN
JMD
SFA
-
-
-
-
-
MCH
-
-
-
-
EAD
JPB
AUO
EKP
NEA,TZO
-
BRC
YQG
-
-
-
-
RSC
FXR
JSW
BBK,DEM,RRA
-
KOA
-
BBC,LHV
Fellow
-
-
-
-
-
-
-
-
-
DZ1016
-
EHA
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
AKE
-
-
-
Attending[1]
-
-
Wu
-
-
-
Call
Torous
Nielsen
Turashvili
Turashvili
Turashvili
-
Avillach
Torous
Torous
Torous
Bulterys
Bulterys
Bulterys
ANA
-
-
Zhang
Zhang
Zhang
Zhang
Wu
Wu
Hsu-Lin
Hsu-Lin
Patalas,Dannheim
Sadow
Sadow
Hasserjian
Hasserjian
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
-
MSS
-
AND,RAK
-
-
FXR
JSW
-
-
-
-
-
-
-
-
-
JSE,SMT
Fellow
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
Attending[1]
Makar
Fitzpatrick
-
-
-
-
Dannheim,Sohani
Nardi
Dighe
-
-
-
-
-
-
-
MM408
-
Call
27364
No results Fitzpatrick
15433
32443
25338
25338
Dannheim,Sohani
Dannheim,Sohani
Dighe
-
-
-
-
-
-
-
MM408
-

[1]Faculty schedule displayed using the QGenda API.

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