Difference between revisions of "CurrentWeekConfCall"

From MGH Learn Pathology
(Created page with "<table class='table borderless'> <tr> <td colspan="1"> {{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=scheduleFACservice.DayNumber='1' AND sc...")
 
 
(17 intermediate revisions by the same user not shown)
Line 1: Line 1:
 
<table class='table borderless'>
 
<table class='table borderless'>
 
<tr>
 
<tr>
−
<td colspan="1">
+
<td style="width: 14%">
−
{{#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}}
+
{{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=YEAR(Date)={{#time: Y|{{Timezone}}}} AND scheduleFACservice.DayNumber='1' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|{{Timezone}}}} - 0 }}' AND scheduleFACservice.TaskAbbrev='BR1' |format=template|template=datedisplayfac}}
 
</td>
 
</td>
−
<td colspan="1">
+
<td style="width: 14%">
−
{{#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}}
+
{{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=YEAR(Date)={{#time: Y|{{Timezone}}}} AND scheduleFACservice.DayNumber='2' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|{{Timezone}}}} - 0 }}' AND scheduleFACservice.TaskAbbrev='BR1' |format=template|template=datedisplayfac}}
 
</td>
 
</td>
−
<td colspan="1">
+
<td style="width: 14%">
−
{{#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}}
+
{{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=YEAR(Date)={{#time: Y|{{Timezone}}}} AND scheduleFACservice.DayNumber='3' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|{{Timezone}}}} - 0 }}' AND scheduleFACservice.TaskAbbrev='BR1' |format=template|template=datedisplayfac}}
 
</td>
 
</td>
−
<td colspan="1">
+
<td style="width: 14%">
−
{{#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}}
+
{{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=YEAR(Date)={{#time: Y|{{Timezone}}}} AND scheduleFACservice.DayNumber='4' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|{{Timezone}}}} - 0 }}' AND scheduleFACservice.TaskAbbrev='BR1' |format=template|template=datedisplayfac}}
 
</td>
 
</td>
−
<td colspan="1">
+
<td style="width: 14%">
−
{{#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}}
+
{{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=YEAR(Date)={{#time: Y|{{Timezone}}}} AND scheduleFACservice.DayNumber='5' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|{{Timezone}}}} - 0 }}' AND scheduleFACservice.TaskAbbrev='BR1' |format=template|template=datedisplayfac}}
 
</td>
 
</td>
−
<td colspan="1">
+
<td style="width: 14%">
−
{{#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}}
+
{{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=YEAR(Date)={{#time: Y|{{Timezone}}}} AND scheduleFACservice.DayNumber='6' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|{{Timezone}}}} - 0 }}' AND scheduleFACservice.TaskAbbrev='BR1' |format=template|template=datedisplayfac}}
 
</td>
 
</td>
−
<td colspan="1">
+
<td style="width: 14%">
−
{{#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}}
+
{{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=YEAR(Date)={{#time: Y|{{Timezone}}}} AND scheduleFACservice.DayNumber='7' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|{{Timezone}}}} - 0 }}' AND scheduleFACservice.TaskAbbrev='BR1' |format=template|template=datedisplayfac}}
 
</td>
 
</td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
−
<td colspan="1">
+
<td style="width: 14%">
 
{{#cargo_query: tables=conference,residentMGH  
 
{{#cargo_query: tables=conference,residentMGH  
 
     |join on=conference.presenter=residentMGH.copath_id
 
     |join on=conference.presenter=residentMGH.copath_id
−
     |fields=conference.presenter,conference.color,residentMGH.full_name,conference.conference
+
     |fields=conference.presenter,conference.color,residentMGH.full_name,conference.conference,conference.sort=sort
 
     |where=conference.weeknumber='{{#expr: {{#time: W|{{Timezone}}}} - 0 }}' AND conference.daynumber='1'|default={{:schtableempty}}
 
     |where=conference.weeknumber='{{#expr: {{#time: W|{{Timezone}}}} - 0 }}' AND conference.daynumber='1'|default={{:schtableempty}}
−
     |format=template|template=schtableconf}}
+
     |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,DATE_FORMAT(conferenceOuts.date, '%Y/%m/%d')
 +
    |where=conferenceOuts.weeknumber='{{#expr: {{#time: W|{{Timezone}}}} - 0 }}' AND conferenceOuts.daynumber='1'|default={{:schtableempty}}
 +
    |format=template|order by = time ASC|template=schtableouts}}
 
</td>
 
</td>
−
<td colspan="1">
+
<td style="width: 14%">
 
{{#cargo_query: tables=conference,residentMGH  
 
{{#cargo_query: tables=conference,residentMGH  
 
     |join on=conference.presenter=residentMGH.copath_id
 
     |join on=conference.presenter=residentMGH.copath_id
−
     |fields=conference.presenter,conference.color,residentMGH.full_name,conference.conference
+
     |fields=conference.presenter,conference.color,residentMGH.full_name,conference.conference,conference.sort=sort
 
     |where=conference.weeknumber='{{#expr: {{#time: W|{{Timezone}}}} - 0 }}' AND conference.daynumber='2'|default={{:schtableempty}}
 
     |where=conference.weeknumber='{{#expr: {{#time: W|{{Timezone}}}} - 0 }}' AND conference.daynumber='2'|default={{:schtableempty}}
−
     |format=template|template=schtableconf}}
+
     |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}}}} - 0 }}' AND conferenceOuts.daynumber='2'|default={{:schtableempty}}
 +
    |format=template|order by = time ASC|template=schtableouts}}
 
</td>
 
</td>
−
<td colspan="1">
+
<td style="width: 14%">
 
{{#cargo_query: tables=conference,residentMGH  
 
{{#cargo_query: tables=conference,residentMGH  
 
     |join on=conference.presenter=residentMGH.copath_id
 
     |join on=conference.presenter=residentMGH.copath_id
−
     |fields=conference.presenter,conference.color,residentMGH.full_name,conference.conference
+
     |fields=conference.presenter,conference.color,residentMGH.full_name,conference.conference,conference.sort=sort
 
     |where=conference.weeknumber='{{#expr: {{#time: W|{{Timezone}}}} - 0 }}' AND conference.daynumber='3'|default={{:schtableempty}}
 
     |where=conference.weeknumber='{{#expr: {{#time: W|{{Timezone}}}} - 0 }}' AND conference.daynumber='3'|default={{:schtableempty}}
−
     |format=template|template=schtableconf}}
+
     |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}}}} - 0 }}' AND conferenceOuts.daynumber='3'|default={{:schtableempty}}
 +
    |format=template|order by = time ASC|template=schtableouts}}
 
</td>
 
</td>
−
<td colspan="1">
+
<td style="width: 14%">
 
{{#cargo_query: tables=conference,residentMGH  
 
{{#cargo_query: tables=conference,residentMGH  
 
     |join on=conference.presenter=residentMGH.copath_id
 
     |join on=conference.presenter=residentMGH.copath_id
−
     |fields=conference.presenter,conference.color,residentMGH.full_name,conference.conference
+
     |fields=conference.presenter,conference.color,residentMGH.full_name,conference.conference,conference.sort=sort
 
     |where=conference.weeknumber='{{#expr: {{#time: W|{{Timezone}}}} - 0 }}' AND conference.daynumber='4'|default={{:schtableempty}}
 
     |where=conference.weeknumber='{{#expr: {{#time: W|{{Timezone}}}} - 0 }}' AND conference.daynumber='4'|default={{:schtableempty}}
−
     |format=template|template=schtableconf}}
+
     |format=template|order by = sort ASC|template=schtableconfcallLeft}}
 +
{{#cargo_query: tables=conference,facultyMGH
 +
    |join on=conference.presenter=facultyMGH.copath_id
 +
    |fields=conference.presenter,facultyMGH.fullname,conference.type
 +
    |where=conference.weeknumber='{{#expr: {{#time: W|{{Timezone}}}} - 0 }}' AND conference.conference='Thursday'|default={{:schtableempty}}
 +
    |format=template|order by = sort ASC|template=schtableconfthursday}}
 
</td>
 
</td>
−
<td colspan="1">
+
<td style="width: 14%">
 
{{#cargo_query: tables=conference,residentMGH  
 
{{#cargo_query: tables=conference,residentMGH  
 
     |join on=conference.presenter=residentMGH.copath_id
 
     |join on=conference.presenter=residentMGH.copath_id
−
     |fields=conference.presenter,conference.color,residentMGH.full_name,conference.conference
+
     |fields=conference.presenter,conference.color,residentMGH.full_name,conference.conference,conference.sort=sort
 
     |where=conference.weeknumber='{{#expr: {{#time: W|{{Timezone}}}} - 0 }}' AND conference.daynumber='5'|default={{:schtableempty}}
 
     |where=conference.weeknumber='{{#expr: {{#time: W|{{Timezone}}}} - 0 }}' AND conference.daynumber='5'|default={{:schtableempty}}
−
     |format=template|template=schtableconf}}
+
     |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}}}} - 0 }}' AND conferenceOuts.daynumber='5'|default={{:schtableempty}}
 +
    |format=template|order by = time ASC|template=schtableouts}}
 
</td>
 
</td>
−
<td colspan="1">
+
<td style="width: 14%">
 
{{#cargo_query: tables=conference,residentMGH  
 
{{#cargo_query: tables=conference,residentMGH  
 
     |join on=conference.presenter=residentMGH.copath_id
 
     |join on=conference.presenter=residentMGH.copath_id
−
     |fields=conference.presenter,conference.color,residentMGH.full_name,conference.conference
+
     |fields=conference.presenter,conference.color,residentMGH.full_name,conference.conference,conference.sort=sort
 
     |where=conference.weeknumber='{{#expr: {{#time: W|{{Timezone}}}} - 0 }}' AND conference.daynumber='6'|default={{:schtableempty}}
 
     |where=conference.weeknumber='{{#expr: {{#time: W|{{Timezone}}}} - 0 }}' AND conference.daynumber='6'|default={{:schtableempty}}
−
     |format=template|template=schtableconf}}
+
     |format=template|order by = sort ASC|template=schtableconfcallLeft}}
 
</td>
 
</td>
−
<td colspan="1">
+
<td style="width: 14%">
 
{{#cargo_query: tables=conference,residentMGH  
 
{{#cargo_query: tables=conference,residentMGH  
 
     |join on=conference.presenter=residentMGH.copath_id
 
     |join on=conference.presenter=residentMGH.copath_id
−
     |fields=conference.presenter,conference.color,residentMGH.full_name,conference.conference
+
     |fields=conference.presenter,conference.color,residentMGH.full_name,conference.conference,conference.sort=sort
 
     |where=conference.weeknumber='{{#expr: {{#time: W|{{Timezone}}}} - 0 }}' AND conference.daynumber='7'|default={{:schtableempty}}
 
     |where=conference.weeknumber='{{#expr: {{#time: W|{{Timezone}}}} - 0 }}' AND conference.daynumber='7'|default={{:schtableempty}}
−
     |format=template|template=schtableconf}}
+
     |format=template|order by = sort ASC|template=schtableconfcallLeft}}
 
</td>
 
</td>
 
</tr>
 
</tr>
 
</table>
 
</table>

Latest revision as of 07:06, June 25, 2020

Monday
Apr 27

Monday
Apr 27
Tuesday
Apr 28

Tuesday
Apr 28
Wednesday
Apr 29

Wednesday
Apr 29
Thursday
Apr 30

Thursday
Apr 30
Friday
May 01

Friday
May 01
Saturday
May 02
Sunday
May 03
Call: Senior - KRT
Caroline Hilburn - CFH
🥣 - Roll the dice!
GU: OLI @ 12:00 PM
No PDF
DP: RMN @ 12:30 PM
No PDF
Aida Valencia-Guerrero - AID
Sarah Mueller - MUL
🥣 - J. Pace's
Autopsy - MEG
GYN: OLI @ 12:00 PM
No PDF
Ying-Hsia Chu - YHC
Bailey Hutchison - HUT
🥣 - India Quality
GI: MBP @ 12:00 PM
No PDF
BR: AMY @ 12:30 PM
No PDF
Zehra Ordulu Sahin - ZRA
Michael Marshall - MIC
🥣 - King and I
-
Julian Villalba - VIL
Call: Junior - MEG
🥣 - Piperi
Amin Heidarian - HEI
BST: IAC @ 12:00 PM
No PDF
Julian Villalba - VIL
Cynthia Harris - CYN
Michael Marshall - MIC
Julian Villalba - VIL
Cynthia Harris - CYN
Michael Marshall - MIC
Retrieved from "https://learn.mghpathology.org/index.php?title=CurrentWeekConfCall&oldid=38666"
  • Powered by MediaWiki
  • Search Powered by Cargo
  • Massachusetts General Hospital