EFSA has prepared a standard data model for the transmission of chemical occurrence data
and pesticide residues. This model is referred to as the “Standard Model” (SM) or the
“Standard Sample Description” (SSD). The aim of the present project was to collect and
transform data from the Danish national data repositories for chemical contaminants and
pesticides and in coding these according to the SM and to facilitate the continued use of the
SM in answering future EFSA data calls in these areas. Restructuring was performed using
existing equipment and programming tools. SAS procedures and Excel mapping tables were
developed to handle the data transformation. The main challenges were mapping existing data
to the SM, synthesising necessary information missing in the national repository, and dealing
with the complexity of pesticide substance reporting.
Question No EFSA-Q-2009-00838.