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 MASTERS

Column
Alias Name		 Domain
Name		 Domain
Type		 Valid Value
Description
Segment Num SEGMENT_NUMBERS Number Range Between 0000000 and 9999999
Seg Length SEG_LENGTHS Number Range Between 0000000 and 9999999
Aban Aprv Dt GENERAL_DATES Date Range Between 01-JAN-1947 and SYSDATE+10
Aban Date GENERAL_DATES Date Range Between 01-JAN-1947 and SYSDATE+10
Approved Date GENERAL_DATES Date Range Between 01-JAN-1947 and SYSDATE+10
Auth Code AUTH_CODES Enumeration Range The Value-Description Pairs are listed below:
  • I- DEPARTMENT OF THE INTERIOR.
  • T- DEPARTMENT OF TRANSPORTATION.
Bd Ppl Sdv Fl H_L_CODES Enumeration Range The Value-Description Pairs are listed below:
  • H- HOLDS.
  • L- LEAKS.
  • N- NO.
  • Y- YES.
Bur Dsgn Fl BUR_DSGN_FLS Enumeration Range The Value-Description Pairs are listed below:
  • N- NO.
  • S- SELF BURIAL.
  • W- WAIVER.
  • Y- YES.
Cat Life Tm CAT_LIFE_TMS Number Range Between 00 and 99
Dep Flag DEP_FLAGS Enumeration Range The Value-Description Pairs are listed below:
  • B- BIDIRECTIONAL.
  • D- DEPARTING PLATFORM.
  • I- INCOMING TO PLATFORM.
Ppl Const Date GENERAL_DATES Date Range Between 01-JAN-1947 and SYSDATE+10
Lk Detec Fl FLAG Enumeration Range The Value-Description Pairs are listed below:
  • N- No.
  • Y- Yes.
Last Rev Date GENERAL_DATES Date Range Between 01-JAN-1947 and SYSDATE+10
Init Hs Dt GENERAL_DATES Date Range Between 01-JAN-1947 and SYSDATE+10
Fed St Lgth SEG_LENGTHS Number Range Between 0000000 and 9999999
Status Code STATUS_CODES Enumeration Range The Value-Description Pairs are listed below:
  • A/C- ABANDONED AND COMBINED.
  • ABN- ABANDONED.
  • ACT- ACTIVE.
  • CNCL- CANCELLED.
  • COMB- COMBINED.
  • O/C- OUT AND COMBINED.
  • OUT- OUT OF SERVICE.
  • PABN- PROPOSE ABANDONMENT.
  • PREM- PROPOSE REMOVAL.
  • PROP- PROPOSED.
  • R/A- RELINQUISHED AND ABANDONED.
  • R/C- RELINQUISHED AND COMBINED.
  • R/R- RELINQUISHED AND REMOVED.
  • RELQ- RELINQUISHED.
  • REM- REMOVED.
Ppl Size Code PPL_SIZE_CODES Enumeration Range The Value-Description Pairs are listed below:
  • 0.5- 1/2-inch pipe.
  • 0.75- 3/4-inch pipe.
  • 01- 1".
  • 01-02- 1" TO 2 7/8".
  • 01-03- 1" TO 3 1/2".
  • 02- 2 1/2" OR 2 7/8".
  • 02-01- (2 1/2" OR 2 7/8") TO 1".
  • 02-03- (2 1/2" OR 2 7/8") TO 3".
  • 02-04- (2 1/2" OR 2 7/8") TO 4".
  • 02-06- 2" to 6".
  • 03- 3 1/2".
  • 03-01- 3 1/2" TO 1".
  • 03-02- 3 1/2" TO (2 1/2" OR 2 7/8").
  • 03-04- 3 1/2" TO 4".
  • 03-06- 3 1/2" TO 6 5/8".
  • 04- 4".
  • 04-02- 4" TO (2 1/2" OR 2 7/8").
  • 04-03- 4" TO 3 1/2".
  • 04-06- 4" TO 6 5/8".
  • 05- 5".
  • 06- 6 5/8".
  • 06-03- 6 5/8" TO 3 1/2".
  • 06-04- 6 5/8" TO 4".
  • 06-08- 6 5/8" TO 8 5/8".
  • 07- special 7-inch pipe.
  • 08- 8 5/8".
  • 08-06- 8 5/8" TO 6 5/8".
  • 08-10- 8 5/8" TO 10 3/4".
  • 08-12- 8 5/8" to 12 3/4".
  • 10- 10 3/4".
  • 10-08- 10 3/4" TO 8 5/8".
  • 10-12- 10 3/4" TO 12 3/4".
  • 12- 12".
  • 12-10- 12 3/4" TO 10 3/4".
  • 12-14- 12 3/4" TO 14".
  • 14- 14".
  • 14-10- 14" TO 10 3/4".
  • 14-12- 14" TO 12 3/4".
  • 14-16- 14" TO 16".
  • 16- 16".
  • 16-14- 16" TO 14".
  • 16-18- 16" TO 18".
  • 18- 18".
  • 18-16- 18" TO 16".
  • 18-20- 18" TO 20".
  • 20- 20".
  • 20-18- 20" TO 18".
  • 20-24- 20" TO 24".
  • 22- 22".
  • 24- 24".
  • 24-20- 24" TO 20".
  • 24-26- 24" TO 26".
  • 24-30- 24" TO 30".
  • 26- 26".
  • 26-24- 26" TO 24".
  • 26-30- 26" TO 30".
  • 28- 28".
  • 30- 30".
  • 30-24- 30" TO 24".
  • 30-26- 30" TO 26".
  • 36- 36".
  • 42- 42".
  • 48- 48".
  • 54- 54".
Recv Maop Prss MAOPS Number Range Between 00000 and 25000
Recv Seg Num SEGMENT_NUMBERS Number Range Between 0000000 and 9999999
Prpsl Con Dt PRPSL_CON_DTS Date Range Between 01-JAN-1947 and SYSDATE+3650
Prod Code PROD_CODES Enumeration Range The Value-Description Pairs are listed below:
  • ACID- ACID.
  • AIR- PNEUMATIC.
  • BLGH- BULK GAS WITH TRACE LEVELS OF HYDROGEN SULFIDE.
  • BLKG- BULK GAS - FULL WELL STREAM PRODUCTION FROM GAS WELL(S) PRIO.
  • BLKO- BULK OIL - FULL WELL STREAM PRODUCTION FROM OIL WELL(S) PRIO.
  • BLOH- BULK OIL WITH TRACE LEVELS OF HYDROGEN SULFIDE.
  • CBLC- A NON-UMBILICAL CABLE SUCH AS FIBER OPTIC/COMMUNICATIONS.
  • CBLP- POWER CABLE.
  • CBLR- RENEWABLE ENERGY POWER CABLE.
  • CHEM- CORROSION INHIBITOR OR OTHER CHEMICALS.
  • CO2- CARBON DIOXIDE (SUPPORT ACTIVITY LEASE).
  • COND- CONDENSATE OR DISTILLATE TRANSPORTED DOWNSTREAM OF FIRST PRO.
  • CSNG- PIPELINE USED AS A PROTECTIVE CASING (CSNG) FOR ANOTHER PIPELINE..
  • FLG- FLARE GAS.
  • G/C- GAS AND CONDENSATE SERVICE AFTER FIRST PROCESSING.
  • G/CH- GAS AND CONDENSATE (H2S).
  • G/O- GAS AND OIL SERVICE AFTER FIRST PROCESSING.
  • G/OH- GAS AND OIL (H2S).
  • GAS- GAS TRANSPORTED AFTER FIRST PROCESSING.
  • GASH- PROCESSED GAS WITH TRACE LEVELS OF HYDROGEN SULFIDE.
  • H2O- WATER.
  • INJ- GAS INJECTION.
  • LGER- LIQUID GAS ENHANCED RECOVERY.
  • LIFT- GAS LIFT.
  • LPRO- LIQUID PROPANE.
  • METH- METHANOL / GLYCOL.
  • NGER- NATURAL GAS ENHANCED RECOVERY.
  • NGL- Natural Gas Liquids.
  • O/W- OIL AND WATER TRANSPORTED AFTER FIRST PROCESSING.
  • OIL- OIL TRANSPORTED AFTER FIRST PROCESSING.
  • OILH- PROCESSED OIL WITH TRACE LEVELS OF HYDROGEN SULFIDE.
  • PWTR- PRESSURIZED WATER (RENEWABLE ENERGY).
  • SERV- SERVICE OR UTILITY LINE USED FOR PIGGING AND PIPELINE MAINTE.
  • SPLY- SUPPLY GAS.
  • SPRE- SPARE.
  • SULF- LIQUIFIED SULPHUR OR SLURRIED SULPHER.
  • TEST- TEST.
  • TOW- TOW ROUTE ONLY - NOT A PIPELINE.
  • UBEH- ELECTRO /HYDRAULIC UMBILICAL.
  • UMB- UMBILICAL LINE. USUALLY INCLUDES PNEUMATIC OR HYDRAULIC CONT.
  • UMBC- CHEMICAL UMBILICAL.
  • UMBE- ELECTRICAL UMBILICAL.
  • UMBH- HYDRAULIC UMBILICAL.
ROW Permittee Code MMS_COMPANY_NUMS Number Range Between 00001 and 99999
Min Wtr Dpth RANGE4 Number Range Between 0 and 9999
Max Wtr Dpth RANGE4 Number Range Between 0 and 9999
Maop Prss MAOPS Number Range Between 00000 and 25000
Cathodic Code CATHODIC_CODES Enumeration Range The Value-Description Pairs are listed below:
  • A- BRACELET ANODES.
  • B- GALVANIC PLUS RECTIFIER.
  • C- POTENTIAL READINGS REQUIRED.
  • N- NONE.
  • P- PLATFORM ANODES.
  • R- RECTIFIER.
Bidir Flag FLAG Enumeration Range The Value-Description Pairs are listed below:
  • N- No.
  • Y- Yes.
Bd Ppl Fsv Fl FLAG Enumeration Range The Value-Description Pairs are listed below:
  • N- No.
  • Y- Yes.
Aprv Code APRV_CODES Enumeration Range The Value-Description Pairs are listed below:
  • L- LEASE TERM.
  • R- RIGHT-OF-WAY.
  • S- STATE.
  • U- RIGHT OF USE AND EASEMENT.
Aban Type ABAN_TYPES Enumeration Range The Value-Description Pairs are listed below:
  • INPLACE- PIPELINE REMAINS INPLACE.
  • INPLC/REMV- PIPELINE CAN EITHER BE INPLACE OR REMOVED.
  • REMOVED- PIPELINE IS REMOVED.