Difference between revisions of "EvaluationResAtt"
From MGH Learn Pathology
| Line 2: | Line 2: | ||
<center><table width:100%"> | <center><table width:100%"> | ||
<tr> | <tr> | ||
| − | <td style="background-color:#a3e2ff; width: | + | <td style="background-color:#a3e2ff; width:38%"> |
<center><p></p>{{ColorText|Anatomic Pathology|||3}}<p></p></center> | <center><p></p>{{ColorText|Anatomic Pathology|||3}}<p></p></center> | ||
</td> | </td> | ||
| Line 8: | Line 8: | ||
| | ||
</td> | </td> | ||
| − | <td style="background-color:#ffdeb5; width: | + | <td style="background-color:#ffdeb5; width:38%"> |
<center><p></p>{{ColorText|Clinical Pathology|||3}}<p></p></center> | <center><p></p>{{ColorText|Clinical Pathology|||3}}<p></p></center> | ||
</td> | </td> | ||
| Line 14: | Line 14: | ||
| | ||
</td> | </td> | ||
| − | <td style="background-color:#baffd6; width: | + | <td style="background-color:#baffd6; width:22%"> |
<center><p></p>{{ColorText|External/Elective Evaluations|||3}}<p></p></center> | <center><p></p>{{ColorText|External/Elective Evaluations|||3}}<p></p></center> | ||
</td> | </td> | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
| − | <td style="vertical-align:top; width: | + | <td style="vertical-align:top; width:38%"> |
{{#cargo_query:tables=scheduleRFA,evaluationResAtt | {{#cargo_query:tables=scheduleRFA,evaluationResAtt | ||
|join on=scheduleRFA.UID=evaluationResAtt.UID | |join on=scheduleRFA.UID=evaluationResAtt.UID | ||
|fields= | |fields= | ||
scheduleRFA.Date=Date | scheduleRFA.Date=Date | ||
| − | |||
,CONCAT('{{evaluationResAtt-attending{{#urldecode:%7C}}',scheduleRFA.StaffAbbrev,'{{#urldecode:%7C}}',scheduleRFA.TaskAbbrev,'{{#urldecode:%7C}}',scheduleRFA.Date,'{{#urldecode:%7C}}',scheduleRFA.UID,'}}')=Attending | ,CONCAT('{{evaluationResAtt-attending{{#urldecode:%7C}}',scheduleRFA.StaffAbbrev,'{{#urldecode:%7C}}',scheduleRFA.TaskAbbrev,'{{#urldecode:%7C}}',scheduleRFA.Date,'{{#urldecode:%7C}}',scheduleRFA.UID,'}}')=Attending | ||
|where=YEAR(scheduleRFA.Date)={{#time: Y|{{Timezone}}}} AND scheduleRFA.ResAbbrev='SYA' AND evaluationResAtt._pageName IS NULL AND WEEK(scheduleRFA.Date) <= '{{#ifexpr: {{#time: w}} >= 5|{{#expr: {{#time: W|{{Timezone}}}} - 1 }}|{{#expr: {{#time: W|{{Timezone}}}} - 2 }} }}' | |where=YEAR(scheduleRFA.Date)={{#time: Y|{{Timezone}}}} AND scheduleRFA.ResAbbrev='SYA' AND evaluationResAtt._pageName IS NULL AND WEEK(scheduleRFA.Date) <= '{{#ifexpr: {{#time: w}} >= 5|{{#expr: {{#time: W|{{Timezone}}}} - 1 }}|{{#expr: {{#time: W|{{Timezone}}}} - 2 }} }}' | ||
| Line 35: | Line 34: | ||
| | ||
</td> | </td> | ||
| − | <td style="vertical-align:top; width: | + | <td style="vertical-align:top; width:38%"> |
{{#cargo_query:tables=scheduleRESservice,evaluationResAtt | {{#cargo_query:tables=scheduleRESservice,evaluationResAtt | ||
|join on=scheduleRESservice.TaskAbbrev=evaluationResAtt.UID | |join on=scheduleRESservice.TaskAbbrev=evaluationResAtt.UID | ||
| Line 51: | Line 50: | ||
| | ||
</td> | </td> | ||
| − | <td style="vertical-align:top; width: | + | <td style="vertical-align:top; width:22%"> |
{{#cargo_query:tables=scheduleRESservice,evaluationResAtt | {{#cargo_query:tables=scheduleRESservice,evaluationResAtt | ||
|join on=scheduleRESservice.TaskAbbrev=evaluationResAtt.UID | |join on=scheduleRESservice.TaskAbbrev=evaluationResAtt.UID | ||
Revision as of 19:36, September 23, 2020
|
|
|
|
|
|
|
|
|
