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
- Operating area, division, or system segment is identified
- Source records reviewed are identified
- Inspector confirms records are complete for the selected period
- Data owner or preparer is identified
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
- Leak classification is documented for each event
- Leak location or asset type is documented
- Leak discovery method is recorded
- Leak response time or repair initiation date is documented
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
- Repair method or component replaced is documented
- Root cause or contributing factor is identified
- Corrective action or mitigation is documented for repeat or systemic issues
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
- Damage type is documented
- One-call / locate ticket reference is recorded when applicable
- Damage was reported and investigated according to company procedure
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
- Missing or unknown values are identified and explained
- Notable trends, repeat events, or hotspots are summarized
- Annual report submission or management review is completed
- Inspector signature
How to use this template
- 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. 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. 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. 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. 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:
Common use cases
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.
Related templates
Go deeper on the topic
-
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...
-
See how MangoApps Forms helps teams collect, track, and analyze employee data in real time — with mobile access, file uploads, and enterprise-grade security.
-
MangoApps Shifts & Schedules unifies frontline scheduling, time, and leave management in one native platform for faster, simpler operations.
-
Software bloat warning signs explained—spot bloated software early and choose leaner tools that boost performance, adoption, and ROI.
-
Compare on-premise vs SaaS intranet TCO with MangoApps and uncover the true 5-10 year cost to choose smarter.
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.