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 COMPANIES_ALL(ACCESS)

Column
Alias Name		 Domain
Name		 Domain
Type		 Valid Value
Description
MMSCompanyNum MMS_COMPANY_NUMS Number Range Between 00001 and 99999
MmsStartDate GENERAL_DATES Date Range Between 01-JAN-1947 and SYSDATE+10
MmsTermDate LSE_FUTURE_DT Date Range Between 01-JAN-1900 and SYSDATE+7300
PacRegionCode PAC_REGION_CODES Enumeration Range The Value-Description Pairs are listed below:
  • P- Qualified in the Pacific Region.
GomRegionCode GOM_REGION_CODES Enumeration Range The Value-Description Pairs are listed below:
  • G- Qualified in the Gulf of Mexico Region.
AlaskaRgnCode ALASKA_RGN_CODES Enumeration Range The Value-Description Pairs are listed below:
  • Y- Qualified in the Alaska Region.
AtlRegionCode ATL_REGION_CODES Enumeration Range The Value-Description Pairs are listed below:
  • A- Qualified in the Atlantic Region..
TermActnEffDt LSE_FUTURE_DT Date Range Between 01-JAN-1900 and SYSDATE+7300
TerminationCode TERMINATION_CODES Enumeration Range The Value-Description Pairs are listed below:
  • C- Change of Name.
  • M- Merger.
  • O- Other.
PostalStCode POSTAL_ST_CODES Enumeration Range The Value-Description Pairs are listed below:
  • AK- Alaska.
  • AL- Alabama.
  • AR- Arkansas.
  • AS- American Samoa.
  • AZ- Arizona.
  • CA- California.
  • CO- Colorado.
  • CT- Connecticut.
  • DC- District of Columbia.
  • DE- Delaware.
  • FL- Florida.
  • GA- Georgia.
  • GU- Guam.
  • HI- Hawaii.
  • IA- Iowa.
  • ID- Idaho.
  • IL- Illinois.
  • IN- Indiana.
  • KS- Kansas.
  • KY- Kentucky.
  • LA- Louisiana.
  • MA- Massachusetts.
  • MD- Maryland.
  • ME- Maine.
  • MH- Marshall Islands.
  • MI- Michigan.
  • MN- Minnesota.
  • MO- Missouri.
  • MP- Northern Mariana Is.
  • MS- Mississippi.
  • MT- Montana.
  • NC- North Carolina.
  • ND- North Dakota.
  • NE- Nebraska.
  • NH- New Hampshire.
  • NJ- New Jersey.
  • NM- New Mexico.
  • NV- Nevada.
  • NY- New York.
  • OH- Ohio.
  • OK- Oklahoma.
  • OR- Oregon.
  • PA- Pennsylvania.
  • PR- Puerto Rico.
  • PW- Palau.
  • RI- Rhode Island.
  • SC- South Carolina.
  • SD- South Dakota.
  • TN- Tennessee.
  • TX- Texas.
  • UT- Utah.
  • VA- Virginia.
  • VI- Virgin Island.
  • VT- Vermont.
  • WA- Washington.
  • WI- Wisconsin.
  • WV- West Virginia.
  • WY- Wyoming.