D&B - CANADIAN DUN'S MARKET IDENTIFIERS [520]

HOME : Support : Dialog Search Aids : Bluesheets	Add RSS \| What is RSS?
View Bluesheets by \| Database Name \| File Number \| Subject \| OneSearch Categories \| Search Options \|

	520
D&B - Canadian Dun's Market Identifiers^Ž

Last Loaded on Web: Wednesday, July 01, 2009

Last Update To Bluesheet: July 23, 2008

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 - Canadian Dun's Market Identifiers^Ž, a directory file produced by D&B, Inc., contains basic company data, executive names, corporate linkage information, full address, sales volume in Canadian and U.S. dollars, DUNS^Ž numbers, organizational status, and other marketing information on over 1,141,700 Canadian companies.

D&B - Canadian DMI is extracted on a quarterly basis from the main D&B information bases. Nearly 200 business analysts collect and maintain the data through in-person interviews, supplemented by telephone interviews, government sources, other third party sources, and volume mailings throughout Canada.

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:	1,244,603 records as of January 2005
Update Frequency:	Suspended This file is no longer updating

Database Content [top]

Directories

Document Types Indexed [top]

Geographic Coverage [top]

International

Special Features [top]

ERA Available
Graduate Education Program
Remove Duplicates (RD, ID) Available
REPORT Available
MAP Available

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 - Canadian Dun's Market Identifiers file is produced by D&B, 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 - Canadian Dun's Market Identifiers is a registered trademark of The Dun & Bradstreet Corporation

D&B - Canadian Dun's Market Identifiers: 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-Canadian Dun`s Mkt. Ident.(R)
	`(c) 2003 Dun & Bradstreet. All rts. reserv.`
	`SAMPLE RECORD - DOES NOT CONTAIN ACTUAL DATA`

	`0964142`
/CO, CO=	`Biozymes Inc`
A1=	`480 rue Perreault`
CY=, ZP=	`Levis, PQ G6W 7V6`

TE=	`TELEPHONE: 418-789-2343`

CX=, MC=, MN=	`COUNTY: LEVIS SMSA: 007 (QUEBEC PQ)`

/DE	`BUSINESS: Mfr-enzymes`
P2=, PC=	`PRIMARY US SIC: 2869 (INDUSTRIAL ORGANIC CHEMICALS, NEC)`
S2=, SC=	`SECONDARY US SIC: 2819 (INDUSTRIAL INORGANIC CHEMICALS, NEC`

	`YEAR STARTED: 1993`
YR=	`LATEST YEAR ORGANIZED: 1993`

	`CURRENT TREND BASE`
	`YEAR YEAR YEAR`
	`(1996) (1994)`

SL=, TR=, BR=	`SALES (CANADIAN $): 3,000,000 3,000,000 1,000,000`
SA=	`SALES (U.S. $): 2,058,900`
ET=, TM=, BE=	`EMPLOYEES TOTAL: 15 15 6`
EH=	`EMPLOYEES HERE: 15`

SG=	`SALES GROWTH (%): 200`
EG=	`EMPLOYMENT GROWTH (%): 150`
NW=	`NET WORTH: 2,491,124`

	`THIS IS:`
SF=	`A MANUFACTURING LOCATION`
	`A SINGLE LOCATION`
	`A SUBSIDIARY`

DN=	`DUNS NUMBER: 25-726-5694`

DP=	`PARENT DUNS: 24-709-7470`
IP=	`PARENT COMPANY NAME: Axcan Pharma Inc`
IY=	`PARENT CITY: BELOEIL`
IS=	`PARENT STATE/PROVINCE: PQ`
	`ULTIMATE DOMESTIC DUNS: 24-709-7470`

NA=, PO=	`TOP EXECUTIVE: M. Begin, Jacques / Directeur generale`
	`EXECUTIVE NAMES: M. Vezina, Jean / President`

	`RECORD UPDATE DATE: 09/16/2002`
	`OTHER INFORMATION`
	`CORRESPONDENCE LANGUAGE: English`
	`THE BUSINESS SPACE IS RENTED`

BASIC INDEX [top]

SEARCH SUFFIX	DISPLAY CODE	REPORT (FIELD LENGTH)	FIELD NAME	INDEXING	SELECT EXAMPLES
None	None	None	All Basic Index Fields	Word	S MFR(W)ENZYMES?
/CO	CO	CO (32)	Company Name¹	Word	S BIOZYMES?/CO
/DE	DE	None	Description of Business and SIC Description²	Word	S ORGANIC(W)CHEMICALS?/DE
/IP	IP	IP (32)	Parent Company Name	Word	S AXCAN(W)PHARMA?/IP
/NA	NA	None	Executive Name¹	Word	S JACQUES(1N)BEGIN/NA

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

²Only the Description of Business is displayed with DE; use PC and SC for a display of SIC Descriptions.

ADDITIONAL INDEXES [top]

