 	STORETIME DATETIME,
 	CGID INT,
 	VALUE DATETIME,
-	UOM VARCHAR(50),
+	VALUEUOM VARCHAR(50),
 	WARNING SMALLINT,
 	ERROR SMALLINT,
 	RESULTSTATUS VARCHAR(50),

--    CHARTTIME DATETIME NOT NULL,
--    VALUE VARCHAR(255),
--    VALUENUM VARCHAR(255),
--    UOM VARCHAR(255),
--    FLAG VARCHAR(255));

LOAD DATA LOCAL INFILE 'LABEVENTS_DATA_TABLE.csv' INTO TABLE LABEVENTS
   FIELDS TERMINATED BY ',' ESCAPED BY '\\' OPTIONALLY ENCLOSED BY '"'
   LINES TERMINATED BY '\n'
   IGNORE 1 LINES
   (@ROW_ID,@SUBJECT_ID,@HADM_ID,@ITEMID,@CHARTTIME,@VALUE,@VALUENUM,@UOM,@FLAG)
 SET
   ROW_ID = @ROW_ID,
   SUBJECT_ID = @SUBJECT_ID,

	CGID INT,
	VALUE VARCHAR(255),
	VALUENUM DOUBLE PRECISION,
	VALUEUOM VARCHAR(50),
	WARNING INT,
	ERROR INT,
	RESULTSTATUS VARCHAR(50),
