   "duration_seconds" numeric(38),
   "onset_latency_seconds" numeric(38),
   "onset_delay_seconds" numeric(38),
-  "body_sys_j" varchar(250),
+  "body_sys_j" varchar(999),
   "code_status_j" numeric(38),
-  "desc_coded_j" varchar(255),
-  "desc_reptd_j" varchar(250),
-  "hlgt_j" varchar(250),
-  "hlt_j" varchar(250),
-  "inc_code_j" varchar(30),
-  "inc_term_j" varchar(250),
-  "pref_term_j" varchar(250),
-  "sc_other_text_j" varchar(30),
+  "desc_coded_j" varchar(999),
+  "desc_reptd_j" varchar(999),
+  "hlgt_j" varchar(999),
+  "hlt_j" varchar(999),
+  "inc_code_j" varchar(99),
+  "inc_term_j" varchar(999),
+  "pref_term_j" varchar(999),
+  "sc_other_text_j" varchar(99),
   "report_exclusion" numeric(38),
   "reportable" numeric(38),
-  "ud_text_1_j" varchar(100),
-  "ud_text_2_j" varchar(100),
-  "ud_text_3_j" varchar(100),
-  "ud_text_4_j" varchar(100),
-  "ud_text_5_j" varchar(100),
-  "ud_text_6_j" varchar(100),
-  "ud_text_7_j" varchar(100),
-  "ud_text_8_j" varchar(100),
-  "ud_text_9_j" varchar(100),
-  "ud_text_10_j" varchar(100),
-  "ud_text_11_j" varchar(100),
-  "ud_text_12_j" varchar(100),
+  "ud_text_1_j" varchar(999),
+  "ud_text_2_j" varchar(999),
+  "ud_text_3_j" varchar(999),
+  "ud_text_4_j" varchar(999),
+  "ud_text_5_j" varchar(999),
+  "ud_text_6_j" varchar(999),
+  "ud_text_7_j" varchar(999),
+  "ud_text_8_j" varchar(999),
+  "ud_text_9_j" varchar(999),
+  "ud_text_10_j" varchar(999),
+  "ud_text_11_j" varchar(999),
+  "ud_text_12_j" varchar(999),
   "syn_code_j" numeric(38),
   "infection" numeric(38),
   "rpt_exclude_cmt" varchar(1000),

  "effective_end_date" date,
  "notes" varchar(3900),
  "notes_j" varchar(3900),
  "institution_id" varchar(15)
)

create table rm_case_study

  "listedness_notes" varchar(1000),
  "bfarm_causality" numeric(10,0),
  "bfarm_manual_text" varchar(3900),
  "company_diagnosis" varchar(999),
  "company_diagnosis_notes" varchar(1000),
  "diagnosis_dict_id" numeric(38),
  "diagnosis_pref_code" varchar(99),
  "diagnosis_inc_code" varchar(99),
  "diagnosis_inc_term" varchar(999),
  "diagnosis_hlgt_code" varchar(99),
  "diagnosis_hlgt" varchar(999),
  "diagnosis_hlt_code" varchar(99),
  "diagnosis_hlt" varchar(999),
  "diagnosis_soc_code" varchar(99),
  "diagnosis_body_sys" varchar(999),
  "ud_text_1" varchar(999),
  "ud_text_2" varchar(999),
  "ud_text_3" varchar(999),
  "ud_text_4" varchar(999),
  "ud_text_5" varchar(999),
  "ud_text_6" varchar(999),
  "ud_text_7" varchar(999),
  "ud_text_8" varchar(999),
  "ud_text_9" varchar(999),
  "ud_text_10" varchar(999),
  "ud_text_11" varchar(999),
  "ud_text_12" varchar(999),
  "ud_date_1" date,
  "ud_date_2" date,
  "ud_date_3" date,
