INSERT INTO app_configuration (id, variable, value) VALUES (1, 'application_issue_tracker_url', 'http://gazelle.ihe.net/jira/');
INSERT INTO app_configuration (id, variable, value) VALUES (2, 'application_name', 'Order Simulator');
INSERT INTO app_configuration (id, variable, value) VALUES (3, 'application_release_notes_url', 'http://gazelle.ihe.net/jira/browse/OM#selectedTab=com.atlassian.jira.plugin.system.project%3Achangelog-panel');
INSERT INTO app_configuration (id, variable, value) VALUES (4, 'svs_repository_url', 'http://gazelle.ihe.net');
INSERT INTO app_configuration (id, variable, value) VALUES (6, 'xsl_location', 'http://sumo.irisa.fr/xsl/hl7Validation/resultStylesheet.xsl');
INSERT INTO app_configuration (id, variable, value) VALUES (7, 'url_EVCS_ws', 'http://sake.irisa.fr:8080/GazelleHL7v2Validator-GazelleHL7v2Validator-ejb/GazelleHL7v2ValidationWS?wsdl');
INSERT INTO app_configuration (id, variable, value) VALUES (8, 'timeout_for_receiving_messages', '30000');
INSERT INTO app_configuration (id, variable, value) VALUES (9, 'documentation_url', 'http://gazelle.ihe.net/content/order-manager-user-manual');
INSERT INTO app_configuration (id, variable, value) VALUES (10, 'application_url', 'http://localhost:8080/OrderManager');
INSERT INTO app_configuration (id, variable, value) VALUES (11, 'dicom_proxy_port', '10012');
INSERT INTO app_configuration (id, variable, value) VALUES (12, 'wlmscpfs_port', '12345');
INSERT INTO app_configuration (id, variable, value) VALUES (13, 'wlmscpfs_host', 'localhost');
INSERT INTO app_configuration (id, variable, value) VALUES (14, 'dcm_data_set_basedir', '/opt/worklists/exchange');
INSERT INTO app_configuration (id, variable, value) VALUES (15, 'number_of_segments_to_display', '40');
INSERT INTO app_configuration (id, variable, value) VALUES (16, 'worklists_basedir', '/opt/worklists');
INSERT INTO app_configuration (id, variable, value) VALUES (17, 'pam_encounter_generation_url', 'http://localhost:8080/PatientManager/rest/GenerateRandomData');
INSERT INTO app_configuration (id, variable, value) VALUES (18, 'dds_ws_endpoint', 'http://gazelle.ihe.net/DDSWS/DemographicDataServerBean?wsdl');
INSERT INTO app_configuration (id, variable, value) VALUES (19, 'time_zone', 'CET');
INSERT INTO app_configuration (id, variable, value) VALUES (20, 'dccheck_enabled', 'true');
INSERT INTO app_configuration (id, variable, value) VALUES (21, 'dccheck_endpoint', 'http://localhost:9080/DCCHECK');
INSERT INTO app_configuration (id, variable, value) VALUES (22, 'dccheck_xsl_location', 'http://localhost/~aberge/dccheckTransform.xsl');
INSERT INTO app_configuration (id, variable, value) VALUES (23, 'order_hierarchy_location', 'http://gazelle.ihe.net/examples/Bern2012-orderHierarchy.xml');
INSERT INTO app_configuration (id, variable, value) VALUES (24, 'dicom_proxy_ip', '127.0.0.1');
INSERT INTO app_configuration (id, variable, value) VALUES (25, 'gazelle_hl7v2_validator_url', 'http://gazelle.ihe.net/GazelleHL7v2Validator');
INSERT INTO app_configuration (id, variable, value) VALUES (26, 'eye_order_hierarchy_location', 'http://gazelle.ihe.net/examples/orderHierarchy-EYE2012.xml');
INSERT INTO app_configuration (id, variable, value) VALUES (27, 'application_works_without_cas', 'true');
INSERT INTO app_configuration (id, variable, value) VALUES (28, 'proxy_port_low_limit', '10001');
INSERT INTO app_configuration (id, variable, value) VALUES (29, 'analyzer_serial_number', 'to be uniquely defined');
INSERT INTO app_configuration (id, variable, value) VALUES (30, 'cas_url', 'https://gazelle.ihe.net');
INSERT INTO app_configuration (id, variable, value) VALUES (31, 'ip_login', 'false');
INSERT INTO app_configuration (id, variable, value) VALUES (32, 'ip_login_admin', '.*');
SELECT pg_catalog.setval('app_configuration_id_seq', 32, true);

-- transaction definition
INSERT INTO tf_transaction(id, description, keyword, name) VALUES (2, 'Lab Placer Order Management', 'LAB-1', 'LAB-1');
INSERT INTO tf_transaction(id, description, keyword, name) VALUES (3, 'Placer Order Management', 'RAD-2', 'RAD-2');
INSERT INTO tf_transaction(id, description, keyword, name) VALUES (5, 'Lab Filler Order Management', 'LAB-2', 'LAB-2');
INSERT INTO tf_transaction(id, description, keyword, name) VALUES (6, 'Filler Order Management', 'RAD-3', 'RAD-3');
INSERT INTO tf_transaction(id, description, keyword, name) VALUES (7, 'Appointment Notification', 'RAD-48', 'RAD-48');
INSERT INTO tf_transaction(id, description, keyword, name) VALUES (8, 'Order Results Management', 'LAB-3', 'LAB-3');
INSERT INTO tf_transaction(id, description, keyword, name) VALUES (9, 'Work Order Management', 'LAB-4', 'LAB-4');
INSERT INTO tf_transaction(id, description, keyword, name) VALUES (10, 'Test Result Management', 'LAB-5', 'LAB-5');
INSERT INTO tf_transaction(id, description, keyword, name) VALUES (11, 'Query for AWOS', 'LAB-27', 'LAB-27');
INSERT INTO tf_transaction(id, description, keyword, name) VALUES (12, 'AWOS Broadcast', 'LAB-28', 'LAB-28');
INSERT INTO tf_transaction(id, description, keyword, name) VALUES (13, 'AWOS Change status', 'LAB-29', 'LAB-29');
INSERT INTO tf_transaction(id, description, keyword, name) VALUES (14, 'Procedure Scheduled', 'RAD-4', 'RAD-4');
INSERT INTO tf_transaction(id, description, keyword, name) VALUES (15, 'Procedure Update', 'RAD-13', 'RAD-13');
INSERT INTO tf_transaction(id, description, keyword, name) VALUES (16, 'Patient Registration', 'RAD-1', 'RAD-1');
INSERT INTO tf_transaction(id, description, keyword, name) VALUES (17, 'Patient Update', 'RAD-12', 'RAD-12');
INSERT INTO tf_transaction(id, description, keyword, name) VALUES (18, 'Unknown transaction', 'UNKNOWN', 'UNKNOWN');
SELECT pg_catalog.setval('tf_transaction_id_seq', 18, true);

-- actor definition
INSERT INTO tf_actor(id, description, keyword, name, can_act_as_responder) VALUES (1, 'Order Placer', 'OP', 'Order Placer', true);
INSERT INTO tf_actor(id, description, keyword, name, can_act_as_responder) VALUES (2, 'Order Filler', 'OF', 'Order Filler', true);
INSERT INTO tf_actor(id, description, keyword, name, can_act_as_responder) VALUES (3, 'Automation Manager', 'AM', 'Automation Manager', true);
INSERT INTO tf_actor(id, description, keyword, name, can_act_as_responder) VALUES (4, 'Order Result Tracker', 'ORT', 'Order Result Tracker', true);
INSERT INTO tf_actor(id, description, keyword, name, can_act_as_responder) VALUES (5, 'Analyzer', 'ANALYZER', 'Analyzer', true);
INSERT INTO tf_actor(id, description, keyword, name, can_act_as_responder) VALUES (6, 'Analyzer Manager', 'ANALYZER_MGR', 'Analyzer Manager', true);
INSERT INTO tf_actor(id, description, keyword, name, can_act_as_responder) VALUES (7, 'Image/Report Manager', 'IM', 'Image/Report Manager', true);
INSERT INTO tf_actor(id, description, keyword, name, can_act_as_responder) VALUES (8, 'ADT Patient Registration', 'ADT', 'ADT Patient Registration', false);
INSERT INTO tf_actor(id, description, keyword, name, can_act_as_responder) VALUES (9, 'Aquisition Modality', 'MOD', 'Aquisition Modality', false);
INSERT INTO tf_actor(id, description, keyword, name, can_act_as_responder) VALUES (10, 'Unknown actor', 'UNKNOWN', 'UNKNOWN', false);
SELECT pg_catalog.setval('tf_actor_id_seq', 10 , true);

-- integration profile definition
INSERT INTO tf_integration_profile (id, description, keyword, name) VALUES (1, 'Laboratory Testing Workflow', 'LTW', 'Laboratory Testing Workflow');
INSERT INTO tf_integration_profile (id, description, keyword, name) VALUES (2, 'Scheduled Workflow', 'SWF', 'Scheduled Workflow');
INSERT INTO tf_integration_profile (id, description, keyword, name) VALUES (3, 'Mammography Acquisition Workflow', 'MAWF', 'Mammography Acquisition Workflow');
INSERT INTO tf_integration_profile (id, description, keyword, name) VALUES (4, 'Eyecare Basic Workflow', 'B-EYECARE', 'Eyecare Basic Workflow');
INSERT INTO tf_integration_profile (id, description, keyword, name) VALUES (6, 'Import Reconciliation Workflow', 'IRWF', 'Import Reconciliation Workflow');
INSERT INTO tf_integration_profile (id, description, keyword, name) VALUES (9, 'Stress Testing Workflow', 'STRESS', 'Stress Testing Workflow');
INSERT INTO tf_integration_profile (id, description, keyword, name) VALUES (10, 'Resting Electrocardiography Workflow', 'REWF', 'Resting Electrocardiography Workflow');
INSERT INTO tf_integration_profile (id, description, keyword, name) VALUES (11, 'Echocardiography Workflow', 'ECHO', 'Echocardiography Workflow');
INSERT INTO tf_integration_profile (id, description, keyword, name) VALUES (12, 'Cardiac Catheterization Workflow', 'CATH', 'Cardiac Catheterization Workflow');
SELECT pg_catalog.setval('tf_integration_profile_id_seq', 12, true);

-- domain definition
INSERT INTO tf_domain (id, description, keyword, name) VALUES (1, 'Radiology', 'RAD', 'Radiology');
INSERT INTO tf_domain (id, description, keyword, name) VALUES (2, 'Laboratory', 'LAB', 'Laboratory');
INSERT INTO tf_domain (id, description, keyword, name) VALUES (3, 'Eyecare', 'EYE', 'Eyecare');
INSERT INTO tf_domain (id, description, keyword, name) VALUES (4, 'Cardiology', 'CARD', 'Cardiology');
SELECT pg_catalog.setval('tf_domain_id_seq', 5, true);

