Spreadsheet: 832245d1686209111-transferring-data-from-one-tab-into-another-mini-f2f-audio-pbi-report-v2
Sheet: HS escalation appointments

Case Reference | Appointment Date | Employee Division | Employee Location | Employee Department
SW/HE/20/36-C2 | 2023-01-19 13:30:00 | CSD | Remote Qnr Assessment 1 | Water West Ayr North Dept
SW/HE/20/39-C3 | 2023-06-02 12:00:00 | CSD | Remote Qnr Assessment 11 | Strategic Valve Maint Team
SW/HE/21/63-C2 | 2023-01-13 09:00:00 | CSD | CUSTOMER_SERVICE | CS Water Response Connections
SW/HE/21/74-C1 | 2023-05-25 13:30:00 | CSD | Remote Qnr Assessment 25 | CS Field Response Fort William
SW/HE/22/125-C1 | 2022-12-09 13:30:00 | CSD | Remote QNR Assessment 39 | Waste East Treatment [NAME]
SW/HE/22/146-C2 | 2022-12-22 11:30:00 | CSD | Remote QNR Assessment 35 | EM East Tay
SW/HE/22/146-C3 | 2023-01-12 09:30:00 | CSD | Remote QNR Assessment 35 | EM East Tay
SW/HE/22/164-C1 | 2022-12-12 15:00:00 | CSD | Remote QNR Assessment 54 | Waste East Networks Tay Dept
SW/HE/22/168 | 2022-11-21 10:00:00 | CSD | The Bridge | CS Sewer Response North Clyde
SW/HE/22/169 | 2022-12-01 13:30:00 | CSD | The Bridge | Water South Lanark Dept
SW/HE/22/170 | 2022-12-06 14:00:00 | CSD | The Bridge | Water South Lanark Dept
SW/HE/22/171 | 2022-12-05 08:30:00 | CSD | Fairmilehead Office | [NAME]
SW/HE/22/172 | 2022-12-05 10:00:00 | CSD | Fairmilehead Office | [NAME]
SW/HE/22/173 | 2022-11-30 12:30:00 | CSD | Fairmilehead Office | Water Sth Edin & Lothians Dept
SW/HE/22/174 | 2022-12-05 11:00:00 | CSD | Fairmilehead Office | [NAME]
SW/HE/22/175 | 2023-01-03 11:00:00 | CSD | Fairmilehead Office | CS Water Response Tweed 1
SW/HE/22/176 | 2022-12-05 09:00:00 | CSD | Fairmilehead Office | Water Sth Edin & Lothians Dept
SW/HE/22/177 | 2022-12-01 14:30:00 | CSD | Fairmilehead Office | CS Fld Response N Ayr Clyd Fth
SW/HE/22/178 | 2022-12-06 08:30:00 | CSD | Forth House | CS Water Response West TM
SW/HE/22/179 | 2022-12-06 14:30:00 | CSD | Fairmilehead Office | Water South Borders Dept
SW/HE/22/180 | 2023-02-27 13:30:00 | CSD | Kingshill House | Water East Trtmnt [NAME]
SW/HE/22/181 | 2022-12-20 14:30:00 | CSD | Kingshill House | Water East Trtmnt Don South
SW/HE/23/182 | 2023-02-28 14:00:00 | CSD | Kingshill House | Waste East WWT & Net Don Sth
SW/HE/23/182-C1 | 2023-03-17 09:30:00 | CSD | Kingshill House | Waste East WWT & Net Don Sth
SW/HE/23/183 | 2023-02-08 08:30:00 | CSD | Kingshill House | [NAME] [NAME]
SW/HE/23/185 | 2023-02-14 11:00:00 | CSD | Inverness Area Office | Waste Tankering North West
SW/HE/23/185-C1 | 2023-03-09 11:30:00 | CSD | Inverness Area Office | Waste Tankering North West
SW/HE/23/197 | 2023-03-02 11:30:00 | CSD | Bullion House | [NAME] [NAME]
SW/HE/23/198 | 2023-03-13 14:30:00 | CSD | Bullion House | East W R&LP
SW/HE/23/199 | 2023-03-03 09:30:00 | CSD | Fairmilehead Office | [NAME]
SW/HE/23/200 | 2023-04-03 13:30:00 | CSD | Fairmilehead Office | Byelaws South Dept
SW/HE/23/201 | 2023-03-14 13:30:00 | CSD | Shetland Area Office | CS Sewer Response Shetland
SW/HE/23/202 | 2023-05-03 11:00:00 | CSD | Fairmilehead Office | Waste South Lothians 2 Dept
SW/HE/23/203 | 2023-03-10 14:30:00 | CSD | The Bridge | CS Sewer Response North Clyde
SW/HE/23/204 | 2023-03-10 15:30:00 | CSD | Forth House | CS Water Response Forth
SW/HE/23/204-C1 | 2023-04-11 13:00:00 | CSD | Forth House | CS Water Response Forth
SW/HE/23/205 | 2023-03-20 09:45:00 | People Directorate | Fairmilehead Office | Training Centre-Skills Academy
SW/HE/23/206 | 2023-03-14 16:00:00 | CSD | The Bridge | EM South Nith
SW/HE/23/207 | 2023-03-21 11:30:00 | CSD | The Bridge | H&S Water Wastewater E&M Dept
SW/HE/23/210 | 2023-05-09 13:30:00 | CSD | The Bridge | EM South Nith
SW/HE/23/211 | 2023-03-18 11:30:00 | CSD | Oban Office | EM North West Coast
SW/HE/23/212 | 2023-03-21 14:00:00 | Capital Investment | Oban Office | ESD Non Infra Alliance
SW/HE/23/213 | 2023-03-21 08:45:00 | AM_CUS_SERV_PLAN | Oban Office | Sampling North
SW/HE/23/214 | 2023-03-21 10:00:00 | CSD | Wick Area Office & Depot | CS Sewer Response Caithness
SW/HE/23/215 | 2023-05-30 10:30:00 | AM_CUS_SERV_PLAN | Wick Area Office & Depot | Sampling North
SW/HE/23/217 | 2023-03-28 13:30:00 | CSD | Oban Office | Water North Argyl Multi Main
SW/HE/23/218 | 2023-06-02 11:30:00 | CSD | Oban Office | [NAME] Dept
SW/HE/23/219 | 2023-06-02 13:30:00 | CSD | Oban Office | Water North Argyl Multi Main
SW/HE/23/220 | 2023-06-02 09:30:00 | CSD | Oban Office | Water North Argyl Multi Main
SW/HE/23/221 | 2023-03-21 10:30:00 | CSD | Oban Office | Water North Argyl Multi Main
SW/HE/23/222 | 2023-03-21 16:00:00 | CSD | Inverness Area Office | North W R&LP
SW/HE/23/224 | 2023-03-23 14:30:00 | CSD | Portree Area Office and Depot | Water North Skye & LochabrWest
SW/HE/23/225 | 2023-03-28 16:00:00 | CSD | Portree Area Office and Depot | Water North Skye & LochabrWest
SW/HE/23/226 | 2023-03-22 14:30:00 | CSD | Portree Area Office and Depot | CS Field Response Skye
SW/HE/23/227 | 2023-04-05 12:30:00 | CSD | Portree Area Office and Depot | CS Field Response Skye
SW/HE/23/228 | 2023-03-27 11:45:00 | CSD | Portree Area Office and Depot | Water North Skye & LochabrWest
SW/HE/23/229 | 2023-03-28 14:30:00 | CSD | Portree Area Office and Depot | Water North Skye & LochabrWest
SW/HE/23/230 | 2023-03-27 13:30:00 | CSD | Portree Area Office and Depot | Water North Skye & LochabrWest
SW/HE/23/230-C1 | 2023-04-21 14:30:00 | CSD | Portree Area Office and Depot | Water North Skye & LochabrWest
SW/HE/23/231 | 2023-03-24 12:00:00 | CSD | Portree Area Office and Depot | Water North Skye & LochabrWest
SW/HE/23/232 | 2023-03-23 09:30:00 | CSD | Portree Area Office and Depot | Water North Skye & LochabrWest
SW/HE/23/232-C1 | 2023-04-18 10:00:00 | CSD | Portree Area Office and Depot | Water North Skye & LochabrWest
SW/HE/23/233 | 2023-03-29 10:00:00 | CSD | Portree Area Office and Depot | Water North Skye & LochabrWest
SW/HE/23/234 | 2023-03-27 09:45:00 | CSD | Portree Area Office and Depot | CS Field Response Skye
SW/HE/23/234-C1 | 2023-04-21 10:30:00 | CSD | Portree Area Office and Depot | CS Field Response Skye
SW/HE/23/234-C2 | 2023-05-30 14:30:00 | CSD | Portree Area Office and Depot | CS Field Response Skye
SW/HE/23/235 | 2023-03-30 09:30:00 | CSD | Inverness Area Office | North W R&LP
SW/HE/23/236 | 2023-05-04 09:30:00 | CSD | Inverness Area Office | Water North Inv & Lochabr East
SW/HE/23/237 | 2023-03-24 13:30:00 | CSD | Gowans Terrace WTW & Depot | East W R&LP
SW/HE/23/238 | 2023-03-24 14:30:00 | CSD | Gowans Terrace WTW & Depot | Waste East Networks Tay Dept
SW/HE/23/239 | 2023-05-19 12:00:00 | AM_CUS_SERV_PLAN | Inverness Area Office | Sampling Demand Dept
SW/HE/23/240 | 2023-05-10 11:00:00 | CSD | Inverness Area Office | EM North Ness
SW/HE/23/241 | 2023-04-27 08:45:00 | CSD | Inverness Area Office | Metering division - setup cost
SW/HE/23/241-C1 | 2023-05-25 10:30:00 | CSD | Inverness Area Office | Metering division - setup cost
SW/HE/23/242 | 2023-04-14 15:30:00 | CSD | Inverness Area Office | Performance & Reward Dept
SW/HE/23/244 | 2023-04-12 13:30:00 | SCSP | Inverness Area Office | Compliance Peformance
SW/HE/23/245 | 2023-03-28 14:30:00 | CSD | Inverness Area Office | Water Operations Mgr West Dept
SW/HE/23/246 | 2023-03-29 14:30:00 | CSD | Inverness Area Office | CS Sewer Response Caithness
SW/HE/23/247 | 2023-04-03 10:00:00 | CSD | Inverness Area Office | H&S Water Wastewater E&M Dept
SW/HE/23/247-C1 | 2023-05-16 11:00:00 | CSD | Inverness Area Office | H&S Water Wastewater E&M Dept
SW/HE/23/248 | 2023-04-11 09:30:00 | CSD | The Bridge | CS Field Response [NAME]
SW/HE/23/248-C1 | 2023-05-19 10:00:00 | CSD | The Bridge | CS Field Response [NAME]
SW/HE/23/248-C2 | 2023-06-15 14:30:00 | CSD | The Bridge | CS Field Response [NAME]
SW/HE/23/249 | 2023-03-29 09:30:00 | CSD | Elgin Area Office | Waste East WWT & Net [NAME]
SW/HE/23/250-C1 | 2023-06-02 12:00:00 | CSD | Elgin Area Office | CS Field Response Don
SW/HE/23/251 | 2023-03-31 09:30:00 | CSD | Elgin Area Office | EM East Don
SW/HE/23/252 | 2023-04-04 08:30:00 | CSD | Elgin Area Office | EM East Don
SW/HE/23/253 | 2023-04-06 14:00:00 | CSD | Elgin Area Office | Water East Trtmnt [NAME]
SW/HE/23/254 | 2023-03-31 10:30:00 | CSD | Elgin Area Office | CS Water Response Don
SW/HE/23/255 | 2023-03-29 15:30:00 | CSD | Elgin Area Office | EM East Don
SW/HE/23/256 | 2023-04-13 10:30:00 | CSD | Elgin Area Office | Water East Trtmnt [NAME]
SW/HE/23/256-C1 | 2023-05-11 13:00:00 | CSD | Elgin Area Office | Water East Trtmnt [NAME]
SW/HE/23/257 | 2023-03-31 11:30:00 | CSD | The Bridge | Waste South Lanarkshire 2 Dept
SW/HE/23/258 | 2023-04-04 10:00:00 | CSD | Forth House | Waste West Forth TL3 Dept
SW/HE/23/259 | 2023-03-31 13:30:00 | CSD | Forth House | Waste West Forth TL3 Dept
SW/HE/23/260 | 2023-03-27 10:45:00 | CSD | The Bridge | CS Sewer Response South Clyde
SW/HE/23/260-C1 | 2023-04-21 11:30:00 | CSD | The Bridge | CS Sewer Response South Clyde
SW/HE/23/261 | 2023-04-12 14:30:00 | CSD | Elgin Area Office | Waste East WWT & Net [NAME]
SW/HE/23/262 | 2023-04-28 08:45:00 | CSD | Elgin Area Office | Waste East WWT & Net [NAME]
SW/HE/23/263 | 2023-04-03 11:30:00 | CSD | Elgin Area Office | EM East Don
SW/HE/23/265 | 2023-04-28 10:00:00 | CSD | Elgin Area Office | Water East Trtmnt [NAME]
SW/HE/23/267 | 2023-04-04 14:30:00 | CSD | Elgin Area Office | Water East Trtmnt [NAME]
SW/HE/23/269 | 2023-04-05 10:00:00 | CSD | Elgin Area Office | Water East Trtmnt [NAME]
SW/HE/23/269-C1 | 2023-05-30 11:00:00 | CSD | Elgin Area Office | Water East Trtmnt [NAME]
SW/HE/23/270 | 2023-05-09 14:30:00 | CSD | The Bridge | [NAME]
SW/HE/23/271 | 2023-04-05 13:30:00 | CSD | Prestwick Office | Waste West Ayr TL 1 Dept
SW/HE/23/272 | 2023-04-05 14:30:00 | CSD | Prestwick Office | CS Sewer Response South Clyde
SW/HE/23/273 | 2023-05-02 13:30:00 | AM_CUS_SERV_PLAN | Fort William Area Office | Sampling North
SW/HE/23/274 | 2023-05-12 10:30:00 | CSD | Fort William Area Office | Waste Tankering North West
SW/HE/23/275 | 2023-05-12 09:30:00 | CSD | Lochgilphead Office | EM North West Coast
SW/HE/23/276 | 2023-04-28 12:00:00 | CSD | Gowans Terrace WTW & Depot | Waste East Trtmnt Tay East
SW/HE/23/278 | 2023-06-14 08:30:00 | CSD | Gowans Terrace WTW & Depot | H&S Water Wastewater E&M Dept
SW/HE/23/279 | 2023-05-02 10:00:00 | CSD | Gowans Terrace WTW & Depot | CS Water Response Tay
SW/HE/23/280 | 2023-04-20 09:30:00 | CSD | Gowans Terrace WTW & Depot | Waste East Trtmnt Tay East
SW/HE/23/281 | 2023-04-25 11:00:00 | CSD | Gowans Terrace WTW & Depot | Waste East Trtmnt Tay East
SW/HE/23/282 | 2023-04-25 09:30:00 | CSD | The Bridge | EM West Forth
SW/HE/23/284 | 2023-05-15 11:00:00 | CSD | Gowans Terrace WTW & Depot | Waste East Trtmnt [NAME]
SW/HE/23/285 | 2023-05-19 10:00:00 | CSD | The Bridge | South W R&LP
SW/HE/23/287 | 2023-04-25 11:30:00 | CSD | The Bridge | EM West Forth
SW/HE/23/288 | 2023-04-26 14:30:00 | CSD | Bullion House | Waste Ops Vactoring
SW/HE/23/288-C1 | 2023-05-23 14:30:00 | CSD | Bullion House | Waste Ops Vactoring
SW/HE/23/289 | 2023-04-25 10:30:00 | AM_CUS_SERV_PLAN | Bullion House | Sampling South
SW/HE/23/290 | 2023-04-25 09:30:00 | CSD | Bullion House | Waste East Treatment [NAME]
SW/HE/23/291 | 2023-04-25 15:30:00 | CSD | Bullion House | Water East Trtmnt Tay West
SW/HE/23/292 | 2023-04-25 14:30:00 | CSD | Bullion House | Waste Ops Vactoring
SW/HE/23/293 | 2023-04-24 15:30:00 | CSD | Bullion House | CS Water Response Tay
SW/HE/23/294 | 2023-04-25 13:30:00 | CSD | Bullion House | Waste East Treatment [NAME]
SW/HE/23/295 | 2023-04-28 09:00:00 | CSD | Bullion House | East W R&LP
SW/HE/23/297 | 2023-04-19 15:30:00 | CSD | Bullion House | Waste Tankering Central East
SW/HE/23/298 | 2023-04-19 11:30:00 | CSD | Bullion House | EM East Tay
SW/HE/23/300 | 2023-04-19 13:30:00 | CSD | Bullion House | EM East Don
SW/HE/23/302 | 2023-04-19 10:30:00 | CSD | Bullion House | Waste Ops Vactoring
SW/HE/23/303 | 2023-05-12 12:00:00 | CSD | The Bridge | CS Water Response Connections
SW/HE/23/304 | 2023-04-28 10:00:00 | CSD | Bullion House | Waste Tankering Central East
SW/HE/23/307 | 2023-05-02 15:45:00 | AM_CUS_SERV_PLAN | Juniper House | Inorganics
SW/HE/23/308 | 2023-05-02 09:30:00 | AM_CUS_SERV_PLAN | Juniper House | Inorganics
SW/HE/23/315 | 2023-05-11 10:00:00 | AM_CUS_SERV_PLAN | Juniper House | Microbiology
SW/HE/23/316 | 2023-06-26 09:45:00 | CSD | OPS_RESILIENCE | EM East Don
SW/HE/23/318 | 2023-05-11 11:00:00 | AM_CUS_SERV_PLAN | Inverness Area Office | Waste Sampling
SW/HE/23/319 | 2023-05-10 15:00:00 | CSD | Inverness Area Office | Inverness Lab Dept
SW/HE/23/319-C1 | 2023-05-30 09:00:00 | CSD | Inverness Area Office | Inverness Lab Dept
SW/HE/23/320 | 2023-05-12 12:00:00 | CSD | Inverness Area Office | Inverness Lab Dept
SW/HE/23/321 | 2023-05-10 09:30:00 | CSD | Kingshill House | Waste East WWT & Net [NAME]
SW/HE/23/324 | 2023-06-02 11:00:00 | CSD | Kingshill House | Water East Trtmnt Tay East
SW/HE/23/326 | 2023-05-17 10:00:00 | CSD | Dornoch Area Office | CS Water Response Inverness
SW/HE/23/327 | 2023-05-09 15:30:00 | CSD | Inverness Area Office | North W R&LP
SW/HE/23/330 | 2023-05-18 10:30:00 | AM_CUS_SERV_PLAN | Inverness Area Office | Sampling North
SW/HE/23/332 | 2023-05-15 13:30:00 | CSD | Inverness Area Office | Waste Tankering North West
SW/HE/23/333 | 2023-04-22 10:30:00 | CSD | Inverness Area Office | Inverness Lab Dept
SW/HE/23/333-C1 | 2023-05-24 15:00:00 | CSD | Inverness Area Office | Inverness Lab Dept
SW/HE/23/338 | 2023-05-25 11:30:00 | CSD | Kingshill House | EM East Don
SW/HE/23/339 | 2023-05-15 15:30:00 | CSD | The Bridge | CS Sewer Response North Clyde
SW/HE/23/339-C1 | 2023-06-13 09:30:00 | CSD | The Bridge | CS Sewer Response North Clyde
SW/HE/23/342 | 2023-05-17 10:30:00 | CSD | The Bridge | Waste Tankering Central West
SW/HE/23/342-C1 | 2023-06-19 13:30:00 | CSD | The Bridge | Waste Tankering Central West
SW/HE/23/343 | 2023-05-16 15:30:00 | CSD | Gowans Terrace WTW & Depot | CS Field Response Tay
SW/HE/23/344 | 2023-05-18 14:30:00 | SCSP | The Bridge | Deerdykes AD
SW/HE/23/345 | 2023-06-05 11:30:00 | CSD | Bullion House | CS Field Response Tay
SW/HE/23/345-C1 | 2023-06-26 09:30:00 | CSD | Bullion House | CS Field Response Tay
SW/HE/23/346 | 2023-05-22 10:00:00 | CSD | The Bridge | CS Sewer Response North Clyde
SW/HE/23/349 | 2023-05-22 13:30:00 | CSD | The Bridge | CS Water Response Lanark
SW/HE/23/350 | 2023-05-22 13:30:00 | CSD | Orkney Area Office, Kirkwall | CS Sewer Response Orkney
SW/HE/23/354 | 2023-06-05 10:30:00 | CSD | Portree Area Office and Depot | Waste North Rural Dept
SW/HE/23/355 | 2023-06-23 09:00:00 | CSD | Portree Area Office and Depot | Water North Skye & LochabrWest
SW/HE/23/356 | 2023-06-19 09:30:00 | CSD | Portree Area Office and Depot | Water North Skye & LochabrWest
SW/HE/23/360 | 2023-06-12 15:30:00 | CSD | Dornoch Area Office | Water North Caithness Dept
SW/HE/23/362 | 2023-06-19 10:30:00 | CSD | Western Isles Area Offic & Dep | Water North Lewis & Harris MF
SW/HE/23/364 | 2023-06-26 10:30:00 | CSD | Western Isles Area Offic & Dep | Water North Lewis & Harris MF
SW/HE/23/365 | 2023-06-23 13:30:00 | CSD | Arran Water Depot | Water West Forth West Dept
SW/M1/20/418-C2 | 2022-11-18 11:00:00 | CSD | Remote Qnr Assessment 11 | Strategic Valve Maint Team
SW/M1/20/418-C3 | 2023-05-23 13:30:00 | CSD | Remote Qnr Assessment 11 | Strategic Valve Maint Team
SW/M1/20/418-C4 | 2023-06-16 09:30:00 | CSD | Remote Qnr Assessment 11 | Strategic Valve Maint Team
SW/M1/22/799-C2 | 2023-03-07 10:00:00 | CSD | CUSTOMER_SERVICE | CS Field Response [NAME]
SW/M4/22/8-C2 | 2023-05-23 10:30:00 | CSD | WASTE | Poseidon
SW/SR/22/142 | 2022-11-04 11:00:00 | SCSP | Remote QNR Assessment 59 | Deerdykes AD
SW/SR/22/143 | 2022-11-25 10:00:00 | CSD | Fairmilehead Office | CS Water Response Tweed 1
Applied filters: Case Type is Health Surveillance Escalation or Health Survelliance Client is Scottish Water Appointment Date is on or after 01/11/2022 00:00 and is before 19/01/2024 00:00