Borehole Online Query Field Definitions

Data Center >> Well >> Borehole Online Query >>
Borehole Online Query Field Definitions


Field Name 
Data Type 
Field Length 
Definition 
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.
WELL_NAME VARCHAR215 The name assigned to the well. It may be a special name or the name of the property to which the well belongs.
WELL_NAME_SUFFIX VARCHAR216An extension to the well name that indicates the number of times that a new wellbore has been drilled.
BOTM_LEASE_NUMBER VARCHAR221The number assigned to the lease that contains the bottom location of a well.
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.
COMPANY_NAME VARCHAR2300The name of a **business associate**.
WELL_SPUD_DATE DATE7The date that the drilling rig first begins boring into the earth's surface.
BH_TOTAL_MD VARCHAR2120The actual distance measured along the axis of the borehole from the rig kelly bushing to the depth of maximum penetration of the well.
WELL_BORE_TVD VARCHAR2120The vertical distance measured along the axis of the borehole from the rig kelly bushing to the depth of maximum depth of the well.
WELL_TD_SS VARCHAR2120The subsea TVD depth to the total depth of the borehole.
RKB_ELEVATION NUMBER22The distance from the rig's kelly bushing to mean sea level.
WELL_BP_ST_KICKOFF_MD VARCHAR2120The measured depth where a Sidetrack (ST) or Bypass (BP) borehole begins. This point is defined as being where a window has been cut in the casing of a preexisting borehole, or where a ?kick off plug? is set in any preexisting borehole. This depth is the shallowest measured depth for the borehole. There is no KOP for any borehole with an API that has 00 as its 11th and 12th numbers. Circle the appropriate type (ST or BP) of the borehole.
TOTAL_DEPTH_DATE DATE7The date drilling on a well reached the final total depth.
BOREHOLE_STAT_DT DATE7The date the borehole status becomes effective.
WELL_TYPE_CODE VARCHAR23Indicates the final classification of a borehole denoting the purpose of the drilling.
BOREHOLE_STAT_CD VARCHAR29Indicates the conditions relating to a borehole.
CASING_CUT_CODE VARCHAR23A code to indicate the method used to cut a well's casing.
WATER_DEPTH NUMBER22The depth of the water at a well/platform location from the water level to the mud line.
UNDWTR_COMP_STUB VARCHAR23Indicates the type of equipment installed on the underwater completion stub.
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_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.
BOTM_LATITUDE VARCHAR2120The 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.
BOTM_LONGITUDE VARCHAR2120The 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.

Return to the Borehole Online Query