Difference between revisions of "scheduleNow"

From MGH Learn Pathology
Line 1: Line 1:
−
{{varScheduleYear}}
+
__NOCACHE__<table class="table borderless">
−
{{header|Call & conference|}}<br>
+
<tr><td bgcolor="#f0f0f0" colspan="5"><center>'''{{ColorText|Anatomic pathology (AMP)|||4}}'''</center></td></tr>
−
<table class='table borderless'>
 
 
<tr>
 
<tr>
−
<td style="width: 14%">
+
<td style="width: 20%">
−
{{#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}}
+
<table class='scheduletable'><tr><td bgcolor="#f5f5f5"><center>{{ColorText|'''Service'''||#000000|}}</center></td></tr></table>
−
</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}}
 
−
</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}}
 
−
</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}}
 
−
</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}}
 
−
</td>
 
−
<td style="width: 14%">
 
−
{{#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}}
 
−
</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}}
 
−
</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')|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,facultyMGH
 
−
    |join on=scheduleCallConference.ResAbbrev=facultyMGH.copath_id
 
−
    |fields=
 
−
scheduleCallConference.ResAbbrev,
 
−
scheduleCallConference.Color,
 
−
facultyMGH.fullname,
 
−
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: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,facultyMGH
 
−
    |join on=scheduleCallConference.ResAbbrev=facultyMGH.copath_id
 
−
    |fields=
 
−
scheduleCallConference.ResAbbrev,
 
−
scheduleCallConference.Color,
 
−
facultyMGH.fullname,
 
−
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,facultyMGH
 
−
    |join on=scheduleCallConference.ResAbbrev=facultyMGH.copath_id
 
−
    |fields=
 
−
scheduleCallConference.ResAbbrev,
 
−
scheduleCallConference.Color,
 
−
facultyMGH.fullname,
 
−
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,facultyMGH
 
−
    |join on=scheduleCallConference.ResAbbrev=facultyMGH.copath_id
 
−
    |fields=
 
−
scheduleCallConference.ResAbbrev,
 
−
scheduleCallConference.Color,
 
−
facultyMGH.fullname,
 
−
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,facultyMGH
 
−
    |join on=scheduleCallConference.ResAbbrev=facultyMGH.copath_id
 
−
    |fields=
 
−
scheduleCallConference.ResAbbrev,
 
−
scheduleCallConference.Color,
 
−
facultyMGH.fullname,
 
−
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=YEAR(Date)='{{#var:Saturday}}' AND scheduleCallConference.WeekNumber='{{#expr: {{#timel: W|{{Timezone}}}} - 0 }}' AND scheduleCallConference.DayNumber='6' 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}}<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}}<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}}<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}}<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}}<p></p></center>
 
−
</td>
 
−
<td colspan="1">
 
−
<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}}<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}}<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}}
 
{{:scheduleDictionaryAP}}
 
</td>
 
</td>
−
<td style="width: 1%">
+
<td style="width: 20%">
−
&nbsp;
+
<table class='scheduletable'><tr><td bgcolor="#f5f5f5"><center>'''{{ColorText|{{#tip-text:Resident|Resident}}||#000000|}}'''</center></td></tr></table>
−
</td>     
+
{{#switch: {{#time: N|{{Timezone}}}}
−
<td style="width: 9%">
+
|6
−
<table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>'''{{ColorText|{{#tip-text:Resident|Resident}}||#000000|}}'''</center></td></tr></table>
+
|7=
−
{{#arraymap:{{scheduleDictionaryAPresident}}|;|TaskAbbreviation|
+
{{:scheduleDictionaryAPempty}}
 +
|{{#arraymap:{{scheduleDictionaryAPresident}}|;|TaskAbbreviation|
 
{{#cargo_query: tables=scheduleRESservice,residentMGH  
 
{{#cargo_query: tables=scheduleRESservice,residentMGH  
 
|join on=scheduleRESservice.ResAbbrev=residentMGH.copath_id
 
|join on=scheduleRESservice.ResAbbrev=residentMGH.copath_id
−
|fields=GROUP_CONCAT(DISTINCT scheduleRESservice.ResAbbrev),scheduleRESservice.TaskAbbrev,GROUP_CONCAT(DISTINCT residentMGH.full_name)
+
|fields=
 +
GROUP_CONCAT(DISTINCT scheduleRESservice.ResAbbrev)
 +
,scheduleRESservice.TaskAbbrev
 +
,GROUP_CONCAT(DISTINCT residentMGH.full_name)
 +
,pageid
 
|group by=scheduleRESservice.WeekNumber
 
|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=scheduleResident}}
+
|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}}
 
|}}
 
|}}
 +
}}
 
</td>
 
