r_formal2
where case_number = "01-RC-018072"
0 records
CREATE TABLE "r_formal2" ( [case_number] TEXT REFERENCES [r_master]([case_number]), [suffix] TEXT, [rf2_date] TEXT, [date_last_action] TEXT, [transaction] TEXT, [action_777] TEXT, [consol_code] TEXT, [date_election_held] TEXT, [date_obj_chall_filed] TEXT, [number_obj_filed] INTEGER, [number_chall] INTEGER, [date_hearing_ordered] TEXT, [basis_election] TEXT, [party_filing_ob] INTEGER, [hearing_code] TEXT, [hearing_ordered_by] TEXT, [date_rps_no_hearing_held] TEXT, [update_control] TEXT, [date_hearing_closed] TEXT, [date_hearing_opened] TEXT, [date_rpt_on_obj_chall] TEXT, [first_election_rpt] INTEGER, [rpt_control] TEXT, [date_rd_suppl_dec] TEXT, [ruling_on_obj] INTEGER, [type_decision] INTEGER, [decision_control] TEXT, [another_election] TEXT, [previously_reported] TEXT, [date_certification] TEXT, [stage] TEXT, [method] TEXT, [rd_of_bd_dec] TEXT, [date_review_waivered] INTEGER, [date_exception_filed] TEXT, [exception_code] TEXT, [date_ruling_on_exc] TEXT, [ruling_on_exc_code] TEXT, [date_reg_for_review] TEXT, [party_filing_req] TEXT, [date_ruling_on_req] TEXT, [ruling_on_req_code] TEXT, [date_board_dec] INTEGER, [type_board_dec] TEXT, [number_obj_sustained] INTEGER, [number_obj_overuled] INTEGER, [number_obj_withdrawn] INTEGER, [number_chall_sustained] INTEGER, [number_chall_overuled] INTEGER, [number_chall_withdrawn] INTEGER, [date_obj_chall_resolved] TEXT, [ruling_on_obj_r] INTEGER, [ruling_on_obj_r.1] INTEGER, [date_bd_dec_on_rev] INTEGER, [bd_dec_on_rev] INTEGER, FOREIGN KEY([transaction]) REFERENCES [l_transaction_codes]([trans]), FOREIGN KEY([basis_election]) REFERENCES [l_type_elections]([code]), FOREIGN KEY([party_filing_ob]) REFERENCES [l_party_filing_objection]([code]) );