...
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 => procedure
Comma as separator
Set STUDY_ID to VARCHAR length 32, do not allow nulls.
ENCOUNTER_D ID to BIGINT, do not allow nulls.
...