Difference between revisions of "EvaluationResAtt"
From MGH Learn Pathology
| Line 24: | Line 24: | ||
|fields= | |fields= | ||
scheduleRFA.Date=Date | scheduleRFA.Date=Date | ||
| + | ,CONCAT('{{schedule-TaskAbbrev{{#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,'}}')=Attending | ||
|where=YEAR(scheduleRFA.Date)={{#time: Y|{{Timezone}}}} AND scheduleRFA.ResAbbrev='SYA' AND evaluationResAtt._pageName IS NULL AND WEEK(scheduleRFA.Date) <= '{{#ifexpr: {{#time: w}} >= 5|{{#expr: {{#time: W|{{Timezone}}}} - 1 }}|{{#expr: {{#time: W|{{Timezone}}}} - 2 }} }}' | |where=YEAR(scheduleRFA.Date)={{#time: Y|{{Timezone}}}} AND scheduleRFA.ResAbbrev='SYA' AND evaluationResAtt._pageName IS NULL AND WEEK(scheduleRFA.Date) <= '{{#ifexpr: {{#time: w}} >= 5|{{#expr: {{#time: W|{{Timezone}}}} - 1 }}|{{#expr: {{#time: W|{{Timezone}}}} - 2 }} }}' | ||
| Line 55: | Line 56: | ||
|fields= | |fields= | ||
scheduleRESservice.Date=Week Of | scheduleRESservice.Date=Week Of | ||
| − | |||
,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(scheduleRESservice.Date) <= '{{#ifexpr: {{#time: w}} >= 4|{{#expr: {{#time: W|{{Timezone}}}} - 0 }}|{{#expr: {{#time: W|{{Timezone}}}} - 1 }} }}' 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') AND evaluationResAtt._pageName IS NULL | |where=YEAR(scheduleRESservice.Date)={{#time: Y|{{Timezone}}}} AND WEEK(scheduleRESservice.Date) <= '{{#ifexpr: {{#time: w}} >= 4|{{#expr: {{#time: W|{{Timezone}}}} - 0 }}|{{#expr: {{#time: W|{{Timezone}}}} - 1 }} }}' 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') AND evaluationResAtt._pageName IS NULL | ||
Revision as of 19:36, September 23, 2020
|
|
|
|
|
|
|
|
|
