demo-data.sql

-- ----------------------------
-- DISCLAIMER
-- This file is a mix of database dump data and handcrafted data.
-- Its sole purpose is for demonstration so do not rely on it, do not use it in
-- production.
--
-- Concepts here are a subset of concepts from CIEL dictionary, they might not
-- be up to date, they might include some that CIEL doesnt, they dont include
-- all. Again this is for demo only!
--
-- LICENSE
-- This Source Code Form is subject to the terms of the Mozilla Public License, 
-- v. 2.0. If a copy of the MPL was not distributed with this file, You can 
-- obtain one at http://mozilla.org/MPL/2.0/. OpenMRS is also distributed under 
-- the terms of the Healthcare Disclaimer located at http://openmrs.org/license.
-- 
-- Copyright (C) OpenMRS Inc. OpenMRS is a registered trademark and the OpenMRS 
-- graphic logo is a trademark of OpenMRS Inc.
-- ----------------------------

-- Dumps were generated on MySQL Server version	5.6.31

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

-- ----------------------------
--  Radiology Module Roles
-- ----------------------------
-- Setup Role Data Clerk
INSERT INTO role VALUES ('Data clerk','The user who enters patients and their demographic data','bd6ec731-1f97-4e5f-a10a-7ec1a9ca8e8a');
INSERT INTO `role_privilege` VALUES ('Data clerk','Patient Dashboard - View Demographics Section');
INSERT INTO `role_privilege` VALUES ('Data clerk','Patient Dashboard - View Encounters Section');
INSERT INTO `role_privilege` VALUES ('Data clerk','Patient Dashboard - View Overview Section');
INSERT INTO `role_privilege` VALUES ('Data clerk','Patient Dashboard - View Patient Summary');
INSERT INTO `role_privilege` VALUES ('Data clerk','Patient Dashboard - View Radiology Section');
INSERT INTO `role_privilege` VALUES ('Data clerk','Patient Dashboard - View Regimen Section');
INSERT INTO `role_privilege` VALUES ('Data clerk','Add Encounters');
INSERT INTO `role_privilege` VALUES ('Data clerk','Add Patients');
INSERT INTO `role_privilege` VALUES ('Data clerk','Add Relationships');
INSERT INTO `role_privilege` VALUES ('Data clerk','Add Visits');
INSERT INTO `role_privilege` VALUES ('Data clerk','Delete Relationships');
INSERT INTO `role_privilege` VALUES ('Data clerk','Edit Encounters');
INSERT INTO `role_privilege` VALUES ('Data clerk','Edit Patients');
INSERT INTO `role_privilege` VALUES ('Data clerk','Edit Relationships');
INSERT INTO `role_privilege` VALUES ('Data clerk','Edit Visits');
INSERT INTO `role_privilege` VALUES ('Data clerk','Get Care Settings');
INSERT INTO `role_privilege` VALUES ('Data clerk','Get Concepts');
INSERT INTO `role_privilege` VALUES ('Data clerk','Get Encounter Roles');
INSERT INTO `role_privilege` VALUES ('Data clerk','Get Encounters');
INSERT INTO `role_privilege` VALUES ('Data clerk','Get Forms');
INSERT INTO `role_privilege` VALUES ('Data clerk','Get Observations');
INSERT INTO `role_privilege` VALUES ('Data clerk','Get Orders');
INSERT INTO `role_privilege` VALUES ('Data clerk','Get Patients');
INSERT INTO `role_privilege` VALUES ('Data clerk','Get People');
INSERT INTO `role_privilege` VALUES ('Data clerk','Get Providers');
INSERT INTO `role_privilege` VALUES ('Data clerk','Get Radiology Orders');
INSERT INTO `role_privilege` VALUES ('Data clerk','Get Users');
INSERT INTO `role_privilege` VALUES ('Data clerk','Get Visit Attribute Types');
INSERT INTO `role_privilege` VALUES ('Data clerk','Get Visit Types');
INSERT INTO `role_privilege` VALUES ('Data clerk','Get Visits');
INSERT INTO `role_privilege` VALUES ('Data clerk','View Navigation Menu');
INSERT INTO `role_privilege` VALUES ('Data clerk','View Orders');
INSERT INTO `role_privilege` VALUES ('Data clerk','View Patients');
INSERT INTO `role_privilege` VALUES ('Data clerk','Manage Visit Types');

-- Setup Role Radiology: Referring physician
INSERT INTO `role_privilege` VALUES ('Radiology: Referring physician','Patient Dashboard - View Demographics Section');
INSERT INTO `role_privilege` VALUES ('Radiology: Referring physician','Patient Dashboard - View Encounters Section');
INSERT INTO `role_privilege` VALUES ('Radiology: Referring physician','Patient Dashboard - View Overview Section');
INSERT INTO `role_privilege` VALUES ('Radiology: Referring physician','Patient Dashboard - View Patient Summary');
INSERT INTO `role_privilege` VALUES ('Radiology: Referring physician','Patient Dashboard - View Radiology Section');
INSERT INTO `role_privilege` VALUES ('Radiology: Referring physician','Patient Dashboard - View Regimen Section');
INSERT INTO `role_privilege` VALUES ('Radiology: Referring physician','Add Encounters');
INSERT INTO `role_privilege` VALUES ('Radiology: Referring physician','Add Orders');
INSERT INTO `role_privilege` VALUES ('Radiology: Referring physician','Add Radiology Orders');
INSERT INTO `role_privilege` VALUES ('Radiology: Referring physician','Add Radiology Studies');
INSERT INTO `role_privilege` VALUES ('Radiology: Referring physician','Add Relationships');
INSERT INTO `role_privilege` VALUES ('Radiology: Referring physician','Add Visits');
INSERT INTO `role_privilege` VALUES ('Radiology: Referring physician','Delete Radiology Orders');
INSERT INTO `role_privilege` VALUES ('Radiology: Referring physician','Delete Relationships');
INSERT INTO `role_privilege` VALUES ('Radiology: Referring physician','Edit Encounters');
INSERT INTO `role_privilege` VALUES ('Radiology: Referring physician','Edit Orders');
INSERT INTO `role_privilege` VALUES ('Radiology: Referring physician','Edit Radiology Studies');
INSERT INTO `role_privilege` VALUES ('Radiology: Referring physician','Edit Relationships');
INSERT INTO `role_privilege` VALUES ('Radiology: Referring physician','Edit Visits');
INSERT INTO `role_privilege` VALUES ('Radiology: Referring physician','Get Care Settings');
INSERT INTO `role_privilege` VALUES ('Radiology: Referring physician','Get Concepts');
INSERT INTO `role_privilege` VALUES ('Radiology: Referring physician','Get Encounter Roles');
INSERT INTO `role_privilege` VALUES ('Radiology: Referring physician','Get Encounters');
INSERT INTO `role_privilege` VALUES ('Radiology: Referring physician','Get Observations');
INSERT INTO `role_privilege` VALUES ('Radiology: Referring physician','Get Orders');
INSERT INTO `role_privilege` VALUES ('Radiology: Referring physician','Get Patients');
INSERT INTO `role_privilege` VALUES ('Radiology: Referring physician','Get People');
INSERT INTO `role_privilege` VALUES ('Radiology: Referring physician','Get Providers');
INSERT INTO `role_privilege` VALUES ('Radiology: Referring physician','Get Radiology Orders');
INSERT INTO `role_privilege` VALUES ('Radiology: Referring physician','Get Radiology Studies');
INSERT INTO `role_privilege` VALUES ('Radiology: Referring physician','Get Users');
INSERT INTO `role_privilege` VALUES ('Radiology: Referring physician','Get Visit Attribute Types');
INSERT INTO `role_privilege` VALUES ('Radiology: Referring physician','Get Visit Types');
INSERT INTO `role_privilege` VALUES ('Radiology: Referring physician','Get Visits');
INSERT INTO `role_privilege` VALUES ('Radiology: Referring physician','View Navigation Menu');
INSERT INTO `role_privilege` VALUES ('Radiology: Referring physician','View Orders');
INSERT INTO `role_privilege` VALUES ('Radiology: Referring physician','View Patients');
INSERT INTO `role_privilege` VALUES ('Radiology: Referring physician','Manage Visit Types');

-- Setup Role Radiology: Scheduler
INSERT INTO `role_privilege` VALUES ('Radiology: Scheduler','Get Care Settings');
INSERT INTO `role_privilege` VALUES ('Radiology: Scheduler','Get Concepts');
INSERT INTO `role_privilege` VALUES ('Radiology: Scheduler','Get Encounter Roles');
INSERT INTO `role_privilege` VALUES ('Radiology: Scheduler','Get Encounters');
INSERT INTO `role_privilege` VALUES ('Radiology: Scheduler','Get Orders');
INSERT INTO `role_privilege` VALUES ('Radiology: Scheduler','Get Patients');
INSERT INTO `role_privilege` VALUES ('Radiology: Scheduler','Get Providers');
INSERT INTO `role_privilege` VALUES ('Radiology: Scheduler','Get Radiology Orders');
INSERT INTO `role_privilege` VALUES ('Radiology: Scheduler','Get Users');
INSERT INTO `role_privilege` VALUES ('Radiology: Scheduler','Get Visit Attribute Types');
INSERT INTO `role_privilege` VALUES ('Radiology: Scheduler','Get Visit Types');
INSERT INTO `role_privilege` VALUES ('Radiology: Scheduler','Get Visits');
INSERT INTO `role_privilege` VALUES ('Radiology: Scheduler','View Navigation Menu');
INSERT INTO `role_privilege` VALUES ('Radiology: Scheduler','View Navigation Menu - Radiology');
INSERT INTO `role_privilege` VALUES ('Radiology: Scheduler','View Orders');

-- Setup Role Radiology: Performing physician
INSERT INTO `role_privilege` VALUES ('Radiology: Performing physician','Get Care Settings');
INSERT INTO `role_privilege` VALUES ('Radiology: Performing physician','Get Concepts');
INSERT INTO `role_privilege` VALUES ('Radiology: Performing physician','Get Encounter Roles');
INSERT INTO `role_privilege` VALUES ('Radiology: Performing physician','Get Encounters');
INSERT INTO `role_privilege` VALUES ('Radiology: Performing physician','Get Orders');
INSERT INTO `role_privilege` VALUES ('Radiology: Performing physician','Get Patients');
INSERT INTO `role_privilege` VALUES ('Radiology: Performing physician','Get Providers');
INSERT INTO `role_privilege` VALUES ('Radiology: Performing physician','Get Radiology Orders');
INSERT INTO `role_privilege` VALUES ('Radiology: Performing physician','Get Radiology Studies');
INSERT INTO `role_privilege` VALUES ('Radiology: Performing physician','Get Users');
INSERT INTO `role_privilege` VALUES ('Radiology: Performing physician','Get Visit Attribute Types');
INSERT INTO `role_privilege` VALUES ('Radiology: Performing physician','Get Visit Types');
INSERT INTO `role_privilege` VALUES ('Radiology: Performing physician','Get Visits');
INSERT INTO `role_privilege` VALUES ('Radiology: Performing physician','View Navigation Menu');
INSERT INTO `role_privilege` VALUES ('Radiology: Performing physician','View Navigation Menu - Radiology');
INSERT INTO `role_privilege` VALUES ('Radiology: Performing physician','View Orders');

-- Setup Role Radiology: Reading physician
INSERT INTO `role_privilege` VALUES ('Radiology: Reading physician','Add Radiology Reports');
INSERT INTO `role_privilege` VALUES ('Radiology: Reading physician','Add Radiology Report Templates');
INSERT INTO `role_privilege` VALUES ('Radiology: Reading physician','Delete Radiology Reports');
INSERT INTO `role_privilege` VALUES ('Radiology: Reading physician','Delete Radiology Report Templates');
INSERT INTO `role_privilege` VALUES ('Radiology: Reading physician','Edit Radiology Reports');
INSERT INTO `role_privilege` VALUES ('Radiology: Reading physician','Get Care Settings');
INSERT INTO `role_privilege` VALUES ('Radiology: Reading physician','Get Concepts');
INSERT INTO `role_privilege` VALUES ('Radiology: Reading physician','Get Concept Sources');
INSERT INTO `role_privilege` VALUES ('Radiology: Reading physician','Get Concept Reference Terms');
INSERT INTO `role_privilege` VALUES ('Radiology: Reading physician','Get Encounter Roles');
INSERT INTO `role_privilege` VALUES ('Radiology: Reading physician','Get Encounters');
INSERT INTO `role_privilege` VALUES ('Radiology: Reading physician','Get Orders');
INSERT INTO `role_privilege` VALUES ('Radiology: Reading physician','Get Patients');
INSERT INTO `role_privilege` VALUES ('Radiology: Reading physician','Get Providers');
INSERT INTO `role_privilege` VALUES ('Radiology: Reading physician','Get Radiology Orders');
INSERT INTO `role_privilege` VALUES ('Radiology: Reading physician','Get Radiology Reports');
INSERT INTO `role_privilege` VALUES ('Radiology: Reading physician','Get Radiology Report Templates');
INSERT INTO `role_privilege` VALUES ('Radiology: Reading physician','Get Radiology Studies');
INSERT INTO `role_privilege` VALUES ('Radiology: Reading physician','Get Users');
INSERT INTO `role_privilege` VALUES ('Radiology: Reading physician','Get Visit Attribute Types');
INSERT INTO `role_privilege` VALUES ('Radiology: Reading physician','Get Visit Types');
INSERT INTO `role_privilege` VALUES ('Radiology: Reading physician','Get Visits');
INSERT INTO `role_privilege` VALUES ('Radiology: Reading physician','View Orders');
INSERT INTO `role_privilege` VALUES ('Radiology: Reading physician','View Navigation Menu');
INSERT INTO `role_privilege` VALUES ('Radiology: Reading physician','View Navigation Menu - Radiology');
INSERT INTO `role_privilege` VALUES ('Radiology: Reading physician','View Radiology Report Templates');

-- Setup Role Radiology: Administrator
INSERT INTO role VALUES ('Radiology: Administrator','The user who manages modalities, radiology concepts and reference terms','a9d7704b-96e3-4a85-87a0-4d33d771b201');
INSERT INTO `role_privilege` VALUES ('Radiology: Administrator','Add Radiology Report Templates');
INSERT INTO `role_privilege` VALUES ('Radiology: Administrator','Get Concept Attribute Types');
INSERT INTO `role_privilege` VALUES ('Radiology: Administrator','Get Concept Map Types');
INSERT INTO `role_privilege` VALUES ('Radiology: Administrator','Get Concepts');
INSERT INTO `role_privilege` VALUES ('Radiology: Administrator','Get Concept Reference Terms');
INSERT INTO `role_privilege` VALUES ('Radiology: Administrator','Get Concept Sources');
INSERT INTO `role_privilege` VALUES ('Radiology: Administrator','Get Forms');
INSERT INTO `role_privilege` VALUES ('Radiology: Administrator','Get Global Properties');
INSERT INTO `role_privilege` VALUES ('Radiology: Administrator','Get Location Attribute Types');
INSERT INTO `role_privilege` VALUES ('Radiology: Administrator','Get Locations');
INSERT INTO `role_privilege` VALUES ('Radiology: Administrator','Get Patient Programs');
INSERT INTO `role_privilege` VALUES ('Radiology: Administrator','Get Observations');
INSERT INTO `role_privilege` VALUES ('Radiology: Administrator','Get Radiology Modalities');
INSERT INTO `role_privilege` VALUES ('Radiology: Administrator','Get Radiology Report Templates');
INSERT INTO `role_privilege` VALUES ('Radiology: Administrator','Manage Concept Attribute Types');
INSERT INTO `role_privilege` VALUES ('Radiology: Administrator','Manage Concept Reference Terms');
INSERT INTO `role_privilege` VALUES ('Radiology: Administrator','Manage Concept Sources');
INSERT INTO `role_privilege` VALUES ('Radiology: Administrator','Manage Concepts');
INSERT INTO `role_privilege` VALUES ('Radiology: Administrator','Manage Global Properties');
INSERT INTO `role_privilege` VALUES ('Radiology: Administrator','Manage Implementation Id');
INSERT INTO `role_privilege` VALUES ('Radiology: Administrator','Manage Locations');
INSERT INTO `role_privilege` VALUES ('Radiology: Administrator','Manage Location Tags');
INSERT INTO `role_privilege` VALUES ('Radiology: Administrator','Manage Radiology Modalities');
INSERT INTO `role_privilege` VALUES ('Radiology: Administrator','Manage Search Index');
INSERT INTO privilege VALUES ('Purge Concepts','Able to purge concepts','785a2fc8-2a53-406d-ac2c-0719552cc185');
INSERT INTO privilege VALUES ('Purge Concept Reference Terms','Able to purge concept reference terms','f60f05b0-0350-4274-9dcd-0a52a0d109f2');
INSERT INTO privilege VALUES ('Purge Concept Sources','Able to purge concept sources','fbdcd91c-3fc3-45c4-8f73-773b74f2dbe0');
INSERT INTO `role_privilege` VALUES ('Radiology: Administrator','Purge Concepts');
INSERT INTO `role_privilege` VALUES ('Radiology: Administrator','Purge Concept Reference Terms');
INSERT INTO `role_privilege` VALUES ('Radiology: Administrator','Purge Concept Sources');
INSERT INTO `role_privilege` VALUES ('Radiology: Administrator','View Administration Functions');
INSERT INTO `role_privilege` VALUES ('Radiology: Administrator','View Concept Classes');
INSERT INTO `role_privilege` VALUES ('Radiology: Administrator','View Concept Datatypes');
INSERT INTO `role_privilege` VALUES ('Radiology: Administrator','View Concept Sources');
INSERT INTO `role_privilege` VALUES ('Radiology: Administrator','View Concepts');
INSERT INTO `role_privilege` VALUES ('Radiology: Administrator','View Global Properties');
INSERT INTO `role_privilege` VALUES ('Radiology: Administrator','View Navigation Menu');
INSERT INTO `role_privilege` VALUES ('Radiology: Administrator','View Navigation Menu - Radiology');
INSERT INTO `role_privilege` VALUES ('Radiology: Administrator','View Radiology Report Templates');

-- ----------------------------
--  Radiology Module Users
-- ----------------------------
-- Password for all users is "Radio1234"

-- Radiology Administrator
BEGIN;
INSERT INTO `person` (person_id,gender,birthdate,creator,date_created,uuid) VALUES (9,'M','1984-07-09',1,'2016-05-24 09:14:38','237304b6-5183-42df-9768-4730bede89f0');
INSERT INTO `person_name` (person_name_id,person_id,given_name,family_name,creator,date_created,uuid) VALUES (9,9,'Nicholaus','Wuckert',1,'2016-05-24 09:14:38','8c973777-2b1f-489b-8096-3b2717315eb6');
INSERT INTO `users` (user_id,system_id,person_id,username,password,salt,creator,date_created,uuid) VALUES (9,'9-9',9,'radmin','e25b2d0708d753eb05c53b4f260c901a6719fd093860a6b3d692d01ecda7070519d139d45317d6b2d44337a69c2827c67dbdf52352162056dd114a92c7152ff4','c788c6ad82a157b712392ca695dfcf2eed193d7f',1,'2016-05-24 09:14:38','be6e1383-52e7-4931-a1a4-29bfb4d77c45');
INSERT INTO `user_role` VALUES (9,'Radiology: Administrator');
INSERT INTO `provider` (provider_id,person_id,identifier,creator,date_created,uuid) VALUES (9,9,'9',1,'2016-05-24 09:14:38','275b43f9-e1cc-44e3-8b34-65dc2c49b201');
COMMIT;

