Summary File for APDFORM(ACCESS)

Summary File for APDFORM(ACCESS)

Column
Alias
Definition
PermitID SN_APD -Autogenerated sequence number which uniquely identifies each instance of an Application for Permit to Drill (APD).
ApiWellNum 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.
MmsCompanyNum MMS_COMPANY_NUM -The number assigned by the Minerals Management Service to a business entity, individual, or agency with whom MMS does business or exchanges information.
KickoffPoint KICKOFF_POINT_MD -The measured depth at which a sidetrack or bypass wellbore is deviated from the original wellbore.
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.
WellNameBPSuffix WELL_NM_BP_SFIX -A 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.
WellNameSTSuffix WELL_NM_ST_SFIX -A 2 digit numerical suffix to the well number that identifies the number of times a well has been drilled to a new geologic objective.
WaterDepth WATER_DEPTH -The depth of the water at a well/platform location from the water level to the mud line.
PermitType PERMIT_TYPE -The type of permit
PrpRkbElev PRP_RKB_ELEV -The propsoed distance from the rig's kelly bushing to mean sea level.
MineralCode MINERAL_CODE -Indicates the primary mineral for which the well is drilled.
ReqSpudDate REQ_SPUD_DATE -Requested spud date of the wellbore listed on the Application for Permit to Drill (APD).
SubseaBopFlag SUBSEA_BOP_FLAG -Indicates whether a subsea blowout preventor will be used for the proposed well described in an Application for Permit to Drill (APD).
WellTypeCode WELL_TYPE_CODE -Indicates the final classification of a borehole denoting the purpose of the drilling.
SurfAreaCode AREA_CODE -The indicator used to identify an area name.
SurfBlockNum BLOCK_NUMBER -Identifies a subdivision of an Official Protraction Diagram\ as applied to the subdivision containing the surface location of a well.
SurfLeaseNum LEASE_NUMBER -The federal lease number of the surface.
SurfStateLeaseNum STATE_LEASE_NUM -State Lease number if the well was drilled from a state lease into Federal waters
SurfXCoordLoc X_COORD_LOC -X coordinate for a surface location (east-west measurement).
SurfYCoordLoc Y_COORD_LOC -Y coordinate for a surface location (north-south measurement)./td>
SurfLatitude 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.
SurfLongitude 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.
SurfEWDistance E_W_DISTANCE -East_West footage or distance that represents the length of a measurement from an identifiable line./The distance from the borehole surface location to either the east or west block boundary.
SurfEWCode E_W_CODE -East/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.
SurfNSDistance N_S_DISTANCE -North/South footage or distance that represents the length of a measurement from an identifiable line. /The distance from the borehole surface location to either the north or south block boundary.
SurfNSCode N_S_CODE -North/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.
BotmAreaCode 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.
BotmBlockNum BLOCK_NUMBER -Identifies a subdivision of an Official Protraction Diagram as applied to the subdivision containing the bottomhole location of a well.
BotmLeaseNum LEASE_NUMBER -The number assigned to the lease that contains the bottom location of a well.
BotmStateLeaseNum STATE_LEASE_NUM -The number assigned to the lease that contains the bottom location of a well in State Waters.
SVPlanControlCode PLAN_CTRL_CD -An indicator of the stage of the plan application.
SVPlanControlNum PLAN_CTRL_NUM -A number identifying the plan being submitted. This number is assigned by the Plans Unit.
SVLeaseNum 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.
SVAreaCode SURF_AREA_CODE -The indicator used to identify an area name.
SVBlockNum SURF_BLOCK_NUM -Identifies a subdivision of an Official Protraction Diagram\ as applied to the subdivision containing the surface location of a well.
SVWellName 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.
BVPlanControlCode PLAN_CTRL_CD -An indicator of the stage of the plan application.
BVPlanControlNum PLAN_CTRL_NUM -A number identifying the plan being submitted. This number is assigned by the Plans Unit.
BVLeaseNum BOTM_LEASE_NUM -The number assigned to the lease that contains the bottom location of a well.
BVAreaCode 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.
BVBlockNum BOTM_BLOCK_NUM -Identifies a subdivision of an Official Protraction Diagram as applied to the subdivision containing the bottomhole location of a well.
BVWellName 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.
RigAnchorFlag RIG_ANCHOR_FLAG -An flag to indicate if the rig will need anchors.
RigName RIG_NAME -The name of the drilling rig, assigned by the drilling contractor.
RigTypeCode RIG_TYPE_CODE -An indicator of the type of drilling rig; e.g., land, barge, submersible, platform, jackup, drillship, semisubmersible, artifical island.
RigIdNum RIG_ID_NUM -The number assigned by MMS to the drilling rig for internal identification purpose.
RigFuncCode RIG_FUNC_CODE -indicator of the purpose or function of a rig; e.g., drilling, workover.
ConstructionYear CONSTRUCTION_YR -The year the drilling rig was constructed.
ShipyardName SHIPYARD_NAME -The name of the shipyard where a facility was constructed.
RefurbishedYear REFURBISHED_YR -The year that refurbishing or refitting occurred.
RatedWaterDepth RATED_WTR_DEPTH -The design specification for the maximum water depth for the utilization of a drilling rig.
RatedDrillDepth RATE_DRIL_DEPTH -The design specification for maximum drilling depth.
AbsCertExprDate ABS_CERT_EXPR_DT -The date the American Board of Shipping (ABS) certificate for the rig expires.
CGCertExprDate CG_CERT_EXPR_DT -The date the American Board of Shipping (ABS) certificate for the rig expires.
SafeBurnAprvDate SAFE_BRN_APRV_DT -The date the safe burn permit for a rig was approved.
SafeBurnDistrict SAFE_BURN_DIST -And indicator of the MMS District that approved the safe burn permit for the rig.
SafeBurnRemark SAFE_BRN_RMK -remark to provide miscellaneous information about a safe burn permit for a rig.
BusAscName BUS_ASC_NAME -The name of the operator submitting the application
SubDate APD_STATUS_DT -Date the application was originally submitted
AppDate APD_APRV_DT -Date the application was approved.