Data Center

Data Center >>
Field Values for PACIFIC PIPELINE MASTERS

Field Values 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.
  • 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.
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