513
Corporate Affiliations

Last Loaded on Web: Wednesday, July 01, 2009

Last Update To Bluesheet: November 24, 2008

Bluesheet Contents     PDF version

File Description Print Counterparts Geographic Coverage Terms and Conditions Limit Report Options
Subject Coverage Dialog File Data Special Features Sample Record Sort Predefined Format Options
Sources Database Content DIALINDEX/OneSearch Categories Basic Index Rank Rates
Tips Document Types Indexed Contact Additional Indexes Map


File Description [top]

Corporate Affiliations, a database produced by LexisNexis Group, a division of Reed Elsevier Inc., contains business profiles and corporate linkage ("who owns whom") for approximately 200,000 public and private companies worldwide.

Each record includes the name, address, telephone number, sales,number of employees, SIC codes, business description, executive names, director names, corporate family hierarchy, ticker symbol, stock exchanges, net worth, total assets, and total liabilities, where available.



Tips [top]

USE FILE 513

to find company ownership information.

USE /CO OR CO=

to find company names.

USE /PARENT or /AFFILIATE

to restrict retrieval to parent records or to affiliate records.

USE FORMAT 6

to view the number of affiliates.



Subject Coverage [top]

The Corporate Affiliations database covers over 184,000 U.S. and non-U.S. companies in manufacturing, distribution, and service areas. This includes private as well as public companies, both parents and affiliates (subsidiatries and major divisions). All major domestic and international stock exchange listed companies (except investment instuments) are profiled.

U.S. privately held companies with annual sales in excess of $10 million and foreign privately held companies with annual sales in excess of $50 million are profiled.



Sources [top]

Information for the Corporate Affiliations database is gathered by direct telephone contact and in-house research in an ongoing process throughout the year.



Print Counterparts [top]

  • Corporate Affiliations U.S. Public Companies
  • Corporate Affiliations U.S. Private Companies
  • Corporate Affiliations International Public and Private Companies


Dialog File Data [top]

Dates Covered: Current edition
File Size: 212,028 records as of Q2 2008
Update Frequency: Quarterly reload


Database Content [top]

  • Directories


Document Types Indexed [top]

  • NA


Geographic Coverage [top]

  • International


Geographic Restrictions [top]

  • None


Special Features [top]


DialIndex/OneSearch Categories [top]

ACRONYM CATEGORY NAME
ASIACO Asia/Pacific Company Directories
CANADACO Canadian Company Directories
CODIR Company Directories
CORPHIER Corporate Structure and Hierarchy
EUROPECO European Company Directories
INTLCO International Company Directories
JAPANCO Japanese Company Directories
LATINCO Latin American Company Directories
MIDEASTC Middle Eastern/African Company Directories
OWNERS Ownership
TICKERDI Company Directories with Ticker Symbols
UKCO United Kingdom Company Directories
USCO U.S. Company Directories


Contact [top]

The Corporate Affiliations database is produced by the LexisNexis Group. Questions concerning file content should be directed to:

LexisNexis Group
Corporate Affiliations
121 Chanlon Road
New Providence, NJ 07974

800 Line: 800-340-3244
E-Mail: laura.tarnofsky@lexisnexis.com


Terms and Conditions [top]

For Dialog's Redistribution and Archive Policy, enter HELP ERA online. The following terms and conditions also apply.

Copyright 2002 LexisNexis Group, a division of Reed Elsevier Inc. All rights reserved. Limited reproduction of output is permitted for distribution within the user's internal operation, contingent upon payment of multiplier fee. Licensor makes no representations or warranties, express or implied, including warranties of merchantability or fitness for a particular purpose. REED REFERENCE PUBLISHING SHALL HAVE NO LIABILITY FOR LOST PROFITS OR CONSEQUENTIAL DAMAGES RELATED TO THE USE OF (DATABASE) WHETHER SUCH DAMAGES ARE FORESEEABLE OR WHETHER SUCH DAMAGES ARE DEEMED TO RESULT FROM THE FAILURE OR INADEQUACY OF ANY EXCLUSION OR OTHER REMEDY. This database has been supplied under license by LexisNexis Group, a division of Reed Elsevier Inc., and copyright and other proprietary rights are owned by, or licensed exclusively through, LexisNexis Group. The Subscriber or subscriber to this database ("Subscriber") acknowledges that the database is the product of LexisNexis Group's extensive gathering and coordination of information, selection therefrom of information considered by LexisNexis Group to be relevant and useful, and original arrangement of selected information. Duplication, copying, storing, or down-loading in print or electronic format is not permitted without prior written authorization from LexisNexis Group except for reproduction of the results of discrete searches of the database which amount to only limited quantities of reasonable portions for use by the Subscriber and for use within the Subscriber's organization upon payment of a multiplier fee through the ERA Service for Dialog's or through payment of a transactional fee to the Copyright Clearance Center. The permission hereby granted for limited copying is conditioned on including on all copies the attribution of LexisNexis Group as the source of information, and a suitable notice of copyright. Under no circumstances may copies, in any media, be made for resale or redistribution. Subscriber acknowledges that the rate of user fees paid for access to the database, and the limitations of liability set out below, are based in part on the expectation that the Subscriber will bear the risk of any loss which might be incurred due to the use or reliance by the Subscriber or Subscriber's customers on information contained in the database.


