r_case: 03-AC-00042
| r_case_number | case_type | status | nlrb_office_id | docket_num | inquiry_id | case_name | date_filed | hearing_target_date | election_target_date | employer_on_petition | union_involved_on_petition | intervenor_on_petition | self_certification | post_elect_self_cert | naics_code | num_employees_requested | description_requested |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 03-AC-00042 | Amendment of Certification AC | Closed Close | Region 03, Buffalo, New York 03 | 42 | Mike Basil Chevrolet, Inc. | 1996-07-25T00:00:00 | 1996-08-08T00:00:00 | 1996-09-05T00:00:00 | Mike Basil Chevrolet, Inc. | Hamburg Employers Union | N | N | New Car Dealers 441110 | 28 | All service employees; including mechanics, helpers, collision men, washers, painters, undercoaters, lubrication men, janitors and parts department employees, excluding all office clerical employees, all salesmen and service salesmen, parts manager, service manager and all guards and supervisors and professional employees defined in the Act. |
Links from other tables
- 1 row from r_case_number in r_bargaining_unit
- 1 row from r_case_number in r_closed_case
- 1 row from r_case_number in r_impact_category
- 2 rows from r_case_number in r_part_variant
- 5 rows from r_case_number in r_participant
- 0 rows from r_case_number in r_post_elect_board_act
- 0 rows from r_case_number in r_pre_elect_board_act
- 0 rows from r_case_number in r_reopened_case
- 0 rows from new_case_number in r_transfer_history
- 1 row from r_case_number in r_transfer_history