Difference between revisions of "Weekly Schedule"

From MGH Learn Pathology
 
(65 intermediate revisions by 2 users not shown)
Line 1: Line 1:
 
{{DISPLAYTITLE:<span style="color:#f9f9f9">MGH</span>}}
 
{{DISPLAYTITLE:<span style="color:#f9f9f9">MGH</span>}}
<div class=calendarbg>
+
<center><div class=calendarbg>
 
{{#cargo_compound_query:
 
{{#cargo_compound_query:
 
tables=conference,residentMGH
 
tables=conference,residentMGH
Line 26: Line 26:
 
|tables=conference,residentMGH
 
|tables=conference,residentMGH
 
;join on=conference.presenter=residentMGH.copath_id
 
;join on=conference.presenter=residentMGH.copath_id
;fields=CONCAT(conference.conference, ' - ', conference.presenter)=name,residentMGH.full_name=description,conference.date=Date
+
;fields=CONCAT(conference.conference, ' - ', conference.presenter)=name,residentMGH.full_name=description,conference.datetime=Date
 
;where=conference='GPR'
 
;where=conference='GPR'
 
;color=#ffb973
 
;color=#ffb973
 
;text color=black
 
;text color=black
|tables=conference, residentMGH;join on=conference.presenter = residentMGH.copath_id;fields=CONCAT(conference.conference, ' - ', conference.presenter)=name,residentMGH.full_name=description,conference.date=Date;where=conference='MPR';color=#7dc4ff;text color=black
+
|tables=conferenceOuts, facultyMGH;join on=conferenceOuts.StaffAbbrev = facultyMGH.copath_id;fields=CONCAT(conferenceOuts.TaskAbbrev, ' - ', conferenceOuts.StaffAbbrev)=name,facultyMGH.name_last=description,conferenceOuts.datetime=Date;color=#fff673;text color=black
 +
|tables=conference, residentMGH;join on=conference.presenter = residentMGH.copath_id;fields=CONCAT(conference.conference, ' - ', conference.presenter)=name,residentMGH.full_name=description,conference.datetime=Date;where=conference='MPR';color=#7dc4ff;text color=black
 
|tables=conference, residentMGH;join on=conference.presenter = residentMGH.copath_id;fields=CONCAT(conference.conference, ' - ', conference.presenter)=name,residentMGH.full_name=description,conference.date=Date;where=conference='Thoracic';color=#c2c2c2;text color=black
 
|tables=conference, residentMGH;join on=conference.presenter = residentMGH.copath_id;fields=CONCAT(conference.conference, ' - ', conference.presenter)=name,residentMGH.full_name=description,conference.date=Date;where=conference='Thoracic';color=#c2c2c2;text color=black
 
|tables=conference, residentMGH;join on=conference.presenter = residentMGH.copath_id;fields=CONCAT(conference.conference, ' - ', conference.presenter)=name,residentMGH.full_name=description,conference.date=Date;where=conference='RadPath';color=#66ff96;text color=black
 
|tables=conference, residentMGH;join on=conference.presenter = residentMGH.copath_id;fields=CONCAT(conference.conference, ' - ', conference.presenter)=name,residentMGH.full_name=description,conference.date=Date;where=conference='RadPath';color=#66ff96;text color=black
 
|tables=conference, residentMGH;join on=conference.presenter = residentMGH.copath_id;fields=CONCAT(conference.conference, ' - ', conference.presenter)=name,residentMGH.full_name=description,conference.date=Date;where=conference='Autopsy';color=#faff69;text color=black
 
|tables=conference, residentMGH;join on=conference.presenter = residentMGH.copath_id;fields=CONCAT(conference.conference, ' - ', conference.presenter)=name,residentMGH.full_name=description,conference.date=Date;where=conference='Autopsy';color=#faff69;text color=black
|format=calendar|view=week|height=160}}
+
|format=calendar|view=week|height=400}}
 
</div>
 
</div>
 
<br>
 
<br>
 +
<div style="overflow-x:auto"><div class=calendarbg>
 
<table class='table borderless'>
 
<table class='table borderless'>
 
<tr>
 
<tr>
<td colspan="1">&nbsp;</td>
+
<td colspan="1">
<td colspan="2">{{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=scheduleFACservice.DayNumber='1' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|}} - 0 }}' AND scheduleFACservice.TaskAbbrev='BR1' |format=template|template=datedisplay }} - {{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=scheduleFACservice.DayNumber='5' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|}} - 0 }}' AND scheduleFACservice.TaskAbbrev='BR1' |format=template|template=datedisplay }}</td>
+
&nbsp;
<td colspan="1">{{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=scheduleFACservice.DayNumber='1' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|}} - 0}}' AND scheduleFACservice.TaskAbbrev ='BR1' |format=template|template=datedisplay }}</td>
+
</td>
<td colspan="1">{{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=scheduleFACservice.DayNumber='2' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|}} - 0}}' AND scheduleFACservice.TaskAbbrev ='BR1' |format=template|template=datedisplay }}</td>
+
<td colspan="9">
<td colspan="1">{{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=scheduleFACservice.DayNumber='3' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|}} - 0}}' AND scheduleFACservice.TaskAbbrev ='BR1' |format=template|template=datedisplay }}</td>
+
<center>{{ColorText|{{#time:Y": Week "|}}||#000000|}} {{ColorText|'''{{#expr: {{#time: W|}} - 0 }}'''||#000000|}}</center>
<td colspan="1">{{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=scheduleFACservice.DayNumber='4' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|}} - 0}}' AND scheduleFACservice.TaskAbbrev ='BR1' |format=template|template=datedisplay }}</td>
+
</td>
<td colspan="1">{{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=scheduleFACservice.DayNumber='5' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|}} - 0}}' AND scheduleFACservice.TaskAbbrev ='BR1' |format=template|template=datedisplay }}</td>
+
</td>
<td colspan="1">{{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=scheduleFACservice.DayNumber='6' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|}} - 0}}' AND scheduleFACservice.TaskAbbrev ='BR1' |format=template|template=datedisplay }}</td>
+
<td colspan="4">
<td colspan="1">{{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=scheduleFACservice.DayNumber='7' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|}} - 0}}' AND scheduleFACservice.TaskAbbrev ='BR1' |format=template|template=datedisplay }}</td>
+
<center>{{ColorText|{{#time:Y": Week "|}}||#636363|}} {{ColorText|'''{{#expr: {{#time: W|}} + 1 }}'''||#636363|}}</center>
 +
</td>
 +
</tr>
 +
<tr>
 +
<td colspan="1">
 +
&nbsp;
 +
</td>
 +
<td class='align-bottom' colspan="2">
 +
<center><p>{{ColorText|Mon-Fri||#000000|}}</p></center>
 +
</td>
 +
<td class='align-bottom' colspan="1">
 +
{{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=scheduleFACservice.DayNumber='1' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|}} - 0 }}' AND scheduleFACservice.TaskAbbrev='BR1' |format=template|template=datedisplayfac}}
 +
</td>
 +
<td colspan="1">
 +
{{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=scheduleFACservice.DayNumber='2' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|}} - 0 }}' AND scheduleFACservice.TaskAbbrev='BR1' |format=template|template=datedisplayfac}}
 +
</td>
 +
<td colspan="1">
 +
{{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=scheduleFACservice.DayNumber='3' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|}} - 0 }}' AND scheduleFACservice.TaskAbbrev='BR1' |format=template|template=datedisplayfac}}
 +
</td>
 +
<td colspan="1">
 +
{{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=scheduleFACservice.DayNumber='4' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|}} - 0 }}' AND scheduleFACservice.TaskAbbrev='BR1' |format=template|template=datedisplayfac}}
 +
