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 |
Gom Region Code |
GOM_REGION_CODE -Indicates whether a business associate is qualified with the Minerals Management Service's Gulf of Mexico 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. |