Difference between revisions of "NextWeekConfCall"

From MGH Learn Pathology
 
(8 intermediate revisions by the same user not shown)
Line 2: Line 2:
 
<tr>
 
<tr>
 
<td style="width: 14%">
 
<td style="width: 14%">
{{#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=datedisplayfac}}
+
{{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=scheduleFACservice.DayNumber='1' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|{{Timezone}}}} + 1 }}' AND scheduleFACservice.TaskAbbrev='BR1' |format=template|template=datedisplayfac}}
 
</td>
 
</td>
 
<td style="width: 14%">
 
<td style="width: 14%">
{{#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=datedisplayfac}}
+
{{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=scheduleFACservice.DayNumber='2' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|{{Timezone}}}} + 1 }}' AND scheduleFACservice.TaskAbbrev='BR1' |format=template|template=datedisplayfac}}
 
</td>
 
</td>
 
<td style="width: 14%">
 
<td style="width: 14%">
{{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=scheduleFACservice.DayNumber='3' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|}} + 1 }}' AND scheduleFACservice.TaskAbbrev='BR1' |format=template|template=datedisplayfac}}
+
{{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=scheduleFACservice.DayNumber='3' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|{{Timezone}}}} + 1 }}' AND scheduleFACservice.TaskAbbrev='BR1' |format=template|template=datedisplayfac}}
 
</td>
 
</td>
 
<td style="width: 14%">
 
<td style="width: 14%">
{{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=scheduleFACservice.DayNumber='4' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|}} + 1 }}' AND scheduleFACservice.TaskAbbrev='BR1' |format=template|template=datedisplayfac}}
+
{{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=scheduleFACservice.DayNumber='4' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|{{Timezone}}}} + 1 }}' AND scheduleFACservice.TaskAbbrev='BR1' |format=template|template=datedisplayfac}}
 
</td>
 
</td>
 
<td style="width: 14%">
 
<td style="width: 14%">
{{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=scheduleFACservice.DayNumber='5' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|}} + 1 }}' AND scheduleFACservice.TaskAbbrev='BR1' |format=template|template=datedisplayfac}}
+
{{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=scheduleFACservice.DayNumber='5' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|{{Timezone}}}} + 1 }}' AND scheduleFACservice.TaskAbbrev='BR1' |format=template|template=datedisplayfac}}
 
</td>
 
</td>
 
<td style="width: 14%">
 
<td style="width: 14%">
{{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=scheduleFACservice.DayNumber='6' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|}} + 1 }}' AND scheduleFACservice.TaskAbbrev='BR1' |format=template|template=datedisplayfac}}
+
{{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=scheduleFACservice.DayNumber='6' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|{{Timezone}}}} + 1 }}' AND scheduleFACservice.TaskAbbrev='BR1' |format=template|template=datedisplayfac}}
 
</td>
 
</td>
 
<td style="width: 14%">
 
<td style="width: 14%">
{{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=scheduleFACservice.DayNumber='7' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|}} + 1 }}' AND scheduleFACservice.TaskAbbrev='BR1' |format=template|template=datedisplayfac}}
+
{{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=scheduleFACservice.DayNumber='7' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|{{Timezone}}}} + 1 }}' AND scheduleFACservice.TaskAbbrev='BR1' |format=template|template=datedisplayfac}}
 
</td>
 
</td>
 
</tr>
 
</tr>
Line 30: Line 30:
 
     |where=conference.weeknumber='{{#expr: {{#time: W|{{Timezone}}}} + 1 }}' AND conference.daynumber='1'|default={{:schtableempty}}
 
     |where=conference.weeknumber='{{#expr: {{#time: W|{{Timezone}}}} + 1 }}' AND conference.daynumber='1'|default={{:schtableempty}}
 
     |format=template|order by = sort ASC|template=schtableconfcallLeft}}
 
     |format=template|order by = sort ASC|template=schtableconfcallLeft}}
 +
{{#cargo_query: tables=conferenceOuts,facultyMGH
 +
    |join on=conferenceOuts.StaffAbbrev=facultyMGH.copath_id
 +
    |fields=conferenceOuts.StaffAbbrev,conferenceOuts.TaskAbbrev,conferenceOuts.time,facultyMGH.copath_id,facultyMGH.name_last
 +
    |where=conferenceOuts.weeknumber='{{#expr: {{#time: W|{{Timezone}}}} + 1 }}' AND conferenceOuts.daynumber='1'|default={{:schtableempty}}
 +
    |format=template|order by = conferenceOuts.time ASC|template=schtableouts}}
 
</td>
 
</td>
 
<td style="width: 14%">
 