</td>
 +
<td colspan="1">
 +
{{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=scheduleFACservice.DayNumber='5' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|}} - 0 }}' AND scheduleFACservice.TaskAbbrev='BR1' |format=template|template=datedisplayfac}}
 +
</td>
 +
<td colspan="1">
 +
{{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=scheduleFACservice.DayNumber='6' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|}} - 0 }}' AND scheduleFACservice.TaskAbbrev='BR1' |format=template|template=datedisplayfac}}
 +
</td>
 +
<td colspan="1">
 +
{{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=scheduleFACservice.DayNumber='7' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|}} - 0 }}' AND scheduleFACservice.TaskAbbrev='BR1' |format=template|template=datedisplayfac}}
 +
</td>
 +
<td class='align-bottom' colspan="2">
 +
<center><p>{{ColorText|Mon-Fri||#636363|}}</p></center>
 +
</td>
 +
<td colspan="1">
 +
{{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=scheduleFACservice.DayNumber='1' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|}} + 1 }}' AND scheduleFACservice.TaskAbbrev='BR1' |format=template|template=datedisplaynextweekfac}}
 +
</td>
 +
<td colspan="1">
 +
{{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=scheduleFACservice.DayNumber='2' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|}} + 1 }}' AND scheduleFACservice.TaskAbbrev='BR1' |format=template|template=datedisplaynextweekfac}}
 +
</td>
 
</tr><tr>
 
