How to Use Corporate Affiliations

Logging On/Off

Searching

Corporate Affiliations allows searching for companies by name or screening by a number of variables. These variables include geography (city, state, country), size (number of employees, sales), industry (SIC code or SIC chapter). To perform a search, input search terms in the search boxes and/or select items from the drop-down menus. Click on the Search button to search.

The default search is Quick Search. Fill in as many variables as you want and click on the Search button to perform the search.

For more options, click on Advanced Search from the left-hand menu. Select variables, such as company name, from the left-hand drop-down boxes. Then either type the search words in the box on the right or select values from the drop-down menus on the right (depending on which variables you select). Then choose radio buttons for the company types to search (public, private, parent, subsidiary, etc.) and click on the Search button to perform the search.

Search Tips

• Do not abbreviate company names or geographic locations, except for USA.
  e.g. Saint Paul, United Arab Emirates, Fort Wayne
• Use the asterisk (*) as the truncation symbol.
  anders* will retrieve Anders, Andersen, Anderson; *anderson will retrieve Anderson, Sanderson, etc.; *apple* will retrieve Apple Computers, Red Apple Restaurant and Ocean Spray Cranapple
• Use the exclamation point (!) as a sound-alike symbol.
  !andersen will retrieve Andersen, Anderson, Andenes (and much more)
• Use OR to retrieve more than one company, city, country, SIC code, etc.
  e.g. Autozone OR Pep Boys, Saint Paul OR Minneapolis, WI OR MN, Benin OR Togo

Searching Specific Fields

Company Name

Type a company name or names, separating the names with the OR connector.
Goldman Sachs or Morgan Stanley

Location

For cities, spell out the entire name.
e.g., Saint Paul

For US states, use the two-letter state code.
Click on the get values link to find the state codes

For countries, use the get values link to find official country names

Use the OR connector to search for more than one location at once, e.g. Los Angeles OR San Francisco, IL OR IN

Number of Employees

Choose a radio button for greater than, less than, equal to, or between. Then select a number or numbers from the drop-down menus.

NAICS/SIC Code (Industry)

Type in one or more 6-digit NAICS (North American Industry Classification System) or 4-digit SIC (Standard Industrial Classification) codes in the appropriate box, separating multiple codes with the OR connector. Otherwise, click the Select NAICS Codes or Select SIC Codes links to browse and select codes from the menus. Click the Select NAICS Sectors or Select SIC Chapters links to select broad categories of codes.

Job Title/Function

To search for companies that have particular job titles or functions (such as Account Group Head or Import) listed in their records, select a job title/function from the drop-down menu.

Searching by Sales/Revenue

To search for companies with sales/revenue greater than, less than, equal to or between, choose the appropriate radio button and then select an amount (in US dollars) from the drop-down menu.

Refining Search

From the Search Results list, click on the Refine Search button to change your search criteria. Click on Quick Search or Advanced Search from the left-hand menu to clear the previous search and start over.

Displaying Company Records

From the Search Results list, click on a company name to view its record.

To view multiple records at once, check the boxes next to the company names. Then click on Print above the Search Results list - this will NOT automatically print the records. In the Print window, check off all the items you want to display (including Print All Companies on a Single Page). Then click the Print button in the window. This will format all the companies on one screen.

Within each company record, click on the links at the bottom of the record to see such categories as Overview, Personnel, Outside Service Firms, Products, and Hierarchy. Click on Back to Search Results to return to the company list.
Note: Not all companies have all categories.

Print/Save/E-mail Records

To Print:

To select companies to print from the Search Results list, check the boxes next to the company names. Then click on Print above the Search Results list. In the Print window, check off all the items you want to display. If you want all companies on the screen at once, check the box labeled print all companies on a single page. Then click the Print button in the window. This will format all the companies on one screen. Then select File > Print from the browser menu.

To Save:

To select companies to save from the Search Results list, check the boxes next to the company names. Then click on Download (above the Search Results list). From this screen, check off all the Job Titles you want to include. Then click the Download button in the Download window. A File Download window will appear, and select Save. Choose a location and name for the file. Corporate Affiliations uses CSV files, which are compatible with any spreadsheet program, such as Microsoft Excel.

To E-mail:

Since there is no e-mail application built into Corporate Affiliations, use the Saving Company Records instructions (above) to save the file. Then use your e-mail program to e-mail the file.

Finding Help

For help searching Corporate Affiliations, click on Search Instructions from the left-hand menu.