eWell APM Online Query Field Definitions

Online Query Video Tutorial Data Center >> Well >> eWell APM Online Query >>
eWell APM Online Query Field Definitions



Field Name
Data Type
Field Length
Definition
MMS_COMPANY_NUM VARCHAR215The number assigned by the Minerals Management Service to a business entity, individual, or agency with whom MMS does business or exchanges information.
API_WELL_NUMBER VARCHAR236 A unique well identification number consisting of (from left to right) a two digit state code (or pseudo for Offshore), a three digit county code (or pseudo for Offshore), a five digit unique well code, and if applicable, a two digit sidetrack code as defined in API Bulletin D12A.
WATER_DEPTH NUMBER22The depth of the water at a well/platform location from the water level to the mud line.
WELL_NM_BP_SFIX VARCHAR26A 2 digit numerical suffix to the well number that identifies the number of times that a specific segment of a wellbore has been re-drilled to the same geologic objective.
WELL_NM_ST_SFIX VARCHAR26A 2 digit numerical suffix to the well number that identifies the number of times a well has been drilled to a new geologic objective.
SURF_AREA_CODE VARCHAR26The indicator used to identify an area name.
SURF_BLOCK_NUM VARCHAR218Identifies a subdivision of an Official Protraction Diagram\ as applied to the subdivision containing the surface location of a well.
SURF_LEASE_NUM VARCHAR221 The number assigned to a lease by the regulatory agency having jurisdiction over mineral activity in the territory where the lease is located.
BOTM_AREA_CODE VARCHAR26The designated abbreviation assigned to Outer Continental Shelf (OCS) geographical units for identification purposes and for use on maps and in data bases as applied to the bottomhole location of a well.
BOTM_BLOCK_NUM VARCHAR218Identifies a subdivision of an Official Protraction Diagram as applied to the subdivision containing the bottomhole location of a well.
BOTM_LEASE_NUM VARCHAR221The number assigned to the lease that contains the bottom location of a well.
RIG_ID_NUM NUMBER22The number assigned by MMS to the drilling rig for internal identification purpose.
BOREHOLE_STAT_CD VARCHAR29Indicates the conditions relating to a borehole.
WELL_TYPE_CODE VARCHAR23Indicates the final classification of a borehole denoting the purpose of the drilling.
BUS_ASC_NAME VARCHAR2300The name of a **business associate**.

Return to the eWell APM Online Query