150 likes | 160 Views
Learn to create, store, categorize, and distribute submissions to ECB in IUCLID. Understand stakeholders' roles and manage chemical information effectively. Explore submission management versus chemical information management.
E N D
IUCLID International Uniform ChemicaLInformation Database Stefan J. Scheer Rémi Allanou IUCLID Basics I
“active” (companies) “passive” (users) IUCLID DB Create submission store & structure & categorise Submission to ECB Query, display, print, import, export Insert submissions, create & distribute CDs, etc. “administration” (ECB) The Stakeholders and Their Roles
What Is a Submission? “header”: company BASF AG, substance: 50-00-0, date: 30-sep-2002 “footer”: info on chemical, …… … company IUCLID data description ECB IUCLID data entry IUCLID database
Submission Management … versus ... Chemical Information Management
Submission Administration + Producer Related Part “Who sent what and when” “which chemical information is pointed at” Substance Related Part “Which melting point is reported” “which type of LD50 tests have been undertaken” … … ... … versus ...
Data Set Administration + Chapter 1 General Information … versus ... Chapters 2 - 10 Physico-chemical data (2), Environmental fate and pathways (3), Ecotoxicity (4), Toxicity (5), Analytical methods for detection and identifications (6), Effectiveness against target organisms and intended uses (7), Measures necessary to protect man, animals and the environment (8), Literature (9), Summary and evaluation (10)
Hierarchical Decomposition Chapters Subchapters 2.1 Melting Point 2.2 Boiling Point 2.3 Density … 2.13 Viscosity 2.14 Additional Remarks Chapter 2: Physico-chemical Data
Hierarchical Decomposition (cont.) Subchapter Fields Value Decomposition Sublimation Method Year GLP Test Substance Chapter 2.1: Melting Point
several data chapters several data chapters several data chapters Data set to subst ID n Company: c1 Date: d1 Substance ID: n further inform. Data set to subst. ID n Company: c2 Date: d2 Data set to subst. ID n Company: c3 Date: d3
IUCLID: General Overview menus Comment line Header information Icons on menu bar Switch to other sub-chapters Record indicator Entry fields Entry form for another basic chapter Error and warning messages
Query Mechanism: Special Characters _ means to match a single character, e.g. ‘a’, ‘6’, etc. % means to match 0 or more characters, e.g. “UROPEAN COMMISSION”, “106-24” You can mix and multiply use those two characters, e.g. “_0%-_” will reveal: 100-00-5, 10420-33-4, 10543-57-4. 106-24-1, 106-88-7, 107-01-7 and even 50-00-0.
Exercises: BS2.x … DS1.x … IN1.x … DS2.x … IN2.x … AD.x ... About This Course … ... Basics 2: Substances Principles of data sets 1: Data Sets: read, create; records; views Principles of data sets 2: Referencing data sets; template data sets; flags & reliabilities; freetexts IUCLID Interaction 1: import, export of data sets Advanced IUCLID: Merging; administration; user-defined query IUCLID Interaction 2: printing, saving,querying