Seeding New Envs with SpecimenType and DeviceTypes - CDCgov/prime-simplereport GitHub Wiki

SQL Seeding

Run the following SQL to seed specimen_type, device_type, device_specimen_type

  • Make sure you replace the created_by/updated_by with a api user id for the new env (use the [email protected] user id)

INSERT INTO public.specimen_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, name, type_code, collection_location_name, collection_location_code) VALUES ('ac5daed9-57af-4298-8b27-90b2f0ea56d1', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, 'Nasal Swab', '445297001', null, null);
INSERT INTO public.specimen_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, name, type_code, collection_location_name, collection_location_code) VALUES ('3530df5b-dde3-40eb-881c-b2c842affbfd', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, 'Oropharyngeal Swab', '258529004', null, null);
INSERT INTO public.specimen_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, name, type_code, collection_location_name, collection_location_code) VALUES ('a7d90b81-b531-4885-87d0-af041eb8c338', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, 'Nasopharyngeal Wash', '258467004', null, null);
INSERT INTO public.specimen_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, name, type_code, collection_location_name, collection_location_code) VALUES ('edf90158-df15-4e84-953e-2ca17c1c4ce4', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, 'Nasal and Throat Swab Combination', '433801000124107', null, null);
INSERT INTO public.specimen_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, name, type_code, collection_location_name, collection_location_code) VALUES ('532243d7-f04d-4d5b-a5a6-07132e31b7f2', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, 'Nasal Washings', '433871000124101', null, null);
INSERT INTO public.specimen_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, name, type_code, collection_location_name, collection_location_code) VALUES ('5676e5f1-84c2-471e-aa81-1ae28a9dd116', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, 'Bronchoalveolar Lavage', '258607008', null, null);
INSERT INTO public.specimen_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, name, type_code, collection_location_name, collection_location_code) VALUES ('65304a1a-491f-4532-a362-7712f33d3b26', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, 'Sputum', '119334006', null, null);
INSERT INTO public.specimen_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, name, type_code, collection_location_name, collection_location_code) VALUES ('553de536-69e9-4c9d-a6ee-7b38fadeb970', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, 'Lower Respiratory Tract Aspirates', '309171007', null, null);
INSERT INTO public.specimen_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, name, type_code, collection_location_name, collection_location_code) VALUES ('6e7d09b2-ad17-425b-99ac-3b5fc872496b', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, 'Nasal Wash/Aspirate', '429931000124105', null, null);
INSERT INTO public.specimen_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, name, type_code, collection_location_name, collection_location_code) VALUES ('7bfd200b-ead7-43b2-a4f4-4557dacccecc', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', true, 'Auto-generated specimen type ZAP', 'ZAP', null, null);
INSERT INTO public.specimen_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, name, type_code, collection_location_name, collection_location_code) VALUES ('f0ba9ee2-7bf1-4dd6-ba9e-8209ae89171c', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', true, 'Auto-generated specimen type e', 'e', null, null);
INSERT INTO public.specimen_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, name, type_code, collection_location_name, collection_location_code) VALUES ('a87855ab-8e48-4e14-94a5-d3d8c123e770', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', true, 'Nasal Swab (old)', '445297001-1', null, null);
INSERT INTO public.specimen_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, name, type_code, collection_location_name, collection_location_code) VALUES ('8e07cba1-7a0f-42b7-ba36-df3bd1bf2e28', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, 'Nasopharyngeal Swab', '258500001', null, null);
INSERT INTO public.specimen_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, name, type_code, collection_location_name, collection_location_code) VALUES ('5dbd902d-6057-4a82-8286-a79363898766', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, 'Mid-Turbinate Nasal Swab', '871810001', null, null);
INSERT INTO public.specimen_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, name, type_code, collection_location_name, collection_location_code) VALUES ('52a582e4-d389-42d0-b738-bee51cf5244d', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, 'Anterior Nasal Swab', '697989009', null, null);


