Substance approvals data formats

Substance approvals specify which substances are approved within the definition under regulation (EC) No 1107/2009. This information may, for instance, be used to restrict water imputation to approved substances only.

Download empty dataset template: Zipped CSV Excel

Substance approvals

Substance approval records are tuples consisting of an identifier of the substance and a boolean value specifying the approval status of the substance. Substances that are not included in the table are assumed to be NOT approved.

Accepted table names: SubstanceApprovals, ApprovedSubstances.

Table 148 Table definition for Substance approvals.
Name Type Description Aliases Required

idSubstance

AlphaNumeric (50)

The substance code.

idSubstance, Substance, SubstanceId

Yes

IsApproved

Boolean

Specifies whether the substance is approved or not. Substances not included in the table are assumed to be NOT approved.

IsApproved, Approved

Yes