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