l_c_action_fields

264 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ action_table_code action_field_code tbl_name field_name description chronology_flag
1 1 C10JA Appl C_INJ_10J_APPEAL Appeal_Date 10(j) injunction appeal filed N
2 2 C10JA Applt C_INJ_10J_APPEAL Appellate_Date 10(j) injunction appeal decision issued N
3 3 C10K BrdDt C_10K Board_Deter_Date Board 10(k) Determination issued Y
4 4 C10K Disp C_10K Disposition_Date Final disposition of 10(k) matter N
5 5 C10K HORpt C_10K HO_Report_Issued 10(k) Hearing Officer's Report issued Y
6 6 CABEY Auth C_ABEYANCE Abeyance_Authorized Authorization given to hold case in formal abeyance Y
7 7 CABEY Req C_ABEYANCE Abeyance_Requested Authorization requested to hold case in formal abeyance Y
8 8 CABEY Resum C_ABEYANCE Processing_Resumed Case removed from formal abeyance and processing resumed Y
9 9 CACT Act C_ACTION Action_Date No description available N
10 10 CADVC DetRc C_ADVICE Advice_Deter_Rcvd_Reg Advice Memo received in Region N
11 11 CADVC FilRc C_ADVICE File_Received_Advice Case file received in Advice Y
12 12 CADVC FilSn C_ADVICE File_Sent_Advice_Date Case file sent to Advice Y
13 13 CADVC InRcv C_ADVICE InDef_Rcvd_Additional Additional information received in Advice N
14 14 CADVC InReq C_ADVICE InDef_Req_Additional Additional information requested by Advice N
15 15 CADVC Memo C_ADVICE Advice_Memo_Date Advice Memo issued Y
16 16 CADVC SubRc C_ADVICE Advice_Rcvd_Submission Request for Advice received in Advice N
17 17 CADVC Subm C_ADVICE Advice_Submission Request for Advice submitted Y
18 18 CAGEN Assgn C_AGENT Date_Assigned Board agent assigned to case N
19 19 CAGEN Deass C_AGENT Date_De_Assigned Board agent unassigned from case N
20 20 CAGSU Assgn C_AGENT_SUPERVISOR Date_Assigned Supervisor assigned for Board agent N
21 21 CALJD ALJRc C_ALJ_DECISION ALJ_Brief_Rcvd_ALJ Brief to ALJ received in Division of Judges N
22 22 CALJD BrDue C_ALJ_DECISION Brief_Due_Date Brief to ALJ due N
23 23 CALJD Deter C_ALJ_DECISION Determination_Date ALJ Decision issued Y
24 24 CALJD EOTDt C_ALJ_DECISION EOT_Deter_Date Request for extension of time to file brief with ALJ decided N
25 25 CALJD EOTRc C_ALJ_DECISION EOT_Request_Rcvd_ALJ Request for extension of time to file brief with ALJ filed N
26 26 CALJD Filed C_ALJ_DECISION ALJ_Date_Filed Brief is filed in Division of Judges Y
27 27 CALJD RegRc C_ALJ_DECISION ALJ_Brief_Rcvd_Region Brief to ALJ received in the Region Y
28 28 CALJM Deter C_ALJ_MOTION Determination_Date Determination on Motion to ALJ issued Y
29 29 CALJM Filed C_ALJ_MOTION Date_Filed Motion to ALJ filed Y
30 30 CALLA Actn C_ALLEG_ACTION Action_Date No description available N
31 31 CALLH Actn C_ALL_ACT_HISTORY Action_Date No description available N
32 32 CAMND Amend C_AMENDMENT Amendment_Date Amended Charge filed Y
33 33 CAPPL Deter C_APPEAL Appeal_Date_Determination Appeal determination issued Y
34 34 CAPPL EOTDt C_APPEAL EOT_Date_Determination Request for extension of time to file appeal decided N
35 35 CAPPL EOTFi C_APPEAL EOT_Date_Filed Request for extension of time to file appeal filed N
36 36 CAPPL Expir C_APPEAL Appeal_Expiration_Date Appeal due N
37 37 CAPPL FiReg C_APPEAL Appeal_File_Rcvd_Reg Case file received in Region from Appeals N
38 38 CAPPL FilOA C_APPEAL Appeal_File_OA Case file received in Appeals N
39 39 CAPPL Filed C_APPEAL Appeal_Date_Filed Appeal filed Y
40 40 CAPPL RcOA C_APPEAL Appeal_Rcvd_OA Appeal received in Appeals N
41 41 CAPPL RcReg C_APPEAL Appeal_Rcvd_in_Region Appeal received in Region N
42 42 CAPPL RtReg C_APPEAL Appeal_File_Rtrn_Reg Case file returned to Region by Appeals N
43 43 CBANK Chp11 C_BANKRUPTCY Chapter_11_Approved Chapter 11 bankruptcy plan approved Y
44 44 CBANK DisBk C_BANKRUPTCY Dis_Bank_Date Bankruptcy case discharged Y
45 45 CBANK POC C_BANKRUPTCY POC_Date Proof of Claim filed Y
46 46 CBANK POCBa C_BANKRUPTCY POC_Bar_Date Proof of Claim bar date N
47 47 CBANK PetFi C_BANKRUPTCY Bank_Pet_Filed Bankruptcy petition filed Y
48 48 CBDDC Decsn C_BOARD_DECISION Decision_Date Board Decision issued Y
49 49 CBDDC EETDt C_BOARD_DECISION Exceptions_EOT_Deter_Date Request for extension of time to file exceptions to ALJ Decision decided N
50 50 CBDDC EETFi C_BOARD_DECISION Exceptions_EOT_Date_Filed Request for extension of time to file exceptions to ALJ Decision filed N
51 51 CBDDC ExDue C_BOARD_DECISION Exception_Due_Date Exceptions to Supplemental ALJ Decision due N
52 52 CBDDC ExFil C_BOARD_DECISION Exceptions_Date_Filed Exceptions to ALJ Decision filed Y
53 53 CBDDC METDt C_BOARD_DECISION Motion_EOT_Deter_Date Request for extension of time to file motion for reconsideration decided N
54 54 CBDDC METFi C_BOARD_DECISION Motion_EOT_Date_Filed Request for extension of time to file motion for reconsideration filed N
55 55 CBDDC OrArg C_BOARD_DECISION Oral_Arg_Date Oral Argument held before Board Y
56 56 CBDDC OrOrd C_BOARD_DECISION Oral_Arg_Order_Date Order setting oral argument date issued Y
57 57 CBDDC OrReq C_BOARD_DECISION Oral_Arg_Req Request for oral argument before Board filed Y
58 58 CBDDC OrSch C_BOARD_DECISION Oral_Arg_Sch_Date Scheduled date for oral argument with Board N
59 59 CBDDC RcReg C_BOARD_DECISION Date_Received_Region Board Decision received in Region N
60 60 CBDDC Req C_BOARD_DECISION Request_Date Motion for Reconsideration filed with Board Y
61 61 CBDDC ReqDt C_BOARD_DECISION Request_Deter_Date Board determination on Motion for Reconsideration issued Y
62 62 CBDDC Trans C_BOARD_DECISION Transfer_Order_Date Order Transferring Proceeding to Board issued Y
63 63 CBDMT Mot C_BOARD_OTHER_MOTIONS Other_Motion_Date Motion filed with Board N
64 64 CBDMT MotDt C_BOARD_OTHER_MOTIONS Other_Motion_Deter_Date Determination on Motion to Board issued N
65 65 CCALJ ALJRc C_SUP_ALJD_CMP ALJ_Brief_Rcvd_ALJ Brief to ALJ received in Division of Judges N
66 66 CCALJ BrDue C_SUP_ALJD_CMP Brief_Due_Date Brief to ALJ due N
67 67 CCALJ Comp C_SUP_ALJD_CMP ALJD_Comp_Date ALJ Decision issued Y
68 68 CCALJ EOTDt C_SUP_ALJD_CMP EOT_Brief_Deter_Date Determination on request for EOT to file brief with ALJ issued N
69 69 CCALJ EOTRc C_SUP_ALJD_CMP EOT_Request_Rcvd_ALJ Request for EOT to file brief with ALJ filed N
70 70 CCALJ Filed C_SUP_ALJD_CMP ALJ_Date_Filed Brief to ALJ filed Y
71 71 CCALJ RegRc C_SUP_ALJD_CMP ALJ_Brief_Rcvd_Region Brief to ALJ received in Region N
72 72 CCASE Close C_CASE Date_Closed Case closed N
73 73 CCASE Disp C_CASE Disposition_Due Disposition of case due N
74 74 CCASE Filed C_CASE Date_Filed Charge filed Y
75 75 CCBRD BDIss C_SUP_BOARD_DEC_CMP BD_Issued Board Decision issued Y
76 76 CCBRD EETDt C_SUP_BOARD_DEC_CMP Exceptions_EOT_Deter_Date Determination on request for EOT to file exceptions issued N
77 77 CCBRD EETFi C_SUP_BOARD_DEC_CMP Exceptions_EOT_Date_Filed Request for EOT to file exceptions filed N
78 78 CCBRD ExDue C_SUP_BOARD_DEC_CMP Exception_Due Exceptions due N
79 79 CCBRD ExFil C_SUP_BOARD_DEC_CMP Exception_Filed Exceptions filed Y
80 80 CCBRD METDt C_SUP_BOARD_DEC_CMP Motion_EOT_Deter_Date Determination on request for EOT to file motion for reconsideration issued N
81 81 CCBRD METFi C_SUP_BOARD_DEC_CMP Motion_EOT_Date_Filed Request for EOT to file motion of reconsideration filed N
82 82 CCBRD OrArg C_SUP_BOARD_DEC_CMP Oral_Arg_Date Oral argument held before Board Y
83 83 CCBRD OrOrd C_SUP_BOARD_DEC_CMP Oral_Arg_Order_Date Oral argument ordered by Board Y
84 84 CCBRD OrReq C_SUP_BOARD_DEC_CMP Oral_Arg_Req Request for oral argument filed with Board N
85 85 CCBRD OrSch C_SUP_BOARD_DEC_CMP Oral_Arg_Sch_Date Scheduled date for oral argument before Board N
86 86 CCBRD RcReg C_SUP_BOARD_DEC_CMP Date_Received_Region Board Decision received in Region N
87 87 CCBRD Req C_SUP_BOARD_DEC_CMP Request_Date Motion for Reconsideration filed with Board N
88 88 CCBRD ReqDt C_SUP_BOARD_DEC_CMP Request_Deter_Date Determination on Motion for Reconsideration issued N
89 89 CCBRD Trans C_SUP_BOARD_DEC_CMP Transfer_Order_Date Order Transferring Proceeding to Board issued Y
90 90 CCGLS Close C_COMPLIANCE_GOALS Closing_Goal Closing goal N
91 91 CCGLS Expir C_COMPLIANCE_GOALS Post_Expires Posting period expires N
92 92 CCGLS Goal C_COMPLIANCE_GOALS Posting_Goal Posting goal N
93 93 CCGLS Lettr C_COMPLIANCE_GOALS Letter_Date Compliance letter issued Y
94 94 CCGLS Notic C_COMPLIANCE_GOALS Notices_Post_Dates Notices posted N
95 95 CCGLS ReGl C_COMPLIANCE_GOALS Reinstatement_Goal Reinstatement goal N
96 96 CCGLS ReOff C_COMPLIANCE_GOALS Reinstatement_Offered Reinstatement offered N
97 97 CCGRP Creat C_CASE_GROUP Date_Created Case group created N
98 98 CCGRP Dissl C_CASE_GROUP Date_Dissolved Case group dissolved N
99 99 CCLOS Archv C_CLOSING Date_File_Sent_Archives Case file sent to Archives N
100 100 CCLOS Close C_CLOSING Date_Closed Case closed Y

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "l_c_action_fields" (
"action_table_code" TEXT,
  "action_field_code" TEXT,
  "tbl_name" TEXT,
  "field_name" TEXT,
  "description" TEXT,
  "chronology_flag" TEXT
);