Difference between revisions of "EvaluationResAtt"

Latest revision as of 07:30, September 29, 2020

Anatomic Pathology		Clinical Pathology		External/Elective Evaluations

You're signed in as '. Need help?'

@@ Line 19: / Line 19: @@
 </tr>
 <tr>
-<td style="vertical-align:top; width:43%">
+<td style="vertical-align:top; width:38%">
 {{#cargo_query:tables=scheduleRFA,evaluationResAtt
 |join on=scheduleRFA.UID=evaluationResAtt.UID
@@ Line 26: / Line 26: @@
 ,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
-|where=YEAR(scheduleRFA.Date)='{{#expr: {{#time: Y|{{Timezone}}}} + 0 }}' AND scheduleRFA.ResAbbrev='ADM' AND WEEK(scheduleRFA.Date) <= '{{#ifexpr: {{#time: w}} >= 4|{{#expr: {{#time: W|{{Timezone}}}} - 1 }}|{{#expr: {{#time: W|{{Timezone}}}} - 2 }} }}'
+|where=YEAR(scheduleRFA.Date)='{{#expr: {{#time: Y|{{Timezone}}}} + 0 }}' AND scheduleRFA.ResAbbrev='MOR' AND WEEK(scheduleRFA.Date) <= '{{#ifexpr: {{#time: w}} >= 4|{{#expr: {{#time: W|{{Timezone}}}} - 1 }}|{{#expr: {{#time: W|{{Timezone}}}} - 2 }} }}'
 |group by=scheduleRFA.weeknumber,scheduleRFA.TaskAbbrev,scheduleRFA.StaffAbbrev
 |order by=scheduleRFA.Date DESC
@@ Line 35: / Line 35: @@
 &nbsp;&nbsp;&nbsp;
 </td>
-<td style="vertical-align:top; width:33%">
+<td style="vertical-align:top; width:38%">
-{{#cargo_query:tables=scheduleRESservice,evaluationResAtt
+{{#cargo_query:tables=scheduleRFA,evaluationResAtt
-|join on=scheduleRESservice.TaskAbbrev=evaluationResAtt.UID
+|join on=scheduleRFA.UID=evaluationResAtt.UID
 |fields=
-DATE_FORMAT(scheduleRESservice.Date, '%b %e, %Y')=Week Of
+DATE_FORMAT(scheduleRFA.Date, '%b %e, %Y')=Date
-,scheduleRESservice.TaskAbbrev=Rotation
+,CONCAT('{{evaluationResAtt-service{{#urldecode:%7C}}',scheduleRFA.TaskAbbrev,'}}')=Service
-,CONCAT('{{evaluationResAtt-attendingLMP{{#urldecode:%7C}}',scheduleRESservice.TaskAbbrev,'{{#urldecode:%7C}}',scheduleRESservice.Date,'{{#urldecode:%7C}}',scheduleRESservice.UID,'}}')=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
-|where=YEAR(scheduleRESservice.Date)={{#time: Y|{{Timezone}}}} AND WEEK(scheduleRESservice.Date) <= '{{#ifexpr: {{#time: w}} >= 4|{{#expr: {{#time: W|{{Timezone}}}} - 1 }}|{{#expr: {{#time: W|{{Timezone}}}} - 2 }} }}' AND scheduleRESservice.ResAbbrev='NAS' AND WEEKDAY(scheduleRESservice.Date)=0 AND (scheduleRESservice.TaskAbbrev='BB' OR scheduleRESservice.TaskAbbrev='COAG' OR scheduleRESservice.TaskAbbrev='C/M')
+|where=(scheduleRFA.TaskAbbrev='COAG' OR TaskAbbrev='Micro' OR TaskAbbrev='BTS' OR TaskAbbrev='HG' OR TaskAbbrev='HPA' OR TaskAbbrev='HPB') AND YEAR(scheduleRFA.Date)='{{#expr: {{#time: Y|{{Timezone}}}} + 0 }}' AND scheduleRFA.ResAbbrev='STE' AND WEEK(scheduleRFA.Date) <= '{{#ifexpr: {{#time: w}} >= 4|{{#expr: {{#time: W|{{Timezone}}}} - 1 }}|{{#expr: {{#time: W|{{Timezone}}}} - 2 }} }}'
-|order by=scheduleRESservice.Date DESC
+|group by=QUARTER(scheduleRFA.Date),scheduleRFA.TaskAbbrev,scheduleRFA.StaffAbbrev
+|order by=scheduleRFA.Date DESC
 |rows per page=50
-|group by=Week Of
 |format=dynamic table|default=}}
 </td>
@@ Line 65: / Line 65: @@
 </tr>
 </table></center>
+<center><p></p>{{helpfooter}}<center>