-- link domain/integration profile
INSERT INTO tf_domain_integration_profiles (integration_profile_id, domain_id) VALUES (1, 2);
INSERT INTO tf_domain_integration_profiles (integration_profile_id, domain_id) VALUES (2, 1);
INSERT INTO tf_domain_integration_profiles (integration_profile_id, domain_id) VALUES (3, 1);
INSERT INTO tf_domain_integration_profiles (integration_profile_id, domain_id) VALUES (4, 3);
INSERT INTO tf_domain_integration_profiles (integration_profile_id, domain_id) VALUES (6, 1);
INSERT INTO tf_domain_integration_profiles (integration_profile_id, domain_id) VALUES (9, 4);
INSERT INTO tf_domain_integration_profiles (integration_profile_id, domain_id) VALUES (10, 4);
INSERT INTO tf_domain_integration_profiles (integration_profile_id, domain_id) VALUES (11, 4);
INSERT INTO tf_domain_integration_profiles (integration_profile_id, domain_id) VALUES (12, 4);

-- set there the charset used by your simulator
INSERT INTO hl7_charset (id, display_name, hl7_code, java_code) VALUES (1,  'ASCII','ASCII', 'US-ASCII' );                                
INSERT INTO hl7_charset (id, display_name, hl7_code, java_code) VALUES (2,  'ISO8859-1',	'8859/1'	,'ISO8859_1');
INSERT INTO hl7_charset (id, display_name, hl7_code, java_code) VALUES (3,  'ISO8859-2', 	'8859/2'	, 'ISO8859_2');
INSERT INTO hl7_charset (id, display_name, hl7_code, java_code) VALUES (4,  'ISO8859-3', 	'8859/3'	, 'ISO8859_3');    
INSERT INTO hl7_charset (id, display_name, hl7_code, java_code) VALUES (5,  'ISO8859-4', 	'8859/4'	, 'ISO8859_4');
INSERT INTO hl7_charset (id, display_name, hl7_code, java_code) VALUES (6,  'ISO8859-5', 	'8859/5'	, 'ISO8859_5');
INSERT INTO hl7_charset (id, display_name, hl7_code, java_code) VALUES (7,  'ISO8859-6', 	'8859/6'	, 'ISO8859_6');
INSERT INTO hl7_charset (id, display_name, hl7_code, java_code) VALUES (8,  'ISO8859-7', 	'8859/7'	, 'ISO8859_7');   
INSERT INTO hl7_charset (id, display_name, hl7_code, java_code) VALUES (9,  'ISO8859-8', 	'8859/8'	, 'ISO8859_8');
INSERT INTO hl7_charset (id, display_name, hl7_code, java_code) VALUES (10, 'ISO8859-9', 	'8859/9'	, 'ISO8859_9');
INSERT INTO hl7_charset (id, display_name, hl7_code, java_code) VALUES (11, 'Japanese (JIS X 0201)', 	'ISO IR14', 'JIS0201' );
INSERT INTO hl7_charset (id, display_name, hl7_code, java_code) VALUES (12, 'Japanese (JIS X 0208)', 	'ISO IR87', 'JIS0208' );            
INSERT INTO hl7_charset (id, display_name, hl7_code, java_code) VALUES (13, 'Japanese (JIS X 0212)', 	'ISO IR159',  'JIS0212');       
INSERT INTO hl7_charset (id, display_name, hl7_code, java_code) VALUES (14, 'Chinese', 	'GB 18030-2000'	, 'EUC_CN');
INSERT INTO hl7_charset (id, display_name, hl7_code, java_code) VALUES (15, 'Korean', 	'KS X 1001'	, 'EUC_KR');
INSERT INTO hl7_charset (id, display_name, hl7_code, java_code) VALUES (16, 'Taiwanese', 	'CNS 11643-1992', 'EUC_TW');
INSERT INTO hl7_charset (id, display_name, hl7_code, java_code) VALUES (17, 'Taiwanese (BIG 5)', 'BIG-5', 'Big5');
INSERT INTO hl7_charset (id, display_name, hl7_code, java_code) VALUES (19, 'UTF-8', 		'UNICODE UTF-8' , 'UTF8'    ); 
INSERT INTO hl7_charset (id, display_name, hl7_code, java_code) VALUES (20, 'UTF-16', 		'UNICODE UTF-16', 'UTF-16');
INSERT INTO hl7_charset (id, display_name, hl7_code, java_code) VALUES (21, 'UTF-32', 		'UNICODE UTF-32', 'UTF-32');
INSERT INTO hl7_charset (id, display_name, hl7_code, java_code) VALUES (22, 'ISO8859-15', '8859/15', 'ISO8859_15');

SELECT pg_catalog.setval('hl7_charset_id_seq', 22, true);

INSERT INTO affinity_domain (id, keyword, label_to_display, profile) VALUES (1, 'IHE_RAD', 'IHE Radiology', 'All');
INSERT INTO affinity_domain (id, keyword, label_to_display, profile) VALUES (3, 'IHE_EYE', 'IHE Eyecare', 'All');
INSERT INTO affinity_domain (id, keyword, label_to_display, profile) VALUES (5, 'IHE_LAB', 'IHE Laboratory', 'All');
SELECT pg_catalog.setval('affinity_domain_id_seq', 5, true);

INSERT INTO hl7_simulator_responder_configuration (id, name, listening_port, simulated_actor_id, transaction_id, affinity_domain_id, charset_id, accepted_message_type, accepted_trigger_event, server_bean_name, ip_address, receiving_application, receiving_facility, is_running) VALUES (1, 'IHE RAD Order Placer', 10020, 1, 3, 1, 19, '*', '*', 'orderPlacerServer', '127.0.0.1', 'OM_RAD_OP', 'IHE', false);
INSERT INTO hl7_simulator_responder_configuration (id, name, listening_port, simulated_actor_id, transaction_id, affinity_domain_id, charset_id, accepted_message_type, accepted_trigger_event, server_bean_name, ip_address, receiving_application, receiving_facility, is_running) VALUES (2, 'IHE RAD Order Filler', 10021, 2, 6, 1, 19, '*', '*', 'orderFillerServer', '127.0.0.1', 'OM_RAD_OF', 'IHE', false);
INSERT INTO hl7_simulator_responder_configuration (id, name, listening_port, simulated_actor_id, transaction_id, affinity_domain_id, charset_id, accepted_message_type, accepted_trigger_event, server_bean_name, ip_address, receiving_application, receiving_facility, is_running) VALUES (3, 'IHE LAB Order Filler', 10025, 2, 5, 5, 19, '*', '*', 'orderFillerServer', '127.0.0.1', 'OM_LAB_OF', 'IHE', false);
INSERT INTO hl7_simulator_responder_configuration (id, name, listening_port, simulated_actor_id, transaction_id, affinity_domain_id, charset_id, accepted_message_type, accepted_trigger_event, server_bean_name, ip_address, receiving_application, receiving_facility, is_running) VALUES (4, 'IHE LAB Order Placer', 10026, 1, 5, 5, 19, '*', '*', 'orderPlacerServer', '127.0.0.1', 'OM_LAB_OP', 'IHE', false);
INSERT INTO hl7_simulator_responder_configuration (id, name, listening_port, simulated_actor_id, transaction_id, affinity_domain_id, charset_id, accepted_message_type, accepted_trigger_event, server_bean_name, ip_address, receiving_application, receiving_facility, is_running) VALUES (5, 'IHE LAB Automation Manager', 10027, 3, 9, 5, 19, '*', '*', 'automationManagerServer', '127.0.0.1', 'OM_LAB_AM', 'IHE', false);
INSERT INTO hl7_simulator_responder_configuration (id, name, listening_port, simulated_actor_id, transaction_id, affinity_domain_id, charset_id, accepted_message_type, accepted_trigger_event, server_bean_name, ip_address, receiving_application, receiving_facility, is_running) VALUES (6, 'IHE LAB Order Result Tracker', 10028, 4, 8, 5, 19, '*', '*', 'orderResultTrackerServer', '127.0.0.1', 'OM_LAB_ORT', 'IHE', false);
INSERT INTO hl7_simulator_responder_configuration (id, name, listening_port, simulated_actor_id, transaction_id, affinity_domain_id, charset_id, accepted_message_type, accepted_trigger_event, server_bean_name, ip_address, receiving_application, receiving_facility, is_running) VALUES (7, 'IHE LAB Analyzer', 10022, 5, 12, 5, 19, '*', '*', 'analyzerServer', '127.0.0.1', 'OM_LAB_ANALYZER', 'IHE', false);
INSERT INTO hl7_simulator_responder_configuration (id, name, listening_port, simulated_actor_id, transaction_id, affinity_domain_id, charset_id, accepted_message_type, accepted_trigger_event, server_bean_name, ip_address, receiving_application, receiving_facility, is_running) VALUES (8, 'IHE LAB Analyzer Manager', 10029, 6, null, 5, 19, '*', '*', 'analyzerManagerServer', '127.0.0.1', 'OM_LAB_ANALYZER_MGR', 'IHE', false);
INSERT INTO hl7_simulator_responder_configuration (id, name, listening_port, simulated_actor_id, transaction_id, affinity_domain_id, charset_id, accepted_message_type, accepted_trigger_event, server_bean_name, ip_address, receiving_application, receiving_facility, is_running) VALUES (9, 'IHE RAD Image/Report Manager', 10030, 7, null, 1, 19, 'ORM', 'O01', 'imageReportManagerServer', '127.0.0.1', 'OM_RAD_IM', 'IHE', false);
INSERT INTO hl7_simulator_responder_configuration (id, name, listening_port, simulated_actor_id, transaction_id, affinity_domain_id, charset_id, accepted_message_type, accepted_trigger_event, server_bean_name, ip_address, receiving_application, receiving_facility, is_running) VALUES (10, 'IHE EYE Order Placer', 10031, 1, 3, 3, 19, '*', '*', 'orderPlacerServer', '127.0.0.1', 'OM_EYE_OP', 'IHE', false);
INSERT INTO hl7_simulator_responder_configuration (id, name, listening_port, simulated_actor_id, transaction_id, affinity_domain_id, charset_id, accepted_message_type, accepted_trigger_event, server_bean_name, ip_address, receiving_application, receiving_facility, is_running) VALUES (11, 'IHE EYE Order Filler', 10032, 2, 6, 3, 19, '*', '*', 'orderFillerServer', '127.0.0.1', 'OM_EYE_OF', 'IHE', false);
INSERT INTO hl7_simulator_responder_configuration (id, name, listening_port, simulated_actor_id, transaction_id, affinity_domain_id, charset_id, accepted_message_type, accepted_trigger_event, server_bean_name, ip_address, receiving_application, receiving_facility, is_running) VALUES (12, 'IHE EYE Image/Report Manager', 10033, 7, null, 3, 19, 'ORM', 'O01', 'imageReportManagerServer', '127.0.0.1', 'OM_EYE_IM', 'IHE', false);

SELECT pg_catalog.setval('hl7_simulator_responder_configuration_id_seq', 12, true);
--
-- Data for Name: sys_config; Type: TABLE DATA; Schema: public; Owner: gazelle
--

