Processing factors data formats

Processing factors connect to a food id and a processing type or (food) facet (FoodEx 2). The specification of a substance (id) is optional. Specify the unprocessed food code and the processing type or facet. The combination of idFood-idProcessingType represents a processed food.

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.

Download empty dataset template: Zipped CSV Excel

Processing factors

Processing factor records should be linked to processing types (or facets) using the processing type (or facet) 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 (of facets) definitions.

Accepted table names: ProcessingFactors, ProcessingFactor, Processing.

Table 91 Table definition for Processing factors.
Name Type Description Aliases Required

idProcessingType

AlphaNumeric (50)

The code of the processing type.

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

Yes

idSubstance

AlphaNumeric (50)

The code of the substance.

idSubstance, SubstanceId, SubstanceCode, Substance

No

idFoodUnprocessed

AlphaNumeric (50)

The code of the unprocessed food.

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

Yes

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