# Mock 24-hour FDA records request — EXAMPLE DATA

**EXAMPLE DATA. Fictional firm. Not a live U.S. Food and Drug Administration (FDA) request and not a real business.** This is a worked example of the job a buyer is paying for: retrieving the required Key Data Elements (KDEs) for a stated Critical Tracking Event (CTE) and date range, and providing them in an electronic sortable spreadsheet within 24 hours under 21 Code of Federal Regulations (CFR) 1.1455(c). Nothing in this file is a certification of compliance.

## The request (EXAMPLE)

On a Monday morning, FDA asks Example Meadowbrook Produce Distributing to provide the required traceability records for **all romaine shipped on November 4, 2026 through November 5, 2026, inclusive**, within 24 hours (21 CFR 1.1455(c)), or within a reasonable time FDA has agreed to, unless an exception in 21 CFR 1.1455(c)(3)(iii) or (iv) applies.

The firm's written procedure for who answers, how the sheet is filtered, and who checks it is summarized in the one-pager (`sample-client-summary.pdf`). The full written plan is available on request. In this example, Traceability Coordinator Alex Rivera filters the Shipping tab of `sortable-spreadsheet-EXAMPLE-DATA.xlsx` to romaine rows whose shipping date is in that range, sorts by traceability lot code and then by date, and then pulls the matching receiving and transformation rows so a back-trace can be shown. Warehouse manager review happens before the file is provided.

The filtered shipping rows are also saved as `mock-fda-request-romaine-shipped-2026-11-04-to-11-05-EXAMPLE-DATA.csv` and as the `MOCK-FDA-REQUEST-EXAMPLE` tab of the workbook.

## Filtered shipping rows (EXAMPLE)

Three of the five shipping rows in the sample are romaine shipped on 11/04/2026 or 11/05/2026. They are shown here sorted by traceability lot code, then shipping date. Dates are calendar dates in month/day/year form.

| Traceability lot code | Ship date | Quantity | Product | Immediate subsequent recipient | Reference documents | Traceability lot code source |
|---|---|---|---|---|---|---|
| EMPD-EXH-ROM-110326 | 11/05/2026 | 8 cases | Romaine Hearts 12-count (Example Hillside) | Example Market Grocery #12 | Bill of Lading BOL-EX-3003; Advance Shipping Notice ASN-EX-3003 | This warehouse (the firm assigned the code on receipt from an exempt person) |
| EMPD-RP-ROM-110426 | 11/05/2026 | 20 cases | Romaine Hearts 6-count (Example Meadowbrook) | Example Kitchen Restaurant Supply | Bill of Lading BOL-EX-3002; Advance Shipping Notice ASN-EX-3002 | This warehouse (the firm assigned the code on transformation) |
| EV-ROM-110126 | 11/04/2026 | 20 cases | Romaine Hearts 12-count (Example Farm) | Example Market Grocery #12 | Bill of Lading BOL-EX-3001; Advance Shipping Notice ASN-EX-3001 | Example Valley Packing (the initial packer; this firm did not reassign the code) |

The spinach shipment on 11/04/2026 and the tomato shipment on 11/05/2026 are correctly excluded because they are not romaine.

## Back-trace of EMPD-RP-ROM-110426 (EXAMPLE)

The request is for shipped romaine. One of those shipped lots was created at this warehouse, so the Coordinator also produces the transformation and receiving records that explain where it came from.

```
EMPD-RP-ROM-110426  (shipped 11/05/2026, 20 cases, 6-count, BOL-EX-3002, ASN-EX-3002)
        ^
        |  transformation work order WO-EX-3104, completed 11/04/2026
        |  10 cases of 12-count (120 heads) → 20 cases of 6-count (120 heads)
        |  new traceability lot code assigned here (21 CFR 1.1320(a), 1.1350)
        |
EV-ROM-110126  (received 11/02/2026, 40 cases, 12-count)
        ^
        |  from Example Valley Packing
        |  Advance Shipping Notice ASN-EX-1001, Bill of Lading BOL-EX-1001
        |  Example Valley Packing is the traceability lot code source
        |  (this distributor did not assign or change that code; 21 CFR 1.1320(b))
```

Of the 40 cases of EV-ROM-110126 received on 11/02/2026, this example uses 10 cases in WO-EX-3104, ships 20 cases as-is on 11/04/2026 (the third filtered row above), and leaves 10 cases in example inventory.

## The other two filtered lots, in brief (EXAMPLE)

- **EV-ROM-110126 shipped as-is** (20 cases, 11/04/2026, BOL-EX-3001) back-traces to the same receiving row from Example Valley Packing (ASN-EX-1001, BOL-EX-1001).
- **EMPD-EXH-ROM-110326** (8 of 15 cases shipped 11/05/2026, BOL-EX-3003) was received on 11/03/2026 from Example Hillside Growers (Bill of Lading BOL-EX-2001, Purchase Order PO-EX-4408). The firm assigned this lot code because the shipment was treated as received from a person not subject to subpart S (21 CFR 1.1345(b)). The example basis for that treatment — a supplier written statement that Example Hillside Growers is not a covered farm under 21 CFR 112.4(a), on file as STMT-EXH-110326 — is noted on the Receiving From Exempt tab. The receiving firm keeps that statement. Coverage decisions are the supplier's and the receiving firm's.

## What this example does not do

It does not show a live FDA request, a real firm's records, or a food-safety review. Harvesting, cooling and initial-packing records are not in this distributor's file; those events, if they occurred, would be at Example Valley Packing or Example Hillside Growers. Providing this filtered sheet within 24 hours still depends on the firm actually keeping the workbook current, as the plan describes.