INSERT INTO sys_config (id, active, application, facility, ip_address, last_modified, name, port, shared, username, actor_id, charset_id) VALUES (1, true, 'OM_RAD_OF', 'IHE', '127.0.0.1', 'now', 'Radiology Order Filler', 10021, true, NULL, 2, 19);
INSERT INTO sys_config (id, active, application, facility, ip_address, last_modified, name, port, shared, username, actor_id,  charset_id) VALUES (2, true, 'OM_RAD_OP', 'IHE', '127.0.0.1', 'now', 'Radiology Order Placer', 10020, true, NULL, 1, 19);
INSERT INTO sys_config (id, active, application, facility, ip_address, last_modified, name, port, shared, username, actor_id,  charset_id) VALUES (3, true, 'OM_LAB_OF', 'IHE', '127.0.0.1', 'now', 'Laboratory Order Filler', 10025, true, NULL, 2, 19);
INSERT INTO sys_config (id, active, application, facility, ip_address, last_modified, name, port, shared, username, actor_id,  charset_id) VALUES (4, true, 'OM_LAB_OP', 'IHE', '127.0.0.1', 'now', 'Laboratory Order Placer', 10026, true, NULL, 1, 19);
INSERT INTO sys_config (id, active, application, facility, ip_address, last_modified, name, port, shared, username, actor_id,  charset_id) VALUES (5, true, 'OM_LAB_AM', 'IHE', '127.0.0.1', 'now', 'Laboratory Automation Manager', 10027, true, NULL, 3, 19);
INSERT INTO sys_config (id, active, application, facility, ip_address, last_modified, name, port, shared, username, actor_id,  charset_id) VALUES (6, true, 'OM_LAB_ORT', 'IHE', '127.0.0.1', 'now', 'Laboratory Order Result Tracker', 10028, true, NULL, 4, 19);
INSERT INTO sys_config (id, active, application, facility, ip_address, last_modified, name, port, shared, username, actor_id, charset_id) VALUES (7, true, 'OM_RAD_IM', 'IHE', '127.0.0.1', 'now', 'Radiology Image/Report Manager', 10030, true, NULL, 7, 19);
INSERT INTO sys_config (id, active, application, facility, ip_address, last_modified, name, port, shared, username, actor_id,  charset_id) VALUES (8, true, 'OM_EYE_OF', 'IHE', '127.0.0.1', 'now', 'Eye care Order Filler', 10032, true, NULL, 2, 19);
INSERT INTO sys_config (id, active, application, facility, ip_address, last_modified, name, port, shared, username, actor_id,  charset_id) VALUES (9, true, 'OM_EYE_OP', 'IHE', '127.0.0.1', 'now', 'Eye care Order Placer', 10031, true, NULL, 1, 19);
INSERT INTO sys_config (id, active, application, facility, ip_address, last_modified, name, port, shared, username, actor_id,  charset_id) VALUES (10, true, 'OM_EYE_IM', 'IHE', '127.0.0.1', 'now', 'Eye care Image/Report Manager', 10033, true, NULL, 7, 19);
INSERT INTO sys_config (id, active, application, facility, ip_address, last_modified, name, port, shared, username, actor_id,  charset_id) VALUES (11, true, 'OM_LAB_ANALYZER', 'IHE', '127.0.0.1', 'now', 'Laboratory Analyzer', 10022, true, NULL, 5, 19);
INSERT INTO sys_config (id, active, application, facility, ip_address, last_modified, name, port, shared, username, actor_id,  charset_id) VALUES (12, true, 'OM_LAB_ANALYZER_MGR', 'IHE', '127.0.0.1', 'now', 'Laboratory Analyzer Manager', 10029, true, NULL, 6, 19);

SELECT pg_catalog.setval('sys_config_id_seq', 12, true);

INSERT INTO om_number_generator (id, namespace_id, universal_id, next_entity_identifier, universal_id_type, actor_id) VALUES (1, 'IHE_OM_OP', '1.3.6.1.4.1.12559.11.1.2.2.4.2', 1, 'ISO', 1);
INSERT INTO om_number_generator (id, namespace_id, universal_id, next_entity_identifier, universal_id_type, actor_id) VALUES (2, 'IHE_OM_OF', '1.3.6.1.4.1.12559.11.1.2.2.4.3', 1, 'ISO', 2);
INSERT INTO om_number_generator (id, namespace_id, universal_id, next_entity_identifier, universal_id_type, actor_id) VALUES (3, 'IHE_OM_AM', '1.3.6.1.4.1.12559.11.1.2.2.4.6', 1, 'ISO', 3);
INSERT INTO om_number_generator (id, namespace_id, universal_id, next_entity_identifier, universal_id_type, actor_id) VALUES (4, 'IHE_OM_ANALYZER_MGR', '1.3.6.1.4.1.12559.11.1.2.2.4.4', 1, 'ISO', 6);
INSERT INTO om_number_generator (id, namespace_id, universal_id, next_entity_identifier, universal_id_type, actor_id) VALUES (5, 'IHE_OM_ANALYZER', '1.3.6.1.4.1.12559.11.1.2.2.4.5', 1, 'ISO', 4);
SELECT pg_catalog.setval('om_number_generator_id_seq', 5, true);

INSERT INTO om_value_set (id, value_set_name, value_set_oid, usage, value_set_keyword) VALUES (1,'Patient class - HL7 Table 0004','1.3.6.1.4.1.21367.101.104','PV1-2','patientClass');         
INSERT INTO om_value_set (id, value_set_name, value_set_oid, usage, value_set_keyword) VALUES (2,'Physician ID - HL7 Table 0001','1.3.6.1.4.1.21367.101.110','HL7: PV1-8 ORC-10 ORC-11 ORC-12 OBR-16 OBR-28 OBR-34 OBX-16 -- DICOM: (0032,1032)  (0008,0090)  (0040,2008) (0040, 0006)','doctor');
INSERT INTO om_value_set (id, value_set_name, value_set_oid, usage, value_set_keyword) VALUES (3,'Priority','1.3.6.1.4.1.21367.101.116','ORC-7-6 (RAD/EYE), OBR-27-6 (RAD/EYE), TQ1-9 (LAB)','quantityTiming');
INSERT INTO om_value_set (id, value_set_name, value_set_oid, usage, value_set_keyword) VALUES (4,'Entering Organization - HL7 Table IHE005','1.3.6.1.4.1.21367.101.117','HL7: ORC-17 OBX-23 -- DICOM: (0040,2009)','enteringOrganization');
INSERT INTO om_value_set (id, value_set_name, value_set_oid, usage, value_set_keyword) VALUES (5,'Ordering Codes - Universal Service ID (RAD) ','1.3.6.1.4.1.21367.101.118','OBR-4','radUniversalServiceId');
INSERT INTO om_value_set (id, value_set_name, value_set_oid, usage, value_set_keyword) VALUES (6,'Danger Code - HL7 table IHE007','1.3.6.1.4.1.21367.101.119','HL7: OBR-12 -- DICOM: (0038,0500)','danger');
INSERT INTO om_value_set (id, value_set_name, value_set_oid, usage, value_set_keyword) VALUES (7,'Transportation mode code - HL7 Table 0124','1.3.6.1.4.1.21367.101.120','OBR-30','transportationMode');
INSERT INTO om_value_set (id, value_set_name, value_set_oid, usage, value_set_keyword) VALUES (8,'Transport arranged - HL7 Table 0224','1.3.6.1.4.1.21367.101.121','HL7: OBR-41 -- DICOM: (0040,1004)','transportArranged');
INSERT INTO om_value_set (id, value_set_name, value_set_oid, usage, value_set_keyword) VALUES (9,'Ordering Codes - Universal Service ID (CARD) ','1.3.6.1.4.1.21367.101.118','OBR-4','cardUniversalServiceId');
INSERT INTO om_value_set (id, value_set_name, value_set_oid, usage, value_set_keyword) VALUES (10,'Ordering Codes - Universal Service ID (EYE) ','1.3.6.1.4.1.12559.11.4.2.26','OBR-4','eyeUniversalServiceId');
INSERT INTO om_value_set (id, value_set_name, value_set_oid, usage, value_set_keyword) VALUES (11,'patUniversalServiceId','1.3.6.1.4.1.21367.101.118','PAT domain is not yet implemented','patUniversalServiceId');
INSERT INTO om_value_set (id, value_set_name, value_set_oid, usage, value_set_keyword) VALUES (12,'Ordering Codes - Universal Service ID (LAB) ','1.3.6.1.4.1.12559.11.4.2.15','OBR-4','labUniversalServiceId');
INSERT INTO om_value_set (id, value_set_name, value_set_oid, usage, value_set_keyword) VALUES (13,'Specimen Source/Specimen type','2.16.840.1.114222.4.11.3020','OBR-15 SPM-4','specimenSource');
INSERT INTO om_value_set (id, value_set_name, value_set_oid, usage, value_set_keyword) VALUES (14,'Acquisition Modality Codes','1.3.6.1.4.1.21367.101.9','HL7: OBR-24 (RAD/EYE) -- DICOM: (0008,0060) ','modality');
INSERT INTO om_value_set (id, value_set_name, value_set_oid, usage, value_set_keyword) VALUES (15,'Specimen Source/Specimen type','2.16.840.1.114222.4.11.3020','OBR-15 SPM-4','specimenType');
INSERT INTO om_value_set (id, value_set_name, value_set_oid, usage, value_set_keyword) VALUES (16,'Specimen Collection Method - HL7 Table 0488','2.16.840.1.113883.12.488','SPM-7','collectionMethod');
INSERT INTO om_value_set (id, value_set_name, value_set_oid, usage, value_set_keyword) VALUES (17,'Specimen Role - HL7 Table 0369','1.3.6.1.4.1.12559.11.4.2.14','SPM-11','specimenRole');
INSERT INTO om_value_set (id, value_set_name, value_set_oid, usage, value_set_keyword) VALUES (18,'Risk Code - HL7 Table 0489','2.16.840.1.113883.12.489','SPM-16','riskCode');
INSERT INTO om_value_set (id, value_set_name, value_set_oid, usage, value_set_keyword) VALUES (19,'Diagnostic Section Service ID (subset for LAB)','1.3.6.1.4.1.12559.11.4.2.16','OBR-24','diagnosticService');
INSERT INTO om_value_set (id, value_set_name, value_set_oid, usage, value_set_keyword) VALUES (20,'Value type - HL7 Table 0125','2.16.840.1.113883.12.125','OBX-2','valueType');
INSERT INTO om_value_set (id, value_set_name, value_set_oid, usage, value_set_keyword) VALUES (21,'Abnormal flags - HL7 Table 0078','2.16.840.1.113883.12.78','OBX-8','abnormalFlag');
INSERT INTO om_value_set (id, value_set_name, value_set_oid, usage, value_set_keyword) VALUES (22,'Observation result status code interpretation - HL7 Table 0125','2.16.840.1.113883.12.85','OBX-11','resultStatus');
INSERT INTO om_value_set (id, value_set_name, value_set_oid, usage, value_set_keyword) VALUES (23,'Source of comment (defined in LAB TF)','1.3.6.1.4.1.12559.11.4.2.19','NTE-2','sourceOfComment');
INSERT INTO om_value_set (id, value_set_name, value_set_oid, usage, value_set_keyword) VALUES (24,'Comment Type (defined in LAB TF)','1.3.6.1.4.1.12559.11.4.2.20','NTE-4','commentType');
INSERT INTO om_value_set (id, value_set_name, value_set_oid, usage, value_set_keyword) VALUES (25,'access check','1.3.6.1.4.1.12559.11.4.2.20','OBX-13','accessCheck');
INSERT INTO om_value_set (id, value_set_name, value_set_oid, usage, value_set_keyword) VALUES (26,'Observation identifier (related to order) ','1.3.6.1.4.1.12559.11.4.2.21','OBX-3 (in OBX segment related to an OBR segment) ','orderObservationIdentifier');
INSERT INTO om_value_set (id, value_set_name, value_set_oid, usage, value_set_keyword) VALUES (27,'Observation identifier (related to specimen) ','1.3.6.1.4.1.12559.11.4.2.22','OBX-3 (in OBX segment related to a SPM segment)','specimenObservationIdentifier');
INSERT INTO om_value_set (id, value_set_name, value_set_oid, usage, value_set_keyword) VALUES (28,'Result status (sub set of HL7 Table 0123)','1.3.6.1.4.1.12559.11.4.2.23','OBR-25','orderResultStatus');
INSERT INTO om_value_set (id, value_set_name, value_set_oid, usage, value_set_keyword) VALUES (29,'Order status (sub set of HL7 Table 0038)','1.3.6.1.4.1.12559.11.4.2.24','ORC-5','orderStatus');
INSERT INTO om_value_set (id, value_set_name, value_set_oid, usage, value_set_keyword) VALUES (30,'UCUM - Unified Code for Units of Measure','2.16.840.1.114222.4.11.838','OBX','units');
SELECT pg_catalog.setval('om_value_set_id_seq', 30, true);

