Original Date: 10/18/1999
Revision Date: 01/18/2007
Information : Corrective Action and Deviation Report Database Systems
Orenda Turbines developed two database systems for managing, assigning, responding, validating, tracking, trending, and approving root cause and corrective actions. The Corrective Action (CA) Database addresses actions related to nonconformance from customer complaints, quality systems, and procedural issues. The Deviation Report (DR) Database addresses actions related to nonconforming products. The company’s previous method compiled the information manually, was unresponsive, and had limited analysis and tracking capabilities.
The CA Database has been in operation since 1997, while the DR Database is currently being implemented. In developing both systems, Orenda Turbines drew heavily on automotive industry experience and methods for closed- loop tracking and management of nonconformances and corrective actions. These systems are designed to comply with industry standards, procedures, and customer requirements, and to incorporate best practices identified by benchmarking.
Once the corrective action is entered into the CA Database system, it is controlled throughout the entire analysis and tracking process. Users can review all information; conduct on-line root cause analysis and verification; and view or print tracking reports. The system is supported by Microsoft Access and Visual Basic, and is linked with Orenda Turbines’ Approved Supplier Database and GroupWise mail system. This arrangement enables information to flow rapidly and progressively to all involved personnel, thereby assuring timely resolution. Since the CA Database is an activity-based system, activities cannot occur out of sequence. Continuous trend charts and reports allow users to track the status of all assignments. Additionally, the system is linked with the supplier, customer, and internal e-mail systems. As a result, notifications and actions move rapidly and in sequence. Password-protected electronic signatures help ensure the integrity of the database.
Since implementing the CA Database system, Orenda Turbines has seen significant cost reductions due to improved responsiveness and accuracy. Administrative workload for quality tracking and management has decreased by nearly 75%. Orenda Turbines plans to incorporate the CA and DR Database systems into the company’s Enterprise Resource Planning system.
For more information see the
Point of Contact for this survey.