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

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


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