INSERT INTO validation_parameters (id, message_type, profile_oid, actor_id, transaction_id) VALUES (1, 'ORM^O01^ORM_O01 (NW)', '1.3.6.1.4.12559.11.1.1.103', 1, 3);
INSERT INTO validation_parameters (id, message_type, profile_oid, actor_id, transaction_id) VALUES (2, 'ORM^O01^ORM_O01 (CA)', '1.3.6.1.4.12559.11.1.1.104', 1, 3);
INSERT INTO validation_parameters (id, message_type, profile_oid, actor_id, transaction_id) VALUES (3, 'ORR^O02^ORR_O02', '1.3.6.1.4.12559.11.1.1.105', 1, 6);
INSERT INTO validation_parameters (id, message_type, profile_oid, actor_id, transaction_id) VALUES (4, 'ORM^O01^ORM_O01 (SN)', '1.3.6.1.4.12559.11.1.1.9', 2, 6);
INSERT INTO validation_parameters (id, message_type, profile_oid, actor_id, transaction_id) VALUES (5, 'ORM^O01^ORM_O01 (SC)', '1.3.6.1.4.12559.11.1.1.8', 2, 6);
INSERT INTO validation_parameters (id, message_type, profile_oid, actor_id, transaction_id) VALUES (6, 'ORM^O01^ORM_O01 (OC)', '1.3.6.1.4.12559.11.1.1.7', 2, 6);
INSERT INTO validation_parameters (id, message_type, profile_oid, actor_id, transaction_id) VALUES (7, 'ACK^ALL^ACK', '1.3.6.1.4.12559.11.1.1.21', 2, 3);
INSERT INTO validation_parameters (id, message_type, profile_oid, actor_id, transaction_id) VALUES (8, 'ACK^ALL^ACK', '1.3.6.1.4.12559.11.1.1.21', 1, 6);
INSERT INTO validation_parameters (id, message_type, profile_oid, actor_id, transaction_id) VALUES (9, 'OML^O21^OML_O21', '1.3.6.1.4.12559.11.1.1.106', 1, 2);
INSERT INTO validation_parameters (id, message_type, profile_oid, actor_id, transaction_id) VALUES (10, 'OML^O33^OML_O33', '1.3.6.1.4.12559.11.1.1.107', 1, 2);
INSERT INTO validation_parameters (id, message_type, profile_oid, actor_id, transaction_id) VALUES (11, 'OML^O35^OML_O35', '1.3.6.1.4.12559.11.1.1.108', 1, 2);
INSERT INTO validation_parameters (id, message_type, profile_oid, actor_id, transaction_id) VALUES (12, 'OML^O21^OML_O21', '1.3.6.1.4.12559.11.1.1.15', 2, 5);
INSERT INTO validation_parameters (id, message_type, profile_oid, actor_id, transaction_id) VALUES (13, 'OML^O33^OML_O33', '1.3.6.1.4.12559.11.1.1.16', 2, 5);
INSERT INTO validation_parameters (id, message_type, profile_oid, actor_id, transaction_id) VALUES (14, 'OML^O35^OML_O35', '1.3.6.1.4.12559.11.1.1.17', 2, 5);
INSERT INTO validation_parameters (id, message_type, profile_oid, actor_id, transaction_id) VALUES (15, 'ORL^O22^ORL_O22', '1.3.6.1.4.12559.11.1.1.14', 2, 2);
INSERT INTO validation_parameters (id, message_type, profile_oid, actor_id, transaction_id) VALUES (16, 'ORL^O34^ORL_O34', '1.3.6.1.4.12559.11.1.1.12', 2, 2);
INSERT INTO validation_parameters (id, message_type, profile_oid, actor_id, transaction_id) VALUES (17, 'ORL^O36^ORL_O36', '1.3.6.1.4.12559.11.1.1.13', 2, 2);
INSERT INTO validation_parameters (id, message_type, profile_oid, actor_id, transaction_id) VALUES (18, 'ORL^O22^ORL_O22', '1.3.6.1.4.12559.11.1.1.111', 1, 5);
INSERT INTO validation_parameters (id, message_type, profile_oid, actor_id, transaction_id) VALUES (19, 'ORL^O34^ORL_O34', '1.3.6.1.4.12559.11.1.1.109', 1, 5);
INSERT INTO validation_parameters (id, message_type, profile_oid, actor_id, transaction_id) VALUES (20, 'ORL^O36^ORL_O36', '1.3.6.1.4.12559.11.1.1.110', 1, 5);
INSERT INTO validation_parameters (id, message_type, profile_oid, actor_id, transaction_id) VALUES (21, 'OML^O21^OML_O21', '1.3.6.1.4.12559.11.1.1.1', 2, 9);
INSERT INTO validation_parameters (id, message_type, profile_oid, actor_id, transaction_id) VALUES (22, 'OML^O33^OML_O33', '1.3.6.1.4.12559.11.1.1.2', 2, 9);
INSERT INTO validation_parameters (id, message_type, profile_oid, actor_id, transaction_id) VALUES (23, 'OML^O35^OML_O35', '1.3.6.1.4.12559.11.1.1.3', 2, 9);
INSERT INTO validation_parameters (id, message_type, profile_oid, actor_id, transaction_id) VALUES (24, 'ORL^O22^ORL_O22', '1.3.6.1.4.12559.11.1.1.95', 3, 9);
INSERT INTO validation_parameters (id, message_type, profile_oid, actor_id, transaction_id) VALUES (25, 'ORL^O34^ORL_O34', '1.3.6.1.4.12559.11.1.1.93', 3, 9);
INSERT INTO validation_parameters (id, message_type, profile_oid, actor_id, transaction_id) VALUES (26, 'ORL^O36^ORL_O36', '1.3.6.1.4.12559.11.1.1.94', 3, 9);
INSERT INTO validation_parameters (id, message_type, profile_oid, actor_id, transaction_id) VALUES (27, 'ACK^ALL^ACK', '1.3.6.1.4.12559.11.1.1.22', 4, 8);
INSERT INTO validation_parameters (id, message_type, profile_oid, actor_id, transaction_id) VALUES (28, 'OUL^R22^OUL_R22', '1.3.6.1.4.12559.11.1.1.18', 2, 8);
INSERT INTO validation_parameters (id, message_type, profile_oid, actor_id, transaction_id) VALUES (29, 'ORU^R01^ORU_R01', '1.3.6.1.4.12559.11.1.1.20', 2, 8);
INSERT INTO validation_parameters (id, message_type, profile_oid, actor_id, transaction_id) VALUES (30, 'OUL^R22^OUL_R22', '1.3.6.1.4.12559.11.1.1.96', 3, 10);
INSERT INTO validation_parameters (id, message_type, profile_oid, actor_id, transaction_id) VALUES (31, 'OUL^R23^OUL_R23', '1.3.6.1.4.12559.11.1.1.97', 3, 10);
INSERT INTO validation_parameters (id, message_type, profile_oid, actor_id, transaction_id) VALUES (32, 'ACK^ALL^ACK', '1.3.6.1.4.12559.11.1.1.6', 2, 10);
INSERT INTO validation_parameters (id, message_type, profile_oid, actor_id, transaction_id) VALUES (33, 'QBP^Q11^QBP_Q11', '1.3.6.1.4.12559.11.1.1.180', 5, 11);
INSERT INTO validation_parameters (id, message_type, profile_oid, actor_id, transaction_id) VALUES (34, 'ORL^O34^ORL_O34', '1.3.6.1.4.12559.11.1.1.181', 5, 12);
INSERT INTO validation_parameters (id, message_type, profile_oid, actor_id, transaction_id) VALUES (35, 'OUL^R22^OUL_R22', '1.3.6.1.4.12559.11.1.1.182', 5, 13);
INSERT INTO validation_parameters (id, message_type, profile_oid, actor_id, transaction_id) VALUES (36, 'RSP^K11^RSP_K11', '1.3.6.1.4.12559.11.1.1.177', 6, 11);
INSERT INTO validation_parameters (id, message_type, profile_oid, actor_id, transaction_id) VALUES (37, 'OML^O33^OML_O33', '1.3.6.1.4.12559.11.1.1.178', 6, 12);
INSERT INTO validation_parameters (id, message_type, profile_oid, actor_id, transaction_id) VALUES (38, 'ACK^R22^ACK', '1.3.6.1.4.12559.11.1.1.179', 6, 13);
INSERT INTO validation_parameters (id, message_type, profile_oid, actor_id, transaction_id) VALUES (39, 'ORM^O01^ORM_O01', '1.3.6.1.4.12559.11.1.1.10', 2, 14);
INSERT INTO validation_parameters (id, message_type, profile_oid, actor_id, transaction_id) VALUES (40, 'ORM^O01^ORM_O01', '1.3.6.1.4.12559.11.1.1.185', 2, 15);
INSERT INTO validation_parameters (id, message_type, profile_oid, actor_id, transaction_id) VALUES (41, 'ACK^O01^ACK', '1.3.6.1.4.12559.11.1.1.183', 7, 14);
INSERT INTO validation_parameters (id, message_type, profile_oid, actor_id, transaction_id) VALUES (42, 'ACK^O01^ACK', '1.3.6.1.4.12559.11.1.1.184', 7, 15);
INSERT INTO validation_parameters (id, message_type, profile_oid, actor_id, transaction_id) VALUES (43, 'OML^O21^OML_O21', '1.3.6.1.4.12559.11.1.1.186', 2, 2);
INSERT INTO validation_parameters (id, message_type, profile_oid, actor_id, transaction_id) VALUES (44, 'OML^O33^OML_O33', '1.3.6.1.4.12559.11.1.1.187', 2, 2);
INSERT INTO validation_parameters (id, message_type, profile_oid, actor_id, transaction_id) VALUES (45, 'OML^O35^OML_O35', '1.3.6.1.4.12559.11.1.1.188', 2, 2);
INSERT INTO validation_parameters (id, message_type, profile_oid, actor_id, transaction_id) VALUES (46, 'ORL^O22^ORL_O22', '1.3.6.1.4.12559.11.1.1.189', 1, 2);
INSERT INTO validation_parameters (id, message_type, profile_oid, actor_id, transaction_id) VALUES (47, 'ORL^O34^ORL_O34', '1.3.6.1.4.12559.11.1.1.190', 1, 2);
INSERT INTO validation_parameters (id, message_type, profile_oid, actor_id, transaction_id) VALUES (48, 'ORL^O36^ORL_O36', '1.3.6.1.4.12559.11.1.1.191', 1, 5);
INSERT INTO validation_parameters (id, message_type, profile_oid, actor_id, transaction_id) VALUES (49, 'ORM^O01^ORM_O01 (NW)', '1.3.6.1.4.12559.11.1.1.194', 1, 3);
INSERT INTO validation_parameters (id, message_type, profile_oid, actor_id, transaction_id) VALUES (50, 'ORM^O01^ORM_O01 (CA)', '1.3.6.1.4.12559.11.1.1.195', 1, 3);
INSERT INTO validation_parameters (id, message_type, profile_oid, actor_id, transaction_id) VALUES (51, 'ORR^O02^ORR_O02', '1.3.6.1.4.12559.11.1.1.196', 1, 6);
INSERT INTO validation_parameters (id, message_type, profile_oid, actor_id, transaction_id) VALUES (52, 'ORM^O01^ORM_O01 (SN)', '1.3.6.1.4.12559.11.1.1.197', 2, 6);
INSERT INTO validation_parameters (id, message_type, profile_oid, actor_id, transaction_id) VALUES (53, 'ORM^O01^ORM_O01 (SC)', '1.3.6.1.4.12559.11.1.1.198', 2, 6);
INSERT INTO validation_parameters (id, message_type, profile_oid, actor_id, transaction_id) VALUES (54, 'ORM^O01^ORM_O01 (OC)', '1.3.6.1.4.12559.11.1.1.199', 2, 6);
INSERT INTO validation_parameters (id, message_type, profile_oid, actor_id, transaction_id) VALUES (55, 'ACK^ALL^ACK', '1.3.6.1.4.12559.11.1.1.200', 2, 3);
INSERT INTO validation_parameters (id, message_type, profile_oid, actor_id, transaction_id) VALUES (56, 'ACK^ALL^ACK', '1.3.6.1.4.12559.11.1.1.200', 1, 6);
INSERT INTO validation_parameters (id, message_type, profile_oid, actor_id, transaction_id) VALUES (57, 'ADT^A01^ADT_A01', '1.3.6.1.4.12559.11.1.1.77', 8, 16);
INSERT INTO validation_parameters (id, message_type, profile_oid, actor_id, transaction_id) VALUES (58, 'ADT^A04^ADT_A01', '1.3.6.1.4.12559.11.1.1.79', 8, 16);
INSERT INTO validation_parameters (id, message_type, profile_oid, actor_id, transaction_id) VALUES (59, 'ADT^A40^ADT_A39', '1.3.6.1.4.12559.11.1.1.87', 8, 17);
INSERT INTO validation_parameters (id, message_type, profile_oid, actor_id, transaction_id) VALUES (60, 'ADT^A08^ADT_A01', '1.3.6.1.4.12559.11.1.1.82', 8, 17);
INSERT INTO validation_parameters (id, message_type, profile_oid, actor_id, transaction_id) VALUES (61, 'ACK^ALL^ACK', '1.3.6.1.4.12559.11.1.1.148', 2, 16);
INSERT INTO validation_parameters (id, message_type, profile_oid, actor_id, transaction_id) VALUES (62, 'ACK^ALL^ACK', '1.3.6.1.4.12559.11.1.1.148', 1, 16);
INSERT INTO validation_parameters (id, message_type, profile_oid, actor_id, transaction_id) VALUES (63, 'ACK^ALL^ACK', '1.3.6.1.4.12559.11.1.1.150', 2, 17);
INSERT INTO validation_parameters (id, message_type, profile_oid, actor_id, transaction_id) VALUES (64, 'ACK^ALL^ACK', '1.3.6.1.4.12559.11.1.1.150', 1, 17);
INSERT INTO validation_parameters (id, message_type, profile_oid, actor_id, transaction_id) VALUES (65, 'ACK^ALL^ACK', '1.3.6.1.4.12559.11.1.1.150', 7, 17);
INSERT INTO validation_parameters (id, message_type, profile_oid, actor_id, transaction_id) VALUES (66, 'OML^O33^OML_O33 (DC)', '1.3.6.1.4.12559.11.1.1.215', 6, 12);
INSERT INTO validation_parameters (id, message_type, profile_oid, actor_id, transaction_id) VALUES (67, 'OMG^O19^OMG_O19 (NW)', '1.3.6.1.4.12559.11.1.1.205', 1, 3);
INSERT INTO validation_parameters (id, message_type, profile_oid, actor_id, transaction_id) VALUES (68, 'OMG^O19^OMG_O19 (CA)', '1.3.6.1.4.12559.11.1.1.206', 1, 3);
INSERT INTO validation_parameters (id, message_type, profile_oid, actor_id, transaction_id) VALUES (69, 'ORG^O20^ORG_O20', '1.3.6.1.4.12559.11.1.1.207', 1, 6);
INSERT INTO validation_parameters (id, message_type, profile_oid, actor_id, transaction_id) VALUES (70, 'OMG^O19^OMG_O19 (SN)', '1.3.6.1.4.12559.11.1.1.201', 2, 6);
INSERT INTO validation_parameters (id, message_type, profile_oid, actor_id, transaction_id) VALUES (71, 'OMG^O19^OMG_O19 (SC)', '1.3.6.1.4.12559.11.1.1.202', 2, 6);
INSERT INTO validation_parameters (id, message_type, profile_oid, actor_id, transaction_id) VALUES (72, 'OMG^O19^OMG_O19 (OC)', '1.3.6.1.4.12559.11.1.1.203', 2, 6);
INSERT INTO validation_parameters (id, message_type, profile_oid, actor_id, transaction_id) VALUES (73, 'ACK^O19^ACK', '1.3.6.1.4.12559.11.1.1.204', 2, 3);
INSERT INTO validation_parameters (id, message_type, profile_oid, actor_id, transaction_id) VALUES (74, 'ACK^O19^ACK', '1.3.6.1.4.12559.11.1.1.208', 1, 6);
INSERT INTO validation_parameters (id, message_type, profile_oid, actor_id, transaction_id) VALUES (75, 'OMI^O23^OMI_O23', '1.3.6.1.4.12559.11.1.1.209', 2, 14);
INSERT INTO validation_parameters (id, message_type, profile_oid, actor_id, transaction_id) VALUES (76, 'OMI^O23^OMI_O23', '1.3.6.1.4.12559.11.1.1.210', 2, 15);
INSERT INTO validation_parameters (id, message_type, profile_oid, actor_id, transaction_id) VALUES (77, 'ACK^O23^ACK', '1.3.6.1.4.12559.11.1.1.211', 7, 14);
INSERT INTO validation_parameters (id, message_type, profile_oid, actor_id, transaction_id) VALUES (78, 'ACK^O23^ACK', '1.3.6.1.4.12559.11.1.1.212', 7, 15);
INSERT INTO validation_parameters (id, message_type, profile_oid, actor_id, transaction_id) VALUES (79, 'OMG^O19^OMG_O19 (DC)', '1.3.6.1.4.12559.11.1.1.206', 1, 3);
SELECT pg_catalog.setval('ort_validation_parameters_id_seq', 79, true);

