--DROP TABLE ParticipationFunction CASCADE; CREATE TABLE ParticipationFunction ( ParticipationFunction_id int NOT NULL PRIMARY KEY, code varchar(255) NOT NULL, codeSystem varchar(255) NOT NULL, displayName varchar(255) NOT NULL ); INSERT INTO ParticipationFunction (ParticipationFunction_id, code, codeSystem, displayName) VALUES (1, '_AuthorizedParticipationFunction', '2.16.840.1.113883.5.88', 'AuthorizedParticipationFunction'); INSERT INTO ParticipationFunction (ParticipationFunction_id, code, codeSystem, displayName) VALUES (2, '_AuthorizedReceiverParticipationFunction', '2.16.840.1.113883.5.88', 'AuthorizedReceiverParticipationFunction'); INSERT INTO ParticipationFunction (ParticipationFunction_id, code, codeSystem, displayName) VALUES (3, 'AUCG', '2.16.840.1.113883.5.88', 'caregiver information receiver'); INSERT INTO ParticipationFunction (ParticipationFunction_id, code, codeSystem, displayName) VALUES (4, 'AULR', '2.16.840.1.113883.5.88', 'legitimate relationship information receiver'); INSERT INTO ParticipationFunction (ParticipationFunction_id, code, codeSystem, displayName) VALUES (5, 'AUTM', '2.16.840.1.113883.5.88', 'care team information receiver'); INSERT INTO ParticipationFunction (ParticipationFunction_id, code, codeSystem, displayName) VALUES (6, 'AUWA', '2.16.840.1.113883.5.88', 'work area information receiver'); INSERT INTO ParticipationFunction (ParticipationFunction_id, code, codeSystem, displayName) VALUES (7, '_ConsenterParticipationFunction', '2.16.840.1.113883.5.88', 'ConsenterParticipationFunction'); INSERT INTO ParticipationFunction (ParticipationFunction_id, code, codeSystem, displayName) VALUES (8, 'GRDCON', '2.16.840.1.113883.5.88', 'legal guardian consent author'); INSERT INTO ParticipationFunction (ParticipationFunction_id, code, codeSystem, displayName) VALUES (9, 'POACON', '2.16.840.1.113883.5.88', 'healthcare power of attorney consent author'); INSERT INTO ParticipationFunction (ParticipationFunction_id, code, codeSystem, displayName) VALUES (10, 'PRCON', '2.16.840.1.113883.5.88', 'personal representative consent author'); INSERT INTO ParticipationFunction (ParticipationFunction_id, code, codeSystem, displayName) VALUES (11, 'PROMSK', '2.16.840.1.113883.5.88', 'authorized provider masking author'); INSERT INTO ParticipationFunction (ParticipationFunction_id, code, codeSystem, displayName) VALUES (12, 'SUBCON', '2.16.840.1.113883.5.88', 'subject of consent author'); INSERT INTO ParticipationFunction (ParticipationFunction_id, code, codeSystem, displayName) VALUES (13, '_OverriderParticipationFunction', '2.16.840.1.113883.5.88', 'OverriderParticipationFunction'); INSERT INTO ParticipationFunction (ParticipationFunction_id, code, codeSystem, displayName) VALUES (14, 'AUCOV', '2.16.840.1.113883.5.88', 'consent overrider'); INSERT INTO ParticipationFunction (ParticipationFunction_id, code, codeSystem, displayName) VALUES (15, 'AUEMROV', '2.16.840.1.113883.5.88', 'emergency overrider'); INSERT INTO ParticipationFunction (ParticipationFunction_id, code, codeSystem, displayName) VALUES (16, '_CoverageParticipationFunction', '2.16.840.1.113883.5.88', 'CoverageParticipationFunction'); INSERT INTO ParticipationFunction (ParticipationFunction_id, code, codeSystem, displayName) VALUES (17, '_PayorParticipationFunction', '2.16.840.1.113883.5.88', 'PayorParticipationFunction'); INSERT INTO ParticipationFunction (ParticipationFunction_id, code, codeSystem, displayName) VALUES (18, 'CLMADJ', '2.16.840.1.113883.5.88', 'claims adjudication'); INSERT INTO ParticipationFunction (ParticipationFunction_id, code, codeSystem, displayName) VALUES (19, 'ENROLL', '2.16.840.1.113883.5.88', 'enrollment broker'); INSERT INTO ParticipationFunction (ParticipationFunction_id, code, codeSystem, displayName) VALUES (20, 'FFSMGT', '2.16.840.1.113883.5.88', 'ffs management'); INSERT INTO ParticipationFunction (ParticipationFunction_id, code, codeSystem, displayName) VALUES (21, 'MCMGT', '2.16.840.1.113883.5.88', 'managed care management'); INSERT INTO ParticipationFunction (ParticipationFunction_id, code, codeSystem, displayName) VALUES (22, 'PROVMGT', '2.16.840.1.113883.5.88', 'provider management'); INSERT INTO ParticipationFunction (ParticipationFunction_id, code, codeSystem, displayName) VALUES (23, 'UMGT', '2.16.840.1.113883.5.88', 'utilization management'); INSERT INTO ParticipationFunction (ParticipationFunction_id, code, codeSystem, displayName) VALUES (24, '_SponsorParticipationFunction', '2.16.840.1.113883.5.88', 'SponsorParticipationFunction'); INSERT INTO ParticipationFunction (ParticipationFunction_id, code, codeSystem, displayName) VALUES (25, 'FULINRD', '2.16.840.1.113883.5.88', 'fully insured'); INSERT INTO ParticipationFunction (ParticipationFunction_id, code, codeSystem, displayName) VALUES (26, 'SELFINRD', '2.16.840.1.113883.5.88', 'self insured'); INSERT INTO ParticipationFunction (ParticipationFunction_id, code, codeSystem, displayName) VALUES (27, '_UnderwriterParticipationFunction', '2.16.840.1.113883.5.88', 'UnderwriterParticipationFunction'); INSERT INTO ParticipationFunction (ParticipationFunction_id, code, codeSystem, displayName) VALUES (28, 'PAYORCNTR', '2.16.840.1.113883.5.88', 'payor contracting'); INSERT INTO ParticipationFunction (ParticipationFunction_id, code, codeSystem, displayName) VALUES (29, 'REINS', '2.16.840.1.113883.5.88', 'reinsures'); INSERT INTO ParticipationFunction (ParticipationFunction_id, code, codeSystem, displayName) VALUES (30, 'RETROCES', '2.16.840.1.113883.5.88', 'retrocessionaires'); INSERT INTO ParticipationFunction (ParticipationFunction_id, code, codeSystem, displayName) VALUES (31, 'SUBCTRT', '2.16.840.1.113883.5.88', 'subcontracting risk'); INSERT INTO ParticipationFunction (ParticipationFunction_id, code, codeSystem, displayName) VALUES (32, 'UNDERWRTNG', '2.16.840.1.113883.5.88', 'underwriting'); INSERT INTO ParticipationFunction (ParticipationFunction_id, code, codeSystem, displayName) VALUES (33, 'ADMPHYS', '2.16.840.1.113883.5.88', 'admitting physician'); INSERT INTO ParticipationFunction (ParticipationFunction_id, code, codeSystem, displayName) VALUES (34, 'ANEST', '2.16.840.1.113883.5.88', 'anesthesist'); INSERT INTO ParticipationFunction (ParticipationFunction_id, code, codeSystem, displayName) VALUES (35, 'ANRS', '2.16.840.1.113883.5.88', 'anesthesia nurse'); INSERT INTO ParticipationFunction (ParticipationFunction_id, code, codeSystem, displayName) VALUES (36, 'ASSEMBLER', '2.16.840.1.113883.5.88', 'assembly software'); INSERT INTO ParticipationFunction (ParticipationFunction_id, code, codeSystem, displayName) VALUES (37, 'ATTPHYS', '2.16.840.1.113883.5.88', 'attending physician'); INSERT INTO ParticipationFunction (ParticipationFunction_id, code, codeSystem, displayName) VALUES (38, 'COMPOSER', '2.16.840.1.113883.5.88', 'composer software'); INSERT INTO ParticipationFunction (ParticipationFunction_id, code, codeSystem, displayName) VALUES (39, 'DISPHYS', '2.16.840.1.113883.5.88', 'discharging physician'); INSERT INTO ParticipationFunction (ParticipationFunction_id, code, codeSystem, displayName) VALUES (40, 'FASST', '2.16.840.1.113883.5.88', 'first assistant surgeon'); INSERT INTO ParticipationFunction (ParticipationFunction_id, code, codeSystem, displayName) VALUES (41, 'MDWF', '2.16.840.1.113883.5.88', 'midwife'); INSERT INTO ParticipationFunction (ParticipationFunction_id, code, codeSystem, displayName) VALUES (42, 'NASST', '2.16.840.1.113883.5.88', 'nurse assistant'); INSERT INTO ParticipationFunction (ParticipationFunction_id, code, codeSystem, displayName) VALUES (43, 'PCP', '2.16.840.1.113883.5.88', 'primary care physician'); INSERT INTO ParticipationFunction (ParticipationFunction_id, code, codeSystem, displayName) VALUES (44, 'PRISURG', '2.16.840.1.113883.5.88', 'primary surgeon'); INSERT INTO ParticipationFunction (ParticipationFunction_id, code, codeSystem, displayName) VALUES (45, 'REVIEWER', '2.16.840.1.113883.5.88', 'reviewer'); INSERT INTO ParticipationFunction (ParticipationFunction_id, code, codeSystem, displayName) VALUES (46, 'RNDPHYS', '2.16.840.1.113883.5.88', 'rounding physician'); INSERT INTO ParticipationFunction (ParticipationFunction_id, code, codeSystem, displayName) VALUES (47, 'SASST', '2.16.840.1.113883.5.88', 'second assistant surgeon'); INSERT INTO ParticipationFunction (ParticipationFunction_id, code, codeSystem, displayName) VALUES (48, 'SNRS', '2.16.840.1.113883.5.88', 'scrub nurse'); INSERT INTO ParticipationFunction (ParticipationFunction_id, code, codeSystem, displayName) VALUES (49, 'TASST', '2.16.840.1.113883.5.88', 'third assistant');