Data Center

Data Center >>
Field Values for PIPELINE MASTERS

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.