Twitter   Facebook   e-Newsletters   Podcsts   RSS Feeds   Share

513
Corporate Affiliations

Last Loaded on Web: Wednesday, May 01, 2013

Last Update To Bluesheet: December 12, 2011

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 ownership information for over 225,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 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: 225,960 records as of 2011Q3 (December 2011)
Update Frequency: Quarterly reload


Database Content [top]

  • Directories


Document Types Indexed [top]

  • NA


Geographic Coverage [top]

  • International


Geographic Restrictions [top]

  • None


Special Features [top]

  • ERA Available
  • Graduate Education Program
  • KWIC and HILIGHT Available
  • REPORT Available
  • MAP Available


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) 2009 LexisNexis Group. All rts. reserv. 
     
    1833342 
  /CO,CO=  Sanofi-Aventis 
    174 avenue de France 
    75365 
  CY=  Paris, Cedex 13 
  CN=  France 
     
    Telephone: (33) 1 53 77 40 00 
    State of Incorporation: FR 
     
  NO=  LNG Enterprise Number: 096148000 
  TS=,EX=  Ticker Symbol: SNY   Stock Exchange: EUR,NYSE, 
     
  NF=  Number of NonUS Affiliates: 67 
  NU=  Number of US Affiliates:     9 
  NT=  Total Affiliates in family: 76 
    Affiliates for this member: 76 
     
  /DE  Business: Pharmaceutical Research & Mfr 
    SIC Codes (Primary listed first): 
  PC=,P2=,/DE     2834   Pharmaceutical Preparations 
  S2=,/DE     8733   Noncommercial Research Organizations 
     
  EM=  Number of Employees: 98,213 
     
  SA=  Sales:                 $35,118,875,200 
  TA=  Total Assets:          $91,704,239,300 
  TL=  Total Liabilities:     $34,549,441,900 
  NW=  Net Worth:             $57,154,797,400 
     
    This is a(n) Parent, nonUS, International Company 
  DS=  Numeric Field(s) Last Updated:  091210 
  DU=  Textual Field(s) Last Updated:  091201 
    Executives: 
  NA=  Administration/Operations 
       Gregory Irace/Administration/Operations 
    Administration/Operations 
       Belen Garijo/Administration/Operations 
             (...) 
    Business Development 
       Jean-Michel Levy/Business Development 
             (...) 
  DO=  Board  of  Directors:  Uwe Bicker;   Jean-Marc Bruel;   Robert Castaigne; 
         Jean-Francois  Dehecq;    Thierry Desmarest;   Lord Douro;   Jean-Rene 
         Fourtou;    Claudie  Haignere;    Igor  Landau;   Christian Mulliez; 
             (...) 
    Corporate Family Hierarchy: 
    =>Sanofi-Aventis 1833342<= 
     Sanofi-Aventis(Subsidiary) 1833341 
     Sanofi-Aventis France(Subsidiary) 1833340 
     Sanofi-Aventis Research & Development(Subsidiary) 1833339 
     Aventis Pharma SA(Subsidiary) 1833338 
     Aventis Pharma S.A.(Subsidiary) 1833337 
     Sanofi Pasteur SA(Subsidiary) 1833336 
     Sanofi Pasteur S.A.(Subsidiary) 1833335 
     Sanofi Pasteur S.A.(Subsidiary) 1833334 
    Sanofi Pasteur MSD, SNC(Joint Venture) 1833333 
             (...) 
     

Sample Affiliate Record

    DIALOG(R)File 513:Corporate Affiliations 
    (c) 2009 LexisNexis Group. All rts. reserv. 
    1833308 
  /CO,CO=  Chugai-Aventis S.N.C. 
    20 Ave Raymond Aron 
  ZP=  92165 
  CY=  Antony, Cedex 
  CN=  France 
    Telephone: (33) 55716089 
     
  NO=  LNG Enterprise Number: 096148048 
     
  UP=,UO=  Ultimate Parent:  Sanofi-Aventis (France) - 1833342 
  IP=,IO=  Immediate Parent: Sanofi-Aventis Research & Development (France) - 1833339 
  SH=  Ownership by Parent: 100.00 % 
  NF=  Number of NonUS Affiliates: 67 
  NU=  Number of US Affiliates:     9 
  NT=  Total Affiliates in family: 76 
    Affiliates for this member: 0 
     
  /DE  Business: Pharmaceutical Products Mfr 
  SC=,PC=,S2=,P2=  SIC Codes (Primary listed first): 
       2834   Pharmaceutical Preparations 
  EM=  Number of Employees: 17 
  SF=  This is a(n) Affiliate, nonUS, International Company 
  DS=  Numeric Field(s) Last Updated:  091210 
  DU=  Textual Field(s) Last Updated:  081001 
     
  NA=  Executives: 
    Managing Partner 
       Jean-Claude Louis/Managing Partner 
     
    Corporate Family Hierarchy: 
    Sanofi-Aventis 1833342 
     Sanofi-Aventis Research & Development(Subsidiary) 1833339 
     =>Chugai-Aventis S.N.C. 1833308<= 
     


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]

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 Full Record
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:                $11.13
Cost per minute:                   $2.67
Report Elements                    $0.20
Rank Elements                      $0.00

Format    Types   Prints
     1    $0.00    $0.00
     2    $7.00    $7.00
     3    $5.50    $5.50
     5    $8.00    $8.00
     6    $0.80    $0.80
     7    $5.50    $5.50
     8    $1.50    $1.50
     9    $0.00    $0.00
    10    $2.00    $2.00
    11   $13.00   $13.00
    12   $53.00   $53.00
    13   $95.00   $95.00
    14  $135.00  $135.00
    15  $176.00  $176.00
    16  $215.00  $215.00
    17  $270.00  $270.00
    18  $324.00  $324.00
    19  $378.00  $378.00
    20  $420.00  $420.00
KWIC95    $0.15       NA
KWIC96    $0.15       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
------------

File 513 Cost Note:
Full record price is based on the number of affiliates
in a corporate family hierarchy. Format 6 displays the
number of affiliates. The full record price varies
across groups by format as shown below. Prices for the
relevant formats are given in the rates table in the
types or prints column.

Affiliates:  Charged as format:
1-3          Format 11
4-10         Format 12
11-20        Format 13
21-30        Format 14
31-40        Format 15
41-50        Format 16
51-60        Format 17
61-70        Format 18
71-80        Format 19
81+          Format 20
[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.