# MySQL-Front 5.1 (Build 2.8) /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE */; /*!40101 SET SQL_MODE='STRICT_ALL_TABLES' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES */; /*!40103 SET SQL_NOTES='ON' */; # Host: andlinux Database: lims_refactor # ------------------------------------------------------ # Server version 5.0.45-Debian_1ubuntu3.4 # # Source for table parent_organisations # CREATE TABLE `parent_organisations` ( `id` int(11) unsigned NOT NULL auto_increment, `parent_code` varchar(6) NOT NULL default '', `description` varchar(255) NOT NULL default '', PRIMARY KEY (`id`), UNIQUE KEY `description` (`description`), UNIQUE KEY `parent_code` (`parent_code`) ) ENGINE=InnoDB AUTO_INCREMENT=259 DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT; # # Dumping data for table parent_organisations # INSERT INTO `parent_organisations` VALUES (1,'RA2','ROYAL SURREY COUNTY HOSPITAL NHS TRUST'); INSERT INTO `parent_organisations` VALUES (2,'RA3','WESTON AREA HEALTH NHS TRUST'); INSERT INTO `parent_organisations` VALUES (3,'RA4','YEOVIL DISTRICT HOSPITAL NHS FOUNDATION TRUST'); INSERT INTO `parent_organisations` VALUES (4,'RA7','UNIVERSITY HOSPITALS BRISTOL NHS FOUNDATION TRUST'); INSERT INTO `parent_organisations` VALUES (5,'RA9','SOUTH DEVON HEALTHCARE NHS FOUNDATION TRUST'); INSERT INTO `parent_organisations` VALUES (6,'RAE','BRADFORD TEACHING HOSPITALS NHS FOUNDATION TRUST'); INSERT INTO `parent_organisations` VALUES (7,'RAJ','SOUTHEND UNIVERSITY HOSPITAL NHS FOUNDATION TRUST'); INSERT INTO `parent_organisations` VALUES (8,'RAL','ROYAL FREE HAMPSTEAD NHS TRUST'); INSERT INTO `parent_organisations` VALUES (9,'RAN','ROYAL NATIONAL ORTHOPAEDIC HOSPITAL NHS TRUST'); INSERT INTO `parent_organisations` VALUES (10,'RAP','NORTH MIDDLESEX UNIVERSITY HOSPITAL NHS TRUST'); INSERT INTO `parent_organisations` VALUES (11,'RAS','THE HILLINGDON HOSPITAL NHS TRUST'); INSERT INTO `parent_organisations` VALUES (12,'RAT','NORTH EAST LONDON NHS FOUNDATION TRUST'); INSERT INTO `parent_organisations` VALUES (13,'RAX','KINGSTON HOSPITAL NHS TRUST'); INSERT INTO `parent_organisations` VALUES (14,'RB7','STAFFORDSHIRE AMBULANCE SERVICE NHS TRUST'); INSERT INTO `parent_organisations` VALUES (15,'RBA','TAUNTON AND SOMERSET NHS FOUNDATION TRUST'); INSERT INTO `parent_organisations` VALUES (16,'RBB','ROYAL NATIONAL HOSPITAL FOR RHEUMATIC DISEASES NHS FOUNDATION TRUST'); INSERT INTO `parent_organisations` VALUES (17,'RBD','DORSET COUNTY HOSPITAL NHS FOUNDATION TRUST'); INSERT INTO `parent_organisations` VALUES (18,'RBF','NUFFIELD ORTHOPAEDIC CENTRE NHS TRUST'); INSERT INTO `parent_organisations` VALUES (19,'RBK','WALSALL HOSPITALS NHS TRUST'); INSERT INTO `parent_organisations` VALUES (20,'RBL','WIRRAL UNIVERSITY TEACHING HOSPITAL NHS FOUNDATION TRUST'); INSERT INTO `parent_organisations` VALUES (21,'RBN','ST HELENS AND KNOWSLEY HOSPITALS NHS TRUST'); INSERT INTO `parent_organisations` VALUES (22,'RBQ','LIVERPOOL HEART AND CHEST HOSPITAL NHS TRUST'); INSERT INTO `parent_organisations` VALUES (23,'RBS','ALDER HEY CHILDREN\'S NHS FOUNDATION TRUST'); INSERT INTO `parent_organisations` VALUES (24,'RBT','MID CHESHIRE HOSPITALS NHS FOUNDATION TRUST'); INSERT INTO `parent_organisations` VALUES (25,'RBV','THE CHRISTIE NHS FOUNDATION TRUST'); INSERT INTO `parent_organisations` VALUES (26,'RBZ','NORTHERN DEVON HEALTHCARE NHS TRUST'); INSERT INTO `parent_organisations` VALUES (27,'RC1','BEDFORD HOSPITAL NHS TRUST'); INSERT INTO `parent_organisations` VALUES (28,'RC3','EALING HOSPITAL NHS TRUST'); INSERT INTO `parent_organisations` VALUES (29,'RC9','LUTON AND DUNSTABLE HOSPITAL NHS FOUNDATION TRUST'); INSERT INTO `parent_organisations` VALUES (30,'RCB','YORK HOSPITALS NHS FOUNDATION TRUST'); INSERT INTO `parent_organisations` VALUES (31,'RCC','SCARBOROUGH AND NORTH EAST YORKSHIRE HEALTH CARE NHS TRUST'); INSERT INTO `parent_organisations` VALUES (32,'RCD','HARROGATE AND DISTRICT NHS FOUNDATION TRUST'); INSERT INTO `parent_organisations` VALUES (33,'RCF','AIREDALE NHS TRUST'); INSERT INTO `parent_organisations` VALUES (34,'RCU','SHEFFIELD CHILDREN\'S NHS FOUNDATION TRUST'); INSERT INTO `parent_organisations` VALUES (35,'RCX','THE QUEEN ELIZABETH HOSPITAL KING\'S LYNN NHS TRUST'); INSERT INTO `parent_organisations` VALUES (36,'RD1','ROYAL UNITED HOSPITAL BATH NHS TRUST'); INSERT INTO `parent_organisations` VALUES (37,'RD3','POOLE HOSPITAL NHS FOUNDATION TRUST'); INSERT INTO `parent_organisations` VALUES (38,'RD7','HEATHERWOOD AND WEXHAM PARK HOSPITALS NHS FOUNDATION TRUST'); INSERT INTO `parent_organisations` VALUES (39,'RD8','MILTON KEYNES HOSPITAL NHS FOUNDATION TRUST'); INSERT INTO `parent_organisations` VALUES (40,'RDD','BASILDON AND THURROCK UNIVERSITY HOSPITALS NHS FOUNDATION TRUST'); INSERT INTO `parent_organisations` VALUES (41,'RDE','COLCHESTER HOSPITAL UNIVERSITY NHS FOUNDATION TRUST'); INSERT INTO `parent_organisations` VALUES (42,'RDR','SOUTH DOWNS HEALTH NHS TRUST'); INSERT INTO `parent_organisations` VALUES (43,'RDU','FRIMLEY PARK HOSPITAL NHS FOUNDATION TRUST'); INSERT INTO `parent_organisations` VALUES (44,'RDY','DORSET HEALTHCARE NHS FOUNDATION TRUST'); INSERT INTO `parent_organisations` VALUES (45,'RDZ','THE ROYAL BOURNEMOUTH AND CHRISTCHURCH HOSPITALS NHS FOUNDATION TRUST'); INSERT INTO `parent_organisations` VALUES (46,'RE9','SOUTH TYNESIDE NHS FOUNDATION TRUST'); INSERT INTO `parent_organisations` VALUES (47,'REF','ROYAL CORNWALL HOSPITALS NHS TRUST'); INSERT INTO `parent_organisations` VALUES (48,'REM','AINTREE UNIVERSITY HOSPITALS NHS FOUNDATION TRUST'); INSERT INTO `parent_organisations` VALUES (49,'REN','CLATTERBRIDGE CENTRE FOR ONCOLOGY NHS FOUNDATION TRUST'); INSERT INTO `parent_organisations` VALUES (50,'REP','LIVERPOOL WOMEN\'S NHS FOUNDATION TRUST'); INSERT INTO `parent_organisations` VALUES (51,'RET','WALTON CENTRE FOR NEUROLOGY AND NEUROSURGERY NHS TRUST'); INSERT INTO `parent_organisations` VALUES (52,'RF4','BARKING, HAVERING AND REDBRIDGE HOSPITALS NHS TRUST'); INSERT INTO `parent_organisations` VALUES (53,'RFF','BARNSLEY HOSPITAL NHS FOUNDATION TRUST'); INSERT INTO `parent_organisations` VALUES (54,'RFR','THE ROTHERHAM NHS FOUNDATION TRUST'); INSERT INTO `parent_organisations` VALUES (55,'RFS','CHESTERFIELD ROYAL HOSPITAL NHS FOUNDATION TRUST'); INSERT INTO `parent_organisations` VALUES (56,'RFW','WEST MIDDLESEX UNIVERSITY HOSPITAL NHS TRUST'); INSERT INTO `parent_organisations` VALUES (57,'RG2','QUEEN ELIZABETH HOSPITAL NHS TRUST'); INSERT INTO `parent_organisations` VALUES (58,'RG3','BROMLEY HOSPITALS NHS TRUST'); INSERT INTO `parent_organisations` VALUES (59,'RGC','WHIPPS CROSS UNIVERSITY HOSPITAL NHS TRUST'); INSERT INTO `parent_organisations` VALUES (60,'RGD','LEEDS PARTNERSHIPS NHS FOUNDATION TRUST'); INSERT INTO `parent_organisations` VALUES (61,'RGM','PAPWORTH HOSPITAL NHS FOUNDATION TRUST'); INSERT INTO `parent_organisations` VALUES (62,'RGN','PETERBOROUGH AND STAMFORD HOSPITALS NHS FOUNDATION TRUST'); INSERT INTO `parent_organisations` VALUES (63,'RGP','JAMES PAGET UNIVERSITY HOSPITALS NHS FOUNDATION TRUST'); INSERT INTO `parent_organisations` VALUES (64,'RGQ','IPSWICH HOSPITAL NHS TRUST'); INSERT INTO `parent_organisations` VALUES (65,'RGR','WEST SUFFOLK HOSPITALS NHS TRUST'); INSERT INTO `parent_organisations` VALUES (66,'RGT','CAMBRIDGE UNIVERSITY HOSPITALS NHS FOUNDATION TRUST'); INSERT INTO `parent_organisations` VALUES (67,'RGZ','QUEEN MARY\'S SIDCUP NHS TRUST'); INSERT INTO `parent_organisations` VALUES (68,'RH5','SOMERSET PARTNERSHIP NHS FOUNDATION TRUST'); INSERT INTO `parent_organisations` VALUES (69,'RH8','ROYAL DEVON AND EXETER NHS FOUNDATION TRUST'); INSERT INTO `parent_organisations` VALUES (70,'RHA','NOTTINGHAMSHIRE HEALTHCARE NHS TRUST'); INSERT INTO `parent_organisations` VALUES (71,'RHM','SOUTHAMPTON UNIVERSITY HOSPITALS NHS TRUST'); INSERT INTO `parent_organisations` VALUES (72,'RHQ','SHEFFIELD TEACHING HOSPITALS NHS FOUNDATION TRUST'); INSERT INTO `parent_organisations` VALUES (73,'RHU','PORTSMOUTH HOSPITALS NHS TRUST'); INSERT INTO `parent_organisations` VALUES (74,'RHW','ROYAL BERKSHIRE NHS FOUNDATION TRUST'); INSERT INTO `parent_organisations` VALUES (75,'RHX','OXFORDSHIRE LEARNING DISABILITY NHS TRUST'); INSERT INTO `parent_organisations` VALUES (76,'RJ1','GUY\'S AND ST THOMAS\' NHS FOUNDATION TRUST'); INSERT INTO `parent_organisations` VALUES (77,'RJ2','THE LEWISHAM HOSPITAL NHS TRUST'); INSERT INTO `parent_organisations` VALUES (78,'RJ5','ST MARY\'S NHS TRUST'); INSERT INTO `parent_organisations` VALUES (79,'RJ6','MAYDAY HEALTHCARE NHS TRUST'); INSERT INTO `parent_organisations` VALUES (80,'RJ7','ST GEORGE\'S HEALTHCARE NHS TRUST'); INSERT INTO `parent_organisations` VALUES (81,'RJ8','CORNWALL PARTNERSHIP NHS TRUST'); INSERT INTO `parent_organisations` VALUES (82,'RJC','SOUTH WARWICKSHIRE GENERAL HOSPITALS NHS TRUST'); INSERT INTO `parent_organisations` VALUES (83,'RJD','MID STAFFORDSHIRE NHS FOUNDATION TRUST'); INSERT INTO `parent_organisations` VALUES (84,'RJE','UNIVERSITY HOSPITAL OF NORTH STAFFORDSHIRE NHS TRUST'); INSERT INTO `parent_organisations` VALUES (85,'RJF','BURTON HOSPITALS NHS FOUNDATION TRUST'); INSERT INTO `parent_organisations` VALUES (86,'RJH','GOOD HOPE HOSPITAL NHS TRUST'); INSERT INTO `parent_organisations` VALUES (87,'RJL','NORTHERN LINCOLNSHIRE AND GOOLE HOSPITALS NHS FOUNDATION TRUST'); INSERT INTO `parent_organisations` VALUES (88,'RJN','EAST CHESHIRE NHS TRUST'); INSERT INTO `parent_organisations` VALUES (89,'RJR','COUNTESS OF CHESTER HOSPITAL NHS FOUNDATION TRUST'); INSERT INTO `parent_organisations` VALUES (90,'RJX','CALDERSTONES NHS TRUST'); INSERT INTO `parent_organisations` VALUES (91,'RJZ','KING\'S COLLEGE HOSPITAL NHS FOUNDATION TRUST'); INSERT INTO `parent_organisations` VALUES (92,'RK5','SHERWOOD FOREST HOSPITALS NHS FOUNDATION TRUST'); INSERT INTO `parent_organisations` VALUES (93,'RK9','PLYMOUTH HOSPITALS NHS TRUST'); INSERT INTO `parent_organisations` VALUES (94,'RKB','UNIVERSITY HOSPITALS COVENTRY AND WARWICKSHIRE NHS TRUST'); INSERT INTO `parent_organisations` VALUES (95,'RKE','THE WHITTINGTON HOSPITAL NHS TRUST'); INSERT INTO `parent_organisations` VALUES (96,'RKL','WEST LONDON MENTAL HEALTH NHS TRUST'); INSERT INTO `parent_organisations` VALUES (97,'RKU','CEREDIGION AND MID WALES NHS TRUST'); INSERT INTO `parent_organisations` VALUES (98,'RL1','ROBERT JONES AND AGNES HUNT ORTHOPAEDIC AND DISTRICT HOSPITAL NHS TRUST'); INSERT INTO `parent_organisations` VALUES (99,'RL4','THE ROYAL WOLVERHAMPTON HOSPITALS NHS TRUST'); INSERT INTO `parent_organisations` VALUES (100,'RLN','CITY HOSPITALS SUNDERLAND NHS FOUNDATION TRUST'); INSERT INTO `parent_organisations` VALUES (101,'RLQ','HEREFORD HOSPITALS NHS TRUST'); INSERT INTO `parent_organisations` VALUES (102,'RLT','GEORGE ELIOT HOSPITAL NHS TRUST'); INSERT INTO `parent_organisations` VALUES (103,'RLU','BIRMINGHAM WOMEN\'S NHS FOUNDATION TRUST'); INSERT INTO `parent_organisations` VALUES (104,'RLY','NORTH STAFFORDSHIRE COMBINED HEALTHCARE NHS TRUST'); INSERT INTO `parent_organisations` VALUES (105,'RM1','NORFOLK AND NORWICH UNIVERSITY HOSPITALS NHS FOUNDATION TRUST'); INSERT INTO `parent_organisations` VALUES (106,'RM2','UNIVERSITY HOSPITAL OF SOUTH MANCHESTER NHS FOUNDATION TRUST'); INSERT INTO `parent_organisations` VALUES (107,'RM3','SALFORD ROYAL NHS FOUNDATION TRUST'); INSERT INTO `parent_organisations` VALUES (108,'RM4','TRAFFORD HEALTHCARE NHS TRUST'); INSERT INTO `parent_organisations` VALUES (109,'RMC','ROYAL BOLTON HOSPITAL NHS FOUNDATION TRUST'); INSERT INTO `parent_organisations` VALUES (110,'RMP','TAMESIDE HOSPITAL NHS FOUNDATION TRUST'); INSERT INTO `parent_organisations` VALUES (111,'RMY','NORFOLK AND WAVENEY MENTAL HEALTH NHS FOUNDATION TRUST'); INSERT INTO `parent_organisations` VALUES (112,'RN1','WINCHESTER AND EASTLEIGH HEALTHCARE NHS TRUST'); INSERT INTO `parent_organisations` VALUES (113,'RN3','SWINDON AND MARLBOROUGH NHS TRUST'); INSERT INTO `parent_organisations` VALUES (114,'RN5','BASINGSTOKE AND NORTH HAMPSHIRE NHS FOUNDATION TRUST'); INSERT INTO `parent_organisations` VALUES (115,'RN7','DARTFORD AND GRAVESHAM NHS TRUST'); INSERT INTO `parent_organisations` VALUES (116,'RNA','THE DUDLEY GROUP OF HOSPITALS NHS FOUNDATION TRUST'); INSERT INTO `parent_organisations` VALUES (117,'RNH','NEWHAM UNIVERSITY HOSPITAL NHS TRUST'); INSERT INTO `parent_organisations` VALUES (118,'RNJ','BARTS AND THE LONDON NHS TRUST'); INSERT INTO `parent_organisations` VALUES (119,'RNK','TAVISTOCK AND PORTMAN NHS FOUNDATION TRUST'); INSERT INTO `parent_organisations` VALUES (120,'RNL','NORTH CUMBRIA UNIVERSITY HOSPITALS NHS TRUST'); INSERT INTO `parent_organisations` VALUES (121,'RNN','CUMBRIA PARTNERSHIP NHS FOUNDATION TRUST'); INSERT INTO `parent_organisations` VALUES (122,'RNQ','KETTERING GENERAL HOSPITAL NHS FOUNDATION TRUST'); INSERT INTO `parent_organisations` VALUES (123,'RNS','NORTHAMPTON GENERAL HOSPITAL NHS TRUST'); INSERT INTO `parent_organisations` VALUES (124,'RNU','OXFORDSHIRE AND BUCKINGHAMSHIRE MENTAL HEALTH NHS FOUNDATION TRUST'); INSERT INTO `parent_organisations` VALUES (125,'RNZ','SALISBURY NHS FOUNDATION TRUST'); INSERT INTO `parent_organisations` VALUES (126,'RP1','NORTHAMPTONSHIRE HEALTHCARE NHS TRUST'); INSERT INTO `parent_organisations` VALUES (127,'RP4','GREAT ORMOND STREET HOSPITAL FOR CHILDREN NHS TRUST'); INSERT INTO `parent_organisations` VALUES (128,'RP5','DONCASTER AND BASSETLAW HOSPITALS NHS FOUNDATION TRUST'); INSERT INTO `parent_organisations` VALUES (129,'RP6','MOORFIELDS EYE HOSPITAL NHS FOUNDATION TRUST'); INSERT INTO `parent_organisations` VALUES (130,'RP7','LINCOLNSHIRE PARTNERSHIP NHS FOUNDATION TRUST'); INSERT INTO `parent_organisations` VALUES (131,'RPA','MEDWAY NHS FOUNDATION TRUST'); INSERT INTO `parent_organisations` VALUES (132,'RPC','QUEEN VICTORIA HOSPITAL NHS FOUNDATION TRUST'); INSERT INTO `parent_organisations` VALUES (133,'RPG','OXLEAS NHS FOUNDATION TRUST'); INSERT INTO `parent_organisations` VALUES (134,'RPL','WORTHING AND SOUTHLANDS HOSPITALS NHS TRUST'); INSERT INTO `parent_organisations` VALUES (135,'RPR','ROYAL WEST SUSSEX NHS TRUST'); INSERT INTO `parent_organisations` VALUES (136,'RPY','THE ROYAL MARSDEN NHS FOUNDATION TRUST'); INSERT INTO `parent_organisations` VALUES (137,'RQ3','BIRMINGHAM CHILDREN\'S HOSPITAL NHS FOUNDATION TRUST'); INSERT INTO `parent_organisations` VALUES (138,'RQ6','ROYAL LIVERPOOL AND BROADGREEN UNIVERSITY HOSPITALS NHS TRUST'); INSERT INTO `parent_organisations` VALUES (139,'RQ8','MID ESSEX HOSPITAL SERVICES NHS TRUST'); INSERT INTO `parent_organisations` VALUES (140,'RQF','VELINDRE NHS TRUST'); INSERT INTO `parent_organisations` VALUES (141,'RQM','CHELSEA AND WESTMINSTER HOSPITAL NHS FOUNDATION TRUST'); INSERT INTO `parent_organisations` VALUES (142,'RQN','HAMMERSMITH HOSPITALS NHS TRUST'); INSERT INTO `parent_organisations` VALUES (143,'RQQ','HINCHINGBROOKE HEALTH CARE NHS TRUST'); INSERT INTO `parent_organisations` VALUES (144,'RQW','THE PRINCESS ALEXANDRA HOSPITAL NHS TRUST'); INSERT INTO `parent_organisations` VALUES (145,'RQX','HOMERTON UNIVERSITY HOSPITAL NHS FOUNDATION TRUST'); INSERT INTO `parent_organisations` VALUES (146,'RQY','SOUTH WEST LONDON AND ST GEORGE\'S MENTAL HEALTH NHS TRUST'); INSERT INTO `parent_organisations` VALUES (147,'RR1','HEART OF ENGLAND NHS FOUNDATION TRUST'); INSERT INTO `parent_organisations` VALUES (148,'RR6','PEMBROKESHIRE AND DERWEN NHS TRUST'); INSERT INTO `parent_organisations` VALUES (149,'RR7','GATESHEAD HEALTH NHS FOUNDATION TRUST'); INSERT INTO `parent_organisations` VALUES (150,'RR8','LEEDS TEACHING HOSPITALS NHS TRUST'); INSERT INTO `parent_organisations` VALUES (151,'RRD','NORTH ESSEX PARTNERSHIP NHS FOUNDATION TRUST'); INSERT INTO `parent_organisations` VALUES (152,'RRE','SOUTH STAFFORDSHIRE AND SHROPSHIRE HEALTHCARE NHS FOUNDATION TRUST'); INSERT INTO `parent_organisations` VALUES (153,'RRF','WRIGHTINGTON, WIGAN AND LEIGH NHS TRUST'); INSERT INTO `parent_organisations` VALUES (154,'RRJ','THE ROYAL ORTHOPAEDIC HOSPITAL NHS FOUNDATION TRUST'); INSERT INTO `parent_organisations` VALUES (155,'RRK','UNIVERSITY HOSPITAL BIRMINGHAM NHS FOUNDATION TRUST'); INSERT INTO `parent_organisations` VALUES (156,'RRP','BARNET, ENFIELD AND HARINGEY MENTAL HEALTH NHS TRUST'); INSERT INTO `parent_organisations` VALUES (157,'RRS','NORTH GLAMORGAN NHS TRUST'); INSERT INTO `parent_organisations` VALUES (158,'RRU','LONDON AMBULANCE SERVICE NHS TRUST'); INSERT INTO `parent_organisations` VALUES (159,'RRV','UNIVERSITY COLLEGE LONDON HOSPITALS NHS FOUNDATION TRUST'); INSERT INTO `parent_organisations` VALUES (160,'RT1','CAMBRIDGESHIRE AND PETERBOROUGH NHS FOUNDATION TRUST'); INSERT INTO `parent_organisations` VALUES (161,'RT2','PENNINE CARE NHS FOUNDATION TRUST'); INSERT INTO `parent_organisations` VALUES (162,'RT3','ROYAL BROMPTON AND HAREFIELD NHS TRUST'); INSERT INTO `parent_organisations` VALUES (163,'RT4','WELSH AMBULANCE SERVICES NHS TRUST'); INSERT INTO `parent_organisations` VALUES (164,'RT5','LEICESTERSHIRE PARTNERSHIP NHS TRUST'); INSERT INTO `parent_organisations` VALUES (165,'RT6','SUFFOLK MENTAL HEALTH PARTNERSHIP NHS TRUST'); INSERT INTO `parent_organisations` VALUES (166,'RT7','NORTH WEST WALES NHS TRUST'); INSERT INTO `parent_organisations` VALUES (167,'RT8','CONWY AND DENBEIGHSHIRE NHS TRUST'); INSERT INTO `parent_organisations` VALUES (168,'RT9','NORTH EAST WALES NHS TRUST'); INSERT INTO `parent_organisations` VALUES (169,'RTD','THE NEWCASTLE UPON TYNE HOSPITALS NHS FOUNDATION TRUST'); INSERT INTO `parent_organisations` VALUES (170,'RTE','GLOUCESTERSHIRE HOSPITALS NHS FOUNDATION TRUST'); INSERT INTO `parent_organisations` VALUES (171,'RTF','NORTHUMBRIA HEALTHCARE NHS FOUNDATION TRUST'); INSERT INTO `parent_organisations` VALUES (172,'RTG','DERBY HOSPITALS NHS FOUNDATION TRUST'); INSERT INTO `parent_organisations` VALUES (173,'RTH','OXFORD RADCLIFFE HOSPITALS NHS TRUST'); INSERT INTO `parent_organisations` VALUES (174,'RTK','ASHFORD AND ST PETER\'S HOSPITALS NHS TRUST'); INSERT INTO `parent_organisations` VALUES (175,'RTP','SURREY AND SUSSEX HEALTHCARE NHS TRUST'); INSERT INTO `parent_organisations` VALUES (176,'RTQ','2GETHER NHS FOUNDATION TRUST'); INSERT INTO `parent_organisations` VALUES (177,'RTR','SOUTH TEES HOSPITALS NHS TRUST'); INSERT INTO `parent_organisations` VALUES (178,'RTV','5 BOROUGHS PARTNERSHIP NHS TRUST'); INSERT INTO `parent_organisations` VALUES (179,'RTX','UNIVERSITY HOSPITALS OF MORECAMBE BAY NHS TRUST'); INSERT INTO `parent_organisations` VALUES (180,'RV3','CENTRAL AND NORTH WEST LONDON NHS FOUNDATION TRUST'); INSERT INTO `parent_organisations` VALUES (181,'RV5','SOUTH LONDON AND MAUDSLEY NHS FOUNDATION TRUST'); INSERT INTO `parent_organisations` VALUES (182,'RV7','BEDFORDSHIRE AND LUTON MENTAL HEALTH AND SOCIAL CARE NHS TRUST'); INSERT INTO `parent_organisations` VALUES (183,'RV8','NORTH WEST LONDON HOSPITALS NHS TRUST'); INSERT INTO `parent_organisations` VALUES (184,'RV9','HUMBER MENTAL HEALTH TEACHING NHS TRUST'); INSERT INTO `parent_organisations` VALUES (185,'RVA','CARMARTHENSHIRE NHS TRUST'); INSERT INTO `parent_organisations` VALUES (186,'RVC','SWANSEA NHS TRUST'); INSERT INTO `parent_organisations` VALUES (187,'RVD','BRO MORGANNWG NHS TRUST'); INSERT INTO `parent_organisations` VALUES (188,'RVE','PONTYPRIDD AND RHONDDA NHS TRUST'); INSERT INTO `parent_organisations` VALUES (189,'RVF','GWENT HEALTHCARE NHS TRUST'); INSERT INTO `parent_organisations` VALUES (190,'RVJ','NORTH BRISTOL NHS TRUST'); INSERT INTO `parent_organisations` VALUES (191,'RVL','BARNET AND CHASE FARM HOSPITALS NHS TRUST'); INSERT INTO `parent_organisations` VALUES (192,'RVN','AVON AND WILTSHIRE MENTAL HEALTH PARTNERSHIP NHS TRUST'); INSERT INTO `parent_organisations` VALUES (193,'RVR','EPSOM AND ST HELIER UNIVERSITY HOSPITALS NHS TRUST'); INSERT INTO `parent_organisations` VALUES (194,'RVV','EAST KENT HOSPITALS UNIVERSITY NHS TRUST'); INSERT INTO `parent_organisations` VALUES (195,'RVW','NORTH TEES AND HARTLEPOOL NHS FOUNDATION TRUST'); INSERT INTO `parent_organisations` VALUES (196,'RVY','SOUTHPORT AND ORMSKIRK HOSPITAL NHS TRUST'); INSERT INTO `parent_organisations` VALUES (197,'RW1','HAMPSHIRE PARTNERSHIP NHS TRUST'); INSERT INTO `parent_organisations` VALUES (198,'RW3','CENTRAL MANCHESTER AND MANCHESTER CHILDREN\'S UNIVERSITY HOSPITALS NHS TRUST'); INSERT INTO `parent_organisations` VALUES (199,'RW4','MERSEY CARE NHS TRUST'); INSERT INTO `parent_organisations` VALUES (200,'RW5','LANCASHIRE CARE NHS FOUNDATION TRUST'); INSERT INTO `parent_organisations` VALUES (201,'RW6','PENNINE ACUTE HOSPITALS NHS TRUST'); INSERT INTO `parent_organisations` VALUES (202,'RWA','HULL AND EAST YORKSHIRE HOSPITALS NHS TRUST'); INSERT INTO `parent_organisations` VALUES (203,'RWD','UNITED LINCOLNSHIRE HOSPITALS NHS TRUST'); INSERT INTO `parent_organisations` VALUES (204,'RWE','UNIVERSITY HOSPITALS OF LEICESTER NHS TRUST'); INSERT INTO `parent_organisations` VALUES (205,'RWF','MAIDSTONE AND TUNBRIDGE WELLS NHS TRUST'); INSERT INTO `parent_organisations` VALUES (206,'RWG','WEST HERTFORDSHIRE HOSPITALS NHS TRUST'); INSERT INTO `parent_organisations` VALUES (207,'RWH','EAST AND NORTH HERTFORDSHIRE NHS TRUST'); INSERT INTO `parent_organisations` VALUES (208,'RWJ','STOCKPORT NHS FOUNDATION TRUST'); INSERT INTO `parent_organisations` VALUES (209,'RWK','EAST LONDON NHS FOUNDATION TRUST'); INSERT INTO `parent_organisations` VALUES (210,'RWM','CARDIFF AND VALE NHS TRUST'); INSERT INTO `parent_organisations` VALUES (211,'RWN','SOUTH ESSEX PARTNERSHIP NHS FOUNDATION TRUST'); INSERT INTO `parent_organisations` VALUES (212,'RWP','WORCESTERSHIRE ACUTE HOSPITALS NHS TRUST'); INSERT INTO `parent_organisations` VALUES (213,'RWQ','WORCESTERSHIRE MENTAL HEALTH PARTNERSHIP NHS TRUST'); INSERT INTO `parent_organisations` VALUES (214,'RWR','HERTFORDSHIRE PARTNERSHIP NHS FOUNDATION TRUST'); INSERT INTO `parent_organisations` VALUES (215,'RWV','DEVON PARTNERSHIP NHS TRUST'); INSERT INTO `parent_organisations` VALUES (216,'RWW','NORTH CHESHIRE HOSPITALS NHS TRUST'); INSERT INTO `parent_organisations` VALUES (217,'RWX','BERKSHIRE HEALTHCARE NHS FOUNDATION TRUST'); INSERT INTO `parent_organisations` VALUES (218,'RWY','CALDERDALE AND HUDDERSFIELD NHS FOUNDATION TRUST'); INSERT INTO `parent_organisations` VALUES (219,'RX1','NOTTINGHAM UNIVERSITY HOSPITALS NHS TRUST'); INSERT INTO `parent_organisations` VALUES (220,'RX2','SUSSEX PARTNERSHIP NHS FOUNDATION TRUST'); INSERT INTO `parent_organisations` VALUES (221,'RX3','TEES, ESK AND WEAR VALLEYS NHS FOUNDATION TRUST'); INSERT INTO `parent_organisations` VALUES (222,'RX4','NORTHUMBERLAND, TYNE AND WEAR NHS TRUST'); INSERT INTO `parent_organisations` VALUES (223,'RX5','GREAT WESTERN AMBULANCE SERVICE NHS TRUST'); INSERT INTO `parent_organisations` VALUES (224,'RX6','NORTH EAST AMBULANCE SERVICE NHS TRUST'); INSERT INTO `parent_organisations` VALUES (225,'RX7','NORTH WEST AMBULANCE SERVICE NHS TRUST'); INSERT INTO `parent_organisations` VALUES (226,'RX8','YORKSHIRE AMBULANCE SERVICE NHS TRUST'); INSERT INTO `parent_organisations` VALUES (227,'RX9','EAST MIDLANDS AMBULANCE SERVICE NHS TRUST'); INSERT INTO `parent_organisations` VALUES (228,'RXA','CHESHIRE AND WIRRAL PARTNERSHIP NHS FOUNDATION TRUST'); INSERT INTO `parent_organisations` VALUES (229,'RXC','EAST SUSSEX HOSPITALS NHS TRUST'); INSERT INTO `parent_organisations` VALUES (230,'RXE','ROTHERHAM, DONCASTER AND SOUTH HUMBER MENTAL HEALTH NHS FOUNDATION TRUST'); INSERT INTO `parent_organisations` VALUES (231,'RXF','MID YORKSHIRE HOSPITALS NHS TRUST'); INSERT INTO `parent_organisations` VALUES (232,'RXG','SOUTH WEST YORKSHIRE MENTAL HEALTH NHS TRUST'); INSERT INTO `parent_organisations` VALUES (233,'RXH','BRIGHTON AND SUSSEX UNIVERSITY HOSPITALS NHS TRUST'); INSERT INTO `parent_organisations` VALUES (234,'RXK','SANDWELL AND WEST BIRMINGHAM HOSPITALS NHS TRUST'); INSERT INTO `parent_organisations` VALUES (235,'RXL','BLACKPOOL, FYLDE AND WYRE HOSPITALS NHS FOUNDATION TRUST'); INSERT INTO `parent_organisations` VALUES (236,'RXM','DERBYSHIRE MENTAL HEALTH SERVICES NHS TRUST'); INSERT INTO `parent_organisations` VALUES (237,'RXN','LANCASHIRE TEACHING HOSPITALS NHS FOUNDATION TRUST'); INSERT INTO `parent_organisations` VALUES (238,'RXP','COUNTY DURHAM AND DARLINGTON NHS FOUNDATION TRUST'); INSERT INTO `parent_organisations` VALUES (239,'RXQ','BUCKINGHAMSHIRE HOSPITALS NHS TRUST'); INSERT INTO `parent_organisations` VALUES (240,'RXR','EAST LANCASHIRE HOSPITALS NHS TRUST'); INSERT INTO `parent_organisations` VALUES (241,'RXT','BIRMINGHAM AND SOLIHULL MENTAL HEALTH NHS FOUNDATION TRUST'); INSERT INTO `parent_organisations` VALUES (242,'RXV','GREATER MANCHESTER WEST MENTAL HEALTH NHS FOUNDATION TRUST'); INSERT INTO `parent_organisations` VALUES (243,'RXW','SHREWSBURY AND TELFORD HOSPITAL NHS TRUST'); INSERT INTO `parent_organisations` VALUES (244,'RXX','SURREY AND BORDERS PARTNERSHIP NHS FOUNDATION TRUST'); INSERT INTO `parent_organisations` VALUES (245,'RXY','KENT AND MEDWAY NHS AND SOCIAL CARE PARTNERSHIP TRUST'); INSERT INTO `parent_organisations` VALUES (246,'RYA','WEST MIDLANDS AMBULANCE SERVICE NHS TRUST'); INSERT INTO `parent_organisations` VALUES (247,'RYC','EAST OF ENGLAND AMBULANCE SERVICE NHS TRUST'); INSERT INTO `parent_organisations` VALUES (248,'RYD','SOUTH EAST COAST AMBULANCE SERVICE NHS TRUST'); INSERT INTO `parent_organisations` VALUES (249,'RYE','SOUTH CENTRAL AMBULANCE SERVICE NHS TRUST'); INSERT INTO `parent_organisations` VALUES (250,'RYF','SOUTH WESTERN AMBULANCE SERVICE NHS TRUST'); INSERT INTO `parent_organisations` VALUES (251,'RYG','COVENTRY AND WARWICKSHIRE PARTNERSHIP NHS TRUST'); INSERT INTO `parent_organisations` VALUES (252,'RYH','NHS DIRECT NHS TRUST'); INSERT INTO `parent_organisations` VALUES (253,'RYJ','IMPERIAL COLLEGE HEALTHCARE NHS TRUST'); INSERT INTO `parent_organisations` VALUES (254,'RYK','DUDLEY AND WALSALL MENTAL HEALTH PARTNERSHIP NHS TRUST'); INSERT INTO `parent_organisations` VALUES (255,'RYL','CWM TAF NHS TRUST'); INSERT INTO `parent_organisations` VALUES (256,'RYM','ABERTAWE BRO MORGANNWG UNIVERSITY NHS TRUST'); INSERT INTO `parent_organisations` VALUES (257,'RYN','HYWEL DDA NHS TRUST'); INSERT INTO `parent_organisations` VALUES (258,'RYP','NORTH WALES NHS TRUST'); /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;