 CREATE TABLE hcpcsevents (	-- rows=144858
    subject_id INT UNSIGNED NOT NULL,
    hadm_id INT UNSIGNED NOT NULL,
+   chartdate DATETIME NOT NULL,
    hcpcs_cd VARCHAR(255) NOT NULL,	-- max=5
    seq_num TINYINT UNSIGNED NOT NULL,
    short_description TEXT NOT NULL	-- max=165

   subject_id INT UNSIGNED NOT NULL,
   hadm_id INT UNSIGNED NOT NULL,
   seq_num TINYINT UNSIGNED NOT NULL,
   icd_code VARCHAR(255) NOT NULL,	-- max=7
   icd_version TINYINT UNSIGNED NOT NULL)
  CHARACTER SET = UTF8;

   FIELDS TERMINATED BY ',' ESCAPED BY '' OPTIONALLY ENCLOSED BY '"'
   LINES TERMINATED BY '\n'
   IGNORE 1 LINES
   (@subject_id,@hadm_id,@seq_num,@chartdate,@icd_code,@icd_version)
 SET
   subject_id = trim(@subject_id),
   hadm_id = trim(@hadm_id),
   seq_num = trim(@seq_num),
   chartdate = trim(@chartdate),
   icd_code = trim(@icd_code),
   icd_version = trim(@icd_version);