Dialog Standard Terms & Conditions apply.


SAMPLE RECORD [top]

    Sample Parent Record 
    DIALOG(R)File 513: Corporate Affiliations 
    (c)2004 LexisNexis Group. All rts. reserv. 
     
    01970728 
  /CO, CO=   Canon Inc 
     30-2, Shimomaruko 3-chome Ohta-ku 
  CY=, CN=   Tokyo  146-8501  Japan 
     
      Telephone: 03(348)2121 
     
  NO=   LNG Enterprise Number: 020465000 
  TS=, EX=   Ticket Symbol: CAJ   Stock Exchange: FR,FUKUOKA,KYOTO,NSE,NYSE,OSE,SAPPORO,   TOKYO, 
     
  NF=   Number of NonUS Affiliates: 97 
  NU=   Number of US Affiliates:    18 
  NT=   Total Number of Affiliates: 115 
     
  /DE   Business: Mfr. & Marketer of Cameras, 
               Business Machines & Precision Optical Equipment 
     SIC Codes (Primary listed first): 
  PC=,P2=,/DE      3827   Optical instruments & lenses 
  S2=,/DE      3571   Electronic computers 
  SC=,/DE      3861   Photographic equipment & supplies      3577   Computer Peripheral Equipment, NEC 
     
  EM=   Number of Employees: 93,620 
     
  SA=   Sales:          $23,312,920,000 
    TA=   Total Assets:           $22,809,245,000 
    TL=   Total Liabilities:       $9,660,816,000 
    NW=   Net Worth:     $13,148,438,000 
     
  SF=   This is a(n) Parent, NonUS Company, International Company 
     
  DS=   Numeric Field(s) Last Updated: 020611 
  DU=   Textual Field(s) Last Updated): 020531 
     
     Executives: 
  NA=    President, Chief Executive Officer 
          Fujio Mitarai/Chief Executive Officer 
     Managing Director 
          Ichiro Endo/Managing Director 
      Managing Director 
         Toshizo Tanaka/Managing Director 
  DO=   Board of Directors:Muneo Adachi;  Yusuke Emura;  Ichiro Endo;  Jinji 
     Ichikawa;  Fujio Mitarai;  Yasuo Mitsuhashi;  Akiyoshi Moroe; 
     Takashi Saito;  Ikuo Soma;  Akira Tajima;  Teruomi Takahashi;  Toru 
     Takahashi;  Nobuyoshi Tanaka;  Toshizo Tanaka;  Hajime Tsurusoka; 
     
     Corporate Family Hierarchy: 
     
     =>Canon Inc 1970728<= 
         Canon Aptex Inc. (Manufacturing Subsidiary:) 1970727 
         Canon Chemicals Inc. (Manufacturing Subsidiary:) 1970726 
         Canon Components, Inc. (Manufacturing Subsidiary:) 1970725 
         Canon Electronics Inc. (Manufacturing Subsidiary:) 197024 
           (. . .) 
           Canon U.S.A., Inc. (Marketing Subsidiary:)1970694 
             Canon Information Technical Svc. Inc. (Division)1970693 
            Canon Business Solutions, Inc. (Subsidiary) 1970692 
         

Sample Affiliate Record

 
     01970692 
  /CO, CO=   Canon Business Solutions, Inc. 
     425 N Martingale Rd Ste 1400 
  CY=, ZP=, CN=   Schaumburg, IL 60173-2212  USA 
     Telephone: 847-706-3400 
  IN=   State of Incorporation: IL 
  NO=   NRPC Number: 020465007 
     
  UP=, UO=   Ultimate Parent:  Canon Inc, (Japan) 1970728 
  IP=, IO=   Immediate Parent: Canon USA Inc, USA 1970694 
  SH=   Ownership by Parent: 100 % 
     
  NF=   Number of NonUS Affiliates: 97 
  NU=   Number of US Affiliates:    18 
  NT=   Total Number of Affiliates: 115 
     
  /DE   Business: Marketing & Distribution of Canon Products 
     SIC Codes (Primary listed first): 
  SC=, PC=, S2=, P2=      5045   Computers & computer peripheral equipment & 
               software-wholesale 
     
     
  SF=   This is a(n) Affiliate, US, International Company 
     
     
  NA=   Executives:   President, Chief Officer of Subsidiary, Administration/Operations 
        Emily Reynolds/Administration/Operations 
     Corporate Family Hierarchy: 
       Canon Inc 1970728 
         Canon U.S.A Inc. (Marketing Subsidiary:) 1970694 
         =>Canon Business Solutions, Inc. 1970694<= 


