INSERT INTO connectathon (keyword, name, year, location, region) VALUES ('NA2021', 'North America 2021', 2021, 'Online', 1);


-- INSERT INTO company (keyword,name,url,integration_statement_url) VALUES ('AI, CXR, MMG', 'Lunit Inc.', 'https://lunit.io', 'null');
-- INSERT INTO company (keyword,name,url,integration_statement_url) VALUES ('BAXTER', 'Baxter Healthcare', 'http://www.baxter.com', 'http://www.baxter.com/ihe');
-- INSERT INTO company (keyword,name,url,integration_statement_url) VALUES ('BSC', 'Boston Scientific', 'http://www.bostonscientific.com', '');
-- INSERT INTO company (keyword,name,url,integration_statement_url) VALUES ('CAPSULE', 'Capsule Technologies', 'http://www.capsuletech.com', '');
-- INSERT INTO company (keyword,name,url,integration_statement_url) VALUES ('CDC', 'Centers for Disease Control and Prevention', 'http://www.cdc.gov', '');
-- INSERT INTO company (keyword,name,url,integration_statement_url) VALUES ('ECW', 'eClinicalWorks', 'http://www.eclinicalworks.com/', 'http://www.eclinicalworks.com/ihe/2014/statement.pdf');
-- INSERT INTO company (keyword,name,url,integration_statement_url) VALUES ('Epic', 'Epic', 'http://www.epic.com', 'https://open.epic.com/Home/IHE');
-- INSERT INTO company (keyword,name,url,integration_statement_url) VALUES ('FRESENIUS', 'Fresenius Kabi', 'http://www.fresenius-kabi.com/', 'https://key2.fresenius-kabi.com/en/regulatory-documentation?type=100&cat=101');
-- INSERT INTO company (keyword,name,url,integration_statement_url) VALUES ('GAVERS', 'Georgia Vital Events Registration System', 'https://gavers.dph.ga.gov/Welcome.htm', '');
-- INSERT INTO company (keyword,name,url,integration_statement_url) VALUES ('GE', 'GE Healthcare', 'http://www.ge.com/interoperability', 'http://www.ge.com/ihe');
-- INSERT INTO company (keyword,name,url,integration_statement_url) VALUES ('GENESIS', 'Genesis Systems, Inc. ', 'http://www.genesisinfo.com', 'http://www.genesisinfo.com/Genesis-IHE-2014-integration-statement.pdf');
-- INSERT INTO company (keyword,name,url,integration_statement_url) VALUES ('Hillrom', 'Hillrom Company, Inc.', 'http://www.hill-rom.com', '');
-- INSERT INTO company (keyword,name,url,integration_statement_url) VALUES ('HYLAND', 'Hyland', 'http://www.hyland.com/', 'http://www.hyland.com/industry-solutions/healthcare/ihe');
-- INSERT INTO company (keyword,name,url,integration_statement_url) VALUES ('ICU_MEDICAL', 'ICU Medical', 'http://www.icumed.com', 'https://www.icumed.com/media/9681/p18-1229-ihe-integration-statement_final_101618.pdf');
INSERT INTO company (keyword,name,url,integration_statement_url) VALUES ('iCure', 'iCure ', 'https://www.icure.dev', '');
-- INSERT INTO company (keyword,name,url,integration_statement_url) VALUES ('IHEUSA', 'IHE USA', 'http://www.iheusa.org', '');
INSERT INTO company (keyword,name,url,integration_statement_url) VALUES ('IMT', 'InnoVision Medical', 'http://www.innovisionmedical.com', '');
INSERT INTO company (keyword,name,url,integration_statement_url) VALUES ('LYNIATE', 'Lyniate', 'https://www.lyniate.com/', 'https://www.lyniate.com/corepoint/integration-engine/ihe-integration-statement-for-corepoint-integration-engine-v7/');
-- INSERT INTO company (keyword,name,url,integration_statement_url) VALUES ('MedAllies', 'MedAllies', 'http://www.medallies.com/', '');
-- INSERT INTO company (keyword,name,url,integration_statement_url) VALUES ('MEDTRONIC', 'Medtronic', 'http://www.medtronic.com', '');
-- INSERT INTO company (keyword,name,url,integration_statement_url) VALUES ('MINDRAY', 'Mindray', 'http://www.mindray.com', '');
-- INSERT INTO company (keyword,name,url,integration_statement_url) VALUES ('NEXTGEN', 'NextGen Healthcare', 'http://www.nextgen.com', '');
-- INSERT INTO company (keyword,name,url,integration_statement_url) VALUES ('NTT', 'NTT Data', 'http://dell.com/vna', 'http://i.dell.com/sites/doccontent/public/solutions/healthcare/en/Documents/dcca-ihe-integration-statement.pdf');
-- INSERT INTO company (keyword,name,url,integration_statement_url) VALUES ('ORACLE', 'Oracle America, Inc.', 'http://www.oracle.com', 'https://www.oracle.com/a/ocom/docs/industries/healthcare/ihe-integration-statement.pdf');
-- INSERT INTO company (keyword,name,url,integration_statement_url) VALUES ('PHILIPS', 'Philips Medical Systems Nederland B.V.', 'http://www.healthcare.philips.com', 'http://www.philips.com/ihe');
-- INSERT INTO company (keyword,name,url,integration_statement_url) VALUES ('QVERA', 'Qvera', 'https://www.qvera.com/', 'https://www.qvera.com/files/qvera_ihe_integration_statement_2021.pdf');
INSERT INTO company (keyword,name,url,integration_statement_url) VALUES ('SOFTNETA', 'Softneta UAB', 'https://www.softneta.com/', '');
-- INSERT INTO company (keyword,name,url,integration_statement_url) VALUES ('SS', 'Surescripts', 'http://www.surescripts.com/', '');
INSERT INTO company (keyword,name,url,integration_statement_url) VALUES ('TC', 'TigerConnect', 'http://tigerconnect.com', 'http://www.ihe.net');
INSERT INTO company (keyword,name,url,integration_statement_url) VALUES ('Zen', 'Zen Healthcare IT', 'https://consultzen.com', '');
-- INSERT INTO company (keyword,name,url,integration_statement_url) VALUES ('Tiani - Cisco', 'Tiani "Spirit" Gmbh - Cisco Systems Inc.', 'http://www.tiani-spirit.com', 'https://www.tiani-spirit.com/ihe');

-- Merge Tiany company
UPDATE company_actor_profiles SET company = 'TIANI-SPIRIT' WHERE company = 'Tiani-Cisco';
DELETE FROM company WHERE keyword = 'Tiani-Cisco';

INSERT INTO actor (keyword, name, description) VALUES ('PAT_IDENTITY_SUBSCRIBER', 'Patient Identity Subscriber', '');
INSERT INTO actor (keyword, name, description) VALUES ('PAT_IDENTITY_REG', 'Patient Identity Registry', '');



--Company information
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('Baxter', 'ACM', 'ALERT_RPT', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('Baxter', 'DEC', 'DEV_OBS_REPORTER', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('Baxter', 'IPEC', 'DEV_OBS_REPORTER', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('Baxter', 'PIV', 'IOC', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('Baxter', 'CT', 'TIME_CLIENT', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('CAPSULETECH', 'ACM', 'ACON', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('CAPSULETECH', 'ACM', 'ALERT_RPT', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('CAPSULETECH', 'ACM', 'ALRT_COMMUNICATOR', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('CAPSULETECH', 'ACM', 'ALRT_MGR', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('CAPSULETECH', 'DEC', 'DEV_OBS_CONSUMER', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('CAPSULETECH', 'DEC', 'DEV_OBS_REPORTER', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('CAPSULETECH', 'PDQ', 'PDS', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('CAPSULETECH', 'CT', 'TIME_CLIENT', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('CDC', 'HW', 'CONTENT_CONSUMER', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('ECW', '360X', 'REFERRAL_INITIATOR', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('ECW', '360X', 'REFERRAL_RECIPIENT', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('EPIC', 'ACM', 'ACON', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('EPIC', 'ACM', 'ALRT_COMMUNICATOR', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('EPIC', 'QEDm', 'CLIN_DATA_SOURCE', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('EPIC', 'C-CDA2.1_CONSUMERS', 'CONTENT_CONSUMER', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('EPIC', 'LDS', 'CONTENT_CONSUMER', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('EPIC', 'XDS-MS', 'CONTENT_CONSUMER', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('EPIC', 'C-CDA2.1_CARE-PLAN', 'CONTENT_CREATOR', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('EPIC', 'C-CDA2.1_CCD', 'CONTENT_CREATOR', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('EPIC', 'C-CDA2.1_DISCHARGE', 'CONTENT_CREATOR', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('EPIC', 'C-CDA2.1_OPERATIVE', 'CONTENT_CREATOR', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('EPIC', 'C-CDA2.1_PROGRESS', 'CONTENT_CREATOR', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('EPIC', 'C-CDA2.1_REFERRAL', 'CONTENT_CREATOR', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('EPIC', 'C-CDA2.1_UNSTRUCTURED', 'CONTENT_CREATOR', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('EPIC', 'LDS', 'CONTENT_CREATOR', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('EPIC', 'DEC', 'DEV_OBS_CONSUMER', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('EPIC', 'IPEC', 'DEV_OBS_CONSUMER', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('EPIC', 'XDR', 'DOC_RECIPIENT', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('EPIC', 'XDR', 'DOC_SOURCE', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('EPIC', 'IID', 'IMG_DISPLAY_INVOKER', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('EPIC', 'XCA', 'INIT_GATEWAY', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('EPIC', 'XCPD', 'INIT_GATEWAY', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('EPIC', 'PIV', 'IOP', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('EPIC', 'XDR', 'METADATA_LTD_DOC_SOURCE', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('EPIC', 'PAM', 'PES', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('EPIC', 'XDM', 'PMC', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('EPIC', 'XDM', 'PMI', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('EPIC', '360X', 'REFERRAL_INITIATOR', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('EPIC', '360X', 'REFERRAL_RECIPIENT', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('EPIC', 'XCA', 'RESP_GATEWAY', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('EPIC', 'XCPD', 'RESP_GATEWAY', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('EPIC', 'ATNA', 'SA', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('EPIC', 'ATNA', 'SN', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('EPIC', 'CT', 'TIME_CLIENT', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('FRESENIUS', 'PIV', 'IOC', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('FRESENIUS', 'CT', 'TIME_CLIENT', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('GE', 'ACM', 'ALERT_RPT', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('GE', 'DEC', 'DEV_OBS_REPORTER', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('GE', 'PDQ', 'PDC', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('GE', 'CT', 'TIME_CLIENT', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('HYLAND', 'ATNA', 'ARR', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('HYLAND', 'ATNA', 'AUDIT_CONSUMER', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('HYLAND', 'ATNA', 'AUDIT_RECORD_FORWARDER', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('HYLAND', 'QEDm', 'CLIN_DATA_SOURCE', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('HYLAND', 'APPC', 'CONTENT_CONSUMER', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('HYLAND', 'XDS-SD', 'CONTENT_CONSUMER', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('HYLAND', 'APPC', 'CONTENT_CREATOR', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('HYLAND', 'XDS-SD', 'CONTENT_CREATOR', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('HYLAND', 'MPQ', 'DOC_CONSUMER', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('HYLAND', 'MHD', 'DOC_RECIPIENT', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('HYLAND', 'XDR', 'DOC_RECIPIENT', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('HYLAND', 'RMD', 'DOC_REGISTRY', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('HYLAND', 'XDS.b', 'DOC_REGISTRY', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('HYLAND', 'XPID', 'DOC_REGISTRY', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('HYLAND', 'RMD', 'DOC_REPOSITORY', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('HYLAND', 'XDS.b', 'DOC_REPOSITORY', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('HYLAND', 'MHD', 'DOC_RESPONDER', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('HYLAND', 'MHD', 'DOC_SOURCE', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('HYLAND', 'XDR', 'DOC_SOURCE', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('HYLAND', 'XDS.b', 'DOC_SOURCE', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('HYLAND', 'SWF.b', 'EC', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('HYLAND', 'XDS.b', 'EMBED_REPOS', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('HYLAND', 'WIA', 'IMG_DOC_RESPONDER', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('HYLAND', 'WIA', 'IMG_DOC_SOURCE', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('HYLAND', 'XCA', 'INIT_GATEWAY', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('HYLAND', 'XCF', 'INIT_GATEWAY', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('HYLAND', 'XCPD', 'INIT_GATEWAY', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('HYLAND', 'XCA-I', 'INIT_IMG_GATEWAY', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('HYLAND', 'XDR', 'METADATA_LTD_DOC_SOURCE', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('HYLAND', 'PMIR', 'PAT_IDENTITY_REG', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('HYLAND', 'PIX', 'PAT_IDENTITY_SRC', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('HYLAND', 'PIXV3', 'PAT_IDENTITY_SRC', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('HYLAND', 'PDQ', 'PDC', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('HYLAND', 'PDQV3', 'PDC', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('HYLAND', 'PAM', 'PDS', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('HYLAND', 'PDQ', 'PDS', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('HYLAND', 'PDQm', 'PDS', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('HYLAND', 'PDQV3', 'PDS', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('HYLAND', 'PIX', 'PAT_IDENTITY_CONSUMER', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('HYLAND', 'PIXV3', 'PAT_IDENTITY_CONSUMER', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('HYLAND', 'PIX', 'PAT_IDENTITY_X_REF_MGR', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('HYLAND', 'PIXV3', 'PAT_IDENTITY_X_REF_MGR', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('HYLAND', 'XPID', 'PAT_IDENTITY_X_REF_MGR', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('HYLAND', 'XCA', 'RESP_GATEWAY', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('HYLAND', 'XCF', 'RESP_GATEWAY', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('HYLAND', 'XCPD', 'RESP_GATEWAY', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('HYLAND', 'XCA-I', 'RESP_IMG_GATEWAY', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('HYLAND', 'ATNA', 'SA', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('HYLAND', 'ATNA', 'SN', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('HYLAND', 'CT', 'TIME_CLIENT', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('HYLAND', 'XUA', 'X-SERVICE-PROVIDER', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('HYLAND', 'XUA', 'X-SERVICE-USER', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('iCure', 'XDS.b', 'DOC_CONSUMER', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('iCure', 'XDS.b', 'DOC_REGISTRY', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('iCure', 'XDS.b', 'DOC_REPOSITORY', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('iCure', 'XDS.b', 'DOC_SOURCE', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('iCure', 'ATNA', 'SA', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('IMT', 'DEC', 'DEV_OBS_REPORTER', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('IMT', 'CT', 'TIME_CLIENT', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('LYNIATE', 'QEDm', 'CLIN_DATA_CONSUMER', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('LYNIATE', 'MHD', 'DOC_CONSUMER', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('LYNIATE', 'PMIR', 'PAT_IDENTITY_SUBSCRIBER', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('LYNIATE', 'PDQm', 'PDC', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('LYNIATE', 'PDQm', 'PDS', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('LYNIATE', 'PIXm', 'PAT_IDENTITY_CONSUMER', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('LYNIATE', 'PIXm', 'PAT_IDENTITY_X_REF_MGR', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('LYNIATE', 'ATNA', 'SN', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('LYNIATE', 'CT', 'TIME_CLIENT', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('MEDTRONIC', 'MHD', 'DOC_SOURCE', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('MEDTRONIC', 'PDQm', 'PDC', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('MEDTRONIC', 'CT', 'TIME_CLIENT', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('MINDRAY', 'ACM', 'ALERT_RPT', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('MINDRAY', 'DEC', 'DEV_OBS_REPORTER', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('MINDRAY', 'CT', 'TIME_CLIENT', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('NEXTGEN', 'C-CDA2.1_CONSUMERS', 'CONTENT_CONSUMER', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('NEXTGEN', 'C-CDA2.1_CARE-PLAN', 'CONTENT_CREATOR', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('NEXTGEN', 'C-CDA2.1_CCD', 'CONTENT_CREATOR', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('NEXTGEN', 'C-CDA2.1_HandP', 'CONTENT_CREATOR', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('NEXTGEN', 'C-CDA2.1_REFERRAL', 'CONTENT_CREATOR', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('NEXTGEN', 'XDS.b', 'DOC_CONSUMER', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('NEXTGEN', 'XDR', 'DOC_RECIPIENT', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('NEXTGEN', 'XDR', 'DOC_SOURCE', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('NEXTGEN', 'XDS.b', 'DOC_SOURCE', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('NEXTGEN', 'PDQV3', 'PDC', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('NEXTGEN', 'PIXV3', 'PAT_IDENTITY_CONSUMER', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('NEXTGEN', '360X', 'REFERRAL_INITIATOR', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('NEXTGEN', '360X', 'REFERRAL_RECIPIENT', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('NEXTGEN', 'ATNA', 'SA', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('NEXTGEN', 'CT', 'TIME_CLIENT', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('ORACLECORP', 'ATNA', 'ARR', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('ORACLECORP', 'MPQ', 'DOC_REGISTRY', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('ORACLECORP', 'XDS.b', 'DOC_REGISTRY', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('ORACLECORP', 'XDS-I.b', 'DOC_REGISTRY', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('ORACLECORP', 'XDS.b', 'DOC_REPOSITORY', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('ORACLECORP', 'XDS-I.b', 'DOC_REPOSITORY', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('ORACLECORP', 'PAM', 'PDC', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('ORACLECORP', 'PDQ', 'PDS', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('ORACLECORP', 'PDQm', 'PDS', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('ORACLECORP', 'PDQV3', 'PDS', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('ORACLECORP', 'PAM', 'PEC', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('ORACLECORP', 'PIX', 'PAT_IDENTITY_X_REF_MGR', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('ORACLECORP', 'PIXm', 'PAT_IDENTITY_X_REF_MGR', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('ORACLECORP', 'PIXV3', 'PAT_IDENTITY_X_REF_MGR', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('ORACLECORP', 'ATNA', 'SN', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('ORACLECORP', 'CT', 'TIME_CLIENT', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('PHILIPS', 'ATNA', 'ARR', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('PHILIPS', 'ATNA', 'AUDIT_RECORD_FORWARDER', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('PHILIPS', 'C-CDA2.1_CONSUMERS', 'CONTENT_CONSUMER', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('PHILIPS', 'DEC', 'DEV_OBS_CONSUMER', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('PHILIPS', 'MHD', 'DOC_CONSUMER', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('PHILIPS', 'XCA', 'DOC_CONSUMER', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('PHILIPS', 'XDS.b', 'DOC_CONSUMER', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('PHILIPS', 'XDS-I.b', 'DOC_CONSUMER', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('PHILIPS', 'MHD', 'DOC_RECIPIENT', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('PHILIPS', 'RMD', 'DOC_REGISTRY', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('PHILIPS', 'XDS.b', 'DOC_REGISTRY', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('PHILIPS', 'XDS-I.b', 'DOC_REGISTRY', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('PHILIPS', 'RMD', 'DOC_REPOSITORY', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('PHILIPS', 'XDS.b', 'DOC_REPOSITORY', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('PHILIPS', 'XDS-I.b', 'DOC_REPOSITORY', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('PHILIPS', 'MHD', 'DOC_RESPONDER', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('PHILIPS', 'XDS.b', 'DOC_SOURCE', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('PHILIPS', 'XCA-I', 'IMG_DOC_CONSUMER', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('PHILIPS', 'XDS-I.b', 'IMG_DOC_CONSUMER', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('PHILIPS', 'XDS-I.b', 'IMG_DOC_SOURCE', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('PHILIPS', 'XCA', 'INIT_GATEWAY', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('PHILIPS', 'XCPD', 'INIT_GATEWAY', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('PHILIPS', 'XCA-I', 'INIT_IMG_GATEWAY', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('PHILIPS', 'CPI', 'MOD', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('PHILIPS', 'SWF.b', 'MOD', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('PHILIPS', 'SWF.b', 'OF', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('PHILIPS', 'PAM', 'PDC', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('PHILIPS', 'PDQ', 'PDC', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('PHILIPS', 'PDQm', 'PDC', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('PHILIPS', 'PDQm', 'PDS', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('PHILIPS', 'PAM', 'PEC', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('PHILIPS', 'PIX', 'PAT_IDENTITY_CONSUMER', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('PHILIPS', 'PIXm', 'PAT_IDENTITY_CONSUMER', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('PHILIPS', 'PIXm', 'PAT_IDENTITY_X_REF_MGR', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('PHILIPS', 'SWF.b', 'PPSM', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('PHILIPS', 'XCA', 'RESP_GATEWAY', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('PHILIPS', 'XCPD', 'RESP_GATEWAY', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('PHILIPS', 'XCA-I', 'RESP_IMG_GATEWAY', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('PHILIPS', 'ATNA', 'SA', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('PHILIPS', 'ATNA', 'SN', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('PHILIPS', 'CT', 'TIME_CLIENT', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('PHILIPS', 'XUA', 'X-SERVICE-PROVIDER', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('PHILIPS', 'XUA', 'X-SERVICE-USER', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('QVERA', 'ATNA', 'AUDIT_CONSUMER', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('QVERA', 'QEDm', 'CLIN_DATA_CONSUMER', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('QVERA', 'APPC', 'CONTENT_CREATOR', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('QVERA', 'HW', 'CONTENT_CREATOR', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('QVERA', 'MHD', 'DOC_CONSUMER', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('QVERA', 'MHD', 'DOC_RECIPIENT', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('QVERA', 'MHD', 'DOC_RESPONDER', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('QVERA', 'MHD', 'DOC_SOURCE', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('QVERA', 'ARI', 'IM', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('QVERA', 'SWF.b', 'IM', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('QVERA', 'WIA', 'IMG_DOC_CONSUMER', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('QVERA', 'XCA', 'INIT_GATEWAY', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('QVERA', 'XCPD', 'INIT_GATEWAY', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('QVERA', 'PMIR', 'PAT_IDENTITY_CONSUMER', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('QVERA', 'PMIR', 'PAT_IDENTITY_SUBSCRIBER', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('QVERA', 'PMIR', 'PDC', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('QVERA', 'PIX', 'PAT_IDENTITY_CONSUMER', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('QVERA', 'SWF.b', 'PPSM', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('QVERA', '360X', 'REFERRAL_INITIATOR', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('QVERA', '360X', 'REFERRAL_RECIPIENT', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('QVERA', 'XCA', 'RESP_GATEWAY', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('QVERA', 'XCPD', 'RESP_GATEWAY', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('QVERA', 'ATNA', 'SN', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('QVERA', 'CT', 'TIME_CLIENT', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('SOFTNETA', 'XDS.b', 'DOC_CONSUMER', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('SOFTNETA', 'WIA', 'IMG_DOC_CONSUMER', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('SOFTNETA', 'XDS-I.b', 'IMG_DOC_CONSUMER', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('SOFTNETA', 'ATNA', 'SA', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('SOFTNETA', 'CT', 'TIME_CLIENT', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('SS', 'XCA', 'INIT_GATEWAY', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('SS', 'XCPD', 'INIT_GATEWAY', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('SS', 'XCA', 'RESP_GATEWAY', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('SS', 'XCPD', 'RESP_GATEWAY', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('SS', 'ATNA', 'SA', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('SS', 'CT', 'TIME_CLIENT', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('TC', 'ACM', 'ALRT_MGR', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('TIANI-SPIRIT', 'ATNA', 'ARR', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('TIANI-SPIRIT', 'ATNA', 'AUDIT_CONSUMER', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('TIANI-SPIRIT', 'ATNA', 'AUDIT_RECORD_FORWARDER', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('TIANI-SPIRIT', 'APPC', 'CONTENT_CONSUMER', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('TIANI-SPIRIT', 'C-CDA2.1_CONSUMERS', 'CONTENT_CONSUMER', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('TIANI-SPIRIT', 'LDS', 'CONTENT_CONSUMER', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('TIANI-SPIRIT', 'XDS-SD', 'CONTENT_CONSUMER', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('TIANI-SPIRIT', 'LDS', 'CONTENT_CREATOR', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('TIANI-SPIRIT', 'XDS-MS', 'CONTENT_CREATOR', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('TIANI-SPIRIT', 'XDS-SD', 'CONTENT_CREATOR', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('TIANI-SPIRIT', 'RMD', 'DOC_ADMINISTRATOR', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('TIANI-SPIRIT', 'XDS.b', 'DOC_ADMINISTRATOR', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('TIANI-SPIRIT', 'MHD', 'DOC_CONSUMER', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('TIANI-SPIRIT', 'XCA', 'DOC_CONSUMER', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('TIANI-SPIRIT', 'XDS.b', 'DOC_CONSUMER', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('TIANI-SPIRIT', 'XDS-I.b', 'DOC_CONSUMER', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('TIANI-SPIRIT', 'MHD', 'DOC_RECIPIENT', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('TIANI-SPIRIT', 'XDR', 'DOC_RECIPIENT', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('TIANI-SPIRIT', 'MPQ', 'DOC_REGISTRY', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('TIANI-SPIRIT', 'XDS.b', 'DOC_REGISTRY', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('TIANI-SPIRIT', 'XDS-I.b', 'DOC_REGISTRY', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('TIANI-SPIRIT', 'XPID', 'DOC_REGISTRY', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('TIANI-SPIRIT', 'XDS.b', 'DOC_REPOSITORY', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('TIANI-SPIRIT', 'XDS-I.b', 'DOC_REPOSITORY', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('TIANI-SPIRIT', 'MHD', 'DOC_RESPONDER', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('TIANI-SPIRIT', 'MHD', 'DOC_SOURCE', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('TIANI-SPIRIT', 'XDR', 'DOC_SOURCE', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('TIANI-SPIRIT', 'XDS.b', 'DOC_SOURCE', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('TIANI-SPIRIT', 'XDS.b', 'EMBED_REPOS', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('TIANI-SPIRIT', 'ARI', 'ID', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('TIANI-SPIRIT', 'CPI', 'ID', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('TIANI-SPIRIT', 'IID', 'ID', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('TIANI-SPIRIT', 'SWF.b', 'ID', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('TIANI-SPIRIT', 'CPI', 'IM', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('TIANI-SPIRIT', 'SWF.b', 'IM', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('TIANI-SPIRIT', 'XCA-I', 'IMG_DOC_CONSUMER', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('TIANI-SPIRIT', 'XDS-I.b', 'IMG_DOC_CONSUMER', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('TIANI-SPIRIT', 'XCA-I', 'IMG_DOC_SOURCE', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('TIANI-SPIRIT', 'XDS-I.b', 'IMG_DOC_SOURCE', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('TIANI-SPIRIT', 'XCA', 'INIT_GATEWAY', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('TIANI-SPIRIT', 'XCF', 'INIT_GATEWAY', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('TIANI-SPIRIT', 'XCPD', 'INIT_GATEWAY', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('TIANI-SPIRIT', 'XCA-I', 'INIT_IMG_GATEWAY', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('TIANI-SPIRIT', 'XDS.b', 'ON_DEMAND_DOC_SOURCE', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('TIANI-SPIRIT', 'PIX', 'PAT_IDENTITY_SRC', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('TIANI-SPIRIT', 'PIXV3', 'PAT_IDENTITY_SRC', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('TIANI-SPIRIT', 'PMIR', 'PAT_IDENTITY_SRC', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('TIANI-SPIRIT', 'XDS.b', 'PAT_IDENTITY_SRC', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('TIANI-SPIRIT', 'PAM', 'PDC', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('TIANI-SPIRIT', 'PDQ', 'PDC', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('TIANI-SPIRIT', 'PDQm', 'PDC', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('TIANI-SPIRIT', 'PDQV3', 'PDC', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('TIANI-SPIRIT', 'PMIR', 'PDC', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('TIANI-SPIRIT', 'PDQ', 'PDS', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('TIANI-SPIRIT', 'PDQm', 'PDS', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('TIANI-SPIRIT', 'PDQV3', 'PDS', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('TIANI-SPIRIT', 'PAM', 'PEC', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('TIANI-SPIRIT', 'PIX', 'PAT_IDENTITY_CONSUMER', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('TIANI-SPIRIT', 'PIXm', 'PAT_IDENTITY_CONSUMER', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('TIANI-SPIRIT', 'PIXV3', 'PAT_IDENTITY_CONSUMER', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('TIANI-SPIRIT', 'PMIR', 'PAT_IDENTITY_CONSUMER', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('TIANI-SPIRIT', 'PIX', 'PAT_IDENTITY_X_REF_MGR', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('TIANI-SPIRIT', 'PIXm', 'PAT_IDENTITY_X_REF_MGR', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('TIANI-SPIRIT', 'PIXV3', 'PAT_IDENTITY_X_REF_MGR', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('TIANI-SPIRIT', 'XPID', 'PAT_IDENTITY_X_REF_MGR', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('TIANI-SPIRIT', 'SWF.b', 'PPSM', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('TIANI-SPIRIT', 'XCA', 'RESP_GATEWAY', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('TIANI-SPIRIT', 'XCF', 'RESP_GATEWAY', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('TIANI-SPIRIT', 'XCPD', 'RESP_GATEWAY', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('TIANI-SPIRIT', 'XCA-I', 'RESP_IMG_GATEWAY', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('TIANI-SPIRIT', 'ATNA', 'SA', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('TIANI-SPIRIT', 'ATNA', 'SN', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('TIANI-SPIRIT', 'CT', 'TIME_CLIENT', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('TIANI-SPIRIT', 'CT', 'TS', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('TIANI-SPIRIT', 'XUA', 'X-SERVICE-PROVIDER', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('TIANI-SPIRIT', 'XUA', 'X-SERVICE-USER', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('Zen', 'XCA', 'DOC_CONSUMER', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('Zen', 'XDS.b', 'DOC_CONSUMER', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('Zen', 'XCA', 'INIT_GATEWAY', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('Zen', 'XCPD', 'INIT_GATEWAY', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('Zen', 'XCA', 'RESP_GATEWAY', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('Zen', 'XCPD', 'RESP_GATEWAY', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('Zen', 'ATNA', 'SA', 'NA2021');
INSERT INTO company_actor_profiles (company ,integration_profile ,actor ,connectathon) VALUES ('Zen', 'CT', 'TIME_CLIENT', 'NA2021');


-- Remove iCure results (see IHEUSA-59)

DELETE FROM company_actor_profiles WHERE company = 'iCure';
DELETE FROM company WHERE keyword = 'iCure';
