drop table if exists  cumulative_bc_tab;

drop table if exists  cumulative_bm_tab;

drop table if exists  cumulative_bs_tab;

drop table if exists  cumulative_ca_tab;

drop table if exists  cumulative_ci_tab;

drop table if exists  cumulative_cm_tab;

drop table if exists  cumulative_cs_tab;

drop table if exists  cumulative_da_tab;

drop table if exists  cumulative_ec_tab;

drop table if exists  cumulative_en_tab;

drop table if exists  cumulative_ep_tab;

drop table if exists  cumulative_ex_tab;

drop table if exists  cumulative_fo_tab;

drop table if exists  cumulative_hm_tab;

drop table if exists  cumulative_fp_tab;

drop table if exists  cumulative_ie_tab;

drop table if exists  cumulative_dt_tab;

drop table if exists  cumulative_la_tab;

drop table if exists  cumulative_ll_tab;

drop table if exists  cumulative_ls_tab;

drop table if exists  cumulative_lx_tab;

drop table if exists  cumulative_mh_tab;

drop table if exists  cumulative_ou_tab;

drop table if exists  cumulative_pe_tab;

drop table if exists  cumulative_pk_tab;

drop table if exists  cumulative_ph_tab;

drop table if exists  cumulative_ps_tab;

drop table if exists  cumulative_pt_tab;

drop table if exists  cumulative_rc_tab;

drop table if exists  cumulative_pr_tab;

drop table if exists  cumulative_pl_tab;

drop table if exists  cumulative_rf_tab;

drop table if exists  cumulative_ue_tab;

drop table if exists  cumulative_ul_tab;

drop table if exists  cumulative_ux_tab;

drop table if exists  cumulative_xt_tab;

drop table if exists  cumulative_tx_tab;

drop table if exists  cumulative_us_tab;

drop table if exists  cumulative_tf_tab;

drop table if exists  cumulative_sc_tab;

drop table if exists  cumulative_se_tab;

drop table if exists  cumulative_sh_tab;

drop table if exists  cumulative_ss_tab;

drop table if exists  cumulative_sr_tab;

drop table if exists  cumulative_ip_tab;

drop table if exists  cumulative_ds_tab;


CREATE TABLE cumulative_bc_tab
(EXTRACT_DT TIMESTAMP DEFAULT NOW(),
 FILE_ID    VARCHAR(200),
 VERSION    VARCHAR(200),
 EXTRACTED  VARCHAR(200),
 ENTERED_BY VARCHAR(200),
 CREATED    VARCHAR(200),
 CHANGED    VARCHAR(200),
 CHG_TIME   VARCHAR(200),
 FILLER     VARCHAR(200),
 DEL_FLAG   VARCHAR(200),
 DEL_DATE   VARCHAR(200),
 PROTOCOL   VARCHAR(200),
 INST_ID    VARCHAR(200),
 ENTRY_PASS VARCHAR(200),
 TOUCH_DATE VARCHAR(200),
 TOUCH_TIME VARCHAR(200),
 COURSE_NUM VARCHAR(200),
 PATIENT    VARCHAR(200),
 LAB_DATE   VARCHAR(200),
 LAB_TIME   VARCHAR(200),
 LAB_GROUP  VARCHAR(200),
 LAB_CODE   VARCHAR(200),
 BUN        VARCHAR(200),
 S_BUN      VARCHAR(200),
 CREATININE VARCHAR(200),
 S_CREAT    VARCHAR(200),
 SODIUM     VARCHAR(200),
 S_SODIUM   VARCHAR(200),
 POTASSIUM  VARCHAR(200),
 S_POTASS   VARCHAR(200),
 CHLORIDE   VARCHAR(200),
 S_CHLORIDE VARCHAR(200),
 MAGNESIUM  VARCHAR(200),
 S_MAGNES   VARCHAR(200),
 BICARB     VARCHAR(200),
 S_BICARB   VARCHAR(200),
 URIC_ACID  VARCHAR(200),
 S_URIC     VARCHAR(200),
 BILIRUBIN  VARCHAR(200),
 S_BILIRUB  VARCHAR(200),
 ALK_PHOS   VARCHAR(200),
 S_ALK_PHOS VARCHAR(200),
 SGOT_AST   VARCHAR(200),
 S_SGOT_AST VARCHAR(200),
 SGPT_ALT   VARCHAR(200),
 S_SGPT_ALT VARCHAR(200),
 SGGT       VARCHAR(200),
 S_SGGT     VARCHAR(200),
 LDH        VARCHAR(200),
 S_LDH      VARCHAR(200),
 TOTAL_PROT VARCHAR(200),
 S_TOT_PROT VARCHAR(200),
 ALBUMIN    VARCHAR(200),
 S_ALBUMIN  VARCHAR(200),
 GLOBULIN   VARCHAR(200),
 S_GLOBULIN VARCHAR(200),
 CALCIUM    VARCHAR(200),
 S_CALCIUM  VARCHAR(200),
 INORG_PHOS VARCHAR(200),
 S_ING_PHOS VARCHAR(200),
 GLUC_FAST  VARCHAR(200),
 S_GLUC_F   VARCHAR(200),
 GLUC_NFAST VARCHAR(200),
 S_GLUC_NF  VARCHAR(200),
 CHOLEST    VARCHAR(200),
 S_CHOLEST  VARCHAR(200),
 AMYLASE    VARCHAR(200),
 S_AMYLASE  VARCHAR(200),
 FIVE_NUCLEO  VARCHAR(200),
 S_5_NUCLEO VARCHAR(200),
 CREAT_PHOS VARCHAR(200),
 S_CREAT_PH VARCHAR(200),
 LOADED_IN_CTOM_DATETIME DATE,
 ID BIGINT NOT NULL AUTO_INCREMENT ,
  PRIMARY KEY (id)
 ) ENGINE=InnoDB  ;
 
 CREATE TABLE cumulative_bm_tab
 (EXTRACT_DT TIMESTAMP DEFAULT NOW(),
  FILE_ID    VARCHAR(200),
  VERSION    VARCHAR(200),
  EXTRACTED  VARCHAR(200),
  ENTERED_BY VARCHAR(200),
  CREATED    VARCHAR(200),
  CHANGED    VARCHAR(200),
  CHG_TIME   VARCHAR(200),
  FILLER     VARCHAR(200),
  DEL_FLAG   VARCHAR(200),
  DEL_DATE   VARCHAR(200),
  PROTOCOL   VARCHAR(200),
  INST_ID    VARCHAR(200),
  ENTRY_PASS VARCHAR(200),
  TOUCH_DATE VARCHAR(200),
  TOUCH_TIME VARCHAR(200),
  COURSE_NUM VARCHAR(200),
  PATIENT    VARCHAR(200),
  LAB_DATE   VARCHAR(200),
  LAB_TIME   VARCHAR(200),
  MYELOBLAST VARCHAR(200),
  S_MYELOBL  VARCHAR(200),
  PROMYELO   VARCHAR(200),
  S_PROMYELO VARCHAR(200),
  MYEL_NEUT  VARCHAR(200),
  S_MYL_NEUT VARCHAR(200),
  MYEL_EOS   VARCHAR(200),
  S_MYL_EOS  VARCHAR(200),
  MYEL_BASOS VARCHAR(200),
  S_MYL_BASO VARCHAR(200),
  METAMYELO  VARCHAR(200),
  S_METAMYEL VARCHAR(200),
  POLY_NEUT  VARCHAR(200),
  S_PLY_NEUT VARCHAR(200),
  POLY_EOS   VARCHAR(200),
  S_PLY_EOS  VARCHAR(200),
  POLY_BASOS VARCHAR(200),
  S_PLY_BASO VARCHAR(200),
  LYMPHOCYTE VARCHAR(200),
  S_LYMPHO   VARCHAR(200),
  PLASMA_CEL VARCHAR(200),
  S_PLAS_CEL VARCHAR(200),
  MONOCYTES  VARCHAR(200),
  S_MONOS    VARCHAR(200),
  RETIC_CELL VARCHAR(200),
  S_RETIC    VARCHAR(200),
  MEGAKARYO  VARCHAR(200),
  S_MEGAKAR  VARCHAR(200),
  PRONORMO   VARCHAR(200),
  S_PRONORMO VARCHAR(200),
  NORMOBLAST VARCHAR(200),
  S_NORMOBL  VARCHAR(200),
  M_RATING   VARCHAR(200),
  S_M_RATING VARCHAR(200),
  LOADED_IN_CTOM_DATETIME DATE,
 ID BIGINT NOT NULL AUTO_INCREMENT ,
   PRIMARY KEY (id)
  ) ENGINE=InnoDB  ;
 
 CREATE TABLE cumulative_bs_tab
 (EXTRACT_DT TIMESTAMP DEFAULT NOW(),
  FILE_ID    VARCHAR(200),
  VERSION    VARCHAR(200),
  EXTRACTED  VARCHAR(200),
  ENTERED_BY VARCHAR(200),
  CREATED    VARCHAR(200),
  CHANGED    VARCHAR(200),
  CHG_TIME   VARCHAR(200),
  FILLER     VARCHAR(200),
  DEL_FLAG   VARCHAR(200),
  DEL_DATE   VARCHAR(200),
  PROTOCOL   VARCHAR(200),
  INST_ID    VARCHAR(200),
  ENTRY_PASS VARCHAR(200),
  TOUCH_DATE VARCHAR(200),
  TOUCH_TIME VARCHAR(200),
  PSEUDO_CRS VARCHAR(200),
  PATIENT    VARCHAR(200),
  ONSET_DATE VARCHAR(200),
  TOXICITY   VARCHAR(200),
  TOX_CODE   VARCHAR(200),
  GRADE      VARCHAR(200),
  RELATION   VARCHAR(200),
  LOADED_IN_CTOM_DATETIME DATE,
 ID BIGINT NOT NULL AUTO_INCREMENT ,
   PRIMARY KEY (id)
  ) ENGINE=InnoDB  ;
  
 CREATE TABLE cumulative_ca_tab
 (EXTRACT_DT TIMESTAMP DEFAULT NOW()   ,
  FILE_ID    VARCHAR(200),
  VERSION    VARCHAR(200),
  EXTRACTED  VARCHAR(200),
  ENTERED_BY VARCHAR(200),
  CREATED    VARCHAR(200),
  CHANGED    VARCHAR(200),
  CHG_TIME   VARCHAR(200),
  FILLER     VARCHAR(200),
  DEL_FLAG   VARCHAR(200),
  DEL_DATE   VARCHAR(200),
  PROTOCOL   VARCHAR(200),
  INST_ID    VARCHAR(200),
  ENTRY_PASS VARCHAR(200),
  TOUCH_DATE VARCHAR(200),
  TOUCH_TIME VARCHAR(200),
  COURSE_NUM VARCHAR(200),
  PATIENT    VARCHAR(200),
  START_DATE VARCHAR(200),
  RESPONSE   VARCHAR(200),
  RESP_DATE  VARCHAR(200),
  PROG_DATE  VARCHAR(200),
  CRS_DISP   VARCHAR(200),
  TOXICITY   VARCHAR(200),
  NOTE       VARCHAR(200),
  DOSE_DIFF  VARCHAR(200),
  LOADED_IN_CTOM_DATETIME DATE,
 ID BIGINT NOT NULL AUTO_INCREMENT ,
   PRIMARY KEY (id)
  ) ENGINE=InnoDB  ;
  
 CREATE TABLE cumulative_ci_tab
 (EXTRACT_DT TIMESTAMP DEFAULT NOW(),
  FILE_ID    VARCHAR(200),
  VERSION    VARCHAR(200),
  EXTRACTED  VARCHAR(200),
  ENTERED_BY VARCHAR(200),
  CREATED    VARCHAR(200),
  CHANGED    VARCHAR(200),
  CHG_TIME   VARCHAR(200),
  FILLER     VARCHAR(200),
  DEL_FLAG   VARCHAR(200),
  DEL_DATE   VARCHAR(200),
  PROTOCOL   VARCHAR(200),
  INST_ID    VARCHAR(200),
  ENTRY_PASS VARCHAR(200),
  TOUCH_DATE VARCHAR(200),
  TOUCH_TIME VARCHAR(200),
  COURSE_NUM VARCHAR(200),
  PATIENT    VARCHAR(200),
  COURSE     VARCHAR(200),
  ARM        VARCHAR(200),
  TREATMENT  VARCHAR(200),
  WEIGHT     VARCHAR(200),
  WGT_UNITS  VARCHAR(200),
  HEIGHT     VARCHAR(200),
  HT_UNITS   VARCHAR(200),
  BSA        VARCHAR(200),
  TREAT_INST VARCHAR(200),
  LOADED_IN_CTOM_DATETIME DATE,
 ID BIGINT NOT NULL AUTO_INCREMENT ,
   PRIMARY KEY (id)
  ) ENGINE=InnoDB  ;
 
 CREATE TABLE cumulative_cm_tab
 (EXTRACT_DT TIMESTAMP DEFAULT NOW(),
  FILE_ID    VARCHAR(200),
  VERSION    VARCHAR(200),
  EXTRACTED  VARCHAR(200),
  ENTERED_BY VARCHAR(200),
  CREATED    VARCHAR(200),
  CHANGED    VARCHAR(200),
  CHG_TIME   VARCHAR(200),
  FILLER     VARCHAR(200),
  DEL_FLAG   VARCHAR(200),
  DEL_DATE   VARCHAR(200),
  PROTOCOL   VARCHAR(200),
  INST_ID    VARCHAR(200),
  ENTRY_PASS VARCHAR(200),
  TOUCH_DATE VARCHAR(200),
  TOUCH_TIME VARCHAR(200),
  COURSE_NUM VARCHAR(200),
  PATIENT    VARCHAR(200),
  START_DATE VARCHAR(200),
  AGENT_PROC VARCHAR(200),
  ITEM       VARCHAR(200),
  TOTAL_DOSE VARCHAR(200),
  UNITS      VARCHAR(200),
  SCHEDULE   VARCHAR(200),
  REASON     VARCHAR(200),
  END_DATE   VARCHAR(200),
  LOADED_IN_CTOM_DATETIME DATE,
 ID BIGINT NOT NULL AUTO_INCREMENT ,
   PRIMARY KEY (id)
  ) ENGINE=InnoDB  ;
 
 CREATE TABLE cumulative_cs_tab
 (EXTRACT_DT TIMESTAMP DEFAULT NOW(),
  FILE_ID    VARCHAR(200),
  VERSION    VARCHAR(200),
  EXTRACTED  VARCHAR(200),
  ENTERED_BY VARCHAR(200),
  CREATED    VARCHAR(200),
  CHANGED    VARCHAR(200),
  CHG_TIME   VARCHAR(200),
  FILLER     VARCHAR(200),
  DEL_FLAG   VARCHAR(200),
  DEL_DATE   VARCHAR(200),
  PROTOCOL   VARCHAR(200),
  INST_ID    VARCHAR(200),
  ENTRY_PASS VARCHAR(200),
  TOUCH_DATE VARCHAR(200),
  TOUCH_TIME VARCHAR(200),
  COURSE_NUM VARCHAR(200),
  CORR_STDY  VARCHAR(200),
  TITLE      VARCHAR(200),
  PATS_COLL  VARCHAR(200),
  PATS_ANAL  VARCHAR(200),
  SMPL_COLL  VARCHAR(200),
  SMPL_ANAL  VARCHAR(200),
  FINDINGS1  VARCHAR(200),
  FINDINGS2  VARCHAR(200),
  FINDINGS3  VARCHAR(200),
  FINDINGS4  VARCHAR(200),
  FINDINGS5  VARCHAR(200),
  FINDINGS6  VARCHAR(200),
  FINDINGS7  VARCHAR(200),
  FINDINGS8  VARCHAR(200),
  LOADED_IN_CTOM_DATETIME DATE,
 ID BIGINT NOT NULL AUTO_INCREMENT ,
   PRIMARY KEY (id)
  ) ENGINE=InnoDB  ;
 
 CREATE TABLE cumulative_da_tab
 (EXTRACT_DT TIMESTAMP DEFAULT NOW(),   
  FILE_ID    VARCHAR(200),
  VERSION    VARCHAR(200),
  EXTRACTED  VARCHAR(200),
  ENTERED_BY VARCHAR(200),
  CREATED    VARCHAR(200),
  CHANGED    VARCHAR(200),
  CHG_TIME   VARCHAR(200),
  FILLER     VARCHAR(200),
  DEL_FLAG   VARCHAR(200),
  DEL_DATE   VARCHAR(200),
  PROTOCOL   VARCHAR(200),
  INST_ID    VARCHAR(200),
  ENTRY_PASS VARCHAR(200),
  TOUCH_DATE VARCHAR(200),
  TOUCH_TIME VARCHAR(200),
  COURSE_NUM VARCHAR(200),
  PATIENT    VARCHAR(200),
  DATE_      VARCHAR(200),                                 
  START_TIME VARCHAR(200),
  DRUG       VARCHAR(200),
  LOT_NUMBER VARCHAR(200),
  DOSE_LEVEL VARCHAR(200),
  LEV_UNITS  VARCHAR(200),
  SCHEDULE   VARCHAR(200),
  TOTAL_DOSE VARCHAR(200),
  TOT_UNITS  VARCHAR(200),
  ROUTE      VARCHAR(200),
  DURATION   VARCHAR(200),
  DUR_UNITS  VARCHAR(200),
  LOADED_IN_CTOM_DATETIME DATE,
 ID BIGINT NOT NULL AUTO_INCREMENT ,
   PRIMARY KEY (id)
  ) ENGINE=InnoDB  ;
 
 CREATE TABLE cumulative_ec_tab
 (EXTRACT_DT TIMESTAMP DEFAULT NOW(),
  FILE_ID    VARCHAR(200),
  VERSION    VARCHAR(200),
  EXTRACTED  VARCHAR(200),
  ENTERED_BY VARCHAR(200),
  CREATED    VARCHAR(200),
  CHANGED    VARCHAR(200),
  CHG_TIME   VARCHAR(200),
  FILLER     VARCHAR(200),
  DEL_FLAG   VARCHAR(200),
  DEL_DATE   VARCHAR(200),
  PROTOCOL   VARCHAR(200),
  INST_ID    VARCHAR(200),
  ENTRY_PASS VARCHAR(200),
  TOUCH_DATE VARCHAR(200),
  TOUCH_TIME VARCHAR(200),
  PSEUDO_CRS VARCHAR(200),
  PATIENT    VARCHAR(200),
  CHECKLIST  VARCHAR(200),
  QUEST_1    VARCHAR(200),
  QUEST_2    VARCHAR(200),
  QUEST_3    VARCHAR(200),
  QUEST_4    VARCHAR(200),
  QUEST_5    VARCHAR(200),
  QUEST_6    VARCHAR(200),
  QUEST_7    VARCHAR(200),
  QUEST_8    VARCHAR(200),
  QUEST_9    VARCHAR(200),
  QUEST_10   VARCHAR(200),
  QUEST_11   VARCHAR(200),
  QUEST_12   VARCHAR(200),
  QUEST_13   VARCHAR(200),
  QUEST_14   VARCHAR(200),
  QUEST_15   VARCHAR(200),
  QUEST_16   VARCHAR(200),
  QUEST_17   VARCHAR(200),
  QUEST_18   VARCHAR(200),
  QUEST_19   VARCHAR(200),
  QUEST_20   VARCHAR(200),
  QUEST_21   VARCHAR(200),
  QUEST_22   VARCHAR(200),
  QUEST_23   VARCHAR(200),
  QUEST_24   VARCHAR(200),
  QUEST_25   VARCHAR(200),
  QUEST_26   VARCHAR(200),
  QUEST_27   VARCHAR(200),
  QUEST_28   VARCHAR(200),
  QUEST_29   VARCHAR(200),
  QUEST_30   VARCHAR(200),
  QUEST_31   VARCHAR(200),
  QUEST_32   VARCHAR(200),
  QUEST_33   VARCHAR(200),
  QUEST_34   VARCHAR(200),
  QUEST_35   VARCHAR(200),
  QUEST_36   VARCHAR(200),
  QUEST_37   VARCHAR(200),
  QUEST_38   VARCHAR(200),
  QUEST_39   VARCHAR(200),
  QUEST_40   VARCHAR(200),
  ELIGIBLE   VARCHAR(200),
  WHY_NOT    VARCHAR(200),
  WAIVER     VARCHAR(200),
  LOADED_IN_CTOM_DATETIME DATE,
 ID BIGINT NOT NULL AUTO_INCREMENT ,
   PRIMARY KEY (id)
  ) ENGINE=InnoDB  ;
 
 CREATE TABLE cumulative_en_tab
 (EXTRACT_DT TIMESTAMP DEFAULT NOW(),
  FILE_ID    VARCHAR(200),
  VERSION    VARCHAR(200),
  EXTRACTED  VARCHAR(200),
  ENTERED_BY VARCHAR(200),
  CREATED    VARCHAR(200),
  CHANGED    VARCHAR(200),
  CHG_TIME   VARCHAR(200),
  FILLER     VARCHAR(200),
  DEL_FLAG   VARCHAR(200),
  DEL_DATE   VARCHAR(200),
  PROTOCOL   VARCHAR(200),
  INST_ID    VARCHAR(200),
  ENTRY_PASS VARCHAR(200),
  TOUCH_DATE VARCHAR(200),
  TOUCH_TIME VARCHAR(200),
  PSEUDO_CRS VARCHAR(200),
  PATIENT    VARCHAR(200),
  SEX        VARCHAR(200),
  RACE       VARCHAR(200),
  ETHNICITY  VARCHAR(200),
  BIRTH_DATE VARCHAR(200),
  REG_DATE   VARCHAR(200),
  AGE        VARCHAR(200),
  WEIGHT     VARCHAR(200),
  WGT_UNITS  VARCHAR(200),
  HEIGHT     VARCHAR(200),
  HT_UNITS   VARCHAR(200),
  FILTER     VARCHAR(200),
  BSA        VARCHAR(200),
  SUBGROUP   VARCHAR(200),
  REG_GROUP  VARCHAR(200),
  REG_INST   VARCHAR(200),
  LOCAL_ID   VARCHAR(200),
  COUNTRY    VARCHAR(200),
  POSTAL_COD VARCHAR(200),
  PAY_METHOD VARCHAR(200),
  DISEASE    VARCHAR(200),
  PRIM_SITE  VARCHAR(200),
  DIS_STAGE  VARCHAR(200),
  GRADE      VARCHAR(200),
  PERF_STAT  VARCHAR(200),
  HISTOLOGY  VARCHAR(200),
  CONFIRMED  VARCHAR(200),
  DIAG_DATE  VARCHAR(200),
  CONSENTED  VARCHAR(200),
  CONSENT_VR VARCHAR(200),
  TREATMENT  VARCHAR(200),
  LOADED_IN_CTOM_DATETIME DATE,
 ID BIGINT NOT NULL AUTO_INCREMENT ,
   PRIMARY KEY (id)
  ) ENGINE=InnoDB  ;
 
 CREATE TABLE cumulative_ep_tab
 (EXTRACT_DT TIMESTAMP DEFAULT NOW(),
  FILE_ID    VARCHAR(200),
  VERSION    VARCHAR(200),
  EXTRACTED  VARCHAR(200),
  ENTERED_BY VARCHAR(200),
  CREATED    VARCHAR(200),
  CHANGED    VARCHAR(200),
  CHG_TIME   VARCHAR(200),
  FILLER     VARCHAR(200),
  DEL_FLAG   VARCHAR(200),
  DEL_DATE   VARCHAR(200),
  PROTOCOL   VARCHAR(200),
  INST_ID    VARCHAR(200),
  ENTRY_PASS VARCHAR(200),
  TOUCH_DATE VARCHAR(200),
  TOUCH_TIME VARCHAR(200),
  PSEUDO_CRS VARCHAR(200),
  SUBGROUP   VARCHAR(200),
  TREATMENT  VARCHAR(200),
  LOADED_IN_CTOM_DATETIME DATE,
 ID BIGINT NOT NULL AUTO_INCREMENT ,
   PRIMARY KEY (id)
  ) ENGINE=InnoDB  ;
 
 CREATE TABLE cumulative_ex_tab
 (EXTRACT_DT TIMESTAMP DEFAULT NOW(),
  FILE_ID    VARCHAR(200),
  VERSION    VARCHAR(200),
  EXTRACTED  VARCHAR(200),
  ENTERED_BY VARCHAR(200),
  CREATED    VARCHAR(200),
  CHANGED    VARCHAR(200),
  CHG_TIME   VARCHAR(200),
  FILLER     VARCHAR(200),
  DEL_FLAG   VARCHAR(200),
  DEL_DATE   VARCHAR(200),
  PROTOCOL   VARCHAR(200),
  INST_ID    VARCHAR(200),
  ENTRY_PASS VARCHAR(200),
  TOUCH_DATE VARCHAR(200),
  TOUCH_TIME VARCHAR(200),
  COURSE_NUM VARCHAR(200),
  PATIENT    VARCHAR(200),
  LAB_DATE   VARCHAR(200),
  LAB_TIME   VARCHAR(200),
  PANEL      VARCHAR(200),
  LAB_GROUP  VARCHAR(200),
  LAB_CODE   VARCHAR(200),
  TEST_1     VARCHAR(200),
  S_TEST_1   VARCHAR(200),
  TEST_2     VARCHAR(200),
  S_TEST_2   VARCHAR(200),
  TEST_3     VARCHAR(200),
  S_TEST_3   VARCHAR(200),
  TEST_4     VARCHAR(200),
  S_TEST_4   VARCHAR(200),
  TEST_5     VARCHAR(200),
  S_TEST_5   VARCHAR(200),
  TEST_6     VARCHAR(200),
  S_TEST_6   VARCHAR(200),
  TEST_7     VARCHAR(200),
  S_TEST_7   VARCHAR(200),
  TEST_8     VARCHAR(200),
  S_TEST_8   VARCHAR(200),
  TEST_9     VARCHAR(200),
  S_TEST_9   VARCHAR(200),
  TEST_10    VARCHAR(200),
  S_TEST_10  VARCHAR(200),
  TEST_11    VARCHAR(200),
  S_TEST_11  VARCHAR(200),
  TEST_12    VARCHAR(200),
  S_TEST_12  VARCHAR(200),
  TEST_13    VARCHAR(200),
  S_TEST_13  VARCHAR(200),
  TEST_14    VARCHAR(200),
  S_TEST_14  VARCHAR(200),
  TEST_15    VARCHAR(200),
  S_TEST_15  VARCHAR(200),
  TEST_16    VARCHAR(200),
  S_TEST_16  VARCHAR(200),
  TEST_17    VARCHAR(200),
  S_TEST_17  VARCHAR(200),
  TEST_18    VARCHAR(200),
  S_TEST_18  VARCHAR(200),
  TEST_19    VARCHAR(200),
  S_TEST_19  VARCHAR(200),
  TEST_20    VARCHAR(200),
  S_TEST_20  VARCHAR(200),
  TEST_21    VARCHAR(200),
  S_TEST_21  VARCHAR(200),
  TEST_22    VARCHAR(200),
  S_TEST_22  VARCHAR(200),
  TEST_23    VARCHAR(200),
  S_TEST_23  VARCHAR(200),
  TEST_24    VARCHAR(200),
  S_TEST_24  VARCHAR(200),
  TEST_25    VARCHAR(200),
  S_TEST_25  VARCHAR(200),
  LOADED_IN_CTOM_DATETIME DATE,
 ID BIGINT NOT NULL AUTO_INCREMENT ,
   PRIMARY KEY (id)
  ) ENGINE=InnoDB  ;
 
 CREATE TABLE cumulative_fo_tab
 (EXTRACT_DT TIMESTAMP DEFAULT NOW()    ,
  FILE_ID    VARCHAR(200),
  VERSION    VARCHAR(200),
  EXTRACTED  VARCHAR(200),
  ENTERED_BY VARCHAR(200),
  CREATED    VARCHAR(200),
  CHANGED    VARCHAR(200),
  CHG_TIME   VARCHAR(200),
  FILLER     VARCHAR(200),
  DEL_FLAG   VARCHAR(200),
  DEL_DATE   VARCHAR(200),
  PROTOCOL   VARCHAR(200),
  INST_ID    VARCHAR(200),
  ENTRY_PASS VARCHAR(200),
  TOUCH_DATE VARCHAR(200),
  TOUCH_TIME VARCHAR(200),
  PSEUDO_CRS VARCHAR(200),
  PATIENT    VARCHAR(200),
  OFF_TREAT  VARCHAR(200),
  OFF_FOLLOW VARCHAR(200),
  REASON     VARCHAR(200),
  OTH_REASON VARCHAR(200),
  BEST_RESP  VARCHAR(200),
  DATE_BEST  VARCHAR(200),
  DATE_PROG  VARCHAR(200),
  LOADED_IN_CTOM_DATETIME DATE,
 ID BIGINT NOT NULL AUTO_INCREMENT ,
   PRIMARY KEY (id)
  ) ENGINE=InnoDB  ;
 
 CREATE TABLE cumulative_hm_tab
 (EXTRACT_DT TIMESTAMP DEFAULT NOW(),
  FILE_ID    VARCHAR(200),
  VERSION    VARCHAR(200),
  EXTRACTED  VARCHAR(200),
  ENTERED_BY VARCHAR(200),
  CREATED    VARCHAR(200),
  CHANGED    VARCHAR(200),
  CHG_TIME   VARCHAR(200),
  FILLER     VARCHAR(200),
  DEL_FLAG   VARCHAR(200),
  DEL_DATE   VARCHAR(200),
  PROTOCOL   VARCHAR(200),
  INST_ID    VARCHAR(200),
  ENTRY_PASS VARCHAR(200),
  TOUCH_DATE VARCHAR(200),
  TOUCH_TIME VARCHAR(200),
  COURSE_NUM VARCHAR(200),
  PATIENT    VARCHAR(200),
  LAB_DATE   VARCHAR(200),
  LAB_TIME   VARCHAR(200),
  LAB_GROUP  VARCHAR(200),
  LAB_CODE   VARCHAR(200),
  HEMOGLOBIN VARCHAR(200),
  S_HEMOGLOB VARCHAR(200),
  HEMATOCRIT VARCHAR(200),
  S_HEMATOCR VARCHAR(200),
  WBC        VARCHAR(200),
  S_WBC      VARCHAR(200),
  NEUTROPHIL VARCHAR(200),
  S_NEUTROS  VARCHAR(200),
  LYMPHOCYTE VARCHAR(200),
  S_LYMPHOS  VARCHAR(200),
  BASOPHILS  VARCHAR(200),
  S_BASOS    VARCHAR(200),
  MONOCYTES  VARCHAR(200),
  S_MONOS    VARCHAR(200),
  EOSINOPHIL VARCHAR(200),
  S_EOS      VARCHAR(200),
  BANDS      VARCHAR(200),
  S_BANDS    VARCHAR(200),
  BLASTS     VARCHAR(200),
  S_BLASTS   VARCHAR(200),
  ATYP_LYMPH VARCHAR(200),
  S_ATYP_LYM VARCHAR(200),
  OTHER_DIFF VARCHAR(200),
  S_OTH_DIFF VARCHAR(200),
  PLATELETS  VARCHAR(200),
  S_PLATES   VARCHAR(200),
  ANC        VARCHAR(200),
  S_ANC      VARCHAR(200),
  RBC        VARCHAR(200),
  S_RBC      VARCHAR(200),
  RETICULO   VARCHAR(200),
  S_RETICULO VARCHAR(200),
  ESR        VARCHAR(200),
  S_ESR      VARCHAR(200),
  PT         VARCHAR(200),
  S_PT       VARCHAR(200),
  PTT        VARCHAR(200),
  S_PTT      VARCHAR(200),
  LOADED_IN_CTOM_DATETIME DATE,
 ID BIGINT NOT NULL AUTO_INCREMENT ,
   PRIMARY KEY (id)
  ) ENGINE=InnoDB  ;
 
 CREATE TABLE cumulative_fp_tab
 (EXTRACT_DT TIMESTAMP DEFAULT NOW(),
  FILE_ID    VARCHAR(200),
  VERSION    VARCHAR(200),
  EXTRACTED  VARCHAR(200),
  ENTERED_BY VARCHAR(200),
  CREATED    VARCHAR(200),
  CHANGED    VARCHAR(200),
  CHG_TIME   VARCHAR(200),
  FILLER     VARCHAR(200),
  DEL_FLAG   VARCHAR(200),
  DEL_DATE   VARCHAR(200),
  PROTOCOL   VARCHAR(200),
  INST_ID    VARCHAR(200),
  ENTRY_PASS VARCHAR(200),
  TOUCH_DATE VARCHAR(200),
  TOUCH_TIME VARCHAR(200),
  PSEUDO_CRS VARCHAR(200),
  PATIENT    VARCHAR(200),
  LAST_CONT  VARCHAR(200),
  STATUS     VARCHAR(200),
  SPECIFY    VARCHAR(200),
  LOADED_IN_CTOM_DATETIME DATE,
 ID BIGINT NOT NULL AUTO_INCREMENT ,
   PRIMARY KEY (id)
  ) ENGINE=InnoDB  ;
 
 CREATE TABLE cumulative_ie_tab
 (EXTRACT_DT TIMESTAMP DEFAULT NOW(),
  FILE_ID    VARCHAR(200),
  VERSION    VARCHAR(200),
  EXTRACTED  VARCHAR(200),
  ENTERED_BY VARCHAR(200),
  CREATED    VARCHAR(200),
  CHANGED    VARCHAR(200),
  CHG_TIME   VARCHAR(200),
  FILLER     VARCHAR(200),
  DEL_FLAG   VARCHAR(200),
  DEL_DATE   VARCHAR(200),
  PROTOCOL   VARCHAR(200),
  INST_ID    VARCHAR(200),
  ENTRY_PASS VARCHAR(200),
  TOUCH_DATE VARCHAR(200),
  TOUCH_TIME VARCHAR(200),
  COURSE_NUM VARCHAR(200),
  PATIENT    VARCHAR(200),
  ONSET_DATE VARCHAR(200),
  INFECTION  VARCHAR(200),
  PRIM_SITE  VARCHAR(200),
  INF_AGENT  VARCHAR(200),
  TREATMENTS VARCHAR(200),
  RESOLVED   VARCHAR(200),
  OUTCOME    VARCHAR(200),
  LOADED_IN_CTOM_DATETIME DATE,
 ID BIGINT NOT NULL AUTO_INCREMENT ,
   PRIMARY KEY (id)
  ) ENGINE=InnoDB  ;
 
 CREATE TABLE cumulative_dt_tab
 (EXTRACT_DT TIMESTAMP DEFAULT NOW(),
  FILE_ID    VARCHAR(200),
  VERSION    VARCHAR(200),
  EXTRACTED  VARCHAR(200),
  ENTERED_BY VARCHAR(200),
  CREATED    VARCHAR(200),
  CHANGED    VARCHAR(200),
  CHG_TIME   VARCHAR(200),
  FILLER     VARCHAR(200),
  DEL_FLAG   VARCHAR(200),
  DEL_DATE   VARCHAR(200),
  PROTOCOL   VARCHAR(200),
  INST_ID    VARCHAR(200),
  ENTRY_PASS VARCHAR(200),
  TOUCH_DATE VARCHAR(200),
  TOUCH_TIME VARCHAR(200),
  PSEUDO_CRS VARCHAR(200),
  SUBGROUP   VARCHAR(200),
  TOXICITY   VARCHAR(200),
  TOX_CODE   VARCHAR(200),
  LOADED_IN_CTOM_DATETIME DATE,
 ID BIGINT NOT NULL AUTO_INCREMENT ,
   PRIMARY KEY (id)
  ) ENGINE=InnoDB  ;
 
 CREATE TABLE cumulative_la_tab
 (EXTRACT_DT TIMESTAMP DEFAULT NOW(),
  FILE_ID    VARCHAR(200),
  VERSION    VARCHAR(200),
  EXTRACTED  VARCHAR(200),
  ENTERED_BY VARCHAR(200),
  CREATED    VARCHAR(200),
  CHANGED    VARCHAR(200),
  CHG_TIME   VARCHAR(200),
  FILLER     VARCHAR(200),
  DEL_FLAG   VARCHAR(200),
  DEL_DATE   VARCHAR(200),
  PROTOCOL   VARCHAR(200),
  INST_ID    VARCHAR(200),
  ENTRY_PASS VARCHAR(200),
  TOUCH_DATE VARCHAR(200),
  TOUCH_TIME VARCHAR(200),
  COURSE_NUM VARCHAR(200),
  PATIENT    VARCHAR(200),
  FOLLOW_UP  VARCHAR(200),
  TOXICITY   VARCHAR(200),
  ONSET_DATE VARCHAR(200),
  TOX_CODE   VARCHAR(200),
  RESOLVED   VARCHAR(200),
  AER_FILED  VARCHAR(200),
  GRADE      VARCHAR(200),
  ATTRIBUT   VARCHAR(200),
  DOSE_LIMIT VARCHAR(200),
  SERIOUS    VARCHAR(200),
  ACTION     VARCHAR(200),
  THERAPY    VARCHAR(200),
  OUTCOME    VARCHAR(200),
  LOADED_IN_CTOM_DATETIME DATE,
 ID BIGINT NOT NULL AUTO_INCREMENT ,
   PRIMARY KEY (id)
  ) ENGINE=InnoDB  ;
 
 CREATE TABLE cumulative_ll_tab
 (EXTRACT_DT TIMESTAMP DEFAULT NOW(),
  FILE_ID    VARCHAR(200),
  VERSION    VARCHAR(200),
  EXTRACTED  VARCHAR(200),
  ENTERED_BY VARCHAR(200),
  CREATED    VARCHAR(200),
  CHANGED    VARCHAR(200),
  CHG_TIME   VARCHAR(200),
  FILLER     VARCHAR(200),
  DEL_FLAG   VARCHAR(200),
  DEL_DATE   VARCHAR(200),
  PROTOCOL   VARCHAR(200),
  INST_ID    VARCHAR(200),
  ENTRY_PASS VARCHAR(200),
  TOUCH_DATE VARCHAR(200),
  TOUCH_TIME VARCHAR(200), 
  COURSE_NUM VARCHAR(200),
  PATIENT    VARCHAR(200),
  LAB_DATE   VARCHAR(200),
  LAB_TIME   VARCHAR(200),
  LAB_TEST   VARCHAR(200),
  BODY_SITE  VARCHAR(200),
  LAB_GROUP  VARCHAR(200),
  LAB_CODE   VARCHAR(200),
  NORM_ABNOR VARCHAR(200),
  RESULT     VARCHAR(200),
  RESULT_2   VARCHAR(200),
  S_RESULT   VARCHAR(200),
  LOADED_IN_CTOM_DATETIME DATE,
 ID BIGINT NOT NULL AUTO_INCREMENT ,
   PRIMARY KEY (id)
  ) ENGINE=InnoDB  ;
 
 CREATE TABLE cumulative_ls_tab
 (EXTRACT_DT TIMESTAMP DEFAULT NOW(),
  FILE_ID    VARCHAR(200),
  VERSION    VARCHAR(200),
  EXTRACTED  VARCHAR(200),
  ENTERED_BY VARCHAR(200),
  CREATED    VARCHAR(200),
  CHANGED    VARCHAR(200),
  CHG_TIME   VARCHAR(200),
  FILLER     VARCHAR(200),
  DEL_FLAG   VARCHAR(200),
  DEL_DATE   VARCHAR(200),
  PROTOCOL   VARCHAR(200),
  INST_ID    VARCHAR(200),
  ENTRY_PASS VARCHAR(200),
  TOUCH_DATE VARCHAR(200),
  TOUCH_TIME VARCHAR(200),
  PSEUDO_CRS VARCHAR(200),
  PATIENT    VARCHAR(200),
  LESION     VARCHAR(200),
  ORGAN      VARCHAR(200),
  DESCRIP    VARCHAR(200),
  PREV_RAD   VARCHAR(200),
  CATEGORY   VARCHAR(200),
  FOLLOWED   VARCHAR(200),
  LOADED_IN_CTOM_DATETIME DATE,
 ID BIGINT NOT NULL AUTO_INCREMENT ,
   PRIMARY KEY (id)
  ) ENGINE=InnoDB  ;
 
 CREATE TABLE cumulative_lx_tab
 (EXTRACT_DT TIMESTAMP DEFAULT NOW(),
  FILE_ID    VARCHAR(200),
  VERSION    VARCHAR(200),
  EXTRACTED  VARCHAR(200),
  ENTERED_BY VARCHAR(200),
  CREATED    VARCHAR(200),
  CHANGED    VARCHAR(200),
  CHG_TIME   VARCHAR(200),
  FILLER     VARCHAR(200),
  DEL_FLAG   VARCHAR(200),
  DEL_DATE   VARCHAR(200),
  PROTOCOL   VARCHAR(200),
  INST_ID    VARCHAR(200),
  ENTRY_PASS VARCHAR(200),
  TOUCH_DATE VARCHAR(200),
  TOUCH_TIME VARCHAR(200),
  COURSE_NUM VARCHAR(200),
  PATIENT    VARCHAR(200),
  LAB_DATE   VARCHAR(200),
  LAB_TIME   VARCHAR(200),
  PANEL      VARCHAR(200),  
  FIELD_1    VARCHAR(200),
  FIELD_2    VARCHAR(200),
  FIELD_3    VARCHAR(200),
  FIELD_4    VARCHAR(200),
  FIELD_5    VARCHAR(200),
  FIELD_6    VARCHAR(200),
  FIELD_7    VARCHAR(200),
  FIELD_8    VARCHAR(200),
  FIELD_9    VARCHAR(200),
  FIELD_10   VARCHAR(200),
  LOADED_IN_CTOM_DATETIME DATE,
 ID BIGINT NOT NULL AUTO_INCREMENT ,
   PRIMARY KEY (id)
  ) ENGINE=InnoDB  ;
 
 CREATE TABLE cumulative_mh_tab 
 (EXTRACT_DT TIMESTAMP DEFAULT NOW(),
  FILE_ID    VARCHAR(200),
  VERSION    VARCHAR(200),
  EXTRACTED  VARCHAR(200),
  ENTERED_BY VARCHAR(200),
  CREATED    VARCHAR(200),
  CHANGED    VARCHAR(200),
  CHG_TIME   VARCHAR(200),
  FILLER     VARCHAR(200),
  DEL_FLAG   VARCHAR(200),
  DEL_DATE   VARCHAR(200),
  PROTOCOL   VARCHAR(200),
  INST_ID    VARCHAR(200),
  ENTRY_PASS VARCHAR(200),
  TOUCH_DATE VARCHAR(200),
  TOUCH_TIME VARCHAR(200),
  PSEUDO_CRS VARCHAR(200),
  PATIENT    VARCHAR(200),
  EXAM_DATE  VARCHAR(200),
  HEENT      VARCHAR(200),
  HEENT_2    VARCHAR(200),
  NECK       VARCHAR(200),
  NECK_2     VARCHAR(200),
  RESPIRAT   VARCHAR(200),
  RESPIRAT_2 VARCHAR(200),
  CARDIO     VARCHAR(200),
  CARDIO_2   VARCHAR(200),
  GASTRO     VARCHAR(200),
  GASTRO_2   VARCHAR(200),
  MUSCSKEL   VARCHAR(200),
  MUSCSKEL_2 VARCHAR(200),
  DERMAT     VARCHAR(200),
  DERMAT_2   VARCHAR(200),
  HEM_LYM    VARCHAR(200),
  HEM_LYM_2  VARCHAR(200),
  ENDO_MET   VARCHAR(200),
  ENDO_MET_2 VARCHAR(200),
  URINARY    VARCHAR(200),
  URINARY_2  VARCHAR(200),
  GENITAL    VARCHAR(200),
  GENITAL_2  VARCHAR(200),
  BREASTS    VARCHAR(200),
  BREASTS_2  VARCHAR(200),
  PELVIS     VARCHAR(200),
  PELVIS_2   VARCHAR(200),
  ABDOMEN    VARCHAR(200),
  ABDOMEN_2  VARCHAR(200),
  NEUROLOG   VARCHAR(200),
  NEUROLOG_2 VARCHAR(200),
  PSYCHOL    VARCHAR(200),
  PSYCHOL_2  VARCHAR(200),
  IMMUNE     VARCHAR(200),
  IMMUNE_2   VARCHAR(200),
  OTHER      VARCHAR(200),
  OTHER_2    VARCHAR(200),
  LOADED_IN_CTOM_DATETIME DATE,
 ID BIGINT NOT NULL AUTO_INCREMENT ,
   PRIMARY KEY (id)
  ) ENGINE=InnoDB  ;
 
 CREATE TABLE cumulative_ou_tab 
  (EXTRACT_DT TIMESTAMP DEFAULT NOW(),
  FILE_ID    VARCHAR(200),
  VERSION    VARCHAR(200),
  EXTRACTED  VARCHAR(200),
  ENTERED_BY VARCHAR(200),
  CREATED    VARCHAR(200),
  CHANGED    VARCHAR(200),
  CHG_TIME   VARCHAR(200),
  FILLER     VARCHAR(200),
  DEL_FLAG   VARCHAR(200),
  DEL_DATE   VARCHAR(200),
  PROTOCOL   VARCHAR(200),
  INST_ID    VARCHAR(200),
  ENTRY_PASS VARCHAR(200),
  TOUCH_DATE VARCHAR(200),
  TOUCH_TIME VARCHAR(200),
  COURSE_NUM VARCHAR(200),
  PATIENT    VARCHAR(200),
  LAB_DATE   VARCHAR(200),
  LAB_TIME   VARCHAR(200),
  LAB_GROUP  VARCHAR(200),
  LAB_CODE   VARCHAR(200),
  CALCIUM    VARCHAR(200),
  S_CALCIUM  VARCHAR(200),
  CHLORIDE   VARCHAR(200),
  S_CHLORIDE VARCHAR(200),
  OSMOLALITY VARCHAR(200),
  S_OSMOLAL  VARCHAR(200),
  OXALATE    VARCHAR(200),
  S_OXALATE  VARCHAR(200),
  POTASSIUM  VARCHAR(200),
  S_POTASS   VARCHAR(200),
  PROT_ALBUM VARCHAR(200),
  S_PROT_ALB VARCHAR(200),
  PROT_ALPH1 VARCHAR(200),
  S_PROT_AL1 VARCHAR(200),
  PROT_ALPH2 VARCHAR(200),
  S_PROT_AL2 VARCHAR(200),
  PROT_BETA  VARCHAR(200),
  S_PROT_BET VARCHAR(200),
  PROT_GAMMA VARCHAR(200),
  S_PROT_GAM VARCHAR(200),
  SODIUM     VARCHAR(200),
  S_SODIUM   VARCHAR(200),
  UREA_NITRO VARCHAR(200),
  S_UREA_NIT VARCHAR(200),
  URIC_ACID  VARCHAR(200),
  S_URIC_AC  VARCHAR(200),
  LOADED_IN_CTOM_DATETIME DATE,
 ID BIGINT NOT NULL AUTO_INCREMENT ,
   PRIMARY KEY (id)
  ) ENGINE=InnoDB  ;
 
 CREATE TABLE cumulative_pe_tab 
 (EXTRACT_DT TIMESTAMP DEFAULT NOW(),
  FILE_ID    VARCHAR(200),
  VERSION    VARCHAR(200),
  EXTRACTED  VARCHAR(200),
  ENTERED_BY VARCHAR(200),
  CREATED    VARCHAR(200),
  CHANGED    VARCHAR(200),
  CHG_TIME   VARCHAR(200),
  FILLER     VARCHAR(200),
  DEL_FLAG   VARCHAR(200),
  DEL_DATE   VARCHAR(200),
  PROTOCOL   VARCHAR(200),
  INST_ID    VARCHAR(200),
  ENTRY_PASS VARCHAR(200),
  TOUCH_DATE VARCHAR(200),
  TOUCH_TIME VARCHAR(200),
  COURSE_NUM VARCHAR(200),
  PATIENT    VARCHAR(200),
  EXAM_DATE  VARCHAR(200),
  HEENT      VARCHAR(200),
  HEENT_1    VARCHAR(200),
  HEENT_2    VARCHAR(200),
  NECK       VARCHAR(200),
  NECK_1     VARCHAR(200),
  NECK_2     VARCHAR(200),
  RESPIRAT   VARCHAR(200),
  RESPIRAT_1 VARCHAR(200),
  RESPIRAT_2 VARCHAR(200),
  CARDIO     VARCHAR(200),
  CARDIO_1   VARCHAR(200),
  CARDIO_2   VARCHAR(200),
  GASTRO     VARCHAR(200),
  GASTRO_1   VARCHAR(200),
  GASTRO_2   VARCHAR(200),
  MUSCSKEL   VARCHAR(200),
  MUSCSKEL_1 VARCHAR(200),
  MUSCSKEL_2 VARCHAR(200),
  DERMAT     VARCHAR(200),
  DERMAT_1   VARCHAR(200),
  DERMAT_2   VARCHAR(200),
  HEM_LYM    VARCHAR(200),
  HEM_LYM_1  VARCHAR(200),
  HEM_LYM_2  VARCHAR(200),
  ENDO_MET   VARCHAR(200),
  ENDO_MET_1 VARCHAR(200),
  ENDO_MET_2 VARCHAR(200),
  URINARY    VARCHAR(200),
  URINARY_1  VARCHAR(200),
  URINARY_2  VARCHAR(200),
  GENITAL    VARCHAR(200),
  GENITAL_1  VARCHAR(200),
  GENITAL_2  VARCHAR(200),
  BREASTS    VARCHAR(200),
  BREASTS_1  VARCHAR(200),
  BREASTS_2  VARCHAR(200),
  PELVIS     VARCHAR(200),
  PELVIS_1   VARCHAR(200),
  PELVIS_2   VARCHAR(200),
  ABDOMEN    VARCHAR(200),
  ABDOMEN_1  VARCHAR(200),
  ABDOMEN_2  VARCHAR(200),
  NEUROLOG   VARCHAR(200),
  NEUROLOG_1 VARCHAR(200),
  NEUROLOG_2 VARCHAR(200),
  PSYCHOL    VARCHAR(200),
  PSYCHOL_1  VARCHAR(200),
  PSYCHOL_2  VARCHAR(200),
  OTHER      VARCHAR(200),
  OTHER_1    VARCHAR(200),
  OTHER_2    VARCHAR(200),
  LOADED_IN_CTOM_DATETIME DATE,
 ID BIGINT NOT NULL AUTO_INCREMENT ,
   PRIMARY KEY (id)
  ) ENGINE=InnoDB  ;
 
 CREATE TABLE cumulative_pk_tab
 (EXTRACT_DT TIMESTAMP DEFAULT NOW(),
  FILE_ID    VARCHAR(200),
  VERSION    VARCHAR(200),
  EXTRACTED  VARCHAR(200),
  ENTERED_BY VARCHAR(200),
  CREATED    VARCHAR(200),
  CHANGED    VARCHAR(200),
  CHG_TIME   VARCHAR(200),
  FILLER     VARCHAR(200),
  DEL_FLAG   VARCHAR(200),
  DEL_DATE   VARCHAR(200),
  PROTOCOL   VARCHAR(200),
  INST_ID    VARCHAR(200),
  ENTRY_PASS VARCHAR(200),
  TOUCH_DATE VARCHAR(200),
  TOUCH_TIME VARCHAR(200),
  COURSE_NUM VARCHAR(200),
  PATIENT    VARCHAR(200),
  STUDY_DRUG VARCHAR(200),
  DOSINGDATE VARCHAR(200),
  START_TIME VARCHAR(200),
  SPECIMEN   VARCHAR(200),
  DURATION   VARCHAR(200),
  PAR_ASY_1  VARCHAR(200),
  PAR_UN_AS1 VARCHAR(200),
  PAR_ASY_2  VARCHAR(200),
  PAR_UN_AS2 VARCHAR(200),
  PAR_CONC   VARCHAR(200),
  PAR_UNITS  VARCHAR(200),
  MET_ASY_1  VARCHAR(200),
  MET_UN_AS1 VARCHAR(200),
  MET_ASY_2  VARCHAR(200),
  MET_UN_AS2 VARCHAR(200),
  MET_CONC   VARCHAR(200),
  MET_UNITS  VARCHAR(200),
  LOADED_IN_CTOM_DATETIME DATE,
 ID BIGINT NOT NULL AUTO_INCREMENT ,
   PRIMARY KEY (id)
  ) ENGINE=InnoDB  ;
 
 CREATE TABLE cumulative_ph_tab
  (EXTRACT_DT TIMESTAMP DEFAULT NOW(),
  FILE_ID    VARCHAR(200),
  VERSION    VARCHAR(200),
  EXTRACTED  VARCHAR(200),
  ENTERED_BY VARCHAR(200),
  CREATED    VARCHAR(200),
  CHANGED    VARCHAR(200),
  CHG_TIME   VARCHAR(200),
  FILLER     VARCHAR(200),
  DEL_FLAG   VARCHAR(200),
  DEL_DATE   VARCHAR(200),
  PROTOCOL   VARCHAR(200),
  INST_ID    VARCHAR(200),
  ENTRY_PASS VARCHAR(200),
  TOUCH_DATE VARCHAR(200),
  TOUCH_TIME VARCHAR(200),
  COURSE_NUM VARCHAR(200),
  PATIENT    VARCHAR(200),
  NOTE_DATE  VARCHAR(200),
  NOTE_TYPE  VARCHAR(200),
  NOTE       VARCHAR(1024),
  LOADED_IN_CTOM_DATETIME DATE,
 ID BIGINT NOT NULL AUTO_INCREMENT ,
   PRIMARY KEY (id)
  ) ENGINE=InnoDB  ;
 
 CREATE TABLE cumulative_ps_tab
 (EXTRACT_DT TIMESTAMP DEFAULT NOW(),
  FILE_ID    VARCHAR(200),
  VERSION    VARCHAR(200),
  EXTRACTED  VARCHAR(200),
  ENTERED_BY VARCHAR(200),
  CREATED    VARCHAR(200),
  CHANGED    VARCHAR(200),
  CHG_TIME   VARCHAR(200),
  FILLER     VARCHAR(200),
  DEL_FLAG   VARCHAR(200),
  DEL_DATE   VARCHAR(200),
  PROTOCOL   VARCHAR(200),
  INST_ID    VARCHAR(200),
  ENTRY_PASS VARCHAR(200),
  TOUCH_DATE VARCHAR(200),
  TOUCH_TIME VARCHAR(200),
  PSEUDO_CRS VARCHAR(200),
  PATIENT    VARCHAR(200),
  DATE_      VARCHAR(200),
  PROC_SITE  VARCHAR(200),
  ITEM       VARCHAR(200),
  FINDINGS   VARCHAR(200),
  RESID_DIS  VARCHAR(200),
  SURG_CODE  VARCHAR(200),
  LOADED_IN_CTOM_DATETIME DATE,
 ID BIGINT NOT NULL AUTO_INCREMENT ,
   PRIMARY KEY (id)
  ) ENGINE=InnoDB  ;
 
 CREATE TABLE cumulative_pt_tab
  (EXTRACT_DT TIMESTAMP DEFAULT NOW(),
  FILE_ID    VARCHAR(200),
  VERSION    VARCHAR(200),
  EXTRACTED  VARCHAR(200),
  ENTERED_BY VARCHAR(200),
  CREATED    VARCHAR(200),
  CHANGED    VARCHAR(200),
  CHG_TIME   VARCHAR(200),
  FILLER     VARCHAR(200),
  DEL_FLAG   VARCHAR(200),
  DEL_DATE   VARCHAR(200),
  PROTOCOL   VARCHAR(200),
  INST_ID    VARCHAR(200),
  ENTRY_PASS VARCHAR(200),
  TOUCH_DATE VARCHAR(200),
  TOUCH_TIME VARCHAR(200),
  PSEUDO_CRS VARCHAR(200),
  PATIENT    VARCHAR(200),
  START_DATE VARCHAR(200),
  AGENT      VARCHAR(200),
  ITEM       VARCHAR(200),
  STOP_DATE  VARCHAR(200),
  SCHEDULE   VARCHAR(200),
  TOTAL_DOSE VARCHAR(200),
  UNITS      VARCHAR(200),
  RESPONSE   VARCHAR(200),
  THRPY_CODE VARCHAR(200),
  LOADED_IN_CTOM_DATETIME DATE,
 ID BIGINT NOT NULL AUTO_INCREMENT ,
   PRIMARY KEY (id)
  ) ENGINE=InnoDB  ;
 
 CREATE TABLE cumulative_rc_tab
  (EXTRACT_DT TIMESTAMP DEFAULT NOW(),
  FILE_ID    VARCHAR(200),
  VERSION    VARCHAR(200),
  EXTRACTED  VARCHAR(200),
  ENTERED_BY VARCHAR(200),
  CREATED    VARCHAR(200),
  CHANGED    VARCHAR(200),
  CHG_TIME   VARCHAR(200),
  FILLER     VARCHAR(200),
  DEL_FLAG   VARCHAR(200),
  DEL_DATE   VARCHAR(200),
  PROTOCOL   VARCHAR(200),
  INST_ID    VARCHAR(200),
  ENTRY_PASS VARCHAR(200),
  TOUCH_DATE VARCHAR(200),
  TOUCH_TIME VARCHAR(200),
  COURSE_NUM VARCHAR(200),
  PATIENT    VARCHAR(200),
  LAB_DATE   VARCHAR(200),
  LAB_TIME   VARCHAR(200),
  LAB_GROUP  VARCHAR(200),
  LAB_CODE   VARCHAR(200),
  MCH        VARCHAR(200),
  S_MCH      VARCHAR(200),
  MCHC       VARCHAR(200),
  S_MCHC     VARCHAR(200),
  MCV        VARCHAR(200),
  S_MCV      VARCHAR(200),
  BLEED_TIME VARCHAR(200),
  S_BLEED_TM VARCHAR(200),
  CLOT_RETR  VARCHAR(200),
  S_CLOT_RET VARCHAR(200),
  SEMI_QUANT VARCHAR(200),
  S_SEMI_QNT VARCHAR(200),
  QUANT      VARCHAR(200),
  S_QUANT    VARCHAR(200),
  CLOT_TIME  VARCHAR(200),
  S_CLOT_TM  VARCHAR(200),
  FDP        VARCHAR(200),
  S_FIBR_DGR VARCHAR(200),
  FIBRINOGEN VARCHAR(200),
  S_FIBRIN   VARCHAR(200),
  THROMB_TIM VARCHAR(200),
  S_THROMB_T VARCHAR(200),
  NUCL_RBCS  VARCHAR(200),
  S_NUCL_RBC VARCHAR(200),
  COMPLEMENT VARCHAR(200),
  S_COMPLEM  VARCHAR(200),
  COOMBS_TST VARCHAR(200),
  S_COOMBS   VARCHAR(200),
  ANF        VARCHAR(200),
  S_ANF      VARCHAR(200),
  TOT_SER_PR VARCHAR(200),
  S_T_SERPRO VARCHAR(200),
  ALBUMIN    VARCHAR(200),
  S_ALBUMIN  VARCHAR(200),
  ALPHA1     VARCHAR(200),
  S_ALPHA1   VARCHAR(200),
  ALPHA2     VARCHAR(200),
  S_ALPHA2   VARCHAR(200),
  BETA       VARCHAR(200),
  S_BETA     VARCHAR(200),
  GAMMA      VARCHAR(200),
  S_GAMMA    VARCHAR(200),
  LOADED_IN_CTOM_DATETIME DATE,
 ID BIGINT NOT NULL AUTO_INCREMENT ,
   PRIMARY KEY (id)
  ) ENGINE=InnoDB  ;
 
 CREATE TABLE cumulative_pr_tab
  (EXTRACT_DT TIMESTAMP DEFAULT NOW(),
  FILE_ID    VARCHAR(200),
  VERSION    VARCHAR(200),
  EXTRACTED  VARCHAR(200),
  ENTERED_BY VARCHAR(200),
  CREATED    VARCHAR(200),
  CHANGED    VARCHAR(200),
  CHG_TIME   VARCHAR(200),
  FILLER     VARCHAR(200),
  DEL_FLAG   VARCHAR(200),
  DEL_DATE   VARCHAR(200),
  PROTOCOL   VARCHAR(200),
  INST_ID    VARCHAR(200),
  ENTRY_PASS VARCHAR(200),
  TOUCH_DATE VARCHAR(200),
  TOUCH_TIME VARCHAR(200),
  PSEUDO_CRS VARCHAR(200),
  PATIENT    VARCHAR(200),
  START_DATE VARCHAR(200),
  RADIATION  VARCHAR(200),
  ITEM       VARCHAR(200),
  LAST_DATE  VARCHAR(200),
  SITE       VARCHAR(200),
  SCHEDULE   VARCHAR(200),
  DOSE       VARCHAR(200),
  UNITS      VARCHAR(200),
  RESPONSE   VARCHAR(200),
  THRPY_CODE VARCHAR(200),
  LOADED_IN_CTOM_DATETIME DATE,
 ID BIGINT NOT NULL AUTO_INCREMENT ,
   PRIMARY KEY (id)
  ) ENGINE=InnoDB  ;
 
 CREATE TABLE cumulative_pl_tab
 (EXTRACT_DT TIMESTAMP DEFAULT NOW(),
  FILE_ID    VARCHAR(200),
  VERSION    VARCHAR(200),
  EXTRACTED  VARCHAR(200),
  ENTERED_BY VARCHAR(200),
  CREATED    VARCHAR(200),
  CHANGED    VARCHAR(200),
  CHG_TIME   VARCHAR(200),
  FILLER     VARCHAR(200),
  DEL_FLAG   VARCHAR(200),
  DEL_DATE   VARCHAR(200),
  PROTOCOL   VARCHAR(200),
  INST_ID    VARCHAR(200),
  ENTRY_PASS VARCHAR(200),
  TOUCH_DATE VARCHAR(200),
  TOUCH_TIME VARCHAR(200),
  COURSE_NUM VARCHAR(200),
  PATIENT    VARCHAR(200),
  LAB_DATE   VARCHAR(200),
  LAB_TIME   VARCHAR(200),
  LAB_GROUP  VARCHAR(200),
  LAB_CODE   VARCHAR(200),
  PERF_STAT  VARCHAR(200),
  S_PERF     VARCHAR(200),
  HEIGHT     VARCHAR(200),
  S_HEIGHT   VARCHAR(200),
  WEIGHT     VARCHAR(200),
  S_WEIGHT   VARCHAR(200),
  TEMPERATUR VARCHAR(200),
  S_TEMP     VARCHAR(200),
  PULSE      VARCHAR(200),
  S_PULSE    VARCHAR(200),
  RESP_RATE  VARCHAR(200),
  S_RESP     VARCHAR(200),
  SYS_BP     VARCHAR(200),
  S_SYS_BP   VARCHAR(200),
  DIAS_BP    VARCHAR(200),
  S_DIAS_BP  VARCHAR(200),
  BLOOD_FRSH VARCHAR(200),
  S_BLD_FRSH VARCHAR(200),
  BLOOD_STRD VARCHAR(200),
  S_BLD_STRD VARCHAR(200),
  P_RC_FRESH VARCHAR(200),
  S_P_RC_FRE VARCHAR(200),
  P_RC_STRD  VARCHAR(200),
  S_P_RC_STR VARCHAR(200),
  P_WBC      VARCHAR(200),
  S_P_WBC    VARCHAR(200),
  PLATELETS  VARCHAR(200),
  S_PLATES   VARCHAR(200),
  PREEJ_PER  VARCHAR(200),
  S_PREEJ_PE VARCHAR(200),
  LV_EJ_TIME VARCHAR(200),
  S_LV_EJ_TM VARCHAR(200),
  LV_EJ_FRAC VARCHAR(200),
  S_LV_EJ_FR VARCHAR(200),
  LOADED_IN_CTOM_DATETIME DATE,
 ID BIGINT NOT NULL AUTO_INCREMENT ,
   PRIMARY KEY (id)
  ) ENGINE=InnoDB  ;
 
 CREATE TABLE cumulative_rf_tab
 (EXTRACT_DT TIMESTAMP DEFAULT NOW(),
  FILE_ID    VARCHAR(200),
  VERSION    VARCHAR(200),
  EXTRACTED  VARCHAR(200),
  ENTERED_BY VARCHAR(200),
  CREATED    VARCHAR(200),
  CHANGED    VARCHAR(200),
  CHG_TIME   VARCHAR(200),
  FILLER     VARCHAR(200),
  DEL_FLAG   VARCHAR(200),
  DEL_DATE   VARCHAR(200),
  PROTOCOL   VARCHAR(200),
  INST_ID    VARCHAR(200),
  ENTRY_PASS VARCHAR(200),
  TOUCH_DATE VARCHAR(200),
  TOUCH_TIME VARCHAR(200),
  COURSE_NUM VARCHAR(200),
  PATIENT    VARCHAR(200),
  LAB_DATE   VARCHAR(200),
  LAB_TIME   VARCHAR(200),
  LAB_GROUP  VARCHAR(200),
  LAB_CODE   VARCHAR(200),
  ACIDITY    VARCHAR(200),
  S_ACIDITY  VARCHAR(200),
  PART_CO2   VARCHAR(200),
  S_PART_CO2 VARCHAR(200),
  PARTIAL_O2 VARCHAR(200),
  S_PART_O2  VARCHAR(200),
  BICARB     VARCHAR(200),
  S_BICARB   VARCHAR(200),
  BASE_EXC   VARCHAR(200),
  S_BASE_EXC VARCHAR(200),
  BASE_DEF   VARCHAR(200),
  S_BASE_DEF VARCHAR(200),
  OXYGEN_SAT VARCHAR(200),
  S_OXYGEN   VARCHAR(200),
  CARB_MONOX VARCHAR(200),
  S_CO       VARCHAR(200),
  METHEMOGLO VARCHAR(200),
  S_METHEMOG VARCHAR(200),
  VITAL_CAP  VARCHAR(200),
  S_VIT_CAP  VARCHAR(200),
  EXP_VOL_1  VARCHAR(200),
  S_EXP_VOL1 VARCHAR(200),
  MAX_CAP    VARCHAR(200),
  S_MAX_CAP  VARCHAR(200),
  RESID_VOL  VARCHAR(200),
  S_RES_VOL  VARCHAR(200),
  TIDAL_VOL  VARCHAR(200),
  S_TID_VOL  VARCHAR(200),
  FUN_RES_CP VARCHAR(200),
  S_F_RES_CP VARCHAR(200),
  PULM_COMPL VARCHAR(200),
  S_PUL_COMP VARCHAR(200),
  DIFF_CAPAC VARCHAR(200),
  S_DIFF_CAP VARCHAR(200),
  MAX_EXP_FL VARCHAR(200),
  S_MAX_EXP  VARCHAR(200),
  MID_EXP_FL VARCHAR(200),
  S_MID_EXP  VARCHAR(200),
  LOADED_IN_CTOM_DATETIME DATE,
 ID BIGINT NOT NULL AUTO_INCREMENT ,
   PRIMARY KEY (id)
  ) ENGINE=InnoDB  ;
 
 CREATE TABLE cumulative_ue_TAB
 (EXTRACT_DT TIMESTAMP DEFAULT NOW(),
  FILE_ID    VARCHAR(200),
  VERSION    VARCHAR(200),
  EXTRACTED  VARCHAR(200),
  ENTERED_BY VARCHAR(200),
  CREATED    VARCHAR(200),
  CHANGED    VARCHAR(200),
  CHG_TIME   VARCHAR(200),
  FILLER     VARCHAR(200),
  DEL_FLAG   VARCHAR(200),
  DEL_DATE   VARCHAR(200),
  PROTOCOL   VARCHAR(200),
  INST_ID    VARCHAR(200),
  ENTRY_PASS VARCHAR(200),
  TOUCH_DATE VARCHAR(200),
  TOUCH_TIME VARCHAR(200),
  COURSE_NUM VARCHAR(200),
  PATIENT    VARCHAR(200),
  LAB_DATE   VARCHAR(200),
  LAB_TIME   VARCHAR(200),
  LAB_GROUP  VARCHAR(200),
  LAB_CODE   VARCHAR(200),
  IG_A       VARCHAR(200),
  S_IG_A     VARCHAR(200),
  IG_D       VARCHAR(200),
  S_IG_D     VARCHAR(200),
  IG_E       VARCHAR(200),
  S_IG_E     VARCHAR(200),
  IG_G       VARCHAR(200),
  S_IG_G     VARCHAR(200),
  IG_M       VARCHAR(200),
  S_IG_M     VARCHAR(200),
  MONOCLONAL VARCHAR(200),
  S_MONOCLON VARCHAR(200),
  POLYCLONAL VARCHAR(200),
  S_POLYCLON VARCHAR(200),
  KAPPA      VARCHAR(200),
  S_KAPPA    VARCHAR(200),
  LAMBDA     VARCHAR(200),
  S_LAMBDA   VARCHAR(200),
  BENCEJONES VARCHAR(200),
  S_BENCEJON VARCHAR(200),
  LOADED_IN_CTOM_DATETIME DATE,
 ID BIGINT NOT NULL AUTO_INCREMENT ,
   PRIMARY KEY (id)
  ) ENGINE=InnoDB  ;
 
 CREATE TABLE cumulative_ul_tab
 (EXTRACT_DT TIMESTAMP DEFAULT NOW(),
  FILE_ID    VARCHAR(200),
  VERSION    VARCHAR(200),
  EXTRACTED  VARCHAR(200),
  ENTERED_BY VARCHAR(200),
  CREATED    VARCHAR(200),
  CHANGED    VARCHAR(200),
  CHG_TIME   VARCHAR(200),
  FILLER     VARCHAR(200),
  DEL_FLAG   VARCHAR(200),
  DEL_DATE   VARCHAR(200),
  PROTOCOL   VARCHAR(200),
  INST_ID    VARCHAR(200),
  ENTRY_PASS VARCHAR(200),
  TOUCH_DATE VARCHAR(200),
  TOUCH_TIME VARCHAR(200),
  COURSE_NUM VARCHAR(200),
  PATIENT    VARCHAR(200),
  LAB_DATE   VARCHAR(200),
  LAB_TIME   VARCHAR(200),
  LAB_TEST   VARCHAR(200),
  BODY_SITE  VARCHAR(200),
  LAB_GROUP  VARCHAR(200),
  LAB_CODE   VARCHAR(200),
  NORM_ABNOR VARCHAR(200),
  VALUE_TYPE VARCHAR(200),
  NUM_VALUE  VARCHAR(200),
  LIT_VALUE  VARCHAR(200),
  LIT_VALUE2 VARCHAR(200),
  S_VALUE    VARCHAR(200),
  UNITS      VARCHAR(200),
  LOADED_IN_CTOM_DATETIME DATE,
 ID BIGINT NOT NULL AUTO_INCREMENT ,
   PRIMARY KEY (id)
  ) ENGINE=InnoDB  ;
 
 CREATE TABLE cumulative_ux_tab
  (EXTRACT_DT TIMESTAMP DEFAULT NOW(),
  FILE_ID    VARCHAR(200),
  VERSION    VARCHAR(200),
  EXTRACTED  VARCHAR(200),
  ENTERED_BY VARCHAR(200),
  CREATED    VARCHAR(200),
  CHANGED    VARCHAR(200),
  CHG_TIME   VARCHAR(200),
  FILLER     VARCHAR(200),
  DEL_FLAG   VARCHAR(200),
  DEL_DATE   VARCHAR(200),
  PROTOCOL   VARCHAR(200),
  INST_ID    VARCHAR(200),
  ENTRY_PASS VARCHAR(200),
  TOUCH_DATE VARCHAR(200),
  TOUCH_TIME VARCHAR(200),
  COURSE_NUM VARCHAR(200),
  PATIENT    VARCHAR(200),
  DOSE_DATE  VARCHAR(200),
  START_TIME VARCHAR(200),
  DRUG       VARCHAR(200),
  COLL_DATE  VARCHAR(200),
  COLL_TIME  VARCHAR(200),
  END_TIME   VARCHAR(200),
  URINE_VOL  VARCHAR(200),
  PAR_ASY_1  VARCHAR(200),
  P_ASY_UN_1 VARCHAR(200),
  PAR_ASY_2  VARCHAR(200),
  P_ASY_UN_2 VARCHAR(200),
  P_MEAN_CON VARCHAR(200),
  P_CON_UNIT VARCHAR(200),
  P_AMT_VOID VARCHAR(200),
  P_AMT_UNIT VARCHAR(200),
  MET_ASY_1  VARCHAR(200),
  M_ASY_UN_1 VARCHAR(200),
  MET_ASY_2  VARCHAR(200),
  M_ASY_UN_2 VARCHAR(200),
  M_MEAN_CON VARCHAR(200),
  M_CON_UNIT VARCHAR(200),
  M_AMT_VOID VARCHAR(200),
  M_AMT_UNIT VARCHAR(200),
  LOADED_IN_CTOM_DATETIME DATE,
 ID BIGINT NOT NULL AUTO_INCREMENT ,
   PRIMARY KEY (id)
  ) ENGINE=InnoDB  ;
 
 CREATE TABLE cumulative_xt_tab
 (EXTRACT_DT TIMESTAMP DEFAULT NOW(),
  FILE_ID    VARCHAR(200),
  VERSION    VARCHAR(200),
  EXTRACTED  VARCHAR(200),
  ENTERED_BY VARCHAR(200),
  CREATED    VARCHAR(200),
  CHANGED    VARCHAR(200),
  CHG_TIME   VARCHAR(200),
  FILLER     VARCHAR(200),
  DEL_FLAG   VARCHAR(200),
  DEL_DATE   VARCHAR(200),
  PROTOCOL   VARCHAR(200),
  INST_ID    VARCHAR(200),
  ENTRY_PASS VARCHAR(200),
  TOUCH_DATE VARCHAR(200),
  TOUCH_TIME VARCHAR(200),
  COURSE_NUM VARCHAR(200),
  PATIENT    VARCHAR(200),
  LESION     VARCHAR(200),
  DATE_      VARCHAR(200),
  DETERMINED VARCHAR(200),
  X          VARCHAR(200),
  Y          VARCHAR(200),
  Z          VARCHAR(200),
  EVAL_NUM   VARCHAR(200),
  EVALUATION VARCHAR(200),
  LOADED_IN_CTOM_DATETIME DATE,
 ID BIGINT NOT NULL AUTO_INCREMENT ,
   PRIMARY KEY (id)
  ) ENGINE=InnoDB  ;
 
 CREATE TABLE cumulative_tx_tab
  (REC_SEQ   VARCHAR(30) ,
  EXTRACT_DT TIMESTAMP DEFAULT NOW() ,
  FILE_ID    VARCHAR(200),
  VERSION    VARCHAR(200),
  EXTRACTED  VARCHAR(200),
  ENTERED_BY VARCHAR(200),
  CREATED    VARCHAR(200),
  CHANGED    VARCHAR(200),
  CHG_TIME   VARCHAR(200),
  FILLER     VARCHAR(200),
  DEL_FLAG   VARCHAR(200),
  DEL_DATE   VARCHAR(200),
  PROTOCOL   VARCHAR(200),
  INST_ID    VARCHAR(200),
  ENTRY_PASS VARCHAR(200),
  TOUCH_DATE VARCHAR(200),
  TOUCH_TIME VARCHAR(200),
  COURSE_NUM VARCHAR(200),
  PATIENT    VARCHAR(200),
  COURSE     VARCHAR(200),
  TOXICITY   VARCHAR(200),
  ONSET_DATE VARCHAR(200),
  TOX_CODE   VARCHAR(200),
  RESOLVED   VARCHAR(200),
  AER_FILED  VARCHAR(200),
  GRADE      VARCHAR(200),
  ATTRIBUT   VARCHAR(200),
  DOSE_LIMIT VARCHAR(200),
  SERIOUS    VARCHAR(200),
  ACTION     VARCHAR(200),
  THERAPY    VARCHAR(200),
  OUTCOME    VARCHAR(200),
  APEX_NADIR VARCHAR(200),
  LOADED_IN_CTOM_DATETIME DATE,
 ID BIGINT NOT NULL AUTO_INCREMENT ,
   PRIMARY KEY (id)
  ) ENGINE=InnoDB  ;
 
 CREATE TABLE cumulative_us_tab
  (EXTRACT_DT TIMESTAMP DEFAULT NOW(),
  FILE_ID    VARCHAR(200),
  VERSION    VARCHAR(200),
  EXTRACTED  VARCHAR(200),
  ENTERED_BY VARCHAR(200),
  CREATED    VARCHAR(200),
  CHANGED    VARCHAR(200),
  CHG_TIME   VARCHAR(200),
  FILLER     VARCHAR(200),
  DEL_FLAG   VARCHAR(200),
  DEL_DATE   VARCHAR(200),
  PROTOCOL   VARCHAR(200),
  INST_ID    VARCHAR(200),
  ENTRY_PASS VARCHAR(200),
  TOUCH_DATE VARCHAR(200),
  TOUCH_TIME VARCHAR(200),
  COURSE_NUM VARCHAR(200),
  PATIENT    VARCHAR(200),
  LAB_DATE   VARCHAR(200),
  LAB_TIME   VARCHAR(200),
  LAB_GROUP  VARCHAR(200),
  LAB_CODE   VARCHAR(200),
  CREAT_CLR  VARCHAR(200),
  S_CREAT_CL VARCHAR(200),
  HYDROGEN   VARCHAR(200),
  S_HYDROGEN VARCHAR(200),
  SP_GRAVITY VARCHAR(200),
  S_SP_GRAV  VARCHAR(200),
  WBCS       VARCHAR(200),
  S_WBCS     VARCHAR(200),
  RBCS       VARCHAR(200),
  S_RBCS     VARCHAR(200),
  GLUCOSE    VARCHAR(200),
  S_GLUCOSE  VARCHAR(200),
  PROTEIN    VARCHAR(200),
  S_PROTEIN  VARCHAR(200),
  KETONES    VARCHAR(200),
  S_KETONES  VARCHAR(200),
  BILE       VARCHAR(200),
  S_BILE     VARCHAR(200),
  URIN_CREAT VARCHAR(200),
  S_U_CREAT  VARCHAR(200),
  VOLUME     VARCHAR(200),
  S_VOLUME   VARCHAR(200),
  COLL_PER   VARCHAR(200),
  S_COLL_PER VARCHAR(200),
  LOADED_IN_CTOM_DATETIME DATE,
 ID BIGINT NOT NULL AUTO_INCREMENT ,
   PRIMARY KEY (id)
  ) ENGINE=InnoDB  ;
 
 CREATE TABLE cumulative_tf_tab
  (EXTRACT_DT TIMESTAMP DEFAULT NOW(),
  FILE_ID    VARCHAR(200),
  VERSION    VARCHAR(200),
  EXTRACTED  VARCHAR(200),
  ENTERED_BY VARCHAR(200),
  CREATED    VARCHAR(200),
  CHANGED    VARCHAR(200),
  CHG_TIME   VARCHAR(200),
  FILLER     VARCHAR(200),
  DEL_FLAG   VARCHAR(200),
  DEL_DATE   VARCHAR(200),
  PROTOCOL   VARCHAR(200),
  INST_ID    VARCHAR(200),
  ENTRY_PASS VARCHAR(200),
  TOUCH_DATE VARCHAR(200),
  TOUCH_TIME VARCHAR(200),
  PSEUDO_CRS VARCHAR(200),
  PATIENT    VARCHAR(200),
  CHEMO_SING VARCHAR(200),
  LST_CHEM_S VARCHAR(200),
  CHEMO_MULT VARCHAR(200),
  LST_CHEM_M VARCHAR(200),
  CHEMO_UNKN VARCHAR(200),
  LST_CHEM_U VARCHAR(200),
  HORMONAL   VARCHAR(200),
  LAST_HORM  VARCHAR(200),
  SURGERY    VARCHAR(200),
  LAST_SURG  VARCHAR(200),
  IMMUNOTHER VARCHAR(200),
  LAST_IMM   VARCHAR(200),
  EXTENS_RAD VARCHAR(200),
  LST_EX_RAD VARCHAR(200),
  LIM_RAD    VARCHAR(200),
  LST_LM_RAD VARCHAR(200),
  RAD_UNKN   VARCHAR(200),
  LST_UN_RAD VARCHAR(200),
  BONE_MARR  VARCHAR(200),
  LAST_BMT   VARCHAR(200),
  GENE_THRPY VARCHAR(200),
  LAST_GENE  VARCHAR(200),
  OTH_THRPY  VARCHAR(200),
  LAST_OTHER VARCHAR(200),
  NON_CYTO   VARCHAR(200),
  LAST_NOCYT VARCHAR(200),
  ANTI_RTVIR VARCHAR(200),
  LST_ANTRTV VARCHAR(200),
  ANTISENSE  VARCHAR(200),
  LST_ANTSNS VARCHAR(200),
  ONCO_VIRO  VARCHAR(200),
  LST_ONCVIR VARCHAR(200),
  VACCINE    VARCHAR(200),
  LAST_VAC   VARCHAR(200),
  LOADED_IN_CTOM_DATETIME DATE,
 ID BIGINT NOT NULL AUTO_INCREMENT ,
   PRIMARY KEY (id)
  ) ENGINE=InnoDB  ;
 
 CREATE TABLE cumulative_sc_tab
 (EXTRACT_DT TIMESTAMP DEFAULT NOW(),
  FILE_ID    VARCHAR(200),
  VERSION    VARCHAR(200),
  EXTRACTED  VARCHAR(200),
  ENTERED_BY VARCHAR(200),
  CREATED    VARCHAR(200),
  CHANGED    VARCHAR(200),
  CHG_TIME   VARCHAR(200),
  FILLER     VARCHAR(200),
  DEL_FLAG   VARCHAR(200),
  DEL_DATE   VARCHAR(200),
  PROTOCOL   VARCHAR(200),
  INST_ID    VARCHAR(200),
  ENTRY_PASS VARCHAR(200),
  TOUCH_DATE VARCHAR(200),
  TOUCH_TIME VARCHAR(200),
  COURSE_NUM VARCHAR(200),
  PATIENT    VARCHAR(200),
  LAB_DATE   VARCHAR(200),
  LAB_TIME   VARCHAR(200),
  LAB_GROUP  VARCHAR(200),
  LAB_CODE   VARCHAR(200),
  ALDOLASE   VARCHAR(200),
  S_ALDOLASE VARCHAR(200),
  AMMONIA    VARCHAR(200),
  S_AMMONIA  VARCHAR(200),
  CALCIUM    VARCHAR(200),
  S_CALCIUM  VARCHAR(200),
  COPPER     VARCHAR(200),
  S_COPPER   VARCHAR(200),
  FERRITIN   VARCHAR(200),
  S_FERRITIN VARCHAR(200),
  HDL        VARCHAR(200),
  S_HDL      VARCHAR(200),
  INSULIN    VARCHAR(200),
  S_INSULIN  VARCHAR(200),
  IRON       VARCHAR(200),
  S_IRON     VARCHAR(200),
  IRON_BIND  VARCHAR(200),
  S_IRON_BIN VARCHAR(200),
  IRON_SAT   VARCHAR(200),
  S_IRON_SAT VARCHAR(200),
  LDL        VARCHAR(200),
  S_LDL      VARCHAR(200),
  LIPASE     VARCHAR(200),
  S_LIPASE   VARCHAR(200),
  OSMOLALITY VARCHAR(200),
  S_OSMOL    VARCHAR(200),
  ACID_PHOS  VARCHAR(200),
  S_AC_PHOS  VARCHAR(200),
  TRANSFERRI VARCHAR(200),
  S_TRANSFER VARCHAR(200),
  TRIGLYC    VARCHAR(200),
  S_TRIGLYC  VARCHAR(200),
  T3         VARCHAR(200),
  S_T3       VARCHAR(200),
  T4         VARCHAR(200),
  S_T4       VARCHAR(200),
  TSH        VARCHAR(200),
  S_TSH      VARCHAR(200),
  LOADED_IN_CTOM_DATETIME DATE,
 ID BIGINT NOT NULL AUTO_INCREMENT ,
   PRIMARY KEY (id)
  ) ENGINE=InnoDB  ;
 
 CREATE TABLE cumulative_se_tab
  (EXTRACT_DT TIMESTAMP DEFAULT NOW(),
  FILE_ID    VARCHAR(200),
  VERSION    VARCHAR(200),
  EXTRACTED  VARCHAR(200),
  ENTERED_BY VARCHAR(200),
  CREATED    VARCHAR(200),
  CHANGED    VARCHAR(200),
  CHG_TIME   VARCHAR(200),
  FILLER     VARCHAR(200),
  DEL_FLAG   VARCHAR(200),
  DEL_DATE   VARCHAR(200),
  PROTOCOL   VARCHAR(200),
  INST_ID    VARCHAR(200),
  ENTRY_PASS VARCHAR(200),
  TOUCH_DATE VARCHAR(200),
  TOUCH_TIME VARCHAR(200),
  COURSE_NUM VARCHAR(200),
  PATIENT    VARCHAR(200),
  LAB_DATE   VARCHAR(200),
  LAB_TIME   VARCHAR(200),
  LAB_GROUP  VARCHAR(200),
  LAB_CODE   VARCHAR(200),
  IG_A       VARCHAR(200),
  S_IG_A     VARCHAR(200),
  IG_D       VARCHAR(200),
  S_IG_D     VARCHAR(200),
  IG_E       VARCHAR(200),
  S_IG_E     VARCHAR(200),
  IG_G       VARCHAR(200),
  S_IG_G     VARCHAR(200),
  IG_M       VARCHAR(200),
  S_IG_M     VARCHAR(200),
  MONOCLONAL VARCHAR(200),
  S_MONOCLON VARCHAR(200),
  POLYCLONAL VARCHAR(200),
  S_POLYCLON VARCHAR(200),
  KAPPA      VARCHAR(200),
  S_KAPPA    VARCHAR(200),
  LAMBDA     VARCHAR(200),
  S_LAMBDA   VARCHAR(200),
  BENCEJONES VARCHAR(200),
  S_BENCEJON VARCHAR(200),
  LOADED_IN_CTOM_DATETIME DATE,
 ID BIGINT NOT NULL AUTO_INCREMENT ,
   PRIMARY KEY (id)
  ) ENGINE=InnoDB  ;
 
 CREATE TABLE cumulative_sh_tab
 (EXTRACT_DT TIMESTAMP DEFAULT NOW(),
  FILE_ID    VARCHAR(200),
  VERSION    VARCHAR(200),
  EXTRACTED  VARCHAR(200),
  ENTERED_BY VARCHAR(200),
  CREATED    VARCHAR(200),
  CHANGED    VARCHAR(200),
  CHG_TIME   VARCHAR(200),
  FILLER     VARCHAR(200),
  DEL_FLAG   VARCHAR(200),
  DEL_DATE   VARCHAR(200),
  PROTOCOL   VARCHAR(200),
  INST_ID    VARCHAR(200),
  ENTRY_PASS VARCHAR(200),
  TOUCH_DATE VARCHAR(200),
  TOUCH_TIME VARCHAR(200),
  COURSE_NUM VARCHAR(200),
  PATIENT    VARCHAR(200),
  TRIAL      VARCHAR(200),
  DATE_      VARCHAR(200),
  NUCLIDE_1  VARCHAR(200),
  ALIQUOT_1  VARCHAR(200),
  ANTIBODY_1 VARCHAR(200),
  CORR_CPM_1 VARCHAR(200),
  TOT_ADM_1  VARCHAR(200),
  NUCLIDE_2  VARCHAR(200),
  ALIQUOT_2  VARCHAR(200),
  ANTIBODY_2 VARCHAR(200),
  CORR_CPM_2 VARCHAR(200),
  TOT_ADM_2  VARCHAR(200),
  LOADED_IN_CTOM_DATETIME DATE,
 ID BIGINT NOT NULL AUTO_INCREMENT ,
   PRIMARY KEY (id)
  ) ENGINE=InnoDB  ;
 
 CREATE TABLE cumulative_ss_tab
 (EXTRACT_DT TIMESTAMP DEFAULT NOW(),
  FILE_ID    VARCHAR(200),
  VERSION    VARCHAR(200),
  EXTRACTED  VARCHAR(200),
  ENTERED_BY VARCHAR(200),
  CREATED    VARCHAR(200),
  CHANGED    VARCHAR(200),
  CHG_TIME   VARCHAR(200),
  FILLER     VARCHAR(200),
  DEL_FLAG   VARCHAR(200),
  DEL_DATE   VARCHAR(200),
  PROTOCOL   VARCHAR(200),
  INST_ID    VARCHAR(200),
  ENTRY_PASS VARCHAR(200),
  TOUCH_DATE VARCHAR(200),
  TOUCH_TIME VARCHAR(200),
  COURSE_NUM VARCHAR(200),
  PATIENT    VARCHAR(200),
  TRIAL      VARCHAR(200),
  SAMPLE_ID  VARCHAR(200),
  SOURCE_ORG VARCHAR(200),
  SAMPLE_DSC VARCHAR(200),
  TISS_CLASS VARCHAR(200),
  GAMMA_SCAN VARCHAR(200),
  CT_SCAN    VARCHAR(200),
  BIOPSIED   VARCHAR(200),
  WEIGHT     VARCHAR(200),
  PCT_TUMOR  VARCHAR(200),
  CORR_CPM_1 VARCHAR(200),
  CORR_CPM_2 VARCHAR(200),
  LOADED_IN_CTOM_DATETIME DATE,
 ID BIGINT NOT NULL AUTO_INCREMENT ,
   PRIMARY KEY (id)
  ) ENGINE=InnoDB  ;
 
 CREATE TABLE cumulative_sr_tab
  (EXTRACT_DT TIMESTAMP DEFAULT NOW(),
  FILE_ID    VARCHAR(200),
  VERSION    VARCHAR(200),
  EXTRACTED  VARCHAR(200),
  ENTERED_BY VARCHAR(200),
  CREATED    VARCHAR(200),
  CHANGED    VARCHAR(200),
  CHG_TIME   VARCHAR(200),
  FILLER     VARCHAR(200),
  DEL_FLAG   VARCHAR(200),
  DEL_DATE   VARCHAR(200),
  PROTOCOL   VARCHAR(200),
  INST_ID    VARCHAR(200),
  ENTRY_PASS VARCHAR(200),
  TOUCH_DATE VARCHAR(200),
  TOUCH_TIME VARCHAR(200),
  COURSE_NUM VARCHAR(200),
  PATIENT    VARCHAR(200),
  LAB_DATE   VARCHAR(200),
  LAB_TIME   VARCHAR(200),
  LAB_GROUP  VARCHAR(200),
  LAB_CODE   VARCHAR(200),
  PSA        VARCHAR(200),
  S_PSA      VARCHAR(200),
  CA125      VARCHAR(200),
  S_CA125    VARCHAR(200),
  CEA        VARCHAR(200),
  S_CEA      VARCHAR(200),
  CA19_9     VARCHAR(200),
  S_CA19_9   VARCHAR(200),
  CA15_3     VARCHAR(200),
  S_CA15_3   VARCHAR(200),
  CA27_29    VARCHAR(200),
  S_CA27_29  VARCHAR(200),
  AFP        VARCHAR(200),
  S_AFP      VARCHAR(200),
  HCG        VARCHAR(200),
  S_HCG      VARCHAR(200),
  HIV        VARCHAR(200),
  S_HIV      VARCHAR(200),
  HBS_AG     VARCHAR(200),
  S_HBS_AG   VARCHAR(200),
  PREGNANT   VARCHAR(200),
  S_PREGNANT VARCHAR(200),
  GUIAC      VARCHAR(200),
  S_GUIAC    VARCHAR(200),
  LOADED_IN_CTOM_DATETIME DATE,
 ID BIGINT NOT NULL AUTO_INCREMENT ,
   PRIMARY KEY (id)
  ) ENGINE=InnoDB  ;
 
 CREATE TABLE cumulative_ip_tab
 (EXTRACT_DT TIMESTAMP DEFAULT NOW(),
  FILE_ID    VARCHAR(200),
  VERSION    VARCHAR(200),
  EXTRACTED  VARCHAR(200),
  ENTERED_BY VARCHAR(200),
  CREATED    VARCHAR(200),
  CHANGED    VARCHAR(200),
  CHG_TIME   VARCHAR(200),
  FILLER     VARCHAR(200),
  DEL_FLAG   VARCHAR(200),
  DEL_DATE   VARCHAR(200),
  PROTOCOL   VARCHAR(200),
  INST_ID    VARCHAR(200),
  ENTRY_PASS VARCHAR(200),
  TOUCH_DATE VARCHAR(200),
  TOUCH_TIME VARCHAR(200),
  COURSE_NUM VARCHAR(200),
  PATIENT    VARCHAR(200),
  LAB_DATE   VARCHAR(200),
  LAB_TIME   VARCHAR(200),
  LAB_GROUP  VARCHAR(200),
  LAB_CODE   VARCHAR(200),
  LYMPHOCYTE VARCHAR(200),
  S_LYMPHS   VARCHAR(200),
  B_CELL_LEV VARCHAR(200),
  S_B_CELL_L VARCHAR(200),
  T_CELL_TOT VARCHAR(200),
  S_T_CELL_T VARCHAR(200),
  T_CELL_HLP VARCHAR(200),
  S_T_CELL_H VARCHAR(200),
  T_CELL_SUP VARCHAR(200),
  S_T_CELL_S VARCHAR(200),
  T_CELL_DTH VARCHAR(200),
  S_T_CELL_D VARCHAR(200),
  T_CELL_CTL VARCHAR(200),
  S_T_CELL_C VARCHAR(200),
  NK_ACTIV   VARCHAR(200),
  S_NK_ACTIV VARCHAR(200),
  ADCC       VARCHAR(200),
  S_ADCC     VARCHAR(200),
  CYTOTOX    VARCHAR(200),
  S_CYTOTOX  VARCHAR(200),
  CYTOSTASIS VARCHAR(200),
  S_CYTOSTAS VARCHAR(200),
  PEROX_GEN  VARCHAR(200),
  S_PEROX_G  VARCHAR(200),
  INTERFERON VARCHAR(200),
  S_INTERFER VARCHAR(200),
  LOADED_IN_CTOM_DATETIME DATE,
 ID BIGINT NOT NULL AUTO_INCREMENT ,
   PRIMARY KEY (id)
  ) ENGINE=InnoDB  ;
 
 CREATE TABLE cumulative_ds_tab
 (EXTRACT_DT TIMESTAMP DEFAULT NOW(),
  FILE_ID    VARCHAR(200),
  VERSION    VARCHAR(200),
  EXTRACTED  VARCHAR(200),
  ENTERED_BY VARCHAR(200),
  CREATED    VARCHAR(200),
  CHANGED    VARCHAR(200),
  CHG_TIME   VARCHAR(200),
  FILLER     VARCHAR(200),
  DEL_FLAG   VARCHAR(200),
  DEL_DATE   VARCHAR(200),
  PROTOCOL   VARCHAR(200),
  INST_ID    VARCHAR(200),
  ENTRY_PASS VARCHAR(200),
  TOUCH_DATE VARCHAR(200),
  TOUCH_TIME VARCHAR(200),
  PSEUDO_CRS VARCHAR(200),
  PATIENT    VARCHAR(200),
  DEATH_DATE VARCHAR(200),
  CAUSE      VARCHAR(200),
  OTH_CAUSE  VARCHAR(200),
  AUTOPSIED  VARCHAR(200),
  RESULT     VARCHAR(200),
  OTH_RESULT VARCHAR(200),
  SITE_1     VARCHAR(200),
  SITE_2     VARCHAR(200),
  SITE_3     VARCHAR(200),
  SITE_4     VARCHAR(200),
  SITE_5     VARCHAR(200),
  SITE_6     VARCHAR(200),
  SITE_7     VARCHAR(200),
  SITE_8     VARCHAR(200),
  LOADED_IN_CTOM_DATETIME DATE,
 ID BIGINT NOT NULL AUTO_INCREMENT ,
   PRIMARY KEY (id)
  ) ENGINE=InnoDB  ;


CREATE INDEX idx_cumulative_bc_tab ON cumulative_bc_tab (protocol,patient,lab_date,lab_time);

CREATE INDEX idx_cumulative_bm_tab ON cumulative_bm_tab (protocol,patient,lab_date,lab_time);

CREATE INDEX idx_cumulative_bs_tab ON cumulative_bs_tab (protocol,patient,onset_date,toxicity);

CREATE INDEX idx_cumulative_ca_tab ON cumulative_ca_tab (protocol,patient,start_date);

CREATE INDEX idx_cumulative_ci_tab ON cumulative_ci_tab (protocol,patient,course);

CREATE INDEX idx_cumulative_cm_tab ON cumulative_cm_tab (protocol,patient,start_date,agent_proc,item);

CREATE INDEX idx_cumulative_cs_tab ON cumulative_cs_tab (protocol,corr_stdy);

CREATE INDEX idx_cumulative_da_tab ON cumulative_da_tab (protocol,patient,date_,start_time,drug);

CREATE INDEX idx_cumulative_ds_tab ON cumulative_ds_tab (protocol,patient);

CREATE INDEX idx_cumulative_dt_tab ON cumulative_dt_tab (protocol,subgroup,toxicity);

CREATE INDEX idx_cumulative_ec_tab ON cumulative_ec_tab (protocol,patient);

CREATE INDEX idx_cumulative_en_tab ON cumulative_en_tab (protocol,patient);

CREATE INDEX idx_cumulative_ep_tab ON cumulative_ep_tab (protocol,subgroup);

CREATE INDEX idx_cumulative_ex_tab ON cumulative_ex_tab (protocol,patient,lab_date,lab_time,panel);

CREATE INDEX idx_cumulative_fo_tab ON cumulative_fo_tab (protocol,patient);

CREATE INDEX idx_cumulative_fp_tab ON cumulative_fp_tab (protocol,patient,last_cont);

CREATE INDEX idx_cumulative_hm_tab ON cumulative_hm_tab (protocol,patient,lab_date,lab_time);

CREATE INDEX idx_cumulative_ie_tab ON cumulative_ie_tab (protocol,patient,onset_date,infection);

CREATE INDEX idx_cumulative_ip_tab ON cumulative_ip_tab (protocol,patient,lab_date,lab_time);

CREATE INDEX idx_cumulative_la_tab ON cumulative_la_tab (protocol,patient,follow_up,toxicity,onset_date);

CREATE INDEX idx_cumulative_ll_tab ON cumulative_ll_tab (protocol,patient,lab_date,lab_time,lab_test,body_site);

CREATE INDEX idx_cumulative_ls_tab ON cumulative_ls_tab (protocol,patient,lesion);

CREATE INDEX idx_cumulative_lx_tab ON cumulative_lx_tab (protocol,patient,lab_date,lab_time,panel);

CREATE INDEX idx_cumulative_mh_tab ON cumulative_mh_tab (protocol,patient,exam_date);

CREATE INDEX idx_cumulative_ou_tab ON cumulative_ou_tab (protocol,patient,lab_date,lab_time);

CREATE INDEX idx_cumulative_pe_tab ON cumulative_pe_tab (protocol,patient,exam_date);

CREATE INDEX idx_cumulative_ph_tab ON cumulative_ph_tab (protocol,patient,note_date,note_type);

CREATE INDEX idx_cumulative_pk_tab ON cumulative_pk_tab (protocol,patient,study_drug,dosingdate,start_time,specimen,duration);

CREATE INDEX idx_cumulative_pl_tab ON cumulative_pl_tab (protocol,patient,lab_date,lab_time);

CREATE INDEX idx_cumulative_pr_tab ON cumulative_pr_tab (protocol,patient,start_date,radiation,item);

CREATE INDEX idx_cumulative_ps_tab ON cumulative_ps_tab (protocol,patient,date_,proc_site,item);

CREATE INDEX idx_cumulative_pt_tab ON cumulative_pt_tab (protocol,patient,start_date,agent,item);

CREATE INDEX idx_cumulative_rc_tab ON cumulative_rc_tab (protocol,patient,lab_date,lab_time);

CREATE INDEX idx_cumulative_rf_tab ON cumulative_rf_tab (protocol,patient,lab_date,lab_time);

CREATE INDEX idx_cumulative_sc_tab ON cumulative_sc_tab (protocol,patient,lab_date,lab_time);

CREATE INDEX idx_cumulative_se_tab ON cumulative_se_tab (protocol,patient,lab_date,lab_time);

CREATE INDEX idx_cumulative_sh_tab ON cumulative_sh_tab (protocol,patient,trial);

CREATE INDEX idx_cumulative_sr_tab ON cumulative_sr_tab (protocol,patient,lab_date,lab_time);

CREATE INDEX idx_cumulative_ss_tab ON cumulative_ss_tab (protocol,patient,trial,sample_id);

CREATE INDEX idx_cumulative_tf_tab ON cumulative_tf_tab (protocol,patient);

CREATE INDEX idx_cumulative_tx_tab ON cumulative_tx_tab (protocol,patient,course,toxicity,onset_date);

CREATE INDEX idx_cumulative_ue_tab ON cumulative_ue_tab (protocol,patient,lab_date,lab_time);

CREATE INDEX idx_cumulative_ul_tab ON cumulative_ul_tab (protocol,patient,lab_date,lab_time,lab_test,body_site);

CREATE INDEX idx_cumulative_us_tab ON cumulative_us_tab (protocol,patient,lab_date,lab_time);

CREATE INDEX idx_cumulative_ux_tab ON cumulative_ux_tab (protocol,patient,dose_date,start_time,drug,coll_date,coll_time);

CREATE INDEX idx_cumulative_xt_tab ON cumulative_xt_tab (protocol,patient,lesion,date_);