-- Referring Phyisicians
BEGIN;
INSERT INTO `person` (person_id,gender,birthdate,creator,date_created,uuid) VALUES (10,'F','1954-03-12',1,'2016-05-24 09:14:38','21062575-c29e-4409-8c0d-beb533dc22bb');
INSERT INTO `person_name` (person_name_id,person_id,given_name,family_name,creator,date_created,uuid) VALUES (10,10,'Susie','Lowe',1,'2016-05-24 09:14:38','3da0978b-60fb-4444-9de2-0a1f976848ed');
INSERT INTO `users` (user_id,system_id,person_id,username,password,salt,creator,date_created,uuid) VALUES (10,'10-10',10,'ref1','e25b2d0708d753eb05c53b4f260c901a6719fd093860a6b3d692d01ecda7070519d139d45317d6b2d44337a69c2827c67dbdf52352162056dd114a92c7152ff4','c788c6ad82a157b712392ca695dfcf2eed193d7f',1,'2016-05-24 09:14:38','4592ced3-7c55-4b2a-9a6b-bdea83a64e0e');
INSERT INTO `user_role` VALUES (10,'Radiology: Referring physician');
INSERT INTO `provider` (provider_id,person_id,identifier,creator,date_created,uuid) VALUES (10,10,'10',1,'2016-05-24 09:14:38','fe14a7ee-7af6-4217-b9d1-7101ac6c9c26');
COMMIT;

BEGIN;
INSERT INTO `person` (person_id,gender,birthdate,creator,date_created,uuid) VALUES (11,'M','1968-11-10',1,'2016-05-24 09:14:38','7bd71ecf-192c-491d-a9e3-a54711400bdf');
INSERT INTO `person_name` (person_name_id,person_id,given_name,family_name,creator,date_created,uuid) VALUES (11,11,'Dimitri','Christiansen',1,'2016-05-24 09:14:38','29533715-a04d-4578-a305-9ac140a200e4');
INSERT INTO `users` (user_id, system_id, person_id, username, password, salt, creator, date_created, uuid) VALUES (11,'11-11',11,'ref2','e25b2d0708d753eb05c53b4f260c901a6719fd093860a6b3d692d01ecda7070519d139d45317d6b2d44337a69c2827c67dbdf52352162056dd114a92c7152ff4','c788c6ad82a157b712392ca695dfcf2eed193d7f',1,'2016-05-24 09:14:38','87feab09-25b7-476a-8aaf-c39c47818b90');
INSERT INTO `user_role` VALUES (11,'Radiology: Referring physician');
INSERT INTO `provider` (provider_id,person_id,identifier,creator,date_created,uuid) VALUES (11,11,'11',1,'2016-05-24 09:14:38','fe2fe78f-d545-4ac4-9131-fd800c43c1f8');
COMMIT;

-- Scheduler
BEGIN;
INSERT INTO `person` (person_id,gender,birthdate,creator,date_created,uuid) VALUES (12,'F','1988-07-16',1,'2016-05-24 12:59:42','4e51c587-cf16-48cc-acce-9187d307f59c');
INSERT INTO `person_name` (person_name_id,person_id,given_name,family_name,creator,date_created,uuid) VALUES (12,12,'Juliana','Kon',1,'2016-05-24 12:59:42','ca499806-d45e-4743-9c21-1daaf99af7b7');
INSERT INTO `users` (user_id, system_id, person_id, username, password, salt, creator, date_created, uuid) VALUES (12,'12-12',12,'sch1','e25b2d0708d753eb05c53b4f260c901a6719fd093860a6b3d692d01ecda7070519d139d45317d6b2d44337a69c2827c67dbdf52352162056dd114a92c7152ff4','c788c6ad82a157b712392ca695dfcf2eed193d7f',1,'2016-05-24 12:59:42','086444a6-10df-4b51-b690-bb201800b1da');
INSERT INTO `user_role` VALUES (12,'Radiology: Scheduler');
INSERT INTO `provider` (provider_id,person_id,identifier,creator,date_created,uuid) VALUES (12,12,'12',1,'2016-05-24 09:14:38','3c745c8c-b89c-4559-bdae-b91c4293f966');
COMMIT;

-- Performing Physician
BEGIN;
INSERT INTO `person` (person_id,gender,birthdate,creator,date_created,uuid) VALUES (13,'F','1983-05-22',1,'2016-05-24 14:00:28','9a096a0c-14b8-4fb1-ac60-4b9fbbb3e407');
INSERT INTO `person_name` (person_name_id,person_id,given_name,family_name,creator,date_created,uuid) VALUES (13,13,'Melody','Jaskolski',1,'2016-05-24 14:00:28','95d4b275-1d15-4d28-90a8-08bebdc55776');
INSERT INTO `users` (user_id, system_id, person_id, username, password, salt, creator, date_created, uuid) VALUES (13,'13-13',13,'per1','e25b2d0708d753eb05c53b4f260c901a6719fd093860a6b3d692d01ecda7070519d139d45317d6b2d44337a69c2827c67dbdf52352162056dd114a92c7152ff4','c788c6ad82a157b712392ca695dfcf2eed193d7f',1,'2016-05-24 14:00:28','21db08e3-97ab-4133-8c71-e9de4273c6d6');
INSERT INTO `user_role` VALUES (13,'Radiology: Performing physician');
INSERT INTO `provider` (provider_id,person_id,identifier,creator,date_created,uuid) VALUES (13,13,'13',1,'2016-05-24 09:14:38','0fdc1150-17f4-4643-b9ca-f4306b92a89d');
COMMIT;

-- Reading physician
BEGIN;
INSERT INTO `person` (person_id,gender,birthdate,creator,date_created,uuid) VALUES (14,'F','1971-10-27',1,'2016-05-24 14:38:56','6b4f1559-cdbd-48e0-9aef-747a234e083a');
INSERT INTO `person_name` (person_name_id,person_id,given_name,family_name,creator,date_created,uuid) VALUES (14,14,'Alexandra','Skiles',1,'2016-05-24 14:38:56','90324075-ffa7-4eb7-b4b7-83831068547d');
INSERT INTO `users` (user_id, system_id, person_id, username, password, salt, creator, date_created, uuid) VALUES (14,'14-14',14,'rad1','e25b2d0708d753eb05c53b4f260c901a6719fd093860a6b3d692d01ecda7070519d139d45317d6b2d44337a69c2827c67dbdf52352162056dd114a92c7152ff4','c788c6ad82a157b712392ca695dfcf2eed193d7f',1,'2016-05-24 14:38:56','c23d87c1-efd2-4c77-84b8-af58d684d22c');
INSERT INTO `user_role` VALUES (14,'Radiology: Reading physician');
INSERT INTO `provider` (provider_id,person_id,identifier,creator,date_created,uuid) VALUES (14,14,'14',1,'2016-05-24 09:14:38','d032538d-e68c-4b81-a899-db0f521e1a7d');
COMMIT;

BEGIN;
INSERT INTO `person` (person_id,gender,birthdate,creator,date_created,uuid) VALUES (15,'M','1966-06-07',1,'2016-05-24 14:38:56','4b22ff33-7f0a-486b-94e0-5bc0ec6e949d');
INSERT INTO `person_name` (person_name_id,person_id,given_name,family_name,creator,date_created,uuid) VALUES (15,15,'Arden','Veum',1,'2016-05-24 14:38:56','2988e881-4a9b-4664-9b2c-8966d6a739cc');
INSERT INTO `users` (user_id, system_id, person_id, username, password, salt, creator, date_created, uuid) VALUES (15,'15-15',15,'rad2','e25b2d0708d753eb05c53b4f260c901a6719fd093860a6b3d692d01ecda7070519d139d45317d6b2d44337a69c2827c67dbdf52352162056dd114a92c7152ff4','c788c6ad82a157b712392ca695dfcf2eed193d7f',1,'2016-05-24 14:38:56','fdea55bf-7efc-4338-ab4d-5773b3c3c5a8');
INSERT INTO `user_role` VALUES (15,'Radiology: Reading physician');
INSERT INTO `provider` (provider_id,person_id,identifier,creator,date_created,uuid) VALUES (15,15,'15',1,'2016-05-24 09:14:38','dd654cfa-9836-4279-a8dd-d7b755dc7d05');
COMMIT;

-- Data clerk
BEGIN;
INSERT INTO `person` (person_id,gender,birthdate,creator,date_created,uuid) VALUES (16,'M','1944-2-13','1','1996-4-21 09:00:00','204f29e6-9b1b-468a-8f1b-023b5b043482');
INSERT INTO `person_name` (person_name_id,person_id,given_name,family_name,creator,date_created,uuid) VALUES (16,16,'Makenna','Reichert','1','1996-4-21 09:00:00','f260c28c-d0ca-4a10-9d1c-5549f59e8d3c');
INSERT INTO `users` (user_id, system_id, person_id, username, password, salt, creator, date_created, uuid) VALUES (16,'16-16',16,'dat1','e25b2d0708d753eb05c53b4f260c901a6719fd093860a6b3d692d01ecda7070519d139d45317d6b2d44337a69c2827c67dbdf52352162056dd114a92c7152ff4','c788c6ad82a157b712392ca695dfcf2eed193d7f',1,'2016-05-24 14:38:56','fdea55bf-7efc-4338-ab4d-5773b3c3c5a8');
INSERT INTO `user_role` VALUES (16,'Data clerk');
COMMIT;

-- ----------------------------
--  Concept Class, Concepts, Concept Names used
--  for the Radiology Order concept (the orderable)
-- ----------------------------
BEGIN;
INSERT INTO `concept_class` VALUES (22,'Radiology/Imaging Procedure','A radiology or imaging test or procedure.',1,'2012-09-30 20:59:43',0,1,NULL,NULL,'8caa332c-efe4-4025-8b18-3398328e1323');

