Difference between revisions of "mgh:gi-calendar"
From MGH Learn Pathology
| Line 11: | Line 11: | ||
,full_name=description | ,full_name=description | ||
,Date=Date | ,Date=Date | ||
| − | ;where=LocationAbbrev='MGH' AND (TaskAbbrev='GI1' OR TaskAbbrev='GI2' OR TaskAbbrev='GI3' OR TaskAbbrev='GI4 | + | ;where=LocationAbbrev='MGH' AND (TaskAbbrev='GI1' OR TaskAbbrev='GI2' OR TaskAbbrev='GI3' OR TaskAbbrev='GI4') AND NOT ResAbbrev IN ('0', '-', 'TBD');color=#1730b0;text color=#FFFFFF |
|tables=scheduleFELLservice,residentMGH | |tables=scheduleFELLservice,residentMGH | ||
;join on= scheduleFELLservice.FellAbbrev=residentMGH.copath_id | ;join on= scheduleFELLservice.FellAbbrev=residentMGH.copath_id | ||
Revision as of 09:03, September 18, 2024
1. Attending 2. Fellow 3. Resident
