Deterministic substance conversion factors data formats

Deterministic substance conversion factors. Foods are optional.

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.

Table 65 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

Yes

idActiveSubstance

AlphaNumeric (50)

Substance code of the active substance.

idActiveSubstance, idSubstance, ActiveSubstance, Substance

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