Data providers package for reporting Chemical Contaminants (official data reporting phase) SSD1
收藏资源简介:
In the framework of Articles 23 and 33 of Regulation (EC) No 178/2002 EFSA has received from the European Commission a mandate (M-2010-0374) to collect all available data on the occurrence of chemical contaminants in food and feed. These data are used in EFSA’s scientific opinions and reports on contaminants in food and feed. This data providers package provides the data collection configuration and supporting materials for reporting <strong>Chemical Contaminants in SSD1</strong>. These are to be used for the official data reporting phase. The package includes: The Standard Sample Description Version 2 XSD schema definition for CONTAMINANTS reporting. The general and CONTAMINANTS SSD1 specific business rules applied for the automatic validation of the submitted datasets. Excel Mapping tool to convert excel files after mapping into XML document. Please follow the instructions below for the correct use of the mapping tool to avoid compromising its functionalities: Download and save the MS Excel® Standard Sample Description file to your computer (do not open the file before saving and do not change the file name) Download and save the file MS Excel® Simplified Reporting Format (do not open the file before saving) Keep both Excel files in the same folder Open both Excel files and enable the macros Keep both files open in the same Excel instance when filling in the data Guidance on how to run the validation report after submitting data to the DCF.
在(EC)第178/2002号条例第23条与第33条的框架下,欧洲食品安全局(EFSA)收到欧盟委员会下达的授权任务(M-2010-0374),要求收集所有可获取的食品及饲料中化学污染物检出相关数据。 上述数据将用于EFSA发布的关于食品与饲料中污染物的科学意见及报告。 本数据提供者套件提供了用于报告<strong>SSD1中的化学污染物</strong>的数据收集配置与支撑材料,适用于官方数据报告阶段。 本套件包含以下内容:用于污染物报告的标准样本描述第2版XSD架构定义;用于自动校验提交数据集的通用规则及SSD1专用污染物业务规则;可将完成映射的Excel文件转换为XML文档的Excel映射工具。 为避免损害该工具的功能,请遵循以下正确使用指南: 下载并将MS Excel®标准样本描述文件保存至本地计算机(保存前请勿打开该文件,且不得修改文件名) 下载并保存MS Excel®简化报告格式文件(保存前请勿打开该文件) 将两个Excel文件置于同一文件夹中 打开两个Excel文件并启用宏 填写数据时,请在同一个Excel实例中保持两个文件处于打开状态 另有关于向DCF提交数据后如何运行校验报告的指南。



