--DROP TABLE RoleClassMutualRelationship CASCADE; CREATE TABLE RoleClassMutualRelationship ( RoleClassMutualRelationship_id int NOT NULL PRIMARY KEY, code varchar(255) NOT NULL, codeSystem varchar(255) NOT NULL, displayName varchar(255) NOT NULL ); INSERT INTO RoleClassMutualRelationship (RoleClassMutualRelationship_id, code, codeSystem, displayName) VALUES (1, '_RoleClassRelationshipFormal', '2.16.840.1.113883.5.110', 'RoleClassRelationshipFormal'); INSERT INTO RoleClassMutualRelationship (RoleClassMutualRelationship_id, code, codeSystem, displayName) VALUES (2, 'AFFL', '2.16.840.1.113883.5.110', 'affiliate'); INSERT INTO RoleClassMutualRelationship (RoleClassMutualRelationship_id, code, codeSystem, displayName) VALUES (3, 'AGNT', '2.16.840.1.113883.5.110', 'agent'); INSERT INTO RoleClassMutualRelationship (RoleClassMutualRelationship_id, code, codeSystem, displayName) VALUES (4, 'ASSIGNED', '2.16.840.1.113883.5.110', 'assigned entity'); INSERT INTO RoleClassMutualRelationship (RoleClassMutualRelationship_id, code, codeSystem, displayName) VALUES (5, 'COMPAR', '2.16.840.1.113883.5.110', 'commissioning party'); INSERT INTO RoleClassMutualRelationship (RoleClassMutualRelationship_id, code, codeSystem, displayName) VALUES (6, 'SGNOFF', '2.16.840.1.113883.5.110', 'signing authority or officer'); INSERT INTO RoleClassMutualRelationship (RoleClassMutualRelationship_id, code, codeSystem, displayName) VALUES (7, 'CON', '2.16.840.1.113883.5.110', 'contact'); INSERT INTO RoleClassMutualRelationship (RoleClassMutualRelationship_id, code, codeSystem, displayName) VALUES (8, 'ECON', '2.16.840.1.113883.5.110', 'emergency contact'); INSERT INTO RoleClassMutualRelationship (RoleClassMutualRelationship_id, code, codeSystem, displayName) VALUES (9, 'NOK', '2.16.840.1.113883.5.110', 'next of kin'); INSERT INTO RoleClassMutualRelationship (RoleClassMutualRelationship_id, code, codeSystem, displayName) VALUES (10, 'GUARD', '2.16.840.1.113883.5.110', 'guardian'); INSERT INTO RoleClassMutualRelationship (RoleClassMutualRelationship_id, code, codeSystem, displayName) VALUES (11, 'CIT', '2.16.840.1.113883.5.110', 'citizen'); INSERT INTO RoleClassMutualRelationship (RoleClassMutualRelationship_id, code, codeSystem, displayName) VALUES (12, 'COVPTY', '2.16.840.1.113883.5.110', 'covered party'); INSERT INTO RoleClassMutualRelationship (RoleClassMutualRelationship_id, code, codeSystem, displayName) VALUES (13, 'CLAIM', '2.16.840.1.113883.5.110', 'claimant'); INSERT INTO RoleClassMutualRelationship (RoleClassMutualRelationship_id, code, codeSystem, displayName) VALUES (14, 'NAMED', '2.16.840.1.113883.5.110', 'named insured'); INSERT INTO RoleClassMutualRelationship (RoleClassMutualRelationship_id, code, codeSystem, displayName) VALUES (15, 'DEPEN', '2.16.840.1.113883.5.110', 'dependent'); INSERT INTO RoleClassMutualRelationship (RoleClassMutualRelationship_id, code, codeSystem, displayName) VALUES (16, 'INDIV', '2.16.840.1.113883.5.110', 'individual'); INSERT INTO RoleClassMutualRelationship (RoleClassMutualRelationship_id, code, codeSystem, displayName) VALUES (17, 'SUBSCR', '2.16.840.1.113883.5.110', 'subscriber'); INSERT INTO RoleClassMutualRelationship (RoleClassMutualRelationship_id, code, codeSystem, displayName) VALUES (18, 'PROG', '2.16.840.1.113883.5.110', 'program eligible'); INSERT INTO RoleClassMutualRelationship (RoleClassMutualRelationship_id, code, codeSystem, displayName) VALUES (19, 'CRINV', '2.16.840.1.113883.5.110', 'clinical research investigator'); INSERT INTO RoleClassMutualRelationship (RoleClassMutualRelationship_id, code, codeSystem, displayName) VALUES (20, 'CRSPNSR', '2.16.840.1.113883.5.110', 'clinical research sponsor'); INSERT INTO RoleClassMutualRelationship (RoleClassMutualRelationship_id, code, codeSystem, displayName) VALUES (21, 'EMP', '2.16.840.1.113883.5.110', 'employee'); INSERT INTO RoleClassMutualRelationship (RoleClassMutualRelationship_id, code, codeSystem, displayName) VALUES (22, 'MIL', '2.16.840.1.113883.5.110', 'military person'); INSERT INTO RoleClassMutualRelationship (RoleClassMutualRelationship_id, code, codeSystem, displayName) VALUES (23, 'GUAR', '2.16.840.1.113883.5.110', 'guarantor GuarantorRole'); INSERT INTO RoleClassMutualRelationship (RoleClassMutualRelationship_id, code, codeSystem, displayName) VALUES (24, 'INVSBJ', '2.16.840.1.113883.5.110', 'Investigation Subject'); INSERT INTO RoleClassMutualRelationship (RoleClassMutualRelationship_id, code, codeSystem, displayName) VALUES (25, 'CASEBJ', '2.16.840.1.113883.5.110', 'Case Subject'); INSERT INTO RoleClassMutualRelationship (RoleClassMutualRelationship_id, code, codeSystem, displayName) VALUES (26, 'RESBJ', '2.16.840.1.113883.5.110', 'research subject'); INSERT INTO RoleClassMutualRelationship (RoleClassMutualRelationship_id, code, codeSystem, displayName) VALUES (27, 'LIC', '2.16.840.1.113883.5.110', 'licensed entity'); INSERT INTO RoleClassMutualRelationship (RoleClassMutualRelationship_id, code, codeSystem, displayName) VALUES (28, 'NOT', '2.16.840.1.113883.5.110', 'notary public'); INSERT INTO RoleClassMutualRelationship (RoleClassMutualRelationship_id, code, codeSystem, displayName) VALUES (29, 'PROV', '2.16.840.1.113883.5.110', 'healthcare provider'); INSERT INTO RoleClassMutualRelationship (RoleClassMutualRelationship_id, code, codeSystem, displayName) VALUES (30, 'PAT', '2.16.840.1.113883.5.110', 'patient'); INSERT INTO RoleClassMutualRelationship (RoleClassMutualRelationship_id, code, codeSystem, displayName) VALUES (31, 'PAYEE', '2.16.840.1.113883.5.110', 'payee'); INSERT INTO RoleClassMutualRelationship (RoleClassMutualRelationship_id, code, codeSystem, displayName) VALUES (32, 'PAYOR', '2.16.840.1.113883.5.110', 'invoice payor'); INSERT INTO RoleClassMutualRelationship (RoleClassMutualRelationship_id, code, codeSystem, displayName) VALUES (33, 'POLHOLD', '2.16.840.1.113883.5.110', 'policy holder'); INSERT INTO RoleClassMutualRelationship (RoleClassMutualRelationship_id, code, codeSystem, displayName) VALUES (34, 'QUAL', '2.16.840.1.113883.5.110', 'qualified entity'); INSERT INTO RoleClassMutualRelationship (RoleClassMutualRelationship_id, code, codeSystem, displayName) VALUES (35, 'SPNSR', '2.16.840.1.113883.5.110', 'coverage sponsor'); INSERT INTO RoleClassMutualRelationship (RoleClassMutualRelationship_id, code, codeSystem, displayName) VALUES (36, 'STD', '2.16.840.1.113883.5.110', 'student'); INSERT INTO RoleClassMutualRelationship (RoleClassMutualRelationship_id, code, codeSystem, displayName) VALUES (37, 'UNDWRT', '2.16.840.1.113883.5.110', 'underwriter'); INSERT INTO RoleClassMutualRelationship (RoleClassMutualRelationship_id, code, codeSystem, displayName) VALUES (38, 'CAREGIVER', '2.16.840.1.113883.5.110', 'caregiver'); INSERT INTO RoleClassMutualRelationship (RoleClassMutualRelationship_id, code, codeSystem, displayName) VALUES (39, 'PRS', '2.16.840.1.113883.5.110', 'personal relationship');