Difference between revisions of "learn:nextweekinap"

From MGH Learn Pathology
Line 1: Line 1:
 
{{DISPLAYTITLE:Next Week in AP}}{{varScheduleYear}}{{varScheduleYearNW}}{{#css: @media { .container { width: 95% !important; } }}
 
{{DISPLAYTITLE:Next Week in AP}}{{varScheduleYear}}{{varScheduleYearNW}}{{#css: @media { .container { width: 95% !important; } }}
 +
<br>
 +
{{ColorText|'''Tweet of the week @MGHPathology'''||#018ab2|6|}}
 +
<br>
 +
<p><htmltag tagname="a" href="https://twitter.com/MGHPathology?ref_src=twsrc%5Etfw" class="twitter-follow-button" data-show-screen-name="true" data-show-count="true">Follow @MGHPathology</htmltag><htmltag tagname="script" async src="https://platform.twitter.com/widgets.js" charset="utf-8"></htmltag></p>
 +
[[Image: IMG_9585.jpeg|500px]]
 
<br>
 
<br>
 
<table class='table borderless' style="width: 100%">
 
<table class='table borderless' style="width: 100%">
Line 17: Line 22:
 
<tr>
 
<tr>
 
<td style="width: 11%">
 
<td style="width: 11%">
{{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=YEAR(Date)='2024' AND scheduleFACservice.DayNumber='5' AND scheduleFACservice.WeekNumber='{{#expr: {{#timel: W|{{Timezone}}}} - 0 }}' AND scheduleFACservice.TaskAbbrev='BR1' AND scheduleFACservice.Date > '2024-02-01'|format=template|template=datedisplayfac|limit=1|more results text=}}
+
{{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=YEAR(Date)='{{#var:Friday}}' AND scheduleFACservice.DayNumber='5' AND scheduleFACservice.WeekNumber='{{#expr: {{#timel: W|{{Timezone}}}} - 0 }}' AND scheduleFACservice.TaskAbbrev='BR1' |format=template|template=datedisplayfac|limit=1|more results text=}}
 
<br>
 
<br>
 
{{#cargo_query: tables=scheduleCallConference,residentMGH  
 
{{#cargo_query: tables=scheduleCallConference,residentMGH  
 
     |join on=scheduleCallConference.ResAbbrev=residentMGH.copath_id
 
     |join on=scheduleCallConference.ResAbbrev=residentMGH.copath_id
 
     |fields=scheduleCallConference.ResAbbrev,scheduleCallConference.Color,residentMGH.full_name,scheduleCallConference.TaskAbbrev,scheduleCallConference.Sort=sort
 
     |fields=scheduleCallConference.ResAbbrev,scheduleCallConference.Color,residentMGH.full_name,scheduleCallConference.TaskAbbrev,scheduleCallConference.Sort=sort
     |where=YEAR(Date)='2024' AND scheduleCallConference.WeekNumber='{{#expr: {{#timel: W|{{Timezone}}}} - 0 }}' AND scheduleCallConference.DayNumber='5' AND NOT ResAbbrev='-' AND NOT TaskAbbrev IN ('Outs','Thoracic') AND scheduleCallConference.Date > '2024-02-02'|default={{:schtableempty}}
+
     |where=YEAR(Date)='{{#var:Friday}}' AND scheduleCallConference.WeekNumber='{{#expr: {{#timel: W|{{Timezone}}}} - 0 }}' AND scheduleCallConference.DayNumber='5' AND NOT ResAbbrev='-' AND NOT TaskAbbrev IN ('Outs','Thoracic')|default={{:schtableempty}}
 
     |format=template|order by = sort ASC|template=schtableconfcallLeft}}
 
     |format=template|order by = sort ASC|template=schtableconfcallLeft}}
 
</td>
 
</td>
 
<td style="width: 12%">
 
<td style="width: 12%">
{{#vardefine:saturdayDate|{{#time: Y-m-d|{{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=YEAR(Date)='{{#var:Saturday}}' AND scheduleFACservice.DayNumber='6' AND scheduleFACservice.WeekNumber='{{#expr: {{#timel: W|{{Timezone}}}} - 0 }}' AND scheduleFACservice.TaskAbbrev='BR1'|no html|limit=1|more results text=|order by=scheduleFACservice.Date DESC}}}}}}{{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=YEAR(Date)='{{#var:Saturday}}' AND scheduleFACservice.DayNumber='6' AND scheduleFACservice.WeekNumber='{{#expr: {{#timel: W|{{Timezone}}}} - 0 }}' AND scheduleFACservice.TaskAbbrev='BR1' AND scheduleFACservice.Date > '2024-02-01'|format=template|template=datedisplayfac|limit=1|more results text=|order by=scheduleFACservice.Date DESC}}
+
{{#vardefine:saturdayDate|{{#time: Y-m-d|{{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=YEAR(Date)='{{#var:Saturday}}' AND scheduleFACservice.DayNumber='6' AND scheduleFACservice.WeekNumber='{{#expr: {{#timel: W|{{Timezone}}}} - 0 }}' AND scheduleFACservice.TaskAbbrev='BR1'|no html|limit=1|more results text=|order by=scheduleFACservice.Date DESC}}}}}}{{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=YEAR(Date)='{{#var:Saturday}}' AND scheduleFACservice.DayNumber='6' AND scheduleFACservice.WeekNumber='{{#expr: {{#timel: W|{{Timezone}}}} - 0 }}' AND scheduleFACservice.TaskAbbrev='BR1' |format=template|template=datedisplayfac|limit=1|more results text=|order by=scheduleFACservice.Date DESC}}
 
<br>
 
<br>
 
{{#cargo_query: tables=scheduleCallConference,residentMGH  
 
{{#cargo_query: tables=scheduleCallConference,residentMGH  
 
     |join on=scheduleCallConference.ResAbbrev=residentMGH.copath_id
 
     |join on=scheduleCallConference.ResAbbrev=residentMGH.copath_id
 
     |fields=scheduleCallConference.ResAbbrev,scheduleCallConference.Color,residentMGH.full_name,scheduleCallConference.TaskAbbrev,scheduleCallConference.Sort=sort
 
     |fields=scheduleCallConference.ResAbbrev,scheduleCallConference.Color,residentMGH.full_name,scheduleCallConference.TaskAbbrev,scheduleCallConference.Sort=sort
     |where=Date='{{#var:saturdayDate}}' AND NOT ResAbbrev='-' AND scheduleCallConference.Date > '2024-02-02'|default={{:schtableempty}}
+
     |where=Date='{{#var:saturdayDate}}' AND NOT ResAbbrev='-'|default={{:schtableempty}}
 
     |format=template|order by = sort ASC|template=schtableconfcallLeft}}
 
     |format=template|order by = sort ASC|template=schtableconfcallLeft}}
 
</td>
 
</td>
 
<td style="width: 11%">
 
<td style="width: 11%">
{{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=YEAR(Date)='{{#var:Sunday}}' AND scheduleFACservice.DayNumber='7' AND scheduleFACservice.WeekNumber='{{#expr: {{#timel: W|{{Timezone}}}} - 0 }}' AND scheduleFACservice.TaskAbbrev='BR1' AND scheduleFACservice.Date > '2024-02-01'|format=template|template=datedisplayfac|limit=1|more results text=|order by=scheduleFACservice.Date DESC}}
+
{{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=YEAR(Date)='{{#var:Sunday}}' AND scheduleFACservice.DayNumber='7' AND scheduleFACservice.WeekNumber='{{#expr: {{#timel: W|{{Timezone}}}} - 0 }}' AND scheduleFACservice.TaskAbbrev='BR1' |format=template|template=datedisplayfac|limit=1|more results text=|order by=scheduleFACservice.Date DESC}}
 
<br>
 
<br>
 
{{#cargo_query: tables=scheduleCallConference,residentMGH  
 
{{#cargo_query: tables=scheduleCallConference,residentMGH  
 
     |join on=scheduleCallConference.ResAbbrev=residentMGH.copath_id
 
     |join on=scheduleCallConference.ResAbbrev=residentMGH.copath_id
 
     |fields=scheduleCallConference.ResAbbrev,scheduleCallConference.Color,residentMGH.full_name,scheduleCallConference.TaskAbbrev,scheduleCallConference.Sort=sort
 
     |fields=scheduleCallConference.ResAbbrev,scheduleCallConference.Color,residentMGH.full_name,scheduleCallConference.TaskAbbrev,scheduleCallConference.Sort=sort
     |where=YEAR(Date)='{{#var:Sunday}}' AND scheduleCallConference.WeekNumber='{{#expr: {{#timel: W|{{Timezone}}}} - 0 }}' AND scheduleCallConference.DayNumber='7' AND NOT ResAbbrev='-' AND scheduleCallConference.Date > '2024-02-02'|default={{:schtableempty}}
+
     |where=YEAR(Date)='{{#var:Sunday}}' AND scheduleCallConference.WeekNumber='{{#expr: {{#timel: W|{{Timezone}}}} - 0 }}' AND scheduleCallConference.DayNumber='7' AND NOT ResAbbrev='-'|default={{:schtableempty}}
 
     |format=template|order by = sort ASC|template=schtableconfcallLeft}}
 
     |format=template|order by = sort ASC|template=schtableconfcallLeft}}
 
</td>
 
</td>
Line 102: Line 107:
 
</td>
 
</td>
 
<td style="width: 9%">
 
<td style="width: 9%">
<table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>{{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=YEAR(Date)='{{#var:Saturday}}' AND scheduleFACservice.DayNumber='6' AND scheduleFACservice.WeekNumber='{{#expr: {{#timel: W|{{Timezone}}}} + 0 }}' AND scheduleFACservice.TaskAbbrev='BR1' AND scheduleFACservice.Date > '2024-02-01'|format=template|template=datedisplaycurrent|limit=1|more results text=|order by=scheduleFACservice.Date DESC}}</center><br></td></tr></table>
+
<table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>{{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=YEAR(Date)='{{#var:Saturday}}' AND scheduleFACservice.DayNumber='6' AND scheduleFACservice.WeekNumber='{{#expr: {{#timel: W|{{Timezone}}}} + 0 }}' AND scheduleFACservice.TaskAbbrev='BR1' |format=template|template=datedisplaycurrent|limit=1|more results text=|order by=scheduleFACservice.Date DESC}}</center><br></td></tr></table>
 
{{#arraymap:{{scheduleDictionaryAPfaculty}}|;|TaskAbbreviation|
 
{{#arraymap:{{scheduleDictionaryAPfaculty}}|;|TaskAbbreviation|
 
{{#cargo_query: table=scheduleFACservice,facultyMGH|join on=scheduleFACservice.StaffAbbrev=facultyMGH.copath_id
 
{{#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
 
|fields=GROUP_CONCAT(scheduleFACservice.StaffAbbrev),scheduleFACservice.TaskAbbrev,GROUP_CONCAT(scheduleFACservice.StaffFullName),facultyMGH.pageid
 
|group by=scheduleFACservice.Color
 
|group by=scheduleFACservice.Color
|where=Date='{{#var:saturdayDate}}' AND scheduleFACservice.TaskAbbrev='{{#explode:TaskAbbreviation|,|0}}' AND scheduleFACservice.Date > '2024-02-01'
+
|where=Date='{{#var:saturdayDate}}' AND scheduleFACservice.TaskAbbrev='{{#explode:TaskAbbreviation|,|0}}'
 
|default={{schtableempty|{{#explode:TaskAbbreviation|,|2}}}}|format=template|template=scheduleResident}}
 
|default={{schtableempty|{{#explode:TaskAbbreviation|,|2}}}}|format=template|template=scheduleResident}}
 
|}}
 
|}}
 
</td>
 
</td>
 
<td style="width: 9%">
 
<td style="width: 9%">
<table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>{{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=YEAR(Date)='{{#var:Sunday}}' AND scheduleFACservice.DayNumber='7' AND scheduleFACservice.WeekNumber='{{#expr: {{#timel: W|{{Timezone}}}} + 0 }}' AND scheduleFACservice.TaskAbbrev='BR1' AND scheduleFACservice.Date > '2024-02-01'|format=template|template=datedisplaycurrent|limit=1|more results text=|order by=scheduleFACservice.Date DESC}}</center><br></td></tr></table>
+
<table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>{{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=YEAR(Date)='{{#var:Sunday}}' AND scheduleFACservice.DayNumber='7' AND scheduleFACservice.WeekNumber='{{#expr: {{#timel: W|{{Timezone}}}} + 0 }}' AND scheduleFACservice.TaskAbbrev='BR1' |format=template|template=datedisplaycurrent|limit=1|more results text=|order by=scheduleFACservice.Date DESC}}</center><br></td></tr></table>
 
{{#arraymap:{{scheduleDictionaryAPfaculty}}|;|TaskAbbreviation|
 
{{#arraymap:{{scheduleDictionaryAPfaculty}}|;|TaskAbbreviation|
 
{{#cargo_query: table=scheduleFACservice,facultyMGH|join on=scheduleFACservice.StaffAbbrev=facultyMGH.copath_id
 
{{#cargo_query: table=scheduleFACservice,facultyMGH|join on=scheduleFACservice.StaffAbbrev=facultyMGH.copath_id
Line 139: Line 144:
 
Pager
 
Pager
 
|group by=WeekNumber
 
|group by=WeekNumber
|where=LocationAbbrev='MGH' AND Year='{{#var:MondayNW}}' AND WeekNumber='{{formatnum:{{#expr:{{#timel: W|now + 1 week}}}}}}' AND TaskAbbrev='{{#explode:TaskAbbreviation|,|0}}' AND scheduleRESservice_view.Date > '2024-02-02'|default={{schtableempty|{{#explode:TaskAbbreviation|,|2}}}}|format=template|template=scheduleResidentNew}}
+
|where=LocationAbbrev='MGH' AND Year='{{#var:MondayNW}}' AND WeekNumber='{{formatnum:{{#expr:{{#timel: W|now + 1 week}}}}}}' AND TaskAbbrev='{{#explode:TaskAbbreviation|,|0}}'|default={{schtableempty|{{#explode:TaskAbbreviation|,|2}}}}|format=template|template=scheduleResidentNew}}
 
|}}
 
|}}
 
</td>
 
</td>
Line 148: Line 153:
 
|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)='{{#var:MondayNW}}' AND scheduleFELLservice.WeekNumber='{{formatnum:{{#expr:{{#timel: W|now + 1 week}}}}}}' AND scheduleFELLservice.TaskAbbrev='{{#explode:TaskAbbreviation|,|0}}' AND scheduleFELLservice.Date > '2024-02-02'|format=template
+
|where=YEAR(Date)='{{#var:MondayNW}}' AND scheduleFELLservice.WeekNumber='{{formatnum:{{#expr:{{#timel: W|now + 1 week}}}}}}' AND scheduleFELLservice.TaskAbbrev='{{#explode:TaskAbbreviation|,|0}}' |format=template
 
|group by=scheduleFELLservice.WeekNumber|default={{schtableempty|{{#explode:TaskAbbreviation|,|2}}}}|template=scheduleResident}}
 
|group by=scheduleFELLservice.WeekNumber|default={{schtableempty|{{#explode:TaskAbbreviation|,|2}}}}|template=scheduleResident}}
 
|}}
 
|}}

Revision as of 10:41, January 10, 2025


Tweet of the week @MGHPathology

IMG 9585.jpeg


Resident weekend call schedule

 


Weekday call and conference schedule

Friday
May 08


Natalia Georgantzoglou - GEO
Gina Bortoletto - ANT
Saturday
May 09


Natalia Georgantzoglou - GEO
Federico Repetto - FXR
Sunday
May 10


Natalia Georgantzoglou - GEO
Federico Repetto - FXR

 

Monday
May 12


Samuel Bidot - SSB
Diogo Maia e Silva - DEM


Tuesday
May 13


Valentina Zanfagnin - VZA
William Mbongo - WEM
Wednesday
May 14


Samuel Bidot - SSB
Rossana Lazcano - RNS
Thursday
May 15


Joshua Tashman - JOS
Diogo Maia e Silva - DEM
Friday
May 16


Valentina Zanfagnin - VZA
Ronald Phillips - PHI
Saturday
May 17


Valentina Zanfagnin - VZA
Natalia Georgantzoglou - GEO
Sunday
May 18


Valentina Zanfagnin - VZA
Natalia Georgantzoglou - GEO

 

 



Faculty weekend call schedule

 


Integrated service schedules

Service

Service
AUT
BST
BR1
BR2
BR3
MGB CV
RP
CA
CB
CC
DP1 (0-2)
DP2 (3-5)
DP3 (6-9)
EYE
FSJ
FSS
GI1 (1-3)
GI2 (4-6)
GI3 (7-8) / (1-5)
GI4 (9-0) / (6-0)
GU1 (0-4)
GU2 (5-9)
GYL
GYS
OB
HN1 (5-9)
HN2 (0-4)
HP1 (BM)
HP2 (LN)
NP
NPAUT
PP
GR-S
AP CHIEF
Saturday
May 09

Patalas
Hung
Turashvili
Turashvili
-
-
Smith
Zhang
Zhang
Zhang
Bulterys
Bulterys
Bulterys
Stagner
-
-
Shroff
Shroff
Shroff
Shroff
Machacek
Machacek
Turashvili
Turashvili
Patalas
Fisch
Fisch
Fitzpatrick
Fitzpatrick
Oakley
-
Hung
-
-
Sunday
May 10

-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-

 

Service

Service
AUT
BST
BR1
BR2
BR3
MGB CV
RP
CA
CB
CC
DP1 (0-2)
DP2 (3-5)
DP3 (6-9)
EYE
FSJ
FSS
GI1 (1-3)
GI2 (4-6)
GI3 (7-8) / (1-5)
GI4 (9-0) / (6-0)
GU1 (0-4)
GU2 (5-9)
GYL
GYS
OB
HN1 (5-9)
HN2 (0-4)
HP1 (BM)
HP2 (LN)
NP
NPAUT
PP
GR-S
AP CHIEF
Resident

Service
RNS
PHI (D)
-
VZA
-
-
-
JEH
JOS
PDG
-
-
-
-
REN
CQC
-
-
-
-
-
-
BBK
-
-
-
-
-
-
-
-
WEM (D)
-
AUO
Fellow

Service
-
-
-
VZA
-
-
-
RUH
-
MAZ
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
EZR
-
-
-
-
Monday
May 12

Dannheim
Nielsen
Lerwill
Sgroi
OPEN
-
Avillach
Torous
Torous
Madrigal
Stagner
Foreman
-
Stagner
-
-
Shroff
Liao
-
-
Machacek
Wu
Oliva
Turashvili
-
-
Sadow
Sohani
Fitzpatrick
Frosch
-
Hung
-
-
Tuesday
May 13

Dannheim
Nielsen
Lerwill
Sgroi
OPEN
-
Avillach
Torous
Torous
Madrigal
Duncan
Foreman
-
Wolkow
-
-
Shroff
Liao
-
-
Machacek
Wu
Oliva
Turashvili
-
-
Sadow
Sohani
Fitzpatrick
Frosch
-
Hung
-
-
Wednesday
May 14

Dannheim
Nielsen
Lerwill
Sgroi
OPEN
-
Avillach
Torous
Torous
Madrigal
Duncan
Foreman
-
Stagner
-
-
Shroff
Liao
-
-
Machacek
Wu
Oliva
Turashvili
-
-
Sadow
Sohani
Fitzpatrick
Oakley
-
Hung
-
-
Thursday
May 15

Dannheim
Nielsen
Lerwill
Sgroi
OPEN
-
Avillach
Torous
Torous
Madrigal
Duncan
Foreman
-
Dryja
-
-
Shroff
Liao
-
-
Machacek
Wu
Oliva
Turashvili
-
-
Sadow
Sohani
Fitzpatrick
Oakley
-
Hung
-
-
Friday
May 16

Dannheim
Nielsen
Lerwill
Sgroi
OPEN
-
Avillach
Torous
Torous
Madrigal
-
Foreman
-
Dryja
-
-
Shroff
Liao
-
-
Machacek
Wu
Oliva
Turashvili
-
-
Sadow
Sohani
Fitzpatrick
Oakley
-
Hung
-
-