l_allegation_type
217 rows
| nlra_section | allegation_keyname | case_type | description |
|---|---|---|---|
| 8(a)(1) | Changes in Conditions of Employment [not 8a3] | CA | 8(a)(1) Changes in Conditions of Employment [not 8a3] |
| 8(a)(1) | Coercive Statements, including Threats | CA | 8(a)(1) Coercive Statements, including Threats |
| 8(a)(1) | Concerted Activities: Benefits Altered | CA | 8(a)(1) Conserted Activities: Benefits Altered |
| 8(a)(1) | Concerted Activities: Discharge | CA | 8(a)(1) Concerted Activities: Discharge |
| 8(a)(1) | Concerted Activities: Discipline | CA | 8(a)(1) Concerted Activities: Discipline |
| 8(a)(1) | Concerted Activities: Layoff | CA | 8(a)(1) Concerted Activities: Layoff |
| 8(a)(1) | Concerted Activities: Lockout | CA | 8(a)(1) Concerted Activities: Lockout |
| 8(a)(1) | Concerted Activities: Onerous Assignment/Condition | CA | 8(a)(1) Concerted Activities: Onerous Assignment/Condition |
| 8(a)(1) | Concerted Activities: Other Allegations | CA | 8(a)(1) Concerted Activities: Other Allegations |
| 8(a)(1) | Concerted Activities: Promotions Withheld | CA | 8(a)(1) Concerted Activities: Promotions Withheld |
| 8(a)(1) | Concerted Activities: Refusal to Consider/Hire | CA | 8(a)(1) Concerted Activities: Refusal to Consider/Hire |
| 8(a)(1) | Concerted Activities: Refusal to Reinstate | CA | 8(a)(1) Concerted Activities: Refusal to Reinstate |
| 8(a)(1) | Concerted Activities: Rewards | CA | 8(a)(1) Concerted Activities: Rewards |
| 8(a)(1) | Concerted Activities: Shutdown or Relocate | CA | 8(a)(1) Concerted Activities: Shutdown or Relocate |
| 8(a)(1) | Concerted Activities: Suspension | CA | 8(a)(1) Concerted Activities: Suspension |
| 8(a)(1) | Concerted Activities: Union Security Related | CA | 8(a)(1) Concerted Activities: Union Security Related |
| 8(a)(1) | Concerted Activities: Unknown | CA | 8(a)(1) Concerted Activities: Unknown |
| 8(a)(1) | Concerted Activities: Wages Altered | CA | 8(a)(1) Concerted Activities: Wages Altered |
| 8(a)(1) | Denial of Access (Lechmere) | CA | 8(a)(1) Denial of Access (Lechmere) |
| 8(a)(1) | Discharge of supervisor (Parker-Robb Chevrolet) | CA | 8(a)(1) Discharge of supervisor (Parker-Robb Chevrolet) |
| 8(a)(1) | Disparagement of Union/Employee | CA | 8(a)(1) Disparagement of Union or its supporters |
| 8(a)(1) | Harassment | CA | 8(a)(1) Harassment |
| 8(a)(1) | Interference, (Weingarten) | CA | 8(a)(1) Interference, (Weingarten) |
| 8(a)(1) | Interrogation | CA | 8(a)(1) Interrogation |
| 8(a)(1) | Lawsuits | CA | 8(a)(1) Lawsuits |
| 8(a)(1) | Other Allegations | CA | 8(a)(1) Other Allegations |
| 8(a)(1) | Polling Employees | CA | 8(a)(1) Polling Employees |
| 8(a)(1) | Promise of Benefits | CA | 8(a)(1) Promise of Benefits |
| 8(a)(1) | Rules: No-Solicitation/No-Distribution Rules | CA | 8(a)(1) Rules: No-Solicitation/No-Distribution Rules |
| 8(a)(1) | Rules: Other Employer Rules | CA | 8(a)(1) Rules: Other Employer Rules |
| 8(a)(1) | Statements of Futility | CA | 8(a)(1) Statements of Futility |
| 8(a)(1) | Surveillance | CA | 8(a)(1) Surveillance |
| 8(a)(1) | Unknown | CA | 8(a)(1) Unknown |
| 8(a)(1) | Violence | CA | 8(a)(1) Violence |
| 8(a)(2) | Assistance | CA | 8(a)(2) Assistance |
| 8(a)(2) | Creation of In-House Organization (Electromation) | CA | 8(a)(2) Creation of In-House Organization (Electromation) |
| 8(a)(2) | Domination | CA | 8(a)(2) Domination |
| 8(a)(2) | Interference | CA | 8(a)(2) Interference |
| 8(a)(2) | Other Allegations | CA | 8(a)(2) Other Allegations |
| 8(a)(2) | Unknown | CA | 8(a)(2) Unknown |
| 8(a)(2) | Unlawful Recognition | CA | 8(a)(2) Unlawful Recognition |
| 8(a)(3) | Benefits Altered | CA | 8(a)(3) Benefits Altered |
| 8(a)(3) | Discharge | CA | 8(a)(3) Discharge |
| 8(a)(3) | Discharge, Constructive | CA | 8(a)(3) Discharge, Constructive |
| 8(a)(3) | Discipline | CA | 8(a)(3) Discipline |
| 8(a)(3) | Inherently Destructive Conduct | CA | 8(a)(3) Inherently Destructive Conduct |
| 8(a)(3) | Investigatory Meetings (Weingarten) | CA | 8(a)(3) Investigatory Meetings (Weingarten) |
| 8(a)(3) | Lawsuit | CA | 8(a)(3) Lawsuit |
| 8(a)(3) | Layoff | CA | 8(a)(3) Layoff |
| 8(a)(3) | Lockout | CA | 8(a)(3) Lockout |
| 8(a)(3) | Onerous Assignments/Conditions | CA | 8(a)(3) Onerous Assignments/Conditions |
| 8(a)(3) | Other Allegations | CA | 8(a)(3) Other Allegations |
| 8(a)(3) | Promotions Withheld | CA | 8(a)(3) Promotions Withheld |
| 8(a)(3) | Refusal to Consider/Hire Applicant (Not Salting) | CA | 8(a)(3) Refusal to Consider/Hire Applicant (Not Salting) |
| 8(a)(3) | Refusal to Consider/Hire Applicant (Salting) | CA | 8(a)(3) Refusal to Consider/Hire Applicant (Salting) |
| 8(a)(3) | Refusal to Reinstate E'ee/Striker (e.g. Laidlaw) | CA | 8(a)(3) Refusal to Reinstate E'ee/Striker (e.g. Laidlaw) |
| 8(a)(3) | Rewards | CA | 8(a)(3) Rewards |
| 8(a)(3) | Shutdown or Relocate | CA | 8(a)(3) Shutdown or Relocate |
| 8(a)(3) | Subcontract Unit Work | CA | 8(a)(3) Subcontract Unit Work |
| 8(a)(3) | Suspension | CA | 8(a)(3) Suspension |
| 8(a)(3) | Union Security Related Actions | CA | 8(a)(3) Union Security Related Actions |
| 8(a)(3) | Unknown | CA | 8(a)(3) Unknown |
| 8(a)(3) | Wages Altered | CA | 8(a)(3) Wages Altered |
| 8(a)(4) | Benefits Altered | CA | 8(a)(4) Benefits Altered |
| 8(a)(4) | Discharge | CA | 8(a)(4) Discharge |
| 8(a)(4) | Discharge, Constructive | CA | 8(a)(4) Discharge, Constructive |
| 8(a)(4) | Discipline | CA | 8(a)(4) Discipline |
| 8(a)(4) | Inherently Destructive Conduct | CA | 8(a)(4) Inherently Destructive Conduct |
| 8(a)(4) | Lawsuit | CA | 8(a)(4) Lawsuit |
| 8(a)(4) | Layoff | CA | 8(a)(4) Layoff |
| 8(a)(4) | Lockout | CA | 8(a)(4) Lockout |
| 8(a)(4) | Onerous Assignments/Conditions | CA | 8(a)(4) Onerous Assignments/Conditions |
| 8(a)(4) | Other Allegations | CA | 8(a)(4) Other Allegation |
| 8(a)(4) | Promotions Withheld | CA | 8(a)(4) Promotions Withheld |
| 8(a)(4) | Refusal to Consider/Hire Applicant (Not Salting) | CA | 8(a)(4) Refusal to Consider/Hire Applicant (Not Salting) |
| 8(a)(4) | Refusal to Consider/Hire Applicant (Salting) | CA | 8(a)(4) Refusal to Consider/Hire Applicant (Salting) |
| 8(a)(4) | Refusal to Reinstate Employee/Striker | CA | 8(a)(4) Refusal to Reinstate Employee/Striker |
| 8(a)(4) | Rewards | CA | 8(a)(4) Rewards |
| 8(a)(4) | Shutdown or Relocate | CA | 8(a)(4) Shutdown or Relocate |
| 8(a)(4) | Subcontract Unit Work | CA | 8(a)(4) Subcontract Unit Work |
| 8(a)(4) | Suspension | CA | 8(a)(4) Suspension |
| 8(a)(4) | Union Security Related Actions | CA | 8(a)(4) Union Security Related Actions |
| 8(a)(4) | Unknown | CA | 8(a)(4) Unknown |
| 8(a)(4) | Wages Altered | CA | 8(a)(4) Wages Altered |
| 8(a)(5) | Alter Ego or Disguised Continuance | CA | 8(a)(5) Alter Ego or Disguised Continuance |
| 8(a)(5) | Bad Faith Bargaining (Initial Contract) | CA | Bad Faith Bargaining (Initial Contract) |
| 8(a)(5) | Bad Faith Bargaining (Succeeding Contract) | CA | Bad Faith Bargaining (Succeeding Contract) |
| 8(a)(5) | Direct Dealing/Bypassing Union | CA | 8(a)(5) Direct Dealing/Bypassing Union |
| 8(a)(5) | Failure to Sign Agreement | CA | 8(a)(5) Failure to Sign Agreement |
| 8(a)(5) | Implement Drug Testing | CA | 8(a)(5) Implement Drug Testing |
| 8(a)(5) | Implementation (Colorado Ute) | CA | 8(a)(5) Implementation (Colorado Ute) |
| 8(a)(5) | Implementation (impasse issue) | CA | 8(a)(5) Implementation (impasse issue) |
| 8(a)(5) | Other Allegations | CA | 8(a)(5) Other Allegations |
| 8(a)(5) | Refusal to Bargain (Initial Contract) | CA | 8(a)(5) Refusal to Bargain (Initial Contract) |
| 8(a)(5) | Refusal to Bargain (Succeeding or mid Contract) | CA | 8(a)(5) Refusal to Bargain (Succeeding or mid Contract) |
| 8(a)(5) | Refusal to Furnish Information | CA | 8(a)(5) Refusal to Furnish Information |
| 8(a)(5) | Refusal to Hire Majority | CA | 8(a)(5) Refusal to Hire Majority |
| 8(a)(5) | Refusal to Recognize (Gissel) | CA | 8(a)(5) Refusal to Recognize (Gissel) |
| 8(a)(5) | Refusal to Recognize (not Gissel) | CA | 8(a)(5) Refusal to Recognize (not Gissel) |
| 8(a)(5) | Repudiation/Modification of Contract [Sec. 8(d)] | CA | 8(a)(5) Repudiation/Modification of Contract [Sec. 8(d)] |
Table schema
CREATE TABLE l_allegation_type(nlra_section VARCHAR, allegation_keyname VARCHAR, case_type VARCHAR, description VARCHAR);