Skip to content
Beaconby Winda
FactInspection, Testing and Monitoring · Inspection planning and data

What is an inspection data management system (IDMS)?

·9 sources

Short answer

An inspection data management system (IDMS) is the database where a plant keeps fixed equipment inspection records and the results calculated from them. It holds equipment data, monitoring locations, thickness readings and findings, and turns repeat readings into corrosion rates and remaining life. US process safety rules require the underlying inspection records.

By , Editor·Researched and drafted by ·Checked by , Editor·Last checked ·Next review

Why does it matter?

In 2002, an inspector at a refinery in Richmond, California, had extra readings taken beside a monitored elbow and found that a section of straight pipe had lost about a third of its wall 1. Site rules sent such extra findings to a free-text history note instead of the database of permanent readings, and no new monitoring location was added, so the section was never inspected again 1. It ruptured on August 6, 2012 1. The US Chemical Safety and Hazard Investigation Board (CSB) also recommended a formal technical review before anyone lowers the alert thickness stored in an inspection database 1.

What does an IDMS hold?

Every record group in the table traces to a US rule, to the refinery checklist of the US Occupational Safety and Health Administration (OSHA), or to the CSB's Richmond findings, as the last column shows 3,4,5,1.

Record groupTypical contentsWho asks for it
Equipment and design dataMaterials of construction, design codes and standards, piping and instrument diagramsProcess safety information, 29 CFR 1910.119(d)(3) 3
Equipment historyInstallation date, specifications and strength, service class, repairs, replacements, operating changesOSHA refinery inspection checklist 4
Monitoring locations and readingsEach condition monitoring location (CML), the original thickness, and the place, date and result of every later readingOSHA refinery inspection checklist 4; CSB 1
LimitsRetirement thickness; the alert thickness that triggers an engineering reviewOSHA checklist 4; CSB 1
Inspection and test recordsDate, inspector's name, equipment identifier, what was done, results29 CFR 1910.119(j)(4)(iv) 3
Findings and recommendationsFindings, notes, recommended repairs or replacementsCSB 1
Pipeline integrity dataPipe attributes, pressure test history, coating and cathodic protection surveys, in-line inspection results, internal corrosion monitoring results49 CFR 192.917(b) 5

What does an IDMS do with the data?

  • Calculates rates and remaining life. The Richmond refinery's database stored findings, notes and wall thickness values, tracked corrosion rates, and used a minimum value entered by the inspector to project remaining life 1. OSHA has cited refineries for not calculating corrosion rates to set inspection intervals, and for rates above the expected value that went unaddressed 2.
  • Triggers reviews. Reaching an alert thickness started an engineering evaluation of the minimum required thickness 1.
  • Flags anomalies. OSHA, citing industry process safety guidance, says inspection data should be reviewed for suspicious values and that employers should be able to analyze data efficiently and highlight anomalies; a reading that shows a wall getting thicker must be retested and resolved 2,4.
  • Supports decisions. Database reports were used for remaining-life estimates, replacement recommendations and turnaround work scope 1.
  • Keeps the record. Gas transmission and hazardous liquid pipeline operators must keep integrity management records for the useful life of the pipeline 5,6.

A maintenance management system is built around a different object. A Pacific Northwest National Laboratory guide for the DOE Federal Energy Management Program treats a computerized maintenance management system (CMMS) as software for running operations and maintenance work: raising, ranking and tracking work orders, scheduling preventive maintenance and keeping the spare parts inventory 8. The inspection database in the CSB's Richmond account held readings and findings instead, and worked out rates and remaining life from them 1.

What records do US rules require?

Under the US process safety management (PSM) standard, each inspection or test on covered process equipment must be documented with its date, the person who did it, the equipment identifier, a description and the results, and equipment deficiencies outside acceptable limits must be corrected 3. Pipeline rules go further on data use: gas transmission operators must integrate a long list of attributes and survey results into their threat and risk assessment 5, and liquid operators must analyze all available information on the integrity of the whole pipeline 6. See What inspection records do codes require you to keep?.

Where integrity problems show up

What it finds wellWhat it can miss or get wrongIn the Library
Corrosion rate and remaining life at every recorded CML 1Damage written up as free text instead of CML data, which falls out of rate and remaining-life calculations (Richmond, 2012) 1What are condition monitoring locations (CMLs)?
Equipment approaching its alert or retirement thickness 1,4An alert thickness lowered without a documented technical review, which the CSB recommended against 1Minimum required thickness
Readings that break the trend, when checks are built in 2Readings showing a wall growing thicker, left unresolved, as OSHA found in refinery inspections 2,4Corrosion rate
Components that carry monitoring locations 7Components with none: a Philadelphia refinery circuit had 141 CMLs in 2019 and none on the elbow that ruptured 7What should an inspection plan contain?
Pipeline condition data integrated across the system 5Lessons from one segment not applied to similar ones; after the 2012 Sissonville, West Virginia, rupture, the National Transportation Safety Board (NTSB) recommended using integrity data from high consequence area lines on the rest of the system 9What is pipeline integrity management?

Sources: CSB final report on the 2012 Richmond refinery fire, 2015 1; CSB report No. 2019-04-I-PA, 2022 7; OSHA 3918, 2017 2; OSHA CPL 03-00-004, 2007 4; NTSB/PAR-14/01, 2014 9.

Common questions

Is an IDMS the same as a computerized maintenance management system (CMMS)?
No. A US Department of Energy (DOE) guide describes a CMMS as software for managing and tracking operations and maintenance work, such as work orders, preventive maintenance schedules and spare parts. The inspection database the CSB describes stores readings and findings and calculates corrosion rates and remaining life. See [What is a computerized maintenance management system (CMMS)?](/library/cmms/).
Does reaching the alert thickness mean the equipment is unsafe?
Not by itself. At Richmond, reaching the minimum alert thickness started an engineering evaluation of the minimum required thickness, which decided whether the piping had to be replaced at once or could wait.
How long must inspection records be kept?
For US gas transmission and hazardous liquid pipelines covered by integrity management rules, for the useful life of the pipeline.

Beacon explains these concepts in its own words for education. It does not reproduce or replace the standards cited, and Winda is not affiliated with or endorsed by the organizations that publish them. Engineering decisions need the current edition of the standard and a qualified engineer.

Sources

  1. 1.Final Investigation Report: Chevron Richmond Refinery Pipe Rupture and Fire · US Chemical Safety and Hazard Investigation Board (CSB) ·
  2. 2.Process Safety Management for Petroleum Refineries: Lessons Learned from the Petroleum Refinery Process Safety Management National Emphasis Program (OSHA 3918) · US Occupational Safety and Health Administration (OSHA)
  3. 3.29 CFR 1910.119, Process safety management of highly hazardous chemicals · eCFR, US Office of the Federal Register
  4. 4.CPL 03-00-004, Petroleum Refinery Process Safety Management National Emphasis Program · US Occupational Safety and Health Administration (OSHA)
  5. 5.49 CFR Part 192, Subpart O, Gas Transmission Pipeline Integrity Management (sections 192.917 and 192.947) · eCFR, US Office of the Federal Register
  6. 6.49 CFR 195.452, Pipeline integrity management in high consequence areas · eCFR, US Office of the Federal Register
  7. 7.Fire and Explosions at Philadelphia Energy Solutions Refinery Hydrofluoric Acid Alkylation Unit, Investigation Report No. 2019-04-I-PA · US Chemical Safety and Hazard Investigation Board (CSB) ·
  8. 8.Operations & Maintenance Best Practices: A Guide to Achieving Operational Efficiency (G. P. Sullivan et al.), PNNL-13890 · Pacific Northwest National Laboratory for the US Department of Energy, Federal Energy Management Program
  9. 9.Pipeline Accident Report: Columbia Gas Transmission Corporation Pipeline Rupture, Sissonville, West Virginia, December 11, 2012 (NTSB/PAR-14/01) · US National Transportation Safety Board (NTSB)