l_c_case_pending_status_codes

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ status definition
1 1 0 Pending Preliminary Investigation
2 2 1 Pre Complaint Dismissal Letter in Part
3 3 2 Post Advice/Pre Complaint
4 4 3 Post Advice or Abeyance
5 5 4 Post Advice Petition for Injunction
6 6 5 Post Appeal/Pre Complaint
7 7 6 Dismissal Letter
8 8 7 Dismissal Letter
9 9 10 Advice Recommended Injunction
10 10 11 Post Complaint Petition For Injunction
11 11 12 Complaint
12 12 13 Unfair Labor Practice Postponed
13 13 14 Hearing Waived
14 14 16 Another Hearing Ordered
15 15 17 Supplemental Hearing
16 16 18 Backpay Specifications
17 17 19 Backpay Hearing
18 18 20 Settlement
19 19 21 Stipulated Decision
20 20 22 Consent Decree
21 21 24 Pending Complaint Post Administrative Law Judge
22 22 25 Exceptions Withdrawn
23 23 26 Pending Complaint Post Board
24 24 27 Pending Complaint Post 10K
25 25 28 Settlement After Referral for Enforcement
26 26 29 Pending Complaint Post Administrative Law Judge
27 27 30 Enforcement Circuit Court of Appeals Decree
28 28 31 Contempt Circuit Court of Appeals Decree
29 29 32 Supreme Court Action
30 30 34 Pending Complaint Post Backpay
31 31 35 Pending Complaint Post Administrative Law Judge
32 32 36 Supplemental Board Decision
33 33 38 Supplemental Circuit Court of Appeals Decree
34 34 40 Advice Requested
35 35 41 Deferred
36 36 42 Formal Stipulation Received
37 37 46 Pending Compliance
38 38 50 Appeal Received
39 39 52 Pending in Advice
40 40 54 Injunction Sought
41 41 60 Regional Director Request for Enforcement
42 42 61 Enforcement Brief Filed
43 43 62 Circuit Court of Appeals Opinion
44 44 64 Circuit Court of Appeals Decree
45 45 66 Referred for Contempt
46 46 68 Referred to Enforcement
47 47 70 Board Petition for Certeriority
48 48 72 Petition for Certeriority
49 49 74 Centeriority Granted
50 50 76 Supreme Court Oral Argument
51 51 80 Unfair Labor Practice Hearing Closed
52 52 82 Board Order Remanded
53 53 84 Board Order Remanded Supplemental
54 54 86 Backpay Hearing Closed
55 55 87 Administrative Law Judge Decision
56 56 88 Administrative Law Judge Supplemental Decision Issued
57 57 90 10K Hearing Closed
58 58 91 Exceptions/Brief Filed
59 59 92 Exceptions/Brief Filed
60 60 93 Order Transferring to Board
61 61 95 Referred to Board for Stipulation
62 62 96 Supplemental Administrative Law Judge on Backpay
63 63 97 Supplemental Administrative Law Judge Decision on Merits 
CREATE TABLE "l_c_case_pending_status_codes" (
"status" INTEGER,
  "definition" TEXT
);