Plan Sites Field Definitions

Data Center >> Plans >> Exploration and Development Plans Online Query >>
Plan Sites Field Definitions


Field Name 
Data Type 
Field Length 
Definition 
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_NUM VARCHAR218Identifies a subdivision of an Official Protraction Diagram as applied to the subdivision containing the bottomhole location of a well.
BOTM_LEASE_NUM VARCHAR221The number assigned to the lease that contains the bottom location of a well.
PLAN_CTRL_CD VARCHAR23An indicator of the status of the plan application.
PLAN_CTRL_NUM NUMBER22A number identifying the plan being submitted. This number is assigned by the Plans Unit.
PLAN_FNL_ACTN_CD VARCHAR23Indicates the final action was taken on a plan submittal.
PLAN_FNL_ACTN_DT DATE7Date that final action was taken on a plan submittal.
PLAN_SITE_NAME VARCHAR224Name of Plan Site
PLAN_SITE_TYPE VARCHAR29Identifies the site as either a well or a structure site.
SITE_CANCEL_DT DATE7The date approval to use a structure or well site designated in a plan is cancelled.
SURF_AREA_CODE VARCHAR26The indicator used to identify an area name.
SURF_BLOCK_NUM VARCHAR218Identifies a subdivision of an Official Protraction Diagram\ as applied to the subdivision containing the surface location of a well.
SURF_E_W_CODE VARCHAR23East/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_E_W_DIST NUMBER22East_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.
SURF_LATITUDE NUMBER22The 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_LEASE_NUM 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_LONGITUDE NUMBER22The 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_N_S_CODE VARCHAR23North/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.
SURF_N_S_DIST NUMBER22North/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.
SURF_PROJ_ZONE VARCHAR29Indicates the map projection system zone code for the surface X, Y coordinate location of the proposed well descibed in an Application for Permit to Drill (APD).
SURF_X_COORD_LOC NUMBER22X coordinate for a surface location (east-west measurement).
SURF_Y_COORD_LOC NUMBER22Y coordinate for a surface location (north-south measurement).
WATER_DEPTH NUMBER22The depth of the water at a well/platform location from the water level to the mud line.

Return to the Exploration and Development Plans Online Query