--DROP TABLE ReligiousAffiliation CASCADE; CREATE TABLE ReligiousAffiliation ( ReligiousAffiliation_id int NOT NULL PRIMARY KEY, code varchar(255) NOT NULL, codeSystem varchar(255) NOT NULL, displayName varchar(255) NOT NULL ); INSERT INTO ReligiousAffiliation (ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (1, '1001', '2.16.840.1.113883.5.1076', 'Adventist'); INSERT INTO ReligiousAffiliation (ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (2, '1002', '2.16.840.1.113883.5.1076', 'African Religions'); INSERT INTO ReligiousAffiliation (ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (3, '1003', '2.16.840.1.113883.5.1076', 'Afro-Caribbean Religions'); INSERT INTO ReligiousAffiliation (ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (4, '1004', '2.16.840.1.113883.5.1076', 'Agnosticism'); INSERT INTO ReligiousAffiliation (ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (5, '1005', '2.16.840.1.113883.5.1076', 'Anglican'); INSERT INTO ReligiousAffiliation (ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (6, '1006', '2.16.840.1.113883.5.1076', 'Animism'); INSERT INTO ReligiousAffiliation (ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (7, '1007', '2.16.840.1.113883.5.1076', 'Atheism'); INSERT INTO ReligiousAffiliation (ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (8, '1008', '2.16.840.1.113883.5.1076', 'Babi & BahaI faiths'); INSERT INTO ReligiousAffiliation (ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (9, '1009', '2.16.840.1.113883.5.1076', 'Baptist'); INSERT INTO ReligiousAffiliation (ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (10, '1010', '2.16.840.1.113883.5.1076', 'Bon'); INSERT INTO ReligiousAffiliation (ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (11, '1011', '2.16.840.1.113883.5.1076', 'Cao Dai'); INSERT INTO ReligiousAffiliation (ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (12, '1012', '2.16.840.1.113883.5.1076', 'Celticism'); INSERT INTO ReligiousAffiliation (ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (13, '1013', '2.16.840.1.113883.5.1076', 'Christian (non-Catholic, non-specific)'); INSERT INTO ReligiousAffiliation (ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (14, '1014', '2.16.840.1.113883.5.1076', 'Confucianism'); INSERT INTO ReligiousAffiliation (ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (15, '1015', '2.16.840.1.113883.5.1076', 'Cyberculture Religions'); INSERT INTO ReligiousAffiliation (ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (16, '1016', '2.16.840.1.113883.5.1076', 'Divination'); INSERT INTO ReligiousAffiliation (ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (17, '1017', '2.16.840.1.113883.5.1076', 'Fourth Way'); INSERT INTO ReligiousAffiliation (ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (18, '1018', '2.16.840.1.113883.5.1076', 'Free Daism'); INSERT INTO ReligiousAffiliation (ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (19, '1019', '2.16.840.1.113883.5.1076', 'Gnosis'); INSERT INTO ReligiousAffiliation (ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (20, '1020', '2.16.840.1.113883.5.1076', 'Hinduism'); INSERT INTO ReligiousAffiliation (ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (21, '1021', '2.16.840.1.113883.5.1076', 'Humanism'); INSERT INTO ReligiousAffiliation (ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (22, '1022', '2.16.840.1.113883.5.1076', 'Independent'); INSERT INTO ReligiousAffiliation (ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (23, '1023', '2.16.840.1.113883.5.1076', 'Islam'); INSERT INTO ReligiousAffiliation (ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (24, '1024', '2.16.840.1.113883.5.1076', 'Jainism'); INSERT INTO ReligiousAffiliation (ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (25, '1025', '2.16.840.1.113883.5.1076', 'Jehovahs Witnesses'); INSERT INTO ReligiousAffiliation (ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (26, '1026', '2.16.840.1.113883.5.1076', 'Judaism'); INSERT INTO ReligiousAffiliation (ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (27, '1027', '2.16.840.1.113883.5.1076', 'Latter Day Saints'); INSERT INTO ReligiousAffiliation (ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (28, '1028', '2.16.840.1.113883.5.1076', 'Lutheran'); INSERT INTO ReligiousAffiliation (ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (29, '1029', '2.16.840.1.113883.5.1076', 'Mahayana'); INSERT INTO ReligiousAffiliation (ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (30, '1030', '2.16.840.1.113883.5.1076', 'Meditation'); INSERT INTO ReligiousAffiliation (ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (31, '1031', '2.16.840.1.113883.5.1076', 'Messianic Judaism'); INSERT INTO ReligiousAffiliation (ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (32, '1032', '2.16.840.1.113883.5.1076', 'Mitraism'); INSERT INTO ReligiousAffiliation (ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (33, '1033', '2.16.840.1.113883.5.1076', 'New Age'); INSERT INTO ReligiousAffiliation (ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (34, '1034', '2.16.840.1.113883.5.1076', 'non-Roman Catholic'); INSERT INTO ReligiousAffiliation (ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (35, '1035', '2.16.840.1.113883.5.1076', 'Occult'); INSERT INTO ReligiousAffiliation (ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (36, '1036', '2.16.840.1.113883.5.1076', 'Orthodox'); INSERT INTO ReligiousAffiliation (ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (37, '1037', '2.16.840.1.113883.5.1076', 'Paganism'); INSERT INTO ReligiousAffiliation (ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (38, '1038', '2.16.840.1.113883.5.1076', 'Pentecostal'); INSERT INTO ReligiousAffiliation (ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (39, '1039', '2.16.840.1.113883.5.1076', 'Process, The'); INSERT INTO ReligiousAffiliation (ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (40, '1040', '2.16.840.1.113883.5.1076', 'Reformed/Presbyterian'); INSERT INTO ReligiousAffiliation (ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (41, '1041', '2.16.840.1.113883.5.1076', 'Roman Catholic Church'); INSERT INTO ReligiousAffiliation (ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (42, '1042', '2.16.840.1.113883.5.1076', 'Satanism'); INSERT INTO ReligiousAffiliation (ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (43, '1043', '2.16.840.1.113883.5.1076', 'Scientology'); INSERT INTO ReligiousAffiliation (ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (44, '1044', '2.16.840.1.113883.5.1076', 'Shamanism'); INSERT INTO ReligiousAffiliation (ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (45, '1045', '2.16.840.1.113883.5.1076', 'Shiite (Islam)'); INSERT INTO ReligiousAffiliation (ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (46, '1046', '2.16.840.1.113883.5.1076', 'Shinto'); INSERT INTO ReligiousAffiliation (ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (47, '1047', '2.16.840.1.113883.5.1076', 'Sikism'); INSERT INTO ReligiousAffiliation (ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (48, '1048', '2.16.840.1.113883.5.1076', 'Spiritualism'); INSERT INTO ReligiousAffiliation (ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (49, '1049', '2.16.840.1.113883.5.1076', 'Sunni (Islam)'); INSERT INTO ReligiousAffiliation (ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (50, '1050', '2.16.840.1.113883.5.1076', 'Taoism'); INSERT INTO ReligiousAffiliation (ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (51, '1051', '2.16.840.1.113883.5.1076', 'Theravada'); INSERT INTO ReligiousAffiliation (ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (52, '1052', '2.16.840.1.113883.5.1076', 'Unitarian-Universalism'); INSERT INTO ReligiousAffiliation (ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (53, '1053', '2.16.840.1.113883.5.1076', 'Universal Life Church'); INSERT INTO ReligiousAffiliation (ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (54, '1054', '2.16.840.1.113883.5.1076', 'Vajrayana (Tibetan)'); INSERT INTO ReligiousAffiliation (ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (55, '1055', '2.16.840.1.113883.5.1076', 'Veda'); INSERT INTO ReligiousAffiliation (ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (56, '1056', '2.16.840.1.113883.5.1076', 'Voodoo'); INSERT INTO ReligiousAffiliation (ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (57, '1057', '2.16.840.1.113883.5.1076', 'Wicca'); INSERT INTO ReligiousAffiliation (ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (58, '1058', '2.16.840.1.113883.5.1076', 'Yaohushua'); INSERT INTO ReligiousAffiliation (ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (59, '1059', '2.16.840.1.113883.5.1076', 'Zen Buddhism'); INSERT INTO ReligiousAffiliation (ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (60, '1060', '2.16.840.1.113883.5.1076', 'Zoroastrianism'); INSERT INTO ReligiousAffiliation (ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (61, '1061', '2.16.840.1.113883.5.1076', 'Assembly of God'); INSERT INTO ReligiousAffiliation (ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (62, '1062', '2.16.840.1.113883.5.1076', 'Brethren'); INSERT INTO ReligiousAffiliation (ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (63, '1063', '2.16.840.1.113883.5.1076', 'Christian Scientist'); INSERT INTO ReligiousAffiliation (ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (64, '1064', '2.16.840.1.113883.5.1076', 'Church of Christ'); INSERT INTO ReligiousAffiliation (ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (65, '1065', '2.16.840.1.113883.5.1076', 'Church of God'); INSERT INTO ReligiousAffiliation (ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (66, '1066', '2.16.840.1.113883.5.1076', 'Congregational'); INSERT INTO ReligiousAffiliation (ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (67, '1067', '2.16.840.1.113883.5.1076', 'Disciples of Christ'); INSERT INTO ReligiousAffiliation (ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (68, '1068', '2.16.840.1.113883.5.1076', 'Eastern Orthodox'); INSERT INTO ReligiousAffiliation (ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (69, '1069', '2.16.840.1.113883.5.1076', 'Episcopalian'); INSERT INTO ReligiousAffiliation (ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (70, '1070', '2.16.840.1.113883.5.1076', 'Evangelical Covenant'); INSERT INTO ReligiousAffiliation (ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (71, '1071', '2.16.840.1.113883.5.1076', 'Friends'); INSERT INTO ReligiousAffiliation (ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (72, '1072', '2.16.840.1.113883.5.1076', 'Full Gospel'); INSERT INTO ReligiousAffiliation (ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (73, '1073', '2.16.840.1.113883.5.1076', 'Methodist'); INSERT INTO ReligiousAffiliation (ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (74, '1074', '2.16.840.1.113883.5.1076', 'Native American'); INSERT INTO ReligiousAffiliation (ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (75, '1075', '2.16.840.1.113883.5.1076', 'Nazarene'); INSERT INTO ReligiousAffiliation (ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (76, '1076', '2.16.840.1.113883.5.1076', 'Presbyterian'); INSERT INTO ReligiousAffiliation (ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (77, '1077', '2.16.840.1.113883.5.1076', 'Protestant'); INSERT INTO ReligiousAffiliation (ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (78, '1078', '2.16.840.1.113883.5.1076', 'Protestant, No Denomination'); INSERT INTO ReligiousAffiliation (ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (79, '1079', '2.16.840.1.113883.5.1076', 'Reformed'); INSERT INTO ReligiousAffiliation (ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (80, '1080', '2.16.840.1.113883.5.1076', 'Salvation Army'); INSERT INTO ReligiousAffiliation (ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (81, '1081', '2.16.840.1.113883.5.1076', 'Unitarian Universalist'); INSERT INTO ReligiousAffiliation (ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (82, '1082', '2.16.840.1.113883.5.1076', 'United Church of Christ'); INSERT INTO ReligiousAffiliation (ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (83, '1061', '2.16.840.1.113883.5.1076', 'Assembly of God'); INSERT INTO ReligiousAffiliation (ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (84, '1062', '2.16.840.1.113883.5.1076', 'Brethren'); INSERT INTO ReligiousAffiliation (ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (85, '1063', '2.16.840.1.113883.5.1076', 'Christian Scientist'); INSERT INTO ReligiousAffiliation (ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (86, '1064', '2.16.840.1.113883.5.1076', 'Church of Christ'); INSERT INTO ReligiousAffiliation (ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (87, '1065', '2.16.840.1.113883.5.1076', 'Church of God'); INSERT INTO ReligiousAffiliation (ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (88, '1066', '2.16.840.1.113883.5.1076', 'Congregational'); INSERT INTO ReligiousAffiliation (ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (89, '1067', '2.16.840.1.113883.5.1076', 'Disciples of Christ'); INSERT INTO ReligiousAffiliation (ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (90, '1068', '2.16.840.1.113883.5.1076', 'Eastern Orthodox'); INSERT INTO ReligiousAffiliation (ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (91, '1069', '2.16.840.1.113883.5.1076', 'Episcopalian'); INSERT INTO ReligiousAffiliation (ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (92, '1070', '2.16.840.1.113883.5.1076', 'Evangelical Covenant'); INSERT INTO ReligiousAffiliation (ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (93, '1071', '2.16.840.1.113883.5.1076', 'Friends'); INSERT INTO ReligiousAffiliation (ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (94, '1072', '2.16.840.1.113883.5.1076', 'Full Gospel'); INSERT INTO ReligiousAffiliation (ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (95, '1073', '2.16.840.1.113883.5.1076', 'Methodist'); INSERT INTO ReligiousAffiliation (ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (96, '1074', '2.16.840.1.113883.5.1076', 'Native American'); INSERT INTO ReligiousAffiliation (ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (97, '1075', '2.16.840.1.113883.5.1076', 'Nazarene'); INSERT INTO ReligiousAffiliation (ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (98, '1076', '2.16.840.1.113883.5.1076', 'Presbyterian'); INSERT INTO ReligiousAffiliation (ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (99, '1077', '2.16.840.1.113883.5.1076', 'Protestant'); INSERT INTO ReligiousAffiliation (ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (100, '1078', '2.16.840.1.113883.5.1076', 'Protestant, No Denomination'); INSERT INTO ReligiousAffiliation (ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (101, '1079', '2.16.840.1.113883.5.1076', 'Reformed'); INSERT INTO ReligiousAffiliation (ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (102, '1080', '2.16.840.1.113883.5.1076', 'Salvation Army'); INSERT INTO ReligiousAffiliation (ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (103, '1081', '2.16.840.1.113883.5.1076', 'Unitarian Universalist'); INSERT INTO ReligiousAffiliation (ReligiousAffiliation_id, code, codeSystem, displayName) VALUES (104, '1082', '2.16.840.1.113883.5.1076', 'United Church of Christ');