--DROP TABLE IHEXDShealthcareFacilityTypeCodePatientRelatedHealthcare CASCADE; CREATE TABLE IHEXDShealthcareFacilityTypeCodePatientRelatedHealthcare ( IHEXDShealthcareFacilityTypeCodePatientRelatedHealthcare_id int NOT NULL PRIMARY KEY, code varchar(255) NOT NULL, codeSystem varchar(255) NOT NULL, displayName varchar(255) NOT NULL ); INSERT INTO IHEXDShealthcareFacilityTypeCodePatientRelatedHealthcare (IHEXDShealthcareFacilityTypeCodePatientRelatedHealthcare_id, code, codeSystem, displayName) VALUES (1, 'APD', '1.3.6.1.4.1.19376.3.276.1.5.2', 'Ambulanter Pflegedienst'); INSERT INTO IHEXDShealthcareFacilityTypeCodePatientRelatedHealthcare (IHEXDShealthcareFacilityTypeCodePatientRelatedHealthcare_id, code, codeSystem, displayName) VALUES (2, 'APO', '1.3.6.1.4.1.19376.3.276.1.5.2', 'Apotheke'); INSERT INTO IHEXDShealthcareFacilityTypeCodePatientRelatedHealthcare (IHEXDShealthcareFacilityTypeCodePatientRelatedHealthcare_id, code, codeSystem, displayName) VALUES (3, 'BER', '1.3.6.1.4.1.19376.3.276.1.5.2', 'Ärztlicher Bereitschaftsdienst'); INSERT INTO IHEXDShealthcareFacilityTypeCodePatientRelatedHealthcare (IHEXDShealthcareFacilityTypeCodePatientRelatedHealthcare_id, code, codeSystem, displayName) VALUES (4, 'PRA', '1.3.6.1.4.1.19376.3.276.1.5.2', 'Arztpraxis'); INSERT INTO IHEXDShealthcareFacilityTypeCodePatientRelatedHealthcare (IHEXDShealthcareFacilityTypeCodePatientRelatedHealthcare_id, code, codeSystem, displayName) VALUES (5, 'BAA', '1.3.6.1.4.1.19376.3.276.1.5.2', 'Betriebsärztliche Abteilung'); INSERT INTO IHEXDShealthcareFacilityTypeCodePatientRelatedHealthcare (IHEXDShealthcareFacilityTypeCodePatientRelatedHealthcare_id, code, codeSystem, displayName) VALUES (6, 'BHR', '1.3.6.1.4.1.19376.3.276.1.5.2', 'Gesundheitsbehörde'); INSERT INTO IHEXDShealthcareFacilityTypeCodePatientRelatedHealthcare (IHEXDShealthcareFacilityTypeCodePatientRelatedHealthcare_id, code, codeSystem, displayName) VALUES (7, 'HEB', '1.3.6.1.4.1.19376.3.276.1.5.2', 'Hebamme/Geburtshaus'); INSERT INTO IHEXDShealthcareFacilityTypeCodePatientRelatedHealthcare (IHEXDShealthcareFacilityTypeCodePatientRelatedHealthcare_id, code, codeSystem, displayName) VALUES (8, 'HOS', '1.3.6.1.4.1.19376.3.276.1.5.2', 'Hospiz'); INSERT INTO IHEXDShealthcareFacilityTypeCodePatientRelatedHealthcare (IHEXDShealthcareFacilityTypeCodePatientRelatedHealthcare_id, code, codeSystem, displayName) VALUES (9, 'KHS', '1.3.6.1.4.1.19376.3.276.1.5.2', 'Krankenhaus'); INSERT INTO IHEXDShealthcareFacilityTypeCodePatientRelatedHealthcare (IHEXDShealthcareFacilityTypeCodePatientRelatedHealthcare_id, code, codeSystem, displayName) VALUES (10, 'MVZ', '1.3.6.1.4.1.19376.3.276.1.5.2', 'Medizinisches Versorgungszentrum'); INSERT INTO IHEXDShealthcareFacilityTypeCodePatientRelatedHealthcare (IHEXDShealthcareFacilityTypeCodePatientRelatedHealthcare_id, code, codeSystem, displayName) VALUES (11, 'HAN', '1.3.6.1.4.1.19376.3.276.1.5.2', 'Medizinisch-technisches Handwerk'); INSERT INTO IHEXDShealthcareFacilityTypeCodePatientRelatedHealthcare (IHEXDShealthcareFacilityTypeCodePatientRelatedHealthcare_id, code, codeSystem, displayName) VALUES (12, 'REH', '1.3.6.1.4.1.19376.3.276.1.5.2', 'Medizinische Rehabilitation'); INSERT INTO IHEXDShealthcareFacilityTypeCodePatientRelatedHealthcare (IHEXDShealthcareFacilityTypeCodePatientRelatedHealthcare_id, code, codeSystem, displayName) VALUES (13, 'HEI', '1.3.6.1.4.1.19376.3.276.1.5.2', 'Nicht-ärztliche Heilberufs-Praxis'); INSERT INTO IHEXDShealthcareFacilityTypeCodePatientRelatedHealthcare (IHEXDShealthcareFacilityTypeCodePatientRelatedHealthcare_id, code, codeSystem, displayName) VALUES (14, 'PFL', '1.3.6.1.4.1.19376.3.276.1.5.2', 'Pflegeheim'); INSERT INTO IHEXDShealthcareFacilityTypeCodePatientRelatedHealthcare (IHEXDShealthcareFacilityTypeCodePatientRelatedHealthcare_id, code, codeSystem, displayName) VALUES (15, 'RTN', '1.3.6.1.4.1.19376.3.276.1.5.2', 'Rettungsdienst'); INSERT INTO IHEXDShealthcareFacilityTypeCodePatientRelatedHealthcare (IHEXDShealthcareFacilityTypeCodePatientRelatedHealthcare_id, code, codeSystem, displayName) VALUES (16, 'SEL', '1.3.6.1.4.1.19376.3.276.1.5.2', 'Selbsthilfe'); INSERT INTO IHEXDShealthcareFacilityTypeCodePatientRelatedHealthcare (IHEXDShealthcareFacilityTypeCodePatientRelatedHealthcare_id, code, codeSystem, displayName) VALUES (17, 'TMZ', '1.3.6.1.4.1.19376.3.276.1.5.2', 'Telemedizinisches Zentrum ');