Click here to skip navigation.Minerals Management Service MMS - Gulf of Mexico RegionSearchTopic IndexAbout MMSWhat's New U.S. Department of Interior
MMS - Gulf of Mexico Region
News Releases, Papers, Publications, Speeches, and Innovative Achievements ProgramUpcoming EventsFast FactseWell Permitting SystemProducts/Free DataAtlantic Information
Deep Gas in Shallow Water
Offshore Information
Lease Information
Environmental Information
Production Information
Hurricane Information
Online Ordering System
Public Information Ordering System
Public Information Data System
MMS Ocean Science
Spacer ImageNew e-Government Transformation Project, OCS Connect
Freedom of Information Act (FOIA)
MMS Forms for Lessee and Operators
Job Opportunties at MMS
Kid's Information Page
Privacy Act/Disclaimers
Accessibility
MMS Information Quality Guidelines
Subscrbe to Mailing Lists
Navigation Tips
Contact Us
Spacer Image The U.S. government's official web portal
Spacer Image
Questions? Need More Information?

This page last updated: March 15, 2010

Domain File for BOREHOLE API CHANGE ASCII FORMAT

Column
Alias Name		 Domain
Name		 Domain
Type		 Valid Value
Description
Bh Actv Type Cd 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.
Activity Date GENERAL_DATES Date Range Between 01-JAN-1947 and SYSDATE+10
Surf Area Code 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.
Well Spud Date GENERAL_DATES Date Range Between 01-JAN-1947 and SYSDATE+10
Botm Area Code 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.
Bh Total Md MEASURED_DEPTH Number Range Between 0 and 50000
Bh Total Md MEASURED_DEPTH Number Range Between 0 and 50000
Hwdc Scrub Dt GENERAL_DATES Date Range Between 01-JAN-1947 and SYSDATE+10

Privacy | Disclaimers | Accessibility

Home | Search | Topic Index | About MMS | What's New | Press Releases/Reports
Upcoming Events | Fast Facts | Products/Free Data | Deep Gas | Offshore Info | Lease Info
Environmental Info | Production Info | Hurricane Info | Online Ordering System | P.I. Data System
MMS Ocean Science | OEMM e-Gov | Forms | Jobs | Kid's Page | FOIA | Info Quality Guidelines
E-Mail Subscriptions | Navigation | Contact Us