There are two different ways to tell if a company is licensed in a particular state. This is maintained by each of the states. It is the most common field used with the NAIC Financial tables, and the one you will most likely join tables with. Most of the time you will only be concerned with Individual companies. This one is really your choice.
Computers perform better with numeric fields.
For example, you write a query where you are limiting the records to only the domiciled companies in your state. Then these fields won t be brought back from the NAIC Financial Database, making your query faster and the resulting report less cluttered. Save your query before you run it. Always save your query changes before you run the query, unless this is only a slight modification of an existing query and you re not sure if you want to keep it or not. Avoid doing sorts.