...
Code Block | ||||
---|---|---|---|---|
| ||||
case when p.managingdeaneryletb = 'Health Education England North West' THEN 'HENW' when p.managingdeaneryletb = 'Health Education England West Midlands' THEN 'HEWM' when p.managingdeaneryletb =IN ('Health Education England Yorkshire and the Humber', 'Yorkshire & Humber Deanery (North East)' THEN 'HEYH' when p.managingdeaneryletb = 'Health Education England North East' THEN 'HENE' when p.managingdeaneryletb = 'Health Education England East of England' THEN 'HEEOE' when p.managingdeaneryletb IN ('Health Education England South West', 'Peninsula Local Office - HESW', 'Severn Local Office - HESW') THEN 'HESW' when p.managingdeaneryletb IN= ('Health Education England East Midlands', 'Yorkshire & Humber Deanery (North East)') THEN 'HEEM' when p.managingdeaneryletb IN ('Health Education England Kent, Surrey and Sussex', 'London LETBs', 'Health Education England North West London', 'Health Education England North Central and East London', 'Health Education England South London') THEN 'HELASE' when p.managingdeaneryletb IN ('Health Education England Wessex', 'Health Education England Thames Valley') THEN 'HEWTV' else 'UNKNOWN' end as mapped_lo |
...