--DROP TABLE ELGA_HumanActSite CASCADE; CREATE TABLE ELGA_HumanActSite ( ELGA_HumanActSite_id int NOT NULL PRIMARY KEY, code varchar(255) NOT NULL, codeSystem varchar(255) NOT NULL, displayName varchar(255) NOT NULL ); INSERT INTO ELGA_HumanActSite (ELGA_HumanActSite_id, code, codeSystem, displayName) VALUES (1, 'BE', '2.16.840.1.113883.5.1052', 'bilateral ears'); INSERT INTO ELGA_HumanActSite (ELGA_HumanActSite_id, code, codeSystem, displayName) VALUES (2, 'BN', '2.16.840.1.113883.5.1052', 'bilateral nares'); INSERT INTO ELGA_HumanActSite (ELGA_HumanActSite_id, code, codeSystem, displayName) VALUES (3, 'BU', '2.16.840.1.113883.5.1052', 'buttock'); INSERT INTO ELGA_HumanActSite (ELGA_HumanActSite_id, code, codeSystem, displayName) VALUES (4, 'LA', '2.16.840.1.113883.5.1052', 'left arm'); INSERT INTO ELGA_HumanActSite (ELGA_HumanActSite_id, code, codeSystem, displayName) VALUES (5, 'LAC', '2.16.840.1.113883.5.1052', 'left anterior chest'); INSERT INTO ELGA_HumanActSite (ELGA_HumanActSite_id, code, codeSystem, displayName) VALUES (6, 'LACF', '2.16.840.1.113883.5.1052', 'left antecubital fossa'); INSERT INTO ELGA_HumanActSite (ELGA_HumanActSite_id, code, codeSystem, displayName) VALUES (7, 'LD', '2.16.840.1.113883.5.1052', 'left deltoid'); INSERT INTO ELGA_HumanActSite (ELGA_HumanActSite_id, code, codeSystem, displayName) VALUES (8, 'LE', '2.16.840.1.113883.5.1052', 'left ear'); INSERT INTO ELGA_HumanActSite (ELGA_HumanActSite_id, code, codeSystem, displayName) VALUES (9, 'LEJ', '2.16.840.1.113883.5.1052', 'left external jugular'); INSERT INTO ELGA_HumanActSite (ELGA_HumanActSite_id, code, codeSystem, displayName) VALUES (10, 'LF', '2.16.840.1.113883.5.1052', 'left foot'); INSERT INTO ELGA_HumanActSite (ELGA_HumanActSite_id, code, codeSystem, displayName) VALUES (11, 'LG', '2.16.840.1.113883.5.1052', 'left gluteus medius'); INSERT INTO ELGA_HumanActSite (ELGA_HumanActSite_id, code, codeSystem, displayName) VALUES (12, 'LH', '2.16.840.1.113883.5.1052', 'left hand'); INSERT INTO ELGA_HumanActSite (ELGA_HumanActSite_id, code, codeSystem, displayName) VALUES (13, 'LIJ', '2.16.840.1.113883.5.1052', 'left internal jugular'); INSERT INTO ELGA_HumanActSite (ELGA_HumanActSite_id, code, codeSystem, displayName) VALUES (14, 'LLAQ', '2.16.840.1.113883.5.1052', 'left lower abd quadrant'); INSERT INTO ELGA_HumanActSite (ELGA_HumanActSite_id, code, codeSystem, displayName) VALUES (15, 'LLFA', '2.16.840.1.113883.5.1052', 'left lower forearm'); INSERT INTO ELGA_HumanActSite (ELGA_HumanActSite_id, code, codeSystem, displayName) VALUES (16, 'LMFA', '2.16.840.1.113883.5.1052', 'left mid forearm'); INSERT INTO ELGA_HumanActSite (ELGA_HumanActSite_id, code, codeSystem, displayName) VALUES (17, 'LN', '2.16.840.1.113883.5.1052', 'left naris'); INSERT INTO ELGA_HumanActSite (ELGA_HumanActSite_id, code, codeSystem, displayName) VALUES (18, 'LPC', '2.16.840.1.113883.5.1052', 'left posterior chest'); INSERT INTO ELGA_HumanActSite (ELGA_HumanActSite_id, code, codeSystem, displayName) VALUES (19, 'LSC', '2.16.840.1.113883.5.1052', 'left subclavian'); INSERT INTO ELGA_HumanActSite (ELGA_HumanActSite_id, code, codeSystem, displayName) VALUES (20, 'LT', '2.16.840.1.113883.5.1052', 'left thigh'); INSERT INTO ELGA_HumanActSite (ELGA_HumanActSite_id, code, codeSystem, displayName) VALUES (21, 'LUA', '2.16.840.1.113883.5.1052', 'left upper arm'); INSERT INTO ELGA_HumanActSite (ELGA_HumanActSite_id, code, codeSystem, displayName) VALUES (22, 'LUAQ', '2.16.840.1.113883.5.1052', 'left upper abd quadrant'); INSERT INTO ELGA_HumanActSite (ELGA_HumanActSite_id, code, codeSystem, displayName) VALUES (23, 'LUFA', '2.16.840.1.113883.5.1052', 'left upper forearm'); INSERT INTO ELGA_HumanActSite (ELGA_HumanActSite_id, code, codeSystem, displayName) VALUES (24, 'LVG', '2.16.840.1.113883.5.1052', 'left ventragluteal'); INSERT INTO ELGA_HumanActSite (ELGA_HumanActSite_id, code, codeSystem, displayName) VALUES (25, 'LVL', '2.16.840.1.113883.5.1052', 'left vastus lateralis'); INSERT INTO ELGA_HumanActSite (ELGA_HumanActSite_id, code, codeSystem, displayName) VALUES (26, 'OD', '2.16.840.1.113883.5.1052', 'right eye'); INSERT INTO ELGA_HumanActSite (ELGA_HumanActSite_id, code, codeSystem, displayName) VALUES (27, 'OS', '2.16.840.1.113883.5.1052', 'left eye'); INSERT INTO ELGA_HumanActSite (ELGA_HumanActSite_id, code, codeSystem, displayName) VALUES (28, 'OU', '2.16.840.1.113883.5.1052', 'bilateral eyes'); INSERT INTO ELGA_HumanActSite (ELGA_HumanActSite_id, code, codeSystem, displayName) VALUES (29, 'PA', '2.16.840.1.113883.5.1052', 'perianal'); INSERT INTO ELGA_HumanActSite (ELGA_HumanActSite_id, code, codeSystem, displayName) VALUES (30, 'PERIN', '2.16.840.1.113883.5.1052', 'perineal'); INSERT INTO ELGA_HumanActSite (ELGA_HumanActSite_id, code, codeSystem, displayName) VALUES (31, 'RA', '2.16.840.1.113883.5.1052', 'right arm'); INSERT INTO ELGA_HumanActSite (ELGA_HumanActSite_id, code, codeSystem, displayName) VALUES (32, 'RAC', '2.16.840.1.113883.5.1052', 'right anterior chest'); INSERT INTO ELGA_HumanActSite (ELGA_HumanActSite_id, code, codeSystem, displayName) VALUES (33, 'RACF', '2.16.840.1.113883.5.1052', 'right antecubital fossa'); INSERT INTO ELGA_HumanActSite (ELGA_HumanActSite_id, code, codeSystem, displayName) VALUES (34, 'RD', '2.16.840.1.113883.5.1052', 'right deltoid'); INSERT INTO ELGA_HumanActSite (ELGA_HumanActSite_id, code, codeSystem, displayName) VALUES (35, 'RE', '2.16.840.1.113883.5.1052', 'right ear'); INSERT INTO ELGA_HumanActSite (ELGA_HumanActSite_id, code, codeSystem, displayName) VALUES (36, 'REJ', '2.16.840.1.113883.5.1052', 'right external jugular'); INSERT INTO ELGA_HumanActSite (ELGA_HumanActSite_id, code, codeSystem, displayName) VALUES (37, 'RF', '2.16.840.1.113883.5.1052', 'right foot'); INSERT INTO ELGA_HumanActSite (ELGA_HumanActSite_id, code, codeSystem, displayName) VALUES (38, 'RG', '2.16.840.1.113883.5.1052', 'right gluteus medius'); INSERT INTO ELGA_HumanActSite (ELGA_HumanActSite_id, code, codeSystem, displayName) VALUES (39, 'RH', '2.16.840.1.113883.5.1052', 'right hand'); INSERT INTO ELGA_HumanActSite (ELGA_HumanActSite_id, code, codeSystem, displayName) VALUES (40, 'RIJ', '2.16.840.1.113883.5.1052', 'right internal jugular'); INSERT INTO ELGA_HumanActSite (ELGA_HumanActSite_id, code, codeSystem, displayName) VALUES (41, 'RLAQ', '2.16.840.1.113883.5.1052', 'right lower abd quadrant'); INSERT INTO ELGA_HumanActSite (ELGA_HumanActSite_id, code, codeSystem, displayName) VALUES (42, 'RLFA', '2.16.840.1.113883.5.1052', 'right lower forearm'); INSERT INTO ELGA_HumanActSite (ELGA_HumanActSite_id, code, codeSystem, displayName) VALUES (43, 'RMFA', '2.16.840.1.113883.5.1052', 'right mid forearm'); INSERT INTO ELGA_HumanActSite (ELGA_HumanActSite_id, code, codeSystem, displayName) VALUES (44, 'RN', '2.16.840.1.113883.5.1052', 'right naris'); INSERT INTO ELGA_HumanActSite (ELGA_HumanActSite_id, code, codeSystem, displayName) VALUES (45, 'RPC', '2.16.840.1.113883.5.1052', 'right posterior chest'); INSERT INTO ELGA_HumanActSite (ELGA_HumanActSite_id, code, codeSystem, displayName) VALUES (46, 'RSC', '2.16.840.1.113883.5.1052', 'right subclavian'); INSERT INTO ELGA_HumanActSite (ELGA_HumanActSite_id, code, codeSystem, displayName) VALUES (47, 'RT', '2.16.840.1.113883.5.1052', 'right thigh'); INSERT INTO ELGA_HumanActSite (ELGA_HumanActSite_id, code, codeSystem, displayName) VALUES (48, 'RUA', '2.16.840.1.113883.5.1052', 'right upper arm'); INSERT INTO ELGA_HumanActSite (ELGA_HumanActSite_id, code, codeSystem, displayName) VALUES (49, 'RUAQ', '2.16.840.1.113883.5.1052', 'right upper abd quadrant'); INSERT INTO ELGA_HumanActSite (ELGA_HumanActSite_id, code, codeSystem, displayName) VALUES (50, 'RUFA', '2.16.840.1.113883.5.1052', 'right upper forearm'); INSERT INTO ELGA_HumanActSite (ELGA_HumanActSite_id, code, codeSystem, displayName) VALUES (51, 'RVG', '2.16.840.1.113883.5.1052', 'right ventragluteal'); INSERT INTO ELGA_HumanActSite (ELGA_HumanActSite_id, code, codeSystem, displayName) VALUES (52, 'RVL', '2.16.840.1.113883.5.1052', 'right vastus lateralis');