SEARCH PREFIX	DISPLAY CODE	REPORT (FIELD LENGTH)	FIELD NAME	INDEXING	SELECT EXAMPLES
A1=	A1	A1 (32)	Street Address	Word	S A1=(RUE(W)PERREAULT?)
None	A2	A2 (32)	Mailing Address
None	AN	AN (11)	DIALOG Accession Number
CN=	CN	CN (9)	Country Name	Phrase	S CN=CANADA
CO=	CO	CO (32)	Company Name¹	Phrase	S CO=BIOZYMES?
CX=	CX	CX (21)	County Name	Phrase	S CX=LEVIS
CY=	CY	CY (32)	City	Phrase	S CY=LEVIS
None	DC	DC (13)	DUNS Corporate Number
DH=	DH	DH (13)	DUNS Headquarters Number³	Phrase	S DH=24-597-8101
DN=	DN	DN (13)	DUNS Number	Phrase	S DN=25-726-5694
DP=	DP	DP (13)	DUNS Parent Number⁴	Phrase	S DP=24-709-7470
EG=	EG	EG (10)	Employment Growth (%)^5,8	Numeric	S EG=>100%
EH=	EH	EH (12)	Employees Here⁵	Numeric	S EH=15
EM=	EM	EM (12)	Employees Total⁵	Numeric	S EM>=15
HC=	HC	HC (15)	Headquarters City	Phrase	S HC=OTTAWA?
HS=	HS	HS (10)	Headquarters State/Province	Phrase	S HS=ON
IP=	IP	IP (32)	Parent Company Name	Phrase	S IP=AXCAN PHARMA?
IS=	IS	IS (10)	Parent State/Province	Phrase	S IS=PQ
IY=	IY	IY (15)	Parent City	Phrase	S IY=BELOEIL
MC=	MC	MC (7)	Standard Metropolitan Statistical Area (SMSA) Code	Phrase	S MC=007
MN=	MN	MN (22)	Standard Metropolitan Statistical Area (SMSA) Name	Phrase	S MN=QUEBEC PQ
NA=	CE	CE (21)	Top Executive Name¹	Word & Phrase	S NA=BEGIN(1N)JACQUES S NA=BEGIN, JACQUES
NA=	NA	None	Executive Name¹	Word & Phrase	S NA=JEAN(1N)VEZINA S NA=VEZINA, JEAN
NW=	NW	NW (13)	Net Worth⁵	Numeric	S NW=>2400000
P2=	None	None	2-digit Primary SIC Code	Phrase	S P2=28
PC=	PC	PC (9)	Primary SIC Code	Phrase	S PC=2869
PO=	PO	PO (15)	Executive Position	Phrase	S PO=DIRECTEUR GENERALE
None	RD	RD (12)	Record Update Date
S2=	None	None	2-digit SIC Code	Phrase	S S2=51
SA=	SA	SA (14)	Sales (U.S. $)⁵	Numeric	S SA=>2000000
SC=	SC	None	Standard Industrial Classification (SIC) Code	Phrase	S SC=5169
SF=	OS	OS (14)	Organizational Status	Phrase & Phrase	S SF=MANUFACTURING S SF=SINGLE
SF=	SF	None	Organizational Status⁶	Phrase	S SF=SUBSIDIARY
SG=	SG	SG (8)	Sales Growth (%)^5,8	Numeric	S SG=200%
SL=	SL	SL (14)	Sales - Local Currency (Canadian $)⁵	Numeric	S SL=3000000
ST=	ST	ST (10)	State/Province	Phrase	S ST=PQ
TE=	TE	TE (14)	Telephone Area Code⁷	Phrase	S TE=418
YR=	YR	YR (8)	Latest Year Organized	Phrase	S YR=1993
ZP=	ZP	ZP (9)	Postal Code	Phrase	S ZP=G6W 7V6

³Retrieves the branches of a headquarters within Canada.

⁴Retrieves the subsidiaries (within Canada) of the parent.

⁵Numeric entries are indexed as complete numbers, rounded down to the two 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 to retrieve records with sales in U.S. dollars of 1 million or higher. Use NA to eliminate records with no data available (e.g., S S4 NOT SA=NA).

⁶To see a list of searchable entries, enter EXPAND SF=.

⁷The complete telephone number is displayed.

⁸To exclude entries containing no data, use NOT to eliminate those items before using REPORT, e.g., SELECT SC=5112 NOT SL=NA.

LIMIT [top]

SUFFIX	FIELD NAME	EXAMPLES
Sets and terms can be restricted by Basic Index suffixes, i.e., /CO, /DE, /IP, /NA (e.g., S S2/CO), as well as by the following features:
/NAMES	Executive Name Available	S S3/NAMES
/NOSALES	No Sales Data Available	S PC=2869/NOSALES
/SALES	Sales (Current Year) Data Available	S S7/SALES

SORT [top]

SORTABLE FIELDS	EXAMPLES
CN, CO, CX, CY, DH, DN, DP, EG, EH, EM, IP, MC, MN, PC, SA, SG, SL, ST, TE, YR, ZP	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.	RANK AU S3

MAP [top]

MAP FIELDS	EXAMPLES
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	Company Name, Address, Telephone Number, Description of Business, SIC Codes and Descriptions, Corporate Linkages, and Top Executive Name
4	--	Company Name, Address, Telephone Number, and Top Executive Name
5	--	Full Record
6	Short	Company Name, DUNS Number, and Record Update Date
7	Long	Company Name, DUNS Number, and SIC Codes and Descriptions
8	--	Company Name, Address, 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 - Canadian Dun's Market Identifiers^Ž[520]
Cost per DialUnit:                 $7.01
Cost per minute:                   $1.82
Report Elements                    $0.30
Rank Elements                      $0.00

Format    Types   Prints
     1    $0.00    $0.00
     2    $3.69    $3.69
     3    $2.01    $2.01
     4    $1.46    $1.46
     5    $3.69    $3.69
     6    $0.68    $0.68
     7    $1.46    $1.46
     8    $0.87    $0.87
     9    $3.69    $3.69
    10    $0.87    $0.87
    11    $0.00    $0.00
    20    $0.87    $0.87
    27    $0.00    $0.00
    30    $1.14    $1.14
    40    $1.14    $1.14
    66    $0.85    $0.85
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]