   "ud_number_12" numeric(30,10),
   "include_frequency" numeric(38),
   "sdrug_not_admin" numeric(38),
-  "prod_reptd" varchar(255),
-  "prod_coded" varchar(255),
+  "prod_reptd" varchar(999),
+  "prod_coded" varchar(999),
   "prod_syn_id" numeric(38),
   "prod_code_status" numeric(3,0),
   "deleted" date,
   "study_product_num" numeric(2,0),
-  "qc_quantity" varchar(10),
+  "qc_quantity" varchar(99),
   "qc_return_date" date,
   "qc_complaint_cat_date" date,
   "qc_analysis_cat_date" date,
   "qc_analysis_summary_date" date,
   "primary_event" numeric(38),
-  "medicinal_prod_id" varchar(10),
+  "medicinal_prod_id" varchar(99),
   "family_id" numeric(38),
   "existing_rpt_seq_mod_flg" numeric(38),
-  "drug_code_j" varchar(20),
+  "drug_code_j" varchar(99),
   "drug_code_type_j" numeric(38),
-  "product_name_j" varchar(70),
-  "prod_coded_j" varchar(255),
-  "prod_reptd_j" varchar(255),
-  "qc_cross_reference_j" varchar(16),
-  "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),
+  "product_name_j" varchar(99),
+  "prod_coded_j" varchar(999),
+  "prod_reptd_j" varchar(999),
+  "qc_cross_reference_j" varchar(99),
+  "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),
   "dlp_revision_number" numeric(38),
   "last_update_time" date,
   "revision_delete_flag" number default 0,

  "followup_date_j" date,
  "init_rept_date_j" date,
  "just_init_rept_date_j" varchar(1000),
  "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),
  "initial_justification_j" varchar(1000),
  "dlp_revision_number" numeric(38),
  "revision_delete_flag" number default 0,

  "priority_assessment" numeric(38),
  "close_user_id" numeric(38),
  "close_date" date,
  "close_notes" varchar(999),
  "date_locked" date,
  "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,
