Questions? Need More Information?
This page last updated: March 02, 2009
Domain File for PACIFIC 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.
CHEM- CORROSION INHIBITOR OR OTHER CHEMICALS.
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.
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.
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.
INIT DATE
GENERAL_DATES
Date Range
Between 01-JAN-1947 and SYSDATE+10
Privacy
|
Disclaimers
|
Accessibility
Home
|
Search
|
Topic Index
|
About MMS
|
What's New
|
Press Releases/Reports
Upcoming Events
|
Fast Facts
|
Products/Free Data
|
Deep Gas
|
Offshore Info
|
Lease Info
Environmental Info
|
Production Info
|
Hurricane Info
|
Online Ordering System
|
P.I. Data System
MMS Ocean Science
|
OEMM e-Gov
|
Forms
|
Jobs
|
Kid's Page
|
FOIA
|
Info Quality Guidelines
E-Mail Subscriptions
|
Navigation
|
Contact Us