</tr><tr>
<td style="width: 10%">
+
<td style="width: 8%">
{{ColorText|'''Services'''||#183e7a|}}
+
<table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>{{ColorText|'''SERVICE'''||#000000|}}</center></td></tr></table>
 
{{:schtablemobile}}
 
{{:schtablemobile}}
 
</td>       
 
</td>       
<td style="width: 10%">
+
<td style="width: 5%">
{{ColorText|'''Residents'''||#183e7a|}}
+
<table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>'''{{ColorText|{{#tip-text:R|Resident}}||#000000|}}'''</center></td></tr></table>
{{#cargo_query: table=scheduleRESservice |fields=scheduleRESservice.ResAbbrev,scheduleRESservice.Color|where=scheduleRESservice.WeekNumber='{{#expr: {{#time: W|}} - 0 }}' AND scheduleRESservice.TaskAbbrev='AUT' |format=template|template=schtable}}
+
{{#arraymap: AUT,BR1,BR2,BST,CV,CA,CB,CC,DPA,DPB,DPC,FS,HN1,HN2,GI1,GI2,GI3,GUL,GUS,GYL,GYS,HPA,HPB,NP,OB,PP,RP,AP CHIEF,FS-S,FS-J,GR-S|,|TaskAbbreviation|
{{#cargo_query: table=scheduleRESservice |fields=scheduleRESservice.ResAbbrev,scheduleRESservice.Color|where=scheduleRESservice.WeekNumber='{{#expr: {{#time: W|}} - 0 }}' AND scheduleRESservice.TaskAbbrev='BR1' |format=template|template=schtable}}
+
{{#cargo_query: tables=scheduleRESservice,residentMGH
{{#cargo_query: table=scheduleRESservice |fields=scheduleRESservice.ResAbbrev,scheduleRESservice.Color|where=scheduleRESservice.WeekNumber='{{#expr: {{#time: W|}} - 0 }}' AND scheduleRESservice.TaskAbbrev='BR2' |format=template|template=schtable}}
+
|join on=scheduleRESservice.ResAbbrev=residentMGH.copath_id
{{#cargo_query: table=scheduleRESservice |fields=scheduleRESservice.ResAbbrev,scheduleRESservice.Color|where=scheduleRESservice.WeekNumber='{{#expr: {{#time: W|}} - 0 }}' AND scheduleRESservice.TaskAbbrev='BST' |format=template|template=schtable}}
+
|fields=scheduleRESservice.ResAbbrev,scheduleRESservice.Color,residentMGH.full_name
{{#cargo_query: table=scheduleRESservice |fields=scheduleRESservice.ResAbbrev,scheduleRESservice.Color|where=scheduleRESservice.WeekNumber='{{#expr: {{#time: W|}} - 0 }}' AND scheduleRESservice.TaskAbbrev='CV' |format=template|template=schtable}}
+
|where=scheduleRESservice.WeekNumber='{{#expr: {{#time: W|}} - 0 }}' AND scheduleRESservice.TaskAbbrev='TaskAbbreviation'|default={{:schtableempty}}|format=template|template=schtable}}
{{#cargo_query: table=scheduleRESservice |fields=scheduleRESservice.ResAbbrev,scheduleRESservice.Color|where=scheduleRESservice.WeekNumber='{{#expr: {{#time: W|}} - 0 }}' AND scheduleRESservice.TaskAbbrev='CA' |format=template|template=schtable}}
+
|}}
{{#cargo_query: table=scheduleRESservice |fields=scheduleRESservice.ResAbbrev,scheduleRESservice.Color|where=scheduleRESservice.WeekNumber='{{#expr: {{#time: W|}} - 0 }}' AND scheduleRESservice.TaskAbbrev='CB' |format=template|template=schtable}}
+
</td>
{{#cargo_query: table=scheduleRESservice |fields=scheduleRESservice.ResAbbrev,scheduleRESservice.Color|where=scheduleRESservice.WeekNumber='{{#expr: {{#time: W|}} - 0 }}' AND scheduleRESservice.TaskAbbrev='CC' |format=template|template=schtable}}
+
<td style="width: 5%">
{{#cargo_query: table=scheduleRESservice |fields=scheduleRESservice.ResAbbrev,scheduleRESservice.Color|where=scheduleRESservice.WeekNumber='{{#expr: {{#time: W|}} - 0 }}' AND scheduleRESservice.TaskAbbrev='DPA' |format=template|template=schtable}}
+
<table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>'''{{ColorText|{{#tip-text:F|Fellow}}||#000000|}}'''</center></td></tr></table>
{{#cargo_query: table=scheduleRESservice |fields=scheduleRESservice.ResAbbrev,scheduleRESservice.Color|where=scheduleRESservice.WeekNumber='{{#expr: {{#time: W|}} - 0 }}' AND scheduleRESservice.TaskAbbrev='DPB' |format=template|template=schtable}}
+
{{#arraymap: AUT,BR1,BR2,BST,CV,CA,CB,CC,DPA,DPB,DPC,FS,HN1,HN2,GI1,GI2,GI3,GUL,GUS,GYL,GYS,HPA,HPB,NP,OB,PP,RP|,|TaskAbbreviation|
{{#cargo_query: table=scheduleRESservice |fields=scheduleRESservice.ResAbbrev,scheduleRESservice.Color|where=scheduleRESservice.WeekNumber='{{#expr: {{#time: W|}} - 0 }}' AND scheduleRESservice.TaskAbbrev='DPC' |format=template|template=schtable}}
+
{{#cargo_query: tables=scheduleFELLservice,residentMGH
{{#cargo_query: table=scheduleRESservice |fields=scheduleRESservice.ResAbbrev,scheduleRESservice.Color|where=scheduleRESservice.WeekNumber='{{#expr: {{#time: W|}} - 0 }}' AND scheduleRESservice.TaskAbbrev='FS' |format=template|template=schtable}}
+
|join on=scheduleFELLservice.FellAbbrev=residentMGH.copath_id
{{#cargo_query: table=scheduleRESservice |fields=scheduleRESservice.ResAbbrev,scheduleRESservice.Color|where=scheduleRESservice.WeekNumber='{{#expr: {{#time: W|}} - 0 }}' AND scheduleRESservice.TaskAbbrev='HN1' |format=template|template=schtable}}
+
|fields=scheduleFELLservice.FellAbbrev,scheduleFELLservice.Color,residentMGH.full_name
{{#cargo_query: table=scheduleRESservice |fields=scheduleRESservice.ResAbbrev,scheduleRESservice.Color|where=scheduleRESservice.WeekNumber='{{#expr: {{#time: W|}} - 0 }}' AND scheduleRESservice.TaskAbbrev='HN2' |format=template|template=schtable}}
+
|where=scheduleFELLservice.WeekNumber='{{#expr: {{#time: W|}} - 0 }}' AND scheduleFELLservice.TaskAbbrev='TaskAbbreviation' |format=template|template=schtable}}
{{#cargo_query: table=scheduleRESservice |fields=scheduleRESservice.ResAbbrev,scheduleRESservice.Color|where=scheduleRESservice.WeekNumber='{{#expr: {{#time: W|}} - 0 }}' AND scheduleRESservice.TaskAbbrev='GI1' |format=template|template=schtable}}
+
|}}
{{#cargo_query: table=scheduleRESservice |fields=scheduleRESservice.ResAbbrev,scheduleRESservice.Color|where=scheduleRESservice.WeekNumber='{{#expr: {{#time: W|}} - 0 }}' AND scheduleRESservice.TaskAbbrev='GI2' |format=template|template=schtable}}
+
</td>
{{#cargo_query: table=scheduleRESservice |fields=scheduleRESservice.ResAbbrev,scheduleRESservice.Color|where=scheduleRESservice.WeekNumber='{{#expr: {{#time: W|}} - 0 }}' AND scheduleRESservice.TaskAbbrev='GI3' |format=template|template=schtable}}
+
<td style="width: 8%">
{{#cargo_query: table=scheduleRESservice |fields=scheduleRESservice.ResAbbrev,scheduleRESservice.Color|where=scheduleRESservice.WeekNumber='{{#expr: {{#time: W|}} - 0 }}' AND scheduleRESservice.TaskAbbrev='GUL' |format=template|template=schtable}}
+
<table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>'''{{ColorText|{{#tip-text:A|Attending}}||#000000|}}'''<ref>The faculty service schedule is displayed on this page using the QGenda API. For any discrepancies or to view the full schedule <htmltag tagname="a" href="https://www.medialab.com/dv/dl.aspx?d=933279&dh=40c79&u=111736&uh=c3cf8" target="_blank">click here.</htmltag> <span class="glyphicon glyphicon-calendar" aria-hidden="true"></span></ref></center></td></tr></table>
{{#cargo_query: table=scheduleRESservice |fields=scheduleRESservice.ResAbbrev,scheduleRESservice.Color|where=scheduleRESservice.WeekNumber='{{#expr: {{#time: W|}} - 0 }}' AND scheduleRESservice.TaskAbbrev='GUS' |format=template|template=schtable}}
+
{{#arraymap: AUT,BR1,BR2,BST,CV,CA,CB,CC,DPA,DPB,DPC,Frozen Section,HN1,HN2,GI1,GI2,GI3,GUL,GUS,GYL,GYS,HPA,HPB,NP,OB,PP,RP|,|TaskAbbreviation|
{{#cargo_query: table=scheduleRESservice |fields=scheduleRESservice.ResAbbrev,scheduleRESservice.Color|where=scheduleRESservice.WeekNumber='{{#expr: {{#time: W|}} - 0 }}' AND scheduleRESservice.TaskAbbrev='GYL' |format=template|template=schtable}}
+
{{#cargo_query: table=scheduleFACservice
{{#cargo_query: table=scheduleRESservice |fields=scheduleRESservice.ResAbbrev,scheduleRESservice.Color|where=scheduleRESservice.WeekNumber='{{#expr: {{#time: W|}} - 0 }}' AND scheduleRESservice.TaskAbbrev='GYS' |format=template|template=schtable}}
+
|fields=scheduleFACservice.StaffAbbrev,scheduleFACservice.Color,scheduleFACservice.StaffFullName
{{#cargo_query: table=scheduleRESservice |fields=scheduleRESservice.ResAbbrev,scheduleRESservice.Color|where=scheduleRESservice.WeekNumber='{{#expr: {{#time: W|}} - 0 }}' AND scheduleRESservice.TaskAbbrev='HPA' |format=template|template=schtable}}
+
|where=scheduleFACservice.TaskAbbrev='TaskAbbreviation' AND scheduleFACservice.DayNumber='1' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|}} - 0}}'
{{#cargo_query: table=scheduleRESservice |fields=scheduleRESservice.ResAbbrev,scheduleRESservice.Color|where=scheduleRESservice.WeekNumber='{{#expr: {{#time: W|}} - 0 }}' AND scheduleRESservice.TaskAbbrev='HPB' |format=template|template=schtable}}
+
|default={{:schtableempty}}|format=template|template=schtable}}
{{#cargo_query: table=scheduleRESservice |fields=scheduleRESservice.ResAbbrev,scheduleRESservice.Color|where=scheduleRESservice.WeekNumber='{{#expr: {{#time: W|}} - 0 }}' AND scheduleRESservice.TaskAbbrev='NP' |format=template|template=schtable}}
+
|}}
{{#cargo_query: table=scheduleRESservice |fields=scheduleRESservice.ResAbbrev,scheduleRESservice.Color|where=scheduleRESservice.WeekNumber='{{#expr: {{#time: W|}} - 0 }}' AND scheduleRESservice.TaskAbbrev='OB' |format=template|template=schtable}}
+
</td>
{{#cargo_query: table=scheduleRESservice |fields=scheduleRESservice.ResAbbrev,scheduleRESservice.Color|where=scheduleRESservice.WeekNumber='{{#expr: {{#time: W|}} - 0 }}' AND scheduleRESservice.TaskAbbrev='PP' |format=template|template=schtable}}
+
<td style="width: 8%">
{{#cargo_query: table=scheduleRESservice |fields=scheduleRESservice.ResAbbrev,scheduleRESservice.Color|where=scheduleRESservice.WeekNumber='{{#expr: {{#time: W|}} - 0 }}' AND scheduleRESservice.TaskAbbrev='RP' |format=template|template=schtable}}
+
<table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>'''{{ColorText|{{#tip-text:A|Attending}}||#000000|}}'''</center></td></tr></table>
{{#cargo_query: table=scheduleRESservice |fields=scheduleRESservice.ResAbbrev,scheduleRESservice.Color|where=scheduleRESservice.WeekNumber='{{#expr: {{#time: W|}} - 0 }}' AND scheduleRESservice.TaskAbbrev='AP CHIEF' |format=template|template=schtable}}
+
{{#arraymap: AUT,BR1,BR2,BST,CV,CA,CB,CC,DPA,DPB,DPC,Frozen Section,HN1,HN2,GI1,GI2,GI3,GUL,GUS,GYL,GYS,HPA,HPB,NP,OB,PP,RP|,|TaskAbbreviation|
{{#cargo_query: table=scheduleRESservice |fields=scheduleRESservice.ResAbbrev,scheduleRESservice.Color|where=scheduleRESservice.WeekNumber='{{#expr: {{#time: W|}} - 0 }}' AND scheduleRESservice.TaskAbbrev='FS-S' |format=template|template=schtable}}
+
{{#cargo_query: table=scheduleFACservice
{{#cargo_query: table=scheduleRESservice |fields=scheduleRESservice.ResAbbrev,scheduleRESservice.Color|where=scheduleRESservice.WeekNumber='{{#expr: {{#time: W|}} - 0 }}' AND scheduleRESservice.TaskAbbrev='FS-J' |format=template|template=schtable}}
+
|fields=scheduleFACservice.StaffAbbrev,scheduleFACservice.Color,scheduleFACservice.StaffFullName
{{#cargo_query: table=scheduleRESservice |fields=scheduleRESservice.ResAbbrev,scheduleRESservice.Color|where=scheduleRESservice.WeekNumber='{{#expr: {{#time: W|}} - 0 }}' AND scheduleRESservice.TaskAbbrev='GR-S' |format=template|template=schtable}}
+
|where=scheduleFACservice.TaskAbbrev='TaskAbbreviation' AND scheduleFACservice.DayNumber='2' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|}} - 0}}'
 +
|default={{:schtableempty}}|format=template|template=schtable}}
 +
|}}
 +
</td>
 +
<td style="width: 8%">
 +
<table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>'''{{ColorText|{{#tip-text:A|Attending}}||#000000|}}'''</center></td></tr></table>
 +
{{#arraymap: AUT,BR1,BR2,BST,CV,CA,CB,CC,DPA,DPB,DPC,Frozen Section,HN1,HN2,GI1,GI2,GI3,GUL,GUS,GYL,GYS,HPA,HPB,NP,OB,PP,RP|,|TaskAbbreviation|
 +
{{#cargo_query: table=scheduleFACservice
 +
|fields=scheduleFACservice.StaffAbbrev,scheduleFACservice.Color,scheduleFACservice.StaffFullName
 +
|where=scheduleFACservice.TaskAbbrev='TaskAbbreviation' AND scheduleFACservice.DayNumber='3' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|}} - 0}}'
 +
|default={{:schtableempty}}|format=template|template=schtable}}
 +
|}}
 +
</td>
 +
<td style="width: 8%">
 +
<table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>'''{{ColorText|{{#tip-text:A|Attending}}||#000000|}}'''</center></td></tr></table>
 +
{{#arraymap: AUT,BR1,BR2,BST,CV,CA,CB,CC,DPA,DPB,DPC,Frozen Section,HN1,HN2,GI1,GI2,GI3,GUL,GUS,GYL,GYS,HPA,HPB,NP,OB,PP,RP|,|TaskAbbreviation|
 +
{{#cargo_query: table=scheduleFACservice
 +
|fields=scheduleFACservice.StaffAbbrev,scheduleFACservice.Color,scheduleFACservice.StaffFullName
 +
|where=scheduleFACservice.TaskAbbrev='TaskAbbreviation' AND scheduleFACservice.DayNumber='4' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|}} - 0}}'
 +
|default={{:schtableempty}}|format=template|template=schtable}}
 +
|}}
 
</td>
 
</td>
<td style="width: 10%">
+
<td style="width: 8%">
{{ColorText|'''Fellows'''||#183e7a|}}
+
<table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>'''{{ColorText|{{#tip-text:A|Attending}}||#000000|}}'''</center></td></tr></table>
{{#cargo_query: table=scheduleFELLservice |fields=scheduleFELLservice.FellAbbrev,scheduleFELLservice.Color|where=scheduleFELLservice.WeekNumber='{{#expr: {{#time: W|}} - 0 }}' AND scheduleFELLservice.TaskAbbrev='AUT' |format=template|template=schtable}}
+
{{#arraymap: AUT,BR1,BR2,BST,CV,CA,CB,CC,DPA,DPB,DPC,Frozen Section,HN1,HN2,GI1,GI2,GI3,GUL,GUS,GYL,GYS,HPA,HPB,NP,OB,PP,RP|,|TaskAbbreviation|
{{#cargo_query: table=scheduleFELLservice |fields=scheduleFELLservice.FellAbbrev,scheduleFELLservice.Color|where=scheduleFELLservice.WeekNumber='{{#expr: {{#time: W|}} - 0 }}' AND scheduleFELLservice.TaskAbbrev='BR1' |format=template|template=schtable}}
+
{{#cargo_query: table=scheduleFACservice  
{{#cargo_query: table=scheduleFELLservice |fields=scheduleFELLservice.FellAbbrev,scheduleFELLservice.Color|where=scheduleFELLservice.WeekNumber='{{#expr: {{#time: W|}} - 0 }}' AND scheduleFELLservice.TaskAbbrev='BR2' |format=template|template=schtable}}
+
|fields=scheduleFACservice.StaffAbbrev,scheduleFACservice.Color,scheduleFACservice.StaffFullName
{{#cargo_query: table=scheduleFELLservice |fields=scheduleFELLservice.FellAbbrev,scheduleFELLservice.Color|where=scheduleFELLservice.WeekNumber='{{#expr: {{#time: W|}} - 0 }}' AND scheduleFELLservice.TaskAbbrev='BST' |format=template|template=schtable}}
+
|where=scheduleFACservice.TaskAbbrev='TaskAbbreviation' AND scheduleFACservice.DayNumber='5' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|}} - 0}}'
{{#cargo_query: table=scheduleFELLservice |fields=scheduleFELLservice.FellAbbrev,scheduleFELLservice.Color|where=scheduleFELLservice.WeekNumber='{{#expr: {{#time: W|}} - 0 }}' AND scheduleFELLservice.TaskAbbrev='CV' |format=template|template=schtable}}
+
|default={{:schtableempty}}|format=template|template=schtable}}
{{#cargo_query: table=scheduleFELLservice |fields=scheduleFELLservice.FellAbbrev,scheduleFELLservice.Color|where=scheduleFELLservice.WeekNumber='{{#expr: {{#time: W|}} - 0 }}' AND scheduleFELLservice.TaskAbbrev='CA' |format=template|template=schtable}}
+
|}}
{{#cargo_query: table=scheduleFELLservice |fields=scheduleFELLservice.FellAbbrev,scheduleFELLservice.Color|where=scheduleFELLservice.WeekNumber='{{#expr: {{#time: W|}} - 0 }}' AND scheduleFELLservice.TaskAbbrev='CB' |format=template|template=schtable}}
 
{{#cargo_query: table=scheduleFELLservice |fields=scheduleFELLservice.FellAbbrev,scheduleFELLservice.Color|where=scheduleFELLservice.WeekNumber='{{#expr: {{#time: W|}} - 0 }}' AND scheduleFELLservice.TaskAbbrev='CC' |format=template|template=schtable}}
 
{{#cargo_query: table=scheduleFELLservice |fields=scheduleFELLservice.FellAbbrev,scheduleFELLservice.Color|where=scheduleFELLservice.WeekNumber='{{#expr: {{#time: W|}} - 0 }}' AND scheduleFELLservice.TaskAbbrev='DPA' |format=template|template=schtable}}
 
{{#cargo_query: table=scheduleFELLservice |fields=scheduleFELLservice.FellAbbrev,scheduleFELLservice.Color|where=scheduleFELLservice.WeekNumber='{{#expr: {{#time: W|}} - 0 }}' AND scheduleFELLservice.TaskAbbrev='DPB' |format=template|template=schtable}}
 
{{#cargo_query: table=scheduleFELLservice |fields=scheduleFELLservice.FellAbbrev,scheduleFELLservice.Color|where=scheduleFELLservice.WeekNumber='{{#expr: {{#time: W|}} - 0 }}' AND scheduleFELLservice.TaskAbbrev='DPC' |format=template|template=schtable}}
 
{{#cargo_query: table=scheduleFELLservice |fields=scheduleFELLservice.FellAbbrev,scheduleFELLservice.Color|where=scheduleFELLservice.WeekNumber='{{#expr: {{#time: W|}} - 0 }}' AND scheduleFELLservice.TaskAbbrev='FS' |format=template|template=schtable}}
 
{{#cargo_query: table=scheduleFELLservice |fields=scheduleFELLservice.FellAbbrev,scheduleFELLservice.Color|where=scheduleFELLservice.WeekNumber='{{#expr: {{#time: W|}} - 0 }}' AND scheduleFELLservice.TaskAbbrev='HN1' |format=template|template=schtable}}
 
{{#cargo_query: table=scheduleFELLservice |fields=scheduleFELLservice.FellAbbrev,scheduleFELLservice.Color|where=scheduleFELLservice.WeekNumber='{{#expr: {{#time: W|}} - 0 }}' AND scheduleFELLservice.TaskAbbrev='HN2' |format=template|template=schtable}}
 
{{#cargo_query: table=scheduleFELLservice |fields=scheduleFELLservice.FellAbbrev,scheduleFELLservice.Color|where=scheduleFELLservice.WeekNumber='{{#expr: {{#time: W|}} - 0 }}' AND scheduleFELLservice.TaskAbbrev='GI1' |format=template|template=schtable}}
 
{{#cargo_query: table=scheduleFELLservice |fields=scheduleFELLservice.FellAbbrev,scheduleFELLservice.Color|where=scheduleFELLservice.WeekNumber='{{#expr: {{#time: W|}} - 0 }}' AND scheduleFELLservice.TaskAbbrev='GI2' |format=template|template=schtable}}
 
{{#cargo_query: table=scheduleFELLservice |fields=scheduleFELLservice.FellAbbrev,scheduleFELLservice.Color|where=scheduleFELLservice.WeekNumber='{{#expr: {{#time: W|}} - 0 }}' AND scheduleFELLservice.TaskAbbrev='GI3' |format=template|template=schtable}}
 
{{#cargo_query: table=scheduleFELLservice |fields=scheduleFELLservice.FellAbbrev,scheduleFELLservice.Color|where=scheduleFELLservice.WeekNumber='{{#expr: {{#time: W|}} - 0 }}' AND scheduleFELLservice.TaskAbbrev='GUL' |format=template|template=schtable}}
 
{{#cargo_query: table=scheduleFELLservice |fields=scheduleFELLservice.FellAbbrev,scheduleFELLservice.Color|where=scheduleFELLservice.WeekNumber='{{#expr: {{#time: W|}} - 0 }}' AND scheduleFELLservice.TaskAbbrev='GUS' |format=template|template=schtable}}
 
{{#cargo_query: table=scheduleFELLservice |fields=scheduleFELLservice.FellAbbrev,scheduleFELLservice.Color|where=scheduleFELLservice.WeekNumber='{{#expr: {{#time: W|}} - 0 }}' AND scheduleFELLservice.TaskAbbrev='GYL' |format=template|template=schtable}}
 
{{#cargo_query: table=scheduleFELLservice |fields=scheduleFELLservice.FellAbbrev,scheduleFELLservice.Color|where=scheduleFELLservice.WeekNumber='{{#expr: {{#time: W|}} - 0 }}' AND scheduleFELLservice.TaskAbbrev='GYS' |format=template|template=schtable}}
 
{{#cargo_query: table=scheduleFELLservice |fields=scheduleFELLservice.FellAbbrev,scheduleFELLservice.Color|where=scheduleFELLservice.WeekNumber='{{#expr: {{#time: W|}} - 0 }}' AND scheduleFELLservice.TaskAbbrev='HPA' |format=template|template=schtable}}
 
{{#cargo_query: table=scheduleFELLservice |fields=scheduleFELLservice.FellAbbrev,scheduleFELLservice.Color|where=scheduleFELLservice.WeekNumber='{{#expr: {{#time: W|}} - 0 }}' AND scheduleFELLservice.TaskAbbrev='HPB' |format=template|template=schtable}}
 
{{#cargo_query: table=scheduleFELLservice |fields=scheduleFELLservice.FellAbbrev,scheduleFELLservice.Color|where=scheduleFELLservice.WeekNumber='{{#expr: {{#time: W|}} - 0 }}' AND scheduleFELLservice.TaskAbbrev='NP' |format=template|template=schtable}}
 
{{#cargo_query: table=scheduleFELLservice |fields=scheduleFELLservice.FellAbbrev,scheduleFELLservice.Color|where=scheduleFELLservice.WeekNumber='{{#expr: {{#time: W|}} - 0 }}' AND scheduleFELLservice.TaskAbbrev='OB' |format=template|template=schtable}}
 
{{#cargo_query: table=scheduleFELLservice |fields=scheduleFELLservice.FellAbbrev,scheduleFELLservice.Color|where=scheduleFELLservice.WeekNumber='{{#expr: {{#time: W|}} - 0 }}' AND scheduleFELLservice.TaskAbbrev='PP' |format=template|template=schtable}}
 
{{#cargo_query: table=scheduleFELLservice |fields=scheduleFELLservice.FellAbbrev,scheduleFELLservice.Color|where=scheduleFELLservice.WeekNumber='{{#expr: {{#time: W|}} - 0 }}' AND scheduleFELLservice.TaskAbbrev='RP' |format=template|template=schtable}}
 
      <td style="width: 10%">
 
{{ColorText|'''Faculty'''||#183e7a|}}
 
{{#cargo_query: table=scheduleFACservice|fields=scheduleFACservice.StaffAbbrev,scheduleFACservice.Color|where=scheduleFELLservice.TaskAbbrev='AUT' AND scheduleFACservice.DayNumber='1' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|}} - 0}}'|format=template|template=schtable}}
 
{{#cargo_query: table=scheduleFACservice|fields=scheduleFACservice.StaffAbbrev,scheduleFACservice.Color|where=scheduleFELLservice.TaskAbbrev='BR1' AND scheduleFACservice.DayNumber='1' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|}} - 0}}'|format=template|template=schtable}}
 
{{#cargo_query: table=scheduleFACservice|fields=scheduleFACservice.StaffAbbrev,scheduleFACservice.Color|where=scheduleFELLservice.TaskAbbrev='BR2' AND scheduleFACservice.DayNumber='1' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|}} - 0}}'|format=template|template=schtable}}
 
{{#cargo_query: table=scheduleFACservice|fields=scheduleFACservice.StaffAbbrev,scheduleFACservice.Color|where=scheduleFELLservice.TaskAbbrev='BST' AND scheduleFACservice.DayNumber='1' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|}} - 0}}'|format=template|template=schtable}}
 
{{#cargo_query: table=scheduleFACservice|fields=scheduleFACservice.StaffAbbrev,scheduleFACservice.Color|where=scheduleFELLservice.TaskAbbrev='CV' AND scheduleFACservice.DayNumber='1' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|}} - 0}}'|format=template|template=schtable}}
 
{{#cargo_query: table=scheduleFACservice|fields=scheduleFACservice.StaffAbbrev,scheduleFACservice.Color|where=scheduleFELLservice.TaskAbbrev='CA' AND scheduleFACservice.DayNumber='1' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|}} - 0}}'|format=template|template=schtable}}
 
{{#cargo_query: table=scheduleFACservice|fields=scheduleFACservice.StaffAbbrev,scheduleFACservice.Color|where=scheduleFELLservice.TaskAbbrev='CB' AND scheduleFACservice.DayNumber='1' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|}} - 0}}'|format=template|template=schtable}}
 
{{#cargo_query: table=scheduleFACservice|fields=scheduleFACservice.StaffAbbrev,scheduleFACservice.Color|where=scheduleFELLservice.TaskAbbrev='CC' AND scheduleFACservice.DayNumber='1' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|}} - 0}}'|format=template|template=schtable}}
 
{{#cargo_query: table=scheduleFACservice|fields=scheduleFACservice.StaffAbbrev,scheduleFACservice.Color|where=scheduleFELLservice.TaskAbbrev='DPA' AND scheduleFACservice.DayNumber='1' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|}} - 0}}'|format=template|template=schtable}}
 
{{#cargo_query: table=scheduleFACservice|fields=scheduleFACservice.StaffAbbrev,scheduleFACservice.Color|where=scheduleFELLservice.TaskAbbrev='DPB' AND scheduleFACservice.DayNumber='1' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|}} - 0}}'|format=template|template=schtable}}
 
{{#cargo_query: table=scheduleFACservice|fields=scheduleFACservice.StaffAbbrev,scheduleFACservice.Color|where=scheduleFELLservice.TaskAbbrev='DPC' AND scheduleFACservice.DayNumber='1' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|}} - 0}}'|format=template|template=schtable}}
 
{{#cargo_query: table=scheduleFACservice|fields=scheduleFACservice.StaffAbbrev,scheduleFACservice.Color|where=scheduleFELLservice.TaskAbbrev='Frozen Section' AND scheduleFACservice.DayNumber='1' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|}} - 0}}'|format=template|template=schtable}}
 
{{#cargo_query: table=scheduleFACservice|fields=scheduleFACservice.StaffAbbrev,scheduleFACservice.Color|where=scheduleFELLservice.TaskAbbrev='HN1' AND scheduleFACservice.DayNumber='1' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|}} - 0}}'|format=template|template=schtable}}
 
{{#cargo_query: table=scheduleFACservice|fields=scheduleFACservice.StaffAbbrev,scheduleFACservice.Color|where=scheduleFELLservice.TaskAbbrev='HN2' AND scheduleFACservice.DayNumber='1' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|}} - 0}}'|format=template|template=schtable}}
 
{{#cargo_query: table=scheduleFACservice|fields=scheduleFACservice.StaffAbbrev,scheduleFACservice.Color|where=scheduleFELLservice.TaskAbbrev='GI1' AND scheduleFACservice.DayNumber='1' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|}} - 0}}'|format=template|template=schtable}}
 
{{#cargo_query: table=scheduleFACservice|fields=scheduleFACservice.StaffAbbrev,scheduleFACservice.Color|where=scheduleFELLservice.TaskAbbrev='GI2' AND scheduleFACservice.DayNumber='1' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|}} - 0}}'|format=template|template=schtable}}
 
{{#cargo_query: table=scheduleFACservice|fields=scheduleFACservice.StaffAbbrev,scheduleFACservice.Color|where=scheduleFELLservice.TaskAbbrev='GI3' AND scheduleFACservice.DayNumber='1' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|}} - 0}}'|format=template|template=schtable}}
 
{{#cargo_query: table=scheduleFACservice|fields=scheduleFACservice.StaffAbbrev,scheduleFACservice.Color|where=scheduleFELLservice.TaskAbbrev='GUL' AND scheduleFACservice.DayNumber='1' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|}} - 0}}'|format=template|template=schtable}}
 
{{#cargo_query: table=scheduleFACservice|fields=scheduleFACservice.StaffAbbrev,scheduleFACservice.Color|where=scheduleFELLservice.TaskAbbrev='GUS' AND scheduleFACservice.DayNumber='1' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|}} - 0}}'|format=template|template=schtable}}
 
{{#cargo_query: table=scheduleFACservice|fields=scheduleFACservice.StaffAbbrev,scheduleFACservice.Color|where=scheduleFELLservice.TaskAbbrev='GYL' AND scheduleFACservice.DayNumber='1' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|}} - 0}}'|format=template|template=schtable}}
 
{{#cargo_query: table=scheduleFACservice|fields=scheduleFACservice.StaffAbbrev,scheduleFACservice.Color|where=scheduleFELLservice.TaskAbbrev='GYS' AND scheduleFACservice.DayNumber='1' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|}} - 0}}'|format=template|template=schtable}}
 
{{#cargo_query: table=scheduleFACservice|fields=scheduleFACservice.StaffAbbrev,scheduleFACservice.Color|where=scheduleFELLservice.TaskAbbrev='HPA' AND scheduleFACservice.DayNumber='1' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|}} - 0}}'|format=template|template=schtable}}
 
{{#cargo_query: table=scheduleFACservice|fields=scheduleFACservice.StaffAbbrev,scheduleFACservice.Color|where=scheduleFELLservice.TaskAbbrev='HPA' AND scheduleFACservice.DayNumber='1' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|}} - 0}}'|format=template|template=schtable}}
 
{{#cargo_query: table=scheduleFACservice|fields=scheduleFACservice.StaffAbbrev,scheduleFACservice.Color|where=scheduleFELLservice.TaskAbbrev='NP' AND scheduleFACservice.DayNumber='1' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|}} - 0}}'|format=template|template=schtable}}
 
{{#cargo_query: table=scheduleFACservice|fields=scheduleFACservice.StaffAbbrev,scheduleFACservice.Color|where=scheduleFELLservice.TaskAbbrev='OB' AND scheduleFACservice.DayNumber='1' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|}} - 0}}'|format=template|template=schtable}}
 
{{#cargo_query: table=scheduleFACservice|fields=scheduleFACservice.StaffAbbrev,scheduleFACservice.Color|where=scheduleFELLservice.TaskAbbrev='PP' AND scheduleFACservice.DayNumber='1' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|}} - 0}}'|format=template|template=schtable}}
 
{{#cargo_query: table=scheduleFACservice|fields=scheduleFACservice.StaffAbbrev,scheduleFACservice.Color|where=scheduleFELLservice.TaskAbbrev='RP' AND scheduleFACservice.DayNumber='1' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|}} - 0}}'|format=template|template=schtable}}
 
{{#cargo_query: table=scheduleFACservice|fields=scheduleFACservice.StaffAbbrev,scheduleFACservice.Color|where=scheduleFELLservice.TaskAbbrev='RP' AND scheduleFACservice.DayNumber='1' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|}} - 0}}'|format=template|template=schtable}}
 
 
</td>
 
</td>
 
+
<td style="width: 8%">
      <td style="width: 10%">
+
<table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>'''{{ColorText|{{#tip-text:A|Attending}}||#000000|}}'''</center></td></tr></table>
&nbsp;
+
{{#arraymap: AUT,BR1,BR2,BST,CV,CA,CB,CC,DPA,DPB,DPC,Frozen Section,HN1,HN2,GI1,GI2,GI3,GUL,GUS,GYL,GYS,HPA,HPB,NP,OB,PP,RP|,|TaskAbbreviation|
{{#cargo_query:
+
{{#cargo_query: table=scheduleFACservice  
tables=scheduleFACservice
+
|fields=scheduleFACservice.StaffAbbrev,scheduleFACservice.Color,scheduleFACservice.StaffFullName
|fields=scheduleFACservice.StaffAbbrev=Faculty
+
|where=scheduleFACservice.TaskAbbrev='TaskAbbreviation' AND scheduleFACservice.DayNumber='6' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|}} - 0}}'
|where=scheduleFACservice.DayNumber='3' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|}} - 0}}'
+
|default={{:schtableempty}}|format=template|template=schtable}}
|format=template|template=schtableAUT
+
|}}
|order by=scheduleFACservice.TaskAbbrev ASC
 
}}
 
 
</td>
 
</td>
      <td style="width: 10%">
+
<td style="width: 8%">
&nbsp;
+
<table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>'''{{ColorText|{{#tip-text:A|Attending}}||#000000|}}'''</center></td></tr></table>
{{#cargo_query:
+
{{#arraymap: AUT,BR1,BR2,BST,CV,CA,CB,CC,DPA,DPB,DPC,Frozen Section,HN1,HN2,GI1,GI2,GI3,GUL,GUS,GYL,GYS,HPA,HPB,NP,OB,PP,RP|,|TaskAbbreviation|
tables=scheduleFACservice
+
{{#cargo_query: table=scheduleFACservice  
|fields=scheduleFACservice.StaffAbbrev=Faculty
+
|fields=scheduleFACservice.StaffAbbrev,scheduleFACservice.Color,scheduleFACservice.StaffFullName
|where=scheduleFACservice.DayNumber='3' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|}} - 0}}'
+
|where=scheduleFACservice.TaskAbbrev='TaskAbbreviation' AND scheduleFACservice.DayNumber='7' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|}} - 0}}'
|format=template|template=schtableAUT
+
|default={{:schtableempty}}|format=template|template=schtable}}
|order by=scheduleFACservice.TaskAbbrev ASC
+
|}}
}}
 
 
</td>
 
</td>
      <td style="width: 10%">
+
<td style="width: 5%">
&nbsp;
+
<table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>'''{{ColorText|{{#tip-text:R|Resident}}||#636363|}}'''</center></td></tr></table>
{{#cargo_query:
+
{{#arraymap: AUT,BR1,BR2,BST,CV,CA,CB,CC,DPA,DPB,DPC,FS,HN1,HN2,GI1,GI2,GI3,GUL,GUS,GYL,GYS,HPA,HPB,NP,OB,PP,RP,AP CHIEF,FS-S,FS-J,GR-S|,|TaskAbbreviation|
tables=scheduleFACservice
+
{{#cargo_query: tables=scheduleRESservicenextweek,residentMGH
|fields=scheduleFACservice.StaffAbbrev=Faculty
+
|join on=scheduleRESservicenextweek.ResAbbrev=residentMGH.copath_id
|where=scheduleFACservice.DayNumber='4' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|}} - 0}}'
+
|fields=scheduleRESservicenextweek.ResAbbrev,scheduleRESservicenextweek.Color,residentMGH.full_name
|format=template|template=schtableAUT
+
|where=scheduleRESservicenextweek.WeekNumber='{{#expr: {{#time: W|}} + 1 }}' AND scheduleRESservicenextweek.TaskAbbrev='TaskAbbreviation'|default={{:schtableempty}}|format=template|template=schtablenextweek}}
|order by=scheduleFACservice.TaskAbbrev ASC
+
|}}
}}
 
 
</td>
 
</td>
      <td style="width: 10%">
+
<td style="width: 5%">
&nbsp;
+
<table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>'''{{ColorText|{{#tip-text:F|Fellow}}||#636363|}}'''</center></td></tr></table>
{{#cargo_query:
+
{{#arraymap: AUT,BR1,BR2,BST,CV,CA,CB,CC,DPA,DPB,DPC,FS,HN1,HN2,GI1,GI2,GI3,GUL,GUS,GYL,GYS,HPA,HPB,NP,OB,PP,RP|,|TaskAbbreviation|
tables=scheduleFACservice
+
{{#cargo_query: tables=scheduleFELLservicenextweek,residentMGH
|fields=scheduleFACservice.StaffAbbrev=Faculty
+
|join on=scheduleFELLservicenextweek.FellAbbrev=residentMGH.copath_id
|where=scheduleFACservice.DayNumber='3' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|}} - 0}}'
+
|fields=scheduleFELLservicenextweek.FellAbbrev,scheduleFELLservicenextweek.Color,residentMGH.full_name
|format=template|template=schtableAUT
+
|where=scheduleFELLservicenextweek.WeekNumber='{{#expr: {{#time: W|}} + 1 }}' AND scheduleFELLservicenextweek.TaskAbbrev='TaskAbbreviation' |format=template|template=schtablenextweek}}
|order by=scheduleFACservice.TaskAbbrev ASC
+
|}}
}}
 
 
</td>
 
</td>
      <td style="width: 10%">
+
<td style="width: 8%">
&nbsp;
+
<table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>'''{{ColorText|{{#tip-text:A|Attending}}||#636363|}}'''</center></td></tr></table>
{{#cargo_query:
+
{{#arraymap: AUT,BR1,BR2,BST,CV,CA,CB,CC,DPA,DPB,DPC,Frozen Section,HN1,HN2,GI1,GI2,GI3,GUL,GUS,GYL,GYS,HPA,HPB,NP,OB,PP,RP|,|TaskAbbreviation|
tables=scheduleFACservice
+
{{#cargo_query: table=scheduleFACservice  
|fields=scheduleFACservice.StaffAbbrev=Faculty
+
|fields=scheduleFACservice.StaffAbbrev,scheduleFACservice.Color,scheduleFACservice.StaffFullName
|where=scheduleFACservice.DayNumber='3' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|}} - 0}}'
+
|where=scheduleFACservice.TaskAbbrev='TaskAbbreviation' AND scheduleFACservice.DayNumber='1' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|}} + 1}}'
|format=template|template=schtableAUT
+
|default={{:schtableempty}}|format=template|template=schtablenextweek}}
|order by=scheduleFACservice.TaskAbbrev ASC
+
|}}
}}
 
 
</td>
 
</td>
      <td style="width: 10%">
+
<td style="width: 8%">
&nbsp;
+
<table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>'''{{ColorText|{{#tip-text:A|Attending}}||#636363|}}'''</center></td></tr></table>
{{#cargo_query:
+
{{#arraymap: AUT,BR1,BR2,BST,CV,CA,CB,CC,DPA,DPB,DPC,Frozen Section,HN1,HN2,GI1,GI2,GI3,GUL,GUS,GYL,GYS,HPA,HPB,NP,OB,PP,RP|,|TaskAbbreviation|
tables=scheduleFACservice
+
{{#cargo_query: table=scheduleFACservice  
|fields=scheduleFACservice.StaffAbbrev=Faculty
+
|fields=scheduleFACservice.StaffAbbrev,scheduleFACservice.Color,scheduleFACservice.StaffFullName
|where=scheduleFACservice.DayNumber='3' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|}} - 0}}'
+
|where=scheduleFACservice.TaskAbbrev='TaskAbbreviation' AND scheduleFACservice.DayNumber='2' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|}} + 1}}'
|format=template|template=schtableAUT
+
|default={{:schtableempty}}|format=template|template=schtablenextweek}}
|order by=scheduleFACservice.TaskAbbrev ASC
+
|}}
}}
 
 
</td>
 
</td>
    </tr>
+
</tr>
 
</table>
 
</table>
 +
</div>
 +
<hr><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></center>

Latest revision as of 15:12, August 29, 2019


 

2026: Week 18
2026: Week 19

 

Mon-Fri

Monday
Apr 27

Monday
Apr 27

Tuesday
Apr 28

Tuesday
Apr 28

Wednesday
Apr 29

Wednesday
Apr 29

Thursday
May 01

Thursday
Apr 30

Thursday
Apr 30

Friday
May 02

Friday
May 01

Friday
May 01

Saturday
May 03

Saturday
May 02

Sunday
May 04

Sunday
May 03

Mon-Fri

Mon,
May 05Mon,
May 05Mon,
May 04Mon,
May 04

Tue,
May 06Tue,
May 06Tue,
May 05Tue,
May 05

SERVICE
AUT
BR1
BR2
BST
CV
CA
CB
CC
DPA
DPB
DPC
FS
HN1
HN2
GI1
GI2
GI3
GU1
GU2
GYL
GYS
HPA
HPB
NP
OB
PP
RP
Chief
FS-S
FS-J
GR-S


VAC
R
KOA
KOA
KOA
KOA
KOA
NXT
NXT
NXT
NXT
NXT
RAK
RAK
RAK
RAK
RAK
REN
REN
REN
REN
REN
SAN
SAN
SAN
SAN
SAN
ANT
ANT
ANT
ANT
ANT
EAD
EAD
EAD
EAD
EAD
BBC
BBC
BBC
BBC
BBC
EKP
EKP
EKP
EKP
EKP
CQC
CQC
CQC
CQC
CQC
DJH
DJH
DJH
DJH
DJH
NXT
NXT
NXT
NXT
NXT
FXR
FXR
FXR
FXR
FXR
NEA
NEA
NEA
NEA
NEA
PDG
PDG
PDG
PDG
PDG
MAB
MAB
MAB
MAB
MAB
BBK
BBK
BBK
BBK
BBK
FNS
FNS
FNS
FNS
FNS
JOS
JOS
JOS
JOS
JOS
FXR
FXR
FXR
FXR
FXR
-
-
BRC
BRC
BRC
BRC
BRC
MDR
MDR
MDR
MDR
MDR
ELY
ELY
ELY
ELY
ELY
LHV
LHV
LHV
LHV
LHV
-
-
OPA
OPA
OPA
OPA
OPA
-
-
KZL
KZL
KZL
KZL
KZL
VZA
VZA
VZA
VZA
VZA
STG
STG
STG
STG
STG
NAP
NAP
NAP
NAP
NAP
EAD
EAD
EAD
EAD
EAD
EXE
EXE
EXE
EXE
EXE
RAK
RAK
RAK
RAK
RAK
GEO
GEO
GEO
GEO
GEO
SFA
SFA
SFA
SFA
SFA
VZA
VZA
VZA
VZA
VZA
JEH
JEH
JEH
JEH
JEH
FXR
FXR
FXR
FXR
FXR
NEA
NEA
NEA
NEA
NEA
PDG
PDG
PDG
PDG
PDG
AUO
AUO
AUO
AUO
AUO
LPR
LPR
LPR
LPR
LPR
PDG
PDG
PDG
PDG
PDG
-
-
-
F
No resultsNo resultsNo resultsNo resultsNo results
DLD
DLD
DLD
DLD
DLD
MAZ
MAZ
MAZ
MAZ
MAZ
RUH
RUH
RUH
RUH
RUH
No results
MSU
MSU
MSU
MSU
MSU
QUR
QUR
QUR
QUR
QUR
No resultsNo resultsNo resultsNo resultsNo resultsNo resultsNo resultsNo resultsNo resultsNo results
VZA
VZA
VZA
VZA
VZA
No resultsNo results
AKE
AKE
AKE
AKE
AKE
EZR
EZR
EZR
EZR
EZR
VZA
VZA
VZA
VZA
VZA
No resultsNo results
A[1]
-
Ly
Ly
Jo
-
-
A
-
Ly
Ly
Jo
-
-
A
-
Ly
Ly
Jo
-
-
A
-
Ly
Ly
Ly
Ly
Jo
-
-
A
-
Ly
Ly
Ly
Ly
Jo
-
-
A
Ly
Ly
-
Ly
Ly
Ly
-
-
-
A
Ly
Ly
-
Ly
Ly
Ly
-
-
-
R
Error: Table scheduleRESservicenextweek not found.
Error: Table scheduleRESservicenextweek not found.
Error: Table scheduleRESservicenextweek not found.
Error: Table scheduleRESservicenextweek not found.
Error: Table scheduleRESservicenextweek not found.
Error: Table scheduleRESservicenextweek not found.
Error: Table scheduleRESservicenextweek not found.
Error: Table scheduleRESservicenextweek not found.
Error: Table scheduleRESservicenextweek not found.
Error: Table scheduleRESservicenextweek not found.
Error: Table scheduleRESservicenextweek not found.
Error: Table scheduleRESservicenextweek not found.
Error: Table scheduleRESservicenextweek not found.
Error: Table scheduleRESservicenextweek not found.
Error: Table scheduleRESservicenextweek not found.
Error: Table scheduleRESservicenextweek not found.
Error: Table scheduleRESservicenextweek not found.
Error: Table scheduleRESservicenextweek not found.
Error: Table scheduleRESservicenextweek not found.
Error: Table scheduleRESservicenextweek not found.
Error: Table scheduleRESservicenextweek not found.
Error: Table scheduleRESservicenextweek not found.
Error: Table scheduleRESservicenextweek not found.
Error: Table scheduleRESservicenextweek not found.
Error: Table scheduleRESservicenextweek not found.
Error: Table scheduleRESservicenextweek not found.
Error: Table scheduleRESservicenextweek not found.
Error: Table scheduleRESservicenextweek not found.
Error: Table scheduleRESservicenextweek not found.
Error: Table scheduleRESservicenextweek not found.
Error: Table scheduleRESservicenextweek not found.
F
Error: Table scheduleFELLservicenextweek not found.
Error: Table scheduleFELLservicenextweek not found.
Error: Table scheduleFELLservicenextweek not found.
Error: Table scheduleFELLservicenextweek not found.
Error: Table scheduleFELLservicenextweek not found.
Error: Table scheduleFELLservicenextweek not found.
Error: Table scheduleFELLservicenextweek not found.
Error: Table scheduleFELLservicenextweek not found.
Error: Table scheduleFELLservicenextweek not found.
Error: Table scheduleFELLservicenextweek not found.
Error: Table scheduleFELLservicenextweek not found.
Error: Table scheduleFELLservicenextweek not found.
Error: Table scheduleFELLservicenextweek not found.
Error: Table scheduleFELLservicenextweek not found.
Error: Table scheduleFELLservicenextweek not found.
Error: Table scheduleFELLservicenextweek not found.
Error: Table scheduleFELLservicenextweek not found.
Error: Table scheduleFELLservicenextweek not found.
Error: Table scheduleFELLservicenextweek not found.
Error: Table scheduleFELLservicenextweek not found.
Error: Table scheduleFELLservicenextweek not found.
Error: Table scheduleFELLservicenextweek not found.
Error: Table scheduleFELLservicenextweek not found.
Error: Table scheduleFELLservicenextweek not found.
Error: Table scheduleFELLservicenextweek not found.
Error: Table scheduleFELLservicenextweek not found.
Error: Table scheduleFELLservicenextweek not found.
A
Dannheim
Stone
Bossuyt
Dillon
Lerwill
Lester
Bachert
Guidi
Turashvili
Anderson
Hung
Nielsen
Papke
-
Gedik
Madrigal
Ly
Madrigal
Torous
Zhang
Moran
Foreman
Hoang
Laga Canales
Foreman
Hoang
Drage
Oliva
Alzumaili
Fisch
Fisch
Jo
Alzumaili
Faquin
Agoston
Caldwell
Goldsmith
Pitman
Elliott
Liu
Shih
Shroff
Drage
Glickman
-
-
Devins
Young
Hsu-Lin
Oliva
Ferry
Hasserjian
Ferry
Louissaint
Martinez-Lage
Stemmer-Rach
Hsu-Lin
Patalas
Hariri
Mino-Kenudson
Avillach
Smith
A
Dannheim
Stone
Bossuyt
Dillon
Lerwill
Lester
Bachert
Guidi
Turashvili
Anderson
Hung
Nielsen
Papke
-
Gedik
Madrigal
Ly
Madrigal
Torous
Zhang
Moran
Foreman
Hoang
Laga Canales
Foreman
Hoang
Drage
Oliva
Alzumaili
Fisch
Fisch
Jo
Alzumaili
Faquin
Agoston
Caldwell
Goldsmith
Pitman
Elliott
Liu
Shih
Shroff
Drage
Glickman
-
-
Devins
Young
Hsu-Lin
Oliva
Ferry
Hasserjian
Ferry
Louissaint
Martinez-Lage
Stemmer-Rach
Hsu-Lin
Patalas
Hariri
Mino-Kenudson
Avillach
Smith

  1. The faculty service schedule is displayed on this page using the QGenda API. For any discrepancies or to view the full schedule click here.