--DROP TABLE ServiceDeliveryLocationRoleType CASCADE; CREATE TABLE ServiceDeliveryLocationRoleType ( ServiceDeliveryLocationRoleType_id int NOT NULL PRIMARY KEY, code varchar(255) NOT NULL, codeSystem varchar(255) NOT NULL, displayName varchar(255) NOT NULL ); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (1, '_DedicatedServiceDeliveryLocationRoleType', '2.16.840.1.113883.5.111', 'DedicatedServiceDeliveryLocationRoleType'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (2, '_DedicatedClinicalLocationRoleType', '2.16.840.1.113883.5.111', 'DedicatedClinicalLocationRoleType'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (3, 'DX', '2.16.840.1.113883.5.111', 'Diagnostics or therapeutics unit'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (4, 'CVDX', '2.16.840.1.113883.5.111', 'Cardiovascular diagnostics or therapeutics unit'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (5, 'CATH', '2.16.840.1.113883.5.111', 'Cardiac catheterization lab'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (6, 'ECHO', '2.16.840.1.113883.5.111', 'Echocardiography lab'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (7, 'GIDX', '2.16.840.1.113883.5.111', 'Gastroenterology diagnostics or therapeutics lab'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (8, 'ENDOS', '2.16.840.1.113883.5.111', 'Endoscopy lab Ambulatory Health Care Facilities; Clinic/Center; Endoscopy'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (9, 'RADDX', '2.16.840.1.113883.5.111', 'Radiology diagnostics or therapeutics unit Ambulatory Health Care Facilities; Clinic/Center; Radiology'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (10, 'RADO', '2.16.840.1.113883.5.111', 'Radiation oncology unit Ambulatory Health Care Facilities; Clinic/Center; Oncology, Radiation'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (11, 'RNEU', '2.16.840.1.113883.5.111', 'Neuroradiology unit'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (12, 'HOSP', '2.16.840.1.113883.5.111', 'Hospital'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (13, 'CHR', '2.16.840.1.113883.5.111', 'Chronic Care Facility Hospitals; Chronic Disease Hospital'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (14, 'GACH', '2.16.840.1.113883.5.111', 'Hospitals; General Acute Care Hospital General acute care hospital'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (15, 'MHSP', '2.16.840.1.113883.5.111', 'Military Hospital MilitaryHospital'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (16, 'PSYCHF', '2.16.840.1.113883.5.111', 'Psychatric Care Facility'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (17, 'RH', '2.16.840.1.113883.5.111', 'Rehabilitation hospital Hospitals; Rehabilitation Hospital'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (18, 'RHAT', '2.16.840.1.113883.5.111', 'addiction treatment center'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (19, 'RHII', '2.16.840.1.113883.5.111', 'intellectual impairment center'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (20, 'RHMAD', '2.16.840.1.113883.5.111', 'parents with adjustment difficulties center'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (21, 'RHPI', '2.16.840.1.113883.5.111', 'physical impairment center'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (22, 'RHPIH', '2.16.840.1.113883.5.111', 'physical impairment - hearing center'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (23, 'RHPIMS', '2.16.840.1.113883.5.111', 'physical impairment - motor skills center'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (24, 'RHPIVS', '2.16.840.1.113883.5.111', 'physical impairment - visual skills center'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (25, 'RHYAD', '2.16.840.1.113883.5.111', 'youths with adjustment difficulties center'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (26, 'HU', '2.16.840.1.113883.5.111', 'Hospital unit'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (27, 'BMTU', '2.16.840.1.113883.5.111', 'Bone marrow transplant unit'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (28, 'CCU', '2.16.840.1.113883.5.111', 'Coronary care unit'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (29, 'CHEST', '2.16.840.1.113883.5.111', 'Chest unit'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (30, 'EPIL', '2.16.840.1.113883.5.111', 'Epilepsy unit'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (31, 'ER', '2.16.840.1.113883.5.111', 'Emergency room'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (32, 'ETU', '2.16.840.1.113883.5.111', 'Emergency trauma unit'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (33, 'HD', '2.16.840.1.113883.5.111', 'Hemodialysis unit'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (34, 'HLAB', '2.16.840.1.113883.5.111', 'hospital laboratory'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (35, 'INLAB', '2.16.840.1.113883.5.111', 'inpatient laboratory'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (36, 'OUTLAB', '2.16.840.1.113883.5.111', 'outpatient laboratory'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (37, 'HRAD', '2.16.840.1.113883.5.111', 'radiology unit'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (38, 'HUSCS', '2.16.840.1.113883.5.111', 'specimen collection site'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (39, 'ICU', '2.16.840.1.113883.5.111', 'Intensive care unit'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (40, 'PEDICU', '2.16.840.1.113883.5.111', 'Pediatric intensive care unit'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (41, 'PEDNICU', '2.16.840.1.113883.5.111', 'Pediatric neonatal intensive care unit'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (42, 'INPHARM', '2.16.840.1.113883.5.111', 'inpatient pharmacy'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (43, 'MBL', '2.16.840.1.113883.5.111', 'medical laboratory'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (44, 'NCCS', '2.16.840.1.113883.5.111', 'Neurology critical care and stroke unit'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (45, 'NS', '2.16.840.1.113883.5.111', 'Neurosurgery unit'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (46, 'OUTPHARM', '2.16.840.1.113883.5.111', 'outpatient pharmacy'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (47, 'PEDU', '2.16.840.1.113883.5.111', 'Pediatric unit'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (48, 'PEDICU', '2.16.840.1.113883.5.111', 'Pediatric intensive care unit'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (49, 'PEDNICU', '2.16.840.1.113883.5.111', 'Pediatric neonatal intensive care unit'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (50, 'PHU', '2.16.840.1.113883.5.111', 'Psychiatric hospital unit Hospital Units; Psychiatric Unit'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (51, 'RHU', '2.16.840.1.113883.5.111', 'Rehabilitation hospital unit Hospital Units; Rehabilitation Unit'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (52, 'SLEEP', '2.16.840.1.113883.5.111', 'Sleep disorders unit'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (53, 'NCCF', '2.16.840.1.113883.5.111', 'Nursing or custodial care facility'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (54, 'SNF', '2.16.840.1.113883.5.111', 'Skilled nursing facility Nursing & Custodial Care Facilities; Skilled Nursing Facility'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (55, 'OF', '2.16.840.1.113883.5.111', 'Outpatient facility'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (56, 'ALL', '2.16.840.1.113883.5.111', 'Allergy clinic'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (57, 'AMPUT', '2.16.840.1.113883.5.111', 'Amputee clinic'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (58, 'BMTC', '2.16.840.1.113883.5.111', 'Bone marrow transplant clinic'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (59, 'BREAST', '2.16.840.1.113883.5.111', 'Breast clinic'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (60, 'CANC', '2.16.840.1.113883.5.111', 'Child and adolescent neurology clinic'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (61, 'CAPC', '2.16.840.1.113883.5.111', 'Child and adolescent psychiatry clinic'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (62, 'CARD', '2.16.840.1.113883.5.111', 'Ambulatory Health Care Facilities; Clinic/Center; Rehabilitation: Cardiac Facilities Cardiology clinic'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (63, 'PEDCARD', '2.16.840.1.113883.5.111', 'Pediatric cardiology clinic'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (64, 'COAG', '2.16.840.1.113883.5.111', 'Coagulation clinic'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (65, 'CRS', '2.16.840.1.113883.5.111', 'Colon and rectal surgery clinic'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (66, 'DERM', '2.16.840.1.113883.5.111', 'Dermatology clinic'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (67, 'ENDO', '2.16.840.1.113883.5.111', 'Endocrinology clinic'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (68, 'PEDE', '2.16.840.1.113883.5.111', 'Pediatric endocrinology clinic'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (69, 'ENT', '2.16.840.1.113883.5.111', 'Otorhinolaryngology clinic'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (70, 'FMC', '2.16.840.1.113883.5.111', 'Family medicine clinic'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (71, 'GI', '2.16.840.1.113883.5.111', 'Gastroenterology clinic'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (72, 'PEDGI', '2.16.840.1.113883.5.111', 'Pediatric gastroenterology clinic'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (73, 'GIM', '2.16.840.1.113883.5.111', 'General internal medicine clinic'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (74, 'GYN', '2.16.840.1.113883.5.111', 'Gynecology clinic'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (75, 'HEM', '2.16.840.1.113883.5.111', 'Hematology clinic'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (76, 'PEDHEM', '2.16.840.1.113883.5.111', 'Pediatric hematology clinic'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (77, 'HTN', '2.16.840.1.113883.5.111', 'Hypertension clinic'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (78, 'IEC', '2.16.840.1.113883.5.111', 'Impairment evaluation center'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (79, 'INFD', '2.16.840.1.113883.5.111', 'Infectious disease clinic'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (80, 'PEDID', '2.16.840.1.113883.5.111', 'Pediatric infectious disease clinic'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (81, 'INV', '2.16.840.1.113883.5.111', 'Infertility clinic'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (82, 'LYMPH', '2.16.840.1.113883.5.111', 'Lympedema clinic'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (83, 'MGEN', '2.16.840.1.113883.5.111', 'Medical genetics clinic'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (84, 'NEPH', '2.16.840.1.113883.5.111', 'Nephrology clinic'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (85, 'PEDNEPH', '2.16.840.1.113883.5.111', 'Pediatric nephrology clinic'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (86, 'NEUR', '2.16.840.1.113883.5.111', 'Neurology clinic'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (87, 'OB', '2.16.840.1.113883.5.111', 'Obstetrics clinic'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (88, 'OMS', '2.16.840.1.113883.5.111', 'Oral and maxillofacial surgery clinic Ambulatory Health Care Facilities; Clinic/Center; Surgery, Oral/Maxillofacial'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (89, 'ONCL', '2.16.840.1.113883.5.111', 'Medical oncology clinic'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (90, 'PEDHO', '2.16.840.1.113883.5.111', 'Pediatric oncology clinic'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (91, 'OPH', '2.16.840.1.113883.5.111', 'Opthalmology clinic'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (92, 'OPTC', '2.16.840.1.113883.5.111', 'optometry clinic'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (93, 'ORTHO', '2.16.840.1.113883.5.111', 'Orthopedics clinic'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (94, 'HAND', '2.16.840.1.113883.5.111', 'Hand clinic'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (95, 'PAINCL', '2.16.840.1.113883.5.111', 'Pain clinic Ambulatory Health Care Facilities; Clinic/Center; Pain'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (96, 'PC', '2.16.840.1.113883.5.111', 'Primary care clinic Ambulatory Health Care Facilities; Clinic/Center; Primary Care'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (97, 'PEDC', '2.16.840.1.113883.5.111', 'Pediatrics clinic'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (98, 'PEDCARD', '2.16.840.1.113883.5.111', 'Pediatric cardiology clinic'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (99, 'PEDE', '2.16.840.1.113883.5.111', 'Pediatric endocrinology clinic'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (100, 'PEDGI', '2.16.840.1.113883.5.111', 'Pediatric gastroenterology clinic'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (101, 'PEDHEM', '2.16.840.1.113883.5.111', 'Pediatric hematology clinic'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (102, 'PEDID', '2.16.840.1.113883.5.111', 'Pediatric infectious disease clinic'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (103, 'PEDNEPH', '2.16.840.1.113883.5.111', 'Pediatric nephrology clinic'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (104, 'PEDHO', '2.16.840.1.113883.5.111', 'Pediatric oncology clinic'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (105, 'PEDRHEUM', '2.16.840.1.113883.5.111', 'Pediatric rheumatology clinic'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (106, 'POD', '2.16.840.1.113883.5.111', 'Podiatry clinic Ambulatory Health Care Facilities; Clinic/Center; Podiatric'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (107, 'PREV', '2.16.840.1.113883.5.111', 'Preventive medicine clinic'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (108, 'PROCTO', '2.16.840.1.113883.5.111', 'Proctology clinic'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (109, 'PROFF', '2.16.840.1.113883.5.111', 'Providers Office'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (110, 'PROS', '2.16.840.1.113883.5.111', 'Prosthodontics clinic'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (111, 'PSI', '2.16.840.1.113883.5.111', 'Psychology clinic'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (112, 'PSY', '2.16.840.1.113883.5.111', 'Psychiatry clinic'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (113, 'RHEUM', '2.16.840.1.113883.5.111', 'Rheumatology clinic'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (114, 'PEDRHEUM', '2.16.840.1.113883.5.111', 'Pediatric rheumatology clinic'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (115, 'SPMED', '2.16.840.1.113883.5.111', 'Sports medicine clinic'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (116, 'SU', '2.16.840.1.113883.5.111', 'Surgery clinic'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (117, 'PLS', '2.16.840.1.113883.5.111', 'Plastic surgery clinic'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (118, 'URO', '2.16.840.1.113883.5.111', 'Urology clinic'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (119, 'TR', '2.16.840.1.113883.5.111', 'Transplant clinic'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (120, 'TRAVEL', '2.16.840.1.113883.5.111', 'Travel and geographic medicine clinic'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (121, 'WND', '2.16.840.1.113883.5.111', 'Wound clinic'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (122, 'RTF', '2.16.840.1.113883.5.111', 'Residential treatment facility'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (123, 'PRC', '2.16.840.1.113883.5.111', 'Pain rehabilitation center'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (124, 'SURF', '2.16.840.1.113883.5.111', 'Substance use rehabilitation facility Residential Treatment Facilities; Substance Use Rehabilitation Facility'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (125, '_DedicatedNonClinicalLocationRoleType', '2.16.840.1.113883.5.111', 'DedicatedNonClinicalLocationRoleType'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (126, 'DADDR', '2.16.840.1.113883.5.111', 'Delivery Address'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (127, 'MOBL', '2.16.840.1.113883.5.111', 'Mobile Unit'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (128, 'AMB', '2.16.840.1.113883.5.111', 'Ambulance'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (129, 'PHARM', '2.16.840.1.113883.5.111', 'Pharmacy'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (130, 'INPHARM', '2.16.840.1.113883.5.111', 'inpatient pharmacy'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (131, 'OUTPHARM', '2.16.840.1.113883.5.111', 'outpatient pharmacy'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (132, '_IncidentalServiceDeliveryLocationRoleType', '2.16.840.1.113883.5.111', 'IncidentalServiceDeliveryLocationRoleType'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (133, 'ACC', '2.16.840.1.113883.5.111', 'accident site'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (134, 'COMM', '2.16.840.1.113883.5.111', 'Community Location'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (135, 'CSC', '2.16.840.1.113883.5.111', 'community service center'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (136, 'PTRES', '2.16.840.1.113883.5.111', 'Patients Residence'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (137, 'SCHOOL', '2.16.840.1.113883.5.111', 'school'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (138, 'UPC', '2.16.840.1.113883.5.111', 'underage protection center'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (139, 'WORK', '2.16.840.1.113883.5.111', 'work site'); --DROP TABLE ServiceDeliveryLocationRoleType CASCADE; CREATE TABLE ServiceDeliveryLocationRoleType ( ServiceDeliveryLocationRoleType_id int NOT NULL PRIMARY KEY, code varchar(255) NOT NULL, codeSystem varchar(255) NOT NULL, displayName varchar(255) NOT NULL ); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (1, '_DedicatedServiceDeliveryLocationRoleType', '2.16.840.1.113883.5.111', 'DedicatedServiceDeliveryLocationRoleType'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (2, '_DedicatedClinicalLocationRoleType', '2.16.840.1.113883.5.111', 'DedicatedClinicalLocationRoleType'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (3, 'DX', '2.16.840.1.113883.5.111', 'Diagnostics or therapeutics unit'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (4, 'CVDX', '2.16.840.1.113883.5.111', 'Cardiovascular diagnostics or therapeutics unit'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (5, 'CATH', '2.16.840.1.113883.5.111', 'Cardiac catheterization lab'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (6, 'ECHO', '2.16.840.1.113883.5.111', 'Echocardiography lab'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (7, 'GIDX', '2.16.840.1.113883.5.111', 'Gastroenterology diagnostics or therapeutics lab'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (8, 'ENDOS', '2.16.840.1.113883.5.111', 'Endoscopy lab Ambulatory Health Care Facilities; Clinic/Center; Endoscopy'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (9, 'RADDX', '2.16.840.1.113883.5.111', 'Radiology diagnostics or therapeutics unit Ambulatory Health Care Facilities; Clinic/Center; Radiology'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (10, 'RADO', '2.16.840.1.113883.5.111', 'Radiation oncology unit Ambulatory Health Care Facilities; Clinic/Center; Oncology, Radiation'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (11, 'RNEU', '2.16.840.1.113883.5.111', 'Neuroradiology unit'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (12, 'HOSP', '2.16.840.1.113883.5.111', 'Hospital'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (13, 'CHR', '2.16.840.1.113883.5.111', 'Chronic Care Facility Hospitals; Chronic Disease Hospital'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (14, 'GACH', '2.16.840.1.113883.5.111', 'Hospitals; General Acute Care Hospital General acute care hospital'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (15, 'MHSP', '2.16.840.1.113883.5.111', 'Military Hospital MilitaryHospital'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (16, 'PSYCHF', '2.16.840.1.113883.5.111', 'Psychatric Care Facility'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (17, 'RH', '2.16.840.1.113883.5.111', 'Rehabilitation hospital Hospitals; Rehabilitation Hospital'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (18, 'RHAT', '2.16.840.1.113883.5.111', 'addiction treatment center'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (19, 'RHII', '2.16.840.1.113883.5.111', 'intellectual impairment center'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (20, 'RHMAD', '2.16.840.1.113883.5.111', 'parents with adjustment difficulties center'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (21, 'RHPI', '2.16.840.1.113883.5.111', 'physical impairment center'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (22, 'RHPIH', '2.16.840.1.113883.5.111', 'physical impairment - hearing center'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (23, 'RHPIMS', '2.16.840.1.113883.5.111', 'physical impairment - motor skills center'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (24, 'RHPIVS', '2.16.840.1.113883.5.111', 'physical impairment - visual skills center'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (25, 'RHYAD', '2.16.840.1.113883.5.111', 'youths with adjustment difficulties center'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (26, 'HU', '2.16.840.1.113883.5.111', 'Hospital unit'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (27, 'BMTU', '2.16.840.1.113883.5.111', 'Bone marrow transplant unit'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (28, 'CCU', '2.16.840.1.113883.5.111', 'Coronary care unit'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (29, 'CHEST', '2.16.840.1.113883.5.111', 'Chest unit'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (30, 'EPIL', '2.16.840.1.113883.5.111', 'Epilepsy unit'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (31, 'ER', '2.16.840.1.113883.5.111', 'Emergency room'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (32, 'ETU', '2.16.840.1.113883.5.111', 'Emergency trauma unit'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (33, 'HD', '2.16.840.1.113883.5.111', 'Hemodialysis unit'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (34, 'HLAB', '2.16.840.1.113883.5.111', 'hospital laboratory'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (35, 'INLAB', '2.16.840.1.113883.5.111', 'inpatient laboratory'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (36, 'OUTLAB', '2.16.840.1.113883.5.111', 'outpatient laboratory'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (37, 'HRAD', '2.16.840.1.113883.5.111', 'radiology unit'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (38, 'HUSCS', '2.16.840.1.113883.5.111', 'specimen collection site'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (39, 'ICU', '2.16.840.1.113883.5.111', 'Intensive care unit'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (40, 'PEDICU', '2.16.840.1.113883.5.111', 'Pediatric intensive care unit'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (41, 'PEDNICU', '2.16.840.1.113883.5.111', 'Pediatric neonatal intensive care unit'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (42, 'INPHARM', '2.16.840.1.113883.5.111', 'inpatient pharmacy'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (43, 'MBL', '2.16.840.1.113883.5.111', 'medical laboratory'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (44, 'NCCS', '2.16.840.1.113883.5.111', 'Neurology critical care and stroke unit'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (45, 'NS', '2.16.840.1.113883.5.111', 'Neurosurgery unit'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (46, 'OUTPHARM', '2.16.840.1.113883.5.111', 'outpatient pharmacy'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (47, 'PEDU', '2.16.840.1.113883.5.111', 'Pediatric unit'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (48, 'PEDICU', '2.16.840.1.113883.5.111', 'Pediatric intensive care unit'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (49, 'PEDNICU', '2.16.840.1.113883.5.111', 'Pediatric neonatal intensive care unit'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (50, 'PHU', '2.16.840.1.113883.5.111', 'Psychiatric hospital unit Hospital Units; Psychiatric Unit'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (51, 'RHU', '2.16.840.1.113883.5.111', 'Rehabilitation hospital unit Hospital Units; Rehabilitation Unit'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (52, 'SLEEP', '2.16.840.1.113883.5.111', 'Sleep disorders unit'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (53, 'NCCF', '2.16.840.1.113883.5.111', 'Nursing or custodial care facility'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (54, 'SNF', '2.16.840.1.113883.5.111', 'Skilled nursing facility Nursing & Custodial Care Facilities; Skilled Nursing Facility'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (55, 'OF', '2.16.840.1.113883.5.111', 'Outpatient facility'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (56, 'ALL', '2.16.840.1.113883.5.111', 'Allergy clinic'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (57, 'AMPUT', '2.16.840.1.113883.5.111', 'Amputee clinic'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (58, 'BMTC', '2.16.840.1.113883.5.111', 'Bone marrow transplant clinic'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (59, 'BREAST', '2.16.840.1.113883.5.111', 'Breast clinic'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (60, 'CANC', '2.16.840.1.113883.5.111', 'Child and adolescent neurology clinic'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (61, 'CAPC', '2.16.840.1.113883.5.111', 'Child and adolescent psychiatry clinic'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (62, 'CARD', '2.16.840.1.113883.5.111', 'Ambulatory Health Care Facilities; Clinic/Center; Rehabilitation: Cardiac Facilities Cardiology clinic'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (63, 'PEDCARD', '2.16.840.1.113883.5.111', 'Pediatric cardiology clinic'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (64, 'COAG', '2.16.840.1.113883.5.111', 'Coagulation clinic'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (65, 'CRS', '2.16.840.1.113883.5.111', 'Colon and rectal surgery clinic'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (66, 'DERM', '2.16.840.1.113883.5.111', 'Dermatology clinic'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (67, 'ENDO', '2.16.840.1.113883.5.111', 'Endocrinology clinic'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (68, 'PEDE', '2.16.840.1.113883.5.111', 'Pediatric endocrinology clinic'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (69, 'ENT', '2.16.840.1.113883.5.111', 'Otorhinolaryngology clinic'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (70, 'FMC', '2.16.840.1.113883.5.111', 'Family medicine clinic'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (71, 'GI', '2.16.840.1.113883.5.111', 'Gastroenterology clinic'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (72, 'PEDGI', '2.16.840.1.113883.5.111', 'Pediatric gastroenterology clinic'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (73, 'GIM', '2.16.840.1.113883.5.111', 'General internal medicine clinic'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (74, 'GYN', '2.16.840.1.113883.5.111', 'Gynecology clinic'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (75, 'HEM', '2.16.840.1.113883.5.111', 'Hematology clinic'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (76, 'PEDHEM', '2.16.840.1.113883.5.111', 'Pediatric hematology clinic'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (77, 'HTN', '2.16.840.1.113883.5.111', 'Hypertension clinic'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (78, 'IEC', '2.16.840.1.113883.5.111', 'Impairment evaluation center'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (79, 'INFD', '2.16.840.1.113883.5.111', 'Infectious disease clinic'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (80, 'PEDID', '2.16.840.1.113883.5.111', 'Pediatric infectious disease clinic'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (81, 'INV', '2.16.840.1.113883.5.111', 'Infertility clinic'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (82, 'LYMPH', '2.16.840.1.113883.5.111', 'Lympedema clinic'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (83, 'MGEN', '2.16.840.1.113883.5.111', 'Medical genetics clinic'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (84, 'NEPH', '2.16.840.1.113883.5.111', 'Nephrology clinic'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (85, 'PEDNEPH', '2.16.840.1.113883.5.111', 'Pediatric nephrology clinic'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (86, 'NEUR', '2.16.840.1.113883.5.111', 'Neurology clinic'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (87, 'OB', '2.16.840.1.113883.5.111', 'Obstetrics clinic'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (88, 'OMS', '2.16.840.1.113883.5.111', 'Oral and maxillofacial surgery clinic Ambulatory Health Care Facilities; Clinic/Center; Surgery, Oral/Maxillofacial'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (89, 'ONCL', '2.16.840.1.113883.5.111', 'Medical oncology clinic'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (90, 'PEDHO', '2.16.840.1.113883.5.111', 'Pediatric oncology clinic'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (91, 'OPH', '2.16.840.1.113883.5.111', 'Opthalmology clinic'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (92, 'OPTC', '2.16.840.1.113883.5.111', 'optometry clinic'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (93, 'ORTHO', '2.16.840.1.113883.5.111', 'Orthopedics clinic'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (94, 'HAND', '2.16.840.1.113883.5.111', 'Hand clinic'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (95, 'PAINCL', '2.16.840.1.113883.5.111', 'Pain clinic Ambulatory Health Care Facilities; Clinic/Center; Pain'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (96, 'PC', '2.16.840.1.113883.5.111', 'Primary care clinic Ambulatory Health Care Facilities; Clinic/Center; Primary Care'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (97, 'PEDC', '2.16.840.1.113883.5.111', 'Pediatrics clinic'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (98, 'PEDCARD', '2.16.840.1.113883.5.111', 'Pediatric cardiology clinic'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (99, 'PEDE', '2.16.840.1.113883.5.111', 'Pediatric endocrinology clinic'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (100, 'PEDGI', '2.16.840.1.113883.5.111', 'Pediatric gastroenterology clinic'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (101, 'PEDHEM', '2.16.840.1.113883.5.111', 'Pediatric hematology clinic'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (102, 'PEDID', '2.16.840.1.113883.5.111', 'Pediatric infectious disease clinic'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (103, 'PEDNEPH', '2.16.840.1.113883.5.111', 'Pediatric nephrology clinic'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (104, 'PEDHO', '2.16.840.1.113883.5.111', 'Pediatric oncology clinic'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (105, 'PEDRHEUM', '2.16.840.1.113883.5.111', 'Pediatric rheumatology clinic'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (106, 'POD', '2.16.840.1.113883.5.111', 'Podiatry clinic Ambulatory Health Care Facilities; Clinic/Center; Podiatric'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (107, 'PREV', '2.16.840.1.113883.5.111', 'Preventive medicine clinic'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (108, 'PROCTO', '2.16.840.1.113883.5.111', 'Proctology clinic'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (109, 'PROFF', '2.16.840.1.113883.5.111', 'Providers Office'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (110, 'PROS', '2.16.840.1.113883.5.111', 'Prosthodontics clinic'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (111, 'PSI', '2.16.840.1.113883.5.111', 'Psychology clinic'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (112, 'PSY', '2.16.840.1.113883.5.111', 'Psychiatry clinic'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (113, 'RHEUM', '2.16.840.1.113883.5.111', 'Rheumatology clinic'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (114, 'PEDRHEUM', '2.16.840.1.113883.5.111', 'Pediatric rheumatology clinic'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (115, 'SPMED', '2.16.840.1.113883.5.111', 'Sports medicine clinic'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (116, 'SU', '2.16.840.1.113883.5.111', 'Surgery clinic'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (117, 'PLS', '2.16.840.1.113883.5.111', 'Plastic surgery clinic'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (118, 'URO', '2.16.840.1.113883.5.111', 'Urology clinic'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (119, 'TR', '2.16.840.1.113883.5.111', 'Transplant clinic'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (120, 'TRAVEL', '2.16.840.1.113883.5.111', 'Travel and geographic medicine clinic'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (121, 'WND', '2.16.840.1.113883.5.111', 'Wound clinic'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (122, 'RTF', '2.16.840.1.113883.5.111', 'Residential treatment facility'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (123, 'PRC', '2.16.840.1.113883.5.111', 'Pain rehabilitation center'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (124, 'SURF', '2.16.840.1.113883.5.111', 'Substance use rehabilitation facility Residential Treatment Facilities; Substance Use Rehabilitation Facility'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (125, '_DedicatedNonClinicalLocationRoleType', '2.16.840.1.113883.5.111', 'DedicatedNonClinicalLocationRoleType'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (126, 'DADDR', '2.16.840.1.113883.5.111', 'Delivery Address'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (127, 'MOBL', '2.16.840.1.113883.5.111', 'Mobile Unit'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (128, 'AMB', '2.16.840.1.113883.5.111', 'Ambulance'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (129, 'PHARM', '2.16.840.1.113883.5.111', 'Pharmacy'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (130, 'INPHARM', '2.16.840.1.113883.5.111', 'inpatient pharmacy'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (131, 'OUTPHARM', '2.16.840.1.113883.5.111', 'outpatient pharmacy'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (132, '_IncidentalServiceDeliveryLocationRoleType', '2.16.840.1.113883.5.111', 'IncidentalServiceDeliveryLocationRoleType'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (133, 'ACC', '2.16.840.1.113883.5.111', 'accident site'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (134, 'COMM', '2.16.840.1.113883.5.111', 'Community Location'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (135, 'CSC', '2.16.840.1.113883.5.111', 'community service center'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (136, 'PTRES', '2.16.840.1.113883.5.111', 'Patients Residence'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (137, 'SCHOOL', '2.16.840.1.113883.5.111', 'school'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (138, 'UPC', '2.16.840.1.113883.5.111', 'underage protection center'); INSERT INTO ServiceDeliveryLocationRoleType (ServiceDeliveryLocationRoleType_id, code, codeSystem, displayName) VALUES (139, 'WORK', '2.16.840.1.113883.5.111', 'work site');