Substances data formats

Substances

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: Compounds, Compound, Substances, Substance, RawCompounds.

Table 19 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, idCompound, CompoundId, Compound

Yes

Name

AlphaNumeric(100)

The substance name.

Name, CompoundName, SubstanceName, PesticideName

No

Description

AlphaNumeric(200)

Substance description.

Description

No

ARFD

Numeric

The acute reference dose of the critical effect. Note that this is always specified in mg/kg bw/day (exposure).

ARFD

No

ADI

Numeric

The acceptable daily intake. Note that this is always specified in mg/kg bw/person (exposure).

ADI

No

SF

Numeric

The safety factor belonging to the ADI/ARFD.

SF

No

CramerClass

Integer

The Cramer class of the substance.

CramerClass

No

MolecularMass

Numeric

The molecular (molar) mass.

MolecularMass, Mass, MolarMass, MolecularWeight, MolarWeight

No