Data Center

Data Center >>
Field Values for BOREHOLE API CHANGE ASCII FORMAT

Field Values 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