participant and participant_party tables

This message is to confirm your request submission to the FOIAonline application: View Request. Request information is as follows: (https://foiaonline.gov/foiaonline/action/public/submissionDetails?trackingNumber=NLRB-2023-001998&type=Request)

* Tracking Number: NLRB-2023-001998
* Requester Name:
Forest Gregg
* Date Submitted: 08/23/2023
* Request Status: Submitted
* Description:
To Whom It May Concern:

Pursuant to the Freedom of Information Act, I hereby request the following records:

An export of all non-exempt fields of the participant and participant_party tables from the NxGen case management system database.

The requested documents will be made available to the general public, and this request is not being made for commercial purposes.

In the event that there are fees, I would be grateful if you would inform me of the total charges in advance of fulfilling my request. I would prefer the request filled electronically, by e-mail attachment if available or CD-ROM if not.

Thank you in advance for your anticipated cooperation in this matter. I look forward to receiving your response to this request within 20 business days, as the statute requires.

Sincerely,

Forest Gregg

Upload documents directly: https://www.muckrock.com/

CAUTION: This email and any attachments may contain Controlled Unclassified Information (CUI). National Archives and Records Administration (NARA) regulations at 32 CFR Part 2002 apply to all executive branch agencies that designate or handle information that meets the standards for CUI.

I'm working on FOIA request NLRB-2023-001998 for "all non-exempt fields of the participant and participant_party tables from the NxGen case management system database."

NxGen designates participants to have one of four roles:

* Primary: This is usually the main address of the facility as designated on the charge or petition
* Legal Rep: Legal representation for the primary participant
* Additional Service: These are people who would be like a cc in letters, or it could be a secondary address for someone. For example: many union reps list their official business address as primary, and because they might be located in a remote area or working from home, they have a secondary address or home address listed as an additional service.
* Notification: This are the national or international union headquarters. To become a notification, the organization has to file Form 4702 annually, and the notification party only receives a copy of the charge or petition.

Participants also have distinct roles: Employer, Union, Individual, and Union as an Employer.

NxGen further designates participants as: Charging Party, Charged Party/Respondent, Involved Party, Petitioner, Intervenor, Employer, and Amicus.

Instead of providing a dump of all the participants in the system, and in order to provide the most relevant case information, my recommendation for participants is to provide the Primary participant information (entity name and address) and exclude the Legal Reps, Additional Services, and Notifications. Also, because the participant tables do not contain any other case-specific information besides the case number, I would recommend including the case name, date filed, date closed, and case closing reason. I also recommend information for individual charging parties/petitioners be listed simply as the party type of "Individual" and to exclude individuals' personal address information from your request (we would withheld it per Exemptions 6 and 7(C) if it's not specifically excluded.) Further, I would also recommend excluding Amicus information since cases can only have Amicus filings if the Board approves it.

Sample R case info:
Case Number
Case Name
Case Filed Date
Case Closed Date
Closed Reason
Dispute/Unit State
Dispute/Unit City
Employer Type
Employer Account Name
Employer Address1
Employer Address Address2
Employer Address City
Employer Address State
Employer Address Zipcode
Petitioner Party Type
Petitioner
Petitioner Address1
Petitioner Address2
Petitioner Address City
Petitioner Address State
Petitioner Address Zipcode
Union Involved Party Type
Union Involved
Union Involved Address1
Union Involved Address2
Union Involved City
Union Involved State
Union Involved Zipcode
09-RC-324532
Dunkin' Donuts
08/25/2023

OH
Cincinnati
Employer
Dunkin' Donuts
850 Eastgate North Drive

Cincinnati
OH
45245
Union
Bakery, Confectionery, Tobacco Workers and Grain Millers International Union, Local 57, AFL-CIO, CLC
871 West Marion Road, Suite 202

Mt. Gilead
OH
43338

03-RD-316974
Starbucks Corporation
4/28/2023

NY
Buffalo
Employer
Starbucks Corporation
2401 Utah Avenue South

Buffalo
NY
14202
Individual

Union
Workers United
2495 Main St. Suite 556

Buffalo
NY

(Another group of columns would be added at the right side for Intervenor information.)

Sample C case info:
Case Number
Case Name
Case Filed Date
Case Closed Date
Closed Reason
Dispute/Unit State
Dispute/Unit City
Charged Party Type
Charged Party Account Name
Charged Party Address1
Charged Party Address Address2
Charged Party Address City
Charged Party Address State
Charged Party Address Zipcode
Charging Party Type
Charging Party
Charging Party Address1
Charging Party Address2
Charging Party Address City
Charging Party Address State
Charging Party Address Zipcode
Involved Party Type
Involved Party
Involved Party Address1
Involved Party Address2
Involved Party City
Involved Party State
Involved Party Zipcode
10-CA-298933
Amazon.com Services LLC
7/7/2022

AL
Bessemer
Employer
Amazon.com Services LLC
975 Powder Plant Rd

Bessemer
AL
35022-5497
Union
Retail, Wholesale and Department Store Union
1901 10th Avenue South

Birmingham
AL
35205

25-CB-245482
United Food and Commercial Workers Union, Local 400 (Bernie Sanders for President 2020)
7/25/2019
10/30/2019
Withdrawal Non-adjusted
IA
Bettendorf
Union
United Food and Commercial Workers Union, Local 400
8400 Corporate Drive

