Difference between revisions of "testserviceschedule"
From MGH Learn Pathology
| Line 4: | Line 4: | ||
{{#cargo_compound_query: | {{#cargo_compound_query: | ||
|tables=scheduleFACservice | |tables=scheduleFACservice | ||
| − | ;fields=CONCAT('🔘 ',TaskAbbrev,' - ',StaffAbbrev)=name | + | ;fields=CONCAT('🔘 ',TaskAbbrev,' - ',StaffFullName,'(',StaffAbbrev,')')=name |
,Date=Date | ,Date=Date | ||
;where=TaskAbbrev='AUT';color=#AEAAAA;text color=#000000 | ;where=TaskAbbrev='AUT';color=#AEAAAA;text color=#000000 | ||
| Line 27: | Line 27: | ||
;fields=CONCAT('🔸 Resident: ',ResAbbrev,' - ',TaskAbbrev)=name | ;fields=CONCAT('🔸 Resident: ',ResAbbrev,' - ',TaskAbbrev)=name | ||
,Date=Date | ,Date=Date | ||
| − | ;where=(TaskAbbrev='BR1' OR TaskAbbrev='BR2 | + | ;where=(TaskAbbrev='BR1' OR TaskAbbrev='BR2') AND NOT ResAbbrev IN ('0', '-');color=#1730b0;text color=#FFFFFF |
|tables=scheduleRFAview | |tables=scheduleRFAview | ||
;fields=CONCAT('🔹 Fellow: ',FellAbbrev,' - ',TaskAbbrev)=name | ;fields=CONCAT('🔹 Fellow: ',FellAbbrev,' - ',TaskAbbrev)=name | ||
,Date=Date | ,Date=Date | ||
| − | ;where=(TaskAbbrev='BR1' OR TaskAbbrev='BR2 | + | ;where=(TaskAbbrev='BR1' OR TaskAbbrev='BR2') AND NOT FellAbbrev IN ('0', '-');color=#000000;text color=#FFFFFF |
|format=calendar|}} | |format=calendar|}} | ||
<hr> | <hr> | ||
| Line 106: | Line 106: | ||
{{#cargo_compound_query: | {{#cargo_compound_query: | ||
|tables=scheduleFACservice | |tables=scheduleFACservice | ||
| − | ;fields=CONCAT('🔘 ',TaskAbbrev,' - ', | + | ;fields=CONCAT('🔘 ',TaskAbbrev,' - ',S)=name |
,Date=Date | ,Date=Date | ||
;where=TaskAbbrev='HN1' OR TaskAbbrev='HN2';color=#04E489;text color=#000000 | ;where=TaskAbbrev='HN1' OR TaskAbbrev='HN2';color=#04E489;text color=#000000 | ||
| Line 112: | Line 112: | ||
;fields=CONCAT('🔸 Resident: ',ResAbbrev,' - ',TaskAbbrev)=name | ;fields=CONCAT('🔸 Resident: ',ResAbbrev,' - ',TaskAbbrev)=name | ||
,Date=Date | ,Date=Date | ||
| − | ;where=(TaskAbbrev='HN1' OR TaskAbbrev='HN2 | + | ;where=(TaskAbbrev='HN1' OR TaskAbbrev='HN2') AND NOT ResAbbrev IN ('0', '-');color=#1730b0;text color=#FFFFFF |
|tables=scheduleRFAview | |tables=scheduleRFAview | ||
;fields=CONCAT('🔹 Fellow: ',FellAbbrev,' - ',TaskAbbrev)=name | ;fields=CONCAT('🔹 Fellow: ',FellAbbrev,' - ',TaskAbbrev)=name | ||
,Date=Date | ,Date=Date | ||
| − | ;where=(TaskAbbrev='HN1' OR TaskAbbrev='HN2 | + | ;where=(TaskAbbrev='HN1' OR TaskAbbrev='HN2') AND NOT FellAbbrev IN ('0', '-');color=#000000;text color=#FFFFFF |
|format=calendar|}} | |format=calendar|}} | ||
<hr> | <hr> | ||
Revision as of 06:40, October 12, 2019
Contents
Autopsy (AUT)
Error: Table scheduleRFAview not found.
Breast (BR1 & BR2)
Error: Table scheduleRFAview not found.
Bone & Soft Tissue (BST)
Error: Table scheduleRFAview not found.
Cardiovascular & Pulmonary Pathology (CV & PP)
Error: Table scheduleRFAview not found.
Cytology (CA, CB, & CC)
Error: Table scheduleRFAview not found.
Dermatopathology (DPA, DPB, & DPC)
Error: Table scheduleRFAview not found.
Head & Neck (HN1 & HN2)
Error: Table scheduleRFAview not found.
Gastrointestinal Pathology (GI1, GI2, & GI3)
Error: Table scheduleRFAview not found.
