Concentration limits data formats¶
The concentration limits table describes limit values (e.g., MRLs) for specific food/substance combinations. This data may be used, for instance, for the food/substance combinations for which no concentration data is available. The food codes (idFood) and substance codes (idSubstance) should match the codes of the foods and substances table respectively.
Concentration limits¶
Concentration limits are concentration limit values for specific food and substance combinations originating from regulations (e.g., MRLs). This data may be used, for instance, for the food/substance combinations for which no concentration data is available.
Concentration limits¶
The food codes (idFood) and substance codes (idSubstance) should match the codes of the foods and substances table respectively.
Table aliases: ResidueLimits, ResidueLimit, MaximumResidueLimits, MaximumResidueLimit, MRLs, MRL.
| Name | Type | Description | Aliases | Required |
|---|---|---|---|---|
idFood |
AlphaNumeric(50) |
Code of the food of this residue limit definition. |
idFood, FoodId, Food |
Yes |
idSubstance |
AlphaNumeric(50) |
Code of the substance of this residue limit definition. |
idSubstance, SubstanceId, SubstanceCode, Substance |
Yes |
Value |
Numeric |
Residue limit value. |
Value, Limit, MaximumResidueLimit, MaximumResidueLimits, MRL |
Yes |
StartDate |
DateTime |
Start date of the period during which the limit applies. |
StartDate |
No |
EndDate |
DateTime |
End date of the period during which the limit applies. |
EndDate |
No |
ConcentrationUnit |
ConcentrationUnits | The unit of the limit value (default mg/kg). |
ConcentrationUnit, Unit |
No |
ValueType |
ConcentrationLimitValueType |
Value type of the concentration value. |
ValueType, ConcentrationLimitValueType, ConcentrationSingleValueType |
No |
Reference |
AlphaNumeric(200) |
Reference to the source from which this concentration single value is obtained. |
Reference, References, Source, Sources |
No |