Data Center

Data Center >>
Field Values for DETAIL LIST OF ALL COMPANY FILE

Field Values for DETAIL LIST OF ALL COMPANY FILE

Column
Alias Name
Domain
Name
Domain
Type
Valid Value
Description
MMS Company Num MMS_COMPANY_NUMS Number Range Between 00001 and 99999
Mms Start Date GENERAL_DATES Date Range Between 01-JAN-1947 and SYSDATE+10
Mms Term Date LSE_FUTURE_DT Date Range Between 01-JAN-1900 and SYSDATE+7300
Pac Region Code PAC_REGION_CODES Enumeration Range The Value-Description Pairs are listed below:
  • P- Qualified in the Pacific Region.
Gom Region Code GOM_REGION_CODES Enumeration Range The Value-Description Pairs are listed below:
  • G- Qualified in the Gulf of Mexico Region.
Alaska Rgn Code ALASKA_RGN_CODES Enumeration Range The Value-Description Pairs are listed below:
  • Y- Qualified in the Alaska Region.
Atl Region Code ATL_REGION_CODES Enumeration Range The Value-Description Pairs are listed below:
  • A- Qualified in the Atlantic Region..
Term Actn Eff Dt LSE_FUTURE_DT Date Range Between 01-JAN-1900 and SYSDATE+7300
Termination Code TERMINATION_CODES Enumeration Range The Value-Description Pairs are listed below:
  • C- Change of Name.
  • M- Merger.
  • O- Other.
Postal St Code POSTAL_ST_CODES Enumeration Range The Value-Description Pairs are listed below:
  • AK- Alaska.
  • AL- Alabama.
  • AR- Arkansas.
  • AS- American Samoa.
  • AZ- Arizona.
  • CA- California.
  • CO- Colorado.
  • CT- Connecticut.
  • DC- District of Columbia.
  • DE- Delaware.
  • FL- Florida.
  • GA- Georgia.
  • GU- Guam.
  • HI- Hawaii.
  • IA- Iowa.
  • ID- Idaho.
  • IL- Illinois.
  • IN- Indiana.
  • KS- Kansas.
  • KY- Kentucky.
  • LA- Louisiana.
  • MA- Massachusetts.
  • MD- Maryland.
  • ME- Maine.
  • MH- Marshall Islands.
  • MI- Michigan.
  • MN- Minnesota.
  • MO- Missouri.
  • MP- Northern Mariana Is.
  • MS- Mississippi.
  • MT- Montana.
  • NC- North Carolina.
  • ND- North Dakota.
  • NE- Nebraska.
  • NH- New Hampshire.
  • NJ- New Jersey.
  • NM- New Mexico.
  • NV- Nevada.
  • NY- New York.
  • OH- Ohio.
  • OK- Oklahoma.
  • OR- Oregon.
  • PA- Pennsylvania.
  • PR- Puerto Rico.
  • PW- Palau.
  • RI- Rhode Island.
  • SC- South Carolina.
  • SD- South Dakota.
  • TN- Tennessee.
  • TX- Texas.
  • UT- Utah.
  • VA- Virginia.
  • VI- Virgin Island.
  • VT- Vermont.
  • WA- Washington.
  • WI- Wisconsin.
  • WV- West Virginia.
  • WY- Wyoming.