Topic Indices and Site Maps Search - Bureau of Ocean Energy Management, Regulation and Enforcement Home - Bureau of Ocean Energy Management, Regulation and Enforcement Bureau of Ocean Energy Management, Regulation and Enforcement
Bureau of Ocean Energy Management, Regulation, and Enforcement (BOEMRE)
About BOEMRE
Newsroom
FAQ
Renewable Energy Program
Offshore Energy and Minerals Management Program Home Page.
Environmental Stewardship
Research

Library
Kids' Page
 Pipeline Open Access
GOMESA Revenue Sharing
Public Engagement
Contact UsSpacer ImageAlaska Region
Atlantic
Gulf of Mexico
Pacific RegionSpacer Image

Hot Topics:

Spacer Image


  Contact:
    Public Affairs
  
 Navy Spacer

 

The GOMR.BOEMRE.GOV website is no longer being updated. In its place, BOEM.GOV and BSEE.GOV have been launched. Over the next several weeks, the appropriate content from the GOMR.BOEMRE.GOV website will be moved to the new sites.

Field Values for PIPELINE HISTORIES

Column
Alias Name		 Domain
Name		 Domain
Type		 Valid Value
Description
Segment Num SEGMENT_NUMBERS Number Range Between 0000000 and 9999999
History Date GENERAL_DATES Date Range Between 01-JAN-1947 and SYSDATE+10
History Code HISTORY_CODES Enumeration Range The Value-Description Pairs are listed below:
  • A- AS-BUILT APPROVED.
  • B- ABANDONED/PROPOSED ABANDONMENT.
  • C- COMBINED WITH OTHER PIPE TO CREATE A NEW SEGMENT.
  • D- DEPARTURE APPROVED.
  • E- MISCELLANEOUS.
  • F- FLOW DIRECTION CHANGE.
  • H- HYDRO-STATIC TEST DATE.
  • I- DATE OF FIRST OIL FLOW (ALASKA REGION).
  • L- FLUSH/FILL DATE.
  • M- MAOP CHANGE.
  • O- OUT-OF-SERVICE DATE.
  • P- PIPE ADDED OR NEW SEGMENT CREATED.
  • R- REPAIR MADE.
  • S- CHANGE IN SERVICE.
  • T- TEMPORARY CESSATION OF OPERATIONS DATE.
  • U- DATE LINE PLACED IN-SERVICE OR RETURNED TO SERVICE.
Last Rev Date GENERAL_DATES Date Range Between 01-JAN-1947 and SYSDATE+10