l_transaction_codes

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

trans ▼ action
001 New Charge / Pre Compl Dismissal Letter (Pre 3/24/92)
002 C Case Reopened
004 Settlement Agreement
005 Complaint Issued
006 10(k) Notice Issued
007 10(k) Hearing Held
008 Withdrawal
009 Dismissal or Deferral
00A Delete New Charge
00E Delete Complaint
00F Delete 10K Notice of Hearing
00H Partial Withdrawal
00J Post Complaint Dismissal Letter
00K Deferral
011 Closed Case Report
014 Advice Actions
015 Hearing Scheduled
016 Appeal Filing or Response
017 Case Transferred
019 Back Pay Specifications
045 (This is a beta test action.)
094 Closed Case Report
101 New Petition
102 R Case Reopened
104 Administrative Dismissal or Withdrawal
105 Notice of Hearing - Original
106 Notice of Hearing - Reopened
107 Hearing Closed - Original
108 Hearing Closed - Reopened
109 Order Transferring to Board
10A Delete Petition
10D RD Administrative Dismissal Letter
110 RD's Decision Directing Election
111 RD's Decision Order Dismissing
112 Waiver of Req For Rev of RD Decision
113 Hearing Recommended or Ordered
114 Hrg Closed on Obj/Chall
115 Report on Obj/Chall - No Hearing
116 Hearing Officers Report on Obj/Chall
117 RD Supplemental Decision Post Election
118 RD Supplemental Decision and Cert.
119 Order Permitting Withdrawal
120 Appeal/Exception/Req for Rev Filed
121 Board Ruling
122 Consolidation or Severance
123 Case Closed by Certification
124 Objections and/or Challenges
125 Hearing Postponed/Rescheduled/Cancelled
127 Case Transferred
128 Objs/Chall Resolved W/O RD/BD Decision
129 Order Dismissing - Case Closed
131 (Delete) Error Corrections ?????
132 C Case Blocks R Case
133 BD Dec on Request/Review Pre Election
134 BD Dec on Request/Review Post Election
136 Tally Disposition - Closing of Specific?
201 Election Agreement
202 Election - Tally of Ballots Record (UD)
203 Election - Tally of Ballots Record (RC)
701 Automatic Decision
702 Supple Dec & Order Dismissing Complaint
703 Appeal Filing or Response
705 Ord Trf BD/Notice Show Cause/Mot Sum Jud
706 Administrative Law Judge Hearing Closed
707 Receipt of Formal Settlement Stipulation
708 Ord Grant Mot/Approv Stip/Trf To Board
709 Decision and Deter of Dispute (CD Only)
710 Settled After ALJ Hearing Closed
711 Settle After Open/Before Hearing Closed
712 Advice Actions
713 Appeal Filing or Response
714 Advice Actions
715 Formal Settlement Stipulation Approved
716 Exception to ALJ Decision
717 Order Granting Motion to Dismiss
718 Order Granting Motion to Withdraw
719 Exceptions Withdrawn to ALJ Decision
720 Opinion - Circuit Court Appeals
721 Decree Grant Motion to W/D - Cir Ct Appl
722 Decree Upholding Dismissal - Cir Ct Appl
723 Referral to Supreme Court
724 Decision - Supreme Court
725 Action on Petition Denied - Supreme Ct
726 Action on Petition Granted - Supreme Ct
727 Argument - Supreme Court
728 Suppl ALJ Dec/on Merits/After Ct Action
729 Supplemental Board Dec & Order ON MERITS
730 Supplemental Board Dec & Order (BACKPAY)
731 Backpay Specifications
732 Decree After Suppl Dec -Circuit Ct Appl
733 Order Quashing 10(K) Notice
752 Decree Enforcing Full/Part - Cir Ct Appl
753 Decree Deny Enf/Set Aside/Vacate-Cir Ct
756 Contested or Stipulated Decision
757 Exceptions Filed to Supplemental ALJ Dec
759 Board Dec and Order Remanding to ALJ
760 Administrative Law Judge Decision
762 Except Filed to Suppl ALJ Dec ON BACKPAY
763 Supplemental ALJ Decision (BACKPAY)
765 Backpay Hearing Closed (Not Remanded)

Next page

CREATE TABLE "l_transaction_codes" (
   [trans] TEXT PRIMARY KEY,
   [action] TEXT
);