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 APDFORM(ACCESS)

Click on hyperlinked Column Aliases to show possible values.

Column Alias	Definition
PermitID	SN_APD -Unknown
ApiWellNum	API_WELL_NUMBER -Unknown
MmsCompanyNum	MMS_COMPANY_NUM -Unknown
KickoffPoint	KICKOFF_POINT_MD -Unknown
WellName	WELL_NAME -Unknown
WellNameBPSuffix	WELL_NM_BP_SFIX -Unknown
WellNameSTSuffix	WELL_NM_ST_SFIX -Unknown
WaterDepth	WATER_DEPTH -Unknown
PermitType	PERMIT_TYPE -Unknown
PrpRkbElev	PRP_RKB_ELEV -Unknown
MineralCode	MINERAL_CODE -Unknown
ReqSpudDate	REQ_SPUD_DATE -Unknown
SubseaBopFlag	SUBSEA_BOP_FLAG -Unknown
WellTypeCode	WELL_TYPE_CODE -Unknown
SurfAreaCode	AREA_CODE -Unknown
SurfBlockNum	BLOCK_NUMBER -Unknown
SurfLeaseNum	LEASE_NUMBER -Unknown
SurfStateLeaseNum	STATE_LEASE_NUM -Unknown
SurfXCoordLoc	X_COORD_LOC -Unknown
SurfYCoordLoc	Y_COORD_LOC -Unknown
SurfLatitude	LATITUDE -Unknown
SurfLongitude	LONGITUDE -Unknown
SurfEWDistance	E_W_DISTANCE -Unknown
SurfEWCode	E_W_CODE -Unknown
SurfNSDistance	N_S_DISTANCE -Unknown
SurfNSCode	N_S_CODE -Unknown
BotmAreaCode	AREA_CODE -Unknown
BotmBlockNum	BLOCK_NUMBER -Unknown
BotmLeaseNum	LEASE_NUMBER -Unknown
BotmStateLeaseNum	STATE_LEASE_NUM -Unknown
SVPlanControlCode	PLAN_CTRL_CD -Unknown
SVPlanControlNum	PLAN_CTRL_NUM -Unknown
SVLeaseNum	SURF_LEASE_NUM -Unknown
SVAreaCode	SURF_AREA_CODE -Unknown
SVBlockNum	SURF_BLOCK_NUM -Unknown
SVWellName	WELL_NAME -Unknown
BVPlanControlCode	PLAN_CTRL_CD -Unknown
BVPlanControlNum	PLAN_CTRL_NUM -Unknown
BVLeaseNum	BOTM_LEASE_NUM -Unknown
BVAreaCode	BOTM_AREA_CODE -Unknown
BVBlockNum	BOTM_BLOCK_NUM -Unknown
BVWellName	WELL_NAME -Unknown
RigAnchorFlag	RIG_ANCHOR_FLAG -Unknown
RigName	RIG_NAME -Unknown
RigTypeCode	RIG_TYPE_CODE -Unknown
RigIdNum	RIG_ID_NUM -Unknown
RigFuncCode	RIG_FUNC_CODE -Unknown
ConstructionYear	CONSTRUCTION_YR -Unknown
ShipyardName	SHIPYARD_NAME -Unknown
RefurbishedYear	REFURBISHED_YR -Unknown
RatedWaterDepth	RATED_WTR_DEPTH -Unknown
RatedDrillDepth	RATE_DRIL_DEPTH -Unknown
AbsCertExprDate	ABS_CERT_EXPR_DT -Unknown
CGCertExprDate	CG_CERT_EXPR_DT -Unknown
SafeBurnAprvDate	SAFE_BRN_APRV_DT -Unknown
SafeBurnDistrict	SAFE_BURN_DIST -Unknown
SafeBurnRemark	SAFE_BRN_RMK -Unknown
BusAscName	BUS_ASC_NAME -Unknown
SubDate	APD_STATUS_DT -Unknown
AppDate	APD_STATUS_DT -Unknown