Platform Master Data - Field Value Lookup

Column
Alias Name		 Domain
Name		 Domain
Type		 Valid Value
Description
Abandon Flag FLAG Character The Value-Description Pairs are listed below:
 
  • N- No.
     
  • Y- Yes.
     
Aloc Mtr Flag FLAG Character The Value-Description Pairs are listed below:
 
  • N- No.
     
  • Y- Yes.
     
Attended 8 Hr Fl FLAG Character The Value-Description Pairs are listed below:
 
  • N- No.
     
  • Y- Yes.
     
Condn Prod Flag FLAG Character The Value-Description Pairs are listed below:
 
  • N- No.
     
  • Y- Yes.
     
Drilling Flag FLAG Character The Value-Description Pairs are listed below:
 
  • N- No.
     
  • Y- Yes.
     
Fired Vessel Fl FLAG Character The Value-Description Pairs are listed below:
 
  • N- No.
     
  • Y- Yes.
     
Gas Prod Flag FLAG Character The Value-Description Pairs are listed below:
 
  • N- No.
     
  • Y- Yes.
     
Gas Flaring Flag FLAG Character The Value-Description Pairs are listed below:
 
  • N- No.
     
  • Y- Yes.
     
Mms Company Num MMS_COMPANY_NUMS Number Range Between 00001 and 99999
Manned 24 Hr Fl FLAG Character The Value-Description Pairs are listed below:
 
  • N- No.
     
  • Y- Yes.
     
Maj Cmplx Flag FLAG Character The Value-Description Pairs are listed below:
 
  • N- No.
     
  • Y- Yes.
     
Last Rev Date GENERAL_DATES Date Range Between 01-JAN-1947 and SYSDATE
Lact Mtr Flag FLAG Character The Value-Description Pairs are listed below:
 
  • N- No.
     
  • Y- Yes.
     
Injection Code INJ_CODES Character The Value-Description Pairs are listed below:
 
  • B- BOTH GAS AND WATER INJECTIONS.
     
  • G- GAS INJECTION.
     
  • N- NO INJECTION.
     
  • W- WATER INJECTION.
     
Heliport Flag FLAG Character The Value-Description Pairs are listed below:
 
  • N- No.
     
  • Y- Yes.
     
Workover Flag FLAG Character The Value-Description Pairs are listed below:
 
  • N- No.
     
  • Y- Yes.
     
Water Prod Flag FLAG Character The Value-Description Pairs are listed below:
 
  • N- No.
     
  • Y- Yes.
     
Tank Gauge Flag FLAG Character The Value-Description Pairs are listed below:
 
  • N- No.
     
  • Y- Yes.
     
Sul Prod Flag FLAG Character The Value-Description Pairs are listed below:
 
  • N- No.
     
  • Y- Yes.
     
Subdistrict Code SUBDISTRICT_CODES Character The Value-Description Pairs are listed below:
 
  • 1- CORPUS CHRISTI SUBDISTRICT.
     
  • 2- LAKE CHARLES SUBDISTRICT.
     
Store Tank Flag FLAG Character The Value-Description Pairs are listed below:
 
  • N- No.
     
  • Y- Yes.
     
Rig Count RIG_COUNTS Number Range Between 0 and 3
Qtr Type Code QRTSTYPES Character The Value-Description Pairs are listed below:
 
  • N- NONE.
     
  • P- PERMANENT QUARTERS.
     
  • T- TEMPORARY QUARTERS.
     
Prod Eqmt Flag FLAG Character The Value-Description Pairs are listed below:
 
  • N- No.
     
  • Y- Yes.
     
Production Flag FLAG Character The Value-Description Pairs are listed below:
 
  • N- No.
     
  • Y- Yes.
     
Power Source Typ POWER_SRC_TYPES Character The Value-Description Pairs are listed below:
 
  • D- DIESEL POWER.
     
  • G- GAS POWER.
     
Power Gen Flag FLAG Character The Value-Description Pairs are listed below:
 
  • N- No.
     
  • Y- Yes.
     
Oil Prod Flag FLAG Character The Value-Description Pairs are listed below:
 
  • N- No.
     
  • Y- Yes.
     
Gas Sale Mtr Fl FLAG Character The Value-Description Pairs are listed below:
 
  • N- No.
     
  • Y- Yes.
     
District Code DISTRICT_CODES Character The Value-Description Pairs are listed below:
 
  • 1- NEW ORLEANS DISTRICT.
     
  • 2- HOUMA DISTRICT.
     
  • 3- LAFAYETTE DISTRICT.
     
  • 4- LAKE JACKSON DISTRICT.
     
  • 5- LAKE CHARLES SUBDISTRICT.
     
  • 6- CORPUS CHRISTI SUBDISTRICT.
     
Crane Count CRANE_COUNTS Number Range Between 0 and 5
Compressor Flag FLAG Character The Value-Description Pairs are listed below:
 
  • N- No.
     
  • Y- Yes.
     
Comgl Prod Flag FLAG Character The Value-Description Pairs are listed below:
 
  • N- No.
     
  • Y- Yes.
     
Area Code 0059 Character The Value-Description Pairs are listed below:
 
  • AB- NG 15-8 60.
     
  • 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.
     
  • 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.
     
Meter Prover Fl FLAG Character The Value-Description Pairs are listed below:
 
  • N- No.
     
  • Y- Yes.