Painting & Coating Industry (PCI) logo Powder coating summit logo
  • Sign In
  • Create Account
  • Sign Out
  • My Account
  • NEWS
  • PRODUCTS
  • MATERIALS
  • TECHNOLOGIES
  • FINISHING
  • RESOURCES
  • EVENTS
  • DIRECTORIES
  • EMAGAZINE
  • CONTACT
cart
facebook twitter linkedin youtube
  • NEWS
  • Latest News
  • Market Trends & Reports
  • Price Alerts
  • Subscribe to eNewsletters
  • Global Top 10/ PCI 25
  • Weekly Featured Article
  • COATLE Word Game
  • PRODUCTS
  • Product News
  • Must See Products and Services
  • MATERIALS
  • Additives
  • Resins/Polymers
  • Pigments
  • Equipment
  • Distributors
  • TECHNOLOGIES
  • Adhesives
  • Architectural Coatings
  • Industrial Coatings
  • Nanotechnology
  • Powder Coatings
  • Solventborne
  • Special Purpose Coatings
  • Sustainability
  • UV Coatings
  • Waterborne
  • Waterborne
  • FINISHING
  • Finishing News
  • Finishing Technologies
  • Finishing Equipment
  • RESOURCES
  • Columns
  • Blogs
  • Coatings Supplier Handbook
  • Podcasts and Videos
  • PCI Store
  • eBooks
  • Sponsor Insights
  • White Papers
  • COATLE Word Game
  • Columns
  • Ask Joe Powder
  • Did you know?
  • Distribution Dive
  • Focus on Canada
  • Formulating With Mike
  • Innovation Insights
  • Moody's Coatings Conundrums
  • Powder Coating Perspectives
  • Target the Market
  • TiO2 Insider
  • Blogs
  • Editor's Viewpoint
  • Industry Insights
  • Podcasts and Videos
  • COAT-IT! Podcast
  • Videos/PCI TV
  • EVENTS
  • Coatings Trends & Technologies Summit
  • Paint and Coatings Academy
  • Webinars
  • Calendar of Events
  • Lifetime Achievement Award
  • DIRECTORIES
  • Buyer's Guide
  • Equipment Directory
  • Materials Directory
  • EMAGAZINE
  • Current Issue
  • eMagazine Archive
  • China Issue Archive
  • Editorial Advisory Board
  • CONTACT
  • Contact Us
  • Advertise
  • Subscribe to eMagazine
  • Subscribe to eNewsletters
Painting & Coating Industry (PCI) logo Powder coating summit logo
search
cart
facebook twitter linkedin youtube
  • Sign In
  • Create Account
  • Sign Out
  • My Account
