View source for learn:scheduleCurrentWeek

{{varScheduleYear}}{{#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}}}}}}
{{header|Call & conference|}}<br>
<table class='table borderless'>
<tr>
<td style="width: 14%">
{{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=YEAR(Date)='{{#var:Monday}}' AND scheduleFACservice.DayNumber='1' AND scheduleFACservice.WeekNumber='{{formatnum:{{#expr:{{#timel: W|now - 0 weeks}} }} }}' AND scheduleFACservice.TaskAbbrev='BR1' |format=template|template=datedisplayfac|limit=1|more results text=|order by=scheduleFACservice.Date DESC}}
</td>
<td style="width: 14%">
{{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=YEAR(Date)='{{#var:Tuesday}}' AND scheduleFACservice.DayNumber='2' 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}}
</td>
<td style="width: 14%">
{{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=YEAR(Date)='{{#var:Wednesday}}' AND scheduleFACservice.DayNumber='3' 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}}
</td>
<td style="width: 14%">
{{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=YEAR(Date)='{{#var:Thursday}}' AND scheduleFACservice.DayNumber='4' 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}}
</td>
<td style="width: 14%">
{{#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=|order by=scheduleFACservice.Date DESC}}
</td>
<td style="width: 14%">
{{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=Date='{{#var:saturdayDate}}' AND scheduleFACservice.TaskAbbrev='BR1' |format=template|template=datedisplayfac|limit=1|more results text=|order by=scheduleFACservice.Date DESC}}
</td>
<td style="width: 14%">
{{#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}}
</td>
</tr>
<tr>
<td style="width: 14%">
{{#cargo_query: tables=scheduleCallConference,residentMGH 
    |join on=scheduleCallConference.ResAbbrev=residentMGH.copath_id
    |fields=scheduleCallConference.ResAbbrev,scheduleCallConference.Color,residentMGH.full_name,scheduleCallConference.TaskAbbrev,scheduleCallConference.Sort=sort
    |where=YEAR(Date)='{{#var:Monday}}' AND scheduleCallConference.WeekNumber='{{#expr: {{#timel: W|{{Timezone}}}} - 0 }}' AND scheduleCallConference.DayNumber='1' AND NOT ResAbbrev='-' AND NOT TaskAbbrev IN ('Call: Autopsy', 'Call: Junior CP', 'Call: BB/CP', 'HP Journal Club', 'Outs')|default=
    |format=template|order by = sort ASC|template=schtableconfcallLeft}}
{{#cargo_query: tables= conferenceMPR,residentMGH |join on=conferenceMPR.ResAbbrev=residentMGH.copath_id |fields=conferenceMPR.ResAbbrev,conferenceMPR.Color,residentMGH.full_name,conferenceMPR.TaskAbbrev |where=YEAR(conferenceMPR.Date)='{{#timel: Y|now}}' AND conferenceMPR.WeekNumber='{{#expr: {{#timel: W|now}} - 1 }}' AND NOT TaskAbbrev='Outs'|default= |format=template|template=schtableconfcallLeft}}
{{#cargo_query: tables=scheduleCallConference
    |fields=
scheduleCallConference.ResAbbrev,
scheduleCallConference.Color,
scheduleCallConference.Hour,
scheduleCallConference.TaskAbbrev,
scheduleCallConference.Sort,
scheduleCallConference.Notes
    |where=YEAR(Date)='{{#var:Friday}}' AND scheduleCallConference.WeekNumber='{{#expr: {{#timel: W|{{Timezone}}}} - 0 }}' AND scheduleCallConference.DayNumber='1' AND NOT ResAbbrev='-' AND TaskAbbrev='Outs'|default=
    |format=template|order by = Sort ASC|template=schtableconfcallLeftOuts}}
</td>
<td style="width: 14%">
{{#cargo_query: tables=scheduleCallConference,residentMGH 
    |join on=scheduleCallConference.ResAbbrev=residentMGH.copath_id
    |fields=scheduleCallConference.ResAbbrev,scheduleCallConference.Color,residentMGH.full_name,scheduleCallConference.TaskAbbrev,scheduleCallConference.Sort=sort
    |where=YEAR(Date)='{{#var:Tuesday}}' AND scheduleCallConference.WeekNumber='{{#expr: {{#timel: W|{{Timezone}}}} - 0 }}' AND scheduleCallConference.DayNumber='2' AND NOT ResAbbrev='-' AND NOT TaskAbbrev='Outs'|default=
    |format=template|order by = Sort ASC|template=schtableconfcallLeft}}
{{#cargo_query: tables=scheduleCallConference
    |fields=
scheduleCallConference.ResAbbrev,
scheduleCallConference.Color,
scheduleCallConference.Hour,
scheduleCallConference.TaskAbbrev,
scheduleCallConference.Sort,
scheduleCallConference.Notes
    |where=YEAR(Date)='{{#var:Friday}}' AND scheduleCallConference.WeekNumber='{{#expr: {{#timel: W|{{Timezone}}}} - 0 }}' AND scheduleCallConference.DayNumber='2' AND NOT ResAbbrev='-' AND TaskAbbrev='Outs'|default=
    |format=template|order by = Sort ASC|template=schtableconfcallLeftOuts}}
</td>
<td style="width: 14%">
{{#cargo_query: tables=scheduleCallConference,residentMGH 
    |join on=scheduleCallConference.ResAbbrev=residentMGH.copath_id
    |fields=scheduleCallConference.ResAbbrev,scheduleCallConference.Color,residentMGH.full_name,scheduleCallConference.TaskAbbrev,scheduleCallConference.Sort=sort
    |where=YEAR(Date)='{{#var:Wednesday}}' AND scheduleCallConference.WeekNumber='{{#expr: {{#timel: W|{{Timezone}}}} - 0 }}' AND scheduleCallConference.DayNumber='3' AND NOT ResAbbrev='-' AND NOT TaskAbbrev='Outs'|default=
    |format=template|order by = Sort ASC|template=schtableconfcallLeft}}
{{#cargo_query: tables=scheduleCallConference
    |fields=
scheduleCallConference.ResAbbrev,
scheduleCallConference.Color,
scheduleCallConference.Hour,
scheduleCallConference.TaskAbbrev,
scheduleCallConference.Sort,
scheduleCallConference.Notes
    |where=YEAR(Date)='{{#var:Friday}}' AND scheduleCallConference.WeekNumber='{{#expr: {{#timel: W|{{Timezone}}}} - 0 }}' AND scheduleCallConference.DayNumber='3' AND NOT ResAbbrev='-' AND TaskAbbrev='Outs'|default=
    |format=template|order by = Sort ASC|template=schtableconfcallLeftOuts}}
</td>
<td style="width: 14%">
{{#cargo_query: tables=scheduleCallConference,residentMGH 
    |join on=scheduleCallConference.ResAbbrev=residentMGH.copath_id
    |fields=scheduleCallConference.ResAbbrev,scheduleCallConference.Color,residentMGH.full_name,scheduleCallConference.TaskAbbrev,scheduleCallConference.Sort=sort
    |where=YEAR(Date)='{{#var:Thursday}}' AND scheduleCallConference.WeekNumber='{{#expr: {{#timel: W|{{Timezone}}}} - 0 }}' AND scheduleCallConference.DayNumber='4' AND NOT ResAbbrev='-' AND NOT TaskAbbrev='Outs'|default=
    |format=template|order by = Sort ASC|template=schtableconfcallLeft}}
{{#cargo_query: tables=scheduleCallConference
    |fields=
scheduleCallConference.ResAbbrev,
scheduleCallConference.Color,
scheduleCallConference.Hour,
scheduleCallConference.TaskAbbrev,
scheduleCallConference.Sort,
scheduleCallConference.Notes
    |where=YEAR(Date)='{{#var:Friday}}' AND scheduleCallConference.WeekNumber='{{#expr: {{#timel: W|{{Timezone}}}} - 0 }}' AND scheduleCallConference.DayNumber='4' AND NOT ResAbbrev='-' AND TaskAbbrev='Outs'|default=
    |format=template|order by = Sort ASC|template=schtableconfcallLeftOuts}}
</td>
<td style="width: 14%">
{{#cargo_query: tables=scheduleCallConference,residentMGH 
    |join on=scheduleCallConference.ResAbbrev=residentMGH.copath_id
    |fields=
scheduleCallConference.ResAbbrev,
scheduleCallConference.Color,
residentMGH.full_name,
scheduleCallConference.TaskAbbrev,
scheduleCallConference.Sort
    |where=YEAR(Date)='{{#var:Friday}}' AND scheduleCallConference.WeekNumber='{{#expr: {{#timel: W|{{Timezone}}}} - 0 }}' AND scheduleCallConference.DayNumber='5' AND NOT ResAbbrev='-' AND NOT TaskAbbrev='Outs'|default=
    |format=template|order by = Sort ASC|template=schtableconfcallLeft}}
{{#cargo_query: tables=scheduleCallConference
    |fields=
scheduleCallConference.ResAbbrev,
scheduleCallConference.Color,
scheduleCallConference.Hour,
scheduleCallConference.TaskAbbrev,
scheduleCallConference.Sort,
scheduleCallConference.Notes
    |where=YEAR(Date)='{{#var:Friday}}' AND scheduleCallConference.WeekNumber='{{#expr: {{#timel: W|{{Timezone}}}} - 0 }}' AND scheduleCallConference.DayNumber='5' AND NOT ResAbbrev='-' AND TaskAbbrev='Outs'|default=
    |format=template|order by = Sort ASC|template=schtableconfcallLeftOuts}}
</td>
<td style="width: 14%">
{{#cargo_query: tables=scheduleCallConference,residentMGH 
    |join on=scheduleCallConference.ResAbbrev=residentMGH.copath_id
    |fields=scheduleCallConference.ResAbbrev,scheduleCallConference.Color,residentMGH.full_name,scheduleCallConference.TaskAbbrev,scheduleCallConference.Sort=sort
    |where=Date='{{#var:saturdayDate}}' AND NOT ResAbbrev='-'|default=
    |format=template|order by = sort ASC|template=schtableconfcallLeft}}
</td>
<td style="width: 14%">
{{#cargo_query: tables=scheduleCallConference,residentMGH 
    |join on=scheduleCallConference.ResAbbrev=residentMGH.copath_id
    |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='-'|default=
    |format=template|order by = sort ASC|template=schtableconfcallLeft}}
</td>
</tr>
</table>
<br>
{{header|Service schedule - anatomic pathology (AMP)}}
<br>
<table class='table borderless'>
<tr>
<td colspan="1">
&nbsp;
</td>
<td colspan="1">
&nbsp;
</td>
<td colspan="2">
<center>'''Monday to<br>Friday'''</center>
<td colspan="1">
&nbsp;
</td>
<td class='align-bottom' colspan="1">
<center>{{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=YEAR(Date)='{{#var:Monday}}' AND scheduleFACservice.DayNumber='1' 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}}<p></p></center>
</td>
<td class='align-bottom' colspan="1">
<center>{{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=YEAR(Date)='{{#var:Tuesday}}' AND scheduleFACservice.DayNumber='2' 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}}<p></p></center>
</td>
<td class='align-bottom' colspan="1">
<center>{{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=YEAR(Date)='{{#var:Wednesday}}' AND scheduleFACservice.DayNumber='3' 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}}<p></p></center>
</td>
<td class='align-bottom' colspan="1">
<center>{{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=YEAR(Date)='{{#var:Thursday}}' AND scheduleFACservice.DayNumber='4' 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}}<p></p></center>
</td>
<td colspan="1">
<center>{{#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=datedisplaycurrent|limit=1|more results text=|order by=scheduleFACservice.Date DESC}}<p></p></center>
</td>
<td colspan="1">
<center>{{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=Date='{{#var:saturdayDate}}' AND scheduleFACservice.TaskAbbrev='BR1' |format=template|template=datedisplaycurrent|limit=1|more results text=|order by=scheduleFACservice.Date DESC}}<p></p></center>
</td>
<td colspan="1">
<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}}<p></p></center>
</td>
<td colspan="1">
<center>[[onCallAMPrules|'''{{ColorText|{{#tip-text:Attending on call|
{{:onCallAMPrules}}
}}||#000000|}}''']]
</center>
</td>
</tr>
<tr>
<td style="width: 10%">
<table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>{{ColorText|'''Service'''||#000000|}}</center></td></tr></table>
{{:scheduleDictionaryAP}}
</td>
<td style="width: 1%">
&nbsp;
</td>      
<td style="width: 9%">
<table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>'''{{ColorText|{{#tip-text:Resident|Resident}}||#000000|}}'''</center></td></tr></table>
{{#arraymap:{{scheduleDictionaryAPresident}}|;|TaskAbbreviation|
{{#cargo_query: tables=scheduleRESservice,residentMGH,scheduleRESserviceElective_view 
|join on=scheduleRESservice.ResAbbrev=residentMGH.copath_id,scheduleRESservice.UID=scheduleRESserviceElective_view.UID
|fields=GROUP_CONCAT(DISTINCT scheduleRESservice.ResAbbrev),scheduleRESserviceElective_view.TaskAbbrev,GROUP_CONCAT(DISTINCT residentMGH.full_name),scheduleRESserviceElective_view.Elective
|group by=scheduleRESservice.WeekNumber
|where=YEAR(Date)={{#timel: Y|{{Timezone}}}} AND scheduleRESservice.WeekNumber='{{#expr: {{#timel: W|{{Timezone}}}} - 0 }}' AND scheduleRESserviceElective_view.TaskAbbrev='{{#explode:TaskAbbreviation|,|0}}'|default={{schtableempty|{{#explode:TaskAbbreviation|,|2}}}}|format=template|template=scheduleResident}}
|}}
</td>
<td style="width: 9%">
<table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>'''{{ColorText|{{#tip-text:Fellow|Fellow / Elective-Resident}}||#000000|}}'''</center></td></tr></table>
{{#arraymap:{{scheduleDictionaryAPresident}}|;|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=scheduleResident}}
|}}
</td>
<td style="width: 1%">
&nbsp;
</td>
<td style="width: 10%">
<table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>'''{{ColorText|{{#tip-text:A|Attending}}||#000000|}}'''</center></td></tr></table>
{{#arraymap:{{scheduleDictionaryAPfaculty}}|;|TaskAbbreviation|
{{#cargo_query: table=scheduleFACservice 
|fields=scheduleFACservice.StaffAbbrev,scheduleFACservice.TaskAbbrev,scheduleFACservice.StaffFullName
|group by=scheduleFACservice.Color
|where=YEAR(Date)='{{#var:Monday}}' AND scheduleFACservice.TaskAbbrev='{{#explode:TaskAbbreviation|,|0}}' AND scheduleFACservice.DayNumber='1' AND scheduleFACservice.WeekNumber='{{#expr: {{#timel: W|{{Timezone}}}} - 0}}'
|default={{schtableempty|{{#explode:TaskAbbreviation|,|2}}}}|format=template|template={{#switch:{{#timel: N|now }}|1=scheduleFacultyOnCall|scheduleFaculty}}}}
|}}
</td>
<td style="width: 10%">
<table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>'''{{ColorText|{{#tip-text:A|Attending}}||#000000|}}'''</center></td></tr></table>
{{#arraymap:{{scheduleDictionaryAPfaculty}}|;|TaskAbbreviation|
{{#cargo_query: table=scheduleFACservice 
|fields=scheduleFACservice.StaffAbbrev,scheduleFACservice.TaskAbbrev,scheduleFACservice.StaffFullName||limit=1|more results text=
|group by=scheduleFACservice.Color|where=YEAR(Date)='{{#var:Tuesday}}' AND scheduleFACservice.TaskAbbrev='{{#explode:TaskAbbreviation|,|0}}' AND scheduleFACservice.DayNumber='2' AND scheduleFACservice.WeekNumber='{{#expr: {{#timel: W|{{Timezone}}}} - 0}}'
|default={{schtableempty|{{#explode:TaskAbbreviation|,|2}}}}|format=template|template={{#switch:{{#timel: N|now }}|2=scheduleFacultyOnCall|scheduleFaculty}}}}
|}}
</td>
<td style="width: 10%">
<table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>'''{{ColorText|{{#tip-text:A|Attending}}||#000000|}}'''</center></td></tr></table>
{{#arraymap:{{scheduleDictionaryAPfaculty}}|;|TaskAbbreviation|
{{#cargo_query: table=scheduleFACservice 
|fields=scheduleFACservice.StaffAbbrev,scheduleFACservice.TaskAbbrev,scheduleFACservice.StaffFullName||limit=1|more results text=
|group by=scheduleFACservice.Color
|where=YEAR(Date)='{{#var:Wednesday}}' AND scheduleFACservice.TaskAbbrev='{{#explode:TaskAbbreviation|,|0}}' AND scheduleFACservice.DayNumber='3' AND scheduleFACservice.WeekNumber='{{#expr: {{#timel: W|{{Timezone}}}} - 0}}'
|default={{schtableempty|{{#explode:TaskAbbreviation|,|2}}}}|format=template|template={{#switch:{{#timel: N|now }}|3=scheduleFacultyOnCall|scheduleFaculty}}}}
|}}
</td>
<td style="width: 10%">
<table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>'''{{ColorText|{{#tip-text:A|Attending}}||#000000|}}'''</center></td></tr></table>
{{#arraymap:{{scheduleDictionaryAPfaculty}}|;|TaskAbbreviation|
{{#cargo_query: table=scheduleFACservice 
|fields=scheduleFACservice.StaffAbbrev,scheduleFACservice.TaskAbbrev,scheduleFACservice.StaffFullName||limit=1|more results text=
|group by=scheduleFACservice.Color
|where=YEAR(Date)='{{#var:Thursday}}' AND scheduleFACservice.TaskAbbrev='{{#explode:TaskAbbreviation|,|0}}' AND scheduleFACservice.DayNumber='4' AND scheduleFACservice.WeekNumber='{{#expr: {{#timel: W|{{Timezone}}}} - 0}}'
|default={{schtableempty|{{#explode:TaskAbbreviation|,|2}}}}|format=template|template={{#switch:{{#timel: N|now }}|4=scheduleFacultyOnCall|scheduleFaculty}}}}
|}}
</td>
<td style="width: 10%">
<table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>'''{{ColorText|{{#tip-text:A|Attending}}||#000000|}}'''</center></td></tr></table>
{{#arraymap:{{scheduleDictionaryAPfaculty}}|;|TaskAbbreviation|
{{#cargo_query: table=scheduleFACservice 
|fields=scheduleFACservice.StaffAbbrev,scheduleFACservice.TaskAbbrev,scheduleFACservice.StaffFullName||limit=1|more results text=
|group by=scheduleFACservice.Color
|where=YEAR(Date)='{{#var:Friday}}' AND scheduleFACservice.TaskAbbrev='{{#explode:TaskAbbreviation|,|0}}' AND scheduleFACservice.DayNumber='5' AND scheduleFACservice.WeekNumber='{{#expr: {{#timel: W|{{Timezone}}}} - 0}}'
|default={{schtableempty|{{#explode:TaskAbbreviation|,|2}}}}|format=template|template={{#switch:{{#timel: N|now }}|5=scheduleFacultyOnCall|scheduleFaculty}}}}
|}}
</td>
<td style="width: 10%">
<table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>'''{{ColorText|{{#tip-text:A|Attending}}||#000000|}}'''</center></td></tr></table>
{{#arraymap:{{scheduleDictionaryAPfaculty}}|;|TaskAbbreviation|
{{#cargo_query: table=scheduleFACservice 
|fields=scheduleFACservice.StaffAbbrev,scheduleFACservice.TaskAbbrev,scheduleFACservice.StaffFullName|limit=1|more results text=
|group by=scheduleFACservice.Color|order by=scheduleFACservice.Date DESC
|where=Date='{{#var:saturdayDate}}' AND scheduleFACservice.TaskAbbrev='{{#explode:TaskAbbreviation|,|0}}' 
|default={{schtableempty|{{#explode:TaskAbbreviation|,|2}}}}|format=template|template={{#switch:{{#timel: N|now }}|6=scheduleFacultyOnCall|scheduleFaculty}}}}
|}}
</td>
<td style="width: 10%">
<table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>'''{{ColorText|{{#tip-text:A|Attending}}||#000000|}}'''</center></td></tr></table>
{{#arraymap:{{scheduleDictionaryAPfaculty}}|;|TaskAbbreviation|
{{#cargo_query: table=scheduleFACservice 
|fields=scheduleFACservice.StaffAbbrev,scheduleFACservice.TaskAbbrev,scheduleFACservice.StaffFullName||limit=1|more results text=
|group by=scheduleFACservice.Color
|where=YEAR(Date)='{{#var:Sunday}}' AND scheduleFACservice.TaskAbbrev='{{#explode:TaskAbbreviation|,|0}}' AND scheduleFACservice.DayNumber='7' AND scheduleFACservice.WeekNumber='{{#expr: {{#timel: W|{{Timezone}}}} - 0}}'
|default={{schtableempty|{{#explode:TaskAbbreviation|,|2}}}}|format=template|template={{#switch:{{#timel: N|now }}|7=scheduleFacultyOnCall|scheduleFaculty}}}}
|}}
</td>
<td style="width: 10%">
<table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>'''{{ColorText|{{#tip-text:A|Attending}}||#000000|}}'''</center></td></tr></table>
{{:learn:oncallAMP}}
</td>
</tr>
</table>
<br>
{{header|Service schedule - clinical pathology (LMM)}}
<br>
<table class='table borderless'>
<tr>
<td colspan="1">
&nbsp;
</td>
<td colspan="1">
&nbsp;
</td>
<td colspan="2">
<center>'''Monday to<br>Friday'''</center>
<td colspan="1">
&nbsp;
</td>
<td class='align-bottom' colspan="1">
<center>{{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=YEAR(Date)='{{#var:Monday}}' AND scheduleFACservice.DayNumber='1' 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}}<p></p></center>
</td>
<td class='align-bottom' colspan="1">
<center>{{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=YEAR(Date)='{{#var:Tuesday}}' AND scheduleFACservice.DayNumber='2' 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}}<p></p></center>
</td>
<td class='align-bottom' colspan="1">
<center>{{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=YEAR(Date)='{{#var:Wednesday}}' AND scheduleFACservice.DayNumber='3' 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}}<p></p></center>
</td>
<td class='align-bottom' colspan="1">
<center>{{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=YEAR(Date)='{{#var:Thursday}}' AND scheduleFACservice.DayNumber='4' 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}}<p></p></center>
</td>
<td colspan="1">
<center>{{#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=datedisplaycurrent|limit=1|more results text=|order by=scheduleFACservice.Date DESC}}<p></p></center>
</td>
<td colspan="1">
<center>{{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=Date='{{#var:saturdayDate}}' AND scheduleFACservice.TaskAbbrev='BR1' |format=template|template=datedisplaycurrent|limit=1|more results text=|order by=scheduleFACservice.Date DESC}}<p></p></center>
</td>
<td colspan="1">
<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}}<p></p></center>
</td>
<td colspan="1">
<center>'''Attending<br>on call'''</center>
</td>
</tr>
<tr>
<td style="width: 10%">
<table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>{{ColorText|'''Service'''||#000000|}}</center></td></tr></table>
{{:scheduleDictionaryCP}}
</td>
<td style="width: 1%">
&nbsp;
</td>      
<td style="width: 9%">
<table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>'''{{ColorText|{{#tip-text:Resident|Resident}}||#000000|}}'''</center></td></tr></table>
{{#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)
|group by=scheduleRESservice.WeekNumber
|where=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: 9%">
<table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>'''{{ColorText|{{#tip-text:Fellow|Fellow / Elective-Resident}}||#000000|}}'''</center></td></tr></table>
{{#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: 1%">
&nbsp;
</td>
<td style="width: 10%">
<table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>'''{{ColorText|{{#tip-text:A|Attending}}||#000000|}}'''</center></td></tr></table>
{{#arraymap:{{scheduleDictionaryCPfaculty}}|;|TaskAbbreviation|
{{#cargo_query: table=scheduleFACservice 
|fields=scheduleFACservice.StaffAbbrev,scheduleFACservice.TaskAbbrev,scheduleFACservice.StaffFullName||limit=1|more results text=
|group by=scheduleFACservice.Color
|where=YEAR(Date)='{{#var:Monday}}' AND scheduleFACservice.TaskAbbrev='{{#explode:TaskAbbreviation|,|0}}' AND scheduleFACservice.DayNumber='1' AND scheduleFACservice.WeekNumber='{{#expr: {{#timel: W|{{Timezone}}}} - 0}}'
|default={{schtableempty|{{#explode:TaskAbbreviation|,|2}}}}|format=template|template=scheduleResidentCPfaculty}}
|}}
{{scheduleImmunoException}}
</td>
<td style="width: 10%">
<table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>'''{{ColorText|{{#tip-text:A|Attending}}||#000000|}}'''</center></td></tr></table>
{{#arraymap:{{scheduleDictionaryCPfaculty}}|;|TaskAbbreviation|
{{#cargo_query: table=scheduleFACservice 
|fields=scheduleFACservice.StaffAbbrev,scheduleFACservice.TaskAbbrev,scheduleFACservice.StaffFullName||limit=1|more results text=
|group by=scheduleFACservice.Color|where=YEAR(Date)='{{#var:Tuesday}}' AND scheduleFACservice.TaskAbbrev='{{#explode:TaskAbbreviation|,|0}}' AND scheduleFACservice.DayNumber='2' AND scheduleFACservice.WeekNumber='{{#expr: {{#timel: W|{{Timezone}}}} - 0}}'
|default={{schtableempty|{{#explode:TaskAbbreviation|,|2}}}}|format=template|template=scheduleResidentCPfaculty}}
|}}
{{scheduleImmunoException}}
</td>
<td style="width: 10%">
<table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>'''{{ColorText|{{#tip-text:A|Attending}}||#000000|}}'''</center></td></tr></table>
{{#arraymap:{{scheduleDictionaryCPfaculty}}|;|TaskAbbreviation|
{{#cargo_query: table=scheduleFACservice 
|fields=scheduleFACservice.StaffAbbrev,scheduleFACservice.TaskAbbrev,scheduleFACservice.StaffFullName||limit=1|more results text=
|group by=scheduleFACservice.Color
|where=YEAR(Date)='{{#var:Wednesday}}' AND scheduleFACservice.TaskAbbrev='{{#explode:TaskAbbreviation|,|0}}' AND scheduleFACservice.DayNumber='3' AND scheduleFACservice.WeekNumber='{{#expr: {{#timel: W|{{Timezone}}}} - 0}}'
|default={{schtableempty|{{#explode:TaskAbbreviation|,|2}}}}|format=template|template=scheduleResidentCPfaculty}}
|}}
{{scheduleImmunoException}}
</td>
<td style="width: 10%">
<table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>'''{{ColorText|{{#tip-text:A|Attending}}||#000000|}}'''</center></td></tr></table>
{{#arraymap:{{scheduleDictionaryCPfaculty}}|;|TaskAbbreviation|
{{#cargo_query: table=scheduleFACservice 
|fields=scheduleFACservice.StaffAbbrev,scheduleFACservice.TaskAbbrev,scheduleFACservice.StaffFullName||limit=1|more results text=
|group by=scheduleFACservice.Color
|where=YEAR(Date)='{{#var:Thursday}}' AND scheduleFACservice.TaskAbbrev='{{#explode:TaskAbbreviation|,|0}}' AND scheduleFACservice.DayNumber='4' AND scheduleFACservice.WeekNumber='{{#expr: {{#timel: W|{{Timezone}}}} - 0}}'
|default={{schtableempty|{{#explode:TaskAbbreviation|,|2}}}}|format=template|template=scheduleResidentCPfaculty}}
|}}
{{scheduleImmunoException}}
</td>
<td style="width: 10%">
<table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>'''{{ColorText|{{#tip-text:A|Attending}}||#000000|}}'''</center></td></tr></table>
{{#arraymap:{{scheduleDictionaryCPfaculty}}|;|TaskAbbreviation|
{{#cargo_query: table=scheduleFACservice 
|fields=scheduleFACservice.StaffAbbrev,scheduleFACservice.TaskAbbrev,scheduleFACservice.StaffFullName||limit=1|more results text=
|group by=scheduleFACservice.Color
|where=YEAR(Date)='{{#var:Friday}}' AND scheduleFACservice.TaskAbbrev='{{#explode:TaskAbbreviation|,|0}}' AND scheduleFACservice.DayNumber='5' AND scheduleFACservice.WeekNumber='{{#expr: {{#timel: W|{{Timezone}}}} - 0}}'
|default={{schtableempty|{{#explode:TaskAbbreviation|,|2}}}}|format=template|template=scheduleResidentCPfaculty}}
|}}
{{scheduleImmunoException}}
</td>
<td style="width: 10%">
<table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>'''{{ColorText|{{#tip-text:A|Attending}}||#000000|}}'''</center></td></tr></table>
{{#arraymap:{{scheduleDictionaryCPfaculty}}|;|TaskAbbreviation|
{{#cargo_query: table=scheduleFACservice 
|fields=scheduleFACservice.StaffAbbrev,scheduleFACservice.TaskAbbrev,scheduleFACservice.StaffFullName||limit=1|more results text=
|group by=scheduleFACservice.Color
|where=Date='{{#var:saturdayDate}}' AND scheduleFACservice.TaskAbbrev='{{#explode:TaskAbbreviation|,|0}}' 
|default={{schtableempty|{{#explode:TaskAbbreviation|,|2}}}}|format=template|template=scheduleResidentCPfaculty}}
|}}
{{scheduleImmunoException}}
</td>
<td style="width: 10%">
<table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>'''{{ColorText|{{#tip-text:A|Attending}}||#000000|}}'''</center></td></tr></table>
{{#arraymap:{{scheduleDictionaryCPfaculty}}|;|TaskAbbreviation|
{{#cargo_query: table=scheduleFACservice 
|fields=scheduleFACservice.StaffAbbrev,scheduleFACservice.TaskAbbrev,scheduleFACservice.StaffFullName||limit=1|more results text=
|group by=scheduleFACservice.Color
|where=YEAR(Date)='{{#var:Sunday}}' AND scheduleFACservice.TaskAbbrev='{{#explode:TaskAbbreviation|,|0}}' AND scheduleFACservice.DayNumber='7' AND scheduleFACservice.WeekNumber='{{#expr: {{#timel: W|{{Timezone}}}} - 0}}'
|default={{schtableempty|{{#explode:TaskAbbreviation|,|2}}}}|format=template|template=scheduleResidentCPfaculty}}
|}}
{{scheduleImmunoException}}
</td>
<td style="width: 10%">
<table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>'''{{ColorText|{{#tip-text:A|Attending}}||#000000|}}'''</center></td></tr></table>
{{:learn:oncallfaculty}}
</td>
</tr>
</table>