...
ICD_DESC should be set to 255 length; it may default to 150, which is not long enough.
ENCOUNTERS => encounter
Comma as separator
Set STUDY_ID to VARCHAR length 32, do not allow nulls.
ENCOUNTER_ID to BIGINT, do not allow nulls.
PROCEDURES => procedures (procedure is a reserved word)
First, add a header for "PROC_CODE" as the second-to-last field:
"STUDY_ID","ENCOUNTER_ID","PROC_DATE","PROC_TYPE","PROC_CODE","PROC_NAME"Comma as separator
Set STUDY_ID to VARCHAR length 32, do not allow nulls.
ENCOUNTER_D ID to BIGINT, do not allow nulls.
...
For Date, change name to DATE, and make sure it's month/day/year format ("Advanced" button at bottom-left.)
Vitals
STUDY_ID: VARCHAR(32), deselect allow nulls
ENCOUNTER_ID: BIGINT, deselect allow nulls
Change 3 types VARCHAR(50) to VARCHAR(255)