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:32%"> |
| − | <center><p></p>{{ColorText| | + | <center><p></p>{{ColorText|Anatomic Pathology|||3}}<p></p></center> |
</td> | </td> | ||
<td style="width:2%"> | <td style="width:2%"> | ||
| | ||
</td> | </td> | ||
| − | <td style="background-color:#ffdeb5; width: | + | <td style="background-color:#ffdeb5; width:32%"> |
| + | <center><p></p>{{ColorText|Clinical Pathology|||3}}<p></p></center> | ||
| + | </td> | ||
| + | <td style="width:2%"> | ||
| + | | ||
| + | </td> | ||
| + | <td style="background-color:#ffffff; width:32%"> | ||
<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:32%"> |
| + | {{#cargo_query:tables=scheduleRFAview,evaluationResAtt | ||
| + | |join on=scheduleRFAview.UID=evaluationResAtt.UID | ||
| + | |fields= | ||
| + | scheduleRFAview.Date=Date | ||
| + | ,CONCAT('{{schedule-TaskAbbrev{{#urldecode:%7C}}',scheduleRFAview.TaskAbbrev,'}}')=Service | ||
| + | ,CONCAT('{{evaluationResAtt-attending{{#urldecode:%7C}}',scheduleRFAview.StaffAbbrev,'{{#urldecode:%7C}}',scheduleRFAview.TaskAbbrev,'{{#urldecode:%7C}}',scheduleRFAview.Date,'{{#urldecode:%7C}}',scheduleRFAview.UID,'}}')=Attending | ||
| + | |where=YEAR(scheduleRFAview.Date)={{#time: Y|{{Timezone}}}} AND scheduleRFAview.ResAbbrev='SYA' AND evaluationResAtt._pageName IS NULL AND WEEK(scheduleRFAview.Date) <= '{{#ifexpr: {{#time: w}} >= 5|{{#expr: {{#time: W|{{Timezone}}}} - 1 }}|{{#expr: {{#time: W|{{Timezone}}}} - 2 }} }}' | ||
| + | |group by=WEEK(scheduleRFAview.Date) | ||
| + | |order by=scheduleRFAview.Date ASC | ||
| + | |rows per page=50 | ||
| + | |format=dynamic table|default=}} | ||
| + | </td> | ||
| + | <td style="width:2%"> | ||
| + | | ||
| + | </td> | ||
| + | <td style="vertical-align:top; width:32%"> | ||
{{#cargo_query:tables=scheduleRFAview,evaluationResAtt | {{#cargo_query:tables=scheduleRFAview,evaluationResAtt | ||
|join on=scheduleRFAview.UID=evaluationResAtt.UID | |join on=scheduleRFAview.UID=evaluationResAtt.UID | ||
| Line 29: | Line 51: | ||
| | ||
</td> | </td> | ||
| − | <td style="vertical-align:top; width: | + | <td style="vertical-align:top; width:32%"> |
{{#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 15:42, September 23, 2020
|
|
|
|
|
|
|
Error: Table scheduleRFAview not found.
|
|
Error: Table scheduleRFAview not found.
|
|