<td style="width: 14%">
Line 37: Line 42:
 
     |where=conference.weeknumber='{{#expr: {{#time: W|{{Timezone}}}} + 1 }}' AND conference.daynumber='2'|default={{:schtableempty}}
 
     |where=conference.weeknumber='{{#expr: {{#time: W|{{Timezone}}}} + 1 }}' AND conference.daynumber='2'|default={{:schtableempty}}
 
     |format=template|order by = sort ASC|template=schtableconfcallLeft}}
 
     |format=template|order by = sort ASC|template=schtableconfcallLeft}}
 +
{{#cargo_query: tables=conferenceOuts,facultyMGH
 +
    |join on=conferenceOuts.StaffAbbrev=facultyMGH.copath_id
 +
    |fields=conferenceOuts.StaffAbbrev,conferenceOuts.TaskAbbrev,conferenceOuts.time=time,facultyMGH.name_first,facultyMGH.name_last
 +
    |where=conferenceOuts.weeknumber='{{#expr: {{#time: W|{{Timezone}}}} + 1 }}' AND conferenceOuts.daynumber='2'|default={{:schtableempty}}
 +
    |format=template|order by = time ASC|template=schtableouts}}
 
</td>
 
</td>
 
<td style="width: 14%">
 
<td style="width: 14%">
Line 44: Line 54:
 
     |where=conference.weeknumber='{{#expr: {{#time: W|{{Timezone}}}} + 1 }}' AND conference.daynumber='3'|default={{:schtableempty}}
 
     |where=conference.weeknumber='{{#expr: {{#time: W|{{Timezone}}}} + 1 }}' AND conference.daynumber='3'|default={{:schtableempty}}
 
     |format=template|order by = sort ASC|template=schtableconfcallLeft}}
 
     |format=template|order by = sort ASC|template=schtableconfcallLeft}}
 +
{{#cargo_query: tables=conferenceOuts,facultyMGH
 +
    |join on=conferenceOuts.StaffAbbrev=facultyMGH.copath_id
 +
    |fields=conferenceOuts.StaffAbbrev,conferenceOuts.TaskAbbrev,conferenceOuts.time=time,facultyMGH.name_first,facultyMGH.name_last
 +
    |where=conferenceOuts.weeknumber='{{#expr: {{#time: W|{{Timezone}}}} + 1 }}' AND conferenceOuts.daynumber='3'|default={{:schtableempty}}
 +
    |format=template|order by = time ASC|template=schtableouts}}
 
</td>
 
</td>
 
<td style="width: 14%">
 
<td style="width: 14%">
Line 58: Line 73:
 
     |where=conference.weeknumber='{{#expr: {{#time: W|{{Timezone}}}} + 1 }}' AND conference.daynumber='5'|default={{:schtableempty}}
 
     |where=conference.weeknumber='{{#expr: {{#time: W|{{Timezone}}}} + 1 }}' AND conference.daynumber='5'|default={{:schtableempty}}
 
     |format=template|order by = sort ASC|template=schtableconfcallLeft}}
 
     |format=template|order by = sort ASC|template=schtableconfcallLeft}}
 +
{{#cargo_query: tables=conferenceOuts,facultyMGH
 +
    |join on=conferenceOuts.StaffAbbrev=facultyMGH.copath_id
 +
    |fields=conferenceOuts.StaffAbbrev,conferenceOuts.TaskAbbrev,conferenceOuts.time=time,facultyMGH.name_first,facultyMGH.name_last
 +
    |where=conferenceOuts.weeknumber='{{#expr: {{#time: W|{{Timezone}}}} + 1 }}' AND conferenceOuts.daynumber='5'|default={{:schtableempty}}
 +
    |format=template|order by = time ASC|template=schtableouts}}
 
</td>
 
</td>
 
<td style="width: 14%">
 
<td style="width: 14%">

Latest revision as of 22:34, September 15, 2019

Monday
Dec 16

Monday
Dec 16

Monday
Dec 15

Monday
Dec 15

Tuesday
Dec 17

Tuesday
Dec 17

Tuesday
Dec 16

Tuesday
Dec 16

Wednesday
Dec 18

Wednesday
Dec 18

Wednesday
Dec 17

Wednesday
Dec 17

Thursday
Dec 19

Thursday
Dec 19

Thursday
Dec 18

Thursday
Dec 18

Friday
Dec 20

Friday
Dec 20

Friday
Dec 19

Friday
Dec 19

Saturday
Dec 21

Saturday
Dec 20

Sunday
Dec 22

Sunday
Dec 21

Call: Senior - NDA
Daniel Shepherd - DAN
🥣 - Roll the dice!
Mingjuan Zhang - LZH
EYE: DRY @ 12:00 PM
No PDF
Melissa Krystel-Whittemore - MKW
Daniel Shepherd - DAN
🥣 - J. Pace's
Daniel Shepherd - DAN
OB: DRU @ 12:00 PM
No PDF
Andrew Crabbe - CRB
Cynthia Harris - CYN
🥣 - India Quality
GI: ASH @ 12:00 PM
No PDF
HP: RPH @ 12:30 PM
No PDF
Aida Valencia-Guerrero - AID
Elisabeth Tabb - TAB
🥣 - King and I
Call: Senior - KRT
Michael Astudillo - AST
🥣 - Dave's Pasta
Cynthia Harris - CYN
CYT: IAC @ 12:00 PM
No PDF
BST: VDE @ 12:30 PM
No PDF
Call: Senior - KRT
Julian Villalba - VIL
Leif Helland - TLH
Call: Senior - KRT
Julian Villalba - VIL
Leif Helland - TLH