BASIC INDEX [top]

SEARCH
SUFFIX
DISPLAY
CODE
REPORT
(FIELD
LENGTH)
FIELD NAME

INDEXING

SELECT EXAMPLES

None None None All Basic Index Fields Word S CAMERA?(S)MANUFACTUR?
/CO CO CO (32) Company Name1,2 Word S CANON?/CO
/DE DE None Description of Business and SIC Descriptions Word S BUSINESS(W)MACHINE?/DE

1 Also searchable using CO=.

2 Also searches former company name.


ADDITIONAL INDEXES [top]

SEARCH
PREFIX
DISPLAY
CODE
REPORT
(FIELD
LENGTH)
FIELD NAME

INDEXING

SELECT EXAMPLES

None AN AN (9) DIALOG Accession Number
CN= CN CN (29) Country Name Phrase S CN=JAPAN
CO= CO CO (32) Company Name2 Phrase S CO=CANON?
CY= CY CY (32) City Phrase S CY=TOKYO
DO= DO None Director Name4 Phrase S DO=MUNEO ADACHI
DS= DS None Numeric Field(s) Last Updated Phrase S DS=20081027
DU= DU None Textual Field(s) Last Updated Phrase S DU=020531
EM= EM EM (12) Number of Employees5 Numeric S EM>=40K
EX= EX None Stock Exchange4 Phrase S EX=FR
None HR None Corporate Family Hierarchy
IN= IN IN (8) State of Incorporation Phrase S IN=IL
IO= IO IO (29) Immediate Parent Country Phrase S IO=JAPAN
IP= IP IP (32) Immediate Parent Company Name6 Phrase S IP=CANON U.S.A.?
NA= NA None Executive Name Phrase S NA=TANAKA, T.?
NF= NF NF (8) Number of Non-U.S. Affiliates5 Numeric S NF<100
NO= NO NO (11) LNG Enterprise Number7 Phrase S NO=020465000
S NO=020465
NT= NT NT (8) Number of Affiliates, Total5 Numeric S NT>=20
NU= NU NU (8) Number of U.S. Affiliates4,5 Numeric S NU=115
NW= NW NW (19) Net Worth4,5 Numeric S NW=10M:30M
P2= None None 2-digit Primary SIC Code8 Phrase S P2=38:40
PC= PC None Primary SIC Code8 Phrase S PC=3827
PO= None None Position9 Phrase S PO=CONTROLLER?
PS= None None Position Code10 Phrase S PS=011
S2= None None 2-digit SIC Code8 Phrase S S2=34
SA= SA SA (19) Sales in U.S. Dollars5 Phrase S SA=1B:10B
SC= SC None Standard Industrial Classification (SIC) Code8 Phrase S SC=3577
SF= SF None Special Feature11 Phrase S SF=PARENT
SH= SH SH (9) Ownership by Parent (%)5 Numeric S SH=100%
ST= ST ST (7) State or Province Phrase S ST=IL
TA= TA TA (19) Total Assets4,5 Numeric S TA=22b:25b
TE= TE TE (14) Telephone Area Code2,12 Phrase S TE=847
TL= TL TL (19) Total Liabilities4,5 Numeric S TL=9b:10b
TS= TS TS (9) Ticker Symbol4 Phrase S TS=CAJ
UO= UO UO (29) Ultimate Parent Country Phrase S UO=JAPAN
UP= UP UP (32) Ultimate Parent Company Name13 Phrase S UP=CANON, INC?
ZP= ZP ZP (12) Zip Code Phrase S ZP=60173

3 Also searchable using /CO.

4 Available for parent company records only.

5 Numeric entries are indexed as complete numbers, rounded down to the two left-most digits. Use numeric operators (:,>,<,=,etc.) to search a range of values, e.g., S SA>5B to find companies with sales over 5 billion.

6 Retrieves affiliate companies that report directly to the immediate parent. The immediate parent can be the ultimate parent or another affilate.

7 The first six digits of the LNG Enterprise number are also indexed with the NO=prefix. Searching on the six-digit number retrieves all companies in the corporate family, both parent and affiliate.

8 SIC codes are 1987 U.S. Codes.

9 EXPAND PO=A for a complete list of positions.

10 EXPAND PS=1 for a complte list of position codes.

