c_formal1

CREATE TABLE c_formal1(case_number VARCHAR, cf1_date DATE, date_last_action DATE, consol_type VARCHAR, consol_code VARCHAR, update_control VARCHAR, code_date_complt_iss BIGINT, date_complaint_issued DATE, allegations VARCHAR, number_discrim BIGINT, complaint_control BIGINT, code_date_ro_disp BIGINT, date_ro_disp DATE, ro_disp_control VARCHAR, date_hearing_opened DATE, code_date_hearing_closed BIGINT, date_hearing_closed DATE, hearing_control VARCHAR, code_date_disp_issed_recd BIGINT, date_disp_issued_recd DATE, type_disposition VARCHAR, allegations_uphld VARCHAR, allegations_dismd VARCHAR, discrim_upheld VARCHAR, discrim_dismissed VARCHAR, back_pay_control BIGINT, admin_law_judge_disp BIGINT, board_decision_control BIGINT, card_control VARCHAR, number_discrim_reinst_ca BIGINT, number_rec_back_pay_uni_emp_cb BIGINT, number_rec_back_pay_only_ca BIGINT, number_discrim_restor_cb BIGINT, number_discrim_preferd BIGINT, remedy VARCHAR, code_date_hearing_opened BIGINT, chips_amended_code BIGINT, consol_server VARCHAR, case_state_action VARCHAR, complaint_calendar_year BIGINT, complaint_fical_year BIGINT, consol_case_number VARCHAR, sub_consol_case_number VARCHAR);