Topic Indices and Site Maps Search - Bureau of Ocean Energy Management, Regulation and Enforcement Home - Bureau of Ocean Energy Management, Regulation and Enforcement Bureau of Ocean Energy Management, Regulation and Enforcement
Bureau of Ocean Energy Management, Regulation, and Enforcement (BOEMRE)
About BOEMRE
Newsroom
FAQ
Renewable Energy Program
Offshore Energy and Minerals Management Program Home Page.
Environmental Stewardship
Research

Library
Kids' Page
 Pipeline Open Access
GOMESA Revenue Sharing
Public Engagement
Contact UsSpacer ImageAlaska Region
Atlantic
Gulf of Mexico
Pacific RegionSpacer Image

Hot Topics:

Spacer Image


  Contact:
    Public Affairs
  
 Navy Spacer

 

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 Values for BOREHOLE API CHANGES (ACCESS)

Column
Alias Name		 Domain
Name		 Domain
Type		 Valid Value
Description
BhActvTypeCd BH_ACTV_TYPE_CDS Enumeration Range The Value-Description Pairs are listed below:
  • API- API well number change.
  • BLS- Bottom lease number change.
  • LBC- Location change - Bottom Cadastral.
  • LBS- Location change - Bottom Submitted.
  • LSC- Location change - Surface Cadastral.
  • LSE- Lease number change.
  • LSS- NAD 83 Surface Location change - Submitted.
  • ODO- Original Drilling Operator.
  • OPC- Oper change-bottom lease, district.
  • OPH- Oper change-bottom lease, as a part of historical well data cleanup process.
  • OPR- Oper change-bottom lease, leasing.
  • OSD- Oper change-surface lease, district.
  • OSL- Oper change-surface lease, leasing.
  • OWN- Original Well Name.
  • PRF- Public Release Flag Change.
  • RKB- Rig kelly bushing change.
  • SLS- Surface lease number change.
  • STA- Well status change.
  • TMD- Total measured depth change.
  • TVD- True vertical depth change.
  • WLN- Well name change.
ActivityDate GENERAL_DATES Date Range Between 01-JAN-1947 and SYSDATE+10
SurfAreaCode 0059 Enumeration Range The Value-Description Pairs are listed below:
  • AC- MINOS CANYON 60.
  • AM- AMERY TERRACE.
  • AP- APALACHICOLA 60.
  • AT- ATWATER * 60.
  • BA- BRAZOS AREA 42.
  • BM- BAY MARCHAND AREA 17.
  • BS- BRETON SOUND AREA 17.
  • CA- CHANDELEUR AREA 17.
  • CC- CORPUS CHRISTI 60.
  • CE- CAMPECHE ESCARPMENT.
  • CH- CHARLOTTE HARBOR 60.
  • CP- COON POINT (THIS IS A FIELD) 17.
  • CS- CHANDELEUR SOUND 17.
  • DC- DESOTO CANYON 60.
  • DD- DESTIN DOME 60.
  • DT- DRY TORTUGAS 60.
  • EB- EAST BREAKS 60.
  • EC- EAST CAMERON AREA 17.
  • EI- EUGENE ISLAND AREA 17.
  • EL- THE ELBOW 60.
  • EW- EWING BANK 60.
  • FM- FLORIDA MIDDLE GROUND 60.
  • FP- FLORIDA PLAIN.
  • GA- GALVESTON AREA 42.
  • GB- GARDEN BANKS 60.
  • GC- GREEN CANYON 60.
  • GI- GRAND ISLE AREA 17.
  • GV- GAINESVILLE 60.
  • HC- HUDSON CANYON.
  • HE- HENDERSON 60.
  • HH- HOWELL HOOK 60.
  • HI- HIGH ISLAND AREA 42.
  • KC- KEATHLEY CANYON 60.
  • KW- KEY WEST 60.
  • LL- LLOYD 60.
  • LP- LIGHTHOUSE POINT (THIS IS A FIELD) 17.
  • LS- LUND SOUTH.
  • LU- LUND * 60.
  • MA- MIAMI 60.
  • MC- MISSISSIPPI CANYON 60.
  • MI- MATAGORDA ISLAND AREA 42.
  • MO- MOBILE 60.
  • MP- MAIN PASS AREA 17.
  • MQ- MARQESAS 09.
  • MU- MUSTANG ISLAND AREA 42.
  • PB- ST PETERSBURG 60.
  • PE- PENSACOLA 60.
  • PI- PORT ISABEL 60.
  • PL- SOUTH PELTO AREA 17.
  • PN- NORTH PADRE ISLAND AREA 42.
  • PR- PULLEY RIDGE 60.
  • PS- SOUTH PADRE ISLAND AREA 42.
  • RK- RANKIN 60.
  • SA- SABINE PASS (LOUISIANA) 17.
  • SE- SIGSBEE ESCARPMENT.
  • SM- SOUTH MARSH ISLAND AREA 17.
  • SP- SOUTH PASS AREA 17.
  • SS- SHIP SHOAL AREA 17.
  • ST- SOUTH TIMBALIER AREA 17.
  • SX- SABINE PASS (TEXAS) 42.
  • TP- TARPON SPRINGS 60.
  • TS- TIGER SHOAL (THIS IS A FIELD) 17.
  • TV- TORTUGAS VALLEY.
  • VK- VIOSCA KNOLL 60.
  • VN- VERNON * 60.
  • VR- VERMILION AREA 17.
  • WC- WEST CAMERON AREA 17.
  • WD- WEST DELTA AREA 17.
  • WR- WALKER RIDGE 60.
WellSpudDate GENERAL_DATES Date Range Between 01-JAN-1947 and SYSDATE+10
BotmAreaCode 0059 Enumeration Range The Value-Description Pairs are listed below:
  • AC- MINOS CANYON 60.
  • AM- AMERY TERRACE.
  • AP- APALACHICOLA 60.
  • AT- ATWATER * 60.
  • BA- BRAZOS AREA 42.
  • BM- BAY MARCHAND AREA 17.
  • BS- BRETON SOUND AREA 17.
  • CA- CHANDELEUR AREA 17.
  • CC- CORPUS CHRISTI 60.
  • CE- CAMPECHE ESCARPMENT.
  • CH- CHARLOTTE HARBOR 60.
  • CP- COON POINT (THIS IS A FIELD) 17.
  • CS- CHANDELEUR SOUND 17.
  • DC- DESOTO CANYON 60.
  • DD- DESTIN DOME 60.
  • DT- DRY TORTUGAS 60.
  • EB- EAST BREAKS 60.
  • EC- EAST CAMERON AREA 17.
  • EI- EUGENE ISLAND AREA 17.
  • EL- THE ELBOW 60.
  • EW- EWING BANK 60.
  • FM- FLORIDA MIDDLE GROUND 60.
  • FP- FLORIDA PLAIN.
  • GA- GALVESTON AREA 42.
  • GB- GARDEN BANKS 60.
  • GC- GREEN CANYON 60.
  • GI- GRAND ISLE AREA 17.
  • GV- GAINESVILLE 60.
  • HC- HUDSON CANYON.
  • HE- HENDERSON 60.
  • HH- HOWELL HOOK 60.
  • HI- HIGH ISLAND AREA 42.
  • KC- KEATHLEY CANYON 60.
  • KW- KEY WEST 60.
  • LL- LLOYD 60.
  • LP- LIGHTHOUSE POINT (THIS IS A FIELD) 17.
  • LS- LUND SOUTH.
  • LU- LUND * 60.
  • MA- MIAMI 60.
  • MC- MISSISSIPPI CANYON 60.
  • MI- MATAGORDA ISLAND AREA 42.
  • MO- MOBILE 60.
  • MP- MAIN PASS AREA 17.
  • MQ- MARQESAS 09.
  • MU- MUSTANG ISLAND AREA 42.
  • PB- ST PETERSBURG 60.
  • PE- PENSACOLA 60.
  • PI- PORT ISABEL 60.
  • PL- SOUTH PELTO AREA 17.
  • PN- NORTH PADRE ISLAND AREA 42.
  • PR- PULLEY RIDGE 60.
  • PS- SOUTH PADRE ISLAND AREA 42.
  • RK- RANKIN 60.
  • SA- SABINE PASS (LOUISIANA) 17.
  • SE- SIGSBEE ESCARPMENT.
  • SM- SOUTH MARSH ISLAND AREA 17.
  • SP- SOUTH PASS AREA 17.
  • SS- SHIP SHOAL AREA 17.
  • ST- SOUTH TIMBALIER AREA 17.
  • SX- SABINE PASS (TEXAS) 42.
  • TP- TARPON SPRINGS 60.
  • TS- TIGER SHOAL (THIS IS A FIELD) 17.
  • TV- TORTUGAS VALLEY.
  • VK- VIOSCA KNOLL 60.
  • VN- VERNON * 60.
  • VR- VERMILION AREA 17.
  • WC- WEST CAMERON AREA 17.
  • WD- WEST DELTA AREA 17.
  • WR- WALKER RIDGE 60.
BhTotalMd GENERAL_DATES Date Range Between 01-JAN-1947 and SYSDATE+10
BhTotalMd MEASURED_DEPTH Number Range Between 0 and 50000
BhTotalMd LSE_FUTURE_DT Date Range Between 01-JAN-1900 and SYSDATE+7300
BhTotalMd MEASURED_DEPTH Number Range Between 0 and 50000
HWDCScrubDate GENERAL_DATES Date Range Between 01-JAN-1947 and SYSDATE+10