--DROP TABLE ELGA_MedikationMengenart_VS CASCADE; CREATE TABLE ELGA_MedikationMengenart_VS ( ELGA_MedikationMengenart_VS_id int NOT NULL PRIMARY KEY, code varchar(255) NOT NULL, codeSystem varchar(255) NOT NULL, displayName varchar(255) NOT NULL ); INSERT INTO ELGA_MedikationMengenart_VS (ELGA_MedikationMengenart_VS_id, code, codeSystem, displayName) VALUES (1, '%', '2.16.840.1.113883.6.8', 'Percent'); INSERT INTO ELGA_MedikationMengenart_VS (ELGA_MedikationMengenart_VS_id, code, codeSystem, displayName) VALUES (2, '/d', '2.16.840.1.113883.6.8', 'PerDay'); INSERT INTO ELGA_MedikationMengenart_VS (ELGA_MedikationMengenart_VS_id, code, codeSystem, displayName) VALUES (3, '/g', '2.16.840.1.113883.6.8', 'PerGram'); INSERT INTO ELGA_MedikationMengenart_VS (ELGA_MedikationMengenart_VS_id, code, codeSystem, displayName) VALUES (4, '/h', '2.16.840.1.113883.6.8', 'PerHour'); INSERT INTO ELGA_MedikationMengenart_VS (ELGA_MedikationMengenart_VS_id, code, codeSystem, displayName) VALUES (5, '/kg', '2.16.840.1.113883.6.8', 'PerKiloGram'); INSERT INTO ELGA_MedikationMengenart_VS (ELGA_MedikationMengenart_VS_id, code, codeSystem, displayName) VALUES (6, '/kg{body`wt}', '2.16.840.1.113883.6.8', 'PerKiloGramBodyWeight'); INSERT INTO ELGA_MedikationMengenart_VS (ELGA_MedikationMengenart_VS_id, code, codeSystem, displayName) VALUES (7, '/min', '2.16.840.1.113883.6.8', 'PerMinute'); INSERT INTO ELGA_MedikationMengenart_VS (ELGA_MedikationMengenart_VS_id, code, codeSystem, displayName) VALUES (8, '/s', '2.16.840.1.113883.6.8', 'PerSecond'); INSERT INTO ELGA_MedikationMengenart_VS (ELGA_MedikationMengenart_VS_id, code, codeSystem, displayName) VALUES (9, '1', '2.16.840.1.113883.6.8', 'Unit'); INSERT INTO ELGA_MedikationMengenart_VS (ELGA_MedikationMengenart_VS_id, code, codeSystem, displayName) VALUES (10, 'a', '2.16.840.1.113883.6.8', 'Year'); INSERT INTO ELGA_MedikationMengenart_VS (ELGA_MedikationMengenart_VS_id, code, codeSystem, displayName) VALUES (11, 'bar', '2.16.840.1.113883.6.8', 'Bar'); INSERT INTO ELGA_MedikationMengenart_VS (ELGA_MedikationMengenart_VS_id, code, codeSystem, displayName) VALUES (12, 'cal', '2.16.840.1.113883.6.8', 'Calorie'); INSERT INTO ELGA_MedikationMengenart_VS (ELGA_MedikationMengenart_VS_id, code, codeSystem, displayName) VALUES (13, 'cal/d', '2.16.840.1.113883.6.8', 'CaloriesPerDay'); INSERT INTO ELGA_MedikationMengenart_VS (ELGA_MedikationMengenart_VS_id, code, codeSystem, displayName) VALUES (14, 'cal/g', '2.16.840.1.113883.6.8', 'CaloriesPerGram'); INSERT INTO ELGA_MedikationMengenart_VS (ELGA_MedikationMengenart_VS_id, code, codeSystem, displayName) VALUES (15, 'cal/h', '2.16.840.1.113883.6.8', 'CaloriesPerHour'); INSERT INTO ELGA_MedikationMengenart_VS (ELGA_MedikationMengenart_VS_id, code, codeSystem, displayName) VALUES (16, 'cal/mL', '2.16.840.1.113883.6.8', 'CaloriesPerMilliLiter'); INSERT INTO ELGA_MedikationMengenart_VS (ELGA_MedikationMengenart_VS_id, code, codeSystem, displayName) VALUES (17, 'Cel', '2.16.840.1.113883.6.8', 'DegreeCelsius'); INSERT INTO ELGA_MedikationMengenart_VS (ELGA_MedikationMengenart_VS_id, code, codeSystem, displayName) VALUES (18, 'cm', '2.16.840.1.113883.6.8', 'CentiMeter'); INSERT INTO ELGA_MedikationMengenart_VS (ELGA_MedikationMengenart_VS_id, code, codeSystem, displayName) VALUES (19, 'cm2', '2.16.840.1.113883.6.8', 'SquareCentimeter'); INSERT INTO ELGA_MedikationMengenart_VS (ELGA_MedikationMengenart_VS_id, code, codeSystem, displayName) VALUES (20, 'cm3', '2.16.840.1.113883.6.8', 'CubicCentimeter'); INSERT INTO ELGA_MedikationMengenart_VS (ELGA_MedikationMengenart_VS_id, code, codeSystem, displayName) VALUES (21, 'd', '2.16.840.1.113883.6.8', 'Day'); INSERT INTO ELGA_MedikationMengenart_VS (ELGA_MedikationMengenart_VS_id, code, codeSystem, displayName) VALUES (22, 'g', '2.16.840.1.113883.6.8', 'Gram'); INSERT INTO ELGA_MedikationMengenart_VS (ELGA_MedikationMengenart_VS_id, code, codeSystem, displayName) VALUES (23, 'g/kg', '2.16.840.1.113883.6.8', 'GramsPerKiloGram'); INSERT INTO ELGA_MedikationMengenart_VS (ELGA_MedikationMengenart_VS_id, code, codeSystem, displayName) VALUES (24, 'g/L', '2.16.840.1.113883.6.8', 'GramsPerLiter'); INSERT INTO ELGA_MedikationMengenart_VS (ELGA_MedikationMengenart_VS_id, code, codeSystem, displayName) VALUES (25, 'g/mL', '2.16.840.1.113883.6.8', 'GramsPerMilliliter'); INSERT INTO ELGA_MedikationMengenart_VS (ELGA_MedikationMengenart_VS_id, code, codeSystem, displayName) VALUES (26, 'GBq', '2.16.840.1.113883.6.8', 'GigaBecquerel'); INSERT INTO ELGA_MedikationMengenart_VS (ELGA_MedikationMengenart_VS_id, code, codeSystem, displayName) VALUES (27, 'h', '2.16.840.1.113883.6.8', 'Hour'); INSERT INTO ELGA_MedikationMengenart_VS (ELGA_MedikationMengenart_VS_id, code, codeSystem, displayName) VALUES (28, 'J', '2.16.840.1.113883.6.8', 'Joule'); INSERT INTO ELGA_MedikationMengenart_VS (ELGA_MedikationMengenart_VS_id, code, codeSystem, displayName) VALUES (29, 'kat', '2.16.840.1.113883.6.8', 'Katal'); INSERT INTO ELGA_MedikationMengenart_VS (ELGA_MedikationMengenart_VS_id, code, codeSystem, displayName) VALUES (30, 'kcal', '2.16.840.1.113883.6.8', 'KiloCalorie'); INSERT INTO ELGA_MedikationMengenart_VS (ELGA_MedikationMengenart_VS_id, code, codeSystem, displayName) VALUES (31, 'kcal/d', '2.16.840.1.113883.6.8', 'KiloCaloriesPerDay'); INSERT INTO ELGA_MedikationMengenart_VS (ELGA_MedikationMengenart_VS_id, code, codeSystem, displayName) VALUES (32, 'kcal/g', '2.16.840.1.113883.6.8', 'KiloCaloriesPerGram'); INSERT INTO ELGA_MedikationMengenart_VS (ELGA_MedikationMengenart_VS_id, code, codeSystem, displayName) VALUES (33, 'kcal/h', '2.16.840.1.113883.6.8', 'KiloCaloriesPerHour'); INSERT INTO ELGA_MedikationMengenart_VS (ELGA_MedikationMengenart_VS_id, code, codeSystem, displayName) VALUES (34, 'kcal/mL', '2.16.840.1.113883.6.8', 'KiloCaloriesPerMilliliter'); INSERT INTO ELGA_MedikationMengenart_VS (ELGA_MedikationMengenart_VS_id, code, codeSystem, displayName) VALUES (35, 'kg', '2.16.840.1.113883.6.8', 'KiloGrams'); INSERT INTO ELGA_MedikationMengenart_VS (ELGA_MedikationMengenart_VS_id, code, codeSystem, displayName) VALUES (36, 'kg/m2', '2.16.840.1.113883.6.8', 'KilogramPerSquareMeter'); INSERT INTO ELGA_MedikationMengenart_VS (ELGA_MedikationMengenart_VS_id, code, codeSystem, displayName) VALUES (37, 'kg/m3', '2.16.840.1.113883.6.8', 'KiloGramsPerCubicMeter'); INSERT INTO ELGA_MedikationMengenart_VS (ELGA_MedikationMengenart_VS_id, code, codeSystem, displayName) VALUES (38, 'kJ', '2.16.840.1.113883.6.8', 'KiloJoule'); INSERT INTO ELGA_MedikationMengenart_VS (ELGA_MedikationMengenart_VS_id, code, codeSystem, displayName) VALUES (39, 'kPa', '2.16.840.1.113883.6.8', 'KiloPascal'); INSERT INTO ELGA_MedikationMengenart_VS (ELGA_MedikationMengenart_VS_id, code, codeSystem, displayName) VALUES (40, 'k[iU]', '2.16.840.1.113883.6.8', 'KiloInternationalUnits'); INSERT INTO ELGA_MedikationMengenart_VS (ELGA_MedikationMengenart_VS_id, code, codeSystem, displayName) VALUES (41, 'k[iU]/L', '2.16.840.1.113883.6.8', 'KiloInternationalUnitsPerLiter'); INSERT INTO ELGA_MedikationMengenart_VS (ELGA_MedikationMengenart_VS_id, code, codeSystem, displayName) VALUES (42, 'L', '2.16.840.1.113883.6.8', 'Liter'); INSERT INTO ELGA_MedikationMengenart_VS (ELGA_MedikationMengenart_VS_id, code, codeSystem, displayName) VALUES (43, 'L/s', '2.16.840.1.113883.6.8', 'LitersPerSecond'); INSERT INTO ELGA_MedikationMengenart_VS (ELGA_MedikationMengenart_VS_id, code, codeSystem, displayName) VALUES (44, 'm', '2.16.840.1.113883.6.8', 'Meter'); INSERT INTO ELGA_MedikationMengenart_VS (ELGA_MedikationMengenart_VS_id, code, codeSystem, displayName) VALUES (45, 'm2', '2.16.840.1.113883.6.8', 'SquareMeter'); INSERT INTO ELGA_MedikationMengenart_VS (ELGA_MedikationMengenart_VS_id, code, codeSystem, displayName) VALUES (46, 'mbar', '2.16.840.1.113883.6.8', 'MilliBar'); INSERT INTO ELGA_MedikationMengenart_VS (ELGA_MedikationMengenart_VS_id, code, codeSystem, displayName) VALUES (47, 'mg', '2.16.840.1.113883.6.8', 'MilliGram'); INSERT INTO ELGA_MedikationMengenart_VS (ELGA_MedikationMengenart_VS_id, code, codeSystem, displayName) VALUES (48, 'mg/L', '2.16.840.1.113883.6.8', 'MilliGramsPerLiter'); INSERT INTO ELGA_MedikationMengenart_VS (ELGA_MedikationMengenart_VS_id, code, codeSystem, displayName) VALUES (49, 'min', '2.16.840.1.113883.6.8', 'Minute'); INSERT INTO ELGA_MedikationMengenart_VS (ELGA_MedikationMengenart_VS_id, code, codeSystem, displayName) VALUES (50, 'mL', '2.16.840.1.113883.6.8', 'MilliLiter'); INSERT INTO ELGA_MedikationMengenart_VS (ELGA_MedikationMengenart_VS_id, code, codeSystem, displayName) VALUES (51, 'mL/s', '2.16.840.1.113883.6.8', 'MilliLitersPerSecond'); INSERT INTO ELGA_MedikationMengenart_VS (ELGA_MedikationMengenart_VS_id, code, codeSystem, displayName) VALUES (52, 'mm', '2.16.840.1.113883.6.8', 'Millimeter'); INSERT INTO ELGA_MedikationMengenart_VS (ELGA_MedikationMengenart_VS_id, code, codeSystem, displayName) VALUES (53, 'mm2', '2.16.840.1.113883.6.8', 'SquareMilliMeter'); INSERT INTO ELGA_MedikationMengenart_VS (ELGA_MedikationMengenart_VS_id, code, codeSystem, displayName) VALUES (54, 'mmol', '2.16.840.1.113883.6.8', 'MilliMole'); INSERT INTO ELGA_MedikationMengenart_VS (ELGA_MedikationMengenart_VS_id, code, codeSystem, displayName) VALUES (55, 'mmol/L', '2.16.840.1.113883.6.8', 'MilliMolesPerLiter'); INSERT INTO ELGA_MedikationMengenart_VS (ELGA_MedikationMengenart_VS_id, code, codeSystem, displayName) VALUES (56, 'mm[Hg]', '2.16.840.1.113883.6.8', 'MilliMetersOfMercury'); INSERT INTO ELGA_MedikationMengenart_VS (ELGA_MedikationMengenart_VS_id, code, codeSystem, displayName) VALUES (57, 'mo', '2.16.840.1.113883.6.8', 'Month'); INSERT INTO ELGA_MedikationMengenart_VS (ELGA_MedikationMengenart_VS_id, code, codeSystem, displayName) VALUES (58, 'mol/L', '2.16.840.1.113883.6.8', 'MolePerLiter'); INSERT INTO ELGA_MedikationMengenart_VS (ELGA_MedikationMengenart_VS_id, code, codeSystem, displayName) VALUES (59, 'm[iU]', '2.16.840.1.113883.6.8', 'MilliInternationalUnit'); INSERT INTO ELGA_MedikationMengenart_VS (ELGA_MedikationMengenart_VS_id, code, codeSystem, displayName) VALUES (60, 'm[iU]/L', '2.16.840.1.113883.6.8', 'MilliInternationalUnitsPerLiter'); INSERT INTO ELGA_MedikationMengenart_VS (ELGA_MedikationMengenart_VS_id, code, codeSystem, displayName) VALUES (61, 'ng', '2.16.840.1.113883.6.8', 'NanoGram'); INSERT INTO ELGA_MedikationMengenart_VS (ELGA_MedikationMengenart_VS_id, code, codeSystem, displayName) VALUES (62, 'ng/L', '2.16.840.1.113883.6.8', 'NanoGramsPerLiter'); INSERT INTO ELGA_MedikationMengenart_VS (ELGA_MedikationMengenart_VS_id, code, codeSystem, displayName) VALUES (63, 'nmol/L', '2.16.840.1.113883.6.8', 'NanoMolesPerLiter'); INSERT INTO ELGA_MedikationMengenart_VS (ELGA_MedikationMengenart_VS_id, code, codeSystem, displayName) VALUES (64, 's', '2.16.840.1.113883.6.8', 'Second'); INSERT INTO ELGA_MedikationMengenart_VS (ELGA_MedikationMengenart_VS_id, code, codeSystem, displayName) VALUES (65, 'ug', '2.16.840.1.113883.6.8', 'Microgram'); INSERT INTO ELGA_MedikationMengenart_VS (ELGA_MedikationMengenart_VS_id, code, codeSystem, displayName) VALUES (66, 'ug/(kg.min)', '2.16.840.1.113883.6.8', 'MicroGramsPerKiloGramAndMinute'); INSERT INTO ELGA_MedikationMengenart_VS (ELGA_MedikationMengenart_VS_id, code, codeSystem, displayName) VALUES (67, 'ug/L', '2.16.840.1.113883.6.8', 'MicroGramsPerLiter'); INSERT INTO ELGA_MedikationMengenart_VS (ELGA_MedikationMengenart_VS_id, code, codeSystem, displayName) VALUES (68, 'ukat', '2.16.840.1.113883.6.8', 'MicroKatal'); INSERT INTO ELGA_MedikationMengenart_VS (ELGA_MedikationMengenart_VS_id, code, codeSystem, displayName) VALUES (69, 'ukat/L', '2.16.840.1.113883.6.8', 'MicroKatalsPerLiter'); INSERT INTO ELGA_MedikationMengenart_VS (ELGA_MedikationMengenart_VS_id, code, codeSystem, displayName) VALUES (70, 'ukat/mL', '2.16.840.1.113883.6.8', 'MicroKatalsPerMilliLiter'); INSERT INTO ELGA_MedikationMengenart_VS (ELGA_MedikationMengenart_VS_id, code, codeSystem, displayName) VALUES (71, 'uL', '2.16.840.1.113883.6.8', 'MicroLiter'); INSERT INTO ELGA_MedikationMengenart_VS (ELGA_MedikationMengenart_VS_id, code, codeSystem, displayName) VALUES (72, 'umol', '2.16.840.1.113883.6.8', 'MicroMole'); INSERT INTO ELGA_MedikationMengenart_VS (ELGA_MedikationMengenart_VS_id, code, codeSystem, displayName) VALUES (73, 'umol/L', '2.16.840.1.113883.6.8', 'MicroMolesPerLiter'); INSERT INTO ELGA_MedikationMengenart_VS (ELGA_MedikationMengenart_VS_id, code, codeSystem, displayName) VALUES (74, 'wk', '2.16.840.1.113883.6.8', 'Week'); INSERT INTO ELGA_MedikationMengenart_VS (ELGA_MedikationMengenart_VS_id, code, codeSystem, displayName) VALUES (75, '[iU]', '2.16.840.1.113883.6.8', 'InternationalUnit'); INSERT INTO ELGA_MedikationMengenart_VS (ELGA_MedikationMengenart_VS_id, code, codeSystem, displayName) VALUES (76, '[iU]/g', '2.16.840.1.113883.6.8', 'InternationalUnitsPerGram'); INSERT INTO ELGA_MedikationMengenart_VS (ELGA_MedikationMengenart_VS_id, code, codeSystem, displayName) VALUES (77, '[iU]/mL', '2.16.840.1.113883.6.8', 'InternationalUnitsPerMilliLiter'); INSERT INTO ELGA_MedikationMengenart_VS (ELGA_MedikationMengenart_VS_id, code, codeSystem, displayName) VALUES (78, '[pH]', '2.16.840.1.113883.6.8', 'pH'); INSERT INTO ELGA_MedikationMengenart_VS (ELGA_MedikationMengenart_VS_id, code, codeSystem, displayName) VALUES (79, '{Beutel/Aufgussbeutel}', '2.16.840.1.113883.6.8', 'Beutel/Aufgussbeutel'); INSERT INTO ELGA_MedikationMengenart_VS (ELGA_MedikationMengenart_VS_id, code, codeSystem, displayName) VALUES (80, '{Broteinheiten}', '2.16.840.1.113883.6.8', 'Broteinheit(en)'); INSERT INTO ELGA_MedikationMengenart_VS (ELGA_MedikationMengenart_VS_id, code, codeSystem, displayName) VALUES (81, '{Essloeffel}', '2.16.840.1.113883.6.8', 'Esslöffel'); INSERT INTO ELGA_MedikationMengenart_VS (ELGA_MedikationMengenart_VS_id, code, codeSystem, displayName) VALUES (82, '{Flaschen}', '2.16.840.1.113883.6.8', 'Flasche(n)'); INSERT INTO ELGA_MedikationMengenart_VS (ELGA_MedikationMengenart_VS_id, code, codeSystem, displayName) VALUES (83, '{Globuli}', '2.16.840.1.113883.6.8', 'Globuli'); INSERT INTO ELGA_MedikationMengenart_VS (ELGA_MedikationMengenart_VS_id, code, codeSystem, displayName) VALUES (84, '{Hub}', '2.16.840.1.113883.6.8', 'Hub/Hübe'); INSERT INTO ELGA_MedikationMengenart_VS (ELGA_MedikationMengenart_VS_id, code, codeSystem, displayName) VALUES (85, '{Messloeffel}', '2.16.840.1.113883.6.8', 'Messlöffel'); INSERT INTO ELGA_MedikationMengenart_VS (ELGA_MedikationMengenart_VS_id, code, codeSystem, displayName) VALUES (86, '{Packungsbeutel}', '2.16.840.1.113883.6.8', 'Packungsbeutel'); INSERT INTO ELGA_MedikationMengenart_VS (ELGA_MedikationMengenart_VS_id, code, codeSystem, displayName) VALUES (87, '{Packung}', '2.16.840.1.113883.6.8', 'Packung(en)'); INSERT INTO ELGA_MedikationMengenart_VS (ELGA_MedikationMengenart_VS_id, code, codeSystem, displayName) VALUES (88, '{Stueck}', '2.16.840.1.113883.6.8', 'Stück'); INSERT INTO ELGA_MedikationMengenart_VS (ELGA_MedikationMengenart_VS_id, code, codeSystem, displayName) VALUES (89, '{Teeloeffel}', '2.16.840.1.113883.6.8', 'Teelöffel'); INSERT INTO ELGA_MedikationMengenart_VS (ELGA_MedikationMengenart_VS_id, code, codeSystem, displayName) VALUES (90, '{Tropfen}', '2.16.840.1.113883.6.8', 'Tropfen'); INSERT INTO ELGA_MedikationMengenart_VS (ELGA_MedikationMengenart_VS_id, code, codeSystem, displayName) VALUES (91, '[iU]/{Broteinheiten}', '2.16.840.1.113883.6.8', 'International Unit(s) per Bread Unit(s)'); INSERT INTO ELGA_MedikationMengenart_VS (ELGA_MedikationMengenart_VS_id, code, codeSystem, displayName) VALUES (92, '{Ampulle}', '2.16.840.1.113883.6.8', 'Ampulle(n)'); INSERT INTO ELGA_MedikationMengenart_VS (ELGA_MedikationMengenart_VS_id, code, codeSystem, displayName) VALUES (93, '10*6[iU]', '2.16.840.1.113883.6.8', 'MillionInternationalUnits');