l_r_action_fields

88 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Link action_table_code action_field_code tbl_name field_name description chronology_flag
RACT,Actn RACT Actn R_ACTION Action_Date No description available N
RAGEN,Assgn RAGEN Assgn R_AGENT Date_Assigned Board agent assigned N
RAGEN,Deasg RAGEN Deasg R_AGENT Date_De_Assigned Board agent unassigned N
RAGSU,Assgn RAGSU Assgn R_CURRENT_SUPERVISOR Date_Assigned Supervisor assigned to Board agent N
RAMND,Amend RAMND Amend R_AMENDMENT Amendment_Date Amended Petition filed Y
RBLCK,Block RBLCK Block R_BLOCK Blocked Case blocked Y
RBLCK,BrdDt RBLCK BrdDt R_BLOCK ReqProc_Board_Deter_Date Board determination on Request to Proceed issued Y
RBLCK,BrdFi RBLCK BrdFi R_BLOCK ReqProc_Board_Filed_Date Request to Proceed filed with Board Y
RBLCK,ProFi RBLCK ProFi R_BLOCK Req_Proceed_Filed Request to Proceed filed Y
RBLCK,ProWd RBLCK ProWd R_BLOCK Req_Proceed_Withdrawn Request to Proceed withdrawn Y
RBLCK,Unblk RBLCK Unblk R_BLOCK Unblocked Case unblocked Y
RCASE,Close RCASE Close R_CASE Date_Closed Case closed N
RCASE,Elect RCASE Elect R_CASE Election_Target_Date Target date for election N
RCASE,Filed RCASE Filed R_CASE Date_Filed Petition filed Y
RCASE,Hear RCASE Hear R_CASE Hearing_Target_Date Target date for hearing N
RCERT,Rep RCERT Rep R_ELECT_CERTIFICATION Cert_of_Representative Certification of Representative issued Y
RCERT,Resul RCERT Resul R_ELECT_CERTIFICATION Cert_of_Results Certification of Results issued Y
RCLOS,Archv RCLOS Archv R_CLOSED_CASE Date_File_Archives Case file sent to Archives N
RCLOS,Close RCLOS Close R_CLOSED_CASE Closing_Date Case closed Y
RCLOS,Destr RCLOS Destr R_CLOSED_CASE Date_File_Destroyed Case file destroyed N
RCLOS,Recrd RCLOS Recrd R_CLOSED_CASE Date_File_to_Records Case filed sent to Federal Records Center N
RCSGR,Added RCSGR Added R_CASE_CASE_GROUP Date_Case_Added Date case added to case group N
RCSGR,Remov RCSGR Remov R_CASE_CASE_GROUP Date_Case_Removed Date case removed from case group N
RDISM,Lettr RDISM Lettr R_DISMISSAL Date_Letter_Issued Dismissal letter issued Y
RELEC,Elect RELEC Elect R_ELECTION Date_Election Election held Y
RHIST,Close RHIST Close R_HISTORY Date_Closed Case closed N
RHIST,Filed RHIST Filed R_HISTORY Date_Filed Petition filed N
RIMPC,Post RIMPC Post R_IMPACT_CATEGORY PostElection_Date Post-Election Impact Analysis Category assigned N
RIMPC,Pre RIMPC Pre R_IMPACT_CATEGORY PreElection_Date Pre-Election Impact Analysis Category assigned N
RNMCH,NmChg RNMCH NmChg R_NAME_CHANGE Name_Change_Date Party name changed N
RNOTE,Note RNOTE Note R_CASE_NOTE Date_Note Case note entered N
RNOTE,Updat RNOTE Updat R_CASE_NOTE Date_Updated Case note updated N
ROBJ,Objec ROBJ Objec R_OBJECTION_ISSUE Objection_Issue_Date Objections filed Y
RPEBD,BdDec RPEBD BdDec R_PRE_ELECT_BOARD_ACT Board_Decision_Date Pre-election Board Decision issued Y
RPEBD,ExpWd RPEBD ExpWd R_PRE_ELECT_BOARD_ACT Exception_Withdrawn_Date Pre-election Exceptions withdrawn N
RPEBD,Recvd RPEBD Recvd R_PRE_ELECT_BOARD_ACT Received_Date Pre-election Request for Review or Motion filed Y
RPEBD,Rulng RPEBD Rulng R_PRE_ELECT_BOARD_ACT Ruling_Decision_Date Pre-election ruling on Request for Review or Motion issued Y
RPOBD,BdDec RPOBD BdDec R_POST_ELECT_BOARD_ACT Board_Decision_Date Post-election Board Decision issued Y
RPOBD,ExpWd RPOBD ExpWd R_POST_ELECT_BOARD_ACT Exception_Withdrawn_Date Post-election Exceptions withdrawn Y
RPOBD,Recvd RPOBD Recvd R_POST_ELECT_BOARD_ACT Received_Date Post-election Request for Review, Exceptions or Motion filed Y
RPOBD,Rulng RPOBD Rulng R_POST_ELECT_BOARD_ACT Ruling_Decision_Date Post-election ruling on Request for Review or Motion issued Y
RPRHR,Close RPRHR Close R_PRE_ELECT_HEARING Hearing_Closed Pre-election hearing closed Y
RPRHR,HORpt RPRHR HORpt R_PRE_ELECT_HEARING Hearing_Off_Rep_Date Pre-election hearing officer's report submitted Y
RPRHR,Notic RPRHR Notic R_PRE_ELECT_HEARING Date_Notice_Issued Pre-election Notice of Hearing issued Y
RPRHR,Open RPRHR Open R_PRE_ELECT_HEARING Hearing_Opened Pre-election hearing opened Y
RPRHR,PPRcv RPRHR PPRcv R_PRE_ELECT_HEARING P_P_Rcvd_Region Request for postponement of pre-election hearing received N
RPRHR,PPRsp RPRHR PPRsp R_PRE_ELECT_HEARING P_P_Response_Date Determination on request for postponement of pre-election hearing issued N
RPRHR,Resch RPRHR Resch R_PRE_ELECT_HEARING Date_Rescheduled_Issued Pre-election hearing rescheduled Y
RPRHR,Sched RPRHR Sched R_PRE_ELECT_HEARING Date_Hearing_Scheduled Scheduled date for pre-election hearing N
RPRRD,Brf RPRRD Brf R_PRE_ELECT_RD_DECISION Brief_Due_Date Pre-election hearing brief due N
RPRRD,BrfRc RPRRD BrfRc R_PRE_ELECT_RD_DECISION Pre_Election_Brief_Rcvd Pre-election hearing brief filed Y
RPRRD,EOTDt RPRRD EOTDt R_PRE_ELECT_RD_DECISION EOT_Deter_Brief_Date Determination on request for EOT to file pre-election hearing brief issued N
RPRRD,EOTFi RPRRD EOTFi R_PRE_ELECT_RD_DECISION EOT_Filed_Date Request for EOT to file pre-election hearing brief filed N
RPRRD,Issue RPRRD Issue R_PRE_ELECT_RD_DECISION RD_Decision_Issued_Date Pre-election RD decision issued Y
RPRRD,RecFi RPRRD RecFi R_PRE_ELECT_RD_DECISION Recon_Request_Filed Request for Reconsideration of RD pre-election decision filed Y
RPRRD,Recon RPRRD Recon R_PRE_ELECT_RD_DECISION RD_Recon_Deter_Date RD issued determination on pre-election Request for Reconsideration Y
RPRRD,Revw RPRRD Revw R_PRE_ELECT_RD_DECISION Review_Due_Date Request for Review due (original date) N
RPSHR,Close RPSHR Close R_POST_ELECT_HEARING Hearing_Closed Post-election hearing closed Y
RPSHR,NOH RPSHR NOH R_POST_ELECT_HEARING NOH_Issued Post-election Notice of Hearing issued Y
RPSHR,Open RPSHR Open R_POST_ELECT_HEARING Hearing_Opened Post-election hearing opened Y
RPSHR,PPOrd RPSHR PPOrd R_POST_ELECT_HEARING P_P_Order_Issued Reschedule of post-election hearing issued N
RPSHR,PPReq RPSHR PPReq R_POST_ELECT_HEARING P_P_Request_Date Request for postponement of post-election hearing received N
RPSHR,Resch RPSHR Resch R_POST_ELECT_HEARING Date_Reschedule_Issued Post-election hearing rescheduled Y
RPSHR,Sched RPSHR Sched R_POST_ELECT_HEARING Hearing_Scheduled Scheduled date for post-election hearing N
RPSRD,Actn RPSRD Actn R_POST_ELECT_RD_ACT Action_Date Post-election RD action issued Y
RPSRD,Brf RPSRD Brf R_POST_ELECT_RD_ACT Brief_Due Post-election hearing brief due N
RPSRD,BrfFi RPSRD BrfFi R_POST_ELECT_RD_ACT Brief_Filed Post-election hearing brief filed Y
RPSRD,EOTDt RPSRD EOTDt R_POST_ELECT_RD_ACT EOT_Determination_Date Determination on request for EOT to file post-election hearing brief issued N
RPSRD,EOTRq RPSRD EOTRq R_POST_ELECT_RD_ACT EOT_Request_Date Request for EOT to file post-election hearing brief filed N
RPSRD,HORpt RPSRD HORpt R_POST_ELECT_RD_ACT Date_HO_Report Post-Election Hearing Officer's Report issued Y
RPSRD,Revw RPSRD Revw R_POST_ELECT_RD_ACT Review_Due_Date Request for review due (original date) N
RRAGR,Appr RRAGR Appr R_ELECT_AGREEMENT Date_Approved Election Agreement approved Y
RREOP,Reopn RREOP Reopn R_REOPENED_CASE Date_Reopened Case Reopened Y
RRGRP,Creat RRGRP Creat R_CASE_GROUP Date_Created Date case group created N
RRGRP,Dissl RRGRP Dissl R_CASE_GROUP Date_Dissolved Date case group dissolved N
RSCHD,ELDue RSCHD ELDue R_ELECT_SCHEDULED Date_Excelsior_List_Due Date the Excelsior List of the names of eligible voters is due at NLRB. N
RSCHD,ELRcd RSCHD ELRcd R_ELECT_SCHEDULED Date_Excelsior_List_Received Date the Excelsior List of the names of eligible voters is received at NLRB. N
RSCHD,ESent RSCHD ESent R_ELECT_SCHEDULED Date_Excelsior_List_Sent Date the Excelsior List of the names of eligible voters is sent by the NLRB. N
RSCHD,Eligi RSCHD Eligi R_ELECT_SCHEDULED Date_Eligible Election eligibility date based on election agreement approval or DDE date. N
RSCHD,Sched RSCHD Sched R_ELECT_SCHEDULED Schedule_Date Scheduled date for election N
RSCHD,Tally RSCHD Tally R_ELECT_SCHEDULED Scheduled_Tally_Date Scheduled date for tally of ballots N
RTALL,Tally RTALL Tally R_ELECTION_TALLY Tally_Date Tally of Ballots issued Y
RWITH,Appr RWITH Appr R_WITHDRAWAL Withdrawal_Approved_Date Withdrawal request approved Y
RXFER,Hist RXFER Hist R_TRANSFER_HISTORY History_Date No description available N
RXFER,Order RXFER Order R_TRANSFER_HISTORY Transfer_Order_Date Order transferring case to another region issued Y
RXFER,Rcvd RXFER Rcvd R_TRANSFER_HISTORY Received_Date Case data received in transfer region N
RXFER,Req RXFER Req R_TRANSFER_HISTORY Request_Date Request to transfer case to another region submitted to Operations Y
RXFER,Sent RXFER Sent R_TRANSFER_HISTORY Sent_Date Case data sent to transfer region N

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE "l_r_action_fields" (
[action_table_code] text,
[action_field_code] text,
[tbl_name] text,
[field_name] text,
[description] text,
[chronology_flag] text,
    PRIMARY KEY ([action_table_code],[action_field_code])
);