-- 20081105 EP Addition of the pathology Domain

INSERT INTO "tf_domain" (id, last_changed, last_modifier_id, keyword, name, description) VALUES (10, NULL, NULL, 'QRPH', 'Quality Research Public Health', '');
SELECT pg_catalog.setval('tf_domain_id_seq', 10, true);
-- 20081105 EP Addition of the Pathology domain data
INSERT INTO tf_integration_profile (id, last_changed, last_modifier_id, keyword, name, description, integration_profile_type_id) VALUES (86, '2008-11-05 10:00:00.000000', '0', 'APW', 'Pathology Workflow', 'The Pathology Workflow Integration Profile establishes the continuity and integrity of basic pathology data acquired for examinations being ordered for an identified inpatient or outpatient', 4);
SELECT pg_catalog.setval('tf_integration_profile_id_seq', 86, true);
-- 20081105 APW
INSERT INTO "tf_transaction" (id, last_changed, last_modifier_id, label, name, description) VALUES (165, '2008-11-05 11:00:00.000000', '0', 'PAT-1', 'Placer Order Management', 'This transaction contains all the messages required between the Order Placer and the Order Filler for the management of the life cycle of the order. Its main goal is to keep a consistent vision of the order, (content and status), between the two actors.');
INSERT INTO "tf_transaction" (id, last_changed, last_modifier_id, label, name, description) VALUES (166, '2008-11-05 11:00:00.000000', '0', 'PAT-2', 'Filler Order Management', 'This transaction contains all the messages required between the Order Filler and the Order Placer for the notification of a new filler order, as well as the creation of the placer order that reflects it. Its main goal is to ensure that each filler order will be represented by a placer order, and will have both a filler order number and a placer order number.');
INSERT INTO "tf_transaction" (id, last_changed, last_modifier_id, label, name, description) VALUES (167, '2008-11-05 11:00:00.000000', '0', 'PAT-3', 'Order Results Management', 'This transaction carries the results of an Order, as well as status changes, modifications, cancellations of these results, from the Order Filler to the Order Result Tracker.');
INSERT INTO "tf_transaction" (id, last_changed, last_modifier_id, label, name, description) VALUES (168, '2008-11-05 11:00:00.000000', '0', 'PAT-4', 'Procedure Scheduled and Updated', 'The Department System Scheduler/Order Filler sends the Image Manager and Report Manager scheduled procedure information or procedure update.');
INSERT INTO "tf_transaction" (id, last_changed, last_modifier_id, label, name, description) VALUES (169, '2008-11-05 11:00:00.000000', '0', 'PAT-5', 'Query Modality Worklist', 'Based on a query entered at the Acquisition Modality, a modality worklist is generated listing all the items that satisfy the query. This list of Scheduled Procedure Steps with selected demographic information and information about specimen is returned to the Acquisition Modality.');

--- OP
INSERT INTO tf_profile_link (transaction_option_id, actor_id, transaction_id, integration_profile_id) VALUES (1, 15, 165, 86);
INSERT INTO tf_profile_link (transaction_option_id, actor_id, transaction_id, integration_profile_id) VALUES (1, 15, 166, 86);
--- OF
INSERT INTO tf_profile_link (transaction_option_id, actor_id, transaction_id, integration_profile_id) VALUES (1, 13, 165, 86);
INSERT INTO tf_profile_link (transaction_option_id, actor_id, transaction_id, integration_profile_id) VALUES (1, 13, 166, 86);
INSERT INTO tf_profile_link (transaction_option_id, actor_id, transaction_id, integration_profile_id) VALUES (1, 13, 167, 86);
INSERT INTO tf_profile_link (transaction_option_id, actor_id, transaction_id, integration_profile_id) VALUES (1, 13, 168, 86);
INSERT INTO tf_profile_link (transaction_option_id, actor_id, transaction_id, integration_profile_id) VALUES (1, 13, 169, 86);
--- MOD
INSERT INTO tf_profile_link (transaction_option_id, actor_id, transaction_id, integration_profile_id) VALUES (1, 16, 169, 86);
INSERT INTO tf_profile_link (transaction_option_id, actor_id, transaction_id, integration_profile_id) VALUES (1, 16, 11, 86);
INSERT INTO tf_profile_link (transaction_option_id, actor_id, transaction_id, integration_profile_id) VALUES (1, 16, 9, 86);
--- IM
INSERT INTO tf_profile_link (transaction_option_id, actor_id, transaction_id, integration_profile_id) VALUES (1, 17, 168, 86);
INSERT INTO tf_profile_link (transaction_option_id, actor_id, transaction_id, integration_profile_id) VALUES (1, 17, 11, 86);
INSERT INTO tf_profile_link (transaction_option_id, actor_id, transaction_id, integration_profile_id) VALUES (1, 17, 9, 86);
INSERT INTO tf_profile_link (transaction_option_id, actor_id, transaction_id, integration_profile_id) VALUES (1, 17, 39, 86);
INSERT INTO tf_profile_link (transaction_option_id, actor_id, transaction_id, integration_profile_id) VALUES (1, 17, 15, 86);
INSERT INTO tf_profile_link (transaction_option_id, actor_id, transaction_id, integration_profile_id) VALUES (1, 17, 99, 86);
---ID
INSERT INTO tf_profile_link (transaction_option_id, actor_id, transaction_id, integration_profile_id) VALUES (1, 32, 15, 86);
INSERT INTO tf_profile_link (transaction_option_id, actor_id, transaction_id, integration_profile_id) VALUES (1, 32, 99, 86);
---EC
INSERT INTO tf_profile_link (transaction_option_id, actor_id, transaction_id, integration_profile_id) VALUES (1, 18, 11, 86);
INSERT INTO tf_profile_link (transaction_option_id, actor_id, transaction_id, integration_profile_id) VALUES (1, 18, 39, 86);
---ORT
INSERT INTO tf_profile_link (transaction_option_id, actor_id, transaction_id, integration_profile_id) VALUES (1, 31, 167, 86);
-- PATH/APW
INSERT INTO tf_domain_profile (integration_profile_id, domain_id) VALUES (86, 10);
-- PATH:APW EP 2008.11.07
INSERT INTO tf_transaction_link (transaction_id, from_actor_id, to_actor_id) VALUES (165, 15, 13);
INSERT INTO tf_transaction_link (transaction_id, from_actor_id, to_actor_id) VALUES (166, 13, 15);
INSERT INTO tf_transaction_link (transaction_id, from_actor_id, to_actor_id) VALUES (167, 13, 31);
INSERT INTO tf_transaction_link (transaction_id, from_actor_id, to_actor_id) VALUES (168, 13, 17);
INSERT INTO tf_transaction_link (transaction_id, from_actor_id, to_actor_id) VALUES (169, 13, 16);

SELECT pg_catalog.setval('tf_transaction_id_seq', 169, true);