INSERT INTO hl7_validation_parameters_affinity_domain VALUES (67, 1);
INSERT INTO hl7_validation_parameters_affinity_domain VALUES (68, 1);
INSERT INTO hl7_validation_parameters_affinity_domain VALUES (69, 1);
INSERT INTO hl7_validation_parameters_affinity_domain VALUES (70, 1);
INSERT INTO hl7_validation_parameters_affinity_domain VALUES (71, 1);
INSERT INTO hl7_validation_parameters_affinity_domain VALUES (72, 1);
INSERT INTO hl7_validation_parameters_affinity_domain VALUES (73, 1);
INSERT INTO hl7_validation_parameters_affinity_domain VALUES (74, 1);
INSERT INTO hl7_validation_parameters_affinity_domain VALUES (75, 1);
INSERT INTO hl7_validation_parameters_affinity_domain VALUES (76, 1);
INSERT INTO hl7_validation_parameters_affinity_domain VALUES (77, 1);
INSERT INTO hl7_validation_parameters_affinity_domain VALUES (78, 1);
INSERT INTO hl7_validation_parameters_affinity_domain VALUES (79, 1);
INSERT INTO hl7_validation_parameters_affinity_domain VALUES (49, 3);
INSERT INTO hl7_validation_parameters_affinity_domain VALUES (50, 3);
INSERT INTO hl7_validation_parameters_affinity_domain VALUES (51, 3);
INSERT INTO hl7_validation_parameters_affinity_domain VALUES (52, 3);
INSERT INTO hl7_validation_parameters_affinity_domain VALUES (53, 3);
INSERT INTO hl7_validation_parameters_affinity_domain VALUES (54, 3);
INSERT INTO hl7_validation_parameters_affinity_domain VALUES (55, 3);
INSERT INTO hl7_validation_parameters_affinity_domain VALUES (56, 3);
INSERT INTO hl7_validation_parameters_affinity_domain VALUES (1, 1);
INSERT INTO hl7_validation_parameters_affinity_domain VALUES (2, 1);
INSERT INTO hl7_validation_parameters_affinity_domain VALUES (3, 1);
INSERT INTO hl7_validation_parameters_affinity_domain VALUES (4, 1);
INSERT INTO hl7_validation_parameters_affinity_domain VALUES (5, 1);
INSERT INTO hl7_validation_parameters_affinity_domain VALUES (6, 1);
INSERT INTO hl7_validation_parameters_affinity_domain VALUES (7, 1);
INSERT INTO hl7_validation_parameters_affinity_domain VALUES (8, 1);
INSERT INTO hl7_validation_parameters_affinity_domain VALUES (11, 5);
INSERT INTO hl7_validation_parameters_affinity_domain VALUES (12, 5);
INSERT INTO hl7_validation_parameters_affinity_domain VALUES (13, 5);
INSERT INTO hl7_validation_parameters_affinity_domain VALUES (14, 5);
INSERT INTO hl7_validation_parameters_affinity_domain VALUES (15, 5);
INSERT INTO hl7_validation_parameters_affinity_domain VALUES (16, 5);
INSERT INTO hl7_validation_parameters_affinity_domain VALUES (17, 5);
INSERT INTO hl7_validation_parameters_affinity_domain VALUES (18, 5);
INSERT INTO hl7_validation_parameters_affinity_domain VALUES (19, 5);
INSERT INTO hl7_validation_parameters_affinity_domain VALUES (20, 5);
INSERT INTO hl7_validation_parameters_affinity_domain VALUES (9, 5);
INSERT INTO hl7_validation_parameters_affinity_domain VALUES (10, 5);
INSERT INTO hl7_validation_parameters_affinity_domain VALUES (21, 5);
INSERT INTO hl7_validation_parameters_affinity_domain VALUES (22, 5);
INSERT INTO hl7_validation_parameters_affinity_domain VALUES (23, 5);
INSERT INTO hl7_validation_parameters_affinity_domain VALUES (24, 5);
INSERT INTO hl7_validation_parameters_affinity_domain VALUES (25, 5);
INSERT INTO hl7_validation_parameters_affinity_domain VALUES (26, 5);
INSERT INTO hl7_validation_parameters_affinity_domain VALUES (27, 5);
INSERT INTO hl7_validation_parameters_affinity_domain VALUES (28, 5);
INSERT INTO hl7_validation_parameters_affinity_domain VALUES (29, 5);
INSERT INTO hl7_validation_parameters_affinity_domain VALUES (30, 5);
INSERT INTO hl7_validation_parameters_affinity_domain VALUES (31, 5);
INSERT INTO hl7_validation_parameters_affinity_domain VALUES (32, 5);
INSERT INTO hl7_validation_parameters_affinity_domain VALUES (33, 5);
INSERT INTO hl7_validation_parameters_affinity_domain VALUES (34, 5);
INSERT INTO hl7_validation_parameters_affinity_domain VALUES (35, 5);
INSERT INTO hl7_validation_parameters_affinity_domain VALUES (36, 5);
INSERT INTO hl7_validation_parameters_affinity_domain VALUES (37, 5);
INSERT INTO hl7_validation_parameters_affinity_domain VALUES (38, 5);
INSERT INTO hl7_validation_parameters_affinity_domain VALUES (39, 1);
INSERT INTO hl7_validation_parameters_affinity_domain VALUES (40, 1);
INSERT INTO hl7_validation_parameters_affinity_domain VALUES (41, 1);
INSERT INTO hl7_validation_parameters_affinity_domain VALUES (42, 1);
INSERT INTO hl7_validation_parameters_affinity_domain VALUES (43, 5);
INSERT INTO hl7_validation_parameters_affinity_domain VALUES (44, 5);
INSERT INTO hl7_validation_parameters_affinity_domain VALUES (45, 5);
INSERT INTO hl7_validation_parameters_affinity_domain VALUES (47, 5);
INSERT INTO hl7_validation_parameters_affinity_domain VALUES (48, 5);
INSERT INTO hl7_validation_parameters_affinity_domain VALUES (57, 1);
INSERT INTO hl7_validation_parameters_affinity_domain VALUES (58, 1);
INSERT INTO hl7_validation_parameters_affinity_domain VALUES (59, 1);
INSERT INTO hl7_validation_parameters_affinity_domain VALUES (60, 1);
INSERT INTO hl7_validation_parameters_affinity_domain VALUES (61, 1);
INSERT INTO hl7_validation_parameters_affinity_domain VALUES (62, 1);
INSERT INTO hl7_validation_parameters_affinity_domain VALUES (63, 1);
INSERT INTO hl7_validation_parameters_affinity_domain VALUES (64, 1);
INSERT INTO hl7_validation_parameters_affinity_domain VALUES (65, 1);
INSERT INTO hl7_validation_parameters_affinity_domain VALUES (57, 3);
INSERT INTO hl7_validation_parameters_affinity_domain VALUES (58, 3);
INSERT INTO hl7_validation_parameters_affinity_domain VALUES (59, 3);
INSERT INTO hl7_validation_parameters_affinity_domain VALUES (60, 3);
INSERT INTO hl7_validation_parameters_affinity_domain VALUES (61, 3);
INSERT INTO hl7_validation_parameters_affinity_domain VALUES (62, 3);
INSERT INTO hl7_validation_parameters_affinity_domain VALUES (63, 3);
INSERT INTO hl7_validation_parameters_affinity_domain VALUES (64, 3);
INSERT INTO hl7_validation_parameters_affinity_domain VALUES (65, 3);
INSERT INTO hl7_validation_parameters_affinity_domain VALUES (66, 5);

