Difference between revisions of "schedule-conference"
From MGH Learn Pathology
| Line 10: | Line 10: | ||
;where=conference='GPR' | ;where=conference='GPR' | ||
;color=#ffb973;text color=black | ;color=#ffb973;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.type='call' | ||
| + | ;text color=#000000 | ||
| + | ;color=#adffaf | ||
|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=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 | ||
Revision as of 09:35, September 28, 2019
Conference Schedule
1. Autopsy, 2. GPR, 3. Grand Rounds, 4. MPR, 5. Outs, 6. RadPath 7. Thoracic 8. Thursday Didactic 9. Lunch
