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.

Summary File for WAR-MAINQUERY

Column Alias	Definition
SnWar	SN_WAR -Autogenerated sequence number which uniquely identifies each instance of a Weekly Activity Report (WAR).
StartDate	WAR_START_DT -The starting date of the report period for which a weekly activity report for a particular well is submitted.
EndDate	WAR_END_DT -The ending date of the report period for which a weekly activity report for a particular well is submitted.
ApiWellNumber	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.
BusAscName	BUS_ASC_NAME -The name of a **business associate**.
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.
ContactName	CONTACT_NAME -The business associate person designated as the representative for doing business with the Minerals Management Service.
PhoneNumber	PHONE_NUMBER -The telephone number associated with a particular contact.
RigName	RIG_NAME -The name of the drilling rig, assigned by the drilling contractor.
WaterDepth	WATER_DEPTH -The depth of the water at a well/platform location from the water level to the mud line.
RkbElevation	RKB_ELEVATION -The distance from the rig's kelly bushing to mean sea level.
SurfLeaseNum	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.
SurfAreaCode	SURF_AREA_CODE -The indicator used to identify an area name.
SurfBlockNum	SURF_BLOCK_NUM -Identifies a subdivision of an Official Protraction Diagram\ as applied to the subdivision containing the surface location of a well.
BotmLeaseNum	BOTM_LEASE_NUM -The number assigned to the lease that contains the bottom location of a well.
BotmAreaCode	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.
BotmBlockNum	BOTM_BLOCK_NUM -Identifies a subdivision of an Official Protraction Diagram as applied to the subdivision containing the bottomhole location of a well.
BopTestDate	BOP_TEST_DATE -The date the last test of the blowout preventer (BOP) stack was performed.
RamTestPress	RAM_TST_PRSS -The pressure measured during the test of the ram blowout preventer, expressed in pounds per square inch.
AnnularTestPress	ANNULAR_TST_PRSS -The pressure (expressed in square pounds per inch) measured during the test of the annular blowout preventer.
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.