Food substance conversion factors data formats

Food substance conversion factors are food-specific factors used to convert measured concentrations of a substance in a food into equivalent concentrations of another (active) substance. In pesticide exposure assessment, for example, they are used to convert residue definitions established for enforcement purposes into those used for risk assessment. That is, given a conversion factor (cf) the concentration corresponding to the residue definiton for risk assessment is computed from the measured substance concentration as:

\[\mathtt{res_{ra}} = \mathtt{res} \cdot \mathtt{cf}\]

Food substance conversion factors are specify for triplets of measured substance, active substance, and food. Further information is found in deterministic substance conversion factors data format.

Food-specific conversion factors.

Download empty dataset template: Zipped CSV Excel

Deterministic substance conversion factors

Deterministic substance conversion factors for translating measured substance concentrations to active substance concentrations.

Accepted table names: SingleValueSubstanceConversionFactors, SingleValueConversionFactors, SingleValueConversions, SubstanceConversionsFixed, DeterministicSubstanceConversionFactors, DeterministicConversionFactors, FoodSubstanceConversionFactors.

Table 128 Table definition for Deterministic substance conversion factors.
Name Type Description Aliases Required

idMeasuredSubstance

AlphaNumeric (50)

Substance code of the measured substance.

idMeasuredSubstance, idResidueDefinition, ResidueDefinition, MeasuredSubstance, ParamCodeMeasuredSubstance

Yes

idActiveSubstance

AlphaNumeric (50)

Substance code of the active substance.

idActiveSubstance, idSubstance, ActiveSubstance, Substance, ParamCodeActiveSubstance

Yes

idFood

AlphaNumeric (50)

The unique identification code of the food.

idFood, Code, FoodId, FoodCode, Food

No

ConversionFactor

Numeric

Specifies the conversion factor to translate concentrations of the measured substance to (equivalent) concentrations of the active substance according to e.g. the system used in PRIMo.

Factor, ConversionFactor

Yes

Reference

AlphaNumeric (200)

Reference to the source from which this value is obtained.

Reference, References, Source, Sources

No