l_c_action_fields

264 rows

✎ View and edit SQL

Suggested facets: chronology_flag

action_table_code action_field_code tbl_name field_name description chronology_flag
C10JA Appl C_INJ_10J_APPEAL Appeal_Date 10(j) injunction appeal filed N
C10JA Applt C_INJ_10J_APPEAL Appellate_Date 10(j) injunction appeal decision issued N
C10K BrdDt C_10K Board_Deter_Date Board 10(k) Determination issued Y
C10K Disp C_10K Disposition_Date Final disposition of 10(k) matter N
C10K HORpt C_10K HO_Report_Issued 10(k) Hearing Officer's Report issued Y
CABEY Auth C_ABEYANCE Abeyance_Authorized Authorization given to hold case in formal abeyance Y
CABEY Req C_ABEYANCE Abeyance_Requested Authorization requested to hold case in formal abeyance Y
CABEY Resum C_ABEYANCE Processing_Resumed Case removed from formal abeyance and processing resumed Y
CACT Act C_ACTION Action_Date No description available N
CADVC DetRc C_ADVICE Advice_Deter_Rcvd_Reg Advice Memo received in Region N
CADVC FilRc C_ADVICE File_Received_Advice Case file received in Advice Y
CADVC FilSn C_ADVICE File_Sent_Advice_Date Case file sent to Advice Y
CADVC InRcv C_ADVICE InDef_Rcvd_Additional Additional information received in Advice N
CADVC InReq C_ADVICE InDef_Req_Additional Additional information requested by Advice N
CADVC Memo C_ADVICE Advice_Memo_Date Advice Memo issued Y
CADVC SubRc C_ADVICE Advice_Rcvd_Submission Request for Advice received in Advice N
CADVC Subm C_ADVICE Advice_Submission Request for Advice submitted Y
CAGEN Assgn C_AGENT Date_Assigned Board agent assigned to case N
CAGEN Deass C_AGENT Date_De_Assigned Board agent unassigned from case N
CAGSU Assgn C_AGENT_SUPERVISOR Date_Assigned Supervisor assigned for Board agent N
CALJD ALJRc C_ALJ_DECISION ALJ_Brief_Rcvd_ALJ Brief to ALJ received in Division of Judges N
CALJD BrDue C_ALJ_DECISION Brief_Due_Date Brief to ALJ due N
CALJD Deter C_ALJ_DECISION Determination_Date ALJ Decision issued Y
CALJD EOTDt C_ALJ_DECISION EOT_Deter_Date Request for extension of time to file brief with ALJ decided N
CALJD EOTRc C_ALJ_DECISION EOT_Request_Rcvd_ALJ Request for extension of time to file brief with ALJ filed N
CALJD Filed C_ALJ_DECISION ALJ_Date_Filed Brief is filed in Division of Judges Y
CALJD RegRc C_ALJ_DECISION ALJ_Brief_Rcvd_Region Brief to ALJ received in the Region Y
CALJM Deter C_ALJ_MOTION Determination_Date Determination on Motion to ALJ issued Y
CALJM Filed C_ALJ_MOTION Date_Filed Motion to ALJ filed Y
CALLA Actn C_ALLEG_ACTION Action_Date No description available N
CALLH Actn C_ALL_ACT_HISTORY Action_Date No description available N
CAMND Amend C_AMENDMENT Amendment_Date Amended Charge filed Y
CAPPL Deter C_APPEAL Appeal_Date_Determination Appeal determination issued Y
CAPPL EOTDt C_APPEAL EOT_Date_Determination Request for extension of time to file appeal decided N
CAPPL EOTFi C_APPEAL EOT_Date_Filed Request for extension of time to file appeal filed N
CAPPL Expir C_APPEAL Appeal_Expiration_Date Appeal due N
CAPPL FiReg C_APPEAL Appeal_File_Rcvd_Reg Case file received in Region from Appeals N
CAPPL FilOA C_APPEAL Appeal_File_OA Case file received in Appeals N
CAPPL Filed C_APPEAL Appeal_Date_Filed Appeal filed Y
CAPPL RcOA C_APPEAL Appeal_Rcvd_OA Appeal received in Appeals N
CAPPL RcReg C_APPEAL Appeal_Rcvd_in_Region Appeal received in Region N
CAPPL RtReg C_APPEAL Appeal_File_Rtrn_Reg Case file returned to Region by Appeals N
CBANK Chp11 C_BANKRUPTCY Chapter_11_Approved Chapter 11 bankruptcy plan approved Y
CBANK DisBk C_BANKRUPTCY Dis_Bank_Date Bankruptcy case discharged Y
CBANK POC C_BANKRUPTCY POC_Date Proof of Claim filed Y
CBANK POCBa C_BANKRUPTCY POC_Bar_Date Proof of Claim bar date N
CBANK PetFi C_BANKRUPTCY Bank_Pet_Filed Bankruptcy petition filed Y
CBDDC Decsn C_BOARD_DECISION Decision_Date Board Decision issued Y
CBDDC EETDt C_BOARD_DECISION Exceptions_EOT_Deter_Date Request for extension of time to file exceptions to ALJ Decision decided N
CBDDC EETFi C_BOARD_DECISION Exceptions_EOT_Date_Filed Request for extension of time to file exceptions to ALJ Decision filed N
CBDDC ExDue C_BOARD_DECISION Exception_Due_Date Exceptions to Supplemental ALJ Decision due N
CBDDC ExFil C_BOARD_DECISION Exceptions_Date_Filed Exceptions to ALJ Decision filed Y
CBDDC METDt C_BOARD_DECISION Motion_EOT_Deter_Date Request for extension of time to file motion for reconsideration decided N
CBDDC METFi C_BOARD_DECISION Motion_EOT_Date_Filed Request for extension of time to file motion for reconsideration filed N
CBDDC OrArg C_BOARD_DECISION Oral_Arg_Date Oral Argument held before Board Y
CBDDC OrOrd C_BOARD_DECISION Oral_Arg_Order_Date Order setting oral argument date issued Y
CBDDC OrReq C_BOARD_DECISION Oral_Arg_Req Request for oral argument before Board filed Y
CBDDC OrSch C_BOARD_DECISION Oral_Arg_Sch_Date Scheduled date for oral argument with Board N
CBDDC RcReg C_BOARD_DECISION Date_Received_Region Board Decision received in Region N
CBDDC Req C_BOARD_DECISION Request_Date Motion for Reconsideration filed with Board Y
CBDDC ReqDt C_BOARD_DECISION Request_Deter_Date Board determination on Motion for Reconsideration issued Y
CBDDC Trans C_BOARD_DECISION Transfer_Order_Date Order Transferring Proceeding to Board issued Y
CBDMT Mot C_BOARD_OTHER_MOTIONS Other_Motion_Date Motion filed with Board N
CBDMT MotDt C_BOARD_OTHER_MOTIONS Other_Motion_Deter_Date Determination on Motion to Board issued N
CCALJ ALJRc C_SUP_ALJD_CMP ALJ_Brief_Rcvd_ALJ Brief to ALJ received in Division of Judges N
CCALJ BrDue C_SUP_ALJD_CMP Brief_Due_Date Brief to ALJ due N
CCALJ Comp C_SUP_ALJD_CMP ALJD_Comp_Date ALJ Decision issued Y
CCALJ EOTDt C_SUP_ALJD_CMP EOT_Brief_Deter_Date Determination on request for EOT to file brief with ALJ issued N
CCALJ EOTRc C_SUP_ALJD_CMP EOT_Request_Rcvd_ALJ Request for EOT to file brief with ALJ filed N
CCALJ Filed C_SUP_ALJD_CMP ALJ_Date_Filed Brief to ALJ filed Y
CCALJ RegRc C_SUP_ALJD_CMP ALJ_Brief_Rcvd_Region Brief to ALJ received in Region N
CCASE Close C_CASE Date_Closed Case closed N
CCASE Disp C_CASE Disposition_Due Disposition of case due N
CCASE Filed C_CASE Date_Filed Charge filed Y
CCBRD BDIss C_SUP_BOARD_DEC_CMP BD_Issued Board Decision issued Y
CCBRD EETDt C_SUP_BOARD_DEC_CMP Exceptions_EOT_Deter_Date Determination on request for EOT to file exceptions issued N
CCBRD EETFi C_SUP_BOARD_DEC_CMP Exceptions_EOT_Date_Filed Request for EOT to file exceptions filed N
CCBRD ExDue C_SUP_BOARD_DEC_CMP Exception_Due Exceptions due N
CCBRD ExFil C_SUP_BOARD_DEC_CMP Exception_Filed Exceptions filed Y
CCBRD METDt C_SUP_BOARD_DEC_CMP Motion_EOT_Deter_Date Determination on request for EOT to file motion for reconsideration issued N
CCBRD METFi C_SUP_BOARD_DEC_CMP Motion_EOT_Date_Filed Request for EOT to file motion of reconsideration filed N
CCBRD OrArg C_SUP_BOARD_DEC_CMP Oral_Arg_Date Oral argument held before Board Y
CCBRD OrOrd C_SUP_BOARD_DEC_CMP Oral_Arg_Order_Date Oral argument ordered by Board Y
CCBRD OrReq C_SUP_BOARD_DEC_CMP Oral_Arg_Req Request for oral argument filed with Board N
CCBRD OrSch C_SUP_BOARD_DEC_CMP Oral_Arg_Sch_Date Scheduled date for oral argument before Board N
CCBRD RcReg C_SUP_BOARD_DEC_CMP Date_Received_Region Board Decision received in Region N
CCBRD Req C_SUP_BOARD_DEC_CMP Request_Date Motion for Reconsideration filed with Board N
CCBRD ReqDt C_SUP_BOARD_DEC_CMP Request_Deter_Date Determination on Motion for Reconsideration issued N
CCBRD Trans C_SUP_BOARD_DEC_CMP Transfer_Order_Date Order Transferring Proceeding to Board issued Y
CCGLS Close C_COMPLIANCE_GOALS Closing_Goal Closing goal N
CCGLS Expir C_COMPLIANCE_GOALS Post_Expires Posting period expires N
CCGLS Goal C_COMPLIANCE_GOALS Posting_Goal Posting goal N
CCGLS Lettr C_COMPLIANCE_GOALS Letter_Date Compliance letter issued Y
CCGLS Notic C_COMPLIANCE_GOALS Notices_Post_Dates Notices posted N
CCGLS ReGl C_COMPLIANCE_GOALS Reinstatement_Goal Reinstatement goal N
CCGLS ReOff C_COMPLIANCE_GOALS Reinstatement_Offered Reinstatement offered N
CCGRP Creat C_CASE_GROUP Date_Created Case group created N
CCGRP Dissl C_CASE_GROUP Date_Dissolved Case group dissolved N
CCLOS Archv C_CLOSING Date_File_Sent_Archives Case file sent to Archives N
CCLOS Close C_CLOSING Date_Closed Case closed Y

Next page

Download this data

CSV · JSON

Table schema 
CREATE TABLE l_c_action_fields(action_table_code VARCHAR, action_field_code VARCHAR, tbl_name VARCHAR, field_name VARCHAR, description VARCHAR, chronology_flag VARCHAR);