UltraPIPE Database Audit
What is an UltraPIPE Database Audit?
An UltraPIPE database audit is a thorough interrogation of the data set which identifies the quantity and severity of previously unknown issues. The findings are then used to build a prioritized action plan which will resolve all identified issues.
Why is it needed?
UltraPIPE is an incredibly flexible software application capable of effectively managing an inspection program. However, an application with this degree of flexibility requires defined boundaries, work processes, roles, and responsibilities. Without rigid controls and standardization, the UltraPIPE database can, and typically will, fall into disrepair.
Unfortunately, many mechanical integrity issues often remain hidden from sight due to poor configuration of the Analytical Settings, which is obviously a major problem. These settings are used to calculate such parameters as corrosion rates, remaining life, inspection dates, and retirement dates. Improper configuration of the settings leads to incorrect calculations which then yields incorrect outputs. While most have heard the phrase “bad data in, bad data out,” this case of poorly configured settings creates a “good data in, bad data out” scenario giving users a false sense of security.
For example, misapplication of these settings can, and often will, mask overdue inspections and high corrosion areas leaving companies exposed to potential safety, compliance, and environmental risk. In those cases, the real danger lies in being unaware of existing mechanical integrity issues because they either appear as simple data quality issues, which are not typically addressed with the necessary urgency, or they don’t appear at all until there is a loss of primary containment.
An audit of the UltraPIPE database system will identify problem areas and allow users to improve the completeness of their data sets, ensure accuracy of data processing, and increase overall confidence in their reporting. That improvement equips integrity management teams with a better tool to manage risk, safety, and compliance.
What is examined?
We review how the UltraPIPE database is installed, configured, and utilized. As part of the utilization review we query the master list, corrosion monitoring, inspection scheduling, drawing, and reporting modules to identify areas of concern. In addition to the list of specific findings we will summarize the impact and provide a list of recommendations to resolve the issues. Our key areas of focus are:
- Software Version
- Local, Network, Virtual (e.g. CITRIX)
- Database Segregation
- Program Settings
- Path Settings
Analytical Settings and Calculations
- KPI Comparison – Current Settings vs Recommended Settings
- Short Term
- Long Term
- Max. Historical
- Best Fit
- Remaining Life and Retirement Date
- Last Inspection Date and Next Inspection Date
- Maximum Inspection Intervals
- Caution CML Logic for Early Warning Signals
- Inspection Activity Settings
- Standardized Nomenclature
- Data Processing Procedures
- Consistency of Database Hierarchy
- Equipment Grouping or Circuitization
Equipment Missing Information
- Isometric Drawings
- Scheduled Inspections
- Design and Operating Conditions
- Materials of Construction
- CML Placement
Identification of Unusual Data
- Duplicate Records
- Conflicting Data Elements
- User-Defined Tmins and Tmins with “Invalid” Flags
- Confusing KPI Outputs
- Inactive CMLs
How do I request one?
To request an UltraPIPE database audit, please contact us using any of the following options.