...
case when pr.ProgrammeName like '%child%Adolescent%' then 'Child and Adolescent Psychiatry' when pr.ProgrammeName like '%Core%Psychiatry%' then 'Core Psychiatry Training' when pr.ProgrammeName like '%forensic%Psychiatry%' then 'Forensic Psychiatry' when pr.ProgrammeName like '%General%Psychiatry%' then 'General Psychiatry' when pr.ProgrammeName like '%Medical%Psychotherapy%' then 'Medical Psychotherapy' when pr.ProgrammeName like '%Old%Age%Psychiatry%' then 'Old Age Psychiatry' when pr.ProgrammeName like '%Psychiatry%Learning%' then 'Psychiatry of Learning Disability' when pr.ProgrammeName like '%general%Practice%' or pr.ProgrammeName like '%GP%' then 'General Practice' when pr.ProgrammeName like '%Neurosurgery%' then 'Neurosurgery' when pr.ProgrammeName like '%plastic%Surgery%' then 'Plastic Surgery' when pr.ProgrammeName like '%Acute Care Common Stem%Anaesthetics%' or pr.ProgrammeName like '%ACCS%Anaesthetics%' then 'ACCS - Anaesthetics' when pr.ProgrammeName like '%Acute Care Common Stem%Intensive%' or pr.ProgrammeName like '%ACCS%Intensive%' then 'ACCS - Intensive Care Medicine' when pr.ProgrammeName like '%Acute Care Common Stem%Emergency%' or pr.ProgrammeName like '%ACCS%Emergency%' then 'ACCS - Emergency Medicine' when pr.ProgrammeName like '%Acute Care Common Stem%Acute%' or pr.ProgrammeName like '%ACCS%Acute%' then 'ACCS - Acute Medicine' when pr.ProgrammeName like '%Acute Care Common Stem%' then 'ACCS' when pr.ProgrammeName like '%Dental%Foundation%' then 'Dental Foundation Training' when pr.ProgrammeName like '%Core%Anaesthetics%' then 'Core Anaesthetics Training' when pr.ProgrammeName like '%Core%Surgical%' then 'Core Surgical Training' when pr.ProgrammeName like '%Core%Medical%' then 'Core Medical Training' when pr.ProgrammeName like '%Anaesthetics%' then 'Anaesthetics' when pr.ProgrammeName like '%Oral%Maxillo%' then 'Oral and Maxillo-Facial Surgery' when pr.ProgrammeName like '%Oral%Surgery%' then 'Oral Surgery' when pr.ProgrammeName like '%Foundation%' then 'Foundation' when pr.ProgrammeName like '%Clinical%Radiology%' then 'Clinical Radiology' when pr.ProgrammeName like '%Palliative%Medicine%' then 'Palliative Medicine' when pr.ProgrammeName like '%Emergency%Medicine%' then 'Emergency Medicine' when pr.ProgrammeName like '%Ophthalmology%' then 'Ophthalmology' when pr.ProgrammeName like '%Otolaryngology%' then 'Otolaryngology' when pr.ProgrammeName like '%Paediatric%Cardiology%' then 'Paediatric Cardiology' when pr.ProgrammeName like '%Cardiology%' then 'Cardiology' when pr.ProgrammeName like '%Paediatric%Surgery%' then 'Paediatric Surgery' when pr.ProgrammeName like '%Haematology%' then 'Haematology' when pr.ProgrammeName like '%Rheumatology%' then 'Rheumatology' when pr.ProgrammeName like '%Combined%Infection%' then 'Combined Infection Training' when pr.ProgrammeName like '%Clinical%Genetics%' then 'Clinical Genetics' when pr.ProgrammeName like '%Obstetrics%Gynaecology%' then 'Obstetrics and Gynaecology' when pr.ProgrammeName like '%Endocrinology%diabetes%' then 'Endocrinology and Diabetes Mellitus' when pr.ProgrammeName like '%Dental%Public%Health%' then 'Dental Public Health' when pr.ProgrammeName like '%Public%Health%%Dental%' then 'Dental Public Health' when pr.ProgrammeName like '%Public%Health%' then 'Public Health Medicine' when pr.ProgrammeName like '%Intensive%Care%Medicine%' then 'Intensive Care Medicine' when pr.ProgrammeName like '%Genito%Urinary%' then 'Genito-Urinary Medicine' when pr.ProgrammeName like '%Medical%Oncology%' then 'Medical Oncology' when pr.ProgrammeName like '%Neurology%' then 'Neurology' when pr.ProgrammeName like '%Urology%' then 'Urology' when pr.ProgrammeName like '%Forensic%Histopathology%' then 'Forensic Histopathology' when pr.ProgrammeName like '%Paediatrics%' then 'Paediatrics' when pr.ProgrammeName like '%Orthodontics%' then 'Orthodontics' when pr.ProgrammeName like '%Histopathology%' then 'Histopathology' when pr.ProgrammeName like '%Cardio%thoracic%' then 'Cardiothoracic Surgery' when pr.ProgrammeName like '%Medical%Microbiology%Virology%' then 'Medical Microbiology and Virology' when pr.ProgrammeName like '%Medical%Microbiology%' then 'Medical Microbiology' when pr.ProgrammeName like '%Immunology%' then 'Immunology' when pr.ProgrammeName like '%Respiratory%Medicine%' then 'Respiratory Medicine' when pr.ProgrammeName like '%Infectious%Diseases%' then 'Infectious Diseases' when pr.ProgrammeName like '%Medical%Virology%' then 'Medical Virology' when pr.ProgrammeName like '%Vascular%Surgery%' then 'Vascular Surgery' when pr.ProgrammeName like '%Dental%Public%Health' then 'Dental Public Health' when pr.ProgrammeName like '%Rehabilitation%Medicine%' then 'Rehabilitation Medicine' when pr.ProgrammeName like '%Renal%Medicine%' then 'Renal Medicine' when pr.ProgrammeName like '%Broad%Based%Training%' Then 'Broad Based Training' when pr.ProgrammeName like '%Chemical%Pathology%' then 'Chemical Pathology' when pr.ProgrammeName like '%Special%Care%Dentistry%' then 'Special Care Dentistry' when pr.ProgrammeName like '%Gastro%enterology%' then 'Gastroenterology' when pr.ProgrammeName like '%Nuclear%Medicine%' then 'Nuclear Medicine' when pr.ProgrammeName like '%Oral%Maxillo%Pathology%' then 'Oral and Maxillo-Facial Pathology' when pr.ProgrammeName like '%Audio%Vestibular%Medicine%' then 'Audio Vestibular Medicine' when pr.ProgrammeName like '%Trauma%Orthopaedic%' then 'Trauma and Orthopaedic Surgery' when pr.ProgrammeName like '%Stroke%Medicine%' then 'Stroke Medicine' when pr.ProgrammeName like '%Internal%Medicine%Stage%' then 'Internal Medicine Training Stage 1' when pr.ProgrammeName like '%Restorative%Dentistry%' then 'Restorative Dentistry' when pr.ProgrammeName like '%Acute%Internal%Medicine%' then 'Acute Internal Medicine' when pr.ProgrammeName like '%Community%Sexual%Reproductive%' then 'Community Sexual and Reproductive Health' when pr.ProgrammeName like '%Paediatric%Dentistry%' or pr.programmename like 'Paeds%Dentistry%' then 'Paediatric Dentistry' when pr.ProgrammeName like '%Dermatology%' then 'Dermatology' when pr.ProgrammeName like '%Dental%Core%' then 'Dental Core Training' when pr.ProgrammeName like '%Allergy%' then 'Allergy' when pr.ProgrammeName like '%Geriatric%' then 'Geriatric Medicine' when pr.ProgrammeName like '%General%Internal%' then 'General (Internal) Medicine' when pr.ProgrammeName like '%Clinical%Pharmacology%' then 'Clinical Pharmacology and Therapeutics' when pr.ProgrammeName like '%Diagnostic%europathology%' then 'Diagnostic Neuropathology' when pr.ProgrammeName like '%Sport%Exercise%' then 'Sport and Exercise Medicine' when pr.ProgrammeName like '%Clinical%Oncology%' then 'Clinical Oncology' when pr.ProgrammeName like '%Paediatric%Perinatal%Pathology%' then 'Paediatric and Perinatal Pathology' when pr.ProgrammeName like '%General%Surgery%' then 'General Surgery' when pr.ProgrammeName like '%Dental%Maxillo%facial%Radiology%' then 'Dental and Maxillofacial Radiology' when pr.ProgrammeName like '%Oral%Medicine%' then 'Oral Medicine' when pr.ProgrammeName like '%Endodontics%' then 'Endodontics' when pr.ProgrammeName like '%Periodontics%' then 'Periodontics' when pr.ProgrammeName like '%Occupational%Medicine%' then 'Occupational Medicine' when pr.ProgrammeName like '%Clinical%Neurophysiology%' then 'Clinical Neurophysiology' when pr.ProgrammeName like '%Dental%Integrated%' then 'Dental - Integrated DFT and DCT Training' when pr.ProgrammeName like '%Dental%Longitudinal%' then 'Dental Longitudinal Training' when pr.ProgrammeName like ‘%Longitudinal%Dental%' then 'Dental Longitudinal Training' when pr.ProgrammeName like '%Prosthodontics%' then 'Prosthodontics' when pr.ProgrammeName like '%Aviation%Space%Medicine%' then 'Aviation and Space Medicine' when pr.ProgrammeName like '%Dental%Specialties%' then 'Dental Medical Specialties' when pr.ProgrammeName like '%WAST%' then 'WAST' when pr.ProgrammeName like '%Post-CCT%%Academics%' then 'Post-CCT Academics'End
Note that TCS Programme names are standardised, but in the scripts below they are matched against unstandardised form entries (programme specialty, CCT1, CCT2, dual specialty).
B.2. A 'parent’ programme:
...