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

--    CGID SMALLINT,
--    VALUE VARCHAR(255),
--    VALUENUM VARCHAR(255),
--    UOM VARCHAR(255),
--    WARNING TINYINT UNSIGNED,
--    ERROR TINYINT UNSIGNED,
--    RESULTSTATUS VARCHAR(255),

   CHARTTIME = @CHARTTIME,
   VALUE = IF(@VALUE='', NULL, @VALUE),
   VALUENUM = IF(@VALUENUM='', NULL, @VALUENUM),
   VALUEUOM = IF(@VALUEUOM='', NULL, @VALUEUOM),
   FLAG = IF(@FLAG='', NULL, @FLAG);

-- DROP TABLE IF EXISTS MICROBIOLOGYEVENTS;
