The GOMR.BOEMRE.GOV website is no longer being updated. In its place, BOEM.GOV and BSEE.GOV have been launched. Over the next several weeks, the appropriate content from the GOMR.BOEMRE.GOV website will be moved to the new sites.

Field Definitions for BOREHOLE - RELEASABLE

Click on hyperlinked Column Aliases to show possible values.

Column Alias	Definition
APIWellNumber	API_WELL_NUMBER - 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.
WellName	WELL_NAME - The name assigned to the well. It may be a special name or the name of the property to which the well belongs.
WellNameSuffix	WELL_NAME_SUFFIX -An extension to the well name that indicates the number of times that a new wellbore has been drilled.
BottomLeaseNumber	BOTM_LEASE_NUM -The number assigned to the lease that contains the bottom location of a well.
BottomArea	BOTM_AREA_CODE -The 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.
BottomBlock	BOTM_BLOCK_NUM -Identifies a subdivision of an Official Protraction Diagram as applied to the subdivision containing the bottomhole location of a well.
CompanyName	BUS_ASC_NAME -The name of a **business associate**.
SpudDate	WELL_SPUD_DATE -The date that the drilling rig first begins boring into the earth's surface.
BHTotalMD	This field is derived from the expression... decode(bv.public_release_flag, 'Y', to_char(BV.bh_total_md), '*****') ...and consists of these database columns: public_release_flag - Indicates whether or not the record contained in a database table is releasable to the public. bh_total_md - The actual distance measured along the axis of the borehole from the rig kelly bushing to the depth of maximum penetration of the well.
TrueVerticalDepth	This field is derived from the expression... decode(bv.public_release_flag, 'Y', to_char(BV.well_bore_tvd), '*****') ...and consists of these database columns: public_release_flag - Indicates whether or not the record contained in a database table is releasable to the public. well_bore_tvd - The vertical distance measured along the axis of the borehole from the rig kelly bushing to the depth of maximum depth of the well.
TotalDepthDate	TOTAL_DEPTH_DATE -The date drilling on a well reached the final total depth.
StatusDate	BOREHOLE_STAT_DT -The date the borehole status becomes effective.
TypeCode	WELL_TYPE_CODE -Indicates the final classification of a borehole denoting the purpose of the drilling.
StatusCode	BOREHOLE_STAT_CD -Indicates the conditions relating to a borehole.
WaterDepth	WATER_DEPTH -The depth of the water at a well/platform location from the water level to the mud line.
BlockLookup	BOTM_BLOCK_NUM -Identifies a subdivision of an Official Protraction Diagram as applied to the subdivision containing the bottomhole location of a well.
UnderwaterCompStub	UNDWTR_COMP_STUB -Indicates the type of equipment installed on the underwater completion stub.
SurfaceLatitude	SURF_LATITUDE -The 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.
SurfaceLongitude	SURF_LONGITUDE -The 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.
RkbElevation	RKB_ELEVATION -The distance from the rig's kelly bushing to mean sea level.
WellBpStKickoffMd	This field is derived from the expression... decode(bv.public_release_flag, 'Y', to_char(BV.WELL_BP_ST_KICKOFF_MD), '*****') ...and consists of these database columns: public_release_flag - Indicates whether or not the record contained in a database table is releasable to the public. WELL_BP_ST_KICKOFF_MD - The 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.
SurfLeaseNum	SURF_LEASE_NUM - The number assigned to a lease by the regulatory agency having jurisdiction over mineral activity in the territory where the lease is located.
BotmLatitude	This field is derived from the expression... decode(bv.public_release_flag, 'Y', to_char(BV.BOTM_LATITUDE), '*****') ...and consists of these database columns: public_release_flag - Indicates whether or not the record contained in a database table is releasable to the public. BOTM_LATITUDE - The 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.
BotmLongitude	This field is derived from the expression... decode(bv.public_release_flag, 'Y', to_char(BV.BOTM_LONGITUDE), '*****') ...and consists of these database columns: public_release_flag - Indicates whether or not the record contained in a database table is releasable to the public. BOTM_LONGITUDE - The 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.