Column Alias |
Definition |
MMSCompanyNum |
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. |
MmsStartDate |
MMS_START_DATE -The date that a business entity began doing business with the Minerals Management Service. |
BusAscName |
BUS_ASC_NAME -The name of a **business associate**. |
SortName |
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." |
MmsTermDate |
MMS_TERM_DATE -The date that a business entity is no longer qualified to do business on the OCS with MMS. |
PacRegionCode |
PAC_REGION_CODE -Indicates whether a business associate is qualified with the Minerals Management Service's Pacific Region. |
GomRegionCode |
GOM_REGION_CODE -Indicates whether a business associate is qualified with the Minerals Management Service's Gulf of Mexico Region. |
AlaskaRgnCode |
ALASKA_RGN_CODE -Indicates whether a business associate is qualified with the Minerals Management Service (MMS) Alaska Regional Office. |
AtlRegionCode |
ATL_REGION_CODE -Indicates whether a business associate is qualified with the Minerals Management Service's Atlantic Region. |
DunsNumber |
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. |
TermActnEffDt |
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. |
TerminationCode |
TERMINATION_CODE -Indicates the reason a business entity terminates its qualification status with the MMS. |
DivisionName |
DIVISION_NAME -The name of the organizational division of an entity used as part of the mailing address. |
Line1Address |
LINE_1_ADDRESS -The first line of a street address. |
Line2Address |
LINE_2_ADDRESS -The second line of a street address. |
CityName |
CITY_NAME -The name of the city for the mailing address. |
PostalStCode |
POSTAL_ST_CODE -Indicates the postal code for a state. |
ZipCode |
ZIP_CODE -The Postal Service designator which delineates the state, county or parish, community, and possibly neighborhood for a residence or business entity. |
CountryName |
COUNTRY_NAME -The name of the country other than the United States of America (USA) where a business entity receives correspondence. |
SearchName |
BUS_ASC_NAME -The name of a **business associate**. |