r_pre_elect_rd_decision
10,280 rows
Suggested facets: unit_id, action_sequence, recurrence, determination_eot, eot_party, brief_rcvd_party, rd_decision_type, recon_request_party, rd_recon_deter, eot_filed_date (date), eot_deter_brief_date (date), pre_election_brief_rcvd (date), rd_decision_issued_date (date), recon_request_filed (date), rd_recon_deter_date (date), brief_due_date (date), review_due_date (date)
| r_case_number | unit_id | action_sequence | recurrence | determination_eot | eot_party | eot_filed_date | eot_deter_brief_date | brief_rcvd_party | pre_election_brief_rcvd | rd_decision_issued_date | rd_decision_type | recon_request_filed | recon_request_party | rd_recon_deter | rd_recon_deter_date | brief_due_date | review_due_date |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01-AC-00094 | A | 0 | 0 | 2001-08-02 | Decision and Order DecOr | 2001-08-16 | |||||||||||
| 01-AC-00096 | A | 0 | 0 | 2002-06-12 | Amendment of Certification AmdCe | ||||||||||||
| 01-AC-00097 | A | 0 | 0 | 2003-11-05 | Amendment of Certification AmdCe | 2003-11-19 | |||||||||||
| 01-AC-00098 | A | 0 | 0 | 2007-09-06 | Decision and Order DecOr | 2007-09-20 | |||||||||||
| 01-AC-00101 | A | 0 | 0 | 2010-08-18 | Amendment of Certification AmdCe | 2010-09-01 | |||||||||||
| 01-AC-00102 | A | 0 | 0 | 2010-08-18 | Amendment of Certification AmdCe | 2010-09-01 | |||||||||||
| 01-RC-19536 | A | 0 | 0 | 1991-05-24 | Direction of Election DirEl | ||||||||||||
| 01-RC-19926 | A | 0 | 0 | Employer EMP | 1993-03-25 | 1993-04-23 | Direction of Election DirEl | 1993-03-10 | |||||||||
| 01-RC-19926 | A | 0 | 1 | Petitioner PET | 1993-03-25 | 1996-11-21 | Direction of Election DirEl | ||||||||||
| 01-RC-20080 | A | 0 | 0 | Petitioner PET | 1994-02-11 | 1994-03-11 | Direction of Election DirEl | 1994-02-11 | |||||||||
| 01-RC-20080 | A | 0 | 1 | Employer EMP | 1994-02-14 | ||||||||||||
| 01-RC-20106 | A | 0 | 0 | Employer EMP | 1994-04-07 | 1994-06-08 | Decision and Order DecOr | 1994-04-07 | |||||||||
| 01-RC-20106 | A | 0 | 1 | Petitioner PET | 1994-04-07 | ||||||||||||
| 01-RC-20309 | A | 0 | 0 | Employer EMP | 1995-08-09 | 1995-09-01 | Direction of Election DirEl | 1995-08-09 | 1995-09-15 | ||||||||
| 01-RC-20309 | A | 0 | 1 | Petitioner PET | 1995-08-09 | 1995-09-01 | |||||||||||
| 01-RC-20310 | A | 0 | 0 | Employer EMP | 1995-08-09 | 1995-09-01 | Direction of Election DirEl | 1995-08-09 | 1995-09-15 | ||||||||
| 01-RC-20310 | A | 0 | 1 | Petitioner PET | 1995-08-09 | ||||||||||||
| 01-RC-20463 | A | 0 | 0 | Employer EMP | 1996-06-17 | 1996-06-26 | Direction of Election DirEl | 1996-06-17 | 1999-07-09 | ||||||||
| 01-RC-20508 | A | 0 | 0 | Employer EMP | 1996-10-10 | 1996-11-07 | Direction of Election DirEl | 1996-10-10 | |||||||||
| 01-RC-20508 | A | 0 | 1 | Petitioner PET | 1996-10-10 | ||||||||||||
| 01-RC-20574 | A | 0 | 0 | Granted to Requested Date Grant | Employer EMP | 1997-08-17 | 1997-08-27 | Employer EMP | 1997-08-27 | 1997-10-17 | Order Dismissing Dismi | 1997-08-18 | 1997-10-31 | ||||
| 01-RC-20574 | A | 0 | 1 | Petitioner PET | 1997-08-27 | ||||||||||||
| 01-RC-20761 | A | 0 | 0 | Granted to Requested Date Grant | 1998-02-23 | 1998-03-03 | Employer EMP | 1998-03-03 | 1998-03-19 | Direction of Election DirEl | 1998-02-25 | ||||||
| 01-RC-20761 | A | 0 | 1 | Petitioner PET | 1998-03-03 | ||||||||||||
| 01-RC-20804 | A | 0 | 0 | Employer EMP | 1998-04-27 | 1998-05-21 | Direction of Election DirEl | 1998-04-27 | 1998-06-04 | ||||||||
| 01-RC-20804 | A | 0 | 1 | Petitioner PET | 1998-04-27 | ||||||||||||
| 01-RC-20905 | A | 0 | 0 | Petitioner PET | 1998-10-23 | 1998-11-10 | Direction of Election DirEl | 1998-10-23 | 1998-11-24 | ||||||||
| 01-RC-20914 | A | 0 | 0 | Granted to Requested Date Grant | Employer EMP | 1998-11-18 | 1998-11-18 | Employer EMP | 1998-12-02 | 1998-12-21 | Direction of Election DirEl | 1998-11-23 | 1999-01-04 | ||||
| 01-RC-20914 | A | 0 | 1 | Petitioner PET | 1998-12-02 | 1998-12-02 | |||||||||||
| 01-RC-20915 | A | 0 | 0 | Granted to Requested Date Grant | Employer EMP | 1998-11-18 | 1998-11-18 | Employer EMP | 1998-12-02 | 1998-12-21 | Direction of Election DirEl | 1998-11-23 | 1999-01-04 | ||||
| 01-RC-20915 | A | 0 | 1 | Petitioner PET | 1998-12-02 | 1998-12-02 | |||||||||||
| 01-RC-20921 | A | 0 | 0 | Employer EMP | 1998-11-25 | 1998-12-15 | Direction of Election DirEl | 1998-11-23 | 1998-12-29 | ||||||||
| 01-RC-20921 | A | 0 | 1 | Petitioner PET | 1998-11-25 | 1998-11-25 | |||||||||||
| 01-RC-20925 | A | 0 | 0 | Employer EMP | 1998-11-30 | 1998-12-11 | Direction of Election DirEl | 1998-11-30 | 1998-12-27 | ||||||||
| 01-RC-20927 | A | 0 | 0 | Petitioner PET | 1998-12-02 | 1998-12-24 | Direction of Election DirEl | 1998-12-02 | 1999-01-07 | ||||||||
| 01-RC-20940 | A | 0 | 0 | Employer EMP | 1999-01-20 | 1999-02-12 | Direction of Election DirEl | 1998-12-28 | 1999-02-26 | ||||||||
| 01-RC-20940 | A | 0 | 1 | Petitioner PET | 1999-01-20 | ||||||||||||
| 01-RC-20945 | A | 0 | 0 | Employer EMP | 1998-12-28 | 1998-12-31 | Direction of Election DirEl | 1998-12-28 | 1999-01-14 | ||||||||
| 01-RC-20945 | A | 0 | 1 | Petitioner PET | 1998-12-28 | ||||||||||||
| 01-RC-20947 | A | 0 | 0 | Granted to Requested Date Grant | 1998-12-27 | 1999-01-05 | Employer EMP | 1999-01-05 | 1999-01-14 | Direction of Election DirEl | 1998-12-28 | 1999-01-28 | |||||
| 01-RC-20947 | A | 0 | 1 | Petitioner PET | 1999-01-05 | ||||||||||||
| 01-RC-20957 | A | 0 | 0 | 1999-01-13 | Direction of Election DirEl | ||||||||||||
| 01-RC-20958 | A | 0 | 0 | Granted to Another Date GrntA | Employer EMP | 1999-01-08 | 1999-01-08 | Petitioner PET | 1999-01-15 | 1999-01-28 | Direction of Election DirEl | 1999-01-12 | 1999-02-11 | ||||
| 01-RC-20958 | A | 0 | 1 | Employer EMP | 1999-01-15 | 1999-01-15 | |||||||||||
| 01-RC-20960 | A | 0 | 0 | Granted to Another Date GrntA | Employer EMP | 1999-01-21 | 1999-01-22 | Employer EMP | 1999-01-29 | 1999-02-02 | Direction of Election DirEl | 1999-01-27 | 1999-02-16 | ||||
| 01-RC-20960 | A | 0 | 1 | Petitioner PET | 1999-01-29 | 1999-01-29 | |||||||||||
| 01-RC-20968 | A | 0 | 0 | Employer EMP | 1999-02-18 | 1999-03-04 | Direction of Election DirEl | 1999-02-18 | 1999-03-18 | ||||||||
| 01-RC-20968 | A | 0 | 1 | Petitioner PET | 1999-02-18 | ||||||||||||
| 01-RC-20969 | A | 0 | 0 | Granted to Requested Date Grant | Employer EMP | 1999-02-23 | 1999-02-23 | Employer EMP | 1999-03-01 | 1999-03-19 | Direction of Election DirEl | 1999-02-26 | 1999-04-02 | ||||
| 01-RC-20969 | A | 0 | 1 | Petitioner PET | 1999-03-01 | 1999-03-01 | |||||||||||
| 01-RC-20970 | A | 0 | 0 | Granted to Another Date GrntA | Employer EMP | 1999-03-05 | 1999-03-05 | Employer EMP | 1999-03-10 | 1999-03-18 | Direction of Election DirEl | 1999-03-08 | 1999-04-01 | ||||
| 01-RC-20970 | A | 0 | 1 | Petitioner PET | 1999-03-10 | 1999-03-10 | |||||||||||
| 01-RC-20971 | A | 0 | 0 | Granted to Requested Date Grant | Employer EMP | 1999-02-22 | 1999-02-22 | Employer EMP | 1999-03-03 | 1999-03-19 | Direction of Election DirEl | 1999-03-03 | 1999-04-02 | ||||
| 01-RC-20975 | A | 0 | 0 | Employer EMP | 1999-03-10 | 1999-03-15 | Decision and Order DecOr | 1999-03-10 | |||||||||
| 01-RC-20983 | A | 0 | 0 | 1999-03-25 | Direction of Election DirEl | 1999-03-22 | 1999-04-08 | ||||||||||
| 01-RC-20984 | A | 0 | 0 | Employer EMP | 1999-04-06 | 1999-04-21 | Direction of Election DirEl | 1999-04-06 | 1999-05-05 | ||||||||
| 01-RC-20984 | A | 0 | 1 | Petitioner PET | 1999-04-06 | ||||||||||||
| 01-RC-20984 | A | 1 | 0 | Granted to Requested Date Grant | Employer EMP | 2002-03-05 | 2002-03-05 | Employer EMP | 2002-03-11 | 2002-05-22 | Decision and Order DecOr | 2002-03-26 | 2002-06-05 | ||||
| 01-RC-20984 | A | 1 | 1 | Petitioner PET | 2002-03-26 | ||||||||||||
| 01-RC-20984 | A | 1 | 2 | Employer EMP | 2002-03-27 | ||||||||||||
| 01-RC-20985 | A | 0 | 0 | Granted to Another Date GrntA | Employer EMP | 1999-04-01 | 1999-04-01 | Petitioner PET | 1999-04-07 | 1999-04-27 | Direction of Election DirEl | 1999-04-06 | 1999-05-11 | ||||
| 01-RC-20985 | A | 0 | 1 | Employer EMP | 1999-04-08 | 1999-04-08 | |||||||||||
| 01-RC-21011 | A | 0 | 0 | Granted to Another Date GrntA | Petitioner PET | 1999-05-13 | 1999-05-13 | Petitioner PET | 1999-05-26 | 1999-06-03 | Direction of Election DirEl | 1999-05-17 | 1999-06-17 | ||||
| 01-RC-21011 | A | 0 | 1 | Employer EMP | 1999-05-26 | 1999-05-26 | |||||||||||
| 01-RC-21012 | A | 0 | 0 | Employer EMP | 1999-05-19 | 1999-05-21 | Direction of Election DirEl | 1999-05-19 | 1999-06-04 | ||||||||
| 01-RC-21014 | A | 0 | 0 | Granted to Another Date GrntA | Employer EMP | 1999-05-21 | 1999-05-21 | Employer EMP | 1999-05-28 | 1999-06-02 | Direction of Election DirEl | 1999-05-24 | 1999-06-16 | ||||
| 01-RC-21014 | A | 0 | 1 | 1999-05-28 | |||||||||||||
| 01-RC-21020 | A | 0 | 0 | 1999-06-22 | Direction of Election DirEl | 1999-06-11 | |||||||||||
| 01-RC-21026 | A | 0 | 0 | Petitioner PET | 1999-06-30 | 1999-07-06 | Direction of Election DirEl | 1999-06-28 | 1999-07-20 | ||||||||
| 01-RC-21029 | A | 0 | 0 | Petitioner PET | 1999-06-23 | 1999-06-24 | |||||||||||
| 01-RC-21029 | A | 0 | 1 | Employer EMP | 1999-06-24 | ||||||||||||
| 01-RC-21037 | A | 0 | 0 | Employer EMP | 1999-07-20 | 1999-07-30 | Direction of Election DirEl | 1999-07-20 | |||||||||
| 01-RC-21044 | A | 0 | 0 | 1999-08-27 | Direction of Election DirEl | ||||||||||||
| 01-RC-21078 | A | 0 | 0 | Petitioner PET | 1999-09-28 | 1999-10-15 | Direction of Election DirEl | 1999-09-29 | 1999-10-29 | ||||||||
| 01-RC-21092 | A | 0 | 0 | 1999-10-27 | Direction of Election DirEl | 1999-11-10 | |||||||||||
| 01-RC-21097 | A | 0 | 0 | Petitioner PET | 1999-11-08 | 1999-11-22 | Direction of Election DirEl | 1999-11-04 | |||||||||
| 01-RC-21097 | A | 0 | 1 | Employer EMP | 1999-11-08 | 1999-11-22 | Direction of Election DirEl | 1999-12-06 | |||||||||
| 01-RC-21098 | A | 0 | 0 | Employer EMP | 1999-11-17 | 1999-12-02 | Direction of Election DirEl | 1999-11-12 | 1999-12-16 | ||||||||
| 01-RC-21098 | A | 0 | 1 | Petitioner PET | 1999-11-17 | 1999-12-02 | Direction of Election DirEl | 1999-12-06 | |||||||||
| 01-RC-21102 | A | 0 | 0 | 2000-02-02 | Direction of Election DirEl | 2000-02-16 | |||||||||||
| 01-RC-21128 | A | 0 | 0 | Granted to Requested Date Grant | Employer EMP | 2000-01-21 | 2000-02-04 | Employer EMP | 2000-02-04 | 2000-02-10 | Decision and Order DecOr | 2000-01-28 | 2000-02-24 | ||||
| 01-RC-21128 | A | 0 | 1 | Granted to Requested Date Grant | Petitioner PET | 2000-01-21 | 2000-02-04 | Petitioner PET | 2000-02-08 | 2000-02-04 | |||||||
| 01-RC-21130 | A | 0 | 0 | Granted to Requested Date Grant | Employer EMP | 2000-02-17 | 2000-02-23 | Employer EMP | 2000-02-24 | 2000-02-25 | Direction of Election DirEl | 2000-02-17 | 2000-03-10 | ||||
| 01-RC-21130 | A | 0 | 1 | Petitioner PET | 2000-02-24 | 2000-02-23 | |||||||||||
| 01-RC-21131 | A | 0 | 0 | Granted to Requested Date Grant | Employer EMP | 2000-01-31 | 2000-02-04 | Employer EMP | 2000-02-04 | 2000-02-16 | Direction of Election DirEl | 2000-01-31 | 2000-03-01 | ||||
| 01-RC-21131 | A | 0 | 1 | Petitioner PET | 2000-02-04 | 2000-02-04 | |||||||||||
| 01-RC-21135 | A | 0 | 0 | Granted to Requested Date Grant | Employer EMP | 2000-02-15 | 2000-02-18 | Employer EMP | 2000-02-18 | 2000-03-02 | Direction of Election DirEl | 2000-02-15 | 2000-03-16 | ||||
| 01-RC-21135 | A | 0 | 1 | Petitioner PET | 2000-02-18 | 2000-02-18 | |||||||||||
| 01-RC-21138 | A | 0 | 0 | 2000-02-11 | Direction of Election DirEl | 2000-02-25 | |||||||||||
| 01-RC-21160 | A | 0 | 0 | Employer EMP | 2000-04-05 | 2000-04-21 | Direction of Election DirEl | 2000-04-05 | |||||||||
| 01-RC-21163 | A | 0 | 0 | 2000-04-19 | Direction of Election DirEl | 2000-04-24 | Employer EMP | Denied Deny | 2000-05-18 | 2000-04-07 | 2000-05-03 | ||||||
| 01-RC-21185 | A | 0 | 0 | Petitioner PET | 2000-05-15 | 2000-05-16 | Direction of Election DirEl | 2000-05-15 | 2000-05-30 | ||||||||
| 01-RC-21185 | A | 0 | 1 | Employer EMP | 2000-05-15 | ||||||||||||
| 01-RC-21188 | A | 0 | 0 | Petitioner PET | 2000-05-17 | 2000-05-23 | Direction of Election DirEl | 2000-05-17 | 2000-06-03 | ||||||||
| 01-RC-21189 | A | 0 | 0 | 2000-06-01 | Decision and Order DecOr | 2000-05-17 | 2000-06-15 | ||||||||||
| 01-RC-21192 | A | 0 | 0 | Employer EMP | 2000-06-06 | 2000-06-14 | Direction of Election DirEl | 2000-06-06 | 2000-06-28 | ||||||||
| 01-RC-21195 | A | 0 | 0 | Employer EMP | 2000-06-13 | 2000-06-23 | Direction of Election DirEl | 2000-06-13 | 2000-07-07 | ||||||||
| 01-RC-21199 | A | 0 | 0 | Granted to Requested Date Grant | Employer EMP | 2000-07-07 | 2000-07-07 | Petitioner PET | 2000-07-10 | 2000-08-03 | Direction of Election DirEl | 2000-07-11 | 2000-08-17 | ||||
| 01-RC-21199 | A | 0 | 1 | Employer EMP | 2000-07-10 | ||||||||||||
| 01-RC-21202 | A | 0 | 0 | Petitioner PET | 2000-07-10 | 2000-07-13 | Direction of Election DirEl | 2000-07-07 | 2000-07-27 |
Table schema
CREATE TABLE r_pre_elect_rd_decision(r_case_number VARCHAR, unit_id VARCHAR, action_sequence BIGINT, recurrence BIGINT, determination_eot VARCHAR, eot_party VARCHAR, eot_filed_date DATE, eot_deter_brief_date DATE, brief_rcvd_party VARCHAR, pre_election_brief_rcvd DATE, rd_decision_issued_date DATE, rd_decision_type VARCHAR, recon_request_filed DATE, recon_request_party VARCHAR, rd_recon_deter VARCHAR, rd_recon_deter_date DATE, brief_due_date DATE, review_due_date DATE, FOREIGN KEY (rd_recon_deter) REFERENCES l_r_preelec_rd_recon(rd_reconsider_deter), FOREIGN KEY (rd_decision_type) REFERENCES l_r_preelec_rd_dec_type(rd_decision_type), FOREIGN KEY (determination_eot) REFERENCES l_r_preelec_det_eot(determination_eot), FOREIGN KEY (recon_request_party) REFERENCES l_case_party(party), FOREIGN KEY (eot_party) REFERENCES l_case_party(party), FOREIGN KEY (brief_rcvd_party) REFERENCES l_case_party(party));