Difference between revisions of "CurrentWeekConfCall"

From MGH Learn Pathology
 
(14 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,conference.sort=sort
 
     |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|order by = sort ASC|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,conference.sort=sort
 
     |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|order by = sort ASC|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 06:06, June 25, 2020

Monday
Dec 08

Monday
Dec 08
Tuesday
Dec 09

Tuesday
Dec 09
Wednesday
Dec 10

Wednesday
Dec 10
Thursday
Dec 11

Thursday
Dec 11
Friday
Dec 12

Friday
Dec 12
Saturday
Dec 13
Sunday
Dec 14
Call: Senior - NDA
Leif Helland - TLH
🥣 - Roll the dice!
Tyler Miller - TYM
ENT: WCF @ 12:00 PM
No PDF
Andrew Crabbe - CRB
Call: Junior - MOR
🥣 - J. Pace's
Bailey Hutchison - HUT
BST: IAC @ 12:00 PM
No PDF
Call: Senior - NDA
Julian Villalba - VIL
🥣 - India Quality
GI: JOE @ 12:00 PM
No PDF
HP: NDI @ 12:30 PM
No PDF
Andrew Crabbe - CRB
Kristine Chaudet - ALB
🥣 - King and I
WCF - Squamous cell carcinoma and dysplasia
Melissa Krystel-Whittemore - MKW
Call: Junior - MOR
🥣 - Piperi
Julian Villalba - VIL
CYT: MPB @ 12:00 PM
No PDF
CRES: NDA @ 12:30 PM
No PDF
Melissa Krystel-Whittemore - MKW
Kristine Chaudet - ALB
Michael Marshall - MIC
Melissa Krystel-Whittemore - MKW
Kristine Chaudet - ALB
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