Data Center

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

Field Values for PACIFIC 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:
  • 6A- CHANNEL ISLANDS AREA
  • 6B- CHANNEL ISLANDS AREA
  • 6C- CHANNEL ISLANDS AREA
  • 6D- CHANNEL ISLANDS AREA
  • 6E- CHANNEL ISLANDS AREA
  • AC- ASTORIA CANYON
  • AR- ARGEUELLO FAN
  • AS- ASTORIA FAN
  • BC- BARCLEY CANYON
  • BG- BODEGA CANYON
  • BK- BUSHNELL KNOLL
  • BS- BLANCO SADDLE
  • CB- CAPE BLANCO
  • CC- CASCADIA BASIN
  • CD- CAPE DIAAPPOINTMENT
  • CF- CAPE FLATTERY
  • CG- CASCADIA GAP
  • CH- COPALIS BEACH
  • CI- CHANNEL ISLANDS
  • CR- CRESCENT CITY
  • CS- COOS BAY
  • DB- DAISY BANKS
  • DF- DELGADA FAN
  • ER- ESCANABA RIDGE
  • ET- ESCANABA TROUGH
  • EU- EUREKA
  • HB- HECETA BANK
  • HO- HOQUIAM
  • HS- HAKE SEAMOUNT
  • JS- JASPER SEAMOUNT
  • KR- KLAMATH RIDGE
  • LA- LOS ANGELES
  • LB- LONG BEACH
  • LS- CAPE DISAPPOINTMENT WEST
  • MB- MONTEREY BAY
  • MF- MONTEREY FAN
  • NA- NAVARRO CANYON
  • NC- NOYO CANYON
  • NF- NITINAT FAN
  • NP- NEWPORT
  • PA- PATTON RIDGE
  • PE- PIONEER ESCARPMENT
  • PJ- PRESIDENT JACKSON SEAMOUNT
  • PR- PIONEER RIDGE
  • PS- PARKS SEAMOUNT
  • RA- THE RAMPART
  • RB- ROSEBURG
  • RD- REDDING
  • SA- SANTA CRUZ
  • SC- SAN CLEMENTE
  • SD- SAN DIEGO
  • SE- SEATTLE
  • SF- SAN FRANCISCO
  • SI- SANTA ROSA ISLAND
  • SL- SALEM
  • SM- SANTA MARIA
  • SO- SAN LUIS OBISPO
  • SR- SANTA ROSA
  • SS- STODDARD SEAMOUNT
  • ST- SANTA ANA
  • SU- SUR CANYON
  • SV- STEEL VENDOR SEAMOUNT
  • TA- TANEY SEAMOUNT
  • TB- TILLAMOOK BAY
  • TS- THOMPSON SEAMOUNT
  • UK- UKIAH
  • UN- (UNNAMED)
  • VB- VELERO BASIN
  • VC- VANCOUVER
  • VG- VANCOUGAR GAP
  • VS- VANCE SEAMOUNT
  • WE- WEED
  • WS- WESTFALL SEAMOUNT
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:
  • 6A- CHANNEL ISLANDS AREA
  • 6B- CHANNEL ISLANDS AREA
  • 6C- CHANNEL ISLANDS AREA
  • 6D- CHANNEL ISLANDS AREA
  • 6E- CHANNEL ISLANDS AREA
  • AC- ASTORIA CANYON
  • AR- ARGEUELLO FAN
  • AS- ASTORIA FAN
  • BC- BARCLEY CANYON
  • BG- BODEGA CANYON
  • BK- BUSHNELL KNOLL
  • BS- BLANCO SADDLE
  • CB- CAPE BLANCO
  • CC- CASCADIA BASIN
  • CD- CAPE DIAAPPOINTMENT
  • CF- CAPE FLATTERY
  • CG- CASCADIA GAP
  • CH- COPALIS BEACH
  • CI- CHANNEL ISLANDS
  • CR- CRESCENT CITY
  • CS- COOS BAY
  • DB- DAISY BANKS
  • DF- DELGADA FAN
  • ER- ESCANABA RIDGE
  • ET- ESCANABA TROUGH
  • EU- EUREKA
  • HB- HECETA BANK
  • HO- HOQUIAM
  • HS- HAKE SEAMOUNT
  • JS- JASPER SEAMOUNT
  • KR- KLAMATH RIDGE
  • LA- LOS ANGELES
  • LB- LONG BEACH
  • LS- CAPE DISAPPOINTMENT WEST
  • MB- MONTEREY BAY
  • MF- MONTEREY FAN
  • NA- NAVARRO CANYON
  • NC- NOYO CANYON
  • NF- NITINAT FAN
  • NP- NEWPORT
  • PA- PATTON RIDGE
  • PE- PIONEER ESCARPMENT
  • PJ- PRESIDENT JACKSON SEAMOUNT
  • PR- PIONEER RIDGE
  • PS- PARKS SEAMOUNT
  • RA- THE RAMPART
  • RB- ROSEBURG
  • RD- REDDING
  • SA- SANTA CRUZ
  • SC- SAN CLEMENTE
  • SD- SAN DIEGO
  • SE- SEATTLE
  • SF- SAN FRANCISCO
  • SI- SANTA ROSA ISLAND
  • SL- SALEM
  • SM- SANTA MARIA
  • SO- SAN LUIS OBISPO
  • SR- SANTA ROSA
  • SS- STODDARD SEAMOUNT
  • ST- SANTA ANA
  • SU- SUR CANYON
  • SV- STEEL VENDOR SEAMOUNT
  • TA- TANEY SEAMOUNT
  • TB- TILLAMOOK BAY
  • TS- THOMPSON SEAMOUNT
  • UK- UKIAH
  • UN- (UNNAMED)
  • VB- VELERO BASIN
  • VC- VANCOUVER
  • VG- VANCOUGAR GAP
  • VS- VANCE SEAMOUNT
  • WE- WEED
  • WS- WESTFALL SEAMOUNT
Bh Total Md MEASURED_DEPTH Number Range Between 0 and 50000