Twitter   Facebook   e-Newsletters   Podcsts   RSS Feeds   Share

520
D&B WorldBase® - Canada

Last Loaded on Web: Wednesday, May 01, 2013

Last Update To Bluesheet: October 24, 2012

Bluesheet Contents     PDF version

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


File Description [top]

D&B WorldBase® - Canada, File 520, is a Canadian company directory with family affiliations, executives and basic financial information for over 3 million companies.

File 520 has been expanded to include more companies and enhanced. A Record Type field is now available enabling precision retrieval of records of interest. Record types of Marketable or Non Marketable, Active or Inactive, and Linked or Non Linked are searchable as SF= and can be displayed with tags SF or RT. While online, enter Help News520 for details of the record types.

The file name has been changed to D&B WorldBase® - Canada, from D&B - Canadian Dun's Market Identifiers®, to better reflect the content from D&B. The database is developed from interviews conducted by D&B's staff of business analysts located around the world, as well as government sources, large volume mailings, and third-party sources.



Tips [top]

USE FILE 520

to find directory information on Canadian businesses.

USE /CO OR CO=

to find the names of companies and businesses.

USE PC=

to find businesses by primary SIC code.



Subject Coverage [top]

  • Public Canadian companies
  • Private Canadian companies
  • Government-run Canadian companies

Establishments of all sizes and in all industries are included.



Print Counterparts [top]

  • None


Dialog File Data [top]

Dates Covered: Current
File Size: 3,187,177 records as of 2012Q3
Update Frequency: Quarterly


Database Content [top]

  • Directories


Document Types Indexed [top]

  • NA


Geographic Coverage [top]

  • International


Special Features [top]


DialIndex/OneSearch Categories [top]

ACRONYM CATEGORY NAME
CANADACO Canadian Company Directories
CODIR Company Directories
DUNSINTL D&B Directory Files
INTLCO International Company Directories


Contact [top]

D&B WorldBase® - Canada is produced by Dun & Bradstreet. Inc. Questions concerning file content should be directed to:

The Knowledge Center
Dialog
2250 Perimeter Park Drive
Suite 300

Morrisville, NC 27560

Telephone: 919.804.6400
800 Line: 1-800-3DIALOG
Fax: 919.804.6410
E-Mail: customer@dialog.com


Terms and Conditions [top]

D&B WorldBase® is a registered trademark of Dun & Bradstreet, Inc.

