SN_APD
| NUMBER | 22 | Autogenerated sequence number which uniquely identifies each instance of an Application for Permit to Drill (APD). |
API_WELL_NUMBER
| VARCHAR2 | 36 | 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. |
MMS_COMPANY_NUM
| VARCHAR2 | 15 | The number assigned by the Minerals Management Service to a business entity, individual, or agency with whom MMS does business or exchanges information. |
WELL_NAME
| VARCHAR2 | 18 | The name assigned to the well. It may be a special name or the name of the property to which the well belongs. |
WELL_NM_BP_SFIX
| VARCHAR2 | 6 | 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.
|
WELL_NM_ST_SFIX
| VARCHAR2 | 6 | 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. |
WATER_DEPTH
| NUMBER | 22 | The depth of the water at a well/platform location from the water level to the mud line. |
PRP_RKB_ELEV
| NUMBER | 22 | The distance from the drilling rig's kelly bushing to mean sea level for a well proposed in a plan submittal. |
MINERAL_CODE
| VARCHAR2 | 3 | Indicates the primary mineral for which the well is drilled. |
REQ_SPUD_DATE
| DATE | 7 | Requested spud date of the wellbore listed on the Application for Permit to Drill (APD). |
SUBSEA_BOP_FLAG
| VARCHAR2 | 3 | Indicates whether a subsea blowout preventor will be used for the proposed well described in an Application for Permit to Drill (APD). |
WELL_TYPE_CODE
| VARCHAR2 | 45 | Indicates the final classification of a borehole denoting the purpose of the drilling. |
DRIVE_DEPTH
| NUMBER | 22 | Setting depth of the drive pipe as specified on the Application for Permit to Drill (APD). |
DRIVE_SIZE
| NUMBER | 22 | The outside diameter of the drive pipe as specified on the Application for Permit to Drill (APD) |
SURF_AREA_CODE
| VARCHAR2 | 6 | The indicator used to identify an area name. |
SURF_BLOCK_NUMBER
| VARCHAR2 | 18 | Identifies a subdivision of an Official Protraction Diagram\ as applied to the subdivision containing the surface location of a well. |
SURF_LEASE_NUMBER
| VARCHAR2 | 21 | The number assigned to a lease by the regulatory agency having jurisdiction over mineral activity in the territory where the lease is located. |
SURF_X_COORD_LOC
| NUMBER | 22 | X coordinate for a surface location (east-west measurement). |
SURF_Y_COORD_LOC
| NUMBER | 22 | Y coordinate for a surface location (north-south measurement). |
SURF_LATITUDE
| NUMBER | 22 | 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. |
SURF_LONGITUDE
| NUMBER | 22 | 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. |
SURF_E_W_CODE
| VARCHAR2 | 3 | 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. |
SURF_N_S_CODE
| VARCHAR2 | 3 | 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. |
BOTM_AREA_CODE
| VARCHAR2 | 6 | 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. |
BOTM_BLOCK_NUMBER
| VARCHAR2 | 18 | Identifies a subdivision of an Official Protraction Diagram as applied to the subdivision containing the bottomhole location of a well. |
BOTM_LEASE_NUMBER
| VARCHAR2 | 21 | The number assigned to the lease that contains the bottom location of a well. |
RIG_NAME
| VARCHAR2 | 300 | The name of the drilling rig, assigned by the drilling contractor. |
RIG_TYPE_CODE
| VARCHAR2 | 4000 | An indicator of the type of drilling rig; e.g., land, barge, submersible, platform, jackup, drillship, semisubmersible, artifical island. |
RIG_ID_NUM
| NUMBER | 22 | The number assigned by MMS to the drilling rig for internal identification purpose. |
RIG_FUNC_CODE
| VARCHAR2 | 3 | A indicator of the purpose or function of a rig; e.g., drilling, workover. |
CONSTRUCTION_YR
| NUMBER | 22 | The year the drilling rig was constructed. |
SHIPYARD_NAME
| VARCHAR2 | 45 | The name of the shipyard where a facility was constructed. |
REFURBISHED_YR
| NUMBER | 22 | The year that refurbishing or refitting occurred. |
RATED_WTR_DEPTH
| NUMBER | 22 | The design specification for the maximum water depth for the utilization of a drilling rig. |
RATE_DRIL_DEPTH
| NUMBER | 22 | The design specification for maximum drilling depth. |
ABS_CERT_EXPR_DT
| DATE | 7 | The date the American Board of Shipping (ABS) certificate for the rig expires. |
CG_CERT_EXPR_DT
| DATE | 7 | The date the US Coast Guard certificate for the rig expires. |
SAFE_BRN_APRV_DT
| DATE | 7 | The date the safe burn permit for a rig was approved. |
SAFE_BURN_DIST
| VARCHAR2 | 300 | And indicator of the MMS District that approved the safe burn permit for the rig. |
SAFE_BRN_RMK
| VARCHAR2 | 4000 | A remark to provide miscellaneous information about a safe burn permit for a rig. |
BUS_ASC_NAME
| VARCHAR2 | 300 | The name of a **business associate**. |