Unit variability factors data formats

Unit variability factors specify the unit-to-unit variation of substance concentrations on foods. Unit variability factors are described by a single unit variability factors table.

Download empty dataset template: Zipped CSV Excel

Unit variability factors

Unit variability factors are defined for a food, and may possibly also be specified for a specific substance and/or processing type. The unit variability factors are linked to the foods by means of the food code (idFood). Unit variability factors can be specified as unit variability factors (P97.5/mean) or as coefficients of variation of a statistical distribution.

Accepted table names: UnitVariabilityFactors, UnitVariabilityFactor, VariabilityFactor, VariabilityFactors, VariabilityProcCompProd, UnitVariability.

Table 89 Table definition for Unit variability factors.
Name Type Description Aliases Required

idFood

AlphaNumeric (50)

The food code.

idFood, FoodId, Food

Yes

idSubstance

AlphaNumeric (50)

The code of the substance.

idSubstance, SubstanceId, SubstanceCode, Substance

No

idProcessingType

AlphaNumeric (50)

The processing type code.

idProcessingType, ProcessingTypeId, ProcessingType, ProcType

No

Factor

Numeric

The variability factor.

Factor, VarFac, VariabilityFactor

No

UnitsInCompositeSample

Numeric

The number of units in the composite sample.

UnitsInCompositeSample, NoUnitComp

Yes

Coefficient

Numeric

The coefficient of variation.

Coefficient, VariabilityCoefficient, CoefVar, VarCoef

No

IESTI special cases

IESTI special cases for specified combinations of food, substance. The application type (post-harvest or pre-harvest) determines whether Case 1 or Case 3 should be used.

Accepted table names: IestiSpecialCases.

Table 90 Table definition for IESTI special cases.
Name Type Description Aliases Required

idFood

AlphaNumeric (50)

The unique identification code of the food.

idFood, Code, FoodId, FoodCode, Food, Id

Yes

idSubstance

AlphaNumeric (50)

The unique identification code of the substance. This code may be from an existing coding system, such as CAS-codes or Param codes of EFSA, or it may be a used-defined code.

idSubstance, SubstanceId, Substance, Code, Id

Yes

ApplicationType

HarvestApplicationType

Harvest application type (pre-harvest or post-harvest).

ApplicationType, HarvestApplicationType

Yes

Reference

AlphaNumeric (200)

External reference(s) to pre-harvest use.

Reference

No