Difference between revisions of "EvaluationResAtt"

From MGH Learn Pathology
Line 35: Line 35:
 
,scheduleRESservice.TaskAbbrev=Rotation
 
,scheduleRESservice.TaskAbbrev=Rotation
 
,CONCAT('{{evaluationResAtt-attendingexternal{{#urldecode:%7C}}',scheduleRESservice.TaskAbbrev,'{{#urldecode:%7C}}',scheduleRESservice.Date,'{{#urldecode:%7C}}',scheduleRESservice.TaskAbbrev,'}}')=Attending
 
,CONCAT('{{evaluationResAtt-attendingexternal{{#urldecode:%7C}}',scheduleRESservice.TaskAbbrev,'{{#urldecode:%7C}}',scheduleRESservice.Date,'{{#urldecode:%7C}}',scheduleRESservice.TaskAbbrev,'}}')=Attending
|where=YEAR(scheduleRESservice.Date)={{#time: Y|{{Timezone}}}} AND WEEK(scheduleRFAview.Date) <= '{{#expr: {{#time: W|{{Timezone}}}} + 0 }}' AND scheduleRESservice.ResAbbrev='HUT' AND WEEKDAY(scheduleRESservice.Date)=0 AND (scheduleRESservice.TaskAbbrev LIKE '%-E%' OR scheduleRESservice.TaskAbbrev='E' OR scheduleRESservice.TaskAbbrev='ME' OR scheduleRESservice.TaskAbbrev='CAMD') AND evaluationResAtt._pageName IS NULL
+
|where=YEAR(scheduleRESservice.Date)={{#time: Y|{{Timezone}}}} AND WEEK(scheduleRESservice.Date) <= '{{#expr: {{#time: W|{{Timezone}}}} + 0 }}' AND scheduleRESservice.ResAbbrev='HUT' AND WEEKDAY(scheduleRESservice.Date)=0 AND (scheduleRESservice.TaskAbbrev LIKE '%-E%' OR scheduleRESservice.TaskAbbrev='E' OR scheduleRESservice.TaskAbbrev='ME' OR scheduleRESservice.TaskAbbrev='CAMD') AND evaluationResAtt._pageName IS NULL
 
|order by=scheduleRESservice.Date ASC
 
|order by=scheduleRESservice.Date ASC
 
|rows per page=50
 
|rows per page=50

Revision as of 09:33, July 27, 2020

Internal Evaluations

   

External/Elective Evaluations

Error: Table scheduleRFAview not found.