SN_MEAS_LOC
| NUMBER | 22 | An autogenerated sequence number which uniquely identifies each instance of a measurement location record. |
FMP_NUMBER
| VARCHAR2 | 33 | The official Federal number assigned to either:(1) A facility that sells, stores, or transfers Federal production prior to or at the point of royalty determination. (2) A metering point where Federal production is measured for sales, transfers, and/or royalty determination. |
FMP_SUB_LOC_CD
| VARCHAR2 | 3 | An indicator of each measurement point sub-location for a facility/measurement point. |
FMP_LOC_NAME
| VARCHAR2 | 75 | A name used to identify the facility/measurement point location. |
FMP_NAME
| VARCHAR2 | 90 | A name used to identify the facility/measurement point. |
FMP_STATUS_CODE
| VARCHAR2 | 3 | An indicator of the status of a facility/measurement point. |
FMP_STAT_EFF_DT
| DATE | 7 | The date the facility/measurement point (fmp) status is effective. |
FMP_APPROVAL_DT
| DATE | 7 | The date that a facility/measurement point (FMP) is approved by the Minerals Management Service. |
MMS_COMPANY_NUM
| VARCHAR2 | 15 | The number assigned by the Minerals Management Service to a business entity, individual, or agency with whom MMS does business or exchanges information. |
COMGL_SYS_NUM
| VARCHAR2 | 9 | The unique identifier of a pipeline/barge commingling system. |
SN_MEAS_LOC_OUT
| NUMBER | 22 | Autogenerated sequence number which uniquely identifies each instance of a output measurement location. |
SN_MEAS_LOC_SLS
| NUMBER | 22 | Autogenerated sequence number which uniquely identifies each instance of a sales measurement location. |
COMGL_PROD_CD
| NUMBER | 22 | An indicator of the type of commingled production handled by a facility/measurement point. |
STATE_PROD_FLAG
| VARCHAR2 | 1 | An indcator of whether or not state or other non-Federal production is measured at this location. |
FMP_MEAS_TYP_CD
| VARCHAR2 | 9 | An indicator of the method of measurement at facility/measurement point. |
SORT_NAME
| VARCHAR2 | 225 | The name of the business entity doing business on the OCS used for sorting purposes. For example, The Louisana Land and Exploration Company would have a short name of LOUISIANA LAND AND EXPLORATION COMPANY, THE and therefore sort with business entities whose name begins with "L." |