INSERT INTO uid_generator (id, tag, root, last_index) VALUES (1, '(0020,000d)', '1.3.6.1.4.1.12559.11.4.1.1.', 0);
INSERT INTO uid_generator (id, tag, root, last_index) VALUES (2, '(0040,1001)', 'OMRP', 0);
INSERT INTO uid_generator (id, tag, root, last_index) VALUES (3, '(0040,0009)', 'OMSPS', 0);
INSERT INTO uid_generator (id, tag, root, last_index) VALUES (4, '(0008,1155)', '1.3.6.1.4.1.12559.11.4.1.2.', 0);


-- for testing
INSERT INTO om_command_field_values (id, keyword , value_of_key ,  description ) VALUES (1 ,x'0001'::int , 'C-STORE-RQ', '' );
INSERT INTO om_command_field_values (id, keyword , value_of_key ,  description ) VALUES (2 ,x'8001'::int , 'C-STORE-RSP', '' );
INSERT INTO om_command_field_values (id, keyword , value_of_key ,  description ) VALUES (3 ,x'0010'::int , 'C-GET-RQ', '' );
INSERT INTO om_command_field_values (id, keyword , value_of_key ,  description ) VALUES (4 ,x'8010'::int , 'C-GET-RSP', '' );
INSERT INTO om_command_field_values (id, keyword , value_of_key ,  description ) VALUES (5 ,x'0020'::int , 'C-FIND-RQ', '' );
INSERT INTO om_command_field_values (id, keyword , value_of_key ,  description ) VALUES (6 ,x'8020'::int , 'C-FIND-RSP', '' );
INSERT INTO om_command_field_values (id, keyword , value_of_key ,  description ) VALUES (7 ,x'0021'::int , 'C-MOVE-REQ', '' );
INSERT INTO om_command_field_values (id, keyword , value_of_key ,  description ) VALUES (8 ,x'8021'::int , 'C-MOVE-RSP', '' );
INSERT INTO om_command_field_values (id, keyword , value_of_key ,  description ) VALUES (9 ,x'0030'::int , 'C-ECHO-RQ', '' );
INSERT INTO om_command_field_values (id, keyword , value_of_key ,  description ) VALUES (10,x'8030'::int , 'C-ECHO-RSP', '' );
INSERT INTO om_command_field_values (id, keyword , value_of_key ,  description ) VALUES (11,x'0100'::int , 'N-EVENT-REPORT-RQ', '' );
INSERT INTO om_command_field_values (id, keyword , value_of_key ,  description ) VALUES (12,x'8100'::int , 'N-EVENT-REPORT-RSP', '' );
INSERT INTO om_command_field_values (id, keyword , value_of_key ,  description ) VALUES (13,x'0110'::int , 'N-GET-RQ', '' );
INSERT INTO om_command_field_values (id, keyword , value_of_key ,  description ) VALUES (14,x'8110'::int , 'N-GET-RSP', '' );
INSERT INTO om_command_field_values (id, keyword , value_of_key ,  description ) VALUES (15,x'0120'::int , 'N-SET-RQ', '' );
INSERT INTO om_command_field_values (id, keyword , value_of_key ,  description ) VALUES (16,x'8120'::int , 'N-SET-RSP', '' );
INSERT INTO om_command_field_values (id, keyword , value_of_key ,  description ) VALUES (17,x'0130'::int , 'N-ACTION-RQ', '' );
INSERT INTO om_command_field_values (id, keyword , value_of_key ,  description ) VALUES (18,x'8130'::int , 'N-ACTION-RSP', '' );
INSERT INTO om_command_field_values (id, keyword , value_of_key ,  description ) VALUES (19,x'0140'::int , 'N-CREATE-RQ', '' );
INSERT INTO om_command_field_values (id, keyword , value_of_key ,  description ) VALUES (20,x'8140'::int , 'N-CREATE-RSP', '' );
INSERT INTO om_command_field_values (id, keyword , value_of_key ,  description ) VALUES (21,x'0150'::int , 'N-DELETE-RQ', '' );
INSERT INTO om_command_field_values (id, keyword , value_of_key ,  description ) VALUES (22,x'8150'::int , 'N-DELETE-RSP', '' );
INSERT INTO om_command_field_values (id, keyword , value_of_key ,  description ) VALUES (23,x'0FFF'::int , 'C-CANCEL-RQ', '' );
SELECT pg_catalog.setval('om_command_field_values_id_seq', 23, false);
 
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  1, '1.2.840.10008.1.1', 'Verification SOP Class', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  2, '1.2.840.10008.1.2', 'Implicit VR Little Endian: Default Transfer Syntax', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  3, '1.2.840.10008.1.2.1', 'Explicit VR Little Endian', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  4, '1.2.840.10008.1.2.1.99', 'Deflated Explicit VR Little Endian', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  5, '1.2.840.10008.1.2.2', 'Explicit VR Big Endian', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  6, '1.2.840.10008.1.2.4.100', 'MPEG2 Main Profile ,x Main Level', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  7, '1.2.840.10008.1.2.4.50', 'JPEG Baseline (Process 1): Default Lossy 8 Bit JPEG Compression', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  8, '1.2.840.10008.1.2.4.51', 'JPEG Extended (Process 2 and 4): Default Lossy 12 Bit JPEG Compression', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  9, '1.2.840.10008.1.2.4.52', 'JPEG Extended (Process 3 and 5)', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  10, '1.2.840.10008.1.2.4.53', 'JPEG Spectral Selection - Non-Hierarchical (Process 6 and 8)', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  11, '1.2.840.10008.1.2.4.54', 'JPEG Spectral Selection - Non-Hierarchical (Process 7 and 9)', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  12, '1.2.840.10008.1.2.4.55', 'JPEG Full Progression - Non-Hierarchical (Process 10 and 12)', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  13, '1.2.840.10008.1.2.4.56', 'JPEG Full Progression - Non-Hierarchical (Process 11 and 13)', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  14, '1.2.840.10008.1.2.4.57', 'JPEG Lossless - Non-Hierarchical (Process 14)', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  15, '1.2.840.10008.1.2.4.58', 'JPEG Lossless - Non-Hierarchical (Process 15)', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  16, '1.2.840.10008.1.2.4.59', 'JPEG Extended - Hierarchical (Process 16 and 18)', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  17, '1.2.840.10008.1.2.4.60', 'JPEG Extended - Hierarchical (Process 17 and 19)', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  18, '1.2.840.10008.1.2.4.61', 'JPEG Spectral Selection - Hierarchical (Process 20 and 22)', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  19, '1.2.840.10008.1.2.4.62', 'JPEG Spectral Selection - Hierarchical (Process 21 and 23)', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  20, '1.2.840.10008.1.2.4.63', 'JPEG Full Progression - Hierarchical (Process 24 and 26)', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  21, '1.2.840.10008.1.2.4.64', 'JPEG Full Progression - Hierarchical (Process 25 and 27)', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  22, '1.2.840.10008.1.2.4.65', 'JPEG Lossless - Hierarchical (Process 28)', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  23, '1.2.840.10008.1.2.4.66', 'JPEG Lossless - Hierarchical (Process 29)', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  24, '1.2.840.10008.1.2.4.70', 'JPEG Lossless - Non-Hierarchical First-Order Prediction (Process 14): Default Lossless JPEG Compression', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  25, '1.2.840.10008.1.2.4.80', 'JPEG-LS Lossless Compression', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  26, '1.2.840.10008.1.2.4.81', 'JPEG-LS Lossy (Near-Lossless) Compression', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  27, '1.2.840.10008.1.2.4.90', 'JPEG 2000 Lossless Compression (Lossless Only)', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  28, '1.2.840.10008.1.2.4.91', 'JPEG 2000 Compression', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  29, '1.2.840.10008.1.2.4.92', 'JPEG 2000 Part 2 Multi-component Image Compression (Lossless Only)', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  30, '1.2.840.10008.1.2.4.93', 'JPEG 2000 Part 2 Multi-component Image Compression', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  31, '1.2.840.10008.1.2.4.94', 'JPIP Referenced', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  32, '1.2.840.10008.1.2.4.95', 'JPIP Referenced Deflate', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  33, '1.2.840.10008.1.2.5', 'RLE Lossless', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  34, '1.2.840.10008.1.2.6.1', 'RFC 2557 MIME encapsulation', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  35, '1.2.840.10008.1.20.1', 'Storage Commitment Push Model', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  36, '1.2.840.10008.1.20.1.1', 'Storage Commitment Push Model', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  37, '1.2.840.10008.1.20.2', 'Storage Commitment Pull Model', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  38, '1.2.840.10008.1.20.2.1', 'Storage Commitment Pull Model', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  39, '1.2.840.10008.1.3.10', 'Media Storage Directory Storage', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  40, '1.2.840.10008.1.4.1.1', 'Talairach Brain Atlas', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  41, '1.2.840.10008.1.4.1.10', 'SPM2 GRAY', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  42, '1.2.840.10008.1.4.1.11', 'SPM2 WHITE', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  43, '1.2.840.10008.1.4.1.12', 'SPM2 CSF', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  44, '1.2.840.10008.1.4.1.13', 'SPM2 BRAINMASK', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  45, '1.2.840.10008.1.4.1.14', 'SPM2 AVG305T1', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  46, '1.2.840.10008.1.4.1.15', 'SPM2 AVG152T1', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  47, '1.2.840.10008.1.4.1.16', 'SPM2 AVG152T2', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  48, '1.2.840.10008.1.4.1.17', 'SPM2 AVG152PD', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  49, '1.2.840.10008.1.4.1.18', 'SPM2 SINGLESUBJT1', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  50, '1.2.840.10008.1.4.1.2', 'SPM2 T1', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  51, '1.2.840.10008.1.4.1.3', 'SPM2 T2', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  52, '1.2.840.10008.1.4.1.4', 'SPM2 PD', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  53, '1.2.840.10008.1.4.1.5', 'SPM2 EPI', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  54, '1.2.840.10008.1.4.1.6', 'SPM2 FIL T1', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  55, '1.2.840.10008.1.4.1.7', 'SPM2 PET', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  56, '1.2.840.10008.1.4.1.8', 'SPM2 TRANSM', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  57, '1.2.840.10008.1.4.1.9', 'SPM2 SPECT', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  58, '1.2.840.10008.1.4.2.1', 'ICBM 452 T1', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  59, '1.2.840.10008.1.4.2.2', 'ICBM Single Subject MRI', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  60, '1.2.840.10008.1.40', 'Procedural Event Logging', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  61, '1.2.840.10008.1.40.1', 'Procedural Event Logging', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  62, '1.2.840.10008.1.9', 'Basic Study Content Notification', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  63, '1.2.840.10008.15.0.3.1', 'dicomDeviceName', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  64, '1.2.840.10008.15.0.3.10', 'dicomAssociationInitiator', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  65, '1.2.840.10008.15.0.3.11', 'dicomAssociationAcceptor', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  66, '1.2.840.10008.15.0.3.12', 'dicomHostname', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  67, '1.2.840.10008.15.0.3.13', 'dicomPort', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  68, '1.2.840.10008.15.0.3.14', 'dicomSOPClass', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  69, '1.2.840.10008.15.0.3.15', 'dicomTransferRole', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  70, '1.2.840.10008.15.0.3.16', 'dicomTransferSyntax', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  71, '1.2.840.10008.15.0.3.17', 'dicomPrimaryDeviceType', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  72, '1.2.840.10008.15.0.3.18', 'dicomRelatedDeviceReference', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  73, '1.2.840.10008.15.0.3.19', 'dicomPreferredCalledAETitle', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  74, '1.2.840.10008.15.0.3.2', 'dicomDescription', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  75, '1.2.840.10008.15.0.3.20', 'dicomTLSCyphersuite', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  76, '1.2.840.10008.15.0.3.21', 'dicomAuthorizedNodeCertificateReference', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  77, '1.2.840.10008.15.0.3.22', 'dicomThisNodeCertificateReference', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  78, '1.2.840.10008.15.0.3.23', 'dicomInstalled', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  79, '1.2.840.10008.15.0.3.24', 'dicomStationName', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  80, '1.2.840.10008.15.0.3.25', 'dicomDeviceSerialNumber', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  81, '1.2.840.10008.15.0.3.26', 'dicomInstitutionName', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  82, '1.2.840.10008.15.0.3.27', 'dicomInstitutionAddress', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  83, '1.2.840.10008.15.0.3.28', 'dicomInstitutionDepartmentName', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  84, '1.2.840.10008.15.0.3.29', 'dicomIssuerOfPatientID', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  85, '1.2.840.10008.15.0.3.3', 'dicomManufacturer', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  86, '1.2.840.10008.15.0.3.30', 'dicomPreferredCallingAETitle', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  87, '1.2.840.10008.15.0.3.31', 'dicomSupportedCharacterSet', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  88, '1.2.840.10008.15.0.3.4', 'dicomManufacturerModelName', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  89, '1.2.840.10008.15.0.3.5', 'dicomSoftwareVersion', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  90, '1.2.840.10008.15.0.3.6', 'dicomVendorData', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  91, '1.2.840.10008.15.0.3.7', 'dicomAETitle', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  92, '1.2.840.10008.15.0.3.8', 'dicomNetworkConnectionReference', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  93, '1.2.840.10008.15.0.3.9', 'dicomApplicationCluster', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  94, '1.2.840.10008.15.0.4.1', 'dicomConfigurationRoot', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  95, '1.2.840.10008.15.0.4.2', 'dicomDevicesRoot', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  96, '1.2.840.10008.15.0.4.3', 'dicomUniqueAETitlesRegistryRoot', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  97, '1.2.840.10008.15.0.4.4', 'dicomDevice', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  98, '1.2.840.10008.15.0.4.5', 'dicomNetworkAE', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  99, '1.2.840.10008.15.0.4.6', 'dicomNetworkConnection', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  100, '1.2.840.10008.15.0.4.7', 'dicomUniqueAETitle', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  101, '1.2.840.10008.15.0.4.8', 'dicomTransferCapability', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  102, '1.2.840.10008.2.16.4', 'DICOM Controlled Terminology', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  103, '1.2.840.10008.2.6.1', 'DICOM UID Registry', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  104, '1.2.840.10008.3.1.1.1', 'DICOM Application Context Name', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  105, '1.2.840.10008.3.1.2.1.1', 'Detached Patient Management', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  106, '1.2.840.10008.3.1.2.1.4', 'Detached Patient Management', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  107, '1.2.840.10008.3.1.2.2.1', 'Detached Visit Management', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  108, '1.2.840.10008.3.1.2.3.1', 'Detached Study Management', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  109, '1.2.840.10008.3.1.2.3.2', 'Study Component Management', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  110, '1.2.840.10008.3.1.2.3.3', 'Modality Performed Procedure Step', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  111, '1.2.840.10008.3.1.2.3.4', 'Modality Performed Procedure Step Retrieve', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  112, '1.2.840.10008.3.1.2.3.5', 'Modality Performed Procedure Step Notification', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  113, '1.2.840.10008.3.1.2.5.1', 'Detached Results Management', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  114, '1.2.840.10008.3.1.2.5.4', 'Detached Results Management', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  115, '1.2.840.10008.3.1.2.5.5', 'Detached Study Management', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  116, '1.2.840.10008.3.1.2.6.1', 'Detached Interpretation Management', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  117, '1.2.840.10008.4.2', 'Storage Service', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  118, '1.2.840.10008.5.1.1.1', 'Basic Film Session', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  119, '1.2.840.10008.5.1.1.14', 'Print Job', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  120, '1.2.840.10008.5.1.1.15', 'Basic Annotation Box', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  121, '1.2.840.10008.5.1.1.16', 'Printer', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  122, '1.2.840.10008.5.1.1.16.376', 'Printer Configuration Retrieval', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  123, '1.2.840.10008.5.1.1.17', 'Printer', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  124, '1.2.840.10008.5.1.1.17.376', 'Printer Configuration Retrieval', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  125, '1.2.840.10008.5.1.1.18', 'Basic Color Print Management', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  126, '1.2.840.10008.5.1.1.18.1', 'Referenced Color Print Management', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  127, '1.2.840.10008.5.1.1.2', 'Basic Film Box', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  128, '1.2.840.10008.5.1.1.22', 'VOI LUT Box', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  129, '1.2.840.10008.5.1.1.23', 'Presentation LUT', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  130, '1.2.840.10008.5.1.1.24', 'Image Overlay Box', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  131, '1.2.840.10008.5.1.1.24.1', 'Basic Print Image Overlay Box', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  132, '1.2.840.10008.5.1.1.25', 'Print Queue', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  133, '1.2.840.10008.5.1.1.26', 'Print Queue Management', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  134, '1.2.840.10008.5.1.1.27', 'Stored Print Storage', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  135, '1.2.840.10008.5.1.1.29', 'Hardcopy Grayscale Image Storage', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  136, '1.2.840.10008.5.1.1.30', 'Hardcopy Color Image Storage', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  137, '1.2.840.10008.5.1.1.31', 'Pull Print Request', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  138, '1.2.840.10008.5.1.1.32', 'Pull Stored Print Management', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  139, '1.2.840.10008.5.1.1.33', 'Media Creation Management UID', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  140, '1.2.840.10008.5.1.1.4', 'Basic Grayscale Image Box', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  141, '1.2.840.10008.5.1.1.4.1', 'Basic Color Image Box', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  142, '1.2.840.10008.5.1.1.4.2', 'Referenced Image Box', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  143, '1.2.840.10008.5.1.1.9', 'Basic Grayscale Print Management', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  144, '1.2.840.10008.5.1.1.9.1', 'Referenced Grayscale Print Management', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  145, '1.2.840.10008.5.1.4.1.1.1', 'Computed Radiography Image Storage', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  146, '1.2.840.10008.5.1.4.1.1.1.1', 'Digital X-Ray Image Storage - For Presentation', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  147, '1.2.840.10008.5.1.4.1.1.1.1.1', 'Digital X-Ray Image Storage - For Processing', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  148, '1.2.840.10008.5.1.4.1.1.1.2', 'Digital Mammography X-Ray Image Storage - For Presentation', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  149, '1.2.840.10008.5.1.4.1.1.1.2.1', 'Digital Mammography X-Ray Image Storage - For Processing', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  150, '1.2.840.10008.5.1.4.1.1.1.3', 'Digital Intra-oral X-Ray Image Storage - For Presentation', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  151, '1.2.840.10008.5.1.4.1.1.1.3.1', 'Digital Intra-oral X-Ray Image Storage - For Processing', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  152, '1.2.840.10008.5.1.4.1.1.10', 'Standalone Modality LUT Storage', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  153, '1.2.840.10008.5.1.4.1.1.104.1', 'Encapsulated PDF Storage', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  154, '1.2.840.10008.5.1.4.1.1.11', 'Standalone VOI LUT Storage', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  155, '1.2.840.10008.5.1.4.1.1.11.1', 'Grayscale Softcopy Presentation State Storage', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  156, '1.2.840.10008.5.1.4.1.1.11.2', 'Color Softcopy Presentation State Storage', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  157, '1.2.840.10008.5.1.4.1.1.11.3', 'Pseudo-Color Softcopy Presentation State Storage', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  158, '1.2.840.10008.5.1.4.1.1.11.4', 'Blending Softcopy Presentation State Storage', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  159, '1.2.840.10008.5.1.4.1.1.12.1', 'X-Ray Angiographic Image Storage', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  160, '1.2.840.10008.5.1.4.1.1.12.1.1', 'Enhanced XA Image Storage', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  161, '1.2.840.10008.5.1.4.1.1.12.2', 'X-Ray Radiofluoroscopic Image Storage', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  162, '1.2.840.10008.5.1.4.1.1.12.2.1', 'Enhanced XRF Image Storage', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  163, '1.2.840.10008.5.1.4.1.1.12.3', 'X-Ray Angiographic Bi-Plane Image Storage', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  164, '1.2.840.10008.5.1.4.1.1.128', 'Positron Emission Tomography Image Storage', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  165, '1.2.840.10008.5.1.4.1.1.129', 'Standalone PET Curve Storage', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  166, '1.2.840.10008.5.1.4.1.1.2', 'CT Image Storage', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  167, '1.2.840.10008.5.1.4.1.1.2.1', 'Enhanced CT Image Storage', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  168, '1.2.840.10008.5.1.4.1.1.20', 'Nuclear Medicine Image Storage', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  169, '1.2.840.10008.5.1.4.1.1.3', 'Ultrasound Multi-frame Image Storage', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  170, '1.2.840.10008.5.1.4.1.1.3.1', 'Ultrasound Multi-frame Image Storage', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  171, '1.2.840.10008.5.1.4.1.1.4', 'MR Image Storage', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  172, '1.2.840.10008.5.1.4.1.1.4.1', 'Enhanced MR Image Storage', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  173, '1.2.840.10008.5.1.4.1.1.4.2', 'MR Spectroscopy Storage', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  174, '1.2.840.10008.5.1.4.1.1.481.1', 'RT Image Storage', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  175, '1.2.840.10008.5.1.4.1.1.481.2', 'RT Dose Storage', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  176, '1.2.840.10008.5.1.4.1.1.481.3', 'RT Structure Set Storage', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  177, '1.2.840.10008.5.1.4.1.1.481.4', 'RT Beams Treatment Record Storage', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  178, '1.2.840.10008.5.1.4.1.1.481.5', 'RT Plan Storage', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  179, '1.2.840.10008.5.1.4.1.1.481.6', 'RT Brachy Treatment Record Storage', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  180, '1.2.840.10008.5.1.4.1.1.481.7', 'RT Treatment Summary Record Storage', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  181, '1.2.840.10008.5.1.4.1.1.481.8', 'RT Ion Plan Storage', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  182, '1.2.840.10008.5.1.4.1.1.481.9', 'RT Ion Beams Treatment Record Storage', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  183, '1.2.840.10008.5.1.4.1.1.5', 'Nuclear Medicine Image Storage', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  184, '1.2.840.10008.5.1.4.1.1.6', 'Ultrasound Image Storage', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  185, '1.2.840.10008.5.1.4.1.1.6.1', 'Ultrasound Image Storage', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  186, '1.2.840.10008.5.1.4.1.1.66', 'Raw Data Storage', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  187, '1.2.840.10008.5.1.4.1.1.66.1', 'Spatial Registration Storage', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  188, '1.2.840.10008.5.1.4.1.1.66.2', 'Spatial Fiducials Storage', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  189, '1.2.840.10008.5.1.4.1.1.66.3', 'Deformable Spatial Registration Storage', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  190, '1.2.840.10008.5.1.4.1.1.66.4', 'Segmentation Storage', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  191, '1.2.840.10008.5.1.4.1.1.67', 'Real World Value Mapping Storage', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  192, '1.2.840.10008.5.1.4.1.1.7', 'Secondary Capture Image Storage', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  193, '1.2.840.10008.5.1.4.1.1.7.1', 'Multi-frame Single Bit Secondary Capture Image Storage', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  194, '1.2.840.10008.5.1.4.1.1.7.2', 'Multi-frame Grayscale Byte Secondary Capture Image Storage', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  195, '1.2.840.10008.5.1.4.1.1.7.3', 'Multi-frame Grayscale Word Secondary Capture Image Storage', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  196, '1.2.840.10008.5.1.4.1.1.7.4', 'Multi-frame True Color Secondary Capture Image Storage', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  197, '1.2.840.10008.5.1.4.1.1.77.1', 'VL Image Storage', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  198, '1.2.840.10008.5.1.4.1.1.77.1.1', 'VL Endoscopic Image Storage', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  199, '1.2.840.10008.5.1.4.1.1.77.1.1.1', 'Video Endoscopic Image Storage', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  200, '1.2.840.10008.5.1.4.1.1.77.1.2', 'VL Microscopic Image Storage', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  201, '1.2.840.10008.5.1.4.1.1.77.1.2.1', 'Video Microscopic Image Storage', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  202, '1.2.840.10008.5.1.4.1.1.77.1.3', 'VL Slide-Coordinates Microscopic Image Storage', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  203, '1.2.840.10008.5.1.4.1.1.77.1.4', 'VL Photographic Image Storage', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  204, '1.2.840.10008.5.1.4.1.1.77.1.4.1', 'Video Photographic Image Storage', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  205, '1.2.840.10008.5.1.4.1.1.77.1.5.1', 'Ophthalmic Photography 8 Bit Image Storage', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  206, '1.2.840.10008.5.1.4.1.1.77.1.5.2', 'Ophthalmic Photography 16 Bit Image Storage', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  207, '1.2.840.10008.5.1.4.1.1.77.1.5.3', 'Stereometric Relationship Storage', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  208, '1.2.840.10008.5.1.4.1.1.77.2', 'VL Multi-frame Image Storage', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  209, '1.2.840.10008.5.1.4.1.1.8', 'Standalone Overlay Storage', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  210, '1.2.840.10008.5.1.4.1.1.88.11', 'Basic Text SR', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  211, '1.2.840.10008.5.1.4.1.1.88.22', 'Enhanced SR', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  212, '1.2.840.10008.5.1.4.1.1.88.33', 'Comprehensive SR', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  213, '1.2.840.10008.5.1.4.1.1.88.40', 'Procedure Log Storage', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  214, '1.2.840.10008.5.1.4.1.1.88.50', 'Mammography CAD SR', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  215, '1.2.840.10008.5.1.4.1.1.88.59', 'Key Object Selection Document', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  216, '1.2.840.10008.5.1.4.1.1.88.65', 'Chest CAD SR', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  217, '1.2.840.10008.5.1.4.1.1.88.67', 'X-Ray Radiation Dose SR', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  218, '1.2.840.10008.5.1.4.1.1.9', 'Standalone Curve Storage', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  219, '1.2.840.10008.5.1.4.1.1.9.1.1', '12-lead ECG Waveform Storage', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  220, '1.2.840.10008.5.1.4.1.1.9.1.2', 'General ECG Waveform Storage', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  221, '1.2.840.10008.5.1.4.1.1.9.1.3', 'Ambulatory ECG Waveform Storage', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  222, '1.2.840.10008.5.1.4.1.1.9.2.1', 'Hemodynamic Waveform Storage', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  223, '1.2.840.10008.5.1.4.1.1.9.3.1', 'Cardiac Electrophysiology Waveform Storage', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  224, '1.2.840.10008.5.1.4.1.1.9.4.1', 'Basic Voice Audio Waveform Storage', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  225, '1.2.840.10008.5.1.4.1.2.1.1', 'Patient Root Query/Retrieve Information Model - FIND', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  226, '1.2.840.10008.5.1.4.1.2.1.2', 'Patient Root Query/Retrieve Information Model - MOVE', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  227, '1.2.840.10008.5.1.4.1.2.1.3', 'Patient Root Query/Retrieve Information Model - GET', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  228, '1.2.840.10008.5.1.4.1.2.2.1', 'Study Root Query/Retrieve Information Model - FIND', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  229, '1.2.840.10008.5.1.4.1.2.2.2', 'Study Root Query/Retrieve Information Model - MOVE', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  230, '1.2.840.10008.5.1.4.1.2.2.3', 'Study Root Query/Retrieve Information Model - GET', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  231, '1.2.840.10008.5.1.4.1.2.3.1', 'Patient/Study Only Query/Retrieve Information Model - FIND', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  232, '1.2.840.10008.5.1.4.1.2.3.2', 'Patient/Study Only Query/Retrieve Information Model - MOVE', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  233, '1.2.840.10008.5.1.4.1.2.3.3', 'Patient/Study Only Query/Retrieve Information Model - GET', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  234, '1.2.840.10008.5.1.4.31', 'Modality Worklist Information Model - FIND', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  235, '1.2.840.10008.5.1.4.32', 'General Purpose Worklist Management', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  236, '1.2.840.10008.5.1.4.32.1', 'General Purpose Worklist Information Model - FIND', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  237, '1.2.840.10008.5.1.4.32.2', 'General Purpose Scheduled Procedure Step', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  238, '1.2.840.10008.5.1.4.32.3', 'General Purpose Performed Procedure Step', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  239, '1.2.840.10008.5.1.4.33', 'Instance Availability Notification', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  240, '1.2.840.10008.5.1.4.37.1', 'General Relevant Patient Information Query', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  241, '1.2.840.10008.5.1.4.37.2', 'Breast Imaging Relevant Patient Information Query', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  242, '1.2.840.10008.5.1.4.37.3', 'Cardiac Relevant Patient Information Query', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  243, '1.2.840.10008.5.1.4.38.1', 'Hanging Protocol Storage', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  244, '1.2.840.10008.5.1.4.38.2', 'Hanging Protocol Information Model - Find', '');
INSERT INTO om_dicom_uid_values (id, keyword, value_of_key, description) VALUES (  245, '1.2.840.10008.5.1.4.38.3', 'Hanging Protocol Information Model - Move', '');
SELECT pg_catalog.setval('om_dicom_uid_values_id_seq', 245, false);