Processing factors data formats

Processing factors connect two food codes, one for the processed food and one for the unprocessed food. There are two schems to make this connection:

  1. specify the two food codes and the processing type, or

  2. use food facets, i.e. specify only the code of the unprocessed food and the processing type (facet), the code of the processed food is defined by the other two.

Processing factors

Processing factors are defined for triplets of processing type, food, and substance. The processing types are defined in the processing types table and the processing factors are defined in the processing factors table.

Processing factors

Processing factor records should be linked to processing types using the processing type code (idProcessingType) and for the foods and substances. The codes of the processing factor records should match the codes of the foods, substances, and processing type definitions.

Table aliases: ProcessingFactors, ProcessingFactor, Processing, RawProcessingFactors.

Table 67 Table definition for ProcessingFactors.
Name Type Description Aliases Required

idProcessingType

AlphaNumeric(50)

The code of the processing type.

idProcessingType, ProcessingTypeId, ProcessingType, ProcType

Yes

idSubstance

AlphaNumeric(50)

The code of the substance.

idSubstance, SubstanceId, SubstanceCode, Substance, idCompound, CompoundId, CompoundCode, Compound

No

idFoodProcessed

AlphaNumeric(50)

The code of the processed food (may contain a wildcard e.g. ‘FP*’. The wildcard matches all characters preceded by the startcode ‘FP’).

idFoodProcessed, FoodProcessedId, FoodProcessed

Yes

idFoodUnprocessed

AlphaNumeric(50)

The code of the unprocessed food (may contain a wildcard e.g. ‘FP*’).

idFoodUnprocessed, FoodUnprocessedId, idFood, FoodId, FoodUnprocessed

Yes

Nominal

Numeric

The nominal value (best estimate of 50th percentile) of processing factor (defines median processing factor).

Nominal, ProcNom

No

Upper

Numeric

The upper value (estimate of 95th percentile or “worst case” estimate) of processing factor due to variability.

Upper, ProcUpp

No

NominalUncertaintyUpper

Numeric

The upper 95th percentile of nominal value (Nominal) due to uncertainty. A standard deviation for uncertainty of the nominal value (Nominal) is derived using the nominal value (Nominal) and upper 95th percentile (NominalUncertaintyUpper).

NominalUncertaintyUpper, ProcNomUncUpp

No

UpperUncertaintyUpper

Numeric

The upper 95th percentile of upper value (Upper) due to uncertainty. From the nominal value (Nominal), upper value (Upper) and the specified uncertainties of these values (NominalUncertaintyUpper and UpperUncertaintyUpper, respectively) the degrees of freedom of a chi-square distribution describing the uncertainty of the standard deviation for variability is derived.

UpperUncertaintyUpper, ProcUppUncUpp

No

Food facet processing factors

This table can be used to define processing factors for (FoodEx2) food/food-facet combinations.

Table aliases: FoodFacetProcessingFactors, FoodFacetProcessingFactor, FacetProcessingFactors, FacetProcessingFactor, FacetProcessing, RawFoodFacetProcessingFactors.

Table 68 Table definition for FoodFacetProcessingFactors.
Name Type Description Aliases Required

idProcessingType

AlphaNumeric(50)

The code of the processing type.

idProcessingType, ProcessingTypeId, ProcessingType, ProcType, facet, idFacet, codeFacet

Yes

idFood

AlphaNumeric(50)

The food to which this facet should be linked.

idFood, FoodId, Food

Yes

idSubstance

AlphaNumeric(50)

The code of the substance.

idSubstance, SubstanceId, SubstanceCode, Substance, idCompound, CompoundId, CompoundCode, Compound

No

Nominal

Numeric

The nominal value (best estimate of 50th percentile) of processing factor (defines median processing factor).

Nominal, ProcNom

No

Upper

Numeric

The upper value (estimate of 95th percentile or “worst case” estimate) of processing factor due to variability.

Upper, ProcUpp

No

NominalUncertaintyUpper

Numeric

The upper 95th percentile of nominal value (Nominal) due to uncertainty. A standard deviation for uncertainty of the nominal value (Nominal) is derived using the nominal value (Nominal) and upper 95th percentile (NominalUncertaintyUpper).

NominalUncertaintyUpper, ProcNomUncUpp

No

UpperUncertaintyUpper

Numeric

The upper 95th percentile of upper value (Upper) due to uncertainty. From the nominal value (Nominal), upper value (Upper) and the specified uncertainties of these values (NominalUncertaintyUpper and UpperUncertaintyUpper, respectively) the degrees of freedom of a chi-square distribution describing the uncertainty of the standard deviation for variability is derived.

UpperUncertaintyUpper, ProcUppUncUpp

No