D&B WorldBase® - Canada: Access to and use of the Dun & Bradstreet database is subject to the Terms of Agreement between you and the company, partnership, or entity with which you are associated (hereinafter "Company") and Dun & Bradstreet, Inc. ("D&B"). By accessing a D&B database, you agree that you have authority to enter the Terms of Agreement on behalf of your Company and that you have read the terms of Agreement, understand them and agree on behalf of your Company to be bound by them. (See Dialog's Information Provider Terms and Conditions for the above-mentioned Terms of Agreement.)


Dialog Standard Terms & Conditions apply.


SAMPLE RECORD [top]

    DIALOG(R)File 520:D&B WorldBase(R)-Canada 2011 
    (c) 2011 Dun & Bradstreet. All rts. reserv. 
    192925779 
     
  /CO,CO=  AFEXA LIFE SCIENCES INC 
  A1=  9604 20 AVE NW 
  CY=,ST=,ZP=  EDMONTON, AB  T6N 1G1 
  CN=  CANADA 
  CX=  COUNTY:           ALBERTA 
  ST=  STATE/PROVINCE:   ALBERTA (AB) 
  RG=  REGION:           North America 
    TELEPHONE:  (0001) 780-432-0022 
    FAX NUMBER: (0001) 7804327772 
     
  /DE  BUSINESS: COMMERCIAL PHYSICAL RESEARCH, NSK 
  PC=,P2=  PRIMARY SIC:      8731  Commercial physical research 
  SC=,S2=  SECONDARY SIC(S): 5122  Whol drugs/sundries 
                      2834  Mfg pharmaceutical preparations 
                      6712  Bank holding company 
     
  OY=  LATEST YEAR ORGANIZED:  1992 
  EH=  EMPLOYEES HERE:              60E 
  EM=  EMPLOYEES TOTAL:             80E 
     
                    US Dollar          Canadian Dollar 
  SA=,SL=  SALES          43,917,898                  47,592,000 
  PR=  PROFIT          1,200,563                   1,301,000 
  NW=  NET WORTH      21,279,768                  23,060,000 
     
  SD=  DATE OF FINANCIALS: 30 Sep 2009 
    US$ conversion rate is provided for comparison purposes 
  .  Conversion rate used: 0.9207 Canadian Dollar/US$ (090901) 
     
    THIS IS: 
  SF=      An Ultimate Location 
        A  Headquarters Location 
        A  Corporation 
        A  Public Company 
        An Exporter 
     
    PREVIOUS DUNS NUMBER: 20-338-0485 
  DN=  DUNS NUMBER: 24-983-1900 
     
  DP=  PARENT DUNS:                   24-983-1900 
  IP=  PARENT NAME:                   AFEXA LIFE SCIENCES INC 
    PARENT ADDRESS:                9604 20 AVE NW 
  IY=  PARENT CITY:                   EDMONTON 
  IS=  PARENT STATE/PROVINCE:         ALBERTA (AB) 
  IO=  PARENT COUNTRY:                CANADA 
     
  DD=  DOMESTIC ULTIMATE DUNS:        24-983-1900 
    DOMESTIC ULTIMATE NAME:        AFEXA LIFE SCIENCES INC 
    DOMESTIC ULTIMATE ADDRESS:     9604 20 AVE NW 
    DOMESTIC ULTIMATE CITY:        EDMONTON 
    DOMESTIC ULTIMATE STATE/PROV.: ALBERTA (AB) 
    DOMESTIC ULTIMATE COUNTRY:     CANADA 
     
  DC=  GLOBAL ULTIMATE DUNS:          24-983-1900 
  UN=  GLOBAL ULTIMATE NAME:          AFEXA LIFE SCIENCES INC 
    GLOBAL ULTIMATE ADDRESS:       9604 20 AVE NW 
  UY=  GLOBAL ULTIMATE CITY:          EDMONTON 
  US=  GLOBAL ULTIMATE STATE/PROV.:   ALBERTA (AB) 
  UO=  GLOBAL ULTIMATE COUNTRY:       CANADA 
     
  NT=  NUMBER OF FAMILY MEMBERS: 3 
  NM=  TOP EXECUTIVE:   KIT BING CHAN 
  SF=  RECORD TYPE: Marketable, Linked, Active 
  PD=,PY=  RECORD UPDATE DATE: 16 Aug 2010 
  FD=  FAMILY UPDATE DATE: 16 Aug 2010 
     


BASIC INDEX [top]

SEARCH
SUFFIX
DISPLAY
CODE
REPORT
(FIELD
LENGTH)
FIELD NAME

INDEXING

SELECT EXAMPLES

None None None All Basic Index Fields Word S RESEARCH?
/CO CO CO (34) Company Name1 Word S (AFEXA(W)LIFE)/CO
/DE DE None Description of Business and SIC Description Word S (PHARMA?(S)PREP?)/DE

1 Searchable in the Basic Index and in the Additional Indexes.


ADDITIONAL INDEXES [top]

SEARCH
PREFIX
DISPLAY
CODE
REPORT
(FIELD
LENGTH)
FIELD NAME

INDEXING

SELECT EXAMPLES

A1= A1 A1 (32) Street Address Word S A1=(20(W)AVE(W)NW)
None A2 A2 (32) Mailing Address
None AN AN (11) DIALOG Accession Number
CN= CN CN (32) Country Name Phrase S CN=CANADA
CO= CO CO (34) Company Name1 Phrase S CO=AFEXA LIFE?
CX= CX CX (30) County Name Phrase S CX=ALBERTA
CY= CY CY (30) City Phrase S CY=EDMONTON
DC= DC DC (13) Global Ultimate DUNS Number Phrase S DC=24-983-1900
DD= DD DD (13) Domestic Ultimate DUNS Number Phrase S DD=24-983-1900
DH= DH DH (14) Headquarters DUNS Number Phrase S DH=00-404-8013
DN= DN DN (13) DUNS Number Phrase S DN=24-983-1900
DP= DP DP (13) Parent DUNS Number Phrase S DP=24-983-1900
EH= EH EH (12) Employees Here Numeric S EH=60
EM= EM EM (12) Employees Total Numeric S EM=>80
FD= FD FD (13) Family Update Date Phrase S FD=090603
S FD=20090603
None FX FX (29) Fax Number
IO= IO IP (32) Parent Country Phrase S IO=CANADA
IP= IP IP (32) Parent Company Name Phrase S IP=AFEXA LIFE SCI?
IS= IS IS (20) Parent State/Province Phrase S IS=ALBERTA
S IS=AB
IY= IY IY (30) Parent City Phrase S IY=EDMONTON
NM= NM NM (32) Executive Names Word S NM=(JACK(2N)MOFFATT)
NT= NT NT (12) Number of Family Members5 Numeric S NT=3
NW= NW NW (20) Net Worth2 Numeric S NW=19M
OY= OY OY (11) Latest Year Organized Phrase S OY=1992
P2= None None 2-digit Primary U.S. SIC Code Phrase S P2=28
PC= PC PC (9) Primary SIC Code Phrase S PC=8731
PD= PD PD (13) Record Update Date Phrase S PD=090603
S PD=20090603
PO= PO PD (22) Executive Position Phrase S PO=DIRECTEUR GENERALE
PR= PR PR (20) Profit Numeric S PR=4.3M
PY= PY PY (13) Record Update Year Phrase S PY=2009
RG= RG RG (28) Region Phrase S RG=NORTH AMERICA
None RT None Record Type4
S2= None None 2-digit U.S. SIC Code Phrase S S2=51
SA= SA SA (20) Sales (U.S. $)2 Numeric S SA=46M
SC= SC None U.S. SIC Code Phrase S SC=2834
SD= SD SD (13) Date of Financials Phrase S SD=080930
S SD=20080930
SF= SF None Special Features4 Phrase S SF=LINKED
S SF=MARKETABLE

SL= SL SL (20) Sales - Local Currency (Canadian $)2 Numeric S SL=49M
ST= ST ST (20) State/Province Phrase S ST=ALBERTA
None TE TE (22) Telephone3
UD= None None Update Phrase S UD=9999
UN= UN UN (32) Global Ultimate Name Phrase S UN=AFEXA LIFE SCI?
UO= UO UO (22) Global Ultimate Country Phrase S UO=CANADA
US= US US (20) Global Ultimate State/Province Phrase S US=ALBERTA
UY= UY UY (30) Global Ultimate City Phrase S UY=EDMONTON
ZP= ZP ZP (13) Postal Code Phrase S ZP=T6N 1G1

2 Numeric entries are indexed as whole numbers, rounded down to the 2 left-most digits. Negative numbers are preceded by a minus sign. Use numeric operators (<, >, >=, <=, etc.) to search a range of values; e.g., S SA>=1M for records with sales in $US of 1 million or higher. To eliminate records with no data available, S S4 NOT SA=NA.

3 The complete telephone number is displayed.

4 EXPAND SF= for a full list. SF= contains org. type, trade status, and record status. Record Types Marketable or Non Marketable, Active or Inactive, Linked or Non Linked are searchable using SF= and display using SF or RT display tags.

5 Present in Linked records only, e.g., S SF=LINKED


LIMIT [top]

SUFFIX FIELD NAME EXAMPLES
/NAMES Executive name available S S3/NAMES
/NOSALES No sales data available S PC=2869/NOSALES
/SALES Sales data available S S7/SALES
/ULTIMATE Ultimate parent records S S2/ULTIMATE


SORT [top]

SORTABLE FIELDS EXAMPLES
CO, PD, SA SORT S4/ALL/ST/CY
PRINT S5/3/ALL/SA,D


RANK [top]

RANK FIELDS EXAMPLES
All phrase- and numeric-indexed fields in the Additional Indexes can be ranked. Other RANK codes include: IO RANK IO


MAP [top]

MAP FIELDS EXAMPLES
DC, DH, DN, DP MAP DN TEMP S2


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,SL,EM/ALL


USER-DEFINED FORMAT OPTIONS [top]

User-defined formats can be specified using the display codes indicated in the Search Options tables. TYPE S3/CO,CY/1-5


PREDEFINED FORMAT OPTIONS [top]

NO.
DIALOGWEB
FORMAT
RECORD CONTENT
1 -- DIALOG Accession Number
2 -- Full Record
3 Medium Full record Excluding financials, Employees Here, Employees Total, Organization Status, and Latest Year Organized
4 -- Company Name, Address, Telephone Number, DUNS number, Top Executive Name, and Dialog Accession Number
5 Long Full Record
6 Short Company Name, DUNS Number, Number of Family Members, Record Type, Record and Family Update Dates, and Dialog Accession Number
8 -- Company Name, Address, DUNS Number, and Dialog Accession Number
9 Full Full Record
10 -- National Address (excludes country)
20 -- International Address (includes country)
30 -- National Address with Executive Name
40 -- International Address with Executive Name


DIRECT RECORD ACCESS [top]

FIELD NAME EXAMPLES
DIALOG Accession Number TYPE 00100005/5
DISPLAY 0074483/CO,DN
PRINT 50301964/9


Rates [top]

Rates For File: D&B WorldBase® - Canada[520]
Cost per DialUnit:                 $8.43
Cost per minute:                   $2.40
Report Elements                    $0.35
Rank Elements                      $0.00

Format    Types   Prints
     1    $0.00    $0.00
     2    $5.50    $5.50
     3    $3.00    $3.00
     4    $2.00    $2.00
     5    $5.50    $5.50
     6    $1.25    $1.25
     8    $1.50    $1.50
     9    $5.50    $5.50
    10    $1.50    $1.50
    20    $1.50    $1.50
    27    $0.00    $0.00
    30    $1.50    $1.50
    40    $1.50    $1.50
    66    $1.50    $1.50
KWIC95    $0.00       NA
KWIC96    $0.00       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
[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.