Substances data formats
Substances are primary entities of the data model. Substance intakes are of main interest in exposure assessments and the effect of intake on human health is of interest in risk assessments. In the substances table, the substance entities and other relevant substance properties that are relevant for the assessment at hand should be defined.
Download empty dataset template:
Substances
Each substance should have a unique identification code (idSubstance), and optionally, a name and description may be used for a more detailed description of the entity. Additional properties, such as the molecular mass (MolecularMass) and Cramer class (CramerClass) may also be specified. Example: Captan (idSubstance RF-0061-001-PPP) has MolecularMass 300.5922 and CramerClass 3.
Accepted table names: Substances, Substance.
| Name | Type | Description | Aliases | Required |
|---|---|---|---|---|
idSubstance |
AlphaNumeric (50) |
The unique identification code of the substance. This code may be from an existing coding system, such as CAS-codes or Param codes of EFSA, or it may be a used-defined code. |
idSubstance, SubstanceId, Substance, Code, Id |
Yes |
Name |
AlphaNumeric (100) |
The substance name. |
Name, SubstanceName, PesticideName |
No |
Description |
AlphaNumeric (200) |
Substance description. |
Description |
No |
ConcentrationUnit |
ConcentrationUnit | Contains a coding to determine the default unit in which concentrations for this substance are expressed. |
ConcentrationUnit, Unit, ReferenceConcentrationUnit |
No |
CramerClass |
Integer |
The Cramer class of the substance. |
CramerClass |
No |
MolecularMass |
Numeric |
The molecular (molar) mass. |
MolecularMass, Mass, MolarMass, MolecularWeight, MolarWeight |
No |
IsLipidSoluble |
Boolean |
States whether the substance is soluble in lipid (0 = no, 1 = yes). |
IsLipidSoluble, IsSoluble |
No |