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 VARCHAR260The 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 VARCHAR221The number used to identify the minerals lease where a pipeline originates.
DEST_ID_NAME VARCHAR260The 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 VARCHAR221The 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 VARCHAR212An indicator of the current status of the pipeline.
PPL_SIZE_CODE VARCHAR218An 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 VARCHAR212An indicator of the product being transported through a pipeline.
FACIL_OPERATOR VARCHAR215The code number to identify the operator of a facility at the time of inspection.
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 VARCHAR23An indicator of the type of cathodic protection installed on the pipeline.
ROW_STATUS_CODE VARCHAR212The status of the Right of Way.
PPL_ROW_PRMTE VARCHAR215The number assigned by the Minerals Management Service to a business entity that holds the Right-Of-Way (ROW) permit associated with the pipeline.
PRMTE_NAME VARCHAR2300The name of a **business associate**.
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_APRV_DT DATE7The date the abandonment of the pipeline was approved by the MMS office.
ABAN_DATE DATE7The date the abandonment of the pipeline was completed by the operator.

Return to the Pipeline Permits Online Query