Difference between revisions of "testserviceschedule"
From MGH Learn Pathology
| (6 intermediate revisions by the same user not shown) | |||
| Line 152: | Line 152: | ||
;where=TaskAbbrev='AUT' AND NOT FellAbbrev IN ('0', '-');color=#000000;text color=#FFFFFF | ;where=TaskAbbrev='AUT' AND NOT FellAbbrev IN ('0', '-');color=#000000;text color=#FFFFFF | ||
|format=calendar|}} | |format=calendar|}} | ||
| − | |||
== <center>'''{{ColorText|Breast||#30705d|6|}}'''</center> == | == <center>'''{{ColorText|Breast||#30705d|6|}}'''</center> == | ||
<center>'''{{ColorText|BR1 & BR2||#30705d|6|}}'''</center> | <center>'''{{ColorText|BR1 & BR2||#30705d|6|}}'''</center> | ||
| Line 161: | Line 160: | ||
,Date=Date | ,Date=Date | ||
;where=TaskAbbrev='BR1' OR TaskAbbrev='BR2';color=#FF7E46;text color=#000000 | ;where=TaskAbbrev='BR1' OR TaskAbbrev='BR2';color=#FF7E46;text color=#000000 | ||
| − | |tables=scheduleRFAview | + | |tables=scheduleRFAview,residentMGH |
| − | ;fields=CONCAT('🔸 Resident: ',ResAbbrev,' - ',TaskAbbrev)=name | + | ;join on=scheduleRFAview.ResAbbrev=residentMGH.copath_id |
| − | ,Date=Date | + | ;fields=CONCAT('🔸 Resident: ',scheduleRFAview.ResAbbrev,' - ',scheduleRFAview.TaskAbbrev)=name |
| − | ;where=(TaskAbbrev='BR1' OR TaskAbbrev='BR2') AND NOT ResAbbrev IN ('0', '-');color=#1730b0;text color=#FFFFFF | + | ,residentMGH.full_name=description |
| + | ,scheduleRFAview.Date=Date | ||
| + | ;where=(scheduleRFAview.TaskAbbrev='BR1' OR scheduleRFAview.TaskAbbrev='BR2') AND NOT scheduleRFAview.ResAbbrev IN ('0', '-');color=#1730b0;text color=#FFFFFF | ||
|tables=scheduleRFAview | |tables=scheduleRFAview | ||
;fields=CONCAT('🔹 Fellow: ',FellAbbrev,' - ',TaskAbbrev)=name | ;fields=CONCAT('🔹 Fellow: ',FellAbbrev,' - ',TaskAbbrev)=name | ||
| Line 170: | Line 171: | ||
;where=(TaskAbbrev='BR1' OR TaskAbbrev='BR2') AND NOT FellAbbrev IN ('0', '-');color=#000000;text color=#FFFFFF | ;where=(TaskAbbrev='BR1' OR TaskAbbrev='BR2') AND NOT FellAbbrev IN ('0', '-');color=#000000;text color=#FFFFFF | ||
|format=calendar|}} | |format=calendar|}} | ||
| − | |||
== <center>'''{{ColorText|Bone & Soft Tissue||#30705d|6|}}'''</center> == | == <center>'''{{ColorText|Bone & Soft Tissue||#30705d|6|}}'''</center> == | ||
<center>'''{{ColorText|BST||#30705d|6|}}'''</center> | <center>'''{{ColorText|BST||#30705d|6|}}'''</center> | ||
| Line 188: | Line 188: | ||
;where=TaskAbbrev='BST' AND NOT FellAbbrev IN ('0', '-');color=#000000;text color=#FFFFFF | ;where=TaskAbbrev='BST' AND NOT FellAbbrev IN ('0', '-');color=#000000;text color=#FFFFFF | ||
|format=calendar|}} | |format=calendar|}} | ||
| − | |||
== <center>'''{{ColorText|Cardiovascular & Pulmonary||#30705d|6|}}'''</center> == | == <center>'''{{ColorText|Cardiovascular & Pulmonary||#30705d|6|}}'''</center> == | ||
<center>'''{{ColorText|CV & PP||#30705d|6|}}'''</center> | <center>'''{{ColorText|CV & PP||#30705d|6|}}'''</center> | ||
| Line 206: | Line 205: | ||
;where=(TaskAbbrev='CV' OR TaskAbbrev='PP') AND NOT FellAbbrev IN ('0', '-');color=#000000;text color=#FFFFFF | ;where=(TaskAbbrev='CV' OR TaskAbbrev='PP') AND NOT FellAbbrev IN ('0', '-');color=#000000;text color=#FFFFFF | ||
|format=calendar|}} | |format=calendar|}} | ||
| − | |||
== <center>'''{{ColorText|Cytology||#30705d|6|}}'''</center> == | == <center>'''{{ColorText|Cytology||#30705d|6|}}'''</center> == | ||
<center>'''{{ColorText|CA, CB, & CC||#30705d|6|}}'''</center> | <center>'''{{ColorText|CA, CB, & CC||#30705d|6|}}'''</center> | ||
| Line 224: | Line 222: | ||
;where=(TaskAbbrev='CA' OR TaskAbbrev='CB' OR TaskAbbrev='CC') AND NOT FellAbbrev IN ('0', '-');color=#000000;text color=#FFFFFF | ;where=(TaskAbbrev='CA' OR TaskAbbrev='CB' OR TaskAbbrev='CC') AND NOT FellAbbrev IN ('0', '-');color=#000000;text color=#FFFFFF | ||
|format=calendar|}} | |format=calendar|}} | ||
| − | |||
== <center>'''{{ColorText|Dermatopathology||#30705d|6|}}'''</center> == | == <center>'''{{ColorText|Dermatopathology||#30705d|6|}}'''</center> == | ||
<center>'''{{ColorText|DPA, DPB, & DPC||#30705d|6|}}'''</center> | <center>'''{{ColorText|DPA, DPB, & DPC||#30705d|6|}}'''</center> | ||
| Line 242: | Line 239: | ||
;where=(TaskAbbrev='DPA' OR TaskAbbrev='DPB' OR TaskAbbrev='DPC') AND NOT FellAbbrev IN ('0', '-');color=#000000;text color=#FFFFFF | ;where=(TaskAbbrev='DPA' OR TaskAbbrev='DPB' OR TaskAbbrev='DPC') AND NOT FellAbbrev IN ('0', '-');color=#000000;text color=#FFFFFF | ||
|format=calendar|}} | |format=calendar|}} | ||
| − | |||
== <center>'''{{ColorText|Head & Neck||#30705d|6|}}'''</center> == | == <center>'''{{ColorText|Head & Neck||#30705d|6|}}'''</center> == | ||
<center>'''{{ColorText|HN1 & HN2||#30705d|6|}}'''</center> | <center>'''{{ColorText|HN1 & HN2||#30705d|6|}}'''</center> | ||
| Line 260: | Line 256: | ||
;where=(TaskAbbrev='HN1' OR TaskAbbrev='HN2') AND NOT FellAbbrev IN ('0', '-');color=#000000;text color=#FFFFFF | ;where=(TaskAbbrev='HN1' OR TaskAbbrev='HN2') AND NOT FellAbbrev IN ('0', '-');color=#000000;text color=#FFFFFF | ||
|format=calendar|}} | |format=calendar|}} | ||
| − | |||
== <center>'''{{ColorText|Gastrointestinal||#30705d|6|}}'''</center> == | == <center>'''{{ColorText|Gastrointestinal||#30705d|6|}}'''</center> == | ||
<center>'''{{ColorText|GI1, GI2, & GI3||#30705d|6|}}'''</center> | <center>'''{{ColorText|GI1, GI2, & GI3||#30705d|6|}}'''</center> | ||
| Line 278: | Line 273: | ||
;where=(TaskAbbrev='GI1' OR TaskAbbrev='GI2' OR TaskAbbrev='GI3') AND NOT FellAbbrev IN ('0', '-');color=#000000;text color=#FFFFFF | ;where=(TaskAbbrev='GI1' OR TaskAbbrev='GI2' OR TaskAbbrev='GI3') AND NOT FellAbbrev IN ('0', '-');color=#000000;text color=#FFFFFF | ||
|format=calendar|}} | |format=calendar|}} | ||
| − | |||
== <center>'''{{ColorText|Genitourinary||#30705d|6|}}'''</center> == | == <center>'''{{ColorText|Genitourinary||#30705d|6|}}'''</center> == | ||
<center>'''{{ColorText|GUL & GUS||#30705d|6|}}'''</center> | <center>'''{{ColorText|GUL & GUS||#30705d|6|}}'''</center> | ||
| Line 296: | Line 290: | ||
;where=(TaskAbbrev='GUL' OR TaskAbbrev='GUS') AND NOT FellAbbrev IN ('0', '-');color=#000000;text color=#FFFFFF | ;where=(TaskAbbrev='GUL' OR TaskAbbrev='GUS') AND NOT FellAbbrev IN ('0', '-');color=#000000;text color=#FFFFFF | ||
|format=calendar|}} | |format=calendar|}} | ||
| − | |||
== <center>'''{{ColorText|Gynecologic and Obstetric||#30705d|6|}}'''</center> == | == <center>'''{{ColorText|Gynecologic and Obstetric||#30705d|6|}}'''</center> == | ||
<center>'''{{ColorText|GYL, GYS, & OB||#30705d|6|}}'''</center> | <center>'''{{ColorText|GYL, GYS, & OB||#30705d|6|}}'''</center> | ||
| Line 314: | Line 307: | ||
;where=(TaskAbbrev='GYL' OR TaskAbbrev='GYS' OR TaskAbbrev='OB') AND NOT FellAbbrev IN ('0', '-');color=#000000;text color=#FFFFFF | ;where=(TaskAbbrev='GYL' OR TaskAbbrev='GYS' OR TaskAbbrev='OB') AND NOT FellAbbrev IN ('0', '-');color=#000000;text color=#FFFFFF | ||
|format=calendar|}} | |format=calendar|}} | ||
| − | |||
== <center>'''{{ColorText|Hematopathology||#30705d|6|}}'''</center> == | == <center>'''{{ColorText|Hematopathology||#30705d|6|}}'''</center> == | ||
<center>'''{{ColorText|HPA & HPB||#30705d|6|}}'''</center> | <center>'''{{ColorText|HPA & HPB||#30705d|6|}}'''</center> | ||
| Line 332: | Line 324: | ||
;where=(TaskAbbrev='HPA' OR TaskAbbrev='HPB') AND NOT FellAbbrev IN ('0', '-');color=#000000;text color=#FFFFFF | ;where=(TaskAbbrev='HPA' OR TaskAbbrev='HPB') AND NOT FellAbbrev IN ('0', '-');color=#000000;text color=#FFFFFF | ||
|format=calendar|}} | |format=calendar|}} | ||
| − | |||
== <center>'''{{ColorText|Neuropathology||#30705d|6|}}'''</center> == | == <center>'''{{ColorText|Neuropathology||#30705d|6|}}'''</center> == | ||
<center>'''{{ColorText|NP||#30705d|6|}}'''</center> | <center>'''{{ColorText|NP||#30705d|6|}}'''</center> | ||
| Line 350: | Line 341: | ||
;where=TaskAbbrev='NP' AND NOT FellAbbrev IN ('0', '-');color=#000000;text color=#FFFFFF | ;where=TaskAbbrev='NP' AND NOT FellAbbrev IN ('0', '-');color=#000000;text color=#FFFFFF | ||
|format=calendar|}} | |format=calendar|}} | ||
| − | |||
== <center>'''{{ColorText|Renal||#30705d|6|}}'''</center> == | == <center>'''{{ColorText|Renal||#30705d|6|}}'''</center> == | ||
<center>'''{{ColorText|RP||#30705d|6|}}'''</center> | <center>'''{{ColorText|RP||#30705d|6|}}'''</center> | ||
| Line 368: | Line 358: | ||
;where=TaskAbbrev='RP' AND NOT FellAbbrev IN ('0', '-');color=#000000;text color=#FFFFFF | ;where=TaskAbbrev='RP' AND NOT FellAbbrev IN ('0', '-');color=#000000;text color=#FFFFFF | ||
|format=calendar|}} | |format=calendar|}} | ||
| − | < | + | <br> |
| − | {{: | + | {{:footernohr}} |
Latest revision as of 07:37, October 12, 2019
Contents
Service Schedule (Current Week)
Autopsy
Error: Table scheduleRFAview not found.
Breast
Error: Table scheduleRFAview not found.
Bone & Soft Tissue
Error: Table scheduleRFAview not found.
Cardiovascular & Pulmonary
Error: Table scheduleRFAview not found.
Cytology
Error: Table scheduleRFAview not found.
Dermatopathology
Error: Table scheduleRFAview not found.
Head & Neck
Error: Table scheduleRFAview not found.
Gastrointestinal
Error: Table scheduleRFAview not found.
Genitourinary
Error: Table scheduleRFAview not found.
Gynecologic and Obstetric
Error: Table scheduleRFAview not found.
Hematopathology
Error: Table scheduleRFAview not found.
Neuropathology
Error: Table scheduleRFAview not found.
Renal
Error: Table scheduleRFAview not found.
