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.

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.

Table aliases: Substances, Substance.

Table 22 Table definition for Compounds.
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

ConcentrationUnits

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