Difference between revisions of "EvaluationResAtt"
From MGH Learn Pathology
| Line 23: | Line 23: | ||
|join on=scheduleRFA.UID=evaluationResAtt.UID | |join on=scheduleRFA.UID=evaluationResAtt.UID | ||
|fields= | |fields= | ||
| − | scheduleRFA.Date=Date | + | DATE_FORMAT(scheduleRFA.Date, '%b %e, %Y')=Date |
,CONCAT('{{evaluationResAtt-service{{#urldecode:%7C}}',scheduleRFA.TaskAbbrev,'}}')=Service | ,CONCAT('{{evaluationResAtt-service{{#urldecode:%7C}}',scheduleRFA.TaskAbbrev,'}}')=Service | ||
,CONCAT('{{evaluationResAtt-attending{{#urldecode:%7C}}',scheduleRFA.StaffAbbrev,'{{#urldecode:%7C}}',scheduleRFA.TaskAbbrev,'{{#urldecode:%7C}}',scheduleRFA.Date,'{{#urldecode:%7C}}',scheduleRFA.UID,'{{#urldecode:%7C}}',scheduleRFA.WeekNumber,'{{#urldecode:%7C}}',scheduleRFA.ResAbbrev,'}}')=Attending | ,CONCAT('{{evaluationResAtt-attending{{#urldecode:%7C}}',scheduleRFA.StaffAbbrev,'{{#urldecode:%7C}}',scheduleRFA.TaskAbbrev,'{{#urldecode:%7C}}',scheduleRFA.Date,'{{#urldecode:%7C}}',scheduleRFA.UID,'{{#urldecode:%7C}}',scheduleRFA.WeekNumber,'{{#urldecode:%7C}}',scheduleRFA.ResAbbrev,'}}')=Attending | ||
Revision as of 10:08, September 25, 2020
|
|
|
|
|
|
|
|
|
