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.
|
