--DROP TABLE DGC_TypeofTest_VS CASCADE; CREATE TABLE DGC_TypeofTest_VS ( DGC_TypeofTest_VS_id int NOT NULL PRIMARY KEY, code varchar(255) NOT NULL, codeSystem varchar(255) NOT NULL, displayName varchar(255) NOT NULL ); INSERT INTO DGC_TypeofTest_VS (DGC_TypeofTest_VS_id, code, codeSystem, displayName) VALUES (1, '96121-9', '2.16.840.1.113883.6.1', 'SARS-CoV-2 E-Gen ql. /BAL PCR'); INSERT INTO DGC_TypeofTest_VS (DGC_TypeofTest_VS_id, code, codeSystem, displayName) VALUES (2, '94315-9', '2.16.840.1.113883.6.1', 'SARS-CoV-2 E-Gen ql. /Material n. spez. PCR'); INSERT INTO DGC_TypeofTest_VS (DGC_TypeofTest_VS_id, code, codeSystem, displayName) VALUES (3, '96122-7', '2.16.840.1.113883.6.1', 'SARS-CoV-2 E-Gen ql. /NP PCR'); INSERT INTO DGC_TypeofTest_VS (DGC_TypeofTest_VS_id, code, codeSystem, displayName) VALUES (4, '96120-1', '2.16.840.1.113883.6.1', 'SARS-CoV-2 RdRP-Gen ql. /BAL PCR'); INSERT INTO DGC_TypeofTest_VS (DGC_TypeofTest_VS_id, code, codeSystem, displayName) VALUES (5, '94314-2', '2.16.840.1.113883.6.1', 'SARS-CoV-2 RdRP-Gen ql. /Material n. spez. PCR'); INSERT INTO DGC_TypeofTest_VS (DGC_TypeofTest_VS_id, code, codeSystem, displayName) VALUES (6, '96123-5', '2.16.840.1.113883.6.1', 'SARS-CoV-2 RdRP-Gen ql. /NP PCR'); INSERT INTO DGC_TypeofTest_VS (DGC_TypeofTest_VS_id, code, codeSystem, displayName) VALUES (7, '94309-2', '2.16.840.1.113883.6.1', 'SARS-CoV-2-RNA ql. /Material n. spez. PCR'); INSERT INTO DGC_TypeofTest_VS (DGC_TypeofTest_VS_id, code, codeSystem, displayName) VALUES (8, '94759-8', '2.16.840.1.113883.6.1', 'SARS-CoV-2-RNA ql. /NP PCR'); INSERT INTO DGC_TypeofTest_VS (DGC_TypeofTest_VS_id, code, codeSystem, displayName) VALUES (9, '94845-5', '2.16.840.1.113883.6.1', 'SARS-CoV-2-RNA ql. /OF PCR'); INSERT INTO DGC_TypeofTest_VS (DGC_TypeofTest_VS_id, code, codeSystem, displayName) VALUES (10, '94500-6', '2.16.840.1.113883.6.1', 'SARS-CoV-2-RNA ql. /RT PCR'); INSERT INTO DGC_TypeofTest_VS (DGC_TypeofTest_VS_id, code, codeSystem, displayName) VALUES (11, '94746-5', '2.16.840.1.113883.6.1', 'SARS-CoV-2-RNA /Material n. spez. PCR'); INSERT INTO DGC_TypeofTest_VS (DGC_TypeofTest_VS_id, code, codeSystem, displayName) VALUES (12, '94745-7', '2.16.840.1.113883.6.1', 'SARS-CoV-2-RNA /RT PCR'); INSERT INTO DGC_TypeofTest_VS (DGC_TypeofTest_VS_id, code, codeSystem, displayName) VALUES (13, '94507-1', '2.16.840.1.113883.6.1', 'SARS-CoV-2 Antikörper IgG Schnelltest'); INSERT INTO DGC_TypeofTest_VS (DGC_TypeofTest_VS_id, code, codeSystem, displayName) VALUES (14, '94508-9', '2.16.840.1.113883.6.1', 'SARS-CoV-2-AK IgM ql.'); INSERT INTO DGC_TypeofTest_VS (DGC_TypeofTest_VS_id, code, codeSystem, displayName) VALUES (15, '94558-4', '2.16.840.1.113883.6.1', 'SARS-CoV-2 Antigen qualitativ Schnelltest'); INSERT INTO DGC_TypeofTest_VS (DGC_TypeofTest_VS_id, code, codeSystem, displayName) VALUES (16, '96119-3', '2.16.840.1.113883.6.1', 'SARS-CoV-2 (COVID-19) Ag [Presence] in Upper respiratory specimen by Immunoassay'); INSERT INTO DGC_TypeofTest_VS (DGC_TypeofTest_VS_id, code, codeSystem, displayName) VALUES (17, '94547-7', '2.16.840.1.113883.6.1', 'SARS-CoV-2 AK IgG+IgM qualitativ'); INSERT INTO DGC_TypeofTest_VS (DGC_TypeofTest_VS_id, code, codeSystem, displayName) VALUES (18, '94563-4', '2.16.840.1.113883.6.1', 'SARS-CoV-2 Antikörper IgG qualitativ'); INSERT INTO DGC_TypeofTest_VS (DGC_TypeofTest_VS_id, code, codeSystem, displayName) VALUES (19, '94505-5', '2.16.840.1.113883.6.1', 'SARS-CoV-2 Antikörper IgG'); INSERT INTO DGC_TypeofTest_VS (DGC_TypeofTest_VS_id, code, codeSystem, displayName) VALUES (20, '94769-7', '2.16.840.1.113883.6.1', 'SARS-CoV-2-AK'); INSERT INTO DGC_TypeofTest_VS (DGC_TypeofTest_VS_id, code, codeSystem, displayName) VALUES (21, '94562-6', '2.16.840.1.113883.6.1', 'SARS-CoV-2-AK IgA ql.'); INSERT INTO DGC_TypeofTest_VS (DGC_TypeofTest_VS_id, code, codeSystem, displayName) VALUES (22, '94762-2', '2.16.840.1.113883.6.1', 'SARS-CoV-2-AK ql.'); INSERT INTO DGC_TypeofTest_VS (DGC_TypeofTest_VS_id, code, codeSystem, displayName) VALUES (23, '94506-3', '2.16.840.1.113883.6.1', 'SARS-CoV-2-AK IgM');