Data Center

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

Field Definitions for PACIFIC DETAIL LIST OF ACTIVE COMPANY FILE

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 1 Qlfy Non Qlfy Cd QLFY_NON_QLFY_CD -Indicates whether a business is one which undergoes the qualification process.
190 3 Non Qlfy Type Cd NON_QLFY_TYPE_CD -Indicates the type of non-qualified business associate based on the entity's dealings with the Minerals Management Service.
193 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.
201 1 Pac Region Code PAC_REGION_CODE -Indicates whether a business associate is qualified with the Minerals Management Service's Pacific Region.
202 1 Gom Region Code GOM_REGION_CODE -Indicates whether a business associate is qualified with the Minerals Management Service's Gulf of Mexico Region.
203 1 Alaska Rgn Code ALASKA_RGN_CODE -Indicates whether a business associate is qualified with the Minerals Management Service (MMS) Alaska Regional Office.
204 1 Atl Region Code ATL_REGION_CODE -Indicates whether a business associate is qualified with the Minerals Management Service's Atlantic Region.
205 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.
218 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.
226 1 Termination Code TERMINATION_CODE -Indicates the reason a business entity terminates its qualification status with the MMS.
227 35 Division Name DIVISION_NAME -The name of the organizational division of an entity used as part of the mailing address.
262 35 Line 1 Address LINE_1_ADDRESS -The first line of a street address.
297 35 Line 2 Address LINE_2_ADDRESS -The second line of a street address.
332 35 City Name CITY_NAME -The name of the city for the mailing address.
367 2 Postal St Code POSTAL_ST_CODE -Indicates the postal code for a state.
369 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.
389 35 Country Name COUNTRY_NAME -The name of the country other than the United States of America (USA) where a business entity receives correspondence.