Data Center

Data Center >>
Field Values for PACIFIC DETAIL LIST OF ACTIVE COMPANY FILE

Field Values for PACIFIC DETAIL LIST OF ACTIVE COMPANY FILE

Column
Alias Name		 Domain
Name		 Domain
Type		 Valid Value
Description
Mms Company Num MMS_COMPANY_NUMS Number Range Between 00001 and 99999
Mms Start Date GENERAL_DATES Date Range Between 01-JAN-1947 and SYSDATE+10
Qlfy Non Qlfy Cd QLFY_NON_QLFY_CDS Enumeration Range The Value-Description Pairs are listed below:
  • A- Qualified - Alternative Energy.
  • B- Qualified - AE and Mineral.
  • N- Non-Qualified.
  • Q- Qualfiied - Mineral.
Non Qlfy Type Cd NON_QLFY_TYPE_CDS Enumeration Range The Value-Description Pairs are listed below:
  • AGT- U.S. Agent For Service Of Process.
  • BNK- Bank.
  • CMV- Computer Hardware/Software Manufacturer/Vendor.
  • CVA- Certified Verification Agent.
  • EV- Event Company.
  • FMP- FMP Operator.
  • GEO- Geologic Survey Contractor.
  • GGP- G&G Permittee.
  • INS- Insurance Company.
  • LAW- Law Firm.
  • LSE- Leasing Companies.
  • MTR- Meter Owner.
  • NGP- NGPA Applicant.
  • OTH- Other Companies.
  • PAL- Paleo Operator.
  • PIP- Pipeline Company.
  • PLN- Plan Company.
  • PLT- Platform Contract Operator. A company that is hired to operate a platform for a lease operator..
  • PSC- Pipeline Survey Contractor.
  • PUB- Public Information Company.
  • RIG- Drilling Rig Operator.
  • SEI- Seismic Survey Contractor.
  • SHL- Shallow Hazards Survey Contractor.
  • SRO- Spill Removal Organization.
  • TST- Testing Company.
  • WEL- Well Logging Company.
  • WLH- Well Logging Company (historical).
Mms Term Date LSE_FUTURE_DT Date Range Between 01-JAN-1900 and SYSDATE+7300
Pac Region Code PAC_REGION_CODES Enumeration Range The Value-Description Pairs are listed below:
  • P- Qualified in the Pacific Region.
Gom Region Code GOM_REGION_CODES Enumeration Range The Value-Description Pairs are listed below:
  • G- Qualified in the Gulf of Mexico Region.
Alaska Rgn Code ALASKA_RGN_CODES Enumeration Range The Value-Description Pairs are listed below:
  • Y- Qualified in the Alaska Region.
Atl Region Code ATL_REGION_CODES Enumeration Range The Value-Description Pairs are listed below:
  • A- Qualified in the Atlantic Region..
Term Actn Eff Dt LSE_FUTURE_DT Date Range Between 01-JAN-1900 and SYSDATE+7300
Termination Code TERMINATION_CODES Enumeration Range The Value-Description Pairs are listed below:
  • C- Change of Name.
  • M- Merger.
  • O- Other.
Postal St Code 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.