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_STATUS_DT -Date the application was originally submitted |