c_trailer

where case_number = "02-CA-021246-001"

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ case_number trailer_date date_last_action allegations_adjusted settlement approval_requested number_reinstated number_w_reinstated number_d_reinstated number_p_list number_restored number_withdrawn_employment number_rcu_employed number_allegations number_made_whole number_receiving_back_pay total_amt amt_pd_co amt_pd_un back_pay_control f_installment number_rcu_dues total_comp total_pd_co total_pd_un dues_control remedy date_end_picket date_end_work_stop number_employs_picket number_employes_stop number_to_be_reinst related_combined_code related_key_case_number
9676 9676 02-CA-021246-001 1989-10-04 1989-10-04 9   0 0 0 0 0 0 0 0 1 0 0 0 0 0 0   0 0 0   0 01         0 Y 02-CA-021111-001 
CREATE TABLE "c_trailer" (
   [case_number] TEXT REFERENCES [c_master]([case_number]),
   [trailer_date] TEXT,
   [date_last_action] TEXT,
   [allegations_adjusted] INTEGER,
   [settlement] TEXT,
   [approval_requested] INTEGER,
   [number_reinstated] INTEGER,
   [number_w_reinstated] INTEGER,
   [number_d_reinstated] INTEGER,
   [number_p_list] INTEGER,
   [number_restored] INTEGER,
   [number_withdrawn_employment] INTEGER,
   [number_rcu_employed] INTEGER,
   [number_allegations] INTEGER,
   [number_made_whole] INTEGER,
   [number_receiving_back_pay] INTEGER,
   [total_amt] INTEGER,
   [amt_pd_co] INTEGER,
   [amt_pd_un] INTEGER,
   [back_pay_control] INTEGER,
   [f_installment] TEXT,
   [number_rcu_dues] INTEGER,
   [total_comp] INTEGER,
   [total_pd_co] INTEGER,
   [total_pd_un] INTEGER,
   [dues_control] INTEGER,
   [remedy] TEXT,
   [date_end_picket] TEXT,
   [date_end_work_stop] TEXT,
   [number_employs_picket] INTEGER,
   [number_employes_stop] INTEGER,
   [number_to_be_reinst] INTEGER,
   [related_combined_code] TEXT,
   [related_key_case_number] TEXT
);