Difference between revisions of "scheduleNow"

From MGH Learn Pathology
Line 13: Line 13:
 
{{:scheduleDictionaryAPempty}}
 
{{:scheduleDictionaryAPempty}}
 
|{{#arraymap:{{scheduleDictionaryAPresident}}|;|TaskAbbreviation|
 
|{{#arraymap:{{scheduleDictionaryAPresident}}|;|TaskAbbreviation|
−
{{#cargo_query: tables=scheduleRESservice,residentMGH
+
{{#cargo_query: tables=scheduleRESservice_view
−
|join on=scheduleRESservice.ResAbbrev=residentMGH.copath_id
 
 
|fields=
 
|fields=
−
GROUP_CONCAT(DISTINCT scheduleRESservice.ResAbbrev),
+
ResAbbrev,
−
scheduleRESservice.TaskAbbrev,
+
TaskAbbrev,
−
GROUP_CONCAT(DISTINCT residentMGH.full_name),
+
FullName,
−
scheduleRESservice.TaskTags,
+
Pager
−
pageid
 
 
|group by=scheduleRESservice.WeekNumber
 
|group by=scheduleRESservice.WeekNumber
−
|where=LocationAbbrev='MGH' AND YEAR(Date)={{#timel: Y|{{Timezone}}}} AND scheduleRESservice.WeekNumber='{{#expr: {{#timel: W|{{Timezone}}}} - 0 }}' AND scheduleRESservice.TaskAbbrev='{{#explode:TaskAbbreviation|,|0}}'|default={{schtableempty|{{#explode:TaskAbbreviation|,|2}}}}|format=template|template=scheduleResidentNew}}
+
|where=LocationAbbrev='MGH' AND Year={{#timel: Y|{{Timezone}}}} AND WeekNumber='{{#expr: {{#timel: W|{{Timezone}}}} - 0 }}' AND TaskAbbrev='{{#explode:TaskAbbreviation|,|0}}'|default={{schtableempty|{{#explode:TaskAbbreviation|,|2}}}}|format=template|template=scheduleResidentNew}}
 
|}}
 
|}}
 
}}
 
}}

Revision as of 14:08, July 30, 2024

Anatomic pathology (AMP)
Service
AUT
BST
BR1
BR2
BR3
MGB CV
RP
CA
CB
CC
DP1 (0-2)
DP2 (3-5)
DP3 (6-9)
EYE
FSJ
FSS
GI1 (1-3)
GI2 (4-6)
GI3 (7-8) / (1-5)
GI4 (9-0) / (6-0)
GU1 (0-4)
GU2 (5-9)
GYL
GYS
OB
HN1 (5-9)
HN2 (0-4)
HP1 (BM)
HP2 (LN)
NP
NPAUT
PP
GR-S
AP CHIEF
Resident
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `ResAbbrev` AS `ResAbbrev`,`TaskAbbrev` AS `TaskAbbrev`,`FullName` AS `FullName`,`Pager` AS `Pager` FROM `cargo__scheduleRESservice_view` WHERE LocationAbbrev='MGH' AND Year=2026 AND WeekNumber='12' AND TaskAbbrev='AUT' GROUP BY scheduleRESservice.WeekNumber ORDER BY `ResAbbrev`,`TaskAbbrev`,`FullName`,`Pager` LIMIT 100000 Function: CargoSQLQuery::run Error: 1054 Unknown column 'scheduleRESservice.WeekNumber' in 'group statement' (172.27.81.126:30004)

A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `ResAbbrev` AS `ResAbbrev`,`TaskAbbrev` AS `TaskAbbrev`,`FullName` AS `FullName`,`Pager` AS `Pager` FROM `cargo__scheduleRESservice_view` WHERE LocationAbbrev='MGH' AND Year=2026 AND WeekNumber='12' AND TaskAbbrev='BST' GROUP BY scheduleRESservice.WeekNumber ORDER BY `ResAbbrev`,`TaskAbbrev`,`FullName`,`Pager` LIMIT 100000 Function: CargoSQLQuery::run Error: 1054 Unknown column 'scheduleRESservice.WeekNumber' in 'group statement' (172.27.81.126:30004)

A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `ResAbbrev` AS `ResAbbrev`,`TaskAbbrev` AS `TaskAbbrev`,`FullName` AS `FullName`,`Pager` AS `Pager` FROM `cargo__scheduleRESservice_view` WHERE LocationAbbrev='MGH' AND Year=2026 AND WeekNumber='12' AND TaskAbbrev='BR1' GROUP BY scheduleRESservice.WeekNumber ORDER BY `ResAbbrev`,`TaskAbbrev`,`FullName`,`Pager` LIMIT 100000 Function: CargoSQLQuery::run Error: 1054 Unknown column 'scheduleRESservice.WeekNumber' in 'group statement' (172.27.81.126:30004)

A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `ResAbbrev` AS `ResAbbrev`,`TaskAbbrev` AS `TaskAbbrev`,`FullName` AS `FullName`,`Pager` AS `Pager` FROM `cargo__scheduleRESservice_view` WHERE LocationAbbrev='MGH' AND Year=2026 AND WeekNumber='12' AND TaskAbbrev='BR2' GROUP BY scheduleRESservice.WeekNumber ORDER BY `ResAbbrev`,`TaskAbbrev`,`FullName`,`Pager` LIMIT 100000 Function: CargoSQLQuery::run Error: 1054 Unknown column 'scheduleRESservice.WeekNumber' in 'group statement' (172.27.81.126:30004)

A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `ResAbbrev` AS `ResAbbrev`,`TaskAbbrev` AS `TaskAbbrev`,`FullName` AS `FullName`,`Pager` AS `Pager` FROM `cargo__scheduleRESservice_view` WHERE LocationAbbrev='MGH' AND Year=2026 AND WeekNumber='12' AND TaskAbbrev='BR3' GROUP BY scheduleRESservice.WeekNumber ORDER BY `ResAbbrev`,`TaskAbbrev`,`FullName`,`Pager` LIMIT 100000 Function: CargoSQLQuery::run Error: 1054 Unknown column 'scheduleRESservice.WeekNumber' in 'group statement' (172.27.81.126:30004)

A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `ResAbbrev` AS `ResAbbrev`,`TaskAbbrev` AS `TaskAbbrev`,`FullName` AS `FullName`,`Pager` AS `Pager` FROM `cargo__scheduleRESservice_view` WHERE LocationAbbrev='MGH' AND Year=2026 AND WeekNumber='12' AND TaskAbbrev='MGB CV' GROUP BY scheduleRESservice.WeekNumber ORDER BY `ResAbbrev`,`TaskAbbrev`,`FullName`,`Pager` LIMIT 100000 Function: CargoSQLQuery::run Error: 1054 Unknown column 'scheduleRESservice.WeekNumber' in 'group statement' (172.27.81.126:30004)

A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `ResAbbrev` AS `ResAbbrev`,`TaskAbbrev` AS `TaskAbbrev`,`FullName` AS `FullName`,`Pager` AS `Pager` FROM `cargo__scheduleRESservice_view` WHERE LocationAbbrev='MGH' AND Year=2026 AND WeekNumber='12' AND TaskAbbrev='RP' GROUP BY scheduleRESservice.WeekNumber ORDER BY `ResAbbrev`,`TaskAbbrev`,`FullName`,`Pager` LIMIT 100000 Function: CargoSQLQuery::run Error: 1054 Unknown column 'scheduleRESservice.WeekNumber' in 'group statement' (172.27.81.126:30004)

A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `ResAbbrev` AS `ResAbbrev`,`TaskAbbrev` AS `TaskAbbrev`,`FullName` AS `FullName`,`Pager` AS `Pager` FROM `cargo__scheduleRESservice_view` WHERE LocationAbbrev='MGH' AND Year=2026 AND WeekNumber='12' AND TaskAbbrev='CA' GROUP BY scheduleRESservice.WeekNumber ORDER BY `ResAbbrev`,`TaskAbbrev`,`FullName`,`Pager` LIMIT 100000 Function: CargoSQLQuery::run Error: 1054 Unknown column 'scheduleRESservice.WeekNumber' in 'group statement' (172.27.81.126:30004)

A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `ResAbbrev` AS `ResAbbrev`,`TaskAbbrev` AS `TaskAbbrev`,`FullName` AS `FullName`,`Pager` AS `Pager` FROM `cargo__scheduleRESservice_view` WHERE LocationAbbrev='MGH' AND Year=2026 AND WeekNumber='12' AND TaskAbbrev='CB' GROUP BY scheduleRESservice.WeekNumber ORDER BY `ResAbbrev`,`TaskAbbrev`,`FullName`,`Pager` LIMIT 100000 Function: CargoSQLQuery::run Error: 1054 Unknown column 'scheduleRESservice.WeekNumber' in 'group statement' (172.27.81.126:30004)

A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `ResAbbrev` AS `ResAbbrev`,`TaskAbbrev` AS `TaskAbbrev`,`FullName` AS `FullName`,`Pager` AS `Pager` FROM `cargo__scheduleRESservice_view` WHERE LocationAbbrev='MGH' AND Year=2026 AND WeekNumber='12' AND TaskAbbrev='CC' GROUP BY scheduleRESservice.WeekNumber ORDER BY `ResAbbrev`,`TaskAbbrev`,`FullName`,`Pager` LIMIT 100000 Function: CargoSQLQuery::run Error: 1054 Unknown column 'scheduleRESservice.WeekNumber' in 'group statement' (172.27.81.126:30004)

A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `ResAbbrev` AS `ResAbbrev`,`TaskAbbrev` AS `TaskAbbrev`,`FullName` AS `FullName`,`Pager` AS `Pager` FROM `cargo__scheduleRESservice_view` WHERE LocationAbbrev='MGH' AND Year=2026 AND WeekNumber='12' AND TaskAbbrev='DP1 (0-2)' GROUP BY scheduleRESservice.WeekNumber ORDER BY `ResAbbrev`,`TaskAbbrev`,`FullName`,`Pager` LIMIT 100000 Function: CargoSQLQuery::run Error: 1054 Unknown column 'scheduleRESservice.WeekNumber' in 'group statement' (172.27.81.126:30004)

A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `ResAbbrev` AS `ResAbbrev`,`TaskAbbrev` AS `TaskAbbrev`,`FullName` AS `FullName`,`Pager` AS `Pager` FROM `cargo__scheduleRESservice_view` WHERE LocationAbbrev='MGH' AND Year=2026 AND WeekNumber='12' AND TaskAbbrev='DP2 (3-5)' GROUP BY scheduleRESservice.WeekNumber ORDER BY `ResAbbrev`,`TaskAbbrev`,`FullName`,`Pager` LIMIT 100000 Function: CargoSQLQuery::run Error: 1054 Unknown column 'scheduleRESservice.WeekNumber' in 'group statement' (172.27.81.126:30004)

A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `ResAbbrev` AS `ResAbbrev`,`TaskAbbrev` AS `TaskAbbrev`,`FullName` AS `FullName`,`Pager` AS `Pager` FROM `cargo__scheduleRESservice_view` WHERE LocationAbbrev='MGH' AND Year=2026 AND WeekNumber='12' AND TaskAbbrev='DP3 (6-9)' GROUP BY scheduleRESservice.WeekNumber ORDER BY `ResAbbrev`,`TaskAbbrev`,`FullName`,`Pager` LIMIT 100000 Function: CargoSQLQuery::run Error: 1054 Unknown column 'scheduleRESservice.WeekNumber' in 'group statement' (172.27.81.126:30004)

A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `ResAbbrev` AS `ResAbbrev`,`TaskAbbrev` AS `TaskAbbrev`,`FullName` AS `FullName`,`Pager` AS `Pager` FROM `cargo__scheduleRESservice_view` WHERE LocationAbbrev='MGH' AND Year=2026 AND WeekNumber='12' AND TaskAbbrev='EYE' GROUP BY scheduleRESservice.WeekNumber ORDER BY `ResAbbrev`,`TaskAbbrev`,`FullName`,`Pager` LIMIT 100000 Function: CargoSQLQuery::run Error: 1054 Unknown column 'scheduleRESservice.WeekNumber' in 'group statement' (172.27.81.126:30004)

A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `ResAbbrev` AS `ResAbbrev`,`TaskAbbrev` AS `TaskAbbrev`,`FullName` AS `FullName`,`Pager` AS `Pager` FROM `cargo__scheduleRESservice_view` WHERE LocationAbbrev='MGH' AND Year=2026 AND WeekNumber='12' AND TaskAbbrev='FSJ' GROUP BY scheduleRESservice.WeekNumber ORDER BY `ResAbbrev`,`TaskAbbrev`,`FullName`,`Pager` LIMIT 100000 Function: CargoSQLQuery::run Error: 1054 Unknown column 'scheduleRESservice.WeekNumber' in 'group statement' (172.27.81.126:30004)

A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `ResAbbrev` AS `ResAbbrev`,`TaskAbbrev` AS `TaskAbbrev`,`FullName` AS `FullName`,`Pager` AS `Pager` FROM `cargo__scheduleRESservice_view` WHERE LocationAbbrev='MGH' AND Year=2026 AND WeekNumber='12' AND TaskAbbrev='FSS' GROUP BY scheduleRESservice.WeekNumber ORDER BY `ResAbbrev`,`TaskAbbrev`,`FullName`,`Pager` LIMIT 100000 Function: CargoSQLQuery::run Error: 1054 Unknown column 'scheduleRESservice.WeekNumber' in 'group statement' (172.27.81.126:30004)

A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `ResAbbrev` AS `ResAbbrev`,`TaskAbbrev` AS `TaskAbbrev`,`FullName` AS `FullName`,`Pager` AS `Pager` FROM `cargo__scheduleRESservice_view` WHERE LocationAbbrev='MGH' AND Year=2026 AND WeekNumber='12' AND TaskAbbrev='GI1 (1-3)' GROUP BY scheduleRESservice.WeekNumber ORDER BY `ResAbbrev`,`TaskAbbrev`,`FullName`,`Pager` LIMIT 100000 Function: CargoSQLQuery::run Error: 1054 Unknown column 'scheduleRESservice.WeekNumber' in 'group statement' (172.27.81.126:30004)

A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `ResAbbrev` AS `ResAbbrev`,`TaskAbbrev` AS `TaskAbbrev`,`FullName` AS `FullName`,`Pager` AS `Pager` FROM `cargo__scheduleRESservice_view` WHERE LocationAbbrev='MGH' AND Year=2026 AND WeekNumber='12' AND TaskAbbrev='GI2 (4-6)' GROUP BY scheduleRESservice.WeekNumber ORDER BY `ResAbbrev`,`TaskAbbrev`,`FullName`,`Pager` LIMIT 100000 Function: CargoSQLQuery::run Error: 1054 Unknown column 'scheduleRESservice.WeekNumber' in 'group statement' (172.27.81.126:30004)

A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `ResAbbrev` AS `ResAbbrev`,`TaskAbbrev` AS `TaskAbbrev`,`FullName` AS `FullName`,`Pager` AS `Pager` FROM `cargo__scheduleRESservice_view` WHERE LocationAbbrev='MGH' AND Year=2026 AND WeekNumber='12' AND TaskAbbrev='GI3 (7-8) / (1-5)' GROUP BY scheduleRESservice.WeekNumber ORDER BY `ResAbbrev`,`TaskAbbrev`,`FullName`,`Pager` LIMIT 100000 Function: CargoSQLQuery::run Error: 1054 Unknown column 'scheduleRESservice.WeekNumber' in 'group statement' (172.27.81.126:30004)

A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `ResAbbrev` AS `ResAbbrev`,`TaskAbbrev` AS `TaskAbbrev`,`FullName` AS `FullName`,`Pager` AS `Pager` FROM `cargo__scheduleRESservice_view` WHERE LocationAbbrev='MGH' AND Year=2026 AND WeekNumber='12' AND TaskAbbrev='GI4 (9-0) / (6-0)' GROUP BY scheduleRESservice.WeekNumber ORDER BY `ResAbbrev`,`TaskAbbrev`,`FullName`,`Pager` LIMIT 100000 Function: CargoSQLQuery::run Error: 1054 Unknown column 'scheduleRESservice.WeekNumber' in 'group statement' (172.27.81.126:30004)

A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `ResAbbrev` AS `ResAbbrev`,`TaskAbbrev` AS `TaskAbbrev`,`FullName` AS `FullName`,`Pager` AS `Pager` FROM `cargo__scheduleRESservice_view` WHERE LocationAbbrev='MGH' AND Year=2026 AND WeekNumber='12' AND TaskAbbrev='GU1 (0-4)' GROUP BY scheduleRESservice.WeekNumber ORDER BY `ResAbbrev`,`TaskAbbrev`,`FullName`,`Pager` LIMIT 100000 Function: CargoSQLQuery::run Error: 1054 Unknown column 'scheduleRESservice.WeekNumber' in 'group statement' (172.27.81.126:30004)

A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `ResAbbrev` AS `ResAbbrev`,`TaskAbbrev` AS `TaskAbbrev`,`FullName` AS `FullName`,`Pager` AS `Pager` FROM `cargo__scheduleRESservice_view` WHERE LocationAbbrev='MGH' AND Year=2026 AND WeekNumber='12' AND TaskAbbrev='GU2 (5-9)' GROUP BY scheduleRESservice.WeekNumber ORDER BY `ResAbbrev`,`TaskAbbrev`,`FullName`,`Pager` LIMIT 100000 Function: CargoSQLQuery::run Error: 1054 Unknown column 'scheduleRESservice.WeekNumber' in 'group statement' (172.27.81.126:30004)

A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `ResAbbrev` AS `ResAbbrev`,`TaskAbbrev` AS `TaskAbbrev`,`FullName` AS `FullName`,`Pager` AS `Pager` FROM `cargo__scheduleRESservice_view` WHERE LocationAbbrev='MGH' AND Year=2026 AND WeekNumber='12' AND TaskAbbrev='GYL' GROUP BY scheduleRESservice.WeekNumber ORDER BY `ResAbbrev`,`TaskAbbrev`,`FullName`,`Pager` LIMIT 100000 Function: CargoSQLQuery::run Error: 1054 Unknown column 'scheduleRESservice.WeekNumber' in 'group statement' (172.27.81.126:30004)

A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `ResAbbrev` AS `ResAbbrev`,`TaskAbbrev` AS `TaskAbbrev`,`FullName` AS `FullName`,`Pager` AS `Pager` FROM `cargo__scheduleRESservice_view` WHERE LocationAbbrev='MGH' AND Year=2026 AND WeekNumber='12' AND TaskAbbrev='GYS' GROUP BY scheduleRESservice.WeekNumber ORDER BY `ResAbbrev`,`TaskAbbrev`,`FullName`,`Pager` LIMIT 100000 Function: CargoSQLQuery::run Error: 1054 Unknown column 'scheduleRESservice.WeekNumber' in 'group statement' (172.27.81.126:30004)

A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `ResAbbrev` AS `ResAbbrev`,`TaskAbbrev` AS `TaskAbbrev`,`FullName` AS `FullName`,`Pager` AS `Pager` FROM `cargo__scheduleRESservice_view` WHERE LocationAbbrev='MGH' AND Year=2026 AND WeekNumber='12' AND TaskAbbrev='OB' GROUP BY scheduleRESservice.WeekNumber ORDER BY `ResAbbrev`,`TaskAbbrev`,`FullName`,`Pager` LIMIT 100000 Function: CargoSQLQuery::run Error: 1054 Unknown column 'scheduleRESservice.WeekNumber' in 'group statement' (172.27.81.126:30004)

A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `ResAbbrev` AS `ResAbbrev`,`TaskAbbrev` AS `TaskAbbrev`,`FullName` AS `FullName`,`Pager` AS `Pager` FROM `cargo__scheduleRESservice_view` WHERE LocationAbbrev='MGH' AND Year=2026 AND WeekNumber='12' AND TaskAbbrev='HN1 (5-9)' GROUP BY scheduleRESservice.WeekNumber ORDER BY `ResAbbrev`,`TaskAbbrev`,`FullName`,`Pager` LIMIT 100000 Function: CargoSQLQuery::run Error: 1054 Unknown column 'scheduleRESservice.WeekNumber' in 'group statement' (172.27.81.126:30004)

A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `ResAbbrev` AS `ResAbbrev`,`TaskAbbrev` AS `TaskAbbrev`,`FullName` AS `FullName`,`Pager` AS `Pager` FROM `cargo__scheduleRESservice_view` WHERE LocationAbbrev='MGH' AND Year=2026 AND WeekNumber='12' AND TaskAbbrev='HN2 (0-4)' GROUP BY scheduleRESservice.WeekNumber ORDER BY `ResAbbrev`,`TaskAbbrev`,`FullName`,`Pager` LIMIT 100000 Function: CargoSQLQuery::run Error: 1054 Unknown column 'scheduleRESservice.WeekNumber' in 'group statement' (172.27.81.126:30004)

A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `ResAbbrev` AS `ResAbbrev`,`TaskAbbrev` AS `TaskAbbrev`,`FullName` AS `FullName`,`Pager` AS `Pager` FROM `cargo__scheduleRESservice_view` WHERE LocationAbbrev='MGH' AND Year=2026 AND WeekNumber='12' AND TaskAbbrev='HP1 (BM)' GROUP BY scheduleRESservice.WeekNumber ORDER BY `ResAbbrev`,`TaskAbbrev`,`FullName`,`Pager` LIMIT 100000 Function: CargoSQLQuery::run Error: 1054 Unknown column 'scheduleRESservice.WeekNumber' in 'group statement' (172.27.81.126:30004)

A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `ResAbbrev` AS `ResAbbrev`,`TaskAbbrev` AS `TaskAbbrev`,`FullName` AS `FullName`,`Pager` AS `Pager` FROM `cargo__scheduleRESservice_view` WHERE LocationAbbrev='MGH' AND Year=2026 AND WeekNumber='12' AND TaskAbbrev='HP2 (LN)' GROUP BY scheduleRESservice.WeekNumber ORDER BY `ResAbbrev`,`TaskAbbrev`,`FullName`,`Pager` LIMIT 100000 Function: CargoSQLQuery::run Error: 1054 Unknown column 'scheduleRESservice.WeekNumber' in 'group statement' (172.27.81.126:30004)

A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `ResAbbrev` AS `ResAbbrev`,`TaskAbbrev` AS `TaskAbbrev`,`FullName` AS `FullName`,`Pager` AS `Pager` FROM `cargo__scheduleRESservice_view` WHERE LocationAbbrev='MGH' AND Year=2026 AND WeekNumber='12' AND TaskAbbrev='NP' GROUP BY scheduleRESservice.WeekNumber ORDER BY `ResAbbrev`,`TaskAbbrev`,`FullName`,`Pager` LIMIT 100000 Function: CargoSQLQuery::run Error: 1054 Unknown column 'scheduleRESservice.WeekNumber' in 'group statement' (172.27.81.126:30004)

A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `ResAbbrev` AS `ResAbbrev`,`TaskAbbrev` AS `TaskAbbrev`,`FullName` AS `FullName`,`Pager` AS `Pager` FROM `cargo__scheduleRESservice_view` WHERE LocationAbbrev='MGH' AND Year=2026 AND WeekNumber='12' AND TaskAbbrev='NPAUT' GROUP BY scheduleRESservice.WeekNumber ORDER BY `ResAbbrev`,`TaskAbbrev`,`FullName`,`Pager` LIMIT 100000 Function: CargoSQLQuery::run Error: 1054 Unknown column 'scheduleRESservice.WeekNumber' in 'group statement' (172.27.81.126:30004)

A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `ResAbbrev` AS `ResAbbrev`,`TaskAbbrev` AS `TaskAbbrev`,`FullName` AS `FullName`,`Pager` AS `Pager` FROM `cargo__scheduleRESservice_view` WHERE LocationAbbrev='MGH' AND Year=2026 AND WeekNumber='12' AND TaskAbbrev='PP' GROUP BY scheduleRESservice.WeekNumber ORDER BY `ResAbbrev`,`TaskAbbrev`,`FullName`,`Pager` LIMIT 100000 Function: CargoSQLQuery::run Error: 1054 Unknown column 'scheduleRESservice.WeekNumber' in 'group statement' (172.27.81.126:30004)

A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `ResAbbrev` AS `ResAbbrev`,`TaskAbbrev` AS `TaskAbbrev`,`FullName` AS `FullName`,`Pager` AS `Pager` FROM `cargo__scheduleRESservice_view` WHERE LocationAbbrev='MGH' AND Year=2026 AND WeekNumber='12' AND TaskAbbrev='GR-S' GROUP BY scheduleRESservice.WeekNumber ORDER BY `ResAbbrev`,`TaskAbbrev`,`FullName`,`Pager` LIMIT 100000 Function: CargoSQLQuery::run Error: 1054 Unknown column 'scheduleRESservice.WeekNumber' in 'group statement' (172.27.81.126:30004)

A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `ResAbbrev` AS `ResAbbrev`,`TaskAbbrev` AS `TaskAbbrev`,`FullName` AS `FullName`,`Pager` AS `Pager` FROM `cargo__scheduleRESservice_view` WHERE LocationAbbrev='MGH' AND Year=2026 AND WeekNumber='12' AND TaskAbbrev='AP CHIEF' GROUP BY scheduleRESservice.WeekNumber ORDER BY `ResAbbrev`,`TaskAbbrev`,`FullName`,`Pager` LIMIT 100000 Function: CargoSQLQuery::run Error: 1054 Unknown column 'scheduleRESservice.WeekNumber' in 'group statement' (172.27.81.126:30004)

Fellow
-
-
-
-
-
-
-
-
-
HH579
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
EZR
-
-
-
Attending[1]
Patalas
Nielsen
Sgroi
Guidi
-
-
Smith
Zhang
Zhang
Madrigal
Moran
Laga Canales
Hoang
Wolkow
Oliva
Oliva
Redston
Liao
Shih
Drage
Lu
Devins
Young
Oliva
Brackett
Sadow
Alzumaili
Sohani
Fitzpatrick
Stemmer-Rach
-
Hung
-
-
Call
Patalas
Nielsen
Sgroi
Sgroi
Sgroi
Padera
Smith
Zhang
Zhang
Zhang
Moran
Moran
Moran
ANA
-
-
Drage
Drage
Drage
Drage
Lu
Lu
Young
Young
Brackett
Alzumaili
Alzumaili
Sohani
Sohani
Stemmer-Rach
Stemmer-Rach
Hung
-
-

Clinical pathology (LMM)
Service
BTS
COAG
CORE
MICRO
HLA - A
HLA - B
HPA
HPB
HG
MOL: Consult
MOL: HER2
MOL: A non-NGS
MOL: A NGS
MOL: B NGS
MOL: B non-NGS
MOL: B FISH
IMMUNO
CP CHIEF
Resident
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
JSE
Fellow
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
Attending[1]
Makar
Connell
LiuL
-
-
-
Sohani
Fitzpatrick
Higgins
-
-
-
-
-
-
-
MFL12
-
Call
27364
No results Connell
15433
32443
25338
25338
Sohani
Sohani
Higgins
-
-
-
-
-
-
-
MFL12
-

[1]Faculty schedule displayed using the QGenda API.

Retrieved from "https://learn.mghpathology.org/index.php?title=scheduleNow&oldid=130884"
  • Powered by MediaWiki
  • Search Powered by Cargo
  • Massachusetts General Hospital