11 These entries are searchable with SF=: AFFILIATE; PARENT;PRIVATE;U.S.; NONUS.

12 U.S. telephone area codes are searchabe using TE=. All telephone numbers may be displayed in a report, use TE.

13 Retrieves all affliate companies of the ultimate parent company.


LIMIT [top]

Sets and terms may be limited by Basic Index suffixes, i.e., /CO, /DE (e.g., SELECT S3/CO), as well as by the features listes below:
SUFFIX FIELD NAME EXAMPLES
/AFFILIATE Affiliate company records S S4/AFFILIATE
/NONUS Companies not in the U.S. S CANON/NONUS
/PARENT Parent company records S CANON/PARENT
/US Companies located in the U.S. S S1/US


SORT [top]

SORTABLE FIELDS EXAMPLES
CN, CO, CY, EM, IN, NW, PC, SA, ST, TA, TE, TL, TS, ZP SORT S4/ALL/ST,CY
PRINT S5/3/ALL/ST


RANK [top]

RANK FIELDS EXAMPLES
All phrase- and numeric-indexed fields in the Additional Indexes can be ranked. RANK CO S3


MAP [top]

MAP FIELDS EXAMPLES
CO, IP, NO, UP MAP UP TEMP S1


REPORT OPTIONS [top]

Output can be displayed in table format. REPORT codes with field lengths in parentheses are listed in the Search Options tables. Default table width is 72 characters; use SET H 132 to set maximum table width. REPORT S2/CO,IP/ALL


USER-DEFINED FORMAT OPTIONS [top]

User-defined formats may be specified using the display codes indicated in the Search Options tables. TYPE S2/CO,EX,TS/1-5


PREDEFINED FORMAT OPTIONS [top]

NO.
DIALOGWEB
FORMAT
RECORD CONTENT
1 -- DIALOG Accession Number
2 -- Full Record except Executive/Director Names and Corporate Hierarchy
3 Medium Company Name, Address, Telephone Number, LNG Enterprise Number, Ticker Symbol, Stock Exchange, Description of Business, and SIC Codes
5 Long Full Record except Corporate Hierarchy
6 -- Company name, LNG Enterprise Number, and Number of Affiliates
7 -- Company Name, Address, LNG Enterprise Number, and Update Fields
8 Short Company Name and Address
10 -- National Address (excludes country)
20 Full International Address (includes country)
K -- KWIC (Key Word In Context) displays a window of text; may be used alone or with other formats


DIRECT RECORD ACCESS [top]

FIELD NAME EXAMPLES
DIALOG Accession Number TYPE 1951420/5
DISPLAY 1951413/CO,UO
PRINT 1951409/3


Rates [top]

Rates For File: Corporate Affiliations[513]
Cost per DialUnit:                 $8.31
Cost per minute:                   $1.77
Report Elements                    $0.15
Rank Elements                      $0.00

Format    Types   Prints
     1    $0.00    $0.00
     2    $5.00    $5.00
     3    $4.00    $4.00
     5    $6.00    $6.00
     6    $0.60    $0.60
     7    $4.00    $4.00
     8    $1.10    $1.10
     9    $0.00    $0.00
    10    $1.50    $1.50
    11    $9.99    $9.99
    12   $39.99   $39.99
    13   $69.99   $69.99
    14   $99.99   $99.99
    15  $129.99  $129.99
    16  $159.99  $159.99
    17  $199.99  $199.99
    18  $239.99  $239.99
    19  $279.99  $279.99
    20  $310.99  $310.99
KWIC95    $0.12       NA
KWIC96    $0.12       NA

REDIST/COPY Multiplier Table:

      Range      Multiplier
        1-2       1.00
       3-25       1.50
     26-100       3.00
    101-200       4.00
    201-500       6.00
   501-1000       8.00
 1001 or more    10.00

ARCHIVE Multiplier Table:

      Range      Multiplier
       1-25       1.50
     26-200       3.00
    201-500       6.00
   501-1000       8.00
 1001 or more    10.00
------------

Note:
Full record prices are based on the number of affiliates
in a corporate family hierarchy. Use Format 6 to view the
number of affiliates in a corporate family hierarchy. Full
record prices are as follows:

1-3       AFFILIATES            $9.99
4-10      AFFILIATES           $39.99
11-20     AFFILIATES           $69.99
21-30     AFFILIATES           $99.99
31-40     AFFILIATES          $129.99
41-50     AFFILIATES          $159.99
51-60     AFFILIATES          $199.99
61-70     AFFILIATES          $239.99
71-80     AFFILIATES          $279.99
81+       AFFILIATES          $310.99
[top]



All contents Copyright © Dialog, LLC. All rights reserved.
If you have any questions about, problems with, or corrections for our Web site,
please contact Customer Service for assistance.