Data Center

Data Center >>
Field Definitions for PACIFIC PIPELINE MASTERS

Field Definitions for PACIFIC PIPELINE MASTERS

Click on hyperlinked Column Aliases to show possible values.

The Start Position Column is used for fixed dumps only. Click on the column alias for a valid list of values or codes associated with the element selected.

Start
Position		 Item
Length		 Column
Alias		 Definition
1 8 Segment Num SEGMENT_NUM -The number assigned by MMS to each pipeline segment for purpose of internal identification.
9 8 Seg Length SEG_LENGTH -The length, in feet, of the Federal portion of the pipeline segment. The measurement is taken from the beginning of the pipeline segment and ends at the seaward extent of the coastal State's territorial sea.
17 20 Orig Id Name ORIG_ID_NAME -The unique name used to identify the facility where the pipeline originates.
37 2 Orig Ar Code ORIG_AR_CODE -The indicator of the area name in which the pipeline begins.
39 6 Orig Blk Num ORIG_BLK_NUM -The number used to identify the particular block in the Outer Continental Shelf (OCS) where the pipeline originates.
45 7 Orig Lse Num ORIG_LSE_NUM -The number used to identify the minerals lease where a pipeline originates.
52 20 Dest Id Name DEST_ID_NAME -The name of the facility the end of the pipeline segment crosses or connects.
72 2 Dest Ar Code DEST_AR_CODE -The indicator of the area name in which the pipeline segment terminates.
74 6 Dest Blk Num DEST_BLK_NUM -The number used to identify the particular block in the Outer Continental Shelf (OCS) where the pipeline segment terminates.
80 7 Dest Lse Num DEST_LSE_NUM -The number used to identify the mineral lease where a pipeline segment terminates.
87 8 Aban Aprv Dt ABAN_APRV_DT -The date the abandonment of the pipeline was approved by the MMS office.
95 8 Aban Date ABAN_DATE -The date the abandonment of the pipeline was completed by the operator.
103 8 Approved Date APPROVED_DATE -The day, month, and year the application or permit request was approved by MMS.
111 1 Auth Code AUTH_CODE -The indicator of the authority under which the pipeline operates.
112 1 Bd Ppl Sdv Fl BD_PPL_SDV_FL -An indicator of whether a boarding pipeline has a shut down valve (SDV) installed and operational.
113 1 Bur Dsgn Fl BUR_DSGN_FL -An indicator of whether a pipeline was buried at the time of installation.
114 4 Cat Life Tm CAT_LIFE_TM -The length of time the pipeline cathodic protection is expected to be effective.
118 1 Dep Flag DEP_FLAG -An indicator of the direction of flow of the pipeline segment.
119 8 Ppl Const Date PPL_CONST_DATE -The day, month, and year the pipeline was built.
127 1 Lk Detec Fl LK_DETEC_FL -An indicator of whether a pipeline has a leak detection system installed and operational.
128 8 Last Rev Date LAST_REV_DATE -Date a row in the database was last updated.
136 8 Init Hs Dt INIT_HS_DT -The day, month, and year the first hydrostatic (HS) test is performed. Hydrostatic testing involves filling a pipeline with water under pressure to test the pipeline tensile strength or its ability to hold a certain pressure.
144 8 Fed St Lgth FED_ST_LGTH -The length of pipeline which lies within the outer Continental Shelf (Federal jurisdiction) and a coastal State's territorial sea up to the shoreline (State jurisdiction).
152 4 Status Code STATUS_CODE -An indicator of the current status of the pipeline.
156 6 Ppl Size Code PPL_SIZE_CODE -An indicator of the outside diameter of the pipeline.
162 8 Row Number ROW_NUMBER -An identifier assigned to a pipeline approved under Title 30 CFR 250.250.
170 6 Recv Maop Prss RECV_MAOP_PRSS -The highest operating pressure allowable in the receiving pipeline during normal flow or static conditions.
176 8 Recv Seg Num RECV_SEG_NUM -The segment number of the pipeline that is connected to the current pipeline which receives the product for transportation to another point.
184 8 Prpsl Con Dt PRPSL_CON_DT -The day, month, and year the operator has proposed to construct the pipeline segment.
192 4 Prod Code PROD_CODE -An indicator of the product being transported through a pipeline.
196 4 Sys Desig Code SYS_DESIG_CODE -An indicator of the MMS' commingling system the pipeline is part of.
200 5 Facil Operator FACIL_OPERATOR -The code number to identify the operator of a facility at the time of inspection.
205 5 Min Wtr Dpth MIN_WTR_DPTH -The least vertical distance from mean sea level to the sea floor at the shallow part of the pipeline.
210 5 Max Wtr Dpth MAX_WTR_DPTH -The greatest vertical distance from mean sea level to the sea floor.The depth of the water at the deep end of the pipeline system.
215 7 Prot Number PROT_NUMBER -The identifier of an official protraction, which can be one of two types as utilized by the Minerals Management Service (MMS): an Official Protraction Diagram (OPD) or Leasing Map.
222 6 Maop Prss MAOP_PRSS -The highest operating pressure allowable at any point in a system during normal flow or static conditions.
228 1 Cathodic Code CATHODIC_CODE -An indicator of the type of cathodic protection installed on the pipeline.
229 1 Bidir Flag BIDIR_FLAG -An indicator of whether the product in the pipeline can be passed in either direction.
230 1 Bd Ppl Fsv Fl BD_PPL_FSV_FL -An indicator of whether a boarding pipeline has a flow safety valve (FSV) installed and operational.
231 1 Aprv Code APRV_CODE -An indicator of whether the pipeline segment was approved under lease terms or right-of-way.
232 10 Aban Type ABAN_TYPE -The method used to abandon the pipeline segment.
242 8 INIT DATE INIT_HS_DT -The day, month, and year the first hydrostatic (HS) test is performed. Hydrostatic testing involves filling a pipeline with water under pressure to test the pipeline tensile strength or its ability to hold a certain pressure.