This article was presented at American Institute of Chemical Engineers, 2010 Spring Meeting, 6th Global Congress on Process Safety, San Antonio, TX, March 22–24, 2010.
Articles to Improve Process Safety
Objective analysis of process safety audit data with microsoft access†
Version of Record online: 3 FEB 2011
Copyright © 2011 American Institute of Chemical Engineers (AIChE)
Process Safety Progress
Volume 30, Issue 3, pages 221–231, September 2011
How to Cite
Forest, J. J. (2011), Objective analysis of process safety audit data with microsoft access. Proc. Safety Prog., 30: 221–231. doi: 10.1002/prs.10435
- Issue online: 5 AUG 2011
- Version of Record online: 3 FEB 2011
In developing systems for process safety, compliance audits provide essential verification that practices and procedures are developed and are effective for compliance. Data collected during compliance audits is often subjective and findings are descriptive in nature. Therefore, it is difficult to complete objective analysis of audit data across standards/procedures to surface systemic management system gaps and to compare site performance across a company. Complete analysis of process safety audit data is analogous to incident investigation causal factor assignment, data analysis, and cause elimination.
This article describes a database solution that:
- 1Provides a data collection method for compliance audits that allows for easy database input, thereby reducing overall data handling.
- 2Structures process safety procedures by management system element so that these elements can be examined across various procedures.
- 3Groups compliance audit findings by common types for Pareto analysis.
The benefits of objective analysis of process safety audit data include more effective future audits and continuous process safety performance improvement at the site level.
The presentation will include a brief review of the Microsoft Access database structure. © 2011 American Institute of Chemical Engineers Process Saf Prog, 2011