Regulatory limits and catalogs
SmartLIMS can show, for each tested parameter, the legal limit that applies to the sample, taken from the rulebooks you choose on the request. This page explains the catalogs, regulatory frameworks, limits and how they reach the work order.
Who this is for: Laboratory owners and administrators, and lab staff who choose rulebooks on requests · You need: "Manage regulatory frameworks" to edit frameworks and limits; "Manage product catalog" or "Manage parameter catalog" to edit the catalogs
The idea in short
A maximum residue level (MRL) is the highest amount of a substance, such as a pesticide, that the law allows in a product. SmartLIMS calls these values limits. See the glossary.
Four pieces work together:
| Piece | What it is |
|---|---|
| Product Catalog | A shared list of commodities ("Apples", "Milk"), the same for every company. |
| Parameter Catalog | A shared list of substances, with their CAS numbers (the standard chemical registry number). |
| Regulatory framework | A rulebook: a government regulation or a customer's private rulebook. It holds limits. |
| Limit | One rule in a framework: for this catalog product and this catalog substance, the allowed minimum and/or maximum. |
Your own products and parameters are linked to the catalog entries. When a sample is tested, SmartLIMS takes the sample's product and each parameter, finds the matching catalog entries, and looks up the limit in the frameworks chosen on the request.
The catalogs are filled from the EU Pesticides Database: about 380 EU products and over a thousand substances, plus some common non-pesticide parameters (metals, mycotoxins, veterinary drugs, microbiology, radioactivity, dairy quality).
You find all of this under Settings → Regulatory: Product Catalog, Parameter Catalog and Regulatory frameworks.
How to link your products and parameters to the catalog
Without this link, SmartLIMS can't find a limit, and the work order shows No limit.
- Open Settings → Products, open a product and choose its Catalog product. Save.
- Open Settings → Parameters, open a parameter and choose its Catalog substance. Save.
Parameters you add with Add from EU jurisdiction are linked automatically by CAS number. See Products and parameters.
How to set up a regulatory framework
- Open Settings → Regulatory frameworks and click New framework.
- Fill in Name and choose the Type:
- Government regulation: a law that applies to everyone, for example an EU regulation.
- Private rulebook: a customer's own, usually stricter, limits. Choose the Owning customer.
- Optionally fill in Jurisdiction label, Effective from and Effective to.
- Optionally choose a Fallback framework (see the rules below).
- Save. Then, under Limits, click Add limit for each limit.
For each limit, choose the Product and Parameter from the catalogs and enter a Min value, a Max value or both, each with its operator (<, <=, =, >=, >). Citation says where the limit comes from (for example an article of the regulation). You can also add Analyte definition, Provenance note, Effective from and Effective to.
Frameworks marked as system frameworks are shared and read-only: "System frameworks cannot be edited."
📷 Screenshot: a regulatory framework with its Limits list and the Add limit dialog open
How to import limits from Excel
To add many limits at once, click Import limits from Excel on the Regulatory frameworks page.
- Columns: framework, product, parameter, min value and operator, max value and operator, citation, analyte definition, provenance note, effective from, effective to. Framework, product, parameter and citation are required.
- The framework must be one of your company's own frameworks, not a system one.
- Products and parameters are matched by their catalog name. A parameter that isn't found by name is looked up by CAS number.
- Write dates as year-month-day (2026-01-31). A date that can't be read is left empty.
- Rows that can't be imported are reported one by one with the reason; the other rows are still imported.
See Excel import for how the column mapping works.
How to choose rulebooks on a request
- Open the request and click Edit (or, on the request page, open ⋯ and click Regulatory frameworks…).
- In Regulatory frameworks, choose the rulebooks in Select rulebooks…. They apply to every sample of the request. In the window on the request page, click Save.
- To use different rulebooks for one sample, open that sample and click its rulebooks chip (or Rulebooks for this sample… in its ⋯ menu), pick them and click Save. The chip turns amber and says Own rulebooks. Reset to request default, in the same window, undoes this.
The list offers every government regulation and only the private rulebooks of this request's customer. A sample's rulebooks can be set only after the request is saved. Every change is written to the audit trail. See Lab requests.
How to see and use limits on the work order
- Open the sample's work order. See Work orders.
- Click Regulatory limits on a group of parameters (or Regulatory limits… in the group's ⋯ menu). A side panel shows, for each parameter, the limit from each chosen framework and its status (see below).
- In the same panel you can change the group's Legend, Origin and Report text for this work order, then click Save.
- To check results against the legal limits, click Seed from framework, choose the frameworks in order of priority and click Seed limits.
Seed limits copies the limits into each parameter's reference minimum and maximum. These are the numbers the Pass / Fail badge next to a result is checked against. For each parameter, the first chosen framework that has a limit wins. Until you seed, Pass / Fail uses the parameter's own reference range.
📷 Screenshot: the Regulatory limits side panel on a work order, with Resolved, Inherited and No limit rows
Rules
| Status on the work order | What it means |
|---|---|
| Resolved | The framework has its own limit for this product and parameter. |
| Inherited | The framework has no limit of its own; the limit comes from its fallback framework (shown as "via …"). |
| No limit | Neither the framework nor its fallbacks have a limit, or the product or parameter isn't linked to the catalog. |
| Lab default | No framework gives a limit, so the parameter's own reference range applies. |
| Rule | What it means |
|---|---|
| Fallback | If a framework has no limit for a product and parameter, the limit of its Fallback framework is used. A framework can't fall back on itself, directly or through a chain. |
| Effective dates | SmartLIMS uses the limit that was in force on the date the sample was received. Both dates count as in force; an empty date means no start or no end. Older limits stay visible with Show superseded rows. |
| Private rulebooks | A private rulebook can be used only on its customer's requests. |
| Work orders without a product | Limits can't be looked up: "This work order has no source product, so regulatory limits cannot be resolved." |
| Catalog changes | The catalogs are shared. A change made there is seen by every company. |
Tips
- Use the Needs review only filter in the catalogs to find entries that aren't yet mapped to a framework's own product or substance names.
- When a parameter shows No limit, first check that the product and the parameter are linked to the catalog.
- For a customer with stricter limits, create a Private rulebook with only their limits and set the government regulation as its Fallback framework. All other limits then come from the regulation.
- Seeding overwrites the reference range. Seed again if the rulebooks on the request change.