Data Center

Official websites use .gov
A .gov website belongs to an official government organization in the United States.

Secure .gov websites use HTTPS
A lock ( ) or https:// means you’ve safely connected to the .gov website. Share sensitive information only on official, secure websites.


Data Center >>
Field Definitions for DETAIL LIST OF COMPANY FILE (1110)

Field Definitions for DETAIL LIST OF COMPANY FILE (1110)

Click on hyperlinked Column Aliases to show possible values.

The Start Position Column is used for fixed dumps only. Click on the column alias for a valid list of values or codes associated with the element selected.

Start
Position		 Item
Length		 Column
Alias		 Definition
1 5 Mms Company Num MMS_COMPANY_NUM -The number assigned by the Minerals Management Service to a business entity, individual, or agency with whom MMS does business or exchanges information.
6 8 Mms Start Date MMS_START_DATE -The date that a business entity began doing business with the Minerals Management Service.
14 100 Bus Asc Name BUS_ASC_NAME -The name of a **business associate**.
114 75 Sort Name SORT_NAME -The name of the business entity doing business on the OCS used for sorting purposes. For example, The Louisana Land and Exploration Company would have a short name of LOUISIANA LAND AND EXPLORATION COMPANY, THE and therefore sort with business entities whose name begins with "L."
189 8 Mms Term Date MMS_TERM_DATE -The date that a business entity is no longer qualified to do business on the OCS with MMS.
197 1 Pac Region Code PAC_REGION_CODE -Indicates whether a business associate is qualified with the Minerals Management Service's Pacific Region.
198 1 GoA Region Code GOM_REGION_CODE -Indicates whether a business associate is qualified with the Minerals Management Service's Gulf of America Region.
199 1 Alaska Rgn Code ALASKA_RGN_CODE -Indicates whether a business associate is qualified with the Minerals Management Service (MMS) Alaska Regional Office.
200 1 Atl Region Code ATL_REGION_CODE -Indicates whether a business associate is qualified with the Minerals Management Service's Atlantic Region.
201 13 Duns Number DUNS_NUMBER -The unique identifier assigned to a requesting business by Dun and Bradstreet. The first nine digits are assigned by Dun and Bradstreet, the last four are agreed to by the trading partners.
214 8 Term Actn Eff Dt TERM_ACTN_EFF_DT -The date that an action, such as a name change or merger, that causes a business entity to terminate is effective.
222 1 Termination Code TERMINATION_CODE -Indicates the reason a business entity terminates its qualification status with the MMS.
223 35 Division Name DIVISION_NAME -The name of the organizational division of an entity used as part of the mailing address.
258 35 Line 1 Address LINE_1_ADDRESS -The first line of a street address.
293 35 Line 2 Address LINE_2_ADDRESS -The second line of a street address.
328 35 City Name CITY_NAME -The name of the city for the mailing address.
363 2 Postal St Code POSTAL_ST_CODE -Indicates the postal code for a state.
365 20 Zip Code ZIP_CODE -The Postal Service designator which delineates the state, county or parish, community, and possibly neighborhood for a residence or business entity.
385 35 Country Name COUNTRY_NAME -The name of the country other than the United States of America (USA) where a business entity receives correspondence.