Difference between revisions of "Weekly Schedule"

From MGH Learn Pathology
 
(64 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=scheduleFACservice.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=scheduleFACservice.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=scheduleFACservice.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=scheduleFACservice.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=scheduleFACservice.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=scheduleFACservice.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=scheduleFACservice.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=scheduleFACservice.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=scheduleFACservice.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=scheduleFACservice.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=scheduleFACservice.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=scheduleFACservice.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=scheduleFACservice.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=scheduleFACservice.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=scheduleFACservice.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=scheduleFACservice.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=scheduleFACservice.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=scheduleFACservice.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=scheduleFACservice.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=scheduleFACservice.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=scheduleFACservice.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=scheduleFACservice.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=scheduleFACservice.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=scheduleFACservice.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=scheduleFACservice.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=scheduleFACservice.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=scheduleFACservice.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=scheduleFACservice.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 12
2026: Week 13

 

Mon-Fri

Monday
Mar 17

Monday
Mar 17

Monday
Mar 16

Monday
Mar 16

Tuesday
Mar 18

Tuesday
Mar 18

Tuesday
Mar 17

Tuesday
Mar 17

Wednesday
Mar 19

Wednesday
Mar 19

Wednesday
Mar 18

Wednesday
Mar 18

Thursday
Mar 20

Thursday
Mar 20

Thursday
Mar 19

Thursday
Mar 19

Friday
Mar 21

Friday
Mar 21

Friday
Mar 20

Friday
Mar 20

Saturday
Mar 22

Saturday
Mar 21

Sunday
Mar 23

Sunday
Mar 22

Mon-Fri

Mon,
Mar 24Mon,
Mar 24Mon,
Mar 23Mon,
Mar 23

Tue,
Mar 25Tue,
Mar 25Tue,
Mar 24Tue,
Mar 24

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
DEM
DEM
DEM
DEM
DEM
HUA
HUA
HUA
HUA
HUA
JMD
JMD
JMD
JMD
JMD
SAN
SAN
SAN
SAN
SAN
MDR
MDR
MDR
MDR
MDR
TYY
TYY
TYY
TYY
TYY
VZA
VZA
VZA
VZA
VZA
KZL
KZL
KZL
KZL
KZL
AAW
AAW
AAW
AAW
AAW
NCK
NCK
NCK
NCK
NCK
NEA
NEA
NEA
NEA
NEA
SFA
SFA
SFA
SFA
SFA
ANT
ANT
ANT
ANT
ANT
EAD
EAD
EAD
EAD
EAD
LHV
LHV
LHV
LHV
LHV
RRA
RRA
RRA
RRA
RRA
BLF
BLF
BLF
BLF
BLF
-
AKE
AKE
AKE
AKE
AKE
BRC
BRC
BRC
BRC
BRC
RGJ
RGJ
RGJ
RGJ
RGJ
-
-
ATE
ATE
ATE
ATE
ATE
BBK
BBK
BBK
BBK
BBK
PDG
PDG
PDG
PDG
PDG
RSC
RSC
RSC
RSC
RSC
RSC
RSC
RSC
RSC
RSC
NXT
NXT
NXT
NXT
NXT
-
FXR
FXR
FXR
FXR
FXR
-
-
-
EKP
EKP
EKP
EKP
EKP
LCC
LCC
LCC
LCC
LCC
-
PDG
PDG
PDG
PDG
PDG
ELY
ELY
ELY
ELY
ELY
MUS
MUS
MUS
MUS
MUS
YQG
YQG
YQG
YQG
YQG
MAB
MAB
MAB
MAB
MAB
CQC
CQC
CQC
CQC
CQC
ELY
ELY
ELY
ELY
ELY
RNS
RNS
RNS
RNS
RNS
ANT
ANT
ANT
ANT
ANT
EAD
EAD
EAD
EAD
EAD
LPR
LPR
LPR
LPR
LPR
TMS
TMS
TMS
TMS
TMS
-
-
-
F
No results
VZA
VZA
VZA
VZA
VZA
SSB
SSB
SSB
SSB
SSB
No resultsNo results
KWA
KWA
KWA
KWA
KWA
No results
OHA
OHA
OHA
OHA
OHA
No results
EHA
EHA
EHA
EHA
EHA
SJB
SJB
SJB
SJB
SJB
No resultsNo resultsNo resultsNo resultsNo resultsNo resultsNo resultsNo resultsNo resultsNo resultsNo resultsNo resultsNo results
EZR
EZR
EZR
EZR
EZR
No resultsNo resultsNo results
A[1]
-
Ly
Ly
Jo
Jo
-
-
A
-
Ly
Ly
Jo
Jo
-
-
A
-
Ly
Ly
Lu
Jo
Jo
-
-
A
-
Ly
Ly
Jo
Jo
-
-
A
Jo
-
Ly
Ly
Jo
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
Brackett
Patalas
Lester
Lester
Ly
Ly
Bachert
Guidi
Lerwill
Lester
Anderson
Hartsough
Nielsen
Nielsen
-
Madrigal
Pitman
Madrigal
Pitman
Chebib
Torous
Foreman
Hoang
Duncan
Hanna
Hoang
Murphy
Bulterys
Duncan
Drage
Glickman
Sadow
Sadow
Wong
Wong
Sadow
Elliott
Glickman
Goldsmith
Pitman
Chen
Drage
Turner
Zhang
Drage
Shroff
-
-
Young
Young
Oliva
Oliva
Nardi
Sohani
Ferry
Louissaint
Frosch
Frosch
Dannheim
Hung
Mino-Kenudson
Avillach
Klepeis
A
Brackett
Patalas
Lester
Lester
Ly
Ly
Bachert
Guidi
Lerwill
Lester
Anderson
Hartsough
Nielsen
Nielsen
-
Madrigal
Pitman
Madrigal
Pitman
Chebib
Torous
Foreman
Hoang
Duncan
Hanna
Hoang
Murphy
Bulterys
Duncan
Drage
Glickman
Faquin
Sadow
Wong
Wong
Sadow
Elliott
Goldsmith
OPEN
Pitman
Chen
Glickman
Turner
Zhang
Drage
Shroff
-
-
Young
Young
Oliva
Oliva
Nardi
Sohani
Ferry
Louissaint
Frosch
Oakley
Dannheim
Hung
Mino-Kenudson
Avillach
Klepeis

  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.