-- ----------------------------
--  Records of `concept`
-- ----------------------------
LOCK TABLES `concept` WRITE;
/*!40000 ALTER TABLE `concept` DISABLE KEYS */;
INSERT INTO `concept` VALUES (12,0,'','',NULL,2,22,0,1,'2004-01-01 00:00:00','',1,'2015-12-31 20:52:38',1,NULL,NULL,'12AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(101,0,'','',NULL,2,22,0,1,'2004-01-01 00:00:00','',1,'2016-01-29 02:24:24',1,NULL,NULL,'101AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(309,0,'','',NULL,2,22,0,1,'2004-01-01 00:00:00','',1,'2012-10-05 13:30:19',1,NULL,NULL,'309AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(377,0,'','',NULL,2,22,0,1,'2004-01-01 00:00:00','',1,'2016-01-29 02:26:54',1,NULL,NULL,'377AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(380,0,'','',NULL,2,22,0,1,'2004-01-01 00:00:00','',1,'2012-10-05 12:52:25',1,NULL,NULL,'380AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(382,0,'','',NULL,2,22,0,1,'2004-01-01 00:00:00','',1,'2016-01-29 02:28:05',1,NULL,NULL,'382AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(384,0,'','',NULL,2,22,0,1,'2004-01-01 00:00:00','',1,'2012-10-05 12:57:09',1,NULL,NULL,'384AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(386,0,'','',NULL,2,22,0,1,'2004-01-01 00:00:00','',1,'2012-10-05 12:57:33',1,NULL,NULL,'386AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(390,0,'','',NULL,2,22,0,1,'2004-01-01 00:00:00','',1,'2012-10-05 12:58:02',1,NULL,NULL,'390AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(392,0,'','',NULL,2,22,0,1,'2004-01-01 00:00:00','',1,'2012-10-05 12:58:29',1,NULL,NULL,'392AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(394,0,'','',NULL,2,22,0,1,'2004-01-01 00:00:00','',1,'2012-10-05 12:59:45',1,NULL,NULL,'394AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(845,0,'','',NULL,2,22,0,1,'2004-05-05 00:00:00','',1,'2012-11-03 18:27:39',1,NULL,NULL,'845AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(846,0,'','',NULL,2,22,0,1,'2004-05-05 00:00:00','',1,'2012-11-08 23:54:29',1,NULL,NULL,'846AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(852,0,'','',NULL,2,22,0,1,'2004-05-05 00:00:00','',1,'2012-10-05 13:00:40',1,NULL,NULL,'852AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(159567,0,NULL,NULL,NULL,2,22,0,1,'2010-09-06 18:58:37','',1,'2015-12-31 20:57:47',1,NULL,NULL,'159567AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(159600,0,NULL,NULL,NULL,2,22,0,1,'2010-10-29 14:04:32','',1,'2012-10-05 13:01:25',1,NULL,NULL,'159600AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(159601,0,NULL,NULL,NULL,3,22,0,1,'2010-10-29 14:09:08','',1,'2012-10-05 13:02:49',1,NULL,NULL,'159601AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(159618,0,NULL,NULL,NULL,2,22,0,1,'2010-10-29 19:43:03','',1,'2012-10-05 13:03:20',1,NULL,NULL,'159618AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(160630,0,NULL,NULL,NULL,1,22,0,1,'2012-06-23 00:07:39','',1,'2012-10-05 13:35:15',1,NULL,NULL,'160630AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(161051,0,NULL,NULL,NULL,2,22,0,1,'2012-08-03 19:41:08','',1,'2013-02-21 19:25:58',1,NULL,NULL,'161051AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(161052,0,NULL,NULL,NULL,4,22,0,1,'2012-08-03 19:43:56','',1,'2012-10-05 13:36:40',1,NULL,NULL,'161052AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(161129,0,NULL,NULL,NULL,4,22,0,1,'2012-08-12 17:30:11','',1,'2012-12-16 18:54:16',1,NULL,NULL,'161129AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(161130,0,NULL,NULL,NULL,2,22,0,1,'2012-08-12 17:32:49','',1,'2013-02-20 02:59:16',1,NULL,NULL,'161130AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(161131,0,NULL,NULL,NULL,4,22,0,1,'2012-08-12 17:38:37','',1,'2012-12-16 18:57:40',1,NULL,NULL,'161131AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(161161,0,NULL,NULL,NULL,4,22,0,1,'2012-08-29 20:40:19','',1,'2012-10-05 13:39:11',1,NULL,NULL,'161161AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(161162,0,NULL,NULL,NULL,4,22,0,1,'2012-08-29 20:43:06','',1,'2015-06-17 01:29:11',1,NULL,NULL,'161162AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(161163,0,NULL,NULL,NULL,4,22,0,1,'2012-08-29 20:45:10','',1,'2012-11-08 23:23:36',1,NULL,NULL,'161163AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(161165,0,NULL,NULL,NULL,4,22,0,1,'2012-08-29 21:31:31','',1,'2012-10-05 13:40:20',1,NULL,NULL,'161165AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(161251,0,NULL,NULL,NULL,4,22,0,1,'2012-10-17 20:27:15','',1,'2012-11-04 00:47:34',1,NULL,NULL,'161251AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(161263,0,NULL,NULL,NULL,4,22,0,1,'2012-11-03 15:28:47','',1,'2012-11-03 15:53:22',1,NULL,NULL,'161263AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(161264,0,NULL,NULL,NULL,4,22,0,1,'2012-11-03 15:34:42','',1,'2012-11-04 03:48:45',1,NULL,NULL,'161264AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(161265,0,NULL,NULL,NULL,4,22,0,1,'2012-11-03 15:56:21','',1,NULL,1,NULL,NULL,'161265AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(161266,0,NULL,NULL,NULL,4,22,0,1,'2012-11-03 15:58:17','',1,NULL,1,NULL,NULL,'161266AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(161267,0,NULL,NULL,NULL,4,22,0,1,'2012-11-03 15:59:32','',1,NULL,1,NULL,NULL,'161267AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(161268,0,NULL,NULL,NULL,4,22,0,1,'2012-11-03 16:01:15','',1,NULL,1,NULL,NULL,'161268AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(161269,0,NULL,NULL,NULL,4,22,0,1,'2012-11-03 16:04:03','',1,NULL,1,NULL,NULL,'161269AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(161270,0,NULL,NULL,NULL,4,22,0,1,'2012-11-03 16:05:44','',1,NULL,1,NULL,NULL,'161270AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(161271,0,NULL,NULL,NULL,4,22,0,1,'2012-11-03 16:07:58','',1,NULL,1,NULL,NULL,'161271AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(161272,0,NULL,NULL,NULL,4,22,0,1,'2012-11-03 16:16:37','',1,'2012-11-03 16:20:06',1,NULL,NULL,'161272AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(161273,0,NULL,NULL,NULL,4,22,0,1,'2012-11-03 16:18:33','',1,'2012-11-03 16:19:49',1,NULL,NULL,'161273AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(161274,0,NULL,NULL,NULL,4,22,0,1,'2012-11-03 16:21:09','',1,'2012-11-03 23:48:52',1,NULL,NULL,'161274AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(161275,0,NULL,NULL,NULL,4,22,0,1,'2012-11-03 16:27:13','',1,'2012-11-03 23:44:55',1,NULL,NULL,'161275AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(161276,0,NULL,NULL,NULL,4,22,0,1,'2012-11-03 16:29:24','',1,'2012-11-03 23:50:16',1,NULL,NULL,'161276AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(161277,0,NULL,NULL,NULL,4,22,0,1,'2012-11-03 16:39:44','',1,'2015-12-31 21:41:33',1,NULL,NULL,'161277AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(161278,0,NULL,NULL,NULL,4,22,0,1,'2012-11-03 16:52:20','',1,'2012-11-04 00:02:01',1,NULL,NULL,'161278AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(161279,0,NULL,NULL,NULL,4,22,0,1,'2012-11-03 16:56:44','',1,'2012-11-04 00:03:41',1,NULL,NULL,'161279AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(161280,0,NULL,NULL,NULL,4,22,0,1,'2012-11-03 17:01:07','',1,'2012-11-04 00:08:25',1,NULL,NULL,'161280AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(161281,0,NULL,NULL,NULL,4,22,0,1,'2012-11-03 17:05:39','',1,'2012-11-04 00:06:31',1,NULL,NULL,'161281AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(161282,0,NULL,NULL,NULL,4,22,0,1,'2012-11-03 17:19:49','',1,'2012-11-04 00:09:08',1,NULL,NULL,'161282AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(161283,0,NULL,NULL,NULL,4,22,0,1,'2012-11-03 17:21:55','',1,'2012-11-04 00:09:45',1,NULL,NULL,'161283AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(161284,0,NULL,NULL,NULL,4,22,0,1,'2012-11-03 17:30:46','',1,'2012-11-04 00:14:24',1,NULL,NULL,'161284AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(161285,0,NULL,NULL,NULL,4,22,0,1,'2012-11-03 17:38:13','',1,'2012-11-03 17:38:45',1,NULL,NULL,'161285AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(161286,0,NULL,NULL,NULL,4,22,0,1,'2012-11-03 17:43:43','',1,'2012-11-04 00:21:23',1,NULL,NULL,'161286AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(161287,0,NULL,NULL,NULL,4,22,0,1,'2012-11-03 18:01:02','',1,'2012-11-04 00:26:10',1,NULL,NULL,'161287AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(161288,0,NULL,NULL,NULL,4,22,0,1,'2012-11-03 18:06:05','',1,'2012-11-04 00:27:47',1,NULL,NULL,'161288AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(161289,0,NULL,NULL,NULL,4,22,0,1,'2012-11-03 18:11:42','',1,'2012-11-04 00:28:24',1,NULL,NULL,'161289AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(161290,0,NULL,NULL,NULL,4,22,0,1,'2012-11-03 18:18:43','',1,'2012-11-04 00:32:11',1,NULL,NULL,'161290AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(161291,0,NULL,NULL,NULL,4,22,0,1,'2012-11-03 18:23:31','',1,'2012-11-04 00:32:45',1,NULL,NULL,'161291AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(161292,0,NULL,NULL,NULL,4,22,0,1,'2012-11-03 18:55:34','',1,'2012-11-12 16:34:49',1,NULL,NULL,'161292AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(161293,0,NULL,NULL,NULL,4,22,0,1,'2012-11-03 19:22:03','',1,'2012-11-12 16:35:28',1,NULL,NULL,'161293AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(161294,0,NULL,NULL,NULL,4,22,0,1,'2012-11-04 03:37:36','',1,NULL,1,NULL,NULL,'161294AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(161295,0,NULL,NULL,NULL,4,22,0,1,'2012-11-04 03:53:36','',1,NULL,1,NULL,NULL,'161295AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(161296,0,NULL,NULL,NULL,4,22,0,1,'2012-11-04 03:54:49','',1,NULL,1,NULL,NULL,'161296AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(161297,0,NULL,NULL,NULL,4,22,0,1,'2012-11-04 03:56:13','',1,NULL,1,NULL,NULL,'161297AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(161298,0,NULL,NULL,NULL,4,22,0,1,'2012-11-04 03:58:04','',1,NULL,1,NULL,NULL,'161298AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(161299,0,NULL,NULL,NULL,4,22,0,1,'2012-11-04 03:59:12','',1,NULL,1,NULL,NULL,'161299AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(161300,0,NULL,NULL,NULL,4,22,0,1,'2012-11-04 04:01:02','',1,NULL,1,NULL,NULL,'161300AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(161301,0,NULL,NULL,NULL,4,22,0,1,'2012-11-04 04:02:52','',1,NULL,1,NULL,NULL,'161301AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(161302,0,NULL,NULL,NULL,4,22,0,1,'2012-11-07 05:11:08','',1,NULL,1,NULL,NULL,'161302AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(161303,0,NULL,NULL,NULL,4,22,0,1,'2012-11-07 05:12:25','',1,NULL,1,NULL,NULL,'161303AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(161304,0,NULL,NULL,NULL,4,22,0,1,'2012-11-07 17:27:47','',1,'2012-11-09 16:41:45',1,NULL,NULL,'161304AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(161305,0,NULL,NULL,NULL,4,22,0,1,'2012-11-07 17:29:21','',1,NULL,1,NULL,NULL,'161305AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(161306,0,NULL,NULL,NULL,4,22,0,1,'2012-11-07 17:31:15','',1,NULL,1,NULL,NULL,'161306AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(161307,0,NULL,NULL,NULL,4,22,0,1,'2012-11-07 17:32:17','',1,NULL,1,NULL,NULL,'161307AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(161308,0,NULL,NULL,NULL,4,22,0,1,'2012-11-07 17:34:04','',1,NULL,1,NULL,NULL,'161308AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(161309,0,NULL,NULL,NULL,4,22,0,1,'2012-11-08 23:05:31','',1,'2012-11-09 17:11:48',1,NULL,NULL,'161309AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(161310,0,NULL,NULL,NULL,4,22,0,1,'2012-11-08 23:12:37','',1,'2012-11-09 17:12:06',1,NULL,NULL,'161310AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(161311,0,NULL,NULL,NULL,4,22,0,1,'2012-11-08 23:18:45','',1,'2012-11-09 17:12:22',1,NULL,NULL,'161311AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(161312,0,NULL,NULL,NULL,4,22,0,1,'2012-11-08 23:28:29','',1,'2012-11-09 17:12:34',1,NULL,NULL,'161312AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(161313,0,NULL,NULL,NULL,4,22,0,1,'2012-11-08 23:33:22','',1,'2012-11-09 17:12:46',1,NULL,NULL,'161313AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(161314,0,NULL,NULL,NULL,4,22,0,1,'2012-11-08 23:36:26','',1,'2012-11-09 17:12:58',1,NULL,NULL,'161314AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(161315,0,NULL,NULL,NULL,4,22,0,1,'2012-11-08 23:42:16','',1,'2012-11-09 17:13:11',1,NULL,NULL,'161315AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(161316,0,NULL,NULL,NULL,4,22,0,1,'2012-11-09 00:01:25','',1,'2012-11-09 17:13:25',1,NULL,NULL,'161316AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(161318,0,NULL,NULL,NULL,4,22,0,1,'2012-11-09 00:14:24','',1,'2012-11-09 16:42:51',1,NULL,NULL,'161318AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(161319,0,NULL,NULL,NULL,4,22,0,1,'2012-11-09 00:26:23','',1,'2012-11-09 16:38:04',1,NULL,NULL,'161319AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(161320,0,NULL,NULL,NULL,4,22,0,1,'2012-11-09 00:44:18','',1,'2012-11-09 16:39:00',1,NULL,NULL,'161320AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(161321,0,NULL,NULL,NULL,4,22,0,1,'2012-11-09 17:15:19','',1,'2016-01-29 02:11:54',1,NULL,NULL,'161321AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(161322,0,NULL,NULL,NULL,4,22,0,1,'2012-11-09 17:16:06','',1,NULL,1,NULL,NULL,'161322AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(161323,0,NULL,NULL,NULL,4,22,0,1,'2012-11-09 17:17:55','',1,'2012-11-09 17:23:04',1,NULL,NULL,'161323AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(161324,0,NULL,NULL,NULL,4,22,0,1,'2012-11-09 17:19:30','',1,NULL,1,NULL,NULL,'161324AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(161325,0,NULL,NULL,NULL,4,22,0,1,'2012-11-09 17:20:18','',1,NULL,1,NULL,NULL,'161325AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(161326,0,NULL,NULL,NULL,4,22,0,1,'2012-11-09 17:21:56','',1,'2012-11-09 17:23:41',1,NULL,NULL,'161326AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(161327,0,NULL,NULL,NULL,4,22,0,1,'2012-11-09 19:09:02','',1,NULL,1,NULL,NULL,'161327AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(161328,0,NULL,NULL,NULL,4,22,0,1,'2012-11-09 19:12:37','',1,NULL,1,NULL,NULL,'161328AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(161329,0,NULL,NULL,NULL,4,22,0,1,'2012-11-09 19:13:00','',1,NULL,1,NULL,NULL,'161329AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(161330,0,NULL,NULL,NULL,4,22,0,1,'2012-11-09 19:13:52','',1,NULL,1,NULL,NULL,'161330AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(161331,0,NULL,NULL,NULL,4,22,0,1,'2012-11-09 19:16:04','',1,NULL,1,NULL,NULL,'161331AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(161332,0,NULL,NULL,NULL,4,22,0,1,'2012-11-09 19:17:46','',1,NULL,1,NULL,NULL,'161332AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(161333,0,NULL,NULL,NULL,4,22,0,1,'2012-11-09 19:18:51','',1,NULL,1,NULL,NULL,'161333AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(161334,0,NULL,NULL,NULL,4,22,0,1,'2012-11-09 19:20:35','',1,NULL,1,NULL,NULL,'161334AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(161335,0,NULL,NULL,NULL,4,22,0,1,'2012-11-09 19:20:42','',1,NULL,1,NULL,NULL,'161335AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(161336,0,NULL,NULL,NULL,4,22,0,1,'2012-11-09 19:24:19','',1,NULL,1,NULL,NULL,'161336AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(161337,0,NULL,NULL,NULL,4,22,0,1,'2012-11-09 19:31:27','',1,NULL,1,NULL,NULL,'161337AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(161338,0,NULL,NULL,NULL,4,22,0,1,'2012-11-09 19:32:23','',1,NULL,1,NULL,NULL,'161338AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(161339,0,NULL,NULL,NULL,4,22,0,1,'2012-11-09 19:32:44','',1,NULL,1,NULL,NULL,'161339AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(161340,0,NULL,NULL,NULL,4,22,0,1,'2012-11-09 19:33:58','',1,NULL,1,NULL,NULL,'161340AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(161341,0,NULL,NULL,NULL,4,22,0,1,'2012-11-09 19:35:31','',1,NULL,1,NULL,NULL,'161341AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(161342,0,NULL,NULL,NULL,4,22,0,1,'2012-11-09 20:26:22','',1,NULL,1,NULL,NULL,'161342AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(161343,0,NULL,NULL,NULL,4,22,0,1,'2012-11-09 20:31:30','',1,NULL,1,NULL,NULL,'161343AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(161344,0,NULL,NULL,NULL,4,22,0,1,'2012-11-09 20:38:23','',1,NULL,1,NULL,NULL,'161344AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(161345,0,NULL,NULL,NULL,4,22,0,1,'2012-11-09 20:42:14','',1,NULL,1,NULL,NULL,'161345AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(161346,0,NULL,NULL,NULL,4,22,0,1,'2012-11-09 20:45:03','',1,NULL,1,NULL,NULL,'161346AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(161347,0,NULL,NULL,NULL,4,22,0,1,'2012-11-09 20:58:37','',1,'2012-11-10 20:43:16',1,NULL,NULL,'161347AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(161348,0,NULL,NULL,NULL,4,22,0,1,'2012-11-09 21:03:01','',1,NULL,1,NULL,NULL,'161348AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(161349,0,NULL,NULL,NULL,4,22,0,1,'2012-11-09 21:06:03','',1,'2012-11-10 20:45:41',1,NULL,NULL,'161349AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(161350,0,NULL,NULL,NULL,4,22,0,1,'2012-11-09 21:08:49','',1,'2012-11-10 20:45:27',1,NULL,NULL,'161350AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(161351,0,NULL,NULL,NULL,4,22,0,1,'2012-11-11 22:48:55','',1,'2012-11-11 22:58:44',1,NULL,NULL,'161351AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(161352,0,NULL,NULL,NULL,4,22,0,1,'2012-11-11 22:56:00','',1,NULL,1,NULL,NULL,'161352AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(161353,0,NULL,NULL,NULL,4,22,0,1,'2012-11-12 16:40:57','',1,NULL,1,NULL,NULL,'161353AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(162285,1,NULL,NULL,NULL,4,22,0,1,'2014-02-04 01:06:59','',1,'2015-10-27 15:51:27',1,NULL,NULL,'162285AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(162286,0,NULL,NULL,NULL,4,22,0,1,'2014-02-04 01:13:59','',1,'2014-02-05 02:15:53',1,NULL,NULL,'162286AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(162287,0,NULL,NULL,NULL,4,22,0,1,'2014-02-05 02:25:15','',1,'2014-02-05 02:26:43',1,NULL,NULL,'162287AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(162288,0,NULL,NULL,NULL,4,22,0,1,'2014-02-05 02:31:31','',1,'2014-02-05 02:31:40',1,NULL,NULL,'162288AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(162289,0,NULL,NULL,NULL,4,22,0,1,'2014-02-05 02:36:10','',1,'2014-02-05 02:36:19',1,NULL,NULL,'162289AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(162290,0,NULL,NULL,NULL,4,22,0,1,'2014-02-05 02:40:12','',1,'2014-02-05 02:44:40',1,NULL,NULL,'162290AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(162291,0,NULL,NULL,NULL,4,22,0,1,'2014-02-05 02:46:11','',1,'2014-02-05 02:46:20',1,NULL,NULL,'162291AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(162292,0,NULL,NULL,NULL,4,22,0,1,'2014-02-05 04:29:22','',1,'2014-02-05 04:33:28',1,NULL,NULL,'162292AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(162293,0,NULL,NULL,NULL,4,22,0,1,'2014-02-05 04:32:44','',1,'2014-02-05 04:32:53',1,NULL,NULL,'162293AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(162294,0,NULL,NULL,NULL,4,22,0,1,'2014-02-05 04:36:02','',1,'2014-02-05 04:36:11',1,NULL,NULL,'162294AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(162318,1,NULL,NULL,NULL,4,22,0,1,'2014-03-22 19:26:17','',1,'2016-04-17 01:24:18',1,NULL,NULL,'162318AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(163003,0,NULL,NULL,NULL,4,22,0,1,'2015-06-17 01:33:39','',1,'2015-10-27 15:51:19',1,NULL,NULL,'163003AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(163004,0,NULL,NULL,NULL,4,22,0,1,'2015-06-17 01:37:42','',1,'2015-06-17 01:38:00',1,NULL,NULL,'163004AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(163005,0,NULL,NULL,NULL,4,22,0,1,'2015-06-17 01:40:59','',1,'2015-06-17 01:41:08',1,NULL,NULL,'163005AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(163030,0,NULL,NULL,NULL,4,22,0,1,'2015-06-26 20:01:50','',1,'2015-06-26 20:04:16',1,NULL,NULL,'163030AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(163031,0,NULL,NULL,NULL,4,22,0,1,'2015-06-26 20:02:40','',1,'2015-06-26 20:03:59',1,NULL,NULL,'163031AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(163037,0,NULL,NULL,NULL,4,22,0,1,'2015-07-01 02:42:36','',1,'2015-07-13 19:49:54',1,NULL,NULL,'163037AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(163038,0,NULL,NULL,NULL,4,22,0,1,'2015-07-01 02:46:06','',1,'2015-07-13 19:50:23',1,NULL,NULL,'163038AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(163039,0,NULL,NULL,NULL,4,22,0,1,'2015-07-01 02:50:44','',1,'2015-07-13 19:40:27',1,NULL,NULL,'163039AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(163040,0,NULL,NULL,NULL,4,22,0,1,'2015-07-01 03:03:07','',1,'2015-07-13 19:50:46',1,NULL,NULL,'163040AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(163041,0,NULL,NULL,NULL,4,22,0,1,'2015-07-01 03:06:45','',1,'2015-07-01 03:06:55',1,NULL,NULL,'163041AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA');
/*!40000 ALTER TABLE `concept` ENABLE KEYS */;
UNLOCK TABLES;

-- ----------------------------
--  Records of `concept_name`
-- ----------------------------
-- WHERE:  concept_id in (select concept_id from concept where class_id='22') and locale in ('en', 'es')
-- represents the names for concepts of the Radiology/Imaging Procedure concept class
-- ATTENTION: need to delete existing entries since there is a duplicate primary key
LOCK TABLES `concept_name` WRITE;
DELETE FROM concept_name;
INSERT INTO concept_name (concept_id,name,locale,creator,date_created,concept_name_id,voided,voided_by,date_voided,void_reason,uuid,concept_name_type,locale_preferred)
VALUES (12,'X-ray, chest','en',1,'2004-01-01 00:00:00',12,0,1,NULL,NULL,'12BBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(12,'Chest xray','en',1,'2005-01-07 00:00:00',89432,0,1,NULL,'','89432BBBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(12,'CXR','en',1,'2004-10-20 00:00:00',90121,0,1,NULL,'','90121BBBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(12,'X-ray chest','en',1,'2004-10-20 00:00:00',100223,0,1,NULL,'','100223BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(101,'X-RAY, ABDOMEN','en',1,'2004-01-01 00:00:00',116,0,1,NULL,NULL,'116BBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(101,'ABDOMINAL X-RAY','en',1,'2005-02-17 00:05:12',87136,0,1,NULL,'','87136BBBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(101,'ABDOMINAL XRAY','en',1,'2005-02-17 00:05:12',87137,0,1,NULL,'','87137BBBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(101,'KUB','en',1,'2005-02-17 00:05:12',93769,0,1,NULL,'','93769BBBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(101,'X-RAY ABDOMEN','en',1,'2004-10-20 00:00:00',100221,0,1,NULL,'','100221BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(309,'X-RAY, OTHER','en',1,'2004-01-01 00:00:00',340,0,1,NULL,NULL,'340BBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(309,'XRAY OTHER','en',1,'2005-02-16 23:58:39',100271,0,1,NULL,'','100271BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(377,'X-RAY, ARM','en',1,'2004-01-01 00:00:00',409,0,1,NULL,NULL,'409BBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(377,'ARM X-RAY','en',1,'2005-02-16 23:37:05',88184,0,1,NULL,'','88184BBBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(377,'ARM XRAY','en',1,'2005-02-16 23:59:12',88185,0,1,NULL,'','88185BBBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(377,'X-RAY ARM','en',1,'2005-02-17 00:10:04',100222,0,1,NULL,'','100222BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(377,'XRAY ARM','en',1,'2005-02-16 23:59:12',100267,0,1,NULL,'','100267BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(380,'X-RAY, LEG','en',1,'2004-01-01 00:00:00',412,0,1,NULL,NULL,'412BBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(380,'LEG X-RAY','en',1,'2005-02-17 00:03:41',93894,0,1,NULL,'','93894BBBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(380,'LEG XRAY','en',1,'2005-02-17 00:03:41',93895,0,1,NULL,'','93895BBBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(380,'X-RAY LEG','en',1,'2004-10-20 00:00:00',100227,0,1,NULL,'','100227BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(380,'XRAY LEG','en',1,'2005-02-17 00:03:41',100270,0,1,NULL,'','100270BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(382,'X-RAY, HAND','en',1,'2004-01-01 00:00:00',414,0,1,NULL,NULL,'414BBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(382,'HAND X-RAY','en',1,'2005-02-17 00:06:00',92714,0,1,NULL,'','92714BBBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(382,'HAND XRAY','en',1,'2005-02-17 00:06:00',92715,0,1,NULL,'','92715BBBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(382,'X-RAY HAND','en',1,'2004-10-20 00:00:00',100225,0,1,NULL,'','100225BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(382,'XRAY HAND','en',1,'2005-02-17 00:06:00',100269,0,1,NULL,'','100269BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(384,'X-RAY, FOOT','en',1,'2004-01-01 00:00:00',416,0,1,NULL,NULL,'416BBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(384,'FOOT X-RAY','en',1,'2005-02-17 00:06:44',92137,0,1,NULL,'','92137BBBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(384,'FOOT XRAY','en',1,'2005-02-17 00:06:44',92138,0,1,NULL,'','92138BBBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(384,'X-RAY FOOT','en',1,'2004-10-20 00:00:00',100224,0,1,NULL,'','100224BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(384,'XRAY FOOT','en',1,'2005-02-17 00:06:44',100268,0,1,NULL,'','100268BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(386,'X-RAY, SKULL','en',1,'2004-01-01 00:00:00',418,0,1,NULL,NULL,'418BBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(386,'SKULL XRAY','en',1,'2005-02-17 00:00:17',98140,0,1,NULL,'','98140BBBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(386,'X-RAY HEAD','en',1,'2004-10-20 00:00:00',100226,0,1,NULL,'','100226BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(386,'X-RAY SKULL','en',1,'2004-10-20 00:00:00',100231,0,1,NULL,'','100231BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(386,'XRAY SKULL','en',1,'2005-02-17 00:00:17',100274,0,1,NULL,'','100274BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(390,'X-RAY, SPINE','en',1,'2004-01-01 00:00:00',422,0,1,NULL,NULL,'422BBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(390,'SPINE X-RAY','en',1,'2005-02-17 00:30:13',98281,0,1,NULL,'','98281BBBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(390,'SPINE XRAY','en',1,'2005-02-17 00:30:13',98282,0,1,NULL,'','98282BBBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(390,'X-RAY SPINE','en',1,'2004-10-20 00:00:00',100232,0,1,NULL,'','100232BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(390,'XRAY SPINE','en',1,'2005-02-17 00:30:31',100275,0,1,NULL,'','100275BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(392,'X-RAY, PELVIS','en',1,'2004-01-01 00:00:00',424,0,1,NULL,NULL,'424BBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(392,'PELVIS X-RAY','en',1,'2005-02-17 00:07:32',96292,0,1,NULL,'','96292BBBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(392,'PELVIS XRAY','en',1,'2005-02-17 00:07:32',96293,0,1,NULL,'','96293BBBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(392,'X-RAY PELVIS','en',1,'2004-10-20 00:00:00',100229,0,1,NULL,'','100229BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(392,'XRAY PELVIS','en',1,'2005-02-17 00:07:32',100272,0,1,NULL,'','100272BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(394,'X-RAY, SHOULDER','en',1,'2004-01-01 00:00:00',426,0,1,NULL,NULL,'426BBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(394,'SHOULDER X-RAY','en',1,'2005-02-17 00:08:50',98035,0,1,NULL,'','98035BBBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(394,'SHOULDER XRAY','en',1,'2005-02-17 00:08:50',98036,0,1,NULL,'','98036BBBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(394,'X-RAY SHOULDER','en',1,'2004-10-20 00:00:00',100230,0,1,NULL,'','100230BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(394,'XRAY SHOULDER','en',1,'2005-02-17 00:08:50',100273,0,1,NULL,'','100273BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(845,'ULTRASOUND, ABDOMEN','en',1,'2004-05-05 00:00:00',885,0,1,NULL,NULL,'885BBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(845,'ABDOMINAL ULTRASOUND','en',1,'2005-02-18 14:48:11',87135,0,1,NULL,'','87135BBBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(845,'Ultrasonido del abdomen','es',1,'2010-05-03 16:52:34',105813,0,1,NULL,NULL,'105813BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(845,'Ultrasonido','es',1,'2010-05-03 16:52:34',105814,0,1,NULL,NULL,'105814BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(845,'Ultrasound of abdomen','en',1,'2012-11-03 18:27:39',110559,0,1,NULL,NULL,'110559BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(845,'Abdomen (US)','en',1,'2012-11-03 18:27:39',110560,0,1,NULL,NULL,'110560BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(846,'COMPUTED TOMOGRAPHY SCAN, HEAD','en',1,'2004-05-05 00:00:00',888,0,1,NULL,NULL,'888BBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(846,'HEAD CT','en',1,'2005-02-18 14:46:34',92743,0,1,NULL,'','92743BBBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(846,'CT scan, head','en',1,'2012-10-19 16:26:16',110468,0,1,NULL,'','110468BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(846,'Head without contrast (CT)','en',1,'2012-11-08 23:54:29',110634,0,1,NULL,NULL,'110634BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(852,'ULTRASOUND, HEPATIC','en',1,'2004-05-05 00:00:00',894,0,1,NULL,NULL,'894BBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(852,'HEAPTIC ULTRASOUND','en',1,'2005-02-18 14:48:41',92749,0,1,NULL,'','92749BBBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(852,'Hepatobiliary Ultrasound','en',1,'2010-09-30 19:27:28',106846,0,1,NULL,'','106846BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(159567,'Echocardiogram','en',1,'2010-09-06 18:58:37',106678,0,1,NULL,NULL,'106678BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(159600,'x-ray, upper gastrointestinal series','en',1,'2010-10-29 14:04:32',106946,0,1,NULL,NULL,'106946BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(159600,'Xray, Upper GI','en',1,'2010-10-29 15:10:39',106950,0,1,NULL,NULL,'106950BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','SHORT',0),(159600,'barium meal','en',1,'2010-10-29 15:10:39',106951,0,1,NULL,'','106951BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(159601,'fluoroscopy, esophagus','en',1,'2010-10-29 14:09:08',106947,0,1,NULL,NULL,'106947BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(159601,'esophagram','en',1,'2010-10-29 15:14:03',106952,0,1,NULL,NULL,'106952BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','SHORT',0),(159601,'barium swallow','en',1,'2010-10-29 15:14:03',106953,0,1,NULL,'','106953BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(159601,'x-ray, esophagus','en',1,'2010-10-29 15:14:03',106954,0,1,NULL,'','106954BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(159618,'Obstetric ultrasound','en',1,'2010-10-29 19:43:03',106973,0,1,NULL,NULL,'106973BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(159618,'US Obstretric','en',1,'2010-10-29 21:21:03',106980,0,1,NULL,NULL,'106980BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','SHORT',0),(160630,'Dual energy X-ray photon absorptiometry','en',1,'2012-06-23 00:07:39',109076,0,1,NULL,NULL,'109076BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(160630,'Bone mineral examination','en',1,'2012-06-23 00:07:39',109077,0,1,NULL,'','109077BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(160630,'DEXA','en',1,'2012-06-23 00:07:39',109078,0,1,NULL,NULL,'109078BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','SHORT',0),(161051,'PET (tomografía por emision de positrones)','es',1,'2012-08-03 19:41:08',109996,0,1,NULL,NULL,'109996BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(161051,'Positron emission tomography scan','en',1,'2012-08-03 19:41:08',109997,0,1,NULL,NULL,'109997BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(161051,'PET scan','en',1,'2012-08-03 19:41:08',109998,0,1,NULL,NULL,'109998BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','SHORT',0),(161052,'Magnetic resonance spectroscopy','en',1,'2012-08-03 19:43:56',109999,0,1,NULL,NULL,'109999BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(161052,'MRS (magnetic resonance spectroscopy)','en',1,'2012-08-03 19:43:56',110000,0,1,NULL,'','110000BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161052,'Espectroscopia (resonancia magnetica)','es',1,'2012-08-03 19:43:56',110001,0,1,NULL,NULL,'110001BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(161129,'Magnetic resonance imaging of brain, functional','en',1,'2012-08-12 17:30:11',110167,0,1,NULL,NULL,'110167BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(161129,'Functional magenetic resonance imaging of brain','en',1,'2012-08-12 17:30:11',110168,0,1,NULL,'','110168BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161129,'Functional MRI of brain','en',1,'2012-08-12 17:30:11',110169,0,1,NULL,'','110169BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161129,'Resonancia magnetica funcional','es',1,'2012-12-16 18:54:16',110853,0,1,NULL,NULL,'110853BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(161130,'Ictal brain single-photon emission computed tomography (SPECT)','en',1,'2012-08-12 17:32:49',110170,0,1,NULL,NULL,'110170BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(161130,'Ictal brain SPECT','en',1,'2012-08-12 17:32:49',110171,0,1,NULL,NULL,'110171BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','SHORT',0),(161130,'SPECT cerebral ictal','es',1,'2012-12-16 18:55:30',110854,0,1,NULL,NULL,'110854BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(161131,'Interictal brain SPECT','en',1,'2012-08-12 17:38:37',110172,0,1,NULL,NULL,'110172BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','SHORT',0),(161131,'Interictal brain single-photon emission computed tomography (SPECT)','en',1,'2012-08-12 17:38:37',110173,0,1,NULL,NULL,'110173BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(161131,'SPECT cerebral interictal','es',1,'2012-12-16 18:57:40',110855,0,1,NULL,NULL,'110855BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(161161,'Bone scan','en',1,'2012-08-29 20:40:19',110284,0,1,NULL,NULL,'110284BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(161162,'Abdominal and pelvic CT scan','en',1,'2012-08-29 20:43:06',110285,0,1,NULL,'','110285BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161162,'Computed tomography of abdomen and pelvis without contrast','en',1,'2012-08-29 20:43:06',110286,0,1,NULL,NULL,'110286BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(161162,'CT scan, abdomen and pelvis','en',1,'2012-11-03 18:47:10',110561,0,1,NULL,'','110561BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161162,'Abdomen and pelvis without contrast (CT)','en',1,'2015-06-17 01:29:11',127441,0,1,NULL,NULL,'127441BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161163,'CT scan, pelvis','en',1,'2012-08-29 20:45:10',110287,0,1,NULL,NULL,'110287BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(161163,'Pelvic CT scan','en',1,'2012-08-29 20:45:10',110288,0,1,NULL,'','110288BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161163,'Pelvis with and without contrast IV (CT)','en',1,'2012-11-08 23:23:36',110626,0,1,NULL,NULL,'110626BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161165,'Chest CT scan','en',1,'2012-08-29 21:31:31',110291,0,1,NULL,'','110291BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161165,'CT scan, chest','en',1,'2012-08-29 21:31:31',110292,0,1,NULL,NULL,'110292BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(161251,'Diagnostic radiography of chest, combined PA and lateral','en',1,'2012-10-17 20:27:15',110460,0,1,NULL,NULL,'110460BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(161251,'PA & Lat chest x-ray','en',1,'2012-10-17 20:27:44',110461,0,1,NULL,'','110461BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161251,'PA/LAT CXR','en',1,'2012-10-17 20:31:41',110462,0,1,NULL,NULL,'110462BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','SHORT',0),(161251,'X-ray of chest, 2 views PA/LAT','en',1,'2012-11-03 16:19:40',110520,0,1,NULL,'','110520BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161263,'X-ray of abdomen, 1 view','en',1,'2012-11-03 15:28:47',110483,0,1,NULL,NULL,'110483BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(161263,'Abdominal x-ray AP','en',1,'2012-11-03 15:28:47',110484,0,1,NULL,'','110484BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161263,'Abdomen 1 view (xray)','en',1,'2012-11-03 15:28:47',110485,0,1,NULL,'','110485BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161263,'Abdomen 1 view (x-ray)','en',1,'2012-11-03 15:53:22',110489,0,1,NULL,NULL,'110489BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161264,'Abdomen 2 views (AP supine and lateral decubitus) (xray)','en',1,'2012-11-03 15:34:42',110486,0,1,NULL,'','110486BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161264,'X-ray of abdomen, 2 views (AP supine and lateral decubitus)','en',1,'2012-11-03 15:34:42',110487,0,1,NULL,NULL,'110487BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(161264,'Abdomen 2 views (AP supine and lateral decubitus) (x-ray)','en',1,'2012-11-03 15:52:44',110488,0,1,NULL,'','110488BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161265,'Acromioclavicular (AC) joints, bilateral (xray)','en',1,'2012-11-03 15:56:21',110490,0,1,NULL,NULL,'110490BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161265,'X-ray of bilateral acromioclavicular joints','en',1,'2012-11-03 15:56:21',110491,0,1,NULL,NULL,'110491BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(161265,'Acromioclavicular (AC) joints, bilateral (x-ray)','en',1,'2012-11-03 15:56:21',110492,0,1,NULL,NULL,'110492BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161266,'Ankle left 2 views (x-ray)','en',1,'2012-11-03 15:58:17',110493,0,1,NULL,NULL,'110493BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161266,'Ankle left 2 views (xray)','en',1,'2012-11-03 15:58:17',110494,0,1,NULL,NULL,'110494BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161266,'X-ray of left ankle, 2 views','en',1,'2012-11-03 15:58:17',110495,0,1,NULL,NULL,'110495BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(161267,'X-ray of right ankle, 2 views','en',1,'2012-11-03 15:59:32',110496,0,1,NULL,NULL,'110496BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(161267,'Ankle right 2 views (x-ray)','en',1,'2012-11-03 15:59:32',110497,0,1,NULL,NULL,'110497BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161267,'Ankle right 2 views (xray)','en',1,'2012-11-03 15:59:32',110498,0,1,NULL,NULL,'110498BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161268,'Ankle bilateral 2 views (x-ray)','en',1,'2012-11-03 16:01:15',110499,0,1,NULL,NULL,'110499BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161268,'X-ray of bilateral ankles, 2 views','en',1,'2012-11-03 16:01:15',110500,0,1,NULL,NULL,'110500BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(161268,'Ankle bilateral 2 views (xray)','en',1,'2012-11-03 16:01:15',110501,0,1,NULL,NULL,'110501BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161269,'X-ray of left calcaneus, 2 views','en',1,'2012-11-03 16:04:03',110502,0,1,NULL,NULL,'110502BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(161269,'Calcaneus left 2 views (xray)','en',1,'2012-11-03 16:04:03',110503,0,1,NULL,NULL,'110503BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161269,'Calcaneus left 2 views (x-ray)','en',1,'2012-11-03 16:04:03',110504,0,1,NULL,NULL,'110504BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161269,'X-ray of heel, 2 views, left','en',1,'2012-11-03 16:04:03',110505,0,1,NULL,NULL,'110505BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161270,'Calcaneus right 2 views (x-ray)','en',1,'2012-11-03 16:05:44',110506,0,1,NULL,NULL,'110506BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161270,'X-ray of right calcaneus, 2 views','en',1,'2012-11-03 16:05:44',110507,0,1,NULL,NULL,'110507BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(161270,'Calcaneus right 2 views (xray)','en',1,'2012-11-03 16:05:44',110508,0,1,NULL,NULL,'110508BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161270,'X-ray of right heel, 2 views','en',1,'2012-11-03 16:05:44',110509,0,1,NULL,NULL,'110509BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161271,'Calcaneus bilateral 2 views (x-ray)','en',1,'2012-11-03 16:07:58',110510,0,1,NULL,NULL,'110510BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161271,'X-ray of bilateral calcaneus, 2 views','en',1,'2012-11-03 16:07:58',110511,0,1,NULL,NULL,'110511BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(161271,'Calcaneus bilateral 2 views (xray)','en',1,'2012-11-03 16:07:58',110512,0,1,NULL,NULL,'110512BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161271,'X-ray of bilateral heels, 2 views','en',1,'2012-11-03 16:07:58',110513,0,1,NULL,NULL,'110513BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161272,'X-ray of chest, 4 views, PA/LAT with right and left oblique','en',1,'2012-11-03 16:16:37',110514,0,1,NULL,NULL,'110514BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(161272,'Chest, 4 views, PA/LAT with right and left oblique (x-ray)','en',1,'2012-11-03 16:16:37',110515,0,1,NULL,'','110515BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161272,'Chest, 4 views, PA/LAT with right and left oblique (xray)','en',1,'2012-11-03 16:16:37',110516,0,1,NULL,'','110516BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161272,'CXR 4 views','en',1,'2012-11-03 16:20:06',110522,0,1,NULL,NULL,'110522BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','SHORT',0),(161273,'Chest 1 view AP (x-ray)','en',1,'2012-11-03 16:18:33',110517,0,1,NULL,'','110517BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161273,'Chest 1 view AP (xray)','en',1,'2012-11-03 16:18:33',110518,0,1,NULL,'','110518BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161273,'X-ray of chest, 1 view, AP','en',1,'2012-11-03 16:18:33',110519,0,1,NULL,NULL,'110519BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(161273,'CXR 1 view','en',1,'2012-11-03 16:19:49',110521,0,1,NULL,NULL,'110521BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','SHORT',0),(161274,'Lower extremity vein bilateral (US)','en',1,'2012-11-03 16:21:09',110523,0,1,NULL,'','110523BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161274,'Ultrasound of bilateral lower extremity veins','en',1,'2012-11-03 16:21:09',110524,0,1,NULL,NULL,'110524BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(161275,'Lower extremity vein right (US)','en',1,'2012-11-03 16:27:13',110525,0,1,NULL,'','110525BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161275,'Ultrasound of right lower extremity vein','en',1,'2012-11-03 16:27:13',110526,0,1,NULL,NULL,'110526BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(161276,'Lower extremity vein left (US)','en',1,'2012-11-03 16:29:24',110527,0,1,NULL,'','110527BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161276,'Ultrasound of left lower extremity vein','en',1,'2012-11-03 16:29:24',110528,0,1,NULL,NULL,'110528BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(161277,'Extremity (US)','en',1,'2012-11-03 16:39:44',110529,0,1,NULL,'','110529BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161277,'Ultrasound of extremity','en',1,'2012-11-03 16:39:44',110530,0,1,NULL,NULL,'110530BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(161278,'Ultrasound of pelvis, transvaginal','en',1,'2012-11-03 16:52:20',110531,0,1,NULL,NULL,'110531BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(161278,'Pelvis transvaginal (US)','en',1,'2012-11-03 16:52:20',110532,0,1,NULL,'','110532BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161279,'Scrotum and testicle (US)','en',1,'2012-11-03 16:56:44',110533,0,1,NULL,'','110533BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161279,'Ultrasound of scrotum and testicle','en',1,'2012-11-03 16:56:44',110534,0,1,NULL,NULL,'110534BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(161279,'Ultrasound of scrotum and testes','en',1,'2012-11-04 00:03:41',110566,0,1,NULL,NULL,'110566BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161279,'Scrotum and testes (US)','en',1,'2012-11-04 00:03:41',110567,0,1,NULL,NULL,'110567BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161280,'Ultrasound of abdomen and retroperitoneum, limited','en',1,'2012-11-03 17:01:07',110535,0,1,NULL,NULL,'110535BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(161280,'Abdomen retroperitoneum limited (US)','en',1,'2012-11-03 17:01:07',110536,0,1,NULL,'','110536BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161280,'Abdominal and retroperitoneal ultrasound, limited','en',1,'2012-11-04 00:08:25',110569,0,1,NULL,NULL,'110569BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161281,'Abdomen retroperitoneum (US)','en',1,'2012-11-03 17:05:39',110537,0,1,NULL,'','110537BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161281,'Ultrasound of abdomen and retroperitoneum','en',1,'2012-11-03 17:05:39',110538,0,1,NULL,NULL,'110538BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(161281,'Abdominal and retroperitoneal ultrasound','en',1,'2012-11-04 00:06:31',110568,0,1,NULL,NULL,'110568BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161282,'Pelvis limited (US)','en',1,'2012-11-03 17:19:49',110539,0,1,NULL,'','110539BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161282,'Ultrasound of pelvis, limited','en',1,'2012-11-03 17:19:49',110540,0,1,NULL,NULL,'110540BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(161282,'Pelvic ultrasound, limited','en',1,'2012-11-04 00:09:08',110570,0,1,NULL,NULL,'110570BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161283,'Pelvis (US)','en',1,'2012-11-03 17:21:55',110541,0,1,NULL,'','110541BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161283,'Ultrasound of pelvis','en',1,'2012-11-03 17:21:55',110542,0,1,NULL,NULL,'110542BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(161283,'Pelvic ultrasound','en',1,'2012-11-04 00:09:45',110571,0,1,NULL,NULL,'110571BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161284,'Guided paracentesis (US)','en',1,'2012-11-03 17:30:46',110543,0,1,NULL,'','110543BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161284,'Ultrasound guided paracentesis','en',1,'2012-11-03 17:30:46',110544,0,1,NULL,NULL,'110544BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(161285,'Head and Neck (US)','en',1,'2012-11-03 17:38:13',110545,0,1,NULL,'','110545BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161285,'Ultrasound of head and neck','en',1,'2012-11-03 17:38:13',110546,0,1,NULL,NULL,'110546BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(161286,'US guidance for aspiration of pericardial space','en',1,'2012-11-03 17:43:43',110547,0,1,NULL,'','110547BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161286,'Ultrasound guidance for aspiration of pericardial space','en',1,'2012-11-03 17:43:43',110548,0,1,NULL,NULL,'110548BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(161287,'US guidance for percutaneous drainage of cavity','en',1,'2012-11-03 18:01:02',110549,0,1,NULL,'','110549BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161287,'Ultrasound guidance for percutaneous drainage of cavity','en',1,'2012-11-03 18:01:02',110550,0,1,NULL,NULL,'110550BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(161288,'Ultrasound of chest','en',1,'2012-11-03 18:06:05',110551,0,1,NULL,NULL,'110551BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(161288,'Chest (US)','en',1,'2012-11-03 18:06:05',110552,0,1,NULL,'','110552BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161289,'Ultrasound of left breast','en',1,'2012-11-03 18:11:42',110553,0,1,NULL,NULL,'110553BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(161289,'Breast left (US)','en',1,'2012-11-03 18:11:42',110554,0,1,NULL,'','110554BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161290,'Ultrasound of right breast','en',1,'2012-11-03 18:18:43',110555,0,1,NULL,NULL,'110555BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(161290,'Breast right (US)','en',1,'2012-11-03 18:18:43',110556,0,1,NULL,'','110556BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161291,'Abdomen limited (US)','en',1,'2012-11-03 18:23:31',110557,0,1,NULL,'','110557BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161291,'Ultrasound of abdomen, limited','en',1,'2012-11-03 18:23:31',110558,0,1,NULL,NULL,'110558BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(161292,'Computed tomography of bilateral lower extremities without contrast','en',1,'2012-11-03 18:55:34',110562,0,1,NULL,NULL,'110562BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(161292,'Lower extremity bilateral without contrast (CT)','en',1,'2012-11-03 18:55:34',110563,0,1,NULL,'','110563BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161292,'CT of bilateral lower extremities without contrast','en',1,'2012-11-04 00:34:34',110572,0,1,NULL,'','110572BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161293,'Computerized tomography of right upper extremity without contrast','en',1,'2012-11-03 19:22:03',110564,0,1,NULL,NULL,'110564BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(161293,'Upper extremity right without contrast (CT)','en',1,'2012-11-03 19:22:03',110565,0,1,NULL,'','110565BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161293,'CT of right upper extremity without contrast','en',1,'2012-11-12 16:35:28',110758,0,1,NULL,NULL,'110758BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161294,'X-ray of chest, bilateral oblique','en',1,'2012-11-04 03:37:36',110573,0,1,NULL,NULL,'110573BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(161294,'Chest bilateral oblique (xray)','en',1,'2012-11-04 03:37:36',110574,0,1,NULL,NULL,'110574BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161294,'Bilateral oblique CXR','en',1,'2012-11-04 03:37:36',110575,0,1,NULL,NULL,'110575BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','SHORT',0),(161294,'Chest bilateral oblique (x-ray)','en',1,'2012-11-04 03:37:36',110576,0,1,NULL,NULL,'110576BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161295,'CXR 2 views and apical','en',1,'2012-11-04 03:53:36',110577,0,1,NULL,NULL,'110577BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','SHORT',0),(161295,'Chest 2 views and apical (xray)','en',1,'2012-11-04 03:53:36',110578,0,1,NULL,NULL,'110578BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161295,'X-ray of chest, 2 views and apical lordotic','en',1,'2012-11-04 03:53:36',110579,0,1,NULL,NULL,'110579BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(161295,'Chest 2 views and apical (x-ray)','en',1,'2012-11-04 03:53:36',110580,0,1,NULL,NULL,'110580BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161296,'X-ray of chest, apical lordotic','en',1,'2012-11-04 03:54:49',110581,0,1,NULL,NULL,'110581BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(161296,'Chest lordotic (xray)','en',1,'2012-11-04 03:54:49',110582,0,1,NULL,NULL,'110582BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161296,'Chest lordotic (x-ray)','en',1,'2012-11-04 03:54:49',110583,0,1,NULL,NULL,'110583BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161296,'CXR apical lordotic','en',1,'2012-11-04 03:54:49',110584,0,1,NULL,NULL,'110584BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','SHORT',0),(161297,'Chest 4 views (xray)','en',1,'2012-11-04 03:56:13',110585,0,1,NULL,NULL,'110585BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161297,'Chest 4 views (x-ray)','en',1,'2012-11-04 03:56:13',110586,0,1,NULL,NULL,'110586BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161297,'X-ray of chest, 4 views','en',1,'2012-11-04 03:56:13',110587,0,1,NULL,NULL,'110587BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(161298,'X-ray of left clavicle, 2 views','en',1,'2012-11-04 03:58:04',110588,0,1,NULL,NULL,'110588BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(161298,'Clavicle left 2 views (xray)','en',1,'2012-11-04 03:58:04',110589,0,1,NULL,NULL,'110589BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161298,'Clavicle left 2 views (x-ray)','en',1,'2012-11-04 03:58:04',110590,0,1,NULL,NULL,'110590BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161299,'X-ray of right clavicle, 2 views','en',1,'2012-11-04 03:59:12',110591,0,1,NULL,NULL,'110591BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(161299,'Clavicle right 2 views (x-ray)','en',1,'2012-11-04 03:59:12',110592,0,1,NULL,NULL,'110592BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161299,'Clavicle right 2 views (xray)','en',1,'2012-11-04 03:59:12',110593,0,1,NULL,NULL,'110593BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161300,'Clavicle bilateral 2 views (x-ray)','en',1,'2012-11-04 04:01:02',110594,0,1,NULL,NULL,'110594BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161300,'X-ray of bilateral clavicles, 2 views','en',1,'2012-11-04 04:01:02',110595,0,1,NULL,NULL,'110595BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(161300,'Clavicle bilateral 2 views (xray)','en',1,'2012-11-04 04:01:02',110596,0,1,NULL,NULL,'110596BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161301,'X-ray of cervical spine, 2 or 3 views','en',1,'2012-11-04 04:02:52',110597,0,1,NULL,NULL,'110597BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(161301,'Spine cervical 2 or 3 views (xray)','en',1,'2012-11-04 04:02:52',110598,0,1,NULL,NULL,'110598BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161301,'Spine cervical 2 or 3 views (x-ray)','en',1,'2012-11-04 04:02:52',110599,0,1,NULL,NULL,'110599BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161302,'X-ray of left elbow, 2 views','en',1,'2012-11-07 05:11:08',110600,0,1,NULL,NULL,'110600BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(161302,'Elbow, 2-views, left (xray)','en',1,'2012-11-07 05:11:08',110601,0,1,NULL,NULL,'110601BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161302,'Elbow, 2-views, left (x-ray)','en',1,'2012-11-07 05:11:08',110602,0,1,NULL,NULL,'110602BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161303,'Elbow, 2-views, right (xray)','en',1,'2012-11-07 05:12:25',110603,0,1,NULL,NULL,'110603BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161303,'Elbow, 2-views, right (x-ray)','en',1,'2012-11-07 05:12:25',110604,0,1,NULL,NULL,'110604BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161303,'X-ray of right elbow, 2 views','en',1,'2012-11-07 05:12:25',110605,0,1,NULL,NULL,'110605BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(161304,'X-ray of bilateral elbows, 2 views','en',1,'2012-11-07 17:27:47',110606,0,1,NULL,NULL,'110606BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(161304,'Elbow, 2-views, bilateral (x-ray)','en',1,'2012-11-07 17:27:47',110607,0,1,NULL,'','110607BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161304,'Elbow, 2-views, bilateral (xray)','en',1,'2012-11-09 16:41:45',110648,0,1,NULL,NULL,'110648BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161305,'X-ray of facial bones, 3 views','en',1,'2012-11-07 17:29:21',110608,0,1,NULL,NULL,'110608BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(161305,'Facial bones, 3 views (xray)','en',1,'2012-11-07 17:29:21',110609,0,1,NULL,NULL,'110609BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161305,'Facial bones, 3 views (x-ray)','en',1,'2012-11-07 17:29:21',110610,0,1,NULL,NULL,'110610BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161306,'Femur left 2 views (x-ray)','en',1,'2012-11-07 17:31:15',110611,0,1,NULL,NULL,'110611BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161306,'Femur left 2 views (xray)','en',1,'2012-11-07 17:31:15',110612,0,1,NULL,NULL,'110612BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161306,'X-ray of left femur, 2 views','en',1,'2012-11-07 17:31:15',110613,0,1,NULL,NULL,'110613BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(161307,'Femur right 2 views (xray)','en',1,'2012-11-07 17:32:17',110614,0,1,NULL,NULL,'110614BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161307,'Femur right 2 views (x-ray)','en',1,'2012-11-07 17:32:17',110615,0,1,NULL,NULL,'110615BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161307,'X-ray of right femur, 2 views','en',1,'2012-11-07 17:32:17',110616,0,1,NULL,NULL,'110616BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(161308,'Femur bilateral 2 views (xray)','en',1,'2012-11-07 17:34:04',110617,0,1,NULL,NULL,'110617BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161308,'Femur bilateral 2 views (x-ray)','en',1,'2012-11-07 17:34:04',110618,0,1,NULL,NULL,'110618BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161308,'X-ray of bilateral femurs, 2 views','en',1,'2012-11-07 17:34:04',110619,0,1,NULL,NULL,'110619BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(161309,'Computerized tomography of left upper extremity without contrast','en',1,'2012-11-08 23:05:31',110620,0,1,NULL,NULL,'110620BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(161309,'Upper extremity left without contrast (CT)','en',1,'2012-11-08 23:13:38',110623,0,1,NULL,'','110623BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161309,'CT of left upper extremity without contrast','en',1,'2012-11-09 16:48:44',110658,0,1,NULL,'','110658BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161310,'Upper extremity right with contrast IV (CT)','en',1,'2012-11-08 23:12:37',110621,0,1,NULL,'','110621BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161310,'Computerized tomography of right upper extremity with IV contrast','en',1,'2012-11-08 23:12:37',110622,0,1,NULL,NULL,'110622BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(161310,'CT of right upper extremity with IV contrast','en',1,'2012-11-09 16:48:16',110657,0,1,NULL,'','110657BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161311,'Upper extremity left with contrast IV (CT)','en',1,'2012-11-08 23:18:45',110624,0,1,NULL,'','110624BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161311,'Computerized tomography of left upper extremity with IV contrast','en',1,'2012-11-08 23:18:45',110625,0,1,NULL,NULL,'110625BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(161311,'CT of left upper extremity with IV contrast','en',1,'2012-11-09 16:47:48',110656,0,1,NULL,'','110656BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161312,'Facial bones and maxilla without contrast (CT)','en',1,'2012-11-08 23:28:29',110627,0,1,NULL,'','110627BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161312,'Computerized tomography of facial bones and maxilla without contrast','en',1,'2012-11-08 23:28:29',110628,0,1,NULL,NULL,'110628BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(161312,'CT of facial bones and maxilla without contrast','en',1,'2012-11-09 16:46:42',110655,0,1,NULL,'','110655BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161313,'Computerized tomography of right lower extremity without contrast','en',1,'2012-11-08 23:33:22',110629,0,1,NULL,NULL,'110629BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(161313,'CT of right lower extremity without contrast','en',1,'2012-11-09 16:46:13',110653,0,1,NULL,'','110653BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161313,'Lower extremity right without contrast (CT)','en',1,'2012-11-09 16:46:13',110654,0,1,NULL,'','110654BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161314,'Lower extremity left without contrast (CT)','en',1,'2012-11-08 23:36:26',110630,0,1,NULL,'','110630BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161314,'Computerized tomography of left lower extremity without contrast','en',1,'2012-11-08 23:36:26',110631,0,1,NULL,NULL,'110631BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(161314,'CT of left lower extremity without contrast','en',1,'2012-11-09 16:45:29',110652,0,1,NULL,'','110652BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161315,'Computerized tomography of lumbar spine without contrast','en',1,'2012-11-08 23:42:16',110632,0,1,NULL,NULL,'110632BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(161315,'Spine lumbar without contrast (CT)','en',1,'2012-11-08 23:42:16',110633,0,1,NULL,'','110633BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161315,'CT of lumbar spine without contrast','en',1,'2012-11-09 16:45:02',110651,0,1,NULL,'','110651BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161316,'Spine cervical without contrast (CT)','en',1,'2012-11-09 00:01:25',110635,0,1,NULL,'','110635BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161316,'Computerized tomography of cervical spine without contrast','en',1,'2012-11-09 00:01:25',110636,0,1,NULL,NULL,'110636BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(161316,'CT of cervical spine without contrast','en',1,'2012-11-09 16:44:18',110650,0,1,NULL,'','110650BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161318,'X-ray of left wrist, 2 views','en',1,'2012-11-09 00:14:24',110639,0,1,NULL,NULL,'110639BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(161318,'Wrist left 2 views (xray)','en',1,'2012-11-09 00:14:24',110640,0,1,NULL,'','110640BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161318,'Wrist left 2 views (x-ray)','en',1,'2012-11-09 16:40:00',110647,0,1,NULL,'','110647BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161319,'Retrograde pyelogram','en',1,'2012-11-09 00:26:23',110641,0,1,NULL,NULL,'110641BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(161319,'Kidney retrograde pyelogram (xray)','en',1,'2012-11-09 00:26:23',110642,0,1,NULL,'','110642BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161319,'Kidney retrograde pyelogram (x-ray)','en',1,'2012-11-09 16:38:04',110645,0,1,NULL,NULL,'110645BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161320,'X-ray of thoracic spine, 2 views','en',1,'2012-11-09 00:44:18',110643,0,1,NULL,NULL,'110643BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(161320,'Spine thoracic 2 views (xray)','en',1,'2012-11-09 00:44:18',110644,0,1,NULL,'','110644BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161320,'Spine thoracic 2 views (x-ray)','en',1,'2012-11-09 16:39:00',110646,0,1,NULL,NULL,'110646BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161321,'X-ray of left foot, 2  views','en',1,'2012-11-09 17:15:19',110659,0,1,NULL,NULL,'110659BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(161321,'Foot left 2 views (x-ray)','en',1,'2012-11-09 17:15:19',110660,0,1,NULL,'','110660BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161321,'Foot left 2 views (xray)','en',1,'2012-11-09 17:15:19',110661,0,1,NULL,'','110661BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161322,'X-ray of right foot, 2  views','en',1,'2012-11-09 17:16:06',110662,0,1,NULL,NULL,'110662BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(161322,'Foot right 2 views (xray)','en',1,'2012-11-09 17:16:06',110663,0,1,NULL,NULL,'110663BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161322,'Foot right 2 views (x-ray)','en',1,'2012-11-09 17:16:06',110664,0,1,NULL,NULL,'110664BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161323,'Foot bilateral 2 views (x-ray)','en',1,'2012-11-09 17:17:55',110665,0,1,NULL,'','110665BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161323,'X-ray of bilateral feet, 2 views','en',1,'2012-11-09 17:17:55',110666,0,1,NULL,NULL,'110666BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(161323,'Foot bilateral 2 views (xray)','en',1,'2012-11-09 17:17:55',110667,0,1,NULL,'','110667BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161324,'Forearm left 2 views (xray)','en',1,'2012-11-09 17:19:30',110668,0,1,NULL,NULL,'110668BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161324,'X-ray of left forearm, 2 views','en',1,'2012-11-09 17:19:30',110669,0,1,NULL,NULL,'110669BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(161324,'Forearm left 2 views (x-ray)','en',1,'2012-11-09 17:19:30',110670,0,1,NULL,NULL,'110670BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161325,'Forearm right 2 views (x-ray)','en',1,'2012-11-09 17:20:18',110671,0,1,NULL,NULL,'110671BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161325,'Forearm right 2 views (xray)','en',1,'2012-11-09 17:20:18',110672,0,1,NULL,NULL,'110672BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161325,'X-ray of right forearm, 2 views','en',1,'2012-11-09 17:20:18',110673,0,1,NULL,NULL,'110673BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(161326,'Forearm bilateral 2 views (x-ray)','en',1,'2012-11-09 17:21:56',110674,0,1,NULL,'','110674BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161326,'X-ray of bilateral forearms, 2 views','en',1,'2012-11-09 17:21:56',110675,0,1,NULL,NULL,'110675BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(161326,'Forearm bilateral 2 views (xray)','en',1,'2012-11-09 17:21:56',110676,0,1,NULL,'','110676BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161327,'Lower leg right 2 views (xray)','en',1,'2012-11-09 19:09:02',110677,0,1,NULL,NULL,'110677BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161327,'X-ray of right lower leg, 2 views','en',1,'2012-11-09 19:09:02',110678,0,1,NULL,NULL,'110678BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(161327,'Lower leg right 2 views (x-ray)','en',1,'2012-11-09 19:09:02',110679,0,1,NULL,NULL,'110679BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161328,'Hand left 2 views (x-ray)','en',1,'2012-11-09 19:12:37',110680,0,1,NULL,NULL,'110680BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161328,'X-ray of left hand, 2 views','en',1,'2012-11-09 19:12:37',110681,0,1,NULL,NULL,'110681BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(161328,'Hand left 2 views (xray)','en',1,'2012-11-09 19:12:37',110682,0,1,NULL,NULL,'110682BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161329,'Lower leg left 2 views (xray)','en',1,'2012-11-09 19:13:00',110683,0,1,NULL,NULL,'110683BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161329,'Lower leg left 2 views (x-ray)','en',1,'2012-11-09 19:13:00',110684,0,1,NULL,NULL,'110684BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161329,'X-ray of left lower leg, 2 views','en',1,'2012-11-09 19:13:00',110685,0,1,NULL,NULL,'110685BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(161330,'Hand right 2 views (xray)','en',1,'2012-11-09 19:13:52',110686,0,1,NULL,NULL,'110686BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161330,'X-ray of right hand, 2 views','en',1,'2012-11-09 19:13:52',110687,0,1,NULL,NULL,'110687BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(161330,'Hand right 2 views (x-ray)','en',1,'2012-11-09 19:13:52',110688,0,1,NULL,NULL,'110688BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161331,'X-ray of bilateral hands, 2 views','en',1,'2012-11-09 19:16:04',110689,0,1,NULL,NULL,'110689BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(161331,'Hand bilateral 2 views (x-ray)','en',1,'2012-11-09 19:16:04',110690,0,1,NULL,NULL,'110690BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161331,'Hand bilateral 2 views (xray)','en',1,'2012-11-09 19:16:04',110691,0,1,NULL,NULL,'110691BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161332,'Hip left 2 views (x-ray)','en',1,'2012-11-09 19:17:46',110692,0,1,NULL,NULL,'110692BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161332,'X-ray of left hip, 2 views','en',1,'2012-11-09 19:17:46',110693,0,1,NULL,NULL,'110693BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(161332,'Hip left 2 views (xray)','en',1,'2012-11-09 19:17:46',110694,0,1,NULL,NULL,'110694BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161333,'X-ray of right hip, 2 views','en',1,'2012-11-09 19:18:51',110695,0,1,NULL,NULL,'110695BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(161333,'Hip right 2 views (xray)','en',1,'2012-11-09 19:18:51',110696,0,1,NULL,NULL,'110696BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161333,'Hip right 2 views (x-ray)','en',1,'2012-11-09 19:18:51',110697,0,1,NULL,NULL,'110697BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161334,'Hip bilateral 2 views (x-ray)','en',1,'2012-11-09 19:20:35',110698,0,1,NULL,NULL,'110698BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161334,'X-ray of bilateral hips, 2 views','en',1,'2012-11-09 19:20:35',110699,0,1,NULL,NULL,'110699BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(161334,'Hip bilateral 2 views (xray)','en',1,'2012-11-09 19:20:35',110700,0,1,NULL,NULL,'110700BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161335,'Spine thoracic and lumbar 2 views (xray)','en',1,'2012-11-09 19:20:42',110701,0,1,NULL,NULL,'110701BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161335,'Spine thoracic and lumbar 2 views (x-ray)','en',1,'2012-11-09 19:20:42',110702,0,1,NULL,NULL,'110702BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161335,'X-ray of thoracic and lumbar spine, 2 views','en',1,'2012-11-09 19:20:42',110703,0,1,NULL,NULL,'110703BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(161336,'Spine 1 view (x-ray)','en',1,'2012-11-09 19:24:19',110704,0,1,NULL,NULL,'110704BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161336,'X-ray of spine, 1 view','en',1,'2012-11-09 19:24:19',110705,0,1,NULL,NULL,'110705BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(161336,'Spine 1 view (xray)','en',1,'2012-11-09 19:24:19',110706,0,1,NULL,NULL,'110706BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161337,'Humerus left 2 views (xray)','en',1,'2012-11-09 19:31:27',110707,0,1,NULL,NULL,'110707BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161337,'Humerus left 2 views (x-ray)','en',1,'2012-11-09 19:31:27',110708,0,1,NULL,NULL,'110708BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161337,'X-ray of left upper arm, 2 views','en',1,'2012-11-09 19:31:27',110709,0,1,NULL,NULL,'110709BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(161337,'X-ray of left humerus, 2 views','en',1,'2012-11-09 19:31:27',110710,0,1,NULL,NULL,'110710BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161338,'Humerus right 2 views (x-ray)','en',1,'2012-11-09 19:32:23',110711,0,1,NULL,NULL,'110711BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161338,'X-ray of right upper arm, 2 views','en',1,'2012-11-09 19:32:23',110712,0,1,NULL,NULL,'110712BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(161338,'X-ray of right humerus, 2 views','en',1,'2012-11-09 19:32:23',110713,0,1,NULL,NULL,'110713BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161338,'Humerus right 2 views (xray)','en',1,'2012-11-09 19:32:23',110714,0,1,NULL,NULL,'110714BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161339,'Skull 4 views (xray)','en',1,'2012-11-09 19:32:44',110715,0,1,NULL,NULL,'110715BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161339,'Skull 4 views (x-ray)','en',1,'2012-11-09 19:32:44',110716,0,1,NULL,NULL,'110716BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161339,'X-ray of skull, 4 views','en',1,'2012-11-09 19:32:44',110717,0,1,NULL,NULL,'110717BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(161340,'Humerus bilateral 2 views (x-ray)','en',1,'2012-11-09 19:33:58',110718,0,1,NULL,NULL,'110718BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161340,'X-ray of bilateral upper arms, 2 views','en',1,'2012-11-09 19:33:58',110719,0,1,NULL,NULL,'110719BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(161340,'Humerus bilateral 2 views (xray)','en',1,'2012-11-09 19:33:58',110720,0,1,NULL,NULL,'110720BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161340,'X-ray of bilateral humerus, 2 views','en',1,'2012-11-09 19:33:58',110721,0,1,NULL,NULL,'110721BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161341,'Sinuses 3 views (x-ray)','en',1,'2012-11-09 19:35:31',110722,0,1,NULL,NULL,'110722BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161341,'Sinuses 3 views (xray)','en',1,'2012-11-09 19:35:31',110723,0,1,NULL,NULL,'110723BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161341,'X-ray of sinuses, 3 views','en',1,'2012-11-09 19:35:31',110724,0,1,NULL,NULL,'110724BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(161342,'X-ray of right shoulder, 2 views','en',1,'2012-11-09 20:26:22',110725,0,1,NULL,NULL,'110725BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(161342,'Shoulder right 2 views (xray)','en',1,'2012-11-09 20:26:22',110726,0,1,NULL,NULL,'110726BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161342,'Shoulder right 2 views (x-ray)','en',1,'2012-11-09 20:26:22',110727,0,1,NULL,NULL,'110727BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161343,'Shoulder left 2 views (xray)','en',1,'2012-11-09 20:31:30',110728,0,1,NULL,NULL,'110728BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161343,'Shoulder left 2 views (x-ray)','en',1,'2012-11-09 20:31:30',110729,0,1,NULL,NULL,'110729BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161343,'X-ray of left shoulder, 2 views','en',1,'2012-11-09 20:31:30',110730,0,1,NULL,NULL,'110730BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(161344,'X-ray of right ribs, 2 views','en',1,'2012-11-09 20:38:23',110731,0,1,NULL,NULL,'110731BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(161344,'Ribs right 2 views (x-ray)','en',1,'2012-11-09 20:38:23',110732,0,1,NULL,NULL,'110732BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161344,'Ribs right 2 views (xray)','en',1,'2012-11-09 20:38:23',110733,0,1,NULL,NULL,'110733BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161345,'Ribs left 2 views (xray)','en',1,'2012-11-09 20:42:14',110734,0,1,NULL,NULL,'110734BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161345,'Ribs left 2 views (x-ray)','en',1,'2012-11-09 20:42:14',110735,0,1,NULL,NULL,'110735BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161345,'X-ray of left ribs, 2 views','en',1,'2012-11-09 20:42:14',110736,0,1,NULL,NULL,'110736BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(161346,'Pelvis 1 view (x-ray)','en',1,'2012-11-09 20:45:03',110737,0,1,NULL,NULL,'110737BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161346,'Pelvis 1 view (xray)','en',1,'2012-11-09 20:45:03',110738,0,1,NULL,NULL,'110738BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161346,'X-ray of pelvis, 1 view','en',1,'2012-11-09 20:45:03',110739,0,1,NULL,NULL,'110739BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(161347,'Mandible Panorex (x-ray)','en',1,'2012-11-09 20:58:37',110740,0,1,NULL,'','110740BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161347,'X-ray of mandible (Panorex)','en',1,'2012-11-09 20:58:37',110741,0,1,NULL,NULL,'110741BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(161347,'Mandible Panorex (xray)','en',1,'2012-11-09 20:58:37',110742,0,1,NULL,'','110742BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161348,'Spine lumbar 2 or 3 views (xray)','en',1,'2012-11-09 21:03:01',110743,0,1,NULL,NULL,'110743BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161348,'X-ray of lumbar spine, 2 or 3 views','en',1,'2012-11-09 21:03:01',110744,0,1,NULL,NULL,'110744BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(161348,'Spine lumbar 2 or 3 views (x-ray)','en',1,'2012-11-09 21:03:01',110745,0,1,NULL,NULL,'110745BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161349,'Knee right 1 or 2 views (xray)','en',1,'2012-11-09 21:06:03',110746,0,1,NULL,'','110746BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161349,'Knee right 1 or 2 views (x-ray)','en',1,'2012-11-09 21:06:03',110747,0,1,NULL,'','110747BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161349,'X-ray of right knee, 1 or 2 views','en',1,'2012-11-09 21:06:03',110748,0,1,NULL,NULL,'110748BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(161350,'Knee left 1 or 2 views (x-ray)','en',1,'2012-11-09 21:08:49',110749,0,1,NULL,'','110749BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161350,'Knee left 1 or 2 views (xray)','en',1,'2012-11-09 21:08:49',110750,0,1,NULL,'','110750BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161350,'X-ray of left knee, 1 or 2 views','en',1,'2012-11-09 21:08:49',110751,0,1,NULL,NULL,'110751BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(161351,'X-ray of bilateral ribs, 2 views','en',1,'2012-11-11 22:48:55',110752,0,1,NULL,NULL,'110752BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(161351,'Bilateral ribs, 2 views (xray)','en',1,'2012-11-11 22:48:55',110753,0,1,NULL,'','110753BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161351,'Bilateral ribs, 2 views (x-ray)','en',1,'2012-11-11 22:48:55',110754,0,1,NULL,'','110754BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161352,'Bilateral knees, 2 views (xray)','en',1,'2012-11-11 22:56:00',110755,0,1,NULL,NULL,'110755BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161352,'X-ray of bilateral knees, 2 views','en',1,'2012-11-11 22:56:00',110756,0,1,NULL,NULL,'110756BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(161352,'Bilateral knees, 2 views (x-ray)','en',1,'2012-11-11 22:56:00',110757,0,1,NULL,NULL,'110757BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161353,'CT of bilateral lower extremities with IV contrast','en',1,'2012-11-12 16:40:57',110759,0,1,NULL,NULL,'110759BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(161353,'Computed tomography of bilateral lower extremities with IV contrast','en',1,'2012-11-12 16:40:57',110760,0,1,NULL,NULL,'110760BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(162285,'Abdomen and Pelvis with intravenous contrast (CT)','en',1,'2014-02-04 01:06:59',125356,0,1,NULL,'','125356BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(162285,'Computed tomography of abdomen and pelvis with intravenous contrast','en',1,'2014-02-04 01:06:59',125357,1,1,'2015-11-12 09:45:05','duplicate','125357BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(162285,'CT of abdomen and pelvis with IV contrast','en',1,'2014-02-05 02:14:33',125361,0,1,NULL,NULL,'125361BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','SHORT',0),(162286,'Cervical spine with intravenous contrast (CT)','en',1,'2014-02-04 01:13:59',125359,0,1,NULL,'','125359BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(162286,'Computed tomography of cervical spine with intravenous contrast','en',1,'2014-02-04 01:13:59',125360,0,1,NULL,NULL,'125360BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(162286,'CT of cervical spine with IV contrast','en',1,'2014-02-05 02:14:57',125364,0,1,NULL,NULL,'125364BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','SHORT',0),(162287,'CT of chest with IV contrast','en',1,'2014-02-05 02:25:15',125367,0,1,NULL,NULL,'125367BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','SHORT',0),(162287,'Chest with contrast IV (CT)','en',1,'2014-02-05 02:25:15',125368,0,1,NULL,'','125368BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(162287,'Computed tomography of chest with intravenous contrast','en',1,'2014-02-05 02:25:15',125370,0,1,NULL,NULL,'125370BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(162288,'Head with contrast IV (CT)','en',1,'2014-02-05 02:31:31',125372,0,1,NULL,'','125372BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(162288,'Computed tomography of head with intravenous contrast','en',1,'2014-02-05 02:31:31',125373,0,1,NULL,NULL,'125373BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(162289,'Computed tomography of lumbar spine with intravenous contrast','en',1,'2014-02-05 02:36:10',125376,0,1,NULL,NULL,'125376BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(162289,'CT of lumbar spine with IV contrast','en',1,'2014-02-05 02:36:10',125377,0,1,NULL,NULL,'125377BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','SHORT',0),(162289,'Lumbar spine with contrast IV (CT)','en',1,'2014-02-05 02:36:10',125379,0,1,NULL,'','125379BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(162290,'Computed tomography of right lower extremity with intravenous contrast','en',1,'2014-02-05 02:40:12',125381,0,1,NULL,NULL,'125381BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(162290,'Lower extremity - right with contrast IV (CT)','en',1,'2014-02-05 02:40:12',125382,0,1,NULL,'','125382BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(162291,'Lower extremity - left with contrast IV (CT)','en',1,'2014-02-05 02:46:11',125387,0,1,NULL,'','125387BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(162291,'Computed tomography of left lower extremity with intravenous contrast','en',1,'2014-02-05 02:46:11',125388,0,1,NULL,NULL,'125388BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(162292,'Computed tomography of facial bones and maxilla with intravenous contrast','en',1,'2014-02-05 04:29:22',125391,0,1,NULL,NULL,'125391BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(162292,'Facial bones and maxilla with contrast IV (CT)','en',1,'2014-02-05 04:29:22',125392,0,1,NULL,'','125392BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(162292,'CT of face with IV contrast','en',1,'2014-02-05 04:33:28',125398,0,1,NULL,NULL,'125398BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','SHORT',0),(162293,'Computed tomography of neck with intravenous contrast','en',1,'2014-02-05 04:32:44',125393,0,1,NULL,NULL,'125393BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(162293,'CT of neck with IV contrast','en',1,'2014-02-05 04:32:44',125394,0,1,NULL,NULL,'125394BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','SHORT',0),(162293,'Neck with contrast IV (CT)','en',1,'2014-02-05 04:32:44',125396,0,1,NULL,'','125396BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(162294,'Thoracic spine with contrast IV (CT)','en',1,'2014-02-05 04:36:02',125399,0,1,NULL,'','125399BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(162294,'CT of thoracic spine with IV contrast','en',1,'2014-02-05 04:36:02',125401,0,1,NULL,NULL,'125401BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','SHORT',0),(162294,'Computed tomography of thoracic spine with intravenous contrast','en',1,'2014-02-05 04:36:02',125402,0,1,NULL,NULL,'125402BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(162318,'Computed tomography of cervical spine with intravenous contrast','en',1,'2014-03-22 19:26:17',125482,0,1,NULL,NULL,'125482BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(163003,'Computed tomography of abdomen and pelvis with intravenous contrast','en',1,'2015-06-17 01:33:39',127442,0,1,NULL,NULL,'127442BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(163003,'Abdominal and pelvic CT scan with IV contrast','en',1,'2015-06-17 01:33:39',127443,0,1,NULL,'','127443BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(163003,'CT scan with IV contrast, abdomen and pelvis','en',1,'2015-06-17 01:33:39',127444,0,1,NULL,'','127444BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(163003,'Abdomen and pelvis with IV contrast (CT)','en',1,'2015-06-17 01:33:39',127445,0,1,NULL,'','127445BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(163003,'Abdomen and Pelvis with intravenous contrast (CT)','en',1,'2015-10-27 15:50:34',134370,0,1,NULL,'','134370BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(163003,'CT of abdomen and pelvis with IV contrast','en',1,'2015-10-27 15:51:19',134371,0,1,NULL,NULL,'134371BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','SHORT',0),(163004,'Computed tomography of abdomen with contrast','en',1,'2015-06-17 01:37:42',127446,0,1,NULL,NULL,'127446BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(163004,'Abdominal CT with contrast','en',1,'2015-06-17 01:37:42',127447,0,1,NULL,'','127447BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(163004,'CT scan with contrast, abdomen','en',1,'2015-06-17 01:37:42',127448,0,1,NULL,'','127448BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(163005,'Computed tomography of abdomen without contrast','en',1,'2015-06-17 01:40:59',127449,0,1,NULL,NULL,'127449BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(163030,'Magnetic resonance imaging of abdomen without contrast','en',1,'2015-06-26 20:01:50',127482,0,1,NULL,NULL,'127482BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(163030,'Abdominal MRI without contrast','en',1,'2015-06-26 20:02:19',127483,0,1,NULL,'','127483BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(163030,'MRI of abdomen without contrast','en',1,'2015-06-26 20:04:16',127487,0,1,NULL,NULL,'127487BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(163031,'Magnetic resonance imaging of abdomen with contrast','en',1,'2015-06-26 20:02:40',127484,0,1,NULL,NULL,'127484BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(163031,'Abdominal MRI with contrast','en',1,'2015-06-26 20:03:31',127485,0,1,NULL,'','127485BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(163031,'MRI of abdomen with contrast','en',1,'2015-06-26 20:03:59',127486,0,1,NULL,NULL,'127486BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(163037,'Chest and abdomen without IV contrast (CT)','en',1,'2015-07-01 02:42:36',127503,0,1,NULL,'','127503BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(163037,'Computed tomography of chest and abdomen without IV contrast','en',1,'2015-07-01 02:42:36',127505,0,1,NULL,NULL,'127505BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(163038,'Computed tomography of chest, abdomen and pelvis without IV contrast','en',1,'2015-07-01 02:46:06',127507,0,1,NULL,NULL,'127507BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(163038,'Chest, abdomen and pelvis without IV contrast (CT)','en',1,'2015-07-01 02:46:06',127508,0,1,NULL,'','127508BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(163039,'Computed tomography of chest and abdomen with IV contrast','en',1,'2015-07-01 02:50:44',127512,0,1,NULL,NULL,'127512BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(163039,'Chest and abdomen with contrast IV (CT)','en',1,'2015-07-01 02:50:44',127513,0,1,NULL,'','127513BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(163040,'Chest, abdomen and pelvis with contrast IV (CT)','en',1,'2015-07-01 03:03:07',127515,0,1,NULL,'','127515BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(163040,'Computed tomography of chest, abdomen and pelvis with IV contrast','en',1,'2015-07-01 03:03:07',127517,0,1,NULL,NULL,'127517BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(163041,'Transthoracic echocardiogram','en',1,'2015-07-01 03:06:45',127518,0,1,NULL,NULL,'127518BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(163041,'Transthoracic echocardiography','en',1,'2015-07-01 03:06:45',127520,0,1,NULL,'','127520BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0);
UNLOCK TABLES;

-- ----------------------------
--  Records of `concept_description`
-- ----------------------------
-- ATTENTION: deleting existing entries
LOCK TABLES `concept_description` WRITE;
DELETE FROM concept_description;
INSERT INTO concept_description (concept_description_id,concept_id,description,locale,creator,date_created,changed_by,date_changed,uuid)
VALUES (12,12,'An examination using irradiation for imaging the chest.','en',1,'2004-01-01 00:00:00',1,'2015-12-31 20:52:38','12FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'),(100,101,'An examination using irradiation for imaging the abdomen.','en',1,'2004-01-01 00:00:00',1,'2016-01-29 02:24:24','100FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'),(310,309,'An examination using irradiation for imaging the body, site unknown.','en',1,'2004-01-01 00:00:00',1,'2012-10-05 13:30:19','310FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'),(377,377,'An examination using irradiation for imaging the upper extremity.','en',1,'2004-01-01 00:00:00',1,'2016-01-29 02:26:54','377FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'),(380,380,'An examination using irradiation for imaging the lower extremity.','en',1,'2004-01-01 00:00:00',1,'2012-10-05 12:52:25','380FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'),(382,382,'An examination using irradiation for imaging the hand.','en',1,'2004-01-01 00:00:00',1,'2016-01-29 02:28:05','382FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'),(384,384,'An examination using irradiation for imaging the foot.','en',1,'2004-01-01 00:00:00',1,'2012-10-05 12:57:09','384FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'),(386,386,'An examination using irradiation for imaging the head and skull.','en',1,'2004-01-01 00:00:00',1,'2012-10-05 12:57:33','386FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'),(390,390,'An examination using irradiation for imaging the spine.','en',1,'2004-01-01 00:00:00',1,'2012-10-05 12:58:02','390FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'),(392,392,'An examination using irradiation for imaging the pelvis.','en',1,'2004-01-01 00:00:00',1,'2012-10-05 12:58:29','392FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'),(394,394,'An examination using irradiation for imaging the shoulder.','en',1,'2004-01-01 00:00:00',1,'2012-10-05 12:59:45','394FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'),(845,845,'Ultrasound examination of the abdomen.','en',1,'2004-05-05 00:00:00',1,'2012-11-03 18:27:39','845FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'),(15964,845,'Examen ultrasonido del abdomen','es',1,'2010-05-03 16:52:34',1,'2012-11-03 18:27:39','15964FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'),(848,846,'A sectional view of the head constructed by computed tomography.','en',1,'2004-05-05 00:00:00',1,'2012-11-08 23:54:29','848FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'),(854,852,'Ultrasound examination of the hepatic region-includes biliary tree','en',1,'2004-05-05 00:00:00',1,'2012-10-05 13:00:40','854FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'),(16204,159567,'Preliminary result of echocardiogram finding','en',1,'2010-09-06 18:58:37',1,'2015-12-31 20:57:47','16204FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'),(16248,159600,'A procedure in which radiographs of esophagus, stomach and duodenum are taken after ingestion of barium sulphate. Used to diagnose structural and motility disorders of the upper gi tract.','en',1,'2010-10-29 14:04:32',1,'2012-10-05 13:01:25','16248FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'),(16249,159601,'Radiographic imaging taken after swallowing barium sulphate. Used to diagnose structural or motility disorders of esophagus.','en',1,'2010-10-29 14:09:08',1,'2012-10-05 13:02:49','16249FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'),(16261,159618,'Sonogram test to diagnose pregnancy and fetal abnormality.','en',1,'2010-10-29 19:43:03',1,'2012-10-05 13:03:20','16261FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'),(16991,161161,'An imaging study which uses radioactive material to visualize bone abnormalities as it attempts to heal','en',1,'2012-08-29 20:40:19',1,'2012-10-05 13:39:11','16991FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'),(16992,161162,'An imaging study of abdomen that uses x-rays to compute tomography and produce cross-sectional images of it.','en',1,'2012-08-29 20:43:06',1,'2015-06-17 01:29:11','16992FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'),(16993,161163,'An imaging study of pelvic region that uses x-rays to compute tomography and produce cross-sectional images of it','en',1,'2012-08-29 20:45:10',1,'2012-11-08 23:23:36','16993FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'),(16995,161165,'An imaging study of chest that uses x-rays to compute tomography and produce cross-sectional images','en',1,'2012-08-29 21:31:31',1,'2012-10-05 13:40:20','16995FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'),(17507,163003,'An imaging study of abdomen and pelvis with intravenous contrast material that uses x-rays to compute tomography and produce cross-sectional images of it.','en',1,'2015-06-17 01:33:39',1,'2015-10-27 15:51:19','17507FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF');
UNLOCK TABLES;

-- ----------------------------
--  Radiology Module Settings and Global Properties
-- ----------------------------
-- Add location and set it as default
INSERT location (location_id,name,description,creator,date_created,uuid) VALUES (10,'Radiology Department','Radiology Department',1,'2016-06-01 10:12:02','9114ba07-8dab-4462-93f0-61e7f9165f86');
UPDATE global_property SET property_value='Radiology Department' WHERE property='default_location';

UPDATE global_property SET property_value='en, es' WHERE property='locale.allowed.list';

-- Set visithandler and EncounterType to VisitType mapping
UPDATE global_property SET property_value='org.openmrs.api.handler.ExistingOrNewVisitAssignmentHandler' WHERE property='visits.assignmentHandler';
UPDATE global_property SET property_value='19db8c0d-3520-48f2-babd-77f2d450e5c7:fe898a34-1ade-11e1-9c71-00248140a5eb' WHERE property='visits.encounterTypeToVisitTypeMapping';
UPDATE global_property SET property_value='true' WHERE property='visits.enabled';


-- Configure radiology orderables
UPDATE global_property SET property_value='8caa332c-efe4-4025-8b18-3398328e1323' WHERE property='radiology.radiologyConceptClasses';
COMMIT;

-- ----------------------------
--  Concept Class, Concepts, Concept Names used
--  for the Radiology Order order reason
-- ----------------------------
BEGIN;
-- concept class Diagnosis is already in OpenMRS Platform 2.0, if at one point
-- it is not uncomment the next line.
-- INSERT INTO `concept_class` VALUES ('4', 'Diagnosis', 'Conclusion drawn through findings', '1', '2004-02-02 00:00:00', '0', '1', null, null, '8d4918b0-c2cc-11de-8d13-0010c6dffd0f');

-- ----------------------------
--  Records of `concept`
-- ----------------------------
LOCK TABLES `concept` WRITE;
INSERT INTO `concept` VALUES (177,0,'','',NULL,4,4,0,1,'2004-01-01 00:00:00','',1,'2016-05-27 03:04:43',1,NULL,NULL,'177AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(178,0,'','',NULL,4,4,0,1,'2004-01-01 00:00:00','',1,'2013-10-31 13:55:30',1,NULL,NULL,'178AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(112639,0,NULL,NULL,NULL,4,4,0,1,'2007-11-03 00:00:00','',1,NULL,1,NULL,NULL,'112639AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(114311,0,NULL,NULL,NULL,4,4,0,1,'2007-11-03 00:00:00','',1,NULL,1,NULL,NULL,'114311AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(114996,0,NULL,NULL,NULL,4,4,0,1,'2007-11-03 00:00:00','',1,NULL,1,NULL,NULL,'114996AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(115542,0,NULL,NULL,NULL,4,4,0,1,'2007-11-03 00:00:00','',1,NULL,1,NULL,NULL,'115542AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(116707,0,NULL,NULL,NULL,4,4,0,1,'2007-11-03 00:00:00','',1,NULL,1,NULL,NULL,'116707AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(117983,0,NULL,NULL,NULL,4,4,0,1,'2007-11-03 00:00:00','',1,NULL,1,NULL,NULL,'117983AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(117989,0,NULL,NULL,NULL,4,4,0,1,'2007-11-03 00:00:00','',1,NULL,1,NULL,NULL,'117989AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(118003,0,NULL,NULL,NULL,4,4,0,1,'2007-11-03 00:00:00','',1,NULL,1,NULL,NULL,'118003AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(118016,0,NULL,NULL,NULL,4,4,0,1,'2007-11-03 00:00:00','',1,'2014-06-06 01:33:48',1,NULL,NULL,'118016AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(118022,0,NULL,NULL,NULL,4,4,0,1,'2007-11-03 00:00:00','',1,NULL,1,NULL,NULL,'118022AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(118039,0,NULL,NULL,NULL,4,4,0,1,'2007-11-03 00:00:00','',1,'2013-01-31 18:27:11',1,NULL,NULL,'118039AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(118044,0,NULL,NULL,NULL,4,4,0,1,'2007-11-03 00:00:00','',1,'2014-06-06 00:26:55',1,NULL,NULL,'118044AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(118055,0,NULL,NULL,NULL,4,4,0,1,'2007-11-03 00:00:00','',1,NULL,1,NULL,NULL,'118055AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(127968,0,NULL,NULL,NULL,4,4,0,1,'2007-11-03 00:00:00','',1,NULL,1,NULL,NULL,'127968AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(128446,0,NULL,NULL,NULL,4,4,0,1,'2007-11-03 00:00:00','',1,NULL,1,NULL,NULL,'128446AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(130696,0,NULL,NULL,NULL,4,4,0,1,'2007-11-03 00:00:00','',1,NULL,1,NULL,NULL,'130696AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(132257,0,NULL,NULL,NULL,4,4,0,1,'2007-11-03 00:00:00','',1,NULL,1,NULL,NULL,'132257AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(141655,0,NULL,NULL,NULL,4,4,0,1,'2007-11-03 00:00:00','',1,NULL,1,NULL,NULL,'141655AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(152512,0,NULL,NULL,NULL,4,4,0,1,'2007-10-14 07:41:45','',1,NULL,1,NULL,NULL,'152512AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(152662,0,NULL,NULL,NULL,4,4,0,1,'2007-10-14 07:41:45','',1,NULL,1,NULL,NULL,'152662AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(156410,0,NULL,NULL,NULL,4,4,0,1,'2010-04-23 20:10:26','',1,NULL,1,NULL,NULL,'156410AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA'),(161645,0,NULL,NULL,NULL,4,4,0,1,'2013-04-06 00:30:58','',1,'2013-04-10 02:43:59',1,NULL,NULL,'161645AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA');
UNLOCK TABLES;

-- ----------------------------
--  Records of `concept_name`
-- ----------------------------
-- WHERE:  class_id='4' and concept_id in ('114311','118055','178','118039','116707','118044','114996','115542','177','118016','117989','130696','118003','132257','156410','118022','117983','141655','127968','152662','152512','128446','161645','112639')
LOCK TABLES `concept_name` WRITE;
INSERT INTO concept_name (concept_id,name,locale,creator,date_created,concept_name_id,voided,voided_by,date_voided,void_reason,uuid,concept_name_type,locale_preferred)
VALUES (177,'Fracture','en',1,'2004-01-01 00:00:00',200,0,1,NULL,NULL,'200BBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(177,'fractura ósea','es',1,'2009-08-18 16:03:14',82860,1,1,'2016-04-26 00:00:00','','82860BBBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(177,'Bone Fracture','en',1,'2007-10-18 04:28:24',88773,0,1,NULL,'','88773BBBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(177,'Fracture NOS','en',1,'2005-02-16 11:37:47',92169,0,1,NULL,'','92169BBBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(178,'Fracture, colles','en',1,'2004-01-01 00:00:00',201,0,1,NULL,NULL,'201BBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(178,'fractura de Colles','es',1,'2009-08-18 16:03:14',61342,1,1,'2016-04-26 00:00:00','','61342BBBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(178,'Colles fracture','en',1,'2005-02-16 11:38:05',89792,0,1,NULL,'','89792BBBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(178,'Colles\' fracture','en',1,'2007-10-18 04:28:24',89793,0,1,NULL,'','89793BBBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(112639,'Subdural Hemorrhage Following Injury, Concussion','en',1,'2007-10-18 04:28:24',13305,0,1,NULL,NULL,'13305BBBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(112639,'hemorragia subdural traumática sin herida intracraneal abierta Y con concusión','es',1,'2009-08-18 16:03:14',85898,1,1,'2016-04-26 00:00:00',NULL,'85898BBBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(114311,'Pathologic Fracture','en',1,'2007-10-18 04:28:24',14904,0,1,NULL,NULL,'14904BBBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(114311,'fractura patológica','es',1,'2009-08-18 16:03:14',84849,0,1,NULL,NULL,'84849BBBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(114996,'Bimalleolar Fracture','en',1,'2007-10-18 04:28:24',15551,0,1,NULL,NULL,'15551BBBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(115542,'Multiple Fracture','en',1,'2007-10-18 04:28:24',16059,0,1,NULL,NULL,'16059BBBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(115542,'fracturas múltiples','es',1,'2009-08-18 16:03:14',84272,0,1,NULL,NULL,'84272BBBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(116707,'Intertrochanteric Fracture','en',1,'2007-10-18 04:28:24',17137,0,1,NULL,NULL,'17137BBBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(116707,'fractura intertrocantérea','es',1,'2009-08-18 16:03:14',83660,0,1,NULL,NULL,'83660BBBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(117983,'Fracture of Tibia','en',1,'2007-10-18 04:28:24',18342,0,1,NULL,NULL,'18342BBBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(117983,'fractura de la tibia','es',1,'2009-08-18 16:03:14',82894,0,1,NULL,NULL,'82894BBBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(117989,'Fracture of Skull','en',1,'2007-10-18 04:28:24',18348,0,1,NULL,NULL,'18348BBBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(117989,'fractura de cráneo','es',1,'2009-08-18 16:03:14',82891,0,1,NULL,NULL,'82891BBBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(118003,'Fracture of Rib','en',1,'2007-10-18 04:28:24',18361,0,1,NULL,NULL,'18361BBBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(118003,'fractura de costilla','es',1,'2009-08-18 16:03:14',82884,0,1,NULL,NULL,'82884BBBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(118016,'Patella fracture','en',1,'2007-10-18 04:28:24',18373,0,1,NULL,NULL,'18373BBBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(118016,'fractura de la rótula','es',1,'2009-08-18 16:03:14',82877,0,1,NULL,NULL,'82877BBBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(118016,'Patellar fracture','en',1,'2014-06-06 01:33:48',126001,0,1,NULL,NULL,'126001BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(118022,'Fracture of Hip','en',1,'2007-10-18 04:28:24',18378,0,1,NULL,NULL,'18378BBBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(118022,'fractura del cuello femoral','es',1,'2009-08-18 16:03:14',82874,0,1,NULL,NULL,'82874BBBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(118039,'Forearm Fracture','en',1,'2007-10-18 04:28:24',18394,0,1,NULL,NULL,'18394BBBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(118039,'fractura del antebrazo','es',1,'2009-08-18 16:03:14',82867,0,1,NULL,NULL,'82867BBBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(118039,'Fracture of forearm','en',1,'2013-01-31 18:27:11',111220,0,1,NULL,NULL,'111220BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(118044,'Fibula fracture','en',1,'2007-10-18 04:28:24',18399,0,1,NULL,NULL,'18399BBBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(118044,'fractura del peroné','es',1,'2009-08-18 16:03:14',82865,0,1,NULL,NULL,'82865BBBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(118044,'Isolated fibula fracture','en',1,'2014-06-06 00:26:55',125995,0,1,NULL,NULL,'125995BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0),(118055,'Bone Fracture','en',1,'2007-10-18 04:28:24',18410,0,1,NULL,NULL,'18410BBBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(118055,'fractura ósea','es',1,'2009-08-18 16:03:14',82861,0,1,NULL,NULL,'82861BBBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(127968,'Quervain\'s Fracture','en',1,'2007-10-18 04:28:24',27988,0,1,NULL,NULL,'27988BBBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(127968,'fractura de Quervain','es',1,'2009-08-18 16:03:14',75634,0,1,NULL,NULL,'75634BBBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(128446,'Progressing Stroke','en',1,'2007-10-18 04:28:24',28465,0,1,NULL,NULL,'28465BBBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(128446,'accidente cerebrovascular en curso','es',1,'2009-08-18 16:03:14',75178,0,1,NULL,NULL,'75178BBBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(130696,'Pathological Fracture - Forearm','en',1,'2007-10-18 04:28:24',30680,0,1,NULL,NULL,'30680BBBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(130696,'fractura patológica - antebrazo','es',1,'2009-08-18 16:03:14',73147,0,1,NULL,NULL,'73147BBBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(132257,'Open Fracture of Humerus','en',1,'2007-10-18 04:28:24',32191,0,1,NULL,NULL,'32191BBBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(132257,'fractura expuesta del húmero','es',1,'2009-08-18 16:03:14',72135,0,1,NULL,NULL,'72135BBBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(141655,'Dupuytren\'s Fracture of Radius','en',1,'2007-10-18 04:28:24',41398,0,1,NULL,NULL,'41398BBBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(141655,'fractura de Dupuytren del radio','es',1,'2009-08-18 16:03:14',63956,0,1,NULL,NULL,'63956BBBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(152512,'Personal History of Stroke','en',1,'2007-10-18 04:28:24',52074,0,1,NULL,NULL,'52074BBBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(152512,'antecedente de accidente cerebrovascular','es',1,'2009-08-18 16:03:14',54910,0,1,NULL,NULL,'54910BBBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(152662,'Fracture of Hand','en',1,'2007-10-18 04:28:24',52224,0,1,NULL,NULL,'52224BBBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(152662,'fractura de la mano','es',1,'2009-08-18 16:03:14',54958,0,1,NULL,NULL,'54958BBBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(156410,'fracture of thoracic vertebra','en',1,'2010-04-23 20:11:27',102638,0,1,NULL,NULL,'102638BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(161645,'Traumatic intracerebral hemorrhage','en',1,'2013-04-06 00:30:58',123639,0,1,NULL,NULL,'123639BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB','FULLY_SPECIFIED',1),(161645,'Traumatic stroke','en',1,'2013-04-06 00:30:58',123640,0,1,NULL,'','123640BBBBBBBBBBBBBBBBBBBBBBBBBBBBBB',NULL,0);
UNLOCK TABLES;

-- ----------------------------
--  Records of `concept_description`
-- ----------------------------
LOCK TABLES `concept_description` WRITE;
INSERT INTO concept_description (concept_description_id,concept_id,description,locale,creator,date_created,changed_by,date_changed,uuid)
VALUES (177,177,'A break, rupture, or crack, especially in bone or cartilage.','en',1,'2004-01-01 00:00:00',1,'2016-05-27 03:04:43','177FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'),(178,178,'Fracture of lower end of both ulna and radius.','en',1,'2004-01-01 00:00:00',1,'2013-10-31 13:55:30','178FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'),(3985,114311,'Fractures occurring as a result of disease of a bone or from some undiscoverable cause, and not due to trauma. (Dorland, 27th ed)','en',1,'2007-10-18 04:28:24',1,NULL,'3985FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'),(4385,115542,'Fractures in which the break in bone is not accompanied by an external wound.','en',1,'2007-10-18 04:28:24',1,NULL,'4385FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'),(4833,116707,'Fractures of the femur head, the femur neck, the trochanters, or the inter- or subtrochanteric region. Excludes fractures of the acetabulum and fractures of the femoral shaft below the subtrochanteric region. For the fractures of the femur neck the specific term FEMORAL NECK FRACTURES is available.','en',1,'2007-10-18 04:28:24',1,NULL,'4833FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'),(5269,117989,'Fractures of the skull which may result from penetrating or nonpenetrating head injuries or rarely BONE DISEASES (see also FRACTURES, SPONTANEOUS). Skull fractures may be classified by location (e.g., SKULL FRACTURE, BASILAR), radiographic appearance (e.g., linear), or based upon cranial integrity (e.g., SKULL FRACTURE, DEPRESSED).','en',1,'2007-10-18 04:28:24',1,NULL,'5269FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'),(5272,118022,'Fractures of the femur head, the femur neck, the trochanters, or the inter- or subtrochanteric region. Excludes fractures of the acetabulum and fractures of the femoral shaft below the subtrochanteric region. For the fractures of the femur neck the specific term FEMORAL NECK FRACTURES is available.','en',1,'2007-10-18 04:28:24',1,NULL,'5272FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'),(5275,118039,'Fractures of the larger bone of the forearm.','en',1,'2007-10-18 04:28:24',1,'2013-01-31 18:27:11','5275FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'),(5282,118055,'Fractures in which the break in bone is not accompanied by an external wound.','en',1,'2007-10-18 04:28:24',1,NULL,'5282FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'),(8620,128446,'Brief reversible episodes of focal, nonconvulsive ischemic dysfunction of the brain having a duration of less than 24 hours, and usually less than one hour, caused by transient thrombotic or embolic blood vessel occlusion or stenosis. Events may be classified by arterial distribution, temporal pattern, or etiology (e.g., embolic vs. thrombotic). (From Adams et al., Principles of Neurology, 6th ed, pp814-6)','en',1,'2007-10-18 04:28:24',1,NULL,'8620FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'),(9311,130696,'Fractures occurring as a result of disease of a bone or from some undiscoverable cause, and not due to trauma. (Dorland, 27th ed)','en',1,'2007-10-18 04:28:24',1,NULL,'9311FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF');
UNLOCK TABLES;
COMMIT;

-- ----------------------------
--  Radiology Module Patients
-- ----------------------------

BEGIN;
INSERT INTO `person` (person_id,gender,birthdate,creator,date_created,uuid) VALUES ('58722','F','1989-2-24','1','2002-3-28 09:00:00','7d791258-fc22-4020-ba97-c5a942d76412');
INSERT INTO `person_name` (person_name_id,person_id,given_name,family_name,creator,date_created,uuid) VALUES ('58722','58722','Elfrieda','Boyle','1','2002-3-28 09:00:00','fc9d570d-c5fb-4e25-8064-c7b6f01689bd');
INSERT INTO `patient` (patient_id,creator,date_created) VALUES ('58722','1','2002-3-28 09:00:00');
INSERT INTO patient_identifier (patient_id,identifier,identifier_type,location_id,creator,date_created,uuid) VALUES ('58722','58722','2','10','1','2002-3-28 09:00:00','e50f529d-4351-48ac-9e55-15de0d4cac9e');
COMMIT;

BEGIN;
INSERT INTO `person` (person_id,gender,birthdate,creator,date_created,uuid) VALUES ('6676','F','1967-11-17','1','1999-11-8 09:00:00','a9b14c06-6988-4062-aa5b-625ec6377309');
INSERT INTO `person_name` (person_name_id,person_id,given_name,family_name,creator,date_created,uuid) VALUES ('6676','6676','Sallie','Thompson','1','1999-11-8 09:00:00','38f0c8be-912b-4530-be0d-c55be7fd289f');
INSERT INTO `patient` (patient_id,creator,date_created) VALUES ('6676','1','1999-11-8 09:00:00');
INSERT INTO patient_identifier (patient_id,identifier,identifier_type,location_id,creator,date_created,uuid) VALUES ('6676','6676','2','10','1','1999-11-8 09:00:00','50977327-f5d5-4982-8908-f262858ab633');
COMMIT;

BEGIN;
INSERT INTO `person` (person_id,gender,birthdate,creator,date_created,uuid) VALUES ('54913','F','1953-12-24','1','1976-5-24 09:00:00','747755fe-5ada-429e-b28a-de547bd9fc81');
INSERT INTO `person_name` (person_name_id,person_id,given_name,family_name,creator,date_created,uuid) VALUES ('54913','54913','Laurianne','Sipes','1','1976-5-24 09:00:00','b296ed98-bd55-4630-9d35-3319e51e4702');
INSERT INTO `patient` (patient_id,creator,date_created) VALUES ('54913','1','1976-5-24 09:00:00');
INSERT INTO patient_identifier (patient_id,identifier,identifier_type,location_id,creator,date_created,uuid) VALUES ('54913','54913','2','10','1','1976-5-24 09:00:00','c79249b8-a1ba-4d13-9d07-7c53464217c1');
COMMIT;

BEGIN;
INSERT INTO `person` (person_id,gender,birthdate,creator,date_created,uuid) VALUES ('1019','M','1966-5-10','1','1986-11-13 09:00:00','9719843a-eb0f-4ac3-84aa-edc0389c89a4');
INSERT INTO `person_name` (person_name_id,person_id,given_name,family_name,creator,date_created,uuid) VALUES ('1019','1019','Lupe','Kohler','1','1986-11-13 09:00:00','f4e385dd-6390-490a-a910-3336a123f9bb');
INSERT INTO `patient` (patient_id,creator,date_created) VALUES ('1019','1','1986-11-13 09:00:00');
INSERT INTO patient_identifier (patient_id,identifier,identifier_type,location_id,creator,date_created,uuid) VALUES ('1019','1019','2','10','1','1986-11-13 09:00:00','ad2d8751-e51c-49de-b0fb-376893d2b465');
COMMIT;

BEGIN;
INSERT INTO `person` (person_id,gender,birthdate,creator,date_created,uuid) VALUES ('88400','M','1956-6-12','1','1983-3-31 09:00:00','12edf6d1-1898-4168-ad8a-4e4938aab474');
INSERT INTO `person_name` (person_name_id,person_id,given_name,family_name,creator,date_created,uuid) VALUES ('88400','88400','Carlos','Wilderman','1','1983-3-31 09:00:00','20c0c378-9b4b-42c3-8553-f3886d687ee2');
INSERT INTO `patient` (patient_id,creator,date_created) VALUES ('88400','1','1983-3-31 09:00:00');
INSERT INTO patient_identifier (patient_id,identifier,identifier_type,location_id,creator,date_created,uuid) VALUES ('88400','88400','2','10','1','1983-3-31 09:00:00','69f2db32-d033-4e31-9c60-008b265dae29');
COMMIT;

BEGIN;
INSERT INTO `person` (person_id,gender,birthdate,creator,date_created,uuid) VALUES ('2408','F','1982-2-24','1','1990-5-15 09:00:00','b8cacf42-e7ed-46f9-be2d-84b612ec8992');
INSERT INTO `person_name` (person_name_id,person_id,given_name,family_name,creator,date_created,uuid) VALUES ('2408','2408','Eldora','Hegmann','1','1990-5-15 09:00:00','cedb842c-dad2-453a-8ba9-25d2ce5e266e');
INSERT INTO `patient` (patient_id,creator,date_created) VALUES ('2408','1','1990-5-15 09:00:00');
INSERT INTO patient_identifier (patient_id,identifier,identifier_type,location_id,creator,date_created,uuid) VALUES ('2408','2408','2','10','1','1990-5-15 09:00:00','bd22003e-b175-41e0-858b-f4b2e91cc46c');
COMMIT;

BEGIN;
INSERT INTO `person` (person_id,gender,birthdate,creator,date_created,uuid) VALUES ('46495','F','1984-5-29','1','1994-8-15 09:00:00','b5078b51-85e9-4497-9939-80d23a3feb31');
INSERT INTO `person_name` (person_name_id,person_id,given_name,family_name,creator,date_created,uuid) VALUES ('46495','46495','Meaghan','McGlynn','1','1994-8-15 09:00:00','95208a63-393a-47a0-b1fc-298440931ec9');
INSERT INTO `patient` (patient_id,creator,date_created) VALUES ('46495','1','1994-8-15 09:00:00');
INSERT INTO patient_identifier (patient_id,identifier,identifier_type,location_id,creator,date_created,uuid) VALUES ('46495','46495','2','10','1','1994-8-15 09:00:00','e1d8bf27-6202-40d4-9bc4-8e8f2cb5123c');
COMMIT;

BEGIN;
INSERT INTO `person` (person_id,gender,birthdate,creator,date_created,uuid) VALUES ('48044','M','1947-11-15','1','1978-9-7 09:00:00','45b14ed5-31b3-4009-b949-a6152559c16e');
INSERT INTO `person_name` (person_name_id,person_id,given_name,family_name,creator,date_created,uuid) VALUES ('48044','48044','Neva','Hegmann','1','1978-9-7 09:00:00','9f2bd04c-0492-4ea6-95fa-b8d2d2bb43d1');
INSERT INTO `patient` (patient_id,creator,date_created) VALUES ('48044','1','1978-9-7 09:00:00');
INSERT INTO patient_identifier (patient_id,identifier,identifier_type,location_id,creator,date_created,uuid) VALUES ('48044','48044','2','10','1','1978-9-7 09:00:00','5b4cefda-769b-4636-bee3-faaf01376828');
COMMIT;

BEGIN;
INSERT INTO `person` (person_id,gender,birthdate,creator,date_created,uuid) VALUES ('66848','M','1961-6-4','1','1985-1-15 09:00:00','a8daf48b-7d36-4e6f-b7df-b86297c8a884');
INSERT INTO `person_name` (person_name_id,person_id,given_name,family_name,creator,date_created,uuid) VALUES ('66848','66848','Sydney','Powlowski','1','1985-1-15 09:00:00','6221f17a-ff1c-4082-9cc0-ea0411ec1e90');
INSERT INTO `patient` (patient_id,creator,date_created) VALUES ('66848','1','1985-1-15 09:00:00');
INSERT INTO patient_identifier (patient_id,identifier,identifier_type,location_id,creator,date_created,uuid) VALUES ('66848','66848','2','10','1','1985-1-15 09:00:00','3fec6c40-339a-48f2-b173-d9fea32cba27');
COMMIT;

BEGIN;
INSERT INTO `person` (person_id,gender,birthdate,creator,date_created,uuid) VALUES ('19895','M','1973-2-20','1','1978-7-25 09:00:00','1130f61b-0a9c-4381-bfe1-698144a1df1d');
INSERT INTO `person_name` (person_name_id,person_id,given_name,family_name,creator,date_created,uuid) VALUES ('19895','19895','Leo','Durgan','1','1978-7-25 09:00:00','d605fac8-19f5-410f-b4a4-6e89053f8daf');
INSERT INTO `patient` (patient_id,creator,date_created) VALUES ('19895','1','1978-7-25 09:00:00');
INSERT INTO patient_identifier (patient_id,identifier,identifier_type,location_id,creator,date_created,uuid) VALUES ('19895','19895','2','10','1','1978-7-25 09:00:00','2019b075-1b28-4519-ace6-5aa4e5768e9c');
COMMIT;

BEGIN;
INSERT INTO `person` (person_id,gender,birthdate,creator,date_created,uuid) VALUES ('31572','F','1952-9-29','1','2006-3-27 09:00:00','293dbf14-7a25-4866-b485-99884c121f8a');
INSERT INTO `person_name` (person_name_id,person_id,given_name,family_name,creator,date_created,uuid) VALUES ('31572','31572','Joyce','Batz','1','2006-3-27 09:00:00','fe528c99-0cba-48e6-b0ff-65e0cd0c19e0');
INSERT INTO `patient` (patient_id,creator,date_created) VALUES ('31572','1','2006-3-27 09:00:00');
INSERT INTO patient_identifier (patient_id,identifier,identifier_type,location_id,creator,date_created,uuid) VALUES ('31572','31572','2','10','1','2006-3-27 09:00:00','861a39e5-838b-4e61-a9d3-1eb5c6a2d333');
COMMIT;

BEGIN;
INSERT INTO `person` (person_id,gender,birthdate,creator,date_created,uuid) VALUES ('91538','F','1984-4-30','1','2012-10-6 09:00:00','ba51534c-afb8-4a8f-b146-2418e9a0755e');
INSERT INTO `person_name` (person_name_id,person_id,given_name,family_name,creator,date_created,uuid) VALUES ('91538','91538','Janie','Champlin','1','2012-10-6 09:00:00','ef4b1fbd-1830-4fe9-8625-080e7c73f291');
INSERT INTO `patient` (patient_id,creator,date_created) VALUES ('91538','1','2012-10-6 09:00:00');
INSERT INTO patient_identifier (patient_id,identifier,identifier_type,location_id,creator,date_created,uuid) VALUES ('91538','91538','2','10','1','2012-10-6 09:00:00','063a412f-41ff-4f39-91d8-1f2444d0076f');
COMMIT;

BEGIN;
INSERT INTO `person` (person_id,gender,birthdate,creator,date_created,uuid) VALUES ('42676','M','1952-9-24','1','2003-9-8 09:00:00','9338b59a-2006-4694-a08a-6d1ddbff7cf5');
INSERT INTO `person_name` (person_name_id,person_id,given_name,family_name,creator,date_created,uuid) VALUES ('42676','42676','Federico','Schoen','1','2003-9-8 09:00:00','fbeb6f5e-106e-4881-a139-ad7f0b4ef2bb');
INSERT INTO `patient` (patient_id,creator,date_created) VALUES ('42676','1','2003-9-8 09:00:00');
INSERT INTO patient_identifier (patient_id,identifier,identifier_type,location_id,creator,date_created,uuid) VALUES ('42676','42676','2','10','1','2003-9-8 09:00:00','6b6de371-9fa6-4824-8429-aeb9c196dd64');
COMMIT;

BEGIN;
INSERT INTO `person` (person_id,gender,birthdate,creator,date_created,uuid) VALUES ('53648','F','1978-4-21','1','2015-7-6 09:00:00','045a8f91-31a2-48c4-9ec6-094ef59f6e02');
INSERT INTO `person_name` (person_name_id,person_id,given_name,family_name,creator,date_created,uuid) VALUES ('53648','53648','Emely','Raynor','1','2015-7-6 09:00:00','6fa088ca-b766-42d7-b94a-ebaa71c128db');
INSERT INTO `patient` (patient_id,creator,date_created) VALUES ('53648','1','2015-7-6 09:00:00');
INSERT INTO patient_identifier (patient_id,identifier,identifier_type,location_id,creator,date_created,uuid) VALUES ('53648','53648','2','10','1','2015-7-6 09:00:00','23ab040e-4640-48bb-96ac-5b6cc94d1459');
COMMIT;

BEGIN;
INSERT INTO `person` (person_id,gender,birthdate,creator,date_created,uuid) VALUES ('81149','F','1985-2-1','1','2010-6-19 09:00:00','b9166879-9b6c-4ee6-b74a-79e17ba74ac6');
INSERT INTO `person_name` (person_name_id,person_id,given_name,family_name,creator,date_created,uuid) VALUES ('81149','81149','Kathryne','Goyette','1','2010-6-19 09:00:00','e6047839-70d2-4446-8a13-68cccd15f67a');
INSERT INTO `patient` (patient_id,creator,date_created) VALUES ('81149','1','2010-6-19 09:00:00');
INSERT INTO patient_identifier (patient_id,identifier,identifier_type,location_id,creator,date_created,uuid) VALUES ('81149','81149','2','10','1','2010-6-19 09:00:00','95454e2f-abc6-4b19-acec-177ab17ac94f');
COMMIT;

BEGIN;
INSERT INTO `person` (person_id,gender,birthdate,creator,date_created,uuid) VALUES ('46998','M','1952-10-15','1','1980-8-8 09:00:00','f3d3f632-4078-415a-89fb-2b28658a9eb7');
INSERT INTO `person_name` (person_name_id,person_id,given_name,family_name,creator,date_created,uuid) VALUES ('46998','46998','Arturo','Huel','1','1980-8-8 09:00:00','d539e725-42b7-4264-a59a-eba5c2c1b164');
INSERT INTO `patient` (patient_id,creator,date_created) VALUES ('46998','1','1980-8-8 09:00:00');
INSERT INTO patient_identifier (patient_id,identifier,identifier_type,location_id,creator,date_created,uuid) VALUES ('46998','46998','2','10','1','1980-8-8 09:00:00','14d4fd7e-fd7f-4905-92dd-33139fbfb17c');
COMMIT;

-- ----------------------------
--  Radiology Cases
-- ----------------------------

-- Joyce Batz
BEGIN;
INSERT INTO `encounter` VALUES (1,1,31572,10, NULL, '2016-07-22 09:04:28', 10, '2016-07-22 09:04:29', 0, NULL, NULL, NULL, NULL, NULL, NULL, '05b262d2-53c8-11e6-beb8-9e71128cae77');
INSERT INTO `orders` VALUES (1,4,161318,10,1,NULL,'2016-07-22 09:04:28',NULL,NULL,152662,'hurt her wrist due to falling from a chair',10,'2016-07-22 09:04:29',0,NULL,NULL,NULL,31572,'1','189e9efa-f040-410b-a581-9ead56294b57','ROUTINE','ORD-1',NULL,'NEW',NULL,1,NULL,NULL,NULL);
INSERT INTO `test_order` VALUES (1,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `radiology_order` VALUES (1);
INSERT INTO `radiology_study` VALUES (1,'2.25.246163855101151575419381898503875072573',1,'COMPLETED',10,'2016-07-22 09:04:29',NULL,NULL,'52cf158d-bd6b-4b60-b0ec-597dda94c372');
INSERT INTO `radiology_report` VALUES (1,1,'COMPLETED',14,'2016-07-22','<p>Left&nbsp;wrist is broken, needs cask.</p>',14,'2016-07-22 09:06:00','022d45cc-ca76-49c0-8572-3c75a6f85e76',false,NULL,NULL,NULL,NULL,NULL);
COMMIT;

-- Carlos Wilderman
BEGIN;
INSERT INTO `encounter` VALUES (2,1,88400,10, NULL, '2016-07-22 09:08:15', 10, '2016-07-22 09:08:15', 0, NULL, NULL, NULL, NULL, NULL, NULL, 'ae1b6b12-53c8-11e6-beb8-9e71128cae77');
INSERT INTO `orders` VALUES (2,4,846,11,2,NULL,'2016-07-22 09:08:15',NULL,NULL,152512,'felt dizzy',11,'2016-07-22 09:08:15',0,NULL,NULL,NULL,88400,'2','91a7e860-0988-4289-8c89-dd82e48b28ea','STAT','ORD-2',NULL,'NEW',NULL,1,NULL,NULL,NULL);
INSERT INTO `test_order` VALUES (2,NULL,NULL,'patient has a history of stroke',NULL,NULL);
INSERT INTO `radiology_order` VALUES (2);
INSERT INTO `radiology_study` VALUES (2,'2.25.116333151748508167695946541872914835248',2,'COMPLETED',11,'2016-07-22 09:08:15',NULL,NULL,'68ef1aa6-0b1e-4781-b820-152af617c4ab');
COMMIT;

-- Eldora Hegmann
BEGIN;
INSERT INTO `encounter` VALUES (3,1,2408,10, NULL, '2016-07-22 09:09:32', 10, '2016-07-22 09:09:39', 0, NULL, NULL, NULL, NULL, NULL, NULL, 'becffba8-53c8-11e6-beb8-9e71128cae77');
INSERT INTO `orders` VALUES (3,4,161313,10,3,NULL,'2016-07-22 09:09:32',NULL,'2016-07-22 09:09:39',118022,'patient has fallen on her hip',10,'2016-07-22 09:09:32',0,NULL,NULL,NULL,2408,'3','ae59af5f-ddfe-4a5a-9268-f69d5ee31b96','ROUTINE','ORD-3',NULL,'NEW',NULL,1,NULL,NULL,NULL);
INSERT INTO `test_order` VALUES (3,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `radiology_order` VALUES (3);
INSERT INTO `radiology_study` VALUES (3,'2.25.294106061613478038935820323947516223534',3,NULL,10,'2016-07-22 09:09:32',NULL,NULL,'f4657e09-7e64-48e0-8f73-1673d3788bad');
INSERT INTO `encounter` VALUES (4,1,2408,10, NULL, '2016-07-22 09:09:39', 10, '2016-07-22 09:09:39', 0, NULL, NULL, NULL, NULL, NULL, NULL, 'becfff9a-53c8-11e6-beb8-9e71128cae77');
INSERT INTO `orders` VALUES (4,4,161313,10,4,NULL,'2016-07-22 09:09:39','2016-07-22 09:09:39',NULL,NULL,'wrong procedure',10,'2016-07-22 09:09:40',0,NULL,NULL,NULL,2408,NULL,'28fca520-92aa-441d-8130-ebebd25328d9','ROUTINE','ORD-4',3,'DISCONTINUE',NULL,1,NULL,NULL,NULL);
INSERT INTO `encounter` VALUES (5,1,2408,10, NULL, '2016-07-22 09:10:45', 10, '2016-07-22 09:10:45', 0, NULL, NULL, NULL, NULL, NULL, NULL, 'bed000b2-53c8-11e6-beb8-9e71128cae77');
INSERT INTO `orders` VALUES (5,4,161333,10,5,NULL,'2016-07-22 09:10:45',NULL,NULL,118022,'patient has fallen on her hip',10,'2016-07-22 09:10:45',0,NULL,NULL,NULL,2408,'4','8b48c8aa-824e-4d4f-b6f7-3ff7668dc46f','ON_SCHEDULED_DATE','ORD-5',NULL,'NEW',NULL,1,'2016-07-25 14:50:00',NULL,NULL);
INSERT INTO `test_order` VALUES (5,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `radiology_order` VALUES (5);
INSERT INTO `radiology_study` VALUES (4,'2.25.61063892801549699180794005437107443005',5,NULL,10,'2016-07-22 09:10:45',NULL,NULL,'dbae9d3d-5032-4e33-b634-fa1273c1b589');
COMMIT;

-- Meaghan McGlynn
BEGIN;
INSERT INTO `encounter` VALUES (6,1,46495,10, NULL, '2016-07-22 09:12:14', 10, '2016-07-22 09:12:14', 0, NULL, NULL, NULL, NULL, NULL, NULL, 'becffe64-53c8-11e6-beb8-9e71128cae77');
INSERT INTO `orders` VALUES (6,4,161267,11,6,NULL,'2016-07-22 09:12:14',NULL,NULL,118055,'hurt ankle while rollerblading',11,'2016-07-22 09:12:14',0,NULL,NULL,NULL,46495,'5','f8e1e585-aae9-4822-8fda-bf30fdb25b16','ROUTINE','ORD-6',NULL,'NEW',NULL,1,NULL,NULL,NULL);
INSERT INTO `test_order` VALUES (6,NULL,NULL,'already had broken her ankle once',NULL,NULL);
INSERT INTO `radiology_order` VALUES (6);
INSERT INTO `radiology_study` VALUES (5,'2.25.178890805958223695051050558077248903949',6,'COMPLETED',11,'2016-07-22 09:12:14',NULL,NULL,'07485517-d0dc-4a79-8e22-fd7d9326d055');
INSERT INTO `radiology_report` VALUES (2,6,'DRAFT',14,NULL,'<p>Old&nbsp;fracture visible, new one close to it.</p>',14,'2016-07-22 09:14:00','b56781de-7dad-4e25-b377-ebba7f3bf30c',false,NULL,NULL,NULL,NULL,NULL);
COMMIT;

BEGIN;
INSERT INTO `encounter` VALUES (7,1,46495,10, NULL, '2016-07-22 09:14:28', 10, '2016-07-22 09:14:28', 0, NULL, NULL, NULL, NULL, NULL, NULL, 'da14a1fc-53c8-11e6-beb8-9e71128cae77');
INSERT INTO `orders` VALUES (7,4,161291,11,7,NULL,'2016-07-22 09:14:28',NULL,NULL,NULL,'abdominal pain',11,'2016-07-22 09:14:28',0,NULL,NULL,NULL,46495,'6','d9cc866a-5089-4187-bc72-96f1008a32bd','STAT','ORD-7',NULL,'NEW',NULL,1,NULL,NULL,NULL);
INSERT INTO `test_order` VALUES (7,NULL,NULL,'patient had several events of sharp abdominal pain for a few weeks',NULL,NULL);
INSERT INTO `radiology_order` VALUES (7);
INSERT INTO `radiology_study` VALUES (6,'2.25.195788626541510102066856864853818401349',7,'COMPLETED',11,'2016-07-22 09:14:28',NULL,NULL,'84feac4a-8954-4d0b-950b-e2b4ba1d4e9f');
INSERT INTO `radiology_report` VALUES (3,7,'DRAFT',14,NULL,'<p>Mhmm, not very firm with ultrasound. I\'ll ask Arden for help on this.</p>',14,'2016-07-22 09:16:00','d60338f6-27e0-4e69-bd91-fbc6e8f29660',true,'2016-07-22 09:16:00',14,'Not firm enough with ultrasound, need Arden to help out here.',NULL,NULL);
INSERT INTO `radiology_report` VALUES (4,7,'DRAFT',15,NULL,'<p>Ahh, clear to see that ...</p>',15,'2016-07-22 09:17:00','59ab79b5-15a0-40b2-a45e-57dba76bad25',false,NULL,NULL,NULL,NULL,NULL);
COMMIT;

-- always update these values, they assure that the assigned order or accession numbers continue after the ones from the test data
UPDATE global_property SET property_value='7' WHERE property='radiology.nextAccessionNumberSeed';
UPDATE global_property SET property_value='8' WHERE property='order.nextOrderNumberSeed';
COMMIT;

-- ----------------------------
--  Radiology Modalities
-- ----------------------------
BEGIN;
INSERT INTO `radiology_modality` (modality_id,modality_aetitle,modality_name,creator,date_created,uuid) VALUES (1,'CT01','Excelsior XT12342X',1,'2015-01-12 19:32:11','015f85fc-1316-45a3-848d-69ba192e64c4');
INSERT INTO `radiology_modality` (modality_id,modality_aetitle,modality_name,creator,date_created,uuid) VALUES (2,'CT02','Excelsior XT9000',1,'2015-12-22 17:19:53','5a4394b8-e2b7-4c5f-a360-523304bcce63');
INSERT INTO `radiology_modality` (modality_id,modality_aetitle,modality_name,creator,date_created,uuid) VALUES (3,'US01','Abracadabra ZT400',1,'2016-03-04 09:17:00','4bcb0c92-7e18-4f53-b956-275a4f687360');
INSERT INTO `radiology_modality` (modality_id,modality_aetitle,modality_name,creator,date_created,uuid,retired,retire_reason,retired_by,date_retired) VALUES (4,'US02','Abracadabra ZT400',1,'2016-03-04 09:18:35','66e4cd04-5ec3-4b0d-bfcd-20f9eb9a2d22',1,'out of order',1,'2016-08-02 11:27:00');
COMMIT;