Landover
MD
20758
Individual

Employer
Bernie Sanders for President 2020
401 SW 8th Street
Suite 423
Des Moines
IA
50309

Are my recommendations and the above sample format acceptable to you? Also, do you have a specific case filed timeframe, or do you want everything in NxGen? Some of the older cases before FY2011 do not have participant info, but I can pull whatever we have if you want it.

Jodilyn M. Breirather, FOIA Specialist
National Labor Relations Board
Division of Legal Counsel
FOIA and Privacy Act Branch
414-930-7208

Please be aware that this email may be subject to public disclosure under the Freedom of Information Act or other authorities, though exceptions may apply for certain case-related information, personal privacy, and other matters.

Thanks so much, Jodilyn.

That looks awesome!

CAUTION: This email and any attachments may contain Controlled Unclassified Information (CUI). National Archives and Records Administration (NARA) regulations at 32 CFR Part 2002 apply to all executive branch agencies that designate or handle information that meets the standards for CUI.

Just wanted to let you know that the records for this request will be released to you within the hour. One of the files we’re releasing is too big to be attached to an email, so in addition to making the records available directly in FOIAonline, we’re also going to upload them to a secure NLRB site. You’ll receive a separate secure email with instructions to access the records on that site.

Just a reminder that FOIAonline is being decommissioned on Saturday, September 30, so any records in that system will no longer be available after that date. Also, if there is a government shutdown, the secure NLRB file site will be unavailable until funding is restored.

Let me know if you have any questions. ☺

Thanks so much, Jodilyn!

FOIA Case Handling (fchandle@nlrb.gov) has sent you a message.

Read the message (https://outlook.office365.com/Encryption/retrieve.ashx?recipientemailaddress=151172-54245967%40requests.muckrock.com&senderemailaddress=fchandle%40nlrb.gov&senderorganization=AwF7AAAAAncAAAADAQAAAHXAlYM1a5JFkOUPyOKEGQ1PVT1ubHJiLm9ubWljcm9zb2Z0LmNvbSxPVT1NaWNyb3NvZnQgRXhjaGFuZ2UgSG9zdGVkIE9yZ2FuaXphdGlvbnMsREM9TkFNUFIwOUEwMDMsREM9UFJPRCxEQz1PVVRMT09LLERDPUNPTQh99zD5mNtMirjsX6NT0ktDTj1Db25maWd1cmF0aW9uLENOPW5scmIub25taWNyb3NvZnQuY29tLENOPUNvbmZpZ3VyYXRpb25Vbml0cyxEQz1OQU1QUjA5QTAwMyxEQz1QUk9ELERDPU9VVExPT0ssREM9Q09NAQ%3d%3d&messageid=%3cSJ0PR09MB92562F3EF99F3D006A54B2CEB7C1A%40SJ0PR09MB9256.namprd09.prod.outlook.com%3e&cfmRecipient=SystemMailbox%7b0AF09B7F-434F-4B2F-9CBC-57639EDCFD9C%7d%40nlrb.onmicrosoft.com&consumerEncryption=false&senderorgid=5e453ed8-e338-43bb-9075-4ed5b8a8caa4&customizationTemplate=NLRB+FOIA+Public+Emails&urldecoded=1&e4e_sdata=uzhVdzM0Z3lckME%2fGWvWO3O1puR6p%2f%2bZJCR3%2bPY02fOTSmamHVcJSX2XaAOWrXlT0iYMBgeMbbhht8%2bcn3Hc2N%2fn1AV%2f8zHDVnD8cfHp%2bC2qRlPJ2B5FRRmsylhjhwHIWGDGX2a1dJHvSfGUCvLixx25sbH5f2%2byl%2bEVnG2%2fCMXhxcXqeswPfsow99AguqFi18cWuxhBLoYs5uf7z8U7mmZNXkPMp94g72YzZKJdaken52ydL9gsjdduB25pJn8rKFsOlgf5T%2fEcXMST2oK%2b0diYuXddSKNiL9tiK6jGM4uRmNtpV04gvFv3CrqNl7PhffO3w9oufype0AoMhYmZ0g%3d%3d)

Read Secured Message from NLRB
All Rights Reserved.
Privacy Statement (https://go.microsoft.com/fwlink/p/?linkid=857875)
Learn More on email encryption. (https://go.microsoft.com/fwlink/?Linkid=844050)
Microsoft Corporation, One Microsoft Way, Redmond, WA 98052

Earlier today, the Agency’s letter and responsive records were provided to you in an encrypted/secure email. A copy of the letter is attached to this email; however, the records are not attached here because they exceed the attachment file size allowed by FOIAonline. Please follow the instructions in the secure email and download the records before 11:59 p.m. Eastern Time on Friday, October 27, 2023.  In the event of a government shutdown, the secure site will be unavailable until funding is restored.

If you have questions about accessing the secure email and records, please contact FOIA Specialist Jodilyn Breirather at (414) 930-7208 or by email at Jodilyn.Breirather@nlrb.gov.

PLEASE DO NOT REPLY DIRECTLY TO THIS EMAIL; THIS IS NOT A MONITORED EMAIL ACCOUNT.