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 14:12, August 29, 2019


 

2026: Week 5
2026: Week 6

 

Mon-Fri

Monday
Jan 26

Monday
Jan 26

Tuesday
Jan 27

Tuesday
Jan 27

Wednesday
Jan 29

Wednesday
Jan 29

Wednesday
Jan 28

Wednesday
Jan 28

Thursday
Jan 30

Thursday
Jan 30

Thursday
Jan 29

Thursday
Jan 29

Friday
Jan 31

Friday
Jan 31

Friday
Jan 30

Friday
Jan 30

Saturday
Feb 01

Saturday
Jan 31

Sunday
Feb 02

Sunday
Feb 01

Mon-Fri

Mon,
Feb 03Mon,
Feb 02Mon,
Feb 02

Tue,
Feb 04Tue,
Feb 03Tue,
Feb 03

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
GEO
GEO
GEO
GEO
GEO
KOA
KOA
KOA
KOA
KOA
MUS
MUS
MUS
MUS
MUS
OPA
OPA
OPA
OPA
OPA
PHI
PHI
PHI
PHI
PHI
RAK
RAK
RAK
RAK
RAK
BRC
BRC
BRC
BRC
BRC
FXR
FXR
FXR
FXR
FXR
SFA
SFA
SFA
SFA
SFA
NEA
NEA
NEA
NEA
NEA
AUO
AUO
AUO
AUO
AUO
BBK
BBK
BBK
BBK
BBK
KSH
KSH
KSH
KSH
KSH
RXN
RXN
RXN
RXN
RXN
YQG
YQG
YQG
YQG
YQG
EKP
EKP
EKP
EKP
EKP
SAN
SAN
SAN
SAN
SAN
MCH
MCH
MCH
MCH
MCH
-
MDR
MDR
MDR
MDR
MDR
BKV
BKV
BKV
BKV
BKV
-
-
ABE
ABE
ABE
ABE
ABE
JEH
JEH
JEH
JEH
JEH
MCH
MCH
MCH
MCH
MCH
JPB
JPB
JPB
JPB
JPB
JPB
JPB
JPB
JPB
JPB
STO
STO
STO
STO
STO
DSV
DSV
DSV
DSV
DSV
RRA
RRA
RRA
RRA
RRA
KMA
KMA
KMA
KMA
KMA
-
-
NXT
NXT
NXT
NXT
NXT
AKE
AKE
AKE
AKE
AKE
JSW
JSW
JSW
JSW
JSW
LHV
LHV
LHV
LHV
LHV
FXR
FXR
FXR
FXR
FXR
RLD
RLD
RLD
RLD
RLD
BBK
BBK
BBK
BBK
BBK
DEM
DEM
DEM
DEM
DEM
EKP
EKP
EKP
EKP
EKP
ELY
ELY
ELY
ELY
ELY
PHI
PHI
PHI
PHI
PHI
REN
REN
REN
REN
REN
RSC
RSC
RSC
RSC
RSC
AKE
AKE
AKE
AKE
AKE
LCC
LCC
LCC
LCC
LCC
TYY
TYY
TYY
TYY
TYY
EKP
EKP
EKP
EKP
EKP
SAN
SAN
SAN
SAN
SAN
BBC
BBC
BBC
BBC
BBC
LHV
LHV
LHV
LHV
LHV
LYU
LYU
LYU
LYU
LYU
-
-
-
F
No resultsNo results
SSB
SSB
SSB
SSB
SSB
No resultsNo results
OHA
OHA
OHA
OHA
OHA
KWA
KWA
KWA
KWA
KWA
No results
EHA
EHA
EHA
EHA
EHA
SJB
SJB
SJB
SJB
SJB
No resultsNo resultsNo resultsNo resultsNo resultsNo resultsNo resultsNo resultsNo resultsNo resultsNo results
HUK
HUK
HUK
HUK
HUK
RGJ
RGJ
RGJ
RGJ
RGJ
No results
EZR
EZR
EZR
EZR
EZR
No resultsNo resultsNo results
A[1]
Jo
-
Ly
Lu
-
-
A
Jo
-
Ly
Lu
-
-
A
Ly
Jo
-
Ly
Lu
-
-
A
Ly
Jo
Jo
-
Ly
-
-
A
Ly
Jo
Jo
-
Ly
-
-
A
Ly
Ly
Ly
Ly
-
Ly
Ly
Ly
-
-
-
A
Ly
Ly
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
Patalas
Hong
Lerwill
Turashvili
Dillon
Dillon
Guidi
Ly
Anderson
Chebib
Chebib
Jo
-
Madrigal
Torous
Madrigal
Torous
Madrigal
Pitman
Foreman
Hoang
Duncan
Murphy
Bulterys
Nazarian
Drage
Drage
Faquin
Faquin
Jo
Wong
Fisch
Sadow
Drage
Turner
Zhang
Zhao_Lei
Hornick
Liu
Shih
Zhang
Drage
Shih
-
-
Devins
Turashvili
Devins
Oliva
Dannheim
Nardi
Sohani
Ferry
Nardi
Yuen
Frosch
Stemmer-Rach
Dannheim
Hsu-Lin
Hung
Mino-Kenudson
Avillach
Avillach
A
Dannheim
Patalas
Hong
Lerwill
Turashvili
Dillon
Dillon
Guidi
Ly
Anderson
Chebib
Chebib
Jo
-
Madrigal
Torous
Madrigal
Torous
Madrigal
Pitman
Foreman
Hoang
Duncan
Murphy
Bulterys
Nazarian
Drage
Drage
Faquin
Faquin
Jo
Wong
Fisch
Sadow
Drage
Turner
Zhang
Zhao_Lei
Hornick
Liu
Shih
Zhang
Drage
Shih
-
-
Devins
Turashvili
Devins
Oliva
Dannheim
Nardi
Sohani
Ferry
Nardi
Yuen
Oakley
Oakley
Dannheim
Hsu-Lin
Hung
Mino-Kenudson
Avillach
Avillach

  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.