Difference between revisions of "EvaluationResAtt"

From MGH Learn Pathology
(Created page with "__NOCACHE__{{DISPLAYTITLE:{{CURRENTUSERREALNAME}} Evaluation of Attending}}{{#css: table.dataTable tbody tr { background-color: transparent; } }} {{#cargo_query:tables=schedul...")
 
 
(209 intermediate revisions by 2 users not shown)
Line 1: Line 1:
−
__NOCACHE__{{DISPLAYTITLE:{{CURRENTUSERREALNAME}} Evaluation of Attending}}{{#css: table.dataTable tbody tr { background-color: transparent; } }}
+
__NOCACHE__{{DISPLAYTITLE:Evaluation of Attending}}{{#css: table.dataTable tbody tr { background-color: transparent; } table  }}{{:dynamictableModified}}
 +
<center><table width:100%">
 +
<tr>
 +
<td style="background-color:#a3e2ff; width:43%">
 +
<center><p></p>{{ColorText|Anatomic Pathology|||3}}<p></p></center>
 +
</td>
 +
<td style="width:1%">
 +
&nbsp;&nbsp;&nbsp;
 +
</td>
 +
<td style="background-color:#ffdeb5; width:33%">
 +
<center><p></p>{{ColorText|Clinical Pathology|||3}}<p></p></center>
 +
</td>
 +
<td style="width:1%">
 +
&nbsp;&nbsp;&nbsp;
 +
</td>
 +
<td style="background-color:#baffd6; width:22%">
 +
<center><p></p>{{ColorText|External/Elective Evaluations|||3}}<p></p></center>
 +
</td>
 +
</tr>
 +
<tr>
 +
<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=Week Of
+
DATE_FORMAT(scheduleRFA.Date, '%b %e, %Y')=Date
−
,CONCAT('{{schedule-TaskAbbrev{{#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,'}}')=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(scheduleRFA.Date)={{#time: Y|{{Timezone}}}} AND QUARTER(scheduleRFA.Date) IN ('3', '4')  AND scheduleRFA.ResAbbrev='BYB' AND WEEKDAY(scheduleRFA.Date)=0 AND evaluationResAtt._pageName IS NULL
+
|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 }} }}'
−
|order by=scheduleRFA.Date ASC
+
|group by=scheduleRFA.weeknumber,scheduleRFA.TaskAbbrev,scheduleRFA.StaffAbbrev
 +
|order by=scheduleRFA.Date DESC
 +
|rows per page=50
 +
|format=dynamic table|default=}}
 +
</td>
 +
<td style="width:1%">
 +
&nbsp;&nbsp;&nbsp;
 +
</td>
 +
<td style="vertical-align:top; width:38%">
 +
{{#cargo_query:tables=scheduleRFA,evaluationResAtt
 +
|join on=scheduleRFA.UID=evaluationResAtt.UID
 +
|fields=
 +
DATE_FORMAT(scheduleRFA.Date, '%b %e, %Y')=Date
 +
,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=(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 }} }}'
 +
|group by=QUARTER(scheduleRFA.Date),scheduleRFA.TaskAbbrev,scheduleRFA.StaffAbbrev
 +
|order by=scheduleRFA.Date DESC
 +
|rows per page=50
 +
|format=dynamic table|default=}}
 +
</td>
 +
<td style="width:1%">
 +
&nbsp;&nbsp;&nbsp;
 +
</td>
 +
<td style="vertical-align:top; width:22%">
 +
{{#cargo_query:tables=scheduleRESservice,evaluationResAtt
 +
|join on=scheduleRESservice.TaskAbbrev=evaluationResAtt.UID
 +
|fields=
 +
DATE_FORMAT(scheduleRESservice.Date, '%b %e, %Y')=Week Of
 +
,CONCAT('{{evaluationResAtt-attendingexternal{{#urldecode:%7C}}',scheduleRESservice.TaskAbbrev,'{{#urldecode:%7C}}',scheduleRESservice.Date,'{{#urldecode:%7C}}',scheduleRESservice.UID,'}}')=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='MEG' AND WEEKDAY(scheduleRESservice.Date)=0 AND (scheduleRESservice.TaskAbbrev LIKE '%-E%' OR scheduleRESservice.TaskAbbrev='E' OR scheduleRESservice.TaskAbbrev='ME' OR scheduleRESservice.TaskAbbrev='CAMD')
 +
|order by=scheduleRESservice.Date DESC
 
|rows per page=50
 
|rows per page=50
 
|group by=Week Of
 
|group by=Week Of
 
|format=dynamic table|default=}}
 
|format=dynamic table|default=}}
 +
</td>
 +
</tr>
 +
</table></center>
 +
<center><p></p>{{helpfooter}}<center>

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

Anatomic Pathology

   

Clinical Pathology

   

External/Elective Evaluations

   

   

You're signed in as '. Need help?'
Retrieved from "https://learn.mghpathology.org/index.php?title=EvaluationResAtt&oldid=50369"
  • Powered by MediaWiki
  • Search Powered by Cargo
  • Massachusetts General Hospital