voc-2.16.840.1.113883.1.11.19724-2014-03-26T000000.sql

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