</td>
−
<td style="width: 9%">
+
<td style="width: 20%">
−
<table class='scheduletable'><tr><td bgcolor="#FFFFFF"><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>
−
{{#arraymap:{{scheduleDictionaryAPresident}}|;|TaskAbbreviation|
+
{{#switch: {{#time: N|{{Timezone}}}}
 +
|6
 +
|7=
 +
{{:scheduleDictionaryAPempty}}
 +
|{{#arraymap:{{scheduleDictionaryAPresident}}|;|TaskAbbreviation|
 
{{#cargo_query: tables=scheduleFELLservice,residentMGH  
 
{{#cargo_query: tables=scheduleFELLservice,residentMGH  
 
|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)={{#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}}
+
|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=scheduleResident}}
 
|}}
 
|}}
 +
}}
 
</td>
 
</td>
−
<td style="width: 1%">
+
<td style="width: 20%">
−
&nbsp;
+
<table class='scheduletable'><tr><td bgcolor="#f5f5f5"><center>'''{{ColorText|{{#tip-text:Attending|Attending}}||#000000|}}'''<sup>[1]</sup></center></td></tr></table>
−
</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|
 
{{#arraymap:{{scheduleDictionaryAPfaculty}}|;|TaskAbbreviation|
−
{{#cargo_query: table=scheduleFACservice  
+
{{#cargo_query: table=scheduleFACservice,facultyMGH|join on=scheduleFACservice.StaffAbbrev=facultyMGH.copath_id
−
|fields=scheduleFACservice.StaffAbbrev,scheduleFACservice.TaskAbbrev,scheduleFACservice.StaffFullName
+
|fields=scheduleFACservice.StaffAbbrev,scheduleFACservice.TaskAbbrev,scheduleFACservice.StaffFullName,facultyMGH.pageid
 
|group by=scheduleFACservice.Color
 
|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}}'
+
|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={{#switch:{{#timel: N|now }}|1=scheduleFacultyOnCall|scheduleFaculty}}}}
+
|limit=1|more results text=|default={{schtableempty|{{#explode:TaskAbbreviation|,|2}}}}|format=template|template=scheduleFaculty}}
 
|}}
 
|}}
 
</td>
 
</td>
−
<td style="width: 10%">
+
<td style="width: 20%">
−
<table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>'''{{ColorText|{{#tip-text:A|Attending}}||#000000|}}'''</center></td></tr></table>
+
<table class='scheduletable'><tr><td bgcolor="#f5f5f5"><center>[[onCallAMPrules|'''{{ColorText|{{#tip-text:Call|
−
{{#arraymap:{{scheduleDictionaryAPfaculty}}|;|TaskAbbreviation|
+
{{:onCallAMPrules}}
−
{{#cargo_query: table=scheduleFACservice
+
}}||#000000|}}''']]
−
|fields=scheduleFACservice.StaffAbbrev,scheduleFACservice.TaskAbbrev,scheduleFACservice.StaffFullName||limit=1|more results text=
+
</center></td></tr></table>
−
|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
 
−
|where=YEAR(Date)='{{#var:Saturday}}' AND scheduleFACservice.TaskAbbrev='{{#explode:TaskAbbreviation|,|0}}' AND scheduleFACservice.DayNumber='6' AND scheduleFACservice.WeekNumber='{{#expr: {{#timel: W|{{Timezone}}}} - 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}}
 
{{:learn:oncallAMP}}
 
</td>
 
</td>
 
</tr>
 
</tr>
 
</table>
 
</table>
−
<br>
+
<p></p>
−
{{header|Service schedule - clinical pathology (LMM)}}
+
__NOCACHE__<table class="table borderless">
−
<br>
+
<tr><td bgcolor="#f0f0f0" colspan="5"><center>'''{{ColorText|Clinical pathology (LMM)|||4}}'''</center></td></tr>
−
<table class='table borderless'>
 
 
<tr>
 
<tr>
−
<td colspan="1">
+
<td style="width: 20%">
−
&nbsp;
+
<table class='scheduletable'><tr><td bgcolor="#f5f5f5"><center>{{ColorText|'''Service'''||#000000|}}</center></td></tr></table>
−
</td>
+
{{:scheduleDictionaryCP}}
−
<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}}<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}}<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}}<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}}<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}}<p></p></center>
 
−
</td>
 
−
<td colspan="1">
 
−
<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}}<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}}<p></p></center>
 
−
</td>
 
−
<td colspan="1">
 
−
<center>'''Attending<br>on call'''</center>
 
 
</td>
 
</td>
−
</tr>
+
<td style="width: 20%">
−
<tr>
+
<table class='scheduletable'><tr><td bgcolor="#f5f5f5"><center>'''{{ColorText|{{#tip-text:Resident|Resident}}||#000000|}}'''</center></td></tr></table>
−
<td style="width: 10%">
+
{{#switch: {{#time: N|{{Timezone}}}}
−
<table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>{{ColorText|'''Service'''||#000000|}}</center></td></tr></table>
+
|6
 +
|7=
 
{{:scheduleDictionaryCP}}
 
{{:scheduleDictionaryCP}}
−
</td>
+
|{{#arraymap:{{scheduleDictionaryCP}}|;|TaskAbbreviation|
−
<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  
 
{{#cargo_query: tables=scheduleRESservice,residentMGH  
 
|join on=scheduleRESservice.ResAbbrev=residentMGH.copath_id
 
|join on=scheduleRESservice.ResAbbrev=residentMGH.copath_id
−
|fields=GROUP_CONCAT(DISTINCT scheduleRESservice.ResAbbrev),scheduleRESservice.TaskAbbrev,GROUP_CONCAT(DISTINCT residentMGH.full_name)
+
|fields=GROUP_CONCAT(DISTINCT scheduleRESservice.ResAbbrev)
 +
,scheduleRESservice.TaskAbbrev
 +
,GROUP_CONCAT(DISTINCT residentMGH.full_name)
 +
,pageid
 
|group by=scheduleRESservice.WeekNumber
 
|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}}
+
|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>
−
<td style="width: 9%">
+
<td style="width: 20%">
−
<table class='scheduletable'><tr><td bgcolor="#FFFFFF"><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>
−
{{#arraymap:{{scheduleDictionaryCP}}|;|TaskAbbreviation|
+
{{#switch: {{#time: N|{{Timezone}}}}
 +
|6
 +
|7=
 +
{{:scheduleDictionaryCP}}
 +
|{{#arraymap:{{scheduleDictionaryCP}}|;|TaskAbbreviation|
 
{{#cargo_query: tables=scheduleFELLservice,residentMGH  
 
{{#cargo_query: tables=scheduleFELLservice,residentMGH  
 
|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)={{#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}}
+
|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: 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=YEAR(Date)='{{#var:Saturday}}' AND scheduleFACservice.TaskAbbrev='{{#explode:TaskAbbreviation|,|0}}' AND scheduleFACservice.DayNumber='6' AND scheduleFACservice.WeekNumber='{{#expr: {{#timel: W|{{Timezone}}}} - 0}}'
 
−
|default={{schtableempty|{{#explode:TaskAbbreviation|,|2}}}}|format=template|template=scheduleResidentCPfaculty}}
 
−
|}}
 
−
{{scheduleImmunoException}}
 
 
</td>
 
</td>
−
<td style="width: 10%">
+
<td style="width: 20%">
−
<table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>'''{{ColorText|{{#tip-text:A|Attending}}||#000000|}}'''</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:{{scheduleDictionaryCPfaculty}}|;|TaskAbbreviation|
 
{{#arraymap:{{scheduleDictionaryCPfaculty}}|;|TaskAbbreviation|
−
{{#cargo_query: table=scheduleFACservice  
+
{{#cargo_query: table=scheduleFACservice,facultyMGH|join on=scheduleFACservice.StaffAbbrev=facultyMGH.copath_id
−
|fields=scheduleFACservice.StaffAbbrev,scheduleFACservice.TaskAbbrev,scheduleFACservice.StaffFullName||limit=1|more results text=
+
|fields=GROUP_CONCAT(scheduleFACservice.StaffAbbrev),scheduleFACservice.TaskAbbrev,GROUP_CONCAT(scheduleFACservice.StaffFullName),facultyMGH.pageid
 
|group by=scheduleFACservice.Color
 
|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}}'
+
|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}}
 
|default={{schtableempty|{{#explode:TaskAbbreviation|,|2}}}}|format=template|template=scheduleResidentCPfaculty}}
 
|}}
 
|}}
 
{{scheduleImmunoException}}
 
{{scheduleImmunoException}}
 
</td>
 
</td>
−
<td style="width: 10%">
+
<td style="width: 20%">
−
<table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>'''{{ColorText|{{#tip-text:A|Attending}}||#000000|}}'''</center></td></tr></table>
+
<table class='scheduletable'><tr><td bgcolor="#f5f5f5"><center>'''{{ColorText|{{#tip-text:Call|On call attending}}||#000000|}}'''
 +
</center></td></tr></table>
 
{{:learn:oncallfaculty}}
 
{{:learn:oncallfaculty}}
 
</td>
 
</td>
 
</tr>
 
</tr>
 
</table>
 
</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 01:14, January 18, 2022

Anatomic pathology (AMP)
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
DEM,JMD
AAW,NEA,SFA
TYY
KZL
-
-
ANT
LHV
-
-
-
-
-
-
KSH
GEO
-
-
-
-
-
-
LCC
-
MAB
-
-
-
-
MUS
-
CQC,ELY
-
LPR
Fellow
-
-
-
-
-
-
-
-
-
HH579
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
EZR
-
-
-
Attending[1]
-
-
Lu
Lu
Lu
Jo
-
-
-
Call
Patalas
Nielsen
Sgroi
Sgroi
Sgroi
Padera
Smith
Zhang
Zhang
Zhang
Moran
Moran
Moran
ANA
-
-
Drage
Drage
Drage
Drage
Lu
Lu
Young
Young
Brackett
Alzumaili
Alzumaili
Sohani
Sohani
Frosch
Frosch
Hung
-
-

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
-
-
-
AND,RAK
-
-
-
-
-
-
-
-
-
-
-
-
-
JSE,SMT
Fellow
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
Attending[1]
Makar
Connell
LiuL
-
-
-
Sohani
Fitzpatrick
Higgins
-
-
-
-
-
-
-
MM408
-
Call
27364
No results Connell
15433
32443
25338
25338
Sohani
Sohani
Higgins
-
-
-
-
-
-
-
MM408
-

[1]Faculty schedule displayed using the QGenda API.

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