Painting & Coating Industry (PCI) logo Powder coating summit logo
  • NEWS
    • Latest News
    • Market Trends & Reports
    • Price Alerts
    • Subscribe to eNewsletters
    • Global Top 10/ PCI 25
    • Weekly Featured Article
    • COATLE Word Game
  • PRODUCTS
    • Product News
    • Must See Products and Services
  • MATERIALS
    • Additives
    • Resins/Polymers
    • Pigments
    • Equipment
    • Distributors
  • TECHNOLOGIES
    • Adhesives
    • Architectural Coatings
    • Industrial Coatings
    • Nanotechnology
    • Powder Coatings
    • Solventborne
    • Special Purpose Coatings
    • Sustainability
    • UV Coatings
    • Waterborne
    • FINISHING
      • Finishing News
      • Finishing Technologies
      • Finishing Equipment
    • RESOURCES
      • Columns
        • Ask Joe Powder
        • Did you know?
        • Distribution Dive
        • Focus on Canada
        • Formulating With Mike
        • Innovation Insights
        • Moody's Coatings Conundrums
        • Powder Coating Perspectives
        • Target the Market
        • TiO2 Insider
      • Blogs
        • Editor's Viewpoint
        • Industry Insights
      • Coatings Supplier Handbook
      • Podcasts and Videos
        • COAT-IT! Podcast
        • Videos/PCI TV
      • PCI Store
      • eBooks
      • Sponsor Insights
      • White Papers
      • COATLE Word Game
    • EVENTS
      • Coatings Trends & Technologies Summit
      • Paint and Coatings Academy
      • Webinars
      • Calendar of Events
      • Lifetime Achievement Award
    • DIRECTORIES
      • Buyer's Guide
      • Equipment Directory
      • Materials Directory
    • EMAGAZINE
      • Current Issue
      • eMagazine Archive
      • China Issue Archive
      • Editorial Advisory Board
    • CONTACT
      • Contact Us
      • Advertise
      • Subscribe to eMagazine
      • Subscribe to eNewsletters

    A Visionary Approach to Electronic Product Information Management

    November 2, 2001
    Product information management in the aerospace industry has always been more comprehensive than other industries. Due to structural integrity requirements of various aircraft designs, aerospace sealant and coating systems are subjected to an array of qualification and quality control testing under specifications of various aircraft manufacturers. Moreover, these systems must also comply with regulatory requirements of various domestic and international regulatory agencies. The resulting product information matrices of these systems can be extremely complex and the scope of document management, depending on the complex nature of the products, frequently may not be handled solely with commercially available solutions. This situation is especially true with PRC-DeSoto's sealant and coating product lines that are, typically, qualified to multiple, international specifications. There are no ready-made document management solutions available in today's market that can accommodate all our documentation needs effectively.

    Approach to Electronic Product Information Management

    Like most other chemical manufacturing companies, PRC-DeSoto manages its formulation and product structure information using a commercially available manufacturing data management system. Although we were successful in modifying and adapting the software to manage our core manufacturing and formulation work flows, we were unable to integrate all of the supporting product information documents into the system due to the inherent design limitations of the software. While these supporting documents do not affect production processes directly, they provide essential references on finished product configurations and testing information that are conformed to various specifications, and criteria for environmental, health and safety, and transportation regulatory compliance. Without centralized document management solutions for these documents, we, instead, resorted to manual distributions and archiving of hard-copied documents. These tasks were extremely time-consuming and labor-intensive, and the slow flow of documents frequently caused delays in processing and shipment of finished products.

    To provide an overall solution to the integrated documentation system, we realized that we should consider developing some of our own applications based on PRC-DeSoto business objectives, instead of relying solely on finding solutions from commercially available technologies. We started our implementation by examining our business needs and visualizing what types of solutions would benefit our documentation flow. Since a large number of new and revised documents were created daily by the centralized Product Information Group and distributed to manufacturing sites and distribution sites all over the world, it was most important for us to implement a true paperless document management system to eliminate hard-copy distributions. It was also important for us to integrate into this system value-added applications that would track documentation flows of process-based documents between various departments of various sites. To keep all users updated on each document's status, the system must also be equipped with real-time or periodic status reports for various product information documents. Based on the above requirements, we contracted with Feasible Management Consulting Inc., the solution provider that has been helping PRC-DeSoto in building its data warehouse since 1998, to develop customized solutions for our documentation system.

    Information-Based Solutions

    For management of information-based documents that provide product references and regulatory information, the data warehousing solution from IMR Alchemy was selected as the primary tool to create an intranet website that is accessible to all internal users. The customized product information site allows easy access to all product information documents by way of Internet browsers. Its users may generate document-specific status reports with a time interval option that provides updated information on document processing status during a user-specified time period. It also features a Document Request Screen that enables users to request specific documents electronically. This customized site has been in use since 1999 and the scope of published information has been expanded many times since. PRC-DeSoto users from all locations worldwide can retrieve product information documents from this site as needed daily. As a result, hard-copy distribution by the Product Information Group ceased completely earlier this year.

    Process-Based Solutions

    Process-based documents, which are used for either multi-functional process flow capacities or technical information computation capacities, were developed by Feasible Management Consulting Inc. as Web-based applications using multiple Web-based solutions. One of the true paperless, multi-functional applications that links process flow of various functional groups in many PRC-DeSoto locations by way of intranet Web is the Color Match Screen (CMS) application for aerospace coating color products. The application consists of a series of electronic input screens for all of the functional groups involved in the workflow process of coating color product production. Typically, the functional groups in the workflow loop are Sales, Marketing, Color Engineering, Product Information and Costing. When a color product order is placed into the CMS, and as the work sequence flows through the loop, the staff of each group documents his group's information into the corresponding group's input screen. The information is flagged upon completion and the date and time of completion for each screen is registered in a real-time report. The CMS application allows precise tracking of color product working processes. The transparent nature of this application has improved the speed of the work cycle significantly. It also enables functional groups to follow the work sequence closely and perform their tasks without unnecessary delay.

    Generic MSDS Application

    The most innovative computation solution we have developed thus far is the Web-based generic MSDS application for aerospace coating color products. The concept of generic MSDS is not new and has been pondered amongst coating manufacturers; however, realistically, it is not possible to derive one generic MSDS document for all coating product lines produced by a multi-product manufacturer. Since PRC-DeSoto has definite guidelines on formulating color products and the colorants used for color products are standardized, it is possible for us to derive a set of generic MSDS documents for PRC-DeSoto color products.

    Using data warehousing and data mining solutions provided by Feasible Management Consulting Inc., we were able to perform relational data analysis on a range of finished color formulae, colorant formulae, and their corresponding MSDSs. Based on the results of our analysis, we separated the data fields of a standard, sixteen parts MSDS document into user-input fields, computational fields, and text fields. To facilitate the database with raw data, the standardized colorants and their raw materials information were compiled and populated into the application.

    For computational fields, we programmed equations and computational rules for hazardous and non-hazardous ingredients based on regulatory requirements. When a color formula is input into the application, the computation program will break down its ingredients and list them on appropriate sections of the MSDS document according to programmed threshold values. For text fields, we developed a series of MSDS templates consisting of possible combinations of hazard ingredients derived from the relational data analysis. The appropriate hazard warnings for various templates and the rules for template selection were programmed into the application as well. For example, if the color formula contains carbon black and silica that meet their appropriate threshold values, the template containing carbon black and silica hazard warnings will be selected by the program to be used in the text fields of the document.

    The resulting application is a formula-specific, user-friendly generic MSDS solution with the entire complex programming residing in the background. An input screen with basic input fields is provided to the users. The screen consists of product descriptions, formula information with concentrations in weights or weight percents, and variable physical properties. When there is a rush color order, the color chemist formulates the product, inputs the formula and other information into the input screen of the generic MSDS application, and submits the MSDS request by clicking the Submit button. Within a minute, a formula-specific MSDS document is created and the product is ready to ship. All created documents in this application are archived and retrievable by the Product Information Group for documentation purposes. The Web-based generic MSDS application runs as a service on the NT server and it is being used by color chemists of PRC-DeSoto worldwide.

    Future Plan for Product Information Management

    We have been very successful in creating a paperless environment for product information distributions. We are especially pleased with our recent advanced developments in Web-based applications that have significantly improved our process flows and documentation flows. Our plan for the future of product information management is to continue with our search for better solutions so that our users can access product information documents quicker and easier, and can perform their work more efficiently by using our Web-based applications. For the immediate future, we have plans to further expand our website scope to include more non-domestic product information requirements for users. We are also developing a Web-based product label solution that would allow shipping departments of any PRC-DeSoto sites to print product labels through the corporate intranet.

    For more information on electronic product information management, contact PRC-Desoto, 2820 Empire Avenue, Burbank, CA 91504; phone 818/549.7511; fax 818/549.7599; e-mail antoria.louie@prc-desoto.com; or Circle Number 86.

    Share This Story

    Looking for a reprint of this article?
    From high-res PDFs to custom plaques, order your copy today!

    Recommended Content

    JOIN TODAY
    to unlock your recommendations.

    Already have an account? Sign In

    • PCI-0724-Global10-Feature-1440.png

      2024 Global Top 10: Top Paint and Coatings Companies

      Who ranks on top? PCI’s annual ranking of the top 10...
      Paint and Coating Market Reports
      By: Courtney Bassett
    • PCI-0724-PCI25-Feature-1440.png

      2024 PCI 25: Top Paint and Coatings Companies

      PCI's annual ranking of the top 25 North American paint...
      Paint and Coating Market Reports
      By: Courtney Bassett
    • pci1022-Kinaltek-Lead-1170.jpg

      A Novel Pigment Production Technology

      Following an extensive R&D program that demonstrated...
      Paint and Coating Pigments
      By: Jawad Haidar and Nitin Soni
    You must login or register in order to post a comment.

    Report Abusive Comment

    Manage My Account
    • eMagazine
    • eNewsletter
    • Online Registration
    • Subscription Customer Service

    The Coatings Minute: Your Inside Look at PCInnovations

    The Coatings Minute: Your Inside Look at PCInnovations

    CTT Registration Now Open

    CTT Registration Now Open

    The Coatings Minute: Why Industry News Matters More Than Ever

    The Coatings Minute: Why Industry News Matters More Than Ever

    The Coatings Minute: Print Returns with PCI’s New Showcase Issue

    The Coatings Minute: Print Returns with PCI’s New Showcase Issue

    More Videos

    Sponsored Content

    Sponsored Content is a special paid section where industry companies provide high quality, objective, non-commercial content around topics of interest to the PCI audience. All Sponsored Content is supplied by the advertising company and any opinions expressed in this article are those of the author and not necessarily reflect the views of PCI or its parent company, BNP Media. Interested in participating in our Sponsored Content section? Contact your local rep!

    close
    • Modern arapartment complex painted in bright colors.
      Sponsored byEPS - Engineered Polymer Solutions

      Architectural Polymers Leading the Way in Coatings Innovation

    • paint sprayer in a workshop
      Sponsored byallnex

      Enabling Performance and Compliance: allnex Introduces a New Line of VOC Exempt Solvent-Borne Resins

    Popular Stories

    No. 3 AkzoNobel

    AkzoNobel to Close Two Manufacturing Sites

    Modern living room interior with green plants, sofa and green wall

    Reimagining Architectural Paints with Plant-Based Acrylic Binders

    Modern arapartment complex painted in bright colors.

    Architectural Polymers Leading the Way in Coatings Innovation



    PCI Buyers Guide

    Submit a Request for Proposal (RFP) to suppliers of your choice with details on what you need with a click of a button

    Start your RFP

    Browse our Buyers Guide for manufacturers and distributors of all types of coatings products and much more!

    Find Suppliers

    Events

    September 3, 2025

    Coatings Trends & Technologies Summit

    The Coatings Trends & Technologies (CTT) Summit is an annual conference for both liquid and powder coatings formulators and manufacturers to discuss innovations in coatings technology. This event combines high-quality technical presentations, a resource-rich exhibit hall, and dedicated networking opportunities to connect scientific minds, foster innovation, and cultivate game-changing new ideas!

    January 1, 2030

    Webinar Sponsorship Information

    For webinar sponsorship information, visit www.bnpevents.com/webinars or email webinars@bnpmedia.com.

    View All Submit An Event

    Poll

    Longest-running laboratory experiment

    What is the longest-running laboratory experiment?
    View Results Poll Archive

    Products

    CTT Summit Short Courses (Live 9/3/25)

    Coatings Trends & Technologies Summit is expanding its offerings with four short courses. These short courses will offer an extensive day of interactive learning.

    See More Products
    pci  webinar april 2025

    PCI CASE EBOOK

    Related Articles

    • A New Approach to Understanding Rheological Additives

      See More
    • Six Sigma, Information Technology & You: Creating A Happy Customer

      See More
    • Product-Development Software Key to Optimizing Your M & A Investment

      See More
    ×

    Keep the info flowing with our eNewsletters!

    Get the latest industry updates tailored your way.

    JOIN TODAY!
    • RESOURCES
      • Advertise
      • Contact Us
      • Directories
      • Store
      • Want More
    • SIGN UP TODAY
      • Create Account
      • eMagazine
      • eNewsletters
      • Customer Service
      • Manage Preferences
    • SERVICES
      • Marketing Services
      • Reprints
      • Market Research
      • List Rental
      • Survey & Sample
    • STAY CONNECTED
      • LinkedIn
      • Facebook
      • Youtube
      • X (Twitter)
    • PRIVACY
      • PRIVACY POLICY
      • TERMS & CONDITIONS
      • DO NOT SELL MY PERSONAL INFORMATION
      • PRIVACY REQUEST
      • ACCESSIBILITY

    Copyright ©2025. All Rights Reserved BNP Media.

    Design, CMS, Hosting & Web Development :: ePublishing

    Painting & Coating Industry (PCI) logo Powder coating summit logo
    search
    cart
    facebook twitter linkedin youtube
    • Sign In
    • Create Account
    • Sign Out
    • My Account
    Painting & Coating Industry (PCI) logo Powder coating summit logo
    • NEWS
      • Latest News
      • Market Trends & Reports
      • Price Alerts
      • Subscribe to eNewsletters
      • Global Top 10/ PCI 25
      • Weekly Featured Article
      • COATLE Word Game
    • PRODUCTS
      • Product News
      • Must See Products and Services
    • MATERIALS
      • Additives
      • Resins/Polymers
      • Pigments
      • Equipment
      • Distributors
    • TECHNOLOGIES
      • Adhesives
      • Architectural Coatings
      • Industrial Coatings
      • Nanotechnology
      • Powder Coatings
      • Solventborne
      • Special Purpose Coatings
      • Sustainability
      • UV Coatings
      • Waterborne
      • FINISHING
        • Finishing News
        • Finishing Technologies
        • Finishing Equipment
      • RESOURCES
        • Columns
          • Ask Joe Powder
          • Did you know?
          • Distribution Dive
          • Focus on Canada
          • Formulating With Mike
          • Innovation Insights
          • Moody's Coatings Conundrums
          • Powder Coating Perspectives
          • Target the Market
          • TiO2 Insider
        • Blogs
          • Editor's Viewpoint
          • Industry Insights
        • Coatings Supplier Handbook
        • Podcasts and Videos
          • COAT-IT! Podcast
          • Videos/PCI TV
        • PCI Store
        • eBooks
        • Sponsor Insights
        • White Papers
        • COATLE Word Game
      • EVENTS
        • Coatings Trends & Technologies Summit
        • Paint and Coatings Academy
        • Webinars
        • Calendar of Events
        • Lifetime Achievement Award
      • DIRECTORIES
        • Buyer's Guide
        • Equipment Directory
        • Materials Directory
      • EMAGAZINE
        • Current Issue
        • eMagazine Archive
        • China Issue Archive
        • Editorial Advisory Board
      • CONTACT
        • Contact Us
        • Advertise
        • Subscribe to eMagazine
        • Subscribe to eNewsletters