1 Division of Food Chemistry, National Food Institute, Technical University of Denmark2 National Food Institute, Technical University of Denmark
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.