Difference between revisions of "EvaluationResAtt"

From MGH Learn Pathology
Line 20: Line 20:
 
,CONCAT('{{schedule-TaskAbbrev{{#urldecode:%7C}}',scheduleRFAview.TaskAbbrev,'}}')=Service
 
,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
 
,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='HUT' AND WEEKDAY(scheduleRFAview.Date)=0 AND evaluationResAtt._pageName IS NULL AND WEEK(scheduleRFAview.Date) <= '{{#expr: {{#time: W|{{Timezone}}}} + 10 }}'
+
|where=YEAR(scheduleRFAview.Date)={{#time: Y|{{Timezone}}}} AND scheduleRFAview.ResAbbrev='HUT' AND WEEKDAY(scheduleRFAview.Date)=0 AND evaluationResAtt._pageName IS NULL AND WEEK(scheduleRFAview.Date) <= '{{#expr: {{#time: W|{{Timezone}}}} + 0 }}'
 
|order by=scheduleRFAview.Date ASC
 
|order by=scheduleRFAview.Date ASC
 
|rows per page=50
 
|rows per page=50
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 scheduleRESservice.ResAbbrev='HUT' AND WEEKDAY(scheduleRESservice.Date)=0 AND scheduleRESservice.TaskAbbrev='E' AND evaluationResAtt._pageName IS NULL
+
|where=YEAR(scheduleRESservice.Date)={{#time: Y|{{Timezone}}}} AND scheduleRESservice.ResAbbrev='CFH' AND WEEKDAY(scheduleRESservice.Date)=0 AND scheduleRESservice.TaskAbbrev='E' 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 06:53, July 27, 2020

Internal Evaluations

   

External/Elective Evaluations

Error: Table scheduleRFAview not found.