Electronic Lab Data Checker (EPA R2)
Perhaps the biggest headache a data manager can face is bad EDDs. Invalid data, missing or incorrect codes, and duplicated data can turn what appears to be a simple delivery of data into an exercise in frustration. Valuable time is spent fixing problems in the data rather than fixing problems in the environment indicated by the data. The Electronic Lab Data Checker (ELDC) makes it possible to avoid these problems easily. With ELDC, laboratories and other data generators can check their own EDDs and correct problems before submitting them to the end EQuIS user. ELDC provides most of the same checking tools used during the EQuIS upload process. Any problems detected can be quickly corrected by the generator, who likely has the data close at hand. ELDC is an important piece of the data reliability puzzle. EQuIS users do NOT need to buy ELDC, they only need to insist their data providers purchase and use ELCD as a condition of data submission.
ELDC verifies typical difficulties with EDDs:
- Correct file format
- No duplicated records
- Required fields populated
- Correct data types (numeric dates, etc.)
- Adherence to valid values
- Orphaned samples or results
ELDC provides immediate feedback regarding EDDs ``pass or fail`` helping to ensure success in data transfer from providers to EQuIS users.
Electronic Lab Data Checker (ELDC)
The Electronic Lab Data Checker (ELDC) is a software tool created to assist laboratories and data providers in the preparation of electronic data deliverables (EDDs). Staff expertise, varying EDD formats, and the type and sophistication of LIMS systems within the laboratory community are all factors that can work against accurate and seamless delivery of EDDs. The ELDC works to level the playing field for data consumers.
Prior to importing data into EQuIS, errors in the EDD must be corrected. These errors typically include problems with unrecognized codes, improper field types, incorrect locations of data within the files and mismatched files. This process frequently involves requiring the data generator to correct and resubmit the data files, typically weeks after production, thus delaying final analysis by the project managers.
Users of the EQuIS system should encourage their data providers to use ELDC to review all deliverables prior to submission. The software produces a log file indicating all errors detected in an EDD file that the laboratory can then use to correct errors. EQuIS users can require this log file as part of the deliverable to prove screening of EDDs. By putting the feedback for error correction in the hands of the data generator, EDD quality typically increases quickly and dramatically.
Electronic data deliverables reviewed by ELDC are checked for the following common data problems:
- Field widths and data types (time, date, integer, text, etc.)
- Duplicated data
- Number and location of fields in the file
- Required fields are populated
- Fields that make up a key are both populated and the key is unique
- Reference values, such as CAS numbers, EPA method numbers, etc.
- Deliverables are cross checked to ensure that samples, tests, results, or batches represented in one file are present in the related file
EQuIS Chemistry
EQuIS Chemistry is the best data management system in the world for managing environmental chemistry. EQuIS Chemistry offers all the fields, tables, and relationships necessary to warehouse and qualify analytical chemistry for site assessments, risk assessments, site characterizations, and remediation projects.
EQuIS Chemistry supports the highest levels of QA/QC in environmental sampling, but can also be easily used for the most basic normal chemical results. Ensuring high data quality, EQuIS powerfully links to the world`s most popular visualization and analysis software packages. Additionally, EQuIS links to Microsoft Office so your data can be delivered anywhere. Custom formats for graphing and reporting can easily be added to the system. Visual Basic code will even be provided with appropriate licensing for complete customization flexibility. An advanced CrossTab Report Writer is also available for the unique reporting requirements of environmental professionals. Relieve your expensive professionals from the production of routine graphs and reports!
EQuIS--EarthSoft`s Environmental Quality Information System--is used by regulators, consultants, and property owners around the world to manage environmental data. EQuIS Geology is a comprehensive database for manipulating lithology, downhole point data, geologic samples and much more. EQuIS Chemistry supports the highest levels of QA/QC in environmental sampling, but can also be easily used for the most basic normal chemical results. Ensuring high data quality, EQuIS powerfully links to the world`s most popular visualization and analysis software packages.
Encapsulated GIS
The EQuIS ArcView GIS Interface facilitates data management and analysis in a GIS environment with unparalleled and intuitive ease of use. In addition to many options for viewing chemical data themes, the latest version includes single-click access to true 3D visualization. From ArcView, data may be queried for both Geology and Chemistry, and single click exports are provided for many common packages.
Advanced Chemistry
EQuIS accommodates advanced chemistry sufficient to manage Superfund and ERPIMS projects. The EQuIS Data Verification Module (DVM) is the world`s first commercial software to support analytical data validation. A key component in many implementations of electronic data programs, EQuIS has been tested by hundreds of consultants, labs and validation groups.
Electronic Lab Data Checker
All major labs in the US and the UK have the Electronic Lab Data Checker (ELDC). This tool allows for the checking of various EDD (Electronic Data Deliverable) formats before attempting to load the data. Mirrored by the Import Module within EQuIS, clean transactions between lab and data management system are guaranteed. Tremendous efficiency gains have been obtained with using these tools.
Fast, Flexible Reports, Graphs, and Advanced Cross-Tabs
EQuIS links to Microsoft Office so your data can be delivered anywhere. Custom formats for graphing and reporting can easily be added to the system. Visual Basic code will even be provided with appropriate licensing for complete customization flexibility. An advanced CrossTab Report Writer is also available for the unique reporting requirements of environmental professionals. Relieve your expensive professionals from the production of routine graphics and reports! You no longer have to be a Power User to quickly view your data!
