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 01


Call: Senior - DHA
Victoria Rodriguez Castellanos - VRC
Saturday
May 02


Call: Senior - DHA
Oscar Perales - OPA
Sunday
May 03


Call: Senior - DHA
Oscar Perales - OPA

 

Monday
May 05


Valentina Zanfagnin - VZA
William Mbongo - WEM


Tuesday
May 06


Bence Kovari - BKV
Brendan Barton - REN
Wednesday
May 07


Lauren Ray - LAU
Emily Hatheway Marshall - ELY
Thursday
May 08


Samuel Bidot - SSB
William Mbongo - WEM
Friday
May 09


Joshua Tashman - JOS
Brendan Barton - REN

No results

Joshua Tashman - JOS
Priscila Dias Goncalves - PDG

No results

Joshua Tashman - JOS
Priscila Dias Goncalves - PDG

 

 



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 02

Patalas
Nielsen
Ly
Ly
-
-
Smith
Ly
Ly
Ly
Moran
Moran
Moran
Stagner
-
-
Mino-Kenudson
Mino-Kenudson
Mino-Kenudson
Mino-Kenudson
Devins
Devins
Devins
Devins
Patalas
Sadow
Sadow
Fitzpatrick
Fitzpatrick
Martinez-Lage
-
Mino-Kenudson
-
-
Sunday
May 03

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

 

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
PDG
-
-
-
-
-
JOS
JEH
BBK
-
-
-
-
REN
LAU
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
WEM
-
AUO
Fellow

Service
-
-
-
-
-
-
-
-
-
RUH
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
Monday
May 05

Dannheim
Nielsen
Bossuyt
Turashvili
-
-
Avillach
Madrigal
Madrigal
Torous
-
Hoang
Foreman
Stagner
-
-
Pitman
Shroff
Glickman
Drage
Machacek
Oliva
Young
Hsu-Lin
Hsu-Lin
Alzumaili
Faquin
Ferry
Louissaint
Stemmer-Rach
-
Hariri
-
-
Tuesday
May 06

Dannheim
Nielsen
Bossuyt
Turashvili
-
-
Avillach
Madrigal
Madrigal
Torous
-
Hoang
Foreman
Wolkow
-
-
Pitman
Shroff
Glickman
Drage
Machacek
Oliva
Young
Hsu-Lin
Hsu-Lin
Alzumaili
Faquin
Ferry
Louissaint
Stemmer-Rach
-
Hariri
-
-
Wednesday
May 07

Dannheim
Nielsen
Bossuyt
Turashvili
-
-
Avillach
Madrigal
Madrigal
Torous
-
Hoang
Foreman
Stagner
-
-
Pitman
Shroff
Glickman
Drage
Machacek
Oliva
Young
Hsu-Lin
Hsu-Lin
Alzumaili
Faquin
Ferry
Louissaint
Stemmer-Rach
-
Hariri
-
-
Thursday
May 08

Dannheim
Nielsen
Bossuyt
Turashvili
-
-
Avillach
Madrigal
Madrigal
Torous
-
Stagner
Foreman
Stagner
-
-
Pitman
Shroff
Glickman
Drage
Machacek
Oliva
Young
Hsu-Lin
Hsu-Lin
Alzumaili
Fisch
Ferry
Louissaint
Stemmer-Rach
-
Hariri
-
-
Friday
May 09

Dannheim
Nielsen
Bossuyt
Turashvili
-
-
Avillach
Madrigal
Madrigal
Torous
-
Stagner
Foreman
Stagner
-
-
Mino-Kenudson
Shroff
Glickman
Drage
Machacek
Oliva
Young
Hsu-Lin
Hsu-Lin
Alzumaili
Fisch
Ferry
Louissaint
Stemmer-Rach
-
Hariri
-
-