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.
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.
Table aliases: ProcessingFactors, ProcessingFactor, Processing.
| 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 |