Difference between revisions of "schedule-conference"
From MGH Learn Pathology
| Line 13: | Line 13: | ||
;join on= conference.presenter=residentMGH.copath_id | ;join on= conference.presenter=residentMGH.copath_id | ||
;fields=CONCAT('口',conference.conference, ' - ', conference.presenter)=name,residentMGH.full_name=description,conference.date=Date | ;fields=CONCAT('口',conference.conference, ' - ', conference.presenter)=name,residentMGH.full_name=description,conference.date=Date | ||
| − | ;where=conference. | + | ;where=conference.conference='Call: Autopsy' OR conference.conference='Call: Junior' |
;text color=#000000 | ;text color=#000000 | ||
| − | ;color=# | + | ;color=#d6b0ff |
| + | |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.conference='Call: Senior' | ||
| + | ;text color=#000000 | ||
| + | ;color=#d0ffb3 | ||
|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 14:01, 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
