Pipeline Segments Online Query Field Definitions

Data Center >> Pipeline >> Pipeline Permits >>
Pipeline Segments Online Query Field Definitions


Field Name
Data Type
Field Length
Definition
SEGMENT_NUM NUMBER22The number assigned by MMS to each pipeline segment for purpose of internal identification.
ORIG_ID_NAME VARCHAR290The unique name used to identify the facility where the pipeline originates.
ORIG_AR_CODE VARCHAR26The indicator of the area name in which the pipeline begins.
ORIG_BLK_NUM VARCHAR218The number used to identify the particular block in the Outer Continental Shelf (OCS) where the pipeline originates.
ORIG_LSE_NUM VARCHAR290The number used to identify the minerals lease where a pipeline originates.
DEST_ID_NAME VARCHAR290The name of the facility the end of the pipeline segment crosses or connects.
DEST_AR_CODE VARCHAR26The indicator of the area name in which the pipeline segment terminates.
DEST_BLK_NUM VARCHAR218The number used to identify the particular block in the Outer Continental Shelf (OCS) where the pipeline segment terminates.
DEST_LSE_NUM VARCHAR290The number used to identify the mineral lease where a pipeline segment terminates.
APPROVED_DATE DATE7The day, month, and year the application or permit request was approved by MMS.
INIT_HS_DT DATE7The 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.
STATUS_CODE VARCHAR290An indicator of the current status of the pipeline.
PPL_SIZE_CODE VARCHAR290An indicator of the outside diameter of the pipeline.
ROW_NUMBER VARCHAR224An identifier assigned to a pipeline approved under Title 30 CFR 250.250.
PROD_CODE VARCHAR290An indicator of the product being transported through a pipeline.
FACIL_OPERATOR VARCHAR224The code number to identify the operator of a facility at the time of inspection.
R_REGION_CODE VARCHAR290An unique identifier for the Minerals Management Service (MMS) Outer Continental Shelf
R_REGION_CODE VARCHAR290 
FACIL_OPERATOR_NAME VARCHAR2300The name of a **business associate**.
MAX_WTR_DPTH NUMBER22The greatest vertical distance from mean sea level to the sea floor.The depth of the water at the deep end of the pipeline system.
MAOP_PRSS NUMBER22The highest operating pressure allowable at any point in a system during normal flow or static conditions.
CATHODIC_CODE VARCHAR290An indicator of the type of cathodic protection installed on the pipeline.
ROW_STATUS_CODE VARCHAR2240The status of the Right of Way.
SEG_LENGTH NUMBER22The 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.
AUTHCODE VARCHAR23The indicator of the authority under which the pipeline operates.
BIDIR_FLAG VARCHAR23An indicator of whether the product in the pipeline can be passed in either direction.
ABAN_DATE DATE7The date the abandonment of the pipeline was completed by the operator.

Return to the Pipeline Permits Online Query