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:
specify the two food codes and the processing type, or
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.
| 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.
| 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 |