ESHTRK V2.0. Environment Safety and Health Tracking Database

The purpose of the ESHTRK V2.0 database application is to track reviews, findings, responsibilities, corrective actions, action plans, etc., that are created as the result of both external and internal audits of an organization`s activities with respect to that organization`s compliance with Environmental, Health, and Safety regulations as well as orders, policies, etc. It solves the problem of providing awareness throughout an organization of the existence of findings, the commitments of corrective actions and their scheduled and actual completion dates. The product also solves the problem of monitoring milestone scheduled and actual completion dates for long term, multi-step action plans. The product provides Oracle FORMS data entry screens for the entry of review and finding information, data entry screens for the entry and updating of responsibility assignments, and data entry screens for the entry and updating of corrective action and action plan information. In addition, the product provides reports showing open findings, responsibilities, counts of findings by review and so forth. The product`s functions and capabilities are based on many supporting tables which are expected to be populated by entries for an organization`s locations, organizational structure, people, acronyms for finding types (implemented as DOE Performance Objectives in one case), andmore » root cause analysis methodology (implemented as the copyrighted TAPROOT approach in one case).« less