Focal processing factors data formats
Focal processing factors replace the list of processing factors for (priority) pesticide residues in food, see also RIVM . This list is used by the food industry and Dutch and foreign institutes for the calculation of dietary intake of certain pesticide residues. 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. Further information is found in processing factors and processing factors data format.
Focal processing factors are defined for triplets of processing type, food, and substance. The processing types are defined in the processing types table and the focal processing factors are defined in the focal processing factors table. The format is identical to the processing factors data format.
Download empty dataset template:
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.
| 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 |