eWell APM Online Query Field Definitions

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



Field Name 
Data Type 
Field Length 
Definition 
SN_APD NUMBER22Autogenerated sequence number which uniquely identifies each instance of an Application for Permit to Drill (APD).
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.
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.
WELL_NAME VARCHAR218 The name assigned to the well. It may be a special name or the name of the property to which the well belongs.
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.
WATER_DEPTH NUMBER22The depth of the water at a well/platform location from the water level to the mud line.
PRP_RKB_ELEV NUMBER22The distance from the drilling rig's kelly bushing to mean sea level for a well proposed in a plan submittal.
MINERAL_CODE VARCHAR23Indicates the primary mineral for which the well is drilled.
REQ_SPUD_DATE DATE7Requested spud date of the wellbore listed on the Application for Permit to Drill (APD).
SUBSEA_BOP_FLAG VARCHAR23Indicates whether a subsea blowout preventor will be used for the proposed well described in an Application for Permit to Drill (APD).
WELL_TYPE_CODE VARCHAR245Indicates the final classification of a borehole denoting the purpose of the drilling.
DRIVE_DEPTH NUMBER22Setting depth of the drive pipe as specified on the Application for Permit to Drill (APD).
DRIVE_SIZE NUMBER22The outside diameter of the drive pipe as specified on the Application for Permit to Drill (APD)
SURF_AREA_CODE VARCHAR26The indicator used to identify an area name.
SURF_BLOCK_NUMBER VARCHAR218Identifies a subdivision of an Official Protraction Diagram\ as applied to the subdivision containing the surface location of a well.
SURF_LEASE_NUMBER VARCHAR221 The number assigned to a lease by the regulatory agency having jurisdiction over mineral activity in the territory where the lease is located.
SURF_X_COORD_LOC NUMBER22X coordinate for a surface location (east-west measurement).
SURF_Y_COORD_LOC NUMBER22Y coordinate for a surface location (north-south measurement).
SURF_LATITUDE NUMBER22The latitude value of a location in the borehole. A positive value denotes north. Angle subtended with equatorial plane by a perpendicular from a point on the surface of a spheriod.
SURF_LONGITUDE NUMBER22The longitude value of a location in a borehole. A positive value denotes east. Angle measured about the spheroid axis from a local prime meridian to the meridian through the point.
SURF_E_W_CODE VARCHAR23East/West descriptor that indicates the direction of a measurement from an identifiable line./Indicates whether the surface borehole location is measured from either the east (E) or west (W) block boundary.
SURF_N_S_CODE VARCHAR23North/South descriptor that indicates the direction of a measurement from an identifiable line. /Indicates whether the surface borehole location is measured from the north (N) or south (S) block boundary.
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_NUMBER VARCHAR218Identifies a subdivision of an Official Protraction Diagram as applied to the subdivision containing the bottomhole location of a well.
BOTM_LEASE_NUMBER VARCHAR221The number assigned to the lease that contains the bottom location of a well.
RIG_NAME VARCHAR2300The name of the drilling rig, assigned by the drilling contractor.
RIG_TYPE_CODE VARCHAR24000An indicator of the type of drilling rig; e.g., land, barge, submersible, platform, jackup, drillship, semisubmersible, artifical island.
RIG_ID_NUM NUMBER22The number assigned by MMS to the drilling rig for internal identification purpose.
RIG_FUNC_CODE VARCHAR23A indicator of the purpose or function of a rig; e.g., drilling, workover.
CONSTRUCTION_YR NUMBER22The year the drilling rig was constructed.
SHIPYARD_NAME VARCHAR245The name of the shipyard where a facility was constructed.
REFURBISHED_YR NUMBER22The year that refurbishing or refitting occurred.
RATED_WTR_DEPTH NUMBER22The design specification for the maximum water depth for the utilization of a drilling rig.
RATE_DRIL_DEPTH NUMBER22The design specification for maximum drilling depth.
ABS_CERT_EXPR_DT DATE7The date the American Board of Shipping (ABS) certificate for the rig expires.
CG_CERT_EXPR_DT DATE7The date the US Coast Guard certificate for the rig expires.
SAFE_BRN_APRV_DT DATE7The date the safe burn permit for a rig was approved.
SAFE_BURN_DIST VARCHAR2300And indicator of the MMS District that approved the safe burn permit for the rig.
SAFE_BRN_RMK VARCHAR24000A remark to provide miscellaneous information about a safe burn permit for a rig.
BUS_ASC_NAME VARCHAR2300The name of a **business associate**.

Return to the eWell APD Online Query