INSERT INTO public.device_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, name, loinc_code, manufacturer, model, swab_type, test_length) VALUES ('b86afd4f-98ee-4db4-bce8-0b738d3e72fc', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', true, 'Zedd Rapid PCR', '12345', 'Zeddco', 'Z Edition', null, 15);
INSERT INTO public.device_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, name, loinc_code, manufacturer, model, swab_type, test_length) VALUES ('07c59c0c-81ad-4bed-b708-f669d9b9dafc', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, 'QIAstat-Dx Respiratory SARS-CoV-2 Panel (PCR)', '94759-8', 'QIAGEN GmbH', 'QIAstat-Dx Respiratory SARS-CoV-2 Panel*', null, 15);
INSERT INTO public.device_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, name, loinc_code, manufacturer, model, swab_type, test_length) VALUES ('52bd6b1c-fc2c-4129-b56f-e4ea8c9422fd', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', true, 'BD Veritor', '94558-4', 'Becton, Dickinson and Company (BD)', 'BD Veritor System for Rapid Detection of SARS-CoV-2*', null, 15);
INSERT INTO public.device_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, name, loinc_code, manufacturer, model, swab_type, test_length) VALUES ('63586bb5-3731-48bf-9c96-70ef225e3a86', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', true, 'Abbott IDNow', '94534-5', 'Abbott', 'ID Now', null, 15);
INSERT INTO public.device_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, name, loinc_code, manufacturer, model, swab_type, test_length) VALUES ('bca52816-b38d-4ef2-afbe-c5e573301f00', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', true, 'LumiraDX', '95209-3', 'LumiraDx UK Ltd.', 'LumiraDx SARS-CoV-2 Ag Test*', null, 15);
INSERT INTO public.device_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, name, loinc_code, manufacturer, model, swab_type, test_length) VALUES ('9fe0c8a4-35f4-4951-82cf-4cc12fe3eef5', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', true, 'a', 'd', 'b', 'c', null, 15);
INSERT INTO public.device_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, name, loinc_code, manufacturer, model, swab_type, test_length) VALUES ('1d37a7f8-c2b2-4a98-8845-dc8dc1df705e', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', true, 'Quidel Sofia 2', '95209-3', 'Quidel', 'Sofia 2 SARS Antigen FIA', null, 15);
INSERT INTO public.device_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, name, loinc_code, manufacturer, model, swab_type, test_length) VALUES ('b578b0b7-e407-4851-a819-b143880c8cab', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', true, 'ZAP', 'ZAP', 'ZAP', 'ZAP', null, 15);
INSERT INTO public.device_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, name, loinc_code, manufacturer, model, swab_type, test_length) VALUES ('cb627ebe-77ad-41bc-a764-1291c536232e', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, 'GeneXpert Xpress (RT-PCR)', '94500-6', 'Cepheid', 'Xpert Xpress SARS-CoV-2', null, 15);
INSERT INTO public.device_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, name, loinc_code, manufacturer, model, swab_type, test_length) VALUES ('49f81a3f-b800-4c04-87f6-77013d9ba47f', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, 'Celltrion DiaTrust (Antigen)', '95209-3', 'Celltrion USA, Inc.', 'Celltrion DiaTrust COVID-19 Ag Rapid Test*', null, 15);
INSERT INTO public.device_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, name, loinc_code, manufacturer, model, swab_type, test_length) VALUES ('c6ba3015-b26d-4eab-9fb7-ecbf33e83f3f', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, 'Quidel Solana SARS-CoV2 Assay (RT-HDA)', '94500-6', 'Quidel Corporation', 'Solana SARS-CoV-2 Assay*', null, 15);
INSERT INTO public.device_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, name, loinc_code, manufacturer, model, swab_type, test_length) VALUES ('74a6d80f-e62a-400c-b285-0127f2aa6001', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, 'GenBody COVID-19 Test (Antigen)', '97097-0', 'GenBody Inc.', 'GenBody COVID-19 Ag*', null, 15);
INSERT INTO public.device_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, name, loinc_code, manufacturer, model, swab_type, test_length) VALUES ('40bd2032-0a75-42d2-a704-be9fce08fa6a', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, 'InBios Detect Rapid Test (Antigen)', '95209-3', 'InBios International, Inc.', 'SCoV-2 Ag Detect Rapid Test', null, 15);
INSERT INTO public.device_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, name, loinc_code, manufacturer, model, swab_type, test_length) VALUES ('0ea444b0-c8a2-4f25-a4d1-448dd6d45cdc', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, 'Clip Covid Rapid Test (Antigen)', '94558-4', 'Luminostics, Inc.', 'Clip COVID Rapid Antigen Test*', null, 15);
INSERT INTO public.device_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, name, loinc_code, manufacturer, model, swab_type, test_length) VALUES ('6efcfaaa-4cb9-40c4-a48c-cb5db894d83e', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, 'Panther Fusion SARS-CoV-2 (RT-PCR)', '94559-2', 'Hologic', 'Panther Fusion SARS-CoV-2 Assay', null, 15);
INSERT INTO public.device_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, name, loinc_code, manufacturer, model, swab_type, test_length) VALUES ('cd3eb131-5215-46bb-98d6-b620775f5aba', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, 'LumiraDX (Antigen)', '95209-3', 'LumiraDx UK Ltd.', 'LumiraDx SARS-CoV-2 Ag Test*', null, 15);
INSERT INTO public.device_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, name, loinc_code, manufacturer, model, swab_type, test_length) VALUES ('f3b3e5aa-cf0f-46e1-b1e3-9db682a9217a', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, 'LifeSign Status COVID-19/Flu (Antigen)', '95209-3', 'Princeton BioMeditech Corp.', 'Status COVID-19/Flu*', null, 15);
INSERT INTO public.device_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, name, loinc_code, manufacturer, model, swab_type, test_length) VALUES ('147a1985-9474-4fce-9dfd-4a5f0d56da5d', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', true, 'Abbott BinaxNow Rapid Antigen', '94558-4', 'Abbott', 'BinaxNOW COVID-19 Ag Card', null, 15);
INSERT INTO public.device_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, name, loinc_code, manufacturer, model, swab_type, test_length) VALUES ('e1d5a27f-d3eb-4be1-8196-5c4b69a19ce1', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, 'Roche Cobas Liat (RT-PCR)', '94500-6', 'Roche Molecular Systems', 'cobas SARS-CoV-2 Nucleic acid test for use on the cobas Liat System (cobas SARS-CoV-2)*', null, 15);
INSERT INTO public.device_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, name, loinc_code, manufacturer, model, swab_type, test_length) VALUES ('6adcbf4f-c8d3-4d05-8fde-6de31e56c0b6', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, 'Abbott BinaxNOW (Antigen)', '94558-4', 'Abbott', 'BinaxNOW COVID-19 Ag Card', null, 15);
INSERT INTO public.device_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, name, loinc_code, manufacturer, model, swab_type, test_length) VALUES ('741a9bff-1ce8-4154-84ab-db942ccc3c55', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, 'Quidel Quick Vue Rapids (Antigen)', '95209-3', 'Quidel', 'QuickVue SARS Antigen Test*', null, 15);
INSERT INTO public.device_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, name, loinc_code, manufacturer, model, swab_type, test_length) VALUES ('0446bc22-f329-494d-9fe1-872fce1b9a11', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, 'Abbott ID NOW (NAAT)', '94534-5', 'Abbott', 'ID Now', null, 15);
INSERT INTO public.device_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, name, loinc_code, manufacturer, model, swab_type, test_length) VALUES ('76695671-ae9a-448f-8678-253c00c7e3ba', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, 'Sofia SARS FIA (Antigen)', '95209-3', 'Quidel', 'Sofia SARS Antigen FIA', null, 15);
INSERT INTO public.device_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, name, loinc_code, manufacturer, model, swab_type, test_length) VALUES ('6e1a4f30-f442-4f3d-8b32-28498566e290', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, 'Lucira CHECK-IT (RT-LAMP)', '96986-5', 'Lucira Health, Inc.', 'Lucira CHECK-IT COVID-19 Test Kit*', null, 15);
INSERT INTO public.device_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, name, loinc_code, manufacturer, model, swab_type, test_length) VALUES ('4107a5d8-c5db-410e-9a11-bca2296893ba', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, 'Access Bio CareStart (Antigen)', '94558-4', 'Access Bio, Inc.', 'CareStart COVID-19 Antigen test*', null, 10);
INSERT INTO public.device_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, name, loinc_code, manufacturer, model, swab_type, test_length) VALUES ('ea9e4867-a628-492a-930b-7c1c30ce4217', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, 'Cepheid Xpert Xpress (RT-PCR)', '94500-6', 'Cepheid', 'Xpert Xpress SARS-CoV-2', null, 15);
INSERT INTO public.device_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, name, loinc_code, manufacturer, model, swab_type, test_length) VALUES ('8c39122d-b611-4276-b84c-759de806ccda', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, 'Quidel QuickVue OTC (Antigen)', '95209-3', 'Quidel Corporation', 'QuickVue At-Home OTC COVID-19 Test*', null, 15);
INSERT INTO public.device_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, name, loinc_code, manufacturer, model, swab_type, test_length) VALUES ('cee545a9-2fa2-4bd3-be63-c3a457bb9aba', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, 'Luminex Aries (RT-PCR)', '94759-8', 'Luminex Corporation', 'ARIES SARS-CoV-2 Assay', null, 15);
INSERT INTO public.device_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, name, loinc_code, manufacturer, model, swab_type, test_length) VALUES ('ad3662f3-692d-462f-a803-012879a0dbff', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, 'Ellume COVID-19 Home Test (Antigen)', '95209-3', 'Ellume Limited', 'Ellume COVID-19 Home Test_Ellume Limited*', null, 15);
INSERT INTO public.device_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, name, loinc_code, manufacturer, model, swab_type, test_length) VALUES ('fbe2183e-0f61-4ab5-928f-a531bbe4756b', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, 'Accula SARS-CoV2 Rapid PCR Test (RT-PCR)', '95409-9', 'Mesa Biotech', 'Accula SARS-Cov-2 Test*', null, 15);
INSERT INTO public.device_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, name, loinc_code, manufacturer, model, swab_type, test_length) VALUES ('83833678-3154-418e-9f97-464b8e13a4eb', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, 'Testinator9000', '456', 'ClydeWorks', '123', null, 15);
INSERT INTO public.device_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, name, loinc_code, manufacturer, model, swab_type, test_length) VALUES ('9ad258d7-8aa6-45b5-ba44-9fcee56c98fa', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, 'Clarity Rapid Test Cassette (Antigen)', '95209-3', 'Salofa Oy', 'Sienna-Clarity COVID-19 Antigen Rapid Test Cassette*', null, 15);
INSERT INTO public.device_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, name, loinc_code, manufacturer, model, swab_type, test_length) VALUES ('d40b28db-07a2-4568-8916-7d1ed3e6602d', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, 'Cue Rapid Test (NAAT)', '95409-9', 'Cue Health', 'Cue COVID-19 Test', null, 15);
INSERT INTO public.device_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, name, loinc_code, manufacturer, model, swab_type, test_length) VALUES ('9df8d8a1-50ff-4775-bdeb-c105b1850695', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, 'BD Veritor SARS-CoV-2 Plus System (Antigen)', '94558-4', 'Becton, Dickinson and Company (BD)', 'BD Veritor System for Rapid Detection of SARS-CoV-2*', null, 15);
INSERT INTO public.device_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, name, loinc_code, manufacturer, model, swab_type, test_length) VALUES ('cefa6607-96c2-4776-b2bc-7e4715055ee6', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, 'CDC Influenza SARS-CoV-2 Multiplex Assay (RT-PCR)', '95423-0', 'Centers for Disease Control and Prevention (CDC)', 'Influenza SARS-CoV-2 (Flu SC2) Multiplex Assay*', null, 15);
INSERT INTO public.device_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, name, loinc_code, manufacturer, model, swab_type, test_length) VALUES ('a72e8edb-bb54-47b1-83ed-938aaed01122', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, 'Abbott Alinity M (RT-PCR)', '94500-6', 'Abbott', 'Alinity m', null, 15);
INSERT INTO public.device_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, name, loinc_code, manufacturer, model, swab_type, test_length) VALUES ('88a10a93-295e-4b06-841c-ab479ae360c3', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, 'BioFire Torch RP 2.1 (RT-PCR)', '94565-9', 'BioFire Diagnostics', 'BioFire Respiratory Panel 2.1 (RP2.1)*@', null, 15);
INSERT INTO public.device_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, name, loinc_code, manufacturer, model, swab_type, test_length) VALUES ('78dc4d98-2958-43a3-a445-76ceef8c0698', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, 'BD Veritor System for Rapid Detection of SARS-CoV-2 & Flu A+B*', '97099-6', 'Becton, Dickinson and Company (BD)', 'BD Veritor System for Rapid Detection of SARS-CoV-2 & Flu A+B*', null, 15);
INSERT INTO public.device_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, name, loinc_code, manufacturer, model, swab_type, test_length) VALUES ('75c890b9-5f8b-43d5-931f-e9a11dfdb502', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, 'SuperDuper', '54565-1', 'SD Industries', 'SD', null, 15);
INSERT INTO public.device_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, name, loinc_code, manufacturer, model, swab_type, test_length) VALUES ('d8b6368f-5181-40fc-bafc-3780f06667f3', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, 'Quidel Sofia 2 (Antigen)', '95209-3', 'Quidel', 'Sofia 2 Flu + SARS Antigen FIA*', null, 15);
INSERT INTO public.device_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, name, loinc_code, manufacturer, model, swab_type, test_length) VALUES ('143fe92e-15a4-49b1-90ec-a83f0c7d5eac', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, 'Visby Point of Care Test (RT-PCR)', '94756-4', 'Visby Medical, Inc.', 'Visby Medical COVID-19 Point of Care Test*', null, 15);
INSERT INTO public.device_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, name, loinc_code, manufacturer, model, swab_type, test_length) VALUES ('442664e6-a5fe-4f38-aea8-54c1ea828542', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, 'test', 'test', '', 'test', null, 15);


INSERT INTO public.device_specimen_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, device_type_id, specimen_type_id) VALUES ('dce5871a-3c56-4361-b218-147cbba8e817', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, '63586bb5-3731-48bf-9c96-70ef225e3a86', 'a87855ab-8e48-4e14-94a5-d3d8c123e770');
INSERT INTO public.device_specimen_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, device_type_id, specimen_type_id) VALUES ('3b3c013c-13c4-4405-a8df-dee425314dda', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, '147a1985-9474-4fce-9dfd-4a5f0d56da5d', 'a87855ab-8e48-4e14-94a5-d3d8c123e770');
INSERT INTO public.device_specimen_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, device_type_id, specimen_type_id) VALUES ('5c69b4aa-c2d0-4218-8e58-273d44184816', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, '1d37a7f8-c2b2-4a98-8845-dc8dc1df705e', 'a87855ab-8e48-4e14-94a5-d3d8c123e770');
INSERT INTO public.device_specimen_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, device_type_id, specimen_type_id) VALUES ('a92654d1-e84a-4491-9402-dd8e2722c00b', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, '52bd6b1c-fc2c-4129-b56f-e4ea8c9422fd', 'a87855ab-8e48-4e14-94a5-d3d8c123e770');
INSERT INTO public.device_specimen_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, device_type_id, specimen_type_id) VALUES ('3f3bfdfc-a87d-463c-b049-47740b45a526', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, 'bca52816-b38d-4ef2-afbe-c5e573301f00', 'a87855ab-8e48-4e14-94a5-d3d8c123e770');
INSERT INTO public.device_specimen_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, device_type_id, specimen_type_id) VALUES ('b43f4739-5fe4-43cf-b61a-6491d2c26e72', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, '9fe0c8a4-35f4-4951-82cf-4cc12fe3eef5', 'f0ba9ee2-7bf1-4dd6-ba9e-8209ae89171c');
INSERT INTO public.device_specimen_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, device_type_id, specimen_type_id) VALUES ('5bdbee7e-2fbc-4f5c-ace6-aeec1c676050', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, 'b578b0b7-e407-4851-a819-b143880c8cab', '7bfd200b-ead7-43b2-a4f4-4557dacccecc');
INSERT INTO public.device_specimen_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, device_type_id, specimen_type_id) VALUES ('e1e4a551-3fa7-4fee-aa51-3a56a320b036', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, 'b86afd4f-98ee-4db4-bce8-0b738d3e72fc', '7bfd200b-ead7-43b2-a4f4-4557dacccecc');
INSERT INTO public.device_specimen_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, device_type_id, specimen_type_id) VALUES ('3110712f-37a4-4421-a8fe-22cd56c31559', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, 'b86afd4f-98ee-4db4-bce8-0b738d3e72fc', 'a87855ab-8e48-4e14-94a5-d3d8c123e770');
INSERT INTO public.device_specimen_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, device_type_id, specimen_type_id) VALUES ('ce061e3a-4d21-490a-8e9d-5eac5aab7dd1', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, '9df8d8a1-50ff-4775-bdeb-c105b1850695', 'ac5daed9-57af-4298-8b27-90b2f0ea56d1');
INSERT INTO public.device_specimen_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, device_type_id, specimen_type_id) VALUES ('03b6a1dc-f24b-43c9-a350-6856a44a8470', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, '0446bc22-f329-494d-9fe1-872fce1b9a11', 'ac5daed9-57af-4298-8b27-90b2f0ea56d1');
INSERT INTO public.device_specimen_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, device_type_id, specimen_type_id) VALUES ('45f0e688-4c82-48a3-b3c9-2cbef8609fd9', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, '6adcbf4f-c8d3-4d05-8fde-6de31e56c0b6', 'ac5daed9-57af-4298-8b27-90b2f0ea56d1');
INSERT INTO public.device_specimen_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, device_type_id, specimen_type_id) VALUES ('8af178e4-ade8-4c9f-83d8-24567836bba1', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, 'd8b6368f-5181-40fc-bafc-3780f06667f3', 'ac5daed9-57af-4298-8b27-90b2f0ea56d1');
INSERT INTO public.device_specimen_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, device_type_id, specimen_type_id) VALUES ('99f76ada-128a-47c7-8532-afd6a8bfce2f', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, 'cd3eb131-5215-46bb-98d6-b620775f5aba', 'ac5daed9-57af-4298-8b27-90b2f0ea56d1');
INSERT INTO public.device_specimen_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, device_type_id, specimen_type_id) VALUES ('de18b7ee-8f20-4fa6-b312-47446fb22962', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, '4107a5d8-c5db-410e-9a11-bca2296893ba', '8e07cba1-7a0f-42b7-ba36-df3bd1bf2e28');
INSERT INTO public.device_specimen_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, device_type_id, specimen_type_id) VALUES ('600800a5-870b-45fd-8ebe-08ca465e6eaa', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, 'd40b28db-07a2-4568-8916-7d1ed3e6602d', 'ac5daed9-57af-4298-8b27-90b2f0ea56d1');
INSERT INTO public.device_specimen_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, device_type_id, specimen_type_id) VALUES ('09b6e5dc-014c-41de-96b4-e11a7698e773', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, 'cb627ebe-77ad-41bc-a764-1291c536232e', 'ac5daed9-57af-4298-8b27-90b2f0ea56d1');
INSERT INTO public.device_specimen_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, device_type_id, specimen_type_id) VALUES ('9ab681d9-a2fc-4437-9e01-bf7febfa8494', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, '76695671-ae9a-448f-8678-253c00c7e3ba', '52a582e4-d389-42d0-b738-bee51cf5244d');
INSERT INTO public.device_specimen_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, device_type_id, specimen_type_id) VALUES ('770aef49-4d18-4528-b2b1-4d5d7c5d0675', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, 'fbe2183e-0f61-4ab5-928f-a531bbe4756b', 'ac5daed9-57af-4298-8b27-90b2f0ea56d1');
INSERT INTO public.device_specimen_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, device_type_id, specimen_type_id) VALUES ('8c81ea10-9ad5-447a-a63e-0cc49bb6f1f7', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, '88a10a93-295e-4b06-841c-ab479ae360c3', '8e07cba1-7a0f-42b7-ba36-df3bd1bf2e28');
INSERT INTO public.device_specimen_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, device_type_id, specimen_type_id) VALUES ('46017b1c-5afb-49cf-90b2-30260057ae4b', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, 'ea9e4867-a628-492a-930b-7c1c30ce4217', '52a582e4-d389-42d0-b738-bee51cf5244d');
INSERT INTO public.device_specimen_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, device_type_id, specimen_type_id) VALUES ('9778770d-2334-479d-8adf-e0f56d0bc6da', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, '741a9bff-1ce8-4154-84ab-db942ccc3c55', '52a582e4-d389-42d0-b738-bee51cf5244d');
INSERT INTO public.device_specimen_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, device_type_id, specimen_type_id) VALUES ('f47e72c8-ae62-4e3d-8d1f-367e41c51564', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, '9ad258d7-8aa6-45b5-ba44-9fcee56c98fa', '8e07cba1-7a0f-42b7-ba36-df3bd1bf2e28');
INSERT INTO public.device_specimen_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, device_type_id, specimen_type_id) VALUES ('9959c544-d078-42c8-a600-a7e6f7962ede', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, '143fe92e-15a4-49b1-90ec-a83f0c7d5eac', '52a582e4-d389-42d0-b738-bee51cf5244d');
INSERT INTO public.device_specimen_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, device_type_id, specimen_type_id) VALUES ('fc955748-25b4-4294-a428-eced787f9968', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, '6e1a4f30-f442-4f3d-8b32-28498566e290', '52a582e4-d389-42d0-b738-bee51cf5244d');
INSERT INTO public.device_specimen_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, device_type_id, specimen_type_id) VALUES ('bb94805e-443f-4670-a9a2-0ddb1b00d1a3', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, 'e1d5a27f-d3eb-4be1-8196-5c4b69a19ce1', '52a582e4-d389-42d0-b738-bee51cf5244d');
INSERT INTO public.device_specimen_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, device_type_id, specimen_type_id) VALUES ('8c66f2b0-e842-4ab7-82c1-0f6ed410d4ff', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, '8c39122d-b611-4276-b84c-759de806ccda', '52a582e4-d389-42d0-b738-bee51cf5244d');
INSERT INTO public.device_specimen_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, device_type_id, specimen_type_id) VALUES ('b949d608-3d82-4269-9a19-20c09c511c6d', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, 'f3b3e5aa-cf0f-46e1-b1e3-9db682a9217a', '8e07cba1-7a0f-42b7-ba36-df3bd1bf2e28');
INSERT INTO public.device_specimen_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, device_type_id, specimen_type_id) VALUES ('09b74098-6d1d-484d-a76e-6d47a0b58df6', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, 'ad3662f3-692d-462f-a803-012879a0dbff', '5dbd902d-6057-4a82-8286-a79363898766');
INSERT INTO public.device_specimen_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, device_type_id, specimen_type_id) VALUES ('41da16c5-f96e-47f3-8921-339206c77a20', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, 'a72e8edb-bb54-47b1-83ed-938aaed01122', 'ac5daed9-57af-4298-8b27-90b2f0ea56d1');
INSERT INTO public.device_specimen_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, device_type_id, specimen_type_id) VALUES ('715b6996-e742-4166-999b-f15305c22558', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, 'cee545a9-2fa2-4bd3-be63-c3a457bb9aba', '8e07cba1-7a0f-42b7-ba36-df3bd1bf2e28');
INSERT INTO public.device_specimen_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, device_type_id, specimen_type_id) VALUES ('dab60f53-27c8-4b97-9776-e7d1efcaebf2', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, '0ea444b0-c8a2-4f25-a4d1-448dd6d45cdc', 'ac5daed9-57af-4298-8b27-90b2f0ea56d1');
INSERT INTO public.device_specimen_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, device_type_id, specimen_type_id) VALUES ('e1e6103a-171a-42b7-ae2f-3042defe7bcd', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, '49f81a3f-b800-4c04-87f6-77013d9ba47f', '8e07cba1-7a0f-42b7-ba36-df3bd1bf2e28');
INSERT INTO public.device_specimen_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, device_type_id, specimen_type_id) VALUES ('b848126b-1ff6-4507-b214-c5a706fb6937', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, '6efcfaaa-4cb9-40c4-a48c-cb5db894d83e', '52a582e4-d389-42d0-b738-bee51cf5244d');
INSERT INTO public.device_specimen_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, device_type_id, specimen_type_id) VALUES ('e1e5ee87-9f90-4288-9400-82c1b053fa70', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, '6efcfaaa-4cb9-40c4-a48c-cb5db894d83e', '5dbd902d-6057-4a82-8286-a79363898766');
INSERT INTO public.device_specimen_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, device_type_id, specimen_type_id) VALUES ('30a3906b-c7ec-4336-a5c4-bf6018245129', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, '6efcfaaa-4cb9-40c4-a48c-cb5db894d83e', '8e07cba1-7a0f-42b7-ba36-df3bd1bf2e28');
INSERT INTO public.device_specimen_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, device_type_id, specimen_type_id) VALUES ('7b882ecb-847f-4754-bc35-ff17756f6566', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, 'cefa6607-96c2-4776-b2bc-7e4715055ee6', '8e07cba1-7a0f-42b7-ba36-df3bd1bf2e28');
INSERT INTO public.device_specimen_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, device_type_id, specimen_type_id) VALUES ('84d5a0df-1a8a-4b03-9241-07ed9b8735d1', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, 'cefa6607-96c2-4776-b2bc-7e4715055ee6', 'ac5daed9-57af-4298-8b27-90b2f0ea56d1');
INSERT INTO public.device_specimen_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, device_type_id, specimen_type_id) VALUES ('5d8ebdad-0733-4120-984b-bec62b826493', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, '40bd2032-0a75-42d2-a704-be9fce08fa6a', '52a582e4-d389-42d0-b738-bee51cf5244d');
INSERT INTO public.device_specimen_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, device_type_id, specimen_type_id) VALUES ('fbfa08df-385f-456d-b299-8a284dfc3409', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, '0446bc22-f329-494d-9fe1-872fce1b9a11', '8e07cba1-7a0f-42b7-ba36-df3bd1bf2e28');
INSERT INTO public.device_specimen_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, device_type_id, specimen_type_id) VALUES ('ac5f7fbc-a450-45d5-a33c-2079ee4ed26e', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, '0446bc22-f329-494d-9fe1-872fce1b9a11', '3530df5b-dde3-40eb-881c-b2c842affbfd');
INSERT INTO public.device_specimen_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, device_type_id, specimen_type_id) VALUES ('9bd440db-dd7f-459a-ab8b-8e4c4cd67ca7', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, '0446bc22-f329-494d-9fe1-872fce1b9a11', 'edf90158-df15-4e84-953e-2ca17c1c4ce4');
INSERT INTO public.device_specimen_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, device_type_id, specimen_type_id) VALUES ('ef3db3af-5d1f-4783-9b86-b6d8769faad3', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, '143fe92e-15a4-49b1-90ec-a83f0c7d5eac', '5dbd902d-6057-4a82-8286-a79363898766');
INSERT INTO public.device_specimen_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, device_type_id, specimen_type_id) VALUES ('82ed4f43-ef28-49c3-984d-60e2f0d10dd9', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, '143fe92e-15a4-49b1-90ec-a83f0c7d5eac', '8e07cba1-7a0f-42b7-ba36-df3bd1bf2e28');
INSERT INTO public.device_specimen_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, device_type_id, specimen_type_id) VALUES ('08b8a5e5-9150-4ff4-8549-2504c2d68a7e', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, '9df8d8a1-50ff-4775-bdeb-c105b1850695', '52a582e4-d389-42d0-b738-bee51cf5244d');
INSERT INTO public.device_specimen_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, device_type_id, specimen_type_id) VALUES ('4cdd7002-5530-4222-96e6-9efcd282a6f2', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, '4107a5d8-c5db-410e-9a11-bca2296893ba', '52a582e4-d389-42d0-b738-bee51cf5244d');
INSERT INTO public.device_specimen_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, device_type_id, specimen_type_id) VALUES ('aefaa3d9-0dc0-4413-8238-c9586076db90', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, 'cb627ebe-77ad-41bc-a764-1291c536232e', '8e07cba1-7a0f-42b7-ba36-df3bd1bf2e28');
INSERT INTO public.device_specimen_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, device_type_id, specimen_type_id) VALUES ('8ef9756b-f3ba-46d7-a9b0-f9f38ad34564', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, 'cb627ebe-77ad-41bc-a764-1291c536232e', '3530df5b-dde3-40eb-881c-b2c842affbfd');
INSERT INTO public.device_specimen_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, device_type_id, specimen_type_id) VALUES ('f99ab1ef-a6c4-4c0c-99c5-88303f622eb8', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, 'cb627ebe-77ad-41bc-a764-1291c536232e', '5dbd902d-6057-4a82-8286-a79363898766');
INSERT INTO public.device_specimen_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, device_type_id, specimen_type_id) VALUES ('e5c58b8c-479a-4bb1-8241-9fb08c9a8640', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, 'cb627ebe-77ad-41bc-a764-1291c536232e', '6e7d09b2-ad17-425b-99ac-3b5fc872496b');
INSERT INTO public.device_specimen_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, device_type_id, specimen_type_id) VALUES ('5310ff37-8f15-4fb6-b840-b25639badbac', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, 'd8b6368f-5181-40fc-bafc-3780f06667f3', '8e07cba1-7a0f-42b7-ba36-df3bd1bf2e28');
INSERT INTO public.device_specimen_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, device_type_id, specimen_type_id) VALUES ('a8809f67-240a-4a51-9075-1134ed4e2091', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, 'ea9e4867-a628-492a-930b-7c1c30ce4217', '8e07cba1-7a0f-42b7-ba36-df3bd1bf2e28');
INSERT INTO public.device_specimen_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, device_type_id, specimen_type_id) VALUES ('ed7b35ed-ef57-49f4-aaec-241e3b5e47fc', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, 'ea9e4867-a628-492a-930b-7c1c30ce4217', '3530df5b-dde3-40eb-881c-b2c842affbfd');
INSERT INTO public.device_specimen_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, device_type_id, specimen_type_id) VALUES ('19d3fcf5-2c2f-41ba-b362-54b3f40e44d4', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, 'ea9e4867-a628-492a-930b-7c1c30ce4217', '5dbd902d-6057-4a82-8286-a79363898766');
INSERT INTO public.device_specimen_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, device_type_id, specimen_type_id) VALUES ('3e5d5b98-4745-44ec-8936-73070dff33d2', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, 'ea9e4867-a628-492a-930b-7c1c30ce4217', '6e7d09b2-ad17-425b-99ac-3b5fc872496b');
INSERT INTO public.device_specimen_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, device_type_id, specimen_type_id) VALUES ('ed2da31d-4545-4014-bea5-2cfcbd2431a1', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, 'ea9e4867-a628-492a-930b-7c1c30ce4217', '532243d7-f04d-4d5b-a5a6-07132e31b7f2');
INSERT INTO public.device_specimen_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, device_type_id, specimen_type_id) VALUES ('70f6a2d0-be89-4007-b8a8-f1d7be9079ab', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, 'e1d5a27f-d3eb-4be1-8196-5c4b69a19ce1', '5dbd902d-6057-4a82-8286-a79363898766');
INSERT INTO public.device_specimen_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, device_type_id, specimen_type_id) VALUES ('02fa032a-afff-49ff-ba42-4e545100090f', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, 'e1d5a27f-d3eb-4be1-8196-5c4b69a19ce1', '8e07cba1-7a0f-42b7-ba36-df3bd1bf2e28');
INSERT INTO public.device_specimen_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, device_type_id, specimen_type_id) VALUES ('4f527fda-54be-410d-877e-f14274a6a032', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, 'a72e8edb-bb54-47b1-83ed-938aaed01122', '52a582e4-d389-42d0-b738-bee51cf5244d');
INSERT INTO public.device_specimen_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, device_type_id, specimen_type_id) VALUES ('96a664c8-5ea0-4be9-8727-7d4a4efd352a', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, 'a72e8edb-bb54-47b1-83ed-938aaed01122', '5dbd902d-6057-4a82-8286-a79363898766');
INSERT INTO public.device_specimen_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, device_type_id, specimen_type_id) VALUES ('1a79d9fb-22c9-4d4d-8daf-cf6927b6d480', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, 'a72e8edb-bb54-47b1-83ed-938aaed01122', 'edf90158-df15-4e84-953e-2ca17c1c4ce4');
INSERT INTO public.device_specimen_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, device_type_id, specimen_type_id) VALUES ('0f50f0ea-78fa-412b-963d-a462c2023fb2', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, 'a72e8edb-bb54-47b1-83ed-938aaed01122', '8e07cba1-7a0f-42b7-ba36-df3bd1bf2e28');
INSERT INTO public.device_specimen_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, device_type_id, specimen_type_id) VALUES ('d6c8f49a-d368-4bf0-87e1-f685a5a10078', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, 'a72e8edb-bb54-47b1-83ed-938aaed01122', '3530df5b-dde3-40eb-881c-b2c842affbfd');
INSERT INTO public.device_specimen_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, device_type_id, specimen_type_id) VALUES ('68f06a59-eaf1-44ba-9965-0d162d473a45', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, 'a72e8edb-bb54-47b1-83ed-938aaed01122', '5676e5f1-84c2-471e-aa81-1ae28a9dd116');
INSERT INTO public.device_specimen_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, device_type_id, specimen_type_id) VALUES ('d81b5a6c-fa72-412f-be92-59752ae67a00', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, 'd40b28db-07a2-4568-8916-7d1ed3e6602d', '52a582e4-d389-42d0-b738-bee51cf5244d');
INSERT INTO public.device_specimen_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, device_type_id, specimen_type_id) VALUES ('889680e3-cd50-4d8f-a702-9ecb47d0a724', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, '6efcfaaa-4cb9-40c4-a48c-cb5db894d83e', '3530df5b-dde3-40eb-881c-b2c842affbfd');
INSERT INTO public.device_specimen_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, device_type_id, specimen_type_id) VALUES ('e7b4c231-5c20-4f5b-83f5-5b1dbee23e65', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, '6efcfaaa-4cb9-40c4-a48c-cb5db894d83e', 'edf90158-df15-4e84-953e-2ca17c1c4ce4');
INSERT INTO public.device_specimen_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, device_type_id, specimen_type_id) VALUES ('0914d7d0-d1d8-4ede-ba23-56e6c41547ce', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, '6efcfaaa-4cb9-40c4-a48c-cb5db894d83e', 'a7d90b81-b531-4885-87d0-af041eb8c338');
INSERT INTO public.device_specimen_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, device_type_id, specimen_type_id) VALUES ('a4c4098f-5013-479a-bbae-07918c6af15f', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, '6efcfaaa-4cb9-40c4-a48c-cb5db894d83e', '5676e5f1-84c2-471e-aa81-1ae28a9dd116');
INSERT INTO public.device_specimen_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, device_type_id, specimen_type_id) VALUES ('2f96dac9-45ca-404d-a4f5-c880b1a584ff', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, 'fbe2183e-0f61-4ab5-928f-a531bbe4756b', '5dbd902d-6057-4a82-8286-a79363898766');
INSERT INTO public.device_specimen_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, device_type_id, specimen_type_id) VALUES ('591a9d7a-308e-4a5f-b8e4-32f04d480862', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, 'cefa6607-96c2-4776-b2bc-7e4715055ee6', '3530df5b-dde3-40eb-881c-b2c842affbfd');
INSERT INTO public.device_specimen_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, device_type_id, specimen_type_id) VALUES ('81326db4-42dd-4569-8763-872f0db1e978', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, 'cefa6607-96c2-4776-b2bc-7e4715055ee6', '65304a1a-491f-4532-a362-7712f33d3b26');
INSERT INTO public.device_specimen_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, device_type_id, specimen_type_id) VALUES ('93690be2-dd90-466d-be64-8bbbd12a28ee', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, 'cefa6607-96c2-4776-b2bc-7e4715055ee6', '553de536-69e9-4c9d-a6ee-7b38fadeb970');
INSERT INTO public.device_specimen_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, device_type_id, specimen_type_id) VALUES ('3247a6ab-8a8b-40d1-a3af-94634ce75b2b', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, 'cefa6607-96c2-4776-b2bc-7e4715055ee6', '5676e5f1-84c2-471e-aa81-1ae28a9dd116');
INSERT INTO public.device_specimen_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, device_type_id, specimen_type_id) VALUES ('e59699e9-295e-46bf-aa6e-7046450a3e58', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, 'cefa6607-96c2-4776-b2bc-7e4715055ee6', 'a7d90b81-b531-4885-87d0-af041eb8c338');
INSERT INTO public.device_specimen_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, device_type_id, specimen_type_id) VALUES ('b4532c79-5cdf-4866-8ff6-53026e28f6ab', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, 'cefa6607-96c2-4776-b2bc-7e4715055ee6', '6e7d09b2-ad17-425b-99ac-3b5fc872496b');
INSERT INTO public.device_specimen_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, device_type_id, specimen_type_id) VALUES ('01c6a31a-a7ef-4e87-84e6-fa849184159e', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, '74a6d80f-e62a-400c-b285-0127f2aa6001', '8e07cba1-7a0f-42b7-ba36-df3bd1bf2e28');
INSERT INTO public.device_specimen_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, device_type_id, specimen_type_id) VALUES ('ca71d807-5a48-4e2e-8986-03373fad3eeb', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, 'c6ba3015-b26d-4eab-9fb7-ecbf33e83f3f', 'ac5daed9-57af-4298-8b27-90b2f0ea56d1');
INSERT INTO public.device_specimen_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, device_type_id, specimen_type_id) VALUES ('51d7c37e-0beb-4371-b650-b1e716b61e36', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, 'c6ba3015-b26d-4eab-9fb7-ecbf33e83f3f', '8e07cba1-7a0f-42b7-ba36-df3bd1bf2e28');
INSERT INTO public.device_specimen_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, device_type_id, specimen_type_id) VALUES ('3564c7ce-0d25-4a9b-826f-a3089892e411', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, '07c59c0c-81ad-4bed-b708-f669d9b9dafc', '8e07cba1-7a0f-42b7-ba36-df3bd1bf2e28');
INSERT INTO public.device_specimen_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, device_type_id, specimen_type_id) VALUES ('da0ea689-93da-4017-9f32-5f4b12a55ae8', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, '83833678-3154-418e-9f97-464b8e13a4eb', '52a582e4-d389-42d0-b738-bee51cf5244d');
INSERT INTO public.device_specimen_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, device_type_id, specimen_type_id) VALUES ('33a1f96d-894c-4421-a4e4-75f294430912', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, '78dc4d98-2958-43a3-a445-76ceef8c0698', '52a582e4-d389-42d0-b738-bee51cf5244d');
INSERT INTO public.device_specimen_type (internal_id, created_at, created_by, updated_at, updated_by, is_deleted, device_type_id, specimen_type_id) VALUES ('59adee60-ed8c-4a21-8f2f-985a2e556c05', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', '2022-08-19 11:58:17.000000', 'change-me-to-valid-id', false, '75c890b9-5f8b-43d5-931f-e9a11dfdb502', '52a582e4-d389-42d0-b738-bee51cf5244d');

GraphQL (manual) seeding

You'll need to manually create several database objects to seed the database.

  1. Give yourself superadmin rights in the environment you want to seed.
  • Okta Preview -> Admin -> People -> your account -> Groups -> Add "SR-DEV5-ADMIN" (or whichever env you're working in)
  1. Run the mutation to add specimen types
mutation {
  createSpecimenType(
    input: {
      name: "Nasal Aspirates"
      typeCode: "429931000124105"
      collectionLocationName: ""
      collectionLocationCode: ""
    }
  ) {
    internalId
    name
    }
}
  1. Create a device using the superadmin UI in the environment.
  1. Create a new organization
  • dev5.simplereport.gov/app/sign-up
  • Don't use your existing SimpleReport email - use something like [email protected]. You won't need access to this user once the organization is created anyway. You only need to complete the first page of the form, not the "personal details" page.

  1. Going back to the superadmin page, verify the newly-created organization.

  2. Back in Okta, assign yourself to the newly created organization by assigning yourself to the new groups, ex. SR-DEV5-TENANT:AZ-Dis-Organization-ca1d56d4-2ae0-4958-bae7-7f93f8078c3a:ADMIN. Add yourself to both the ADMIN and NO_ACCESS versions of these groups.

  • If you really want to make friends and influence people, add your fellow engineers to these new groups too. They'll be happy 😄
  1. Head back to SimpleReport (refresh your creds if necessary) and create a new facility

That's it! You'll also need to make patient records, or that can be done by individuals as they work in the environment.