--DROP TABLE ELGA_ReligiousAffiliation CASCADE; CREATE TABLE ELGA_ReligiousAffiliation ( ELGA_ReligiousAffiliation_id int NOT NULL PRIMARY KEY, code varchar(255) NOT NULL, codeSystem varchar(255) NOT NULL, displayName varchar(255) NOT NULL ); INSERT INTO ELGA_ReligiousAffiliation (ELGA_ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (1, '100', '2.16.840.1.113883.2.16.1.4.1', 'Katholische Kirche (o.n.A.)'); INSERT INTO ELGA_ReligiousAffiliation (ELGA_ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (2, '101', '2.16.840.1.113883.2.16.1.4.1', 'Römisch-Katholisch'); INSERT INTO ELGA_ReligiousAffiliation (ELGA_ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (3, '102', '2.16.840.1.113883.2.16.1.4.1', 'Griechisch-Katholische Kirche'); INSERT INTO ELGA_ReligiousAffiliation (ELGA_ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (4, '103', '2.16.840.1.113883.2.16.1.4.1', 'Armenisch-Katholische Kirche'); INSERT INTO ELGA_ReligiousAffiliation (ELGA_ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (5, '104', '2.16.840.1.113883.2.16.1.4.1', 'Bulgarisch-Katholische Kirche'); INSERT INTO ELGA_ReligiousAffiliation (ELGA_ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (6, '105', '2.16.840.1.113883.2.16.1.4.1', 'Rumänische griechisch-katholische Kirche'); INSERT INTO ELGA_ReligiousAffiliation (ELGA_ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (7, '106', '2.16.840.1.113883.2.16.1.4.1', 'Russisch-Katholische Kirche'); INSERT INTO ELGA_ReligiousAffiliation (ELGA_ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (8, '107', '2.16.840.1.113883.2.16.1.4.1', 'Syrisch-Katholische Kirche'); INSERT INTO ELGA_ReligiousAffiliation (ELGA_ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (9, '108', '2.16.840.1.113883.2.16.1.4.1', 'Ukrainische Griechisch-Katholische Kirche'); INSERT INTO ELGA_ReligiousAffiliation (ELGA_ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (10, '109', '2.16.840.1.113883.2.16.1.4.1', 'Katholische Ostkirche (ohne nähere Angabe)'); INSERT INTO ELGA_ReligiousAffiliation (ELGA_ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (11, '110', '2.16.840.1.113883.2.16.1.4.1', 'Griechisch-Orientalische Kirchen'); INSERT INTO ELGA_ReligiousAffiliation (ELGA_ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (12, '111', '2.16.840.1.113883.2.16.1.4.1', 'Orthodoxe Kirchen (o.n.A.)'); INSERT INTO ELGA_ReligiousAffiliation (ELGA_ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (13, '112', '2.16.840.1.113883.2.16.1.4.1', 'Griechisch-Orthodoxe Kirche (Hl.Dreifaltigkeit)'); INSERT INTO ELGA_ReligiousAffiliation (ELGA_ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (14, '113', '2.16.840.1.113883.2.16.1.4.1', 'Griechisch-Orthodoxe Kirche (Hl.Georg)'); INSERT INTO ELGA_ReligiousAffiliation (ELGA_ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (15, '114', '2.16.840.1.113883.2.16.1.4.1', 'Bulgarisch-Orthodoxe Kirche'); INSERT INTO ELGA_ReligiousAffiliation (ELGA_ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (16, '115', '2.16.840.1.113883.2.16.1.4.1', 'Rumänisch-griechisch-orientalische Kirche'); INSERT INTO ELGA_ReligiousAffiliation (ELGA_ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (17, '116', '2.16.840.1.113883.2.16.1.4.1', 'Russisch-Orthodoxe Kirche'); INSERT INTO ELGA_ReligiousAffiliation (ELGA_ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (18, '117', '2.16.840.1.113883.2.16.1.4.1', 'Serbisch-griechisch-Orthodoxe Kirche'); INSERT INTO ELGA_ReligiousAffiliation (ELGA_ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (19, '118', '2.16.840.1.113883.2.16.1.4.1', 'Ukrainisch-Orthodoxe Kirche'); INSERT INTO ELGA_ReligiousAffiliation (ELGA_ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (20, '119', '2.16.840.1.113883.2.16.1.4.1', 'Orientalisch-Orthodoxe Kirchen'); INSERT INTO ELGA_ReligiousAffiliation (ELGA_ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (21, '120', '2.16.840.1.113883.2.16.1.4.1', 'Armenisch-apostolische Kirche'); INSERT INTO ELGA_ReligiousAffiliation (ELGA_ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (22, '121', '2.16.840.1.113883.2.16.1.4.1', 'Syrisch-orthodoxe Kirche'); INSERT INTO ELGA_ReligiousAffiliation (ELGA_ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (23, '122', '2.16.840.1.113883.2.16.1.4.1', 'Syrisch-orthodoxe Kirche'); INSERT INTO ELGA_ReligiousAffiliation (ELGA_ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (24, '123', '2.16.840.1.113883.2.16.1.4.1', 'Koptisch-orthodoxe Kirche'); INSERT INTO ELGA_ReligiousAffiliation (ELGA_ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (25, '124', '2.16.840.1.113883.2.16.1.4.1', 'Armenisch-apostolische Kirche'); INSERT INTO ELGA_ReligiousAffiliation (ELGA_ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (26, '125', '2.16.840.1.113883.2.16.1.4.1', 'Äthiopisch-Orthodoxe Kirche'); INSERT INTO ELGA_ReligiousAffiliation (ELGA_ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (27, '126', '2.16.840.1.113883.2.16.1.4.1', 'Evangelische Kirchen Österreich'); INSERT INTO ELGA_ReligiousAffiliation (ELGA_ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (28, '127', '2.16.840.1.113883.2.16.1.4.1', 'Evangelische Kirche (o.n.A.)'); INSERT INTO ELGA_ReligiousAffiliation (ELGA_ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (29, '128', '2.16.840.1.113883.2.16.1.4.1', 'Evangelische Kirche A.B.'); INSERT INTO ELGA_ReligiousAffiliation (ELGA_ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (30, '129', '2.16.840.1.113883.2.16.1.4.1', 'Evangelische Kirche H.B.'); INSERT INTO ELGA_ReligiousAffiliation (ELGA_ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (31, '130', '2.16.840.1.113883.2.16.1.4.1', 'Andere Christliche Kirchen'); INSERT INTO ELGA_ReligiousAffiliation (ELGA_ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (32, '131', '2.16.840.1.113883.2.16.1.4.1', 'Altkatholische Kirche Österreichs'); INSERT INTO ELGA_ReligiousAffiliation (ELGA_ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (33, '132', '2.16.840.1.113883.2.16.1.4.1', 'Anglikanische Kirche'); INSERT INTO ELGA_ReligiousAffiliation (ELGA_ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (34, '133', '2.16.840.1.113883.2.16.1.4.1', 'Evangelisch-methodistische Kirche (EmK)'); INSERT INTO ELGA_ReligiousAffiliation (ELGA_ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (35, '134', '2.16.840.1.113883.2.16.1.4.1', 'Sonstige Christliche Gemeinschaften'); INSERT INTO ELGA_ReligiousAffiliation (ELGA_ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (36, '135', '2.16.840.1.113883.2.16.1.4.1', 'Baptisten'); INSERT INTO ELGA_ReligiousAffiliation (ELGA_ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (37, '136', '2.16.840.1.113883.2.16.1.4.1', 'Bund evangelikaler Gemeinden in Österreich'); INSERT INTO ELGA_ReligiousAffiliation (ELGA_ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (38, '137', '2.16.840.1.113883.2.16.1.4.1', 'Freie Christengemeinde/Pfingstgemeinde'); INSERT INTO ELGA_ReligiousAffiliation (ELGA_ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (39, '138', '2.16.840.1.113883.2.16.1.4.1', 'Mennonitische Freikirche'); INSERT INTO ELGA_ReligiousAffiliation (ELGA_ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (40, '139', '2.16.840.1.113883.2.16.1.4.1', 'Kirche der Siebenten-Tags-Adventisten'); INSERT INTO ELGA_ReligiousAffiliation (ELGA_ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (41, '140', '2.16.840.1.113883.2.16.1.4.1', 'Christengemeinschaft'); INSERT INTO ELGA_ReligiousAffiliation (ELGA_ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (42, '141', '2.16.840.1.113883.2.16.1.4.1', 'Jehovas Zeugen'); INSERT INTO ELGA_ReligiousAffiliation (ELGA_ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (43, '142', '2.16.840.1.113883.2.16.1.4.1', 'Neuapostolische Kirche'); INSERT INTO ELGA_ReligiousAffiliation (ELGA_ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (44, '143', '2.16.840.1.113883.2.16.1.4.1', 'Mormonen'); INSERT INTO ELGA_ReligiousAffiliation (ELGA_ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (45, '144', '2.16.840.1.113883.2.16.1.4.1', 'Sonstige Christliche Gemeinschaften (O.n.A.)'); INSERT INTO ELGA_ReligiousAffiliation (ELGA_ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (46, '145', '2.16.840.1.113883.2.16.1.4.1', 'ELAIA Christengemeinden'); INSERT INTO ELGA_ReligiousAffiliation (ELGA_ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (47, '146', '2.16.840.1.113883.2.16.1.4.1', 'Pfingstkirche Gemeinde Gottes'); INSERT INTO ELGA_ReligiousAffiliation (ELGA_ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (48, '148', '2.16.840.1.113883.2.16.1.4.1', 'Nicht-christliche Gemeinschaften'); INSERT INTO ELGA_ReligiousAffiliation (ELGA_ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (49, '149', '2.16.840.1.113883.2.16.1.4.1', 'Israelitische Religionsgesellschaft'); INSERT INTO ELGA_ReligiousAffiliation (ELGA_ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (50, '150', '2.16.840.1.113883.2.16.1.4.1', 'Islamische Glaubensgemeinschaft'); INSERT INTO ELGA_ReligiousAffiliation (ELGA_ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (51, '151', '2.16.840.1.113883.2.16.1.4.1', 'Alevitische Religionsgesellschaft'); INSERT INTO ELGA_ReligiousAffiliation (ELGA_ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (52, '152', '2.16.840.1.113883.2.16.1.4.1', 'Buddhistische Religionsgesellschaft'); INSERT INTO ELGA_ReligiousAffiliation (ELGA_ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (53, '153', '2.16.840.1.113883.2.16.1.4.1', 'Baha‘ i'); INSERT INTO ELGA_ReligiousAffiliation (ELGA_ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (54, '154', '2.16.840.1.113883.2.16.1.4.1', 'Hinduistische Religionsgesellschaft'); INSERT INTO ELGA_ReligiousAffiliation (ELGA_ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (55, '155', '2.16.840.1.113883.2.16.1.4.1', 'Sikh'); INSERT INTO ELGA_ReligiousAffiliation (ELGA_ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (56, '156', '2.16.840.1.113883.2.16.1.4.1', 'Shintoismus'); INSERT INTO ELGA_ReligiousAffiliation (ELGA_ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (57, '157', '2.16.840.1.113883.2.16.1.4.1', 'Vereinigungskirche'); INSERT INTO ELGA_ReligiousAffiliation (ELGA_ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (58, '162', '2.16.840.1.113883.2.16.1.4.1', 'Pastafarianismus'); INSERT INTO ELGA_ReligiousAffiliation (ELGA_ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (59, '158', '2.16.840.1.113883.2.16.1.4.1', 'Andere religiöse Bekenntnisgemeinschaften'); INSERT INTO ELGA_ReligiousAffiliation (ELGA_ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (60, '159', '2.16.840.1.113883.2.16.1.4.1', 'Konfessionslos; ohne Angabe'); INSERT INTO ELGA_ReligiousAffiliation (ELGA_ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (61, '160', '2.16.840.1.113883.2.16.1.4.1', 'Konfessionslos'); INSERT INTO ELGA_ReligiousAffiliation (ELGA_ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (62, '161', '2.16.840.1.113883.2.16.1.4.1', 'Ohne Angabe');