Loading...
compliance

Gas Distribution Integrity Management Data Collection

Use this Gas Distribution Integrity Management Data Collection template to gather leak, repair, and excavation damage data for annual integrity review and reporting. It helps you document source records, spot trends, and close gaps before they become compliance issues.

Trusted by frontline teams 15 years of frontline software AI customization in seconds

Built for: Natural Gas Utilities · Pipeline Operations · Municipal Utility Departments · Energy Infrastructure

Overview

This Gas Distribution Integrity Management Data Collection template is for gathering the records that support an annual integrity management review for a gas distribution system. It organizes the work into five practical sections: scope and record identification, leak event data, repair and corrective action data, excavation damage and third-party interference, and data quality with sign-off. The template is designed to help a reviewer trace each reported count back to source records, confirm the reporting period, and summarize trends that matter to operations and compliance.

Use it when you need a repeatable way to compile leak counts, classify events, document repair timing, and capture excavation damage details for a specific operating area or system segment. It is especially useful when multiple source systems feed the annual report and the reviewer needs to reconcile differences before submission. The template also helps identify repeat events, hotspots, and missing information that could weaken the integrity review.

Do not use this as a field leak survey form, emergency response log, or a substitute for incident investigation documentation. It is not meant to replace asset maintenance records or one-call ticket management systems; it pulls from them. If your organization has no defined reporting period, no source record discipline, or no owner for the annual review, those issues should be addressed before relying on this template for compliance reporting.

Standards & compliance context

  • This template supports the recordkeeping and review discipline commonly expected under federal pipeline safety and gas distribution integrity management programs.
  • The structure helps operators prepare documentation that can be used alongside company procedures, state utility requirements, and internal audit expectations.
  • Where excavation damage is involved, the template supports coordination with one-call and damage prevention processes that are often tied to utility safety obligations.
  • Trend review and corrective action documentation align with the management-system approach used in ANSI and integrity-focused programs, where repeat issues must be tracked to closure.

General regulatory context for orientation only — verify current requirements with counsel or the relevant agency before relying on this template for compliance.

What's inside this template

Inspection Scope and Record Identification

This section matters because it defines the reporting window, system boundary, and source records that make the rest of the data defensible.

  • Reporting period is defined and matches the annual review window (critical · weight 3.0)
  • Operating area, division, or system segment is identified (critical · weight 3.0)
  • Source records reviewed are identified (weight 3.0)
  • Inspector confirms records are complete for the selected period (critical · weight 3.0)
  • Data owner or preparer is identified (weight 3.0)

Leak Event Data Collection

This section matters because leak counts, classifications, locations, and discovery methods are the core inputs for integrity trend analysis.

  • Leak count for the reporting period is recorded (critical · weight 5.0)
  • Leak classification is documented for each event (critical · weight 5.0)
  • Leak location or asset type is documented (weight 5.0)
  • Leak discovery method is recorded (weight 5.0)
  • Leak response time or repair initiation date is documented (weight 5.0)

Repair and Corrective Action Data

This section matters because it shows whether each event was closed properly and whether recurring issues were addressed at the source.

  • Repair completion status is documented for each applicable event (critical · weight 5.0)
  • Repair method or component replaced is documented (weight 5.0)
  • Root cause or contributing factor is identified (weight 5.0)
  • Corrective action or mitigation is documented for repeat or systemic issues (critical · weight 5.0)

Excavation Damage and Third-Party Interference

This section matters because damage prevention events often reveal process gaps, locate issues, or repeat interference patterns that need follow-up.

  • Excavation damage count is recorded (critical · weight 5.0)
  • Damage type is documented (critical · weight 5.0)
  • One-call / locate ticket reference is recorded when applicable (weight 5.0)
  • Damage was reported and investigated according to company procedure (critical · weight 5.0)

Data Quality, Trend Review, and Sign-Off

This section matters because it turns raw records into a reviewed annual package with explained gaps, trend notes, and accountable approval.

  • Data entries are internally consistent across source records (critical · weight 5.0)
  • Missing or unknown values are identified and explained (weight 5.0)
  • Notable trends, repeat events, or hotspots are summarized (weight 5.0)
  • Annual report submission or management review is completed (critical · weight 3.0)
  • Inspector signature (critical · weight 2.0)

How to use this template

  1. 1. Set the reporting period, operating area, and system segment at the top of the template so every record collected belongs to the same annual review window.
  2. 2. Pull the source records you will rely on, such as leak logs, work orders, damage reports, and locate tickets, and list them in the inspection scope section.
  3. 3. Enter each leak, repair, and excavation damage event with the required fields, making sure the classification, location, discovery method, and dates match the source documents.
  4. 4. Review the entries for internal consistency, explain any missing or unknown values, and flag repeat events, systemic causes, or hotspots that need follow-up.
  5. 5. Complete the annual report submission or management review note, then have the designated inspector or data owner sign off on the final record set.

Best practices

  • Use one reporting period definition across all source systems so leak counts and repair totals do not drift between departments.
  • Record the original source document reference for each event so the annual review can be traced without rework.
  • Classify leaks and damage events using your company’s standard definitions, and do not mix field notes with final reviewed classifications.
  • Capture repair initiation and completion dates separately when timing matters, because a delayed repair can be a meaningful compliance or risk signal.
  • Explain every unknown value in plain language instead of leaving blanks that force a reviewer to guess later.
  • Summarize repeat leaks, recurring excavation damage, and geographic hotspots in the trend section so corrective action is visible.
  • Verify that locate ticket references and damage reports align before sign-off, especially when third-party interference is involved.

What this template typically catches

Issues teams running this template most often surface in practice:

Leak counts that do not reconcile to the underlying leak log or work order system.
Leak classifications that change between source records and the annual summary without explanation.
Missing repair initiation dates or completion status for events that were opened but not clearly closed.
Excavation damage entries with no locate ticket reference or no documented investigation outcome.
Repeat leaks at the same asset type or location that are listed individually but never summarized as a trend.
Unknown root causes that are left blank instead of being explained as pending analysis or not determined.
Source records from different divisions using different date ranges or segment names for the same reporting period.
Management review or annual submission fields left unsigned, making the package incomplete for audit purposes.

Common use cases

Integrity Manager — Annual Distribution Review
An integrity manager uses the template to compile the year’s leak, repair, and excavation damage data for a specific distribution segment. The completed record set supports the annual review package and highlights repeat issues that need mitigation.
Utility Compliance Coordinator — Audit Preparation
A compliance coordinator gathers source records from operations, maintenance, and damage prevention systems and uses the template to reconcile differences before an audit. The structure makes it easier to show what was reviewed, what was missing, and what was corrected.
Operations Supervisor — Hotspot Follow-Up
An operations supervisor reviews the trend section to identify neighborhoods, mains, or service areas with repeated leaks or excavation damage. The template helps turn raw counts into a follow-up list for targeted repairs or outreach.
Damage Prevention Lead — Third-Party Interference Review
A damage prevention lead uses the excavation damage section to verify locate ticket references, damage type, and investigation status. This helps connect third-party interference events to corrective action and prevention planning.

Frequently asked questions

What does this template cover?

This template is built to collect the core data used in a gas distribution integrity management review: leak events, repair and corrective action details, excavation damage, and data quality checks. It also captures the reporting period, operating area, source records, and sign-off so the annual review has a clear audit trail. It is meant for record collection and review, not for field leak survey work or emergency response documentation.

Who should use this template?

It is typically used by integrity management staff, compliance coordinators, operations supervisors, or a designated data owner who can pull records from maintenance, leak, and damage prevention systems. A field inspector may help verify source records, but the person completing the template should understand the company’s reporting definitions and recordkeeping process. The sign-off should come from someone accountable for the annual review package.

How often should this be completed?

This template is designed around the annual review window, so it is usually completed once per reporting cycle and then updated as source records are finalized. Many teams also use it quarterly or monthly as a working tracker so the year-end review is not a last-minute reconciliation exercise. If your program has internal checkpoints, the same structure can support interim trend reviews.

Does this template align with regulatory requirements?

Yes, it is aligned to the kind of record collection expected under gas distribution integrity management programs and related utility compliance workflows. It supports the documentation discipline commonly associated with federal pipeline safety requirements and company integrity management procedures. You can also adapt it to match state utility commission reporting, internal audit standards, or operator-specific data fields.

What are the most common mistakes this template helps prevent?

The biggest issues are incomplete source record tracing, inconsistent leak classifications, missing repair dates, and excavation damage entries that do not tie back to locate tickets or incident reports. Teams also miss trend review opportunities when repeat events or hotspots are not summarized in one place. This template forces the reviewer to explain unknowns instead of leaving gaps buried in the annual package.

Can I customize the template for our system or division structure?

Yes, the inspection scope section is meant to be adapted to your operating area, division, or system segment naming convention. You can add fields for asset class, pressure tier, material type, or geographic district if those are part of your internal analysis. The key is to keep the same data logic across reporting periods so year-over-year comparisons stay consistent.

How does this compare with collecting data in spreadsheets or ad hoc notes?

A spreadsheet can hold the numbers, but it often misses the context needed for review: what records were checked, why a value is unknown, and whether a trend was actually investigated. This template gives the review a standard structure so leak, repair, and damage data are collected the same way every cycle. That makes it easier to defend the annual submission and easier to hand off between staff.

What should be reviewed before sign-off?

Before sign-off, confirm that the reporting period matches the annual review window, the source records are complete, and every count can be traced back to a documented event. Check that repairs, root causes, and corrective actions are consistent across the source documents and that any missing values are explained. The final review should also note any repeat events, hotspots, or open follow-up items that need management attention.

Go deeper on the topic

Related concepts
  • Predictive scheduling laws — also called fair workweek laws or secure scheduling — require employers in covered industries to publish employee schedules...
  • Overtime calculation is the process of applying federal, state, local, and contractual rules to hours worked to determine the correct pay — including...
  • A near-miss is an event that could have caused injury or damage but didn't — a slip that didn't fall, a load that shifted but didn't drop, a machine that...
  • Lockout/tagout (LOTO) is the procedure for controlling hazardous energy — electrical, hydraulic, pneumatic, mechanical, thermal, chemical — before...
Related guides

Ready to use this template?

Get started with MangoApps and use Gas Distribution Integrity Management Data Collection with your team — pricing built for small business.

Ask AI Product Advisor

Hi! I'm the MangoApps Product Advisor. I can help you with:

  • Understanding our 40+ workplace apps
  • Finding the right solution for your needs
  • Answering questions about pricing and features
  • Pointing you to free tools you can try right now

What would you like to know?