--DROP TABLE PersonalRelationshipRoleType CASCADE; CREATE TABLE PersonalRelationshipRoleType ( PersonalRelationshipRoleType_id int NOT NULL PRIMARY KEY, code varchar(255) NOT NULL, codeSystem varchar(255) NOT NULL, displayName varchar(255) NOT NULL ); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (1, 'FAMMEMB', '2.16.840.1.113883.5.111', 'family member'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (2, 'CHILD', '2.16.840.1.113883.5.111', 'child'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (3, 'CHLDADOPT', '2.16.840.1.113883.5.111', 'adopted child'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (4, 'DAUADOPT', '2.16.840.1.113883.5.111', 'adopted daughter'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (5, 'SONADOPT', '2.16.840.1.113883.5.111', 'adopted son'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (6, 'CHLDFOST', '2.16.840.1.113883.5.111', 'foster child'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (7, 'DAUFOST', '2.16.840.1.113883.5.111', 'foster daughter'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (8, 'SONFOST', '2.16.840.1.113883.5.111', 'foster son'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (9, 'DAUC', '2.16.840.1.113883.5.111', 'daughter'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (10, 'DAUADOPT', '2.16.840.1.113883.5.111', 'adopted daughter'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (11, 'DAUFOST', '2.16.840.1.113883.5.111', 'foster daughter'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (12, 'DAU', '2.16.840.1.113883.5.111', 'natural daughter'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (13, 'STPDAU', '2.16.840.1.113883.5.111', 'stepdaughter'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (14, 'NCHILD', '2.16.840.1.113883.5.111', 'natural child'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (15, 'DAU', '2.16.840.1.113883.5.111', 'natural daughter'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (16, 'SON', '2.16.840.1.113883.5.111', 'natural son'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (17, 'SONC', '2.16.840.1.113883.5.111', 'son'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (18, 'SONADOPT', '2.16.840.1.113883.5.111', 'adopted son'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (19, 'SONFOST', '2.16.840.1.113883.5.111', 'foster son'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (20, 'SON', '2.16.840.1.113883.5.111', 'natural son'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (21, 'STPSON', '2.16.840.1.113883.5.111', 'stepson'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (22, 'STPCHLD', '2.16.840.1.113883.5.111', 'step child'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (23, 'STPDAU', '2.16.840.1.113883.5.111', 'stepdaughter'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (24, 'STPSON', '2.16.840.1.113883.5.111', 'stepson'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (25, 'EXT', '2.16.840.1.113883.5.111', 'extended family member'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (26, 'AUNT', '2.16.840.1.113883.5.111', 'aunt'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (27, 'MAUNT', '2.16.840.1.113883.5.111', 'maternal aunt'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (28, 'PAUNT', '2.16.840.1.113883.5.111', 'paternal aunt'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (29, 'COUSN', '2.16.840.1.113883.5.111', 'cousin'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (30, 'MCOUSN', '2.16.840.1.113883.5.111', 'maternal cousin'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (31, 'PCOUSN', '2.16.840.1.113883.5.111', 'paternal cousin'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (32, 'GGRPRN', '2.16.840.1.113883.5.111', 'great grandparent'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (33, 'GGRFTH', '2.16.840.1.113883.5.111', 'great grandfather'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (34, 'MGGRFTH', '2.16.840.1.113883.5.111', 'maternal great-grandfather'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (35, 'PGGRFTH', '2.16.840.1.113883.5.111', 'paternal great-grandfather'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (36, 'GGRMTH', '2.16.840.1.113883.5.111', 'great grandmother'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (37, 'MGGRMTH', '2.16.840.1.113883.5.111', 'maternal great-grandmother'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (38, 'PGGRMTH', '2.16.840.1.113883.5.111', 'paternal great-grandmother'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (39, 'MGGRPRN', '2.16.840.1.113883.5.111', 'maternal great-grandparent'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (40, 'MGGRFTH', '2.16.840.1.113883.5.111', 'maternal great-grandfather'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (41, 'MGGRMTH', '2.16.840.1.113883.5.111', 'maternal great-grandmother'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (42, 'PGGRPRN', '2.16.840.1.113883.5.111', 'paternal great-grandparent'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (43, 'PGGRFTH', '2.16.840.1.113883.5.111', 'paternal great-grandfather'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (44, 'PGGRMTH', '2.16.840.1.113883.5.111', 'paternal great-grandmother'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (45, 'GRNDCHILD', '2.16.840.1.113883.5.111', 'grandchild'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (46, 'GRNDDAU', '2.16.840.1.113883.5.111', 'granddaughter'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (47, 'GRNDSON', '2.16.840.1.113883.5.111', 'grandson'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (48, 'GRPRN', '2.16.840.1.113883.5.111', 'grandparent'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (49, 'GRFTH', '2.16.840.1.113883.5.111', 'grandfather'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (50, 'MGRFTH', '2.16.840.1.113883.5.111', 'maternal grandfather'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (51, 'PGRFTH', '2.16.840.1.113883.5.111', 'paternal grandfather'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (52, 'GRMTH', '2.16.840.1.113883.5.111', 'grandmother'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (53, 'MGRMTH', '2.16.840.1.113883.5.111', 'maternal grandmother'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (54, 'PGRMTH', '2.16.840.1.113883.5.111', 'paternal grandmother'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (55, 'MGRPRN', '2.16.840.1.113883.5.111', 'maternal grandparent'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (56, 'MGRFTH', '2.16.840.1.113883.5.111', 'maternal grandfather'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (57, 'MGRMTH', '2.16.840.1.113883.5.111', 'maternal grandmother'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (58, 'PGRPRN', '2.16.840.1.113883.5.111', 'paternal grandparent'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (59, 'PGRFTH', '2.16.840.1.113883.5.111', 'paternal grandfather'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (60, 'PGRMTH', '2.16.840.1.113883.5.111', 'paternal grandmother'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (61, 'INLAW', '2.16.840.1.113883.5.111', 'inlaw'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (62, 'CHLDINLAW', '2.16.840.1.113883.5.111', 'child-in-law'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (63, 'DAUINLAW', '2.16.840.1.113883.5.111', 'daughter in-law'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (64, 'SONINLAW', '2.16.840.1.113883.5.111', 'son in-law'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (65, 'PRNINLAW', '2.16.840.1.113883.5.111', 'parent in-law'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (66, 'FTHINLAW', '2.16.840.1.113883.5.111', 'father-in-law'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (67, 'MTHINLAW', '2.16.840.1.113883.5.111', 'mother-in-law'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (68, 'SIBINLAW', '2.16.840.1.113883.5.111', 'sibling in-law'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (69, 'BROINLAW', '2.16.840.1.113883.5.111', 'brother-in-law'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (70, 'SISINLAW', '2.16.840.1.113883.5.111', 'sister-in-law'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (71, 'NIENEPH', '2.16.840.1.113883.5.111', 'niece/nephew'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (72, 'NEPHEW', '2.16.840.1.113883.5.111', 'nephew'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (73, 'NIECE', '2.16.840.1.113883.5.111', 'niece'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (74, 'UNCLE', '2.16.840.1.113883.5.111', 'uncle'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (75, 'MUNCLE', '2.16.840.1.113883.5.111', 'maternal uncle'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (76, 'PUNCLE', '2.16.840.1.113883.5.111', 'paternal uncle'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (77, 'PRN', '2.16.840.1.113883.5.111', 'parent'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (78, 'ADOPTP', '2.16.840.1.113883.5.111', 'adoptive parent'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (79, 'ADOPTF', '2.16.840.1.113883.5.111', 'adoptive father'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (80, 'ADOPTM', '2.16.840.1.113883.5.111', 'adoptive mother'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (81, 'FTH', '2.16.840.1.113883.5.111', 'father'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (82, 'ADOPTF', '2.16.840.1.113883.5.111', 'adoptive father'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (83, 'FTHFOST', '2.16.840.1.113883.5.111', 'foster father'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (84, 'NFTH', '2.16.840.1.113883.5.111', 'natural father'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (85, 'NFTHF', '2.16.840.1.113883.5.111', 'natural father of fetus'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (86, 'STPFTH', '2.16.840.1.113883.5.111', 'stepfather'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (87, 'MTH', '2.16.840.1.113883.5.111', 'mother'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (88, 'ADOPTM', '2.16.840.1.113883.5.111', 'adoptive mother'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (89, 'GESTM', '2.16.840.1.113883.5.111', 'gestational mother'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (90, 'MTHFOST', '2.16.840.1.113883.5.111', 'foster mother'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (91, 'NMTH', '2.16.840.1.113883.5.111', 'natural mother'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (92, 'NMTHF', '2.16.840.1.113883.5.111', 'natural mother of fetus'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (93, 'STPMTH', '2.16.840.1.113883.5.111', 'stepmother'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (94, 'NPRN', '2.16.840.1.113883.5.111', 'natural parent'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (95, 'NFTH', '2.16.840.1.113883.5.111', 'natural father'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (96, 'NFTHF', '2.16.840.1.113883.5.111', 'natural father of fetus'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (97, 'NMTH', '2.16.840.1.113883.5.111', 'natural mother'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (98, 'NMTHF', '2.16.840.1.113883.5.111', 'natural mother of fetus'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (99, 'PRNFOST', '2.16.840.1.113883.5.111', 'foster parent'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (100, 'FTHFOST', '2.16.840.1.113883.5.111', 'foster father'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (101, 'MTHFOST', '2.16.840.1.113883.5.111', 'foster mother'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (102, 'STPPRN', '2.16.840.1.113883.5.111', 'step parent'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (103, 'STPFTH', '2.16.840.1.113883.5.111', 'stepfather'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (104, 'STPMTH', '2.16.840.1.113883.5.111', 'stepmother'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (105, 'SIB', '2.16.840.1.113883.5.111', 'sibling'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (106, 'BRO', '2.16.840.1.113883.5.111', 'brother'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (107, 'HBRO', '2.16.840.1.113883.5.111', 'half-brother'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (108, 'NBRO', '2.16.840.1.113883.5.111', 'natural brother'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (109, 'TWINBRO', '2.16.840.1.113883.5.111', 'twin brother'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (110, 'FTWINBRO', '2.16.840.1.113883.5.111', 'fraternal twin brother'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (111, 'ITWINBRO', '2.16.840.1.113883.5.111', 'identical twin brother'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (112, 'STPBRO', '2.16.840.1.113883.5.111', 'stepbrother'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (113, 'HSIB', '2.16.840.1.113883.5.111', 'half-sibling'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (114, 'HBRO', '2.16.840.1.113883.5.111', 'half-brother'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (115, 'HSIS', '2.16.840.1.113883.5.111', 'half-sister'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (116, 'NSIB', '2.16.840.1.113883.5.111', 'natural sibling'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (117, 'NBRO', '2.16.840.1.113883.5.111', 'natural brother'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (118, 'TWINBRO', '2.16.840.1.113883.5.111', 'twin brother'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (119, 'FTWINBRO', '2.16.840.1.113883.5.111', 'fraternal twin brother'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (120, 'ITWINBRO', '2.16.840.1.113883.5.111', 'identical twin brother'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (121, 'NSIS', '2.16.840.1.113883.5.111', 'natural sister'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (122, 'TWINSIS', '2.16.840.1.113883.5.111', 'twin sister'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (123, 'FTWINSIS', '2.16.840.1.113883.5.111', 'fraternal twin sister'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (124, 'ITWINSIS', '2.16.840.1.113883.5.111', 'identical twin sister'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (125, 'TWIN', '2.16.840.1.113883.5.111', 'twin'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (126, 'TWINBRO', '2.16.840.1.113883.5.111', 'twin brother'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (127, 'FTWINBRO', '2.16.840.1.113883.5.111', 'fraternal twin brother'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (128, 'ITWINBRO', '2.16.840.1.113883.5.111', 'identical twin brother'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (129, 'TWINSIS', '2.16.840.1.113883.5.111', 'twin sister'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (130, 'FTWINSIS', '2.16.840.1.113883.5.111', 'fraternal twin sister'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (131, 'ITWINSIS', '2.16.840.1.113883.5.111', 'identical twin sister'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (132, 'FTWIN', '2.16.840.1.113883.5.111', 'fraternal twin'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (133, 'FTWINBRO', '2.16.840.1.113883.5.111', 'fraternal twin brother'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (134, 'FTWINSIS', '2.16.840.1.113883.5.111', 'fraternal twin sister'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (135, 'ITWIN', '2.16.840.1.113883.5.111', 'identical twin'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (136, 'ITWINBRO', '2.16.840.1.113883.5.111', 'identical twin brother'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (137, 'ITWINSIS', '2.16.840.1.113883.5.111', 'identical twin sister'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (138, 'SIS', '2.16.840.1.113883.5.111', 'sister'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (139, 'HSIS', '2.16.840.1.113883.5.111', 'half-sister'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (140, 'NSIS', '2.16.840.1.113883.5.111', 'natural sister'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (141, 'TWINSIS', '2.16.840.1.113883.5.111', 'twin sister'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (142, 'FTWINSIS', '2.16.840.1.113883.5.111', 'fraternal twin sister'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (143, 'ITWINSIS', '2.16.840.1.113883.5.111', 'identical twin sister'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (144, 'STPSIS', '2.16.840.1.113883.5.111', 'stepsister'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (145, 'STPSIB', '2.16.840.1.113883.5.111', 'step sibling'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (146, 'STPBRO', '2.16.840.1.113883.5.111', 'stepbrother'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (147, 'STPSIS', '2.16.840.1.113883.5.111', 'stepsister'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (148, 'SIGOTHR', '2.16.840.1.113883.5.111', 'significant other'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (149, 'DOMPART', '2.16.840.1.113883.5.111', 'domestic partner'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (150, 'FMRSPS', '2.16.840.1.113883.5.111', 'former spouse'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (151, 'SPS', '2.16.840.1.113883.5.111', 'spouse'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (152, 'HUSB', '2.16.840.1.113883.5.111', 'husband'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (153, 'WIFE', '2.16.840.1.113883.5.111', 'wife'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (154, 'FRND', '2.16.840.1.113883.5.111', 'unrelated friend'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (155, 'NBOR', '2.16.840.1.113883.5.111', 'neighbor'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (156, 'ONESELF', '2.16.840.1.113883.5.111', 'self'); INSERT INTO PersonalRelationshipRoleType (PersonalRelationshipRoleType_id, code, codeSystem, displayName) VALUES (157, 'ROOM', '2.16.840.1.113883.5.111', 'Roommate');