c_formal2

where case_number = "09-CA-015824-001"

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

CREATE TABLE "c_formal2" (
   [case_number] TEXT REFERENCES [c_master]([case_number]),
   [cf2_date] TEXT,
   [date_last_action] TEXT,
   [consolidation_type] TEXT,
   [consolidation_code] TEXT,
   [update_control] INTEGER,
   [code_date_transfer_board] TEXT,
   [date_transfer_board] TEXT,
   [control_type] TEXT,
   [date_decision_issued] TEXT,
   [type_decision] TEXT,
   [disp_allegations] TEXT,
   [allegations_uphld] TEXT,
   [allegations_dismd] TEXT,
   [number_discrim_reinstated_ca] TEXT,
   [number_receive_back_pay_uni_emp_cb] TEXT,
   [number_receive_back_pay_only_ca] TEXT,
   [number_discrim_restored_cb] TEXT,
   [number_discrim_dismissed] TEXT,
   [number_discrim_preferred] TEXT,
   [remedy] TEXT,
   [board_members] TEXT,
   [board_disposition_allegations] TEXT,
   [close_control] TEXT,
   [card_control] TEXT,
   [code_date_dec_issued] TEXT,
   [volume_number] TEXT,
   [issue_number] TEXT,
   [party_filing_excpt] TEXT,
   [board_members_5] TEXT
);