|
SEGMENT_NUM
| NUMBER | 22 | The number assigned by MMS to each pipeline segment for purpose of internal identification. |
|
ORIG_ID_NAME
| VARCHAR2 | 90 | The unique name used to identify the facility where the pipeline originates. |
|
ORIG_AR_CODE
| VARCHAR2 | 6 | The indicator of the area name in which the pipeline begins. |
|
ORIG_BLK_NUM
| VARCHAR2 | 18 | The number used to identify the particular block in the Outer Continental Shelf (OCS) where the pipeline originates. |
|
ORIG_LSE_NUM
| VARCHAR2 | 90 | The number used to identify the minerals lease where a pipeline originates. |
|
DEST_ID_NAME
| VARCHAR2 | 90 | The name of the facility the end of the pipeline segment crosses or connects. |
|
DEST_AR_CODE
| VARCHAR2 | 6 | The indicator of the area name in which the pipeline segment terminates. |
|
DEST_BLK_NUM
| VARCHAR2 | 18 | The number used to identify the particular block in the Outer Continental Shelf (OCS) where the pipeline segment terminates. |
|
DEST_LSE_NUM
| VARCHAR2 | 90 | The number used to identify the mineral lease where a pipeline segment terminates. |
|
APPROVED_DATE
| DATE | 7 | The day, month, and year the application or permit request was approved by MMS. |
|
INIT_HS_DT
| DATE | 7 | 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. |
|
STATUS_CODE
| VARCHAR2 | 90 | An indicator of the current status of the pipeline. |
|
PPL_SIZE_CODE
| VARCHAR2 | 90 | An indicator of the outside diameter of the pipeline. |
|
ROW_NUMBER
| VARCHAR2 | 24 | An identifier assigned to a pipeline approved under Title 30 CFR 250.250. |
|
PROD_CODE
| VARCHAR2 | 90 | An indicator of the product being transported through a pipeline. |
|
FACIL_OPERATOR
| VARCHAR2 | 24 | The code number to identify the operator of a facility at the time of inspection. |
|
R_REGION_CODE
| VARCHAR2 | 90 | An unique identifier for the Minerals Management Service (MMS) Outer Continental Shelf |
|
R_REGION_CODE
| VARCHAR2 | 90 | |
|
FACIL_OPERATOR_NAME
| VARCHAR2 | 300 | The name of a **business associate**. |
|
MAX_WTR_DPTH
| NUMBER | 22 | 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. |
|
MAOP_PRSS
| NUMBER | 22 | The highest operating pressure allowable at any point in a system during normal flow or static conditions. |
|
CATHODIC_CODE
| VARCHAR2 | 90 | An indicator of the type of cathodic protection installed on the pipeline. |
|
ROW_STATUS_CODE
| VARCHAR2 | 240 | The status of the Right of Way. |
|
SEG_LENGTH
| NUMBER | 22 | 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. |
|
AUTHCODE
| VARCHAR2 | 3 | The indicator of the authority under which the pipeline operates. |
|
BIDIR_FLAG
| VARCHAR2 | 3 | An indicator of whether the product in the pipeline can be passed in either direction. |
|
ABAN_DATE
| DATE | 7 | The date the abandonment of the pipeline was completed by the operator. |
