Click here to skip navigation.Minerals Management Service MMS - Gulf of Mexico RegionSearchTopic IndexAbout MMSWhat's New U.S. Department of Interior
MMS - Gulf of Mexico Region
News Releases, Papers, Publications, Speeches, and Innovative Achievements ProgramUpcoming EventsFast FactseWell Permitting SystemProducts/Free DataAtlantic Information
Deep Gas in Shallow Water
Offshore Information
Lease Information
Environmental Information
Production Information
Hurricane Information
Online Ordering System
Public Information Ordering System
Public Information Data System
MMS Ocean Science
Spacer ImageNew e-Government Transformation Project, OCS Connect
Freedom of Information Act (FOIA)
MMS Forms for Lessee and Operators
Job Opportunties at MMS
Kid's Information Page
Privacy Act/Disclaimers
Accessibility
MMS Information Quality Guidelines
Subscrbe to Mailing Lists
Navigation Tips
Contact Us
Spacer Image The U.S. government's official
web portal
Spacer Image
Questions? Need More Information?

This page last updated: July 11, 2008


Summary File for MMS LOGS AND SAMPLES(ACCESS)

Column
Alias
Definition
LogID DOC_ID -Unique and sequential id assigned to the electronic documents or files such as image, word document, powerpoint presentation, video, audio, text, and pdf
LogType LOG_TYPE -Unknown
API API_WELL_NUMBER - A unique well identification number consisting of (from left to right) a two digit state code (or pseudo for Offshore), a three digit county code (or pseudo for Offshore), a five digit unique well code, and if applicable, a two digit sidetrack code as defined in API Bulletin D12A.
Lease LEASE_NUMBER - The number assigned to a lease by the regulatory agency having jurisdiction over mineral activity in the territory where the lease is located.
WellName WELL_NAME - The name assigned to the well. It may be a special name or the name of the property to which the well belongs.
WellNameSuffix WELL_NAME_SUFFIX -An extension to the well name that indicates the number of times that a new wellbore has been drilled.
Block BLOCK_NUMBER -Identifies a subdivision of an Official Protraction Diagram.
Area AREA_CODE -The designated abbreviation assigned to Outer Continental Shelf (OCS) geographical units for identification purposes and for use on maps and in data bases.
BLI DOC_BOTM_LOG_INTERVAL -Unknown
TLI DOC_TOP_LOG_INTERVAL -Unknown
RunDate DOC_DATE -Unknown
FileSize FILE_SIZE -The size, in bytes, of a file uploaded through the OMM E-Business web site.
LogPackageVolume LOG_PKG_VOLUME -Unknown
Source SOURCE -Unknown
DocBarcodeId DOC_BARCODE_ID -Unknown
QcCheckFlag DOC_QC_CHK_FL -Unknown
Comments COMMENTS -Textual entry to define remark made by a technician.
ReleasableDate This field is derived from the expression... decode(l.lease_expir_date, NULL, add_months(B.TOTAL_DEPTH_DATE,24)+60, decode(sign(l.lease_expir_date + 60 - (add_months(B.TOTAL_DEPTH_DATE,24)+60)), 1, add_months(B.TOTAL_DEPTH_DATE,24)+60, l.lease_expir_date+60)) ...and consists of these database columns:
lease_expir_date - The date a lease expires, is relinquished or terminated.
TOTAL_DEPTH_DATE - The date drilling on a well reached the final total depth.
lease_expir_date - The date a lease expires, is relinquished or terminated.
TOTAL_DEPTH_DATE - The date drilling on a well reached the final total depth.
TOTAL_DEPTH_DATE - The date drilling on a well reached the final total depth.
lease_expir_date - The date a lease expires, is relinquished or terminated.
FileExt
Origin


Privacy | Disclaimers | Accessibility

Home | Search | Topic Index | About MMS | What's New | Press Releases/Reports
Upcoming Events | Fast Facts | Products/Free Data | Deep Gas | Offshore Info | Lease Info
Environmental Info | Production Info | Hurricane Info | Online Ordering System | P.I. Data System
MMS Ocean Science | OEMM e-Gov | Forms | Jobs | Kid's Page | FOIA | Info Quality Guidelines
E-Mail Subscriptions | Navigation | Contact Us