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: Zipped CSV Excel

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.

Table 23 Table definition for Substances.
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