Compliance Database

Intertek Ageus Solutions' Treefrog compliance database for RoHS, WEEE, Japan Green, IPC-1752 and other emerging electronics standards

Treefrog is an object oriented database specifically designed to meet the data gathering and product roll up requirements of RoHS, Japan Green, and IPC-1752. Treefrog uses SQL, HTML, and XML technology to meet the complexities of the material declaration demands on electronics manufacturers.

Treefrog

Treefrog was developed to act as both an operational and data storage tool. Treefrog has an effective range of data storage, data assessment, and data presentation features plus flat file, graphical, and XML output capabilities.

Component Data Storage

The core data storage component of Treefrog is an object oriented SQL database.

Highlights of Treefrog component data storage:

RoHS compliance, Joint Industry Guide, and IPC-1752 information for each component or material
Process and interconnect information for each component
Substitute components for non-compliant / EOL components
Date of availability for all substitute components
Hierarchical data storage for sub-assemblies and mechanical drawings
Linking of components and materials to hard reference materials and certificates of compliance

Intertek Ageus Solutions has a wide range of experience with non-standard or custom data requirements including custom data fields, formats, specifications, and hierarchy. One of Treefrog's features is the ability to handle each of these custom requirements.

Data Viewing and Web Interface

Bill of Material collection and assessment is only a step in product environmental compliance. Intertek Ageus Solutions' Treefrog database provides material declaration outputs to a number of global and industry standards, clean audit trails to each component, and a compliant bill of materials for procurement purposes.

Highlights of Treefrog's HTML portal:

Secure HTML interface for
- Graphical viewing of component data
- Download of material declaration data
Executive summary of product RoHS and related compliance
Identification and highlighting of non-compliant or 'at-risk' components
Compliance graphics downloadable for easy integration into presentations and reports

During a BOM assessment, the day by day progress can be viewed through the secure html interface. An example can be seen at http://www.ageussolutions.com/demo

Mechanical Parts and Components

PCB boards are not the only element in most modern electronic products. Electronics manufacturers need compliance information and assessment for a diverse range of items including custom mechanical drawings.

Treefrog is designed to accommodate the range of items found on mechanical drawings including components, materials, finishes, and additives. For each of these items, Treefrog lists the same core information as for electronic components and provides traceability to the respective mechanical drawings.

Treefrog's features for mechanical drawings include:

Transfer of mechanical drawings to assembly / material / component hierarchy
Creation of Master Materials List for BOM assessment purposes
Storage and cataloging of materials, finishes, and additives
Compliance assessment of materials, finishes, and additives
Traceability for compliant materials back to the individual mechanical drawings

Material Declaration

Intertek Ageus Solutions' BOM assessment services are backed by a leading edge database. The Intertek Ageus Solutions database, Treefrog, is an object oriented data storage and viewing system designed to meet the requirements of RoHS, Japan Green, and IPC-1752.

Highlights of Treefrog's material declaration features:

Compliant Bill of Materials for component procurement
For each component, traceability to
- RoHS compliance statement
- ppm chemical data
- Hard reference data from component supplier
- Contact information of supplier representative
Roll up summaries of product material content and locations
- Including product roll up for JGPSSI requirements
XML output to IPC-1752 standard
Flat file output for upload in standard databases

Compliance Evaluation

RoHS is only one of the requirements facing electronics manufacturers. Many components need to not only meet the requirements of RoHS, but also the material restrictions of other jurisdictions and companies.

Treefrog can assess and identify the compliance of a component to a full range of specifications including RoHS, material ppm values, date of availability, interconnect materials, and any other data field specification.

Typical assessment criteria used by Treefrog:

Material or chemical ppm value of homogenous materials
Date of availability of component or materials
Interconnect metallurgy
Footprint or function compatibility

Intertek Ageus Solutions has vast experience with RoHS, JGPSSI, and related global material declaration requirements. Treefrog was designed and is used to meet these requirements.

Click here to request more information