Substance conversions data formats
Two types of substance conversions are implemented, with two subtypes for the first type:
1a) The measured substance is one or more of a set of possible substances (e.g. isomers or metabolites), and the toxicity of all substances in this set is assumed to be the same and is expressed in one active substance. Example: The measured substance Parathion-methyl(RD) is either Parathion-methyl or paraoxon-methyl, but both are expressed as the active substance Parathion-methyl.
1b) The measured substance is one or more of a set of possible substances (e.g. isomers or metabolites), and the toxicity of all substances in this set is assumed to relate with equal probability to one of a subset of active substances. Example: The measured substance Dithiocarbamates includes the active substances maneb, mancozeb, metiram, propineb, thiram and ziram, one of which will be assumed to be the active substance present with equal probability.
2) If \(\mathit{n}\) active substances all metabolise to the same active substance (the metabolite), it is assumed that all \(\mathit{n}+1\) substances have equal probability of being the source of the measured concentration. The measured substance then is either one active substance (the metabolite) or a mixture of two active substances, one being the metabolite and the other one of the possible parent substances. Example: the measured substance Carbofuran(RD) is either the active substance Carbufuran or a mixture of Carbofuran and one of the possible active parent substances Benfuracarb or Carbosulfan.
Note, it is not allowed to have conversion factors equal to 0.
Substance conversions are described by a single substance conversions table.
Download empty dataset template:
Substance conversion rules
The records of the substance translations definitions table specify which active substances (idActiveSubstance) link to a measured substance (idMeasuredSubstance). Each record contains a conversion factor that specifies how a concentration of the measured substance translates to a concentration of the active substance, a flag that states whether the residue definition should be assumed to translate exclusively to one of its active substances, and a proportion. The proportion specifies the proportion of the samples that should translate to this specific active substance in case the translation is exclusive, otherwise it specifies the proportion of the concentration that is assumed to be attributed to the active substance.
Accepted table names: ResidueDefinitions, ResidueDefinition.
| Name | Type | Description | Aliases | Required |
|---|---|---|---|---|
idMeasuredSubstance |
AlphaNumeric (50) |
Substance code of the measured substance. |
idResidueDefinition, ResidueDefinition, MeasuredSubstance |
Yes |
idActiveSubstance |
AlphaNumeric (50) |
Substance code of the active substance. |
idActiveSubstance, idSubstance, ActiveSubstance, Substance |
Yes |
ConversionFactor |
Numeric |
Specifies the (molecular weight) conversion factor to translate the concentration of the residue definition to a concentration of the active substance |
ConversionFactor |
Yes |
IsExclusive |
Boolean |
Specifies whether a measurement of the residue substance should be translated exclusively to this active substance, or if the residue definition represents/breaks down to a mixture of active substances. |
IsExclusive |
Yes |
Proportion |
Numeric |
Only applicable for non-exclusive conversions. The proportion of the concentration that is assumed to be attributed to the active substance. |
Proportion |
No |