Borehole API Number Changes Online Query Field Definitions

Data Center >> Well >> Borehole API Number Changes >>
Borehole API Number Changes 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.
BH_ACTV_TYPE_CD VARCHAR29Indicates the type of borehole activity that causes a change to the Borehole record in TIMS.
PREV_API_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\as applied to the previous API well number for a well whose API well number is changed.
ACTIVITY_DATE DATE7The date that a well activity takes place.
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.
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_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.
WELL_SPUD_DATE DATE7The date that the drilling rig first begins boring into the earth's surface.
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.
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.

Return to the Borehole API Number Changes Online Query