d&b glossary
TRANSCRIPT
Col No Column Name Description
9DnB Effective End Dt
THE EFFECTIVE END DATE OF DUN AND BRADSTREET INFORMATION. THIS IS THE DATE ON WHICH INFORMATION BECOMES INACTIVATE. SEE ALSO DUN AND BRADSTREET EFFECTIVE START DATE (DAB-EFF-STT-DT).
8DnB Effective Start Dt
THE EFFECTIVE START DATE OF DUN AND BRADSTREET INFORMATION. THIS IS THE DATE ON WHICH INFORMATION BECOMES ACTIVE. SEE ALSO DUN AND BRADSTREET EFFECTIVE END DATE (DAB-EFF-END-DT).
7DnB Marketable Ind
INDICATES WHETHER OR NOT THE D&B (DUN AND BRADSTREET) RECORD IS MARKETABLE. MARKETABLE IS A D&B DEFINED DESIGNATION THAT INDICATES THE RECORD HAS ENOUGH OF THE NECESSARY ELEMENTS SUCH AS A VALID BUSINESS NAME AND ADDRESS TO MAKE IT USEFUL FOR MARKETING PURPOSES. THE REQUIREMENTS FOR A RECORD TO BE DESIGNATED MARKETABLE VARY FROM COUNTRY TO COUNTRY. VALID VALUES ARE: 0 = THE D&B RECORD IS NOT MARKETABLE 1 = THE D&B RECORD IS MARKETABLE
6 DnB Active Ind
INDICATES WHETHER OR NOT DUN AND BRADSTREET DATA (A DUNS RECORD) IS ACTIVE. ACTIVE INDICATES THAT A RECORD WITH A DUNS NUMBER WAS FOUND ON THE DUN AND BRADSTREET MARKETING TAPE RECEIVED BY UPS FOR THE CURRENT MONTH VALID VALUES: 0 = DUN AND BRADSTREET DATA (A DUNS RECORD) IS NOT ACTIVE. A RECORD WITH A DUNS NUMBER WAS NOT FOUND THE DUN AND BRADSTREET MARKETING TAPE RECEIVED BY UPS FOR THE CURRENT MONTH 1 = DUN AND BRADSTREET DATA (A DUNS RECORD) IS ACTIVE. A RECORD WITH A DUNS NUMBER WAS FOUND THE DUN AND BRADSTREET MARKETING TAPE RECEIVED BY UPS FOR THE CURRENT MONTH
5DnB Num Of UPS Accounts
DWH DESCRIPTION: QUANTITY OF UPS ACCOUNTS HELD BY THE ENTERPRISE. THE ENTERPRISETIFIER, AKA DUNS NUMBER SOURCE: D&B
41DnB Type Of Ownership Descr
DWH DESCRIPTION: FREE FORM TEXT DESCRIBING THE VALUES IN ENTERPRISE OWNER HOLDINSOURCE: D&B
40DnB Type Of Ownership Cd
CODE REPRESENTING THE TYPE OF ENTERPRISE OWNERSHIP. DWH DESCRIPTION: CODE REPRESENTING THE TYPE OF ENTERPRISE OWNERSHIP SOURCE: D&B
4DnB Bus DBA Name
THE NAME BY WHICH THE ENTERPRISE WISHES TO BE KNOWN WHILE CONDUCTING BUSINESSTRADE/DOING BUSINESS (I.E., 'DOING BUSINESS AS' NAME). SEE ALSO ENTERPRISE NAME (ENP-NA) FOR RELATED INFORMATION.
39DnB Territory Covered Descr
FREE FORM TEXT DESCRIBING THE VALUES IN DUN AND BRADSTREET ENTERPRISE TERRITORY TYPE CODE (DAB-ENP-TRY-TYP-CD).
38DnB Territory Covered Cd
CODE REPRESENTING THE TYPE OF TERRITORY SERVICED BY THE ENTERPRISE, AS PROVIDED BY DUN & BRADSTREET. DWH DESCRIPTION: CODE REPRESENTING THE TYPE OF TERRITORY SERVICED BY THE ENTERPRSOURCE: D&B
37DnB Subsidiary Descr
FREE FORM TEXT DESCRIBING THE VALUES IN DUN AND BRADSTREET ENTERPRISE LOCATION SUBSIDIARY CODE (DAB-ENP-LOC-SBS-CD).
36 DnB Subsidiary Cd
CODE INDICATING WHETHER THE ENTERPRISE LOCATION IS A SUBSIDIARY WITHIN THE CORPORATE HIERARCHY, AS PROVIDED BY DUN & BRADSTREET. DWH DESCRIPTION: FREE FORM TEXT DESCRIBING THE VALUES IN DUN AND BRADSTREET ENTESOURCE: D&B
35DnB Minority Owned Descr
DATA WAREHOUSE DESCRIPTION: FREE FORM TEXT DESCRIBING THE VALUES IN ENTERPRISE OWNER MINORITY CODE (ENP-ONR-MRY-CD).
34DnB Minority Owned Cd
DATA WAREHOUSE DESCRIPTION: IDENTIFIES WHETHER THE ENTERPRISE IS OWNED, EITHER WHOLLY OR PRIMARILY (OVER 51 PERCENT), BY A HOLDING ENTITY (PERSON OR GROUP) CLASSIFIED AS A MINORITY, AS PROVIDED BY DUN & BRADSTREET. THIS IS SELF-DEFINED BY THE ENTERPRISE.
33DnB Location Status Descr
FREE FORM TEXT DESCRIBING THE VALUES IN DUN AND BRADSTREET ENTERPRISE LOCATION STATUS CODE (DAB-ENP-LOC-STS-CD).
32DnB Location Status Cd
CODE REPRESENTING THE STATUS OF THE LOCATION OF THE ENTERPRISE, AS PROVIDED BY DUN & BRADSTREET. DWH DESCRIPTION: CODE REPRESENTING THE STATUS OF A D&B HOST RECORD BEING PASSED EM AT UPS. EXAMPLES OF VALUES: 01 = DELETE RECORD 02 = ADD RECORD SOURCE: D&B
31DnB Legal Structure Descr
FREE FORM TEXT DESCRIBING THE VALUES IN ENTERPRISE LEGAL STRUCTURE TYPE CODE (ENP-LSQ-TYP-CD).
30DnB Legal Structure Cd
CLASSIFIES THE LEGAL FILING (ORGANIZATIONAL) STRUCTURE OF AN ENTERPRISE. DWH DESCRIPTION: THE CODE REPRESENTING THE LEGAL FILING STRUCTURE OF AN ENTERPRISE SOURCE: D&B
3 DnB Bus Name DWH DESCRIPTION: THE NAME OF A BUSINESS IDENTIFIED BY DUN AND
BRADSTREET SOURCE: D&B
29DnB Import Export Descr
DWH DESCRIPTION: FREE FORM TEXT DESCRIBING THE VALUES IN ENTERPRISE LOCATION EXPSOURCE: D&B
28DnB Import Export Cd
CODE REPRESENTING THE INTERNATIONAL TRADING CAPABILITY OF THE SPECIFIC LOCATION OF THE ENTERPRISE. DWH DESCRIPTION: THE CODE REPRESENTING THE WHETHER OR NOT THE BUSINESS ENTITY CONDUCTS IMPORT ANDSOURCE: D&B
27DnB Hierarchy Descr
FREE FORM TEXT DESCRIBING THE VALUES IN DUN AND BRADSTREET ENTERPRISE LOCATION HIERARCHY CODE (DAB-ENP-LOC-HRR-CD).
26 DnB Hierarchy Cd
CODE REPRESENTING THE LEVEL WITHIN THE CORPORATE HIERARCHY AT WHICH THE ENTERPRISE LOCATION IS PLACED, AS PROVIDED BY DUN & BRADSTREET. DWH DESCRIPTION: THE CODE REPRESENTING AT WHAT LEVEL THE SPECIFIC BUSINESS ENTITY RESIDES WITHIN SOURCE: D&B
25DnB DUNS Review Date
THE DATE ON WHICH A DUN AND BRADSTREET ANALYST COMPLETED REVIEW OF ALL INFORMATION REPORTED ABOUT THE BUSINESS. THE FORMAT OF THIS FIELD IS "YYYYMMDD".
24DnB Business Line Descr
TEXT DESCRIBING THE LINE OF BUSINESS IN WHICH AN ENTERPRISE IS ENGAGED. THIS IS AS DEFINED BY THE ENTERPRISE.
23DnB Bus National ID Type Descr
FREE FORM TEXT DESCRIBING THE VALUES IN ENTERPRISE NATIONAL IDENTIFICATION SYSTEM CODE (ENP-NTL-ID-SYS-CD).
22DnB Bus National ID Type Cd
CODE REPRESENTING THE TYPE OF NATIONAL IDENTIFICATION NUMBER SYSTEM USED TO ASSIGN NATIONAL IDENTIFICATION NUMBER TO AN ENTERPRISE. EXAMPLES OF VALUES: 12 = CRO 14 = SIREN ETC.
21DnB Bus National ID
THE IDENTIFYING NUMBER OF AN ENTERPRISE AT THE NATIONAL LEVEL FOR BUSINESS REGISTRATION AND TAX COLLECTION PURPOSES. THIS NUMBER IS ISSUED BY THE GOVERNMENT TAX AUTHORITY OF THE COUNTRY IN WHICH A BUSINESS NORMALLY TRADES. EXAMPLES: "CRO" NUMBER IN UK; "SIREN" NUMBER IN FRANCE; ETC.
20 DnB Bus Start YearDWH DESCRIPTION: THE DATE ON WHICH A BUSINESS BEGAN OPERATIONS SOURCE: D&B
2DnB Prior DUNS Num
THE IDENTIFYING NUMBER OF THE ENTERPRISE PREVIOUSLY ASSIGNED BY DUN AND BRADSTREET. THIS IS COMMONLY REFERRED TO AS PREVIOUS DUNS NUMBER. AN ENTERPRISE IS A UNIT OF ECONOMIC ORGANIZATION OR ACTIVITY, ESPECIALLY A BUSINESS ORGANIZATION. SEE ALSO DUN AND BRADSTREET ENTERPRISE NUMBER (DAB-ENP-NR) FOR RELATED INFORMATION.
19 DnB Suits IndINDICATES WHETHER THE ENTERPRISE HAS ANY SUITS PENDING AGAINST IT. DWH DESCRIPTION: INDICATES WHETHER THE ENTERPRISE HAS ANY SUITS PENDING AGAINST SOURCE: D&B
18DnB Small Business Ind
INDICATES WHETHER THE ENTERPRISE IS CLASSIFIED AS A "SMALL BUSINESS". THIS IS SELF-DEFINED BY THE ENTERPRISE. DWH DESCRIPTION: INDICATES WHETHER THE ENTERPRISE IS CLASSIFIED AS A "SMALL BUSISOURCE: D&B
17DnB Manufacturing Ind
INDICATES WHETHER THE ENTERPRISE IS INVOLVED ANY PRODUCT MANUFACTURING AT THE SPECIFIC LOCATION. DWH DESCRIPTION: INDICATES WHETHER THE ENTERPRISE IS INVOLVED ANY PRODUCT MANUFASOURCE: D&B
16DnB Mail Response Ind
INDICATES WHETHER THE ENTERPRISE HAS PROPENSITY TO RESPOND TO MAIL SOLICITATIONS. DWH DESCRIPTION: INDICATES WHETHER THE ENTERPRISE HAS PROPENSITY TO RESPOND TO MSOURCE: D&B
15 DnB Liens IndINDICATES WHETHER THE ENTERPRISE HAS ANY LIENS PENDING AGAINST IT. DWH DESCRIPTION: INDICATES WHETHER THE ENTERPRISE HAS ANY LIENS PENDING AGAINST SOURCE: D&B
14DnB Judgements Ind
INDICATES WHETHER THE ENTERPRISE HAS ANY JUDGMENTS PENDING AGAINST IT. DWH DESCRIPTION: INDICATES WHETHER A BUSINESS HAS ANY JUDGMENTS ENFORCED OR PENDING AGAINST IT SOURCE: D&B
13DnB Foreign Owned Ind
INDICATES WHETHER THE ENTERPRISE IS OWNED, EITHER WHOLLY OR PARTIALLY (OVER 51 PERCENT), BY A HOLDING ENTITY DOMICILED OUTISDE OF THE COUNTRY IN WHICH THE ENTERPRISE IS LOCATED. DWH DESCRIPTION: INDICATES WHETHER OF NOT A BUSINESS IS WHOLLY OR PRIMARILY OWNED BY A FOREIGN ENSOURCE: D&B
12DnB Female Owned Ind
IDENTIFIES WHETHER THE ENTERPRISE IS OWNED, EITHER WHOLLY OR PRIMARILY (OVER 51 PERCENT), BY AN FEMALE. THIS IS SELF-DEFINED BY THE ENTERPRISE. DWH DESCRIPTION: INDICATES WHETHER OF NOT A BUSINESS IS WHOLLY OR PRIMARILY OWNED BY A FEMALE SOURCE: D&B
11DnB Home Office Ind
INDICATES WHETHER THE ENTERPRISE IS OPERATED OUT OF A PRIVATE RESIDENCE (HOME) OF ITS PRINCIPAL. THIS IS SOMETIMES REFERRED TO AS "COTTAGE INDUSTRY'. DWH DESCRIPTION: INDICATES WHETHER OR NOT A BUSINESS IS HOME BASED SOURCE: D&B
10DnB Bus In Corp Family Ind
INDICATES WHETHER THE BUSINESS LOCATION IS A MEMBER OF A CORPORATE FAMILY, AS PROVIDED BY DUN & BRADSTREET. DWH DESCRIPTION: INDICATES WHETHER OR NOT A BUSINESS IS PART OF A CORPATE FAMILY SOURCE: D&B
1 DnB DUNS NumDATA WAREHOUSE DESCRIPTION: THE IDENTIFYING NUMBER OF AN ENTERPRISE AS ASSIGNED BY DUN AND BRADSTREET. THIS IS COMMONLY REFERRED TO AS DUNS NUMBER.
Col No Column Name Description
1DnB USPS Carrier Route Num
THE IDENTIFYING NUMBER OF THE INDIVIDUAL MAIL CARRIER ROUTE NUMBER FOR MAIL DELIVERY. SORTING MAIL BY CARRIER ROUTE CAN REDUCE MAILING COSTS. SEE ALSO NEW CARRIER ROUTE NUMBER (NEW-CRR-RTE-NR). SEE POSTAL 2 CODE (PSL-2-CD) FOR PARENT ELEMENT DEFINITION.
2 DnB Bus Street
TEXT CONTAINING THE FIRST LINE OF ADDRESS OF AN ENTERPRISE. THIS CONTAINS INFORMATION IDENTIFYING THE STREET AND LOCATION ON THE STREET ASSOCIATED WITH AN ADDRESS. ADDRESS LINE 1 TEXT (AD-LIN-1-TE) FOR PARENT ELEMENT DEFINITION. SEE ALSO ENTERPRISE ADDRESS LINE 2 TEXT (ENP-AD-LIN-2-TE).
3DnB Bus Street Line2
TEXT CONTAINING THE SECOND LINE OF ADDRESS OF AN ENTERPRISE. THIS CONTAINS INFORMATION IDENTIFYING THE ROOM AND/OR FLOOR AND/OR SUITE NUMBER(S) ASSOCIATED WITH AN ADDRESS. SEE ADDRESS LINE 2 TEXT (AD-LIN-2-TE) FOR PARENT ELEMENT DEFINITION. SEE ALSO ENTERPRISE ADDRESS LINE 1 TEXT (ENP-AD-LIN-1-TE).
4DnB Bus City Name
DATA WAREHOUSE DESCRIPTION: THE NAME OF THE SECONDARY POLITICAL DIVISION OF A COUNTRY (E.G., THE NAME OF A CITY, MUNICIPALITY, TOWN, OR VILLAGE) IN WHICH AN ENTERPRISE IS LOCATED, AS PROVIDED BY DUN AND BRADSTREET. THIS DESCRIBES THE VALUES IN ENTERPRISE POLITICAL DIVISION 2 CODE (ENP-POL-DIV-2-CD). SEE POLITICAL DIVISION 2 NAME (POL-DIV-2-NA) FOR PARENT ELEMENT DEFINITION.
5DnB Bus State Province Cd
CODE REPRESENTING THE PRIMARY POLITICAL DIVISION OF A COUNTRY ASSOCIATED WITH AN ADDRESS OF AN ENTERPRISE. VARYING BY COUNTRY, THIS MAY REPRESENT A STATE, A PROVINCE, OR IN SOME CASES SUCH AS IRELAND, A COUNTY. NOT EVERY COUNTRY ASSOCIATES THE COUNTRY'S PRIMARY POLITICAL DIVISIONS WITH POSTAL ADDRESSES. SEE POLITICAL DIVISION 1 CODE (POL-DIV-1-CD) FOR PARENT ELEMENT DEFINITION.
6DnB Bus State Province Name
THE NAME OF THE PRIMARY POLITICAL DIVISION OF A COUNTRY IN WHICH AN ENTERPRISE RESIDES. EXAMPLES: IN THE UNITED STATES, THIS WOULD BE THE NAME OF A STATE. IN CANADA OR ITALY, THIS WOULD BE THE NAME OF A PROVINCE. IN THE U.K. AND IRELAND, THIS WOULD BE THE NAME OF A COUNTY. NOTE: POLITICAL DIVISIONS ARE BASED ACCORDING TO THEIR SIGNIFICANCE IN CONDUCTING DELIVERY SERVICE WORLDWIDE. THIS IS NOT NECESSARILY THE SAME AS GENERALLY ACCEPTED GEO-POLITICAL DIVISIONS.
7DnB Bus Postal Code Main
CODE REPRESENTING THE FIRST PORTION OF THE CODE ASSIGNED BY THE LOCAL (COUNTRY) POSTAL AUTHORITY. IN THE UNITED STATES, THIS IS THE FIRST FIVE DIGITS OF THE FULL 9-DIGIT ZIP CODE. SEE POSTAL 1 CODE (PSL-1-CD) FOR PARENT ELEMENT DEFINITION.
8DnB Bus Postal Code Ext
CODE REPRESENTING THE SECOND PORTION OF THE CODE ASSIGNED BY THE LOCAL (COUNTRY) POSTAL AUTHORITY. IN THE UNITED STATES, THIS IS THE SECOND GROUP OF FOUR DIGITS WITHIN THE 9-DIGIT ZIP CODE, I.E., ZIP+4. SEE POSTAL 2 CODE (PSL-2-CD) FOR PARENT ELEMENT DEFINITION.
9DnB Bus Country Cd
DATA WAREHOUSE DESCRIPTION: CODE REPRESENTING THE UNIQUE IDENTIFIER OF A COUNTRY, AS ASSIGNED BY DUN & BRADSTREET, FOR A SPECIFIC ADDRESS FOR AN ENTERPRISE. FOR EXAMPLE: US = UNITED STATES, CA = CANADA.
10DnB Bus Country Name
THE FULL NAME FOR THE ENTERPRISE ADDRESS COUNTRY CODE (ENP-AD-CNY-CD). SEE COUNTRY NAME (CNY-NA) FOR PARENT ELEMENT DEFINITION.
11DnB Bus County Cd
DWH DESCRIPTION: THE IDENTIFYING NUMBER OF A COUNTY THAT IS ASSOCIATED TO THE ENTERPRISE ADDRESS. THIS NUMBER IS ASSIGNED BY THE GOVERNMENT. THE STATE CODE (BUS_STATE_PROVINCE) MUST BE USED WITH THIS COUNTY NUMBER FOR IT TO BE
12DnB Bus County Name
DWH DESCRIPTION: THE FULL NAME OF A COUNTY IN THE UNITED STATES OF AMERICA THAT IS ASSOCIATED TO THE ENTERPRISE ADDRESS.
13 DnB Geographic THE IDENTIFYING NUMBER OF THE CONTINENT. SEE ALSO CONTINENT NAME
Grouping Cd (CNE-NA).
14DnB Geographic Grouping Name
THE FULL NAME OF THE CONTINENT. SEE ALSO CONTINENT NUMBER (CNE-NR).
15 DnB Latitude Num
THE IDENTIFYING NUMBER OF THE LATITUDE AT WHICH THE ENTERPRISE IS LOCATED, AS REPORTED BY DUN AND BRADSTREET. LATITUDE IS AN IMAGINARY LINE PARALLEL TO THE EQUATOR AND IS MEASURED AS AN ANGULAR DISTANCE NORTH OR SOUTH OF THE EQUATOR. NOTE: THERE ARE SEVERAL SYSTEMS FOR COMPUTING LATITUDES. IT IS USUALLY A DECIMAL DEGREE VALUE REPRESENTING A POSITION IN THE WORLD, WHERE THE WORLD IS DEFINED IN GLOBAL CARTESIAN COORDINATES. SEE LATITUDE NUMBER (LAT-NR) FOR PARENT ELEMENT DEFINITION.
16DnB Longitude Num
THE IDENTIFYING NUMBER OF THE LONGITUDE AT WHICH THE ENTERPRISE IS LOCATED, AS REPORTED BY DUN AND BRADSTREET. LONGITUDE IS AN IMAGINARY LINE PARALLEL TO THE PRIME MERIDIAN AT GREENWICH, ENGLAND, AND IS MEASURED AS AN ANGULAR DISTANCE, EAST OR WEST OF THE PRIME MERIDIAN AT GREENWICH. NOTE: THERE ARE SEVERAL SYSTEMS FOR COMPUTING LONGITUDES. IT IS USUALLY A DECIMAL DEGREE VALUE REPRESENTING A POSITION IN THE WORLD, WHERE THE WORLD IS DEFINED IN GLOBAL CARTESIAN COORDINATES. SEE LONGITUDE NUMBER (LNG-NR) FOR PARENT ELEMENT DEFINITION.
17DnB Bus Phone Num Country Ext
THE IDENTIFYING NUMBER OF THE COUNTRY ACCESS FOR A DEVICE CONNECTED TO A TELECOMMUNICATION LINE FOR AN ENTERPRISE. SEE TELECOMMUNICATIONS LINE COUNTRY ACCESS NUMBER (TLC-LIN-CNY-ACS-NR) FOR PARENT ELEMENT DEFINITION.
18DnB Bus Phone Num Voice
THE IDENTIFYING NUMBER OF A TELECOMMUNICATIONS LINE DEDICATED TO THE TRANSMISSION OF A VOICE (I.E., A PHONE NUMBER USED FOR PERSON TO PERSON COMMUNICATION) FOR AN ADDRESS OF AN ENTERPRISE. SEE VOICE LINE NUMBER (VOI-LIN-NR) FOR PARENT ELEMENT DEFINITION. SEE ALSO ADDRESS VOICE LINE NUMBER (AD-VOI-LIN-NR).
19DnB Bus Phone Num Data
THE IDENTIFYING NUMBER OF THE TELEX MACHINE (AT A SPECIFIC ADDRESS) ON WHICH THE RELATED ENTERPRISE RECEIVES MESSAGES. SEE ADDRESS TELEX NUMBER (AD-TLX-NR) FOR PARENT ELEMENT DEFINITION.
20DnB Bus Phone Num Fax
THE UNIQUE IDENTIFYING NUMBER OF A TELECOMMUNICATIONS LINE DEDICATED TO THE TRANSMISSION OF FACSIMILES (I.E., FAXES) ASSOCIATED WITH AN ADDRESS OF AN ENTERPRISE. SEE FAX LINE NUMBER (FAX-LIN-NR) FOR PARENT ELEMENT DEFINITION. SEE ALSO ENTERPRISE ADDRESS TELEX NUMBER (ENP-AD-TLX-NR).
Col No Column Name Description
1DnB Address Type Cd
IDENTIFIES THE PURPOSE OF A SPECIFIC ADDRESS ASSOCIATED WITH AN ENTERPRISE.
2DnB Address Type Descr
FREE FORM TEXT DESCRIBING THE VALUES IN ENTERPRISE ADDRESS TYPE CODE (ENT-AD-TYP-CD).
3 DnB Bus Street
TEXT CONTAINING THE FIRST LINE OF ADDRESS OF AN ENTERPRISE. THIS CONTAINS INFORMATION IDENTIFYING THE STREET AND LOCATION ON THE STREET ASSOCIATED WITH AN ADDRESS. ADDRESS LINE 1 TEXT (AD-LIN-1-TE) FOR PARENT ELEMENT DEFINITION. SEE ALSO ENTERPRISE ADDRESS LINE 2 TEXT (ENP-AD-LIN-2-TE).
4DnB Bus Street Line2
TEXT CONTAINING THE SECOND LINE OF ADDRESS OF AN ENTERPRISE. THIS CONTAINS INFORMATION IDENTIFYING THE ROOM AND/OR FLOOR AND/OR SUITE NUMBER(S) ASSOCIATED WITH AN ADDRESS. SEE ADDRESS LINE 2 TEXT (AD-LIN-2-TE) FOR PARENT ELEMENT DEFINITION. SEE ALSO ENTERPRISE ADDRESS LINE 1 TEXT (ENP-AD-LIN-1-TE).
5DnB Bus City Name
DATA WAREHOUSE DESCRIPTION: THE NAME OF THE SECONDARY POLITICAL DIVISION OF A COUNTRY (E.G., THE NAME OF A CITY, MUNICIPALITY, TOWN, OR VILLAGE) IN WHICH AN ENTERPRISE IS LOCATED, AS PROVIDED BY DUN AND BRADSTREET. THIS DESCRIBES THE VALUES IN ENTERPRISE POLITICAL DIVISION 2 CODE (ENP-POL-DIV-2-CD). SEE POLITICAL DIVISION 2 NAME (POL-DIV-2-NA) FOR PARENT ELEMENT DEFINITION.
6DnB Bus State Province Cd
CODE REPRESENTING THE PRIMARY POLITICAL DIVISION OF A COUNTRY ASSOCIATED WITH AN ADDRESS OF AN ENTERPRISE. VARYING BY COUNTRY, THIS MAY REPRESENT A STATE, A PROVINCE, OR IN SOME CASES SUCH AS IRELAND, A COUNTY. NOT EVERY COUNTRY ASSOCIATES THE COUNTRY'S PRIMARY POLITICAL DIVISIONS WITH POSTAL ADDRESSES. SEE POLITICAL DIVISION 1 CODE (POL-DIV-1-CD) FOR PARENT ELEMENT DEFINITION.
7DnB Bus State Province Name
THE NAME OF THE PRIMARY POLITICAL DIVISION OF A COUNTRY IN WHICH AN ENTERPRISE RESIDES. EXAMPLES: IN THE UNITED STATES, THIS WOULD BE THE NAME OF A STATE. IN CANADA OR ITALY, THIS WOULD BE THE NAME OF A PROVINCE. IN THE U.K. AND IRELAND, THIS WOULD BE THE NAME OF A COUNTY. NOTE: POLITICAL DIVISIONS ARE BASED ACCORDING TO THEIR SIGNIFICANCE IN CONDUCTING DELIVERY SERVICE WORLDWIDE. THIS IS NOT NECESSARILY THE SAME AS GENERALLY ACCEPTED GEO-POLITICAL DIVISIONS.
8DnB Bus Postal Code Main
CODE REPRESENTING THE FIRST PORTION OF THE CODE ASSIGNED BY THE LOCAL (COUNTRY) POSTAL AUTHORITY. IN THE UNITED STATES, THIS IS THE FIRST FIVE DIGITS OF THE FULL 9-DIGIT ZIP CODE. SEE POSTAL 1 CODE (PSL-1-CD) FOR PARENT ELEMENT DEFINITION.
9DnB Bus Postal Code Ext
CODE REPRESENTING THE SECOND PORTION OF THE CODE ASSIGNED BY THE LOCAL (COUNTRY) POSTAL AUTHORITY. IN THE UNITED STATES, THIS IS THE SECOND GROUP OF FOUR DIGITS WITHIN THE 9-DIGIT ZIP CODE, I.E., ZIP+4. SEE POSTAL 2 CODE (PSL-2-CD) FOR PARENT ELEMENT DEFINITION.
10DnB Bus Country Cd
DATA WAREHOUSE DESCRIPTION: CODE REPRESENTING THE UNIQUE IDENTIFIER OF A COUNTRY, AS ASSIGNED BY DUN & BRADSTREET, FOR A SPECIFIC ADDRESS FOR AN ENTERPRISE. FOR EXAMPLE: US = UNITED STATES, CA = CANADA.
11DnB Bus Country Name
THE FULL NAME FOR THE ENTERPRISE ADDRESS COUNTRY CODE (ENP-AD-CNY-CD). SEE COUNTRY NAME (CNY-NA) FOR PARENT ELEMENT DEFINITION.
12DnB Bus County Cd
DWH DESCRIPTION: THE IDENTIFYING NUMBER OF A COUNTY THAT IS ASSOCIATED TO THE ENTERPRISE ADDRESS. THIS NUMBER IS ASSIGNED BY THE GOVERNMENT. THE STATE CODE (BUS_STATE_PROVINCE) MUST BE USED WITH THIS COUNTY NUMBER FOR IT TO BE
13DnB Bus County Name
DWH DESCRIPTION: THE FULL NAME OF A COUNTY IN THE UNITED STATES OF AMERICA THAT IS ASSOCIATED TO THE ENTERPRISE ADDRESS.
14DnB Geographic Grouping Cd
THE IDENTIFYING NUMBER OF THE CONTINENT. SEE ALSO CONTINENT NAME (CNE-NA).
15DnB Geographic Grouping Name
THE FULL NAME OF THE CONTINENT. SEE ALSO CONTINENT NUMBER (CNE-NR).
16DnB Bus Phone Num Country Ext
THE IDENTIFYING NUMBER OF THE COUNTRY ACCESS FOR A DEVICE CONNECTED TO A TELECOMMUNICATION LINE FOR AN ENTERPRISE. SEE TELECOMMUNICATIONS LINE COUNTRY ACCESS NUMBER (TLC-LIN-CNY-ACS-NR) FOR PARENT ELEMENT DEFINITION.
17DnB Bus Phone Num Voice
THE IDENTIFYING NUMBER OF A TELECOMMUNICATIONS LINE DEDICATED TO THE TRANSMISSION OF A VOICE (I.E., A PHONE NUMBER USED FOR PERSON TO PERSON COMMUNICATION) FOR AN ADDRESS OF AN ENTERPRISE. SEE VOICE LINE NUMBER (VOI-LIN-NR) FOR PARENT ELEMENT DEFINITION. SEE ALSO ADDRESS VOICE LINE NUMBER (AD-VOI-LIN-NR).
18DnB Bus Phone Num Data
THE IDENTIFYING NUMBER OF THE TELEX MACHINE (AT A SPECIFIC ADDRESS) ON WHICH THE RELATED ENTERPRISE RECEIVES MESSAGES. SEE ADDRESS TELEX NUMBER (AD-TLX-NR) FOR PARENT ELEMENT DEFINITION.
19DnB Bus Phone Num Fax
THE UNIQUE IDENTIFYING NUMBER OF A TELECOMMUNICATIONS LINE DEDICATED TO THE TRANSMISSION OF FACSIMILES (I.E., FAXES) ASSOCIATED WITH AN ADDRESS OF AN ENTERPRISE. SEE FAX LINE NUMBER (FAX-LIN-NR) FOR PARENT ELEMENT DEFINITION. SEE ALSO ENTERPRISE ADDRESS TELEX NUMBER (ENP-AD-TLX-NR).
Col No Column Name Description
1DnB Rec Chg Typ Cd
CODE REPRESENTING THE TYPE OF CHANGE MADE TO A DUN AND BRADSTREET RECORD. EXAMPLES OF VALUES: 00 = DATA NOT AVAILABLE 01 = RECORD NOT CHANGED 02 = RECORD ADDED 03 = RECORD DELETED 04 = RECORD CHANGED FOR NON-INDICATED FIELDS ONLY 05 = RECORD CHANGED FOR INDICATED FIELDS ONLY 06 = RECORD CHANGED FOR BOTH NON-INDICATED AND INDICATED FIELDS 99 = UNCLASSIFIED
2DnB Rec Chg Type Descr
TEXT DESCRIBING OR EXPLAINING THE TYPE OF CHANGE MADE TO A DUN AND BRADSTREET RECORD (FOR EXAMPLE, RECORD ADDED, RECORD NOT CHANGED, RECORD DELETED, ETC.) SEE DUN AND BRADSTREET RECORD CHANGE CODE (DAB-REC-CHN-CD) AND DUN AND BRADSTREET RECORD CHANGE CODE DESCRIPTION TEXT (DAB-REC-CHN-DSC-TE) FOR RELATED INFORMATION.
3 DnB Marketable Chg Cd
CODE REPRESENTING WHAT CHANGE, IF ANY, OCCURRED IN THE MARKETABILITY STATUS OF A D&B (DUN AND BRADSTREET) RECORD. MARKETABLE IS A D&B DEFINED DESIGNATION THAT INDICATES THE RECORD MEETS BASIC REQUIREMENTS SUCH AS BEING ACTIVE (NOT OUT OF BUSINESS) AND HAS THE NECESSARY ELEMENTS SUCH AS A VALID BUSINESS NAME AND ADDRESS TO
MAKE IT USEFUL FOR MARKETING PURPOSES. THE EXACT REQUIREMENTS FOR A RECORD TO BE DESIGNATED MARKETABLE VARY FROM COUNTRY TO COUNTRY.EXAMPLES OF VALUES ARE: 00 - NO CHANGE IN MARKETABILITY STATUS; 01 - CHANGE FROM MARKETABLE TO UNMARKETABLE; 02 - CHANGE FROM UNMARKETABLE TO MARKETABLE
4DnB Marketable Chg Descr
FREE FORM TEXT DESCRIBING THE VALUES IN A D&B ( DUN AND BRADSTREET) MARKETABLE CHANGE CODE (SEE 'DAB-MKA-CHN-CD').
5DnB Bus DBA Name Chg Ind
INDICATES WHETHER OR NOT THE NAME BY WHICH THE ENTERPRISE WISHES TO BE KNOWN WHILE CONDUCTING BUSINESS HAS CHANGED. VALID VALUES: 0 = NAME BY WHICH THE ENTERPRISE WISHES TO BE KNOWN HAS NOT CHANGED 1 = NAME BY WHICH THE ENTERPRISE WISHES TO BE KNOWN HAS CHANGED SEE ENTERPRISE TRADING NAME (ENP-TRD-NA) FOR RELATED INFORMATION.
6DnB Bus Name Chg Ind
INDICATES WHETHER OR NOT THE FULL NAME OF THE ENTERPRISE HAS CHANGED. VALID VALUES: 0 = FULL NAME OF THE ENTERPRISE HAS NOT CHANGED 1 = FULL NAME OF THE ENTERPRISE HAS CHANGED SEE ENTERPRISE NAME (ENP-NA) FOR RELATED INFORMATION.
7DnB Bus National ID Chg Ind
INDICATES WHETHER OR NOT THE IDENTIFYING NUMBER OF AN ENTERPRISE AT THE NATIONAL LEVEL FOR BUSINESS REGISTRATION AND TAX COLLECTION PURPOSES HAS CHANGED. THIS NUMBER IS ISSUED BY THE GOVERNMENT TAX AUTHORITY OF THE COUNTRY IN WHICH A BUSINESS NORMALLY TRADES. VALID VALUES: 0 = IDENTIFYING NUMBER OF AN ENTERPRISE AT THE NATIONAL LEVEL HAS NOT CHANGED 1 = IDENTIFYING NUMBER OF AN ENTERPRISE AT THE NATIONAL LEVEL HAS CHANGED
8DnB Bus Street Chg Ind
INDICATES WHETHER OR NOT TEXT CONTAINING THE FIRST LINE OF ADDRESS HAS CHANGED. THIS CONTAINS INFORMATION IDENTIFYING THE STREET AND LOCATION ON THE STREET ASSOCIATED WITH AN ADDRESS. VALID VALUES: 0 = TEXT CONTAINING THE FIRST LINE OF ADDRESS HAS NOT CHANGED 1 = TEXT CONTAINING THE FIRST LINE OF ADDRESS HAS CHANGED SEE ADDRESS LINE 1 TEXT (AD-LIN-1-TE) FOR RELATED INFORMATION.
9DnB Bus Street Line2 Chg Ind
INDICATES WHETHER OR NOT TEXT CONTAINING THE SECOND LINE OF ADDRESS HAS CHANGED. THIS CONTAINS INFORMATION IDENTIFYING THE ROOM AND/OR FLOOR AND/OR SUITE NUMBER(S) ASSOCIATED WITH AN ADDRESS. VALID VALUES: 0 = TEXT CONTAINING THE SECOND LINE OF ADDRESS HAS NOT CHANGED 1 = TEXT CONTAINING THE SECOND LINE OF ADDRESS HAS CHANGED SEE ADDRESS LINE 2 TEXT (AD-LIN-2-TE) FOR RELATED INFORMATION.
10DnB Bus City Name Chg Ind
INDICATES WHETHER OR NOT TEXT CONTAINING THE NAME OF THE SECONDARY POLITICAL DIVISION OF A COUNTRY (E.G., THE NAME OF A CITY, MUNICIPALITY, TOWN, OR VILLAGE) IN WHICH AN ENTERPRISE IS LOCATED HAS CHANGED. VALID VALUES: 0 = THE TEXT CONTAINING THE NAME OF THE SECONDARY POLITICAL DIVISION OF A COUNTRY HAS NOT CHANGED 1 = THE TEXT CONTAINING THE NAME OF THE SECONDARY POLITICAL DIVISION OF A COUNTRY HAS CHANGED
11DnB Bus State Prov Name Chg Ind
INDICATES WHETHER OR NOT POLITICAL DIVISION 1 HAS CHANGED IN AN ADDRESS. VALID VALUES: 0 = POLITICAL DIVISION 1 HAS NOT CHANGED IN AN ADDRESS 1 = POLITICAL DIVISION 1 HAS CHANGED IN AN ADDRESS SEE ALSO POLITICAL DIVISION 1 CODE (POL-DIV-1-CD) AND POLITICAL DIVISION 1 NAME (POL-DIV-1-NA).
12DnB Bus Postal Code Main Chg Ind
INDICATES WHETHER OR NOT THE FIRST PORTION OF THE CODE ASSIGNED BY THE LOCAL (COUNTRY) POSTAL AUTHORITY HAS CHANGED. IN THE UNITED STATES, THIS IS THE FIRST FIVE DIGITS OF THE FULL 9-DIGIT ZIP CODE. VALID VALUES: 0 = FIRST PORTION OF THE CODE ASSIGNED BY THE LOCAL (COUNTRY) POSTAL AUTHORITY HAS NOT CHANGED 1 = FIRST PORTION OF THE CODE ASSIGNED BY THE LOCAL (COUNTRY) POSTAL AUTHORITY HAS CHANGED
13DnB Bus Postal Code Ext Chg Ind
INDICATES WHETHER OR NOT THE SECOND PORTION OF THE CODE ASSIGNED BY THE LOCAL (COUNTRY) POSTAL AUTHORITY HAS CHANGED. IN THE UNITED STATES, THIS IS THE SECOND GROUP OF FOUR DIGITS WITHIN THE 9-DIGIT ZIP CODE, I.E., ZIP+4. VALID VALUES: 0 = SECOND PORTION OF THE CODE ASSIGNED BY THE LOCAL (COUNTRY) POSTAL AUTHORITY HAS NOT CHANGED 1 = SECOND PORTION OF THE CODE ASSIGNED BY THE LOCAL (COUNTRY) POSTAL AUTHORITY HAS CHANGED
14 DnB Bus Phone Num Voice Chg Ind
INDICATES WHETHER OR NOT THE IDENTIFYING NUMBER OF A TELECOMMUNICATIONS LINE DEDICATED TO THE TRANSMISSION OF A VOICE FOR AN ADDRESS OF AN ENTERPRISE, I.E., A PHONE NUMBER USED FOR PERSON-TO-PERSON COMMUNICATION, HAS CHANGED. VALID VALUES: 0 = IDENTIFYING NUMBER OF A TELECOMMUNICATIONS LINE DEDICATED TO THE TRANSMISSION OF A VOICE FOR AN ADDRESS OF AN ENTERPRISE HAS NOT CHANGED 1 =
IDENTIFYING NUMBER OF A TELECOMMUNICATIONS LINE DEDICATED TO THE TRANSMISSION OF A VOICE FOR AN ADDRESS OF AN ENTERPRISE HAS CHANGED
15DnB Dom Ult Prnt DUNS Chg Ind
INDICATES WHETHER OR NOT THE IDENTIFYING NUMBER OF THE DOMESTIC ULTIMATE PARENT ENTERPRISE OF ANOTHER ENTERPRISE AS ASSIGNED BY DUN AND BRADSTREET HAS CHANGED. VALID VALUES: 0 = IDENTIFYING NUMBER OF THE DOMESTIC ULTIMATE PARENT ENTERPRISE OF ANOTHER ENTERPRISE HAS NOT CHANGED 1 = IDENTIFYING NUMBER OF THE DOMESTIC ULTIMATE PARENT ENTERPRISE OF ANOTHER ENTERPRISE HAS CHANGED SEE DUN AND BRADSTREET DOMESTIC ULTIMATE PARENT ENTERPRISE NUMBER (DAB-DOM-UPX-ENP-NR) FOR FURTHER INFORMATION.
16DnB Global Ult Prnt DUNS Chg Ind
INDICATES WHETHER OR NOT THE IDENTIFYING NUMBER OF THE GLOBAL ULTIMATE PARENT ENTERPRISE OF ANOTHER ENTERPRISE AS ASSIGNED BY DUN AND BRADSTREET HAS CHANGED. VALID VALUES: 0 = IDENTIFYING NUMBER OF THE GLOBAL ULTIMATE PARENT ENTERPRISE OF ANOTHER ENTERPRISE HAS NOT CHANGED 1 = IDENTIFYING NUMBER OF THE GLOBAL ULTIMATE PARENT ENTERPRISE OF ANOTHER ENTERPRISE HAS CHANGED SEE DUN AND BRADSTREET GLOBAL ULTIMATE PARENT ENTERPRISE NUMBER (DAB-GLB-UPX-ENP-NR) FOR FURTHER INFORMATION.
17DnB Headquarters DUNS Chg Ind
INDICATES WHETHER OR NOT THE IDENTIFYING NUMBER OF THE ENTERPRISE THAT IS A HEADQUARTERS LOCATION AS ASSIGNED BY DUN AND BRADSTREET HAS CHANGED. VALID VALUES: 0 = IDENTIFYING NUMBER OF THE ENTERPRISE HAS NOT CHANGED 1 = IDENTIFYING NUMBER OF THE ENTERPRISE HAS CHANGED SEE DUN AND BRADSTREET HEADQUARTERS ENTERPRISE NUMBER (DAB-HQ-ENP-NR) FOR FURTHER INFORMATION.
18DnB Mail Street Chg Ind
INDICATES WHETHER OR NOT THE TEXT CONTAINING THE MAILING ADDRESS OF AN ENTERPRISE HAS CHANGED. THE MAILING ADDRESS MAY CONTAIN STREET NUMBER, STREET NAME, POST OFFICE BOX NUMBER, ROOM/SUITE NUMBER. VALID VALUES: 0 = TEXT CONTAINING THE MAILING ADDRESS OF AN ENTERPRISE HAS NOT CHANGED 1 = TEXT CONTAINING THE MAILING ADDRESS OF AN ENTERPRISE HAS CHANGED
19DnB Mail City Name Chg Ind
INDICATES WHETHER OR NOT THE PORTION OF THE MAILING ADDRESS WHICH CONTAINS THE NAME OF THE SECONDARY POLITICAL DIVISION OF A COUNTRY (E.G., THE NAME OF A CITY, MUNICIPALITY, TOWN, OR VILLAGE) HAS CHANGED. VALID VALUES 0 = THE PORTION OF THE MAILING ADDRESS WHICH CONTAINS THE NAME OF THE SECONDARY POLITICAL DIVISION HAS NOT CHANGED 1 = THE PORTION OF THE MAILING ADDRESS WHICH CONTAINS THE NAME OF THE SECONDARY POLITICAL DIVISION HAS CHANGED SEE POLITICAL DIVISION 2 NAME (POL-DIV-2-NA) FOR RELATED INFORMATION.
20DnB Mail State Province Name Chg Ind
INDICATES WHETHER OR NOT THE PORTION OF THE MAILING ADDRESS WHICH CONTAINS THE NAME OF THE PRIMARY POLITICAL DIVISION OF A COUNTRY HAS CHANGED. VALID VALUES: 0 = PORTION OF THE MAILING ADDRESS WHICH CONTAINS THE NAME OF THE PRIMARY POLITICAL DIVISION HAS NOT CHANGED 1 = PORTION OF THE MAILING ADDRESS WHICH CONTAINS THE NAME OF THE PRIMARY POLITICAL DIVISION HAS CHANGED
21DnB Mail Postal Code Main Chg Ind
INDICATES WHETHER OR NOT THE FIRST PORTION OF THE POSTAL CODE IN THE MAILING ADDRESS HAS CHANGED. VALID VALUES: 0 = THE FIRST PORTION OF THE POSTAL CODE HAS NOT CHANGED 1 = THE FIRST PORTION OF THE POSTAL CODE HAS CHANGED
22DnB Mail Postal Code Ext Chg Ind
INDICATES WHETHER OR NOT THE SECOND PORTION OF THE POSTAL CODE IN THE MAILING ADDRESS HAS CHANGED. VALID VALUES: 0 = THE SECOND PORTION OF THE POSTAL CODE HAS NOT CHANGED 1 = THE SECOND PORTION OF THE POSTAL CODE HAS CHANGED
23DnB Mail Phone Num Voice Telephone Chg Ind
INDICATES WHETHER OR NOT THE IDENTIFYING NUMBER OF A TELECOMMUNICATIONS LINE DEDICATED TO THE TRANSMISSION OF A VOICE FOR THE MAILING ADDRESS OF AN ENTERPRISE, I.E., A PHONE NUMBER USED FOR PERSON-TO PERSON COMMUNICATION, HAS CHANGED. VALID VALUES: 0 = IDENTIFYING NUMBER OF A TELECOMMUNICATIONS LINE DEDICATED TO THE TRANSMISSION OF A VOICE FOR THE MAILING ADDRESS OF AN ENTERPRISE HAS NOT CHANGED 1 = IDENTIFYING NUMBER OF A TELECOMMUNICATIONS LINE DEDICATED TO THE TRANSMISSION OF A VOICE FOR THE MAILING ADDRESS OF AN ENTERPRISE HAS CHANGED
24DnB Primary SIC Industry Chg Ind
INDICATES WHETHER OR NOT THE PRIMARY INDUSTRY CODE TO WHICH AN ENTERPRISE IS CLASSIFIED HAS CHANGED. VALID VALUES: 0 = PRIMARY INDUSTRY CODE HAS NOT CHANGED 1 = PRIMARY INDUSTRY CODE HAS CHANGED SEE ENTERPRISE PRIMARY INDUSTRY CODE (ENP-PRI-NDR-CD) FOR FURTHER INFORMATION.
25DnB Secondary SIC Industry Chg Ind
INDICATES WHETHER OR NOT THE SECONDARY INDUSTRY OF AN ENTERPRISE HAS CHANGED. VALID VALUES: 0 = SECONDARY INDUSTRY OF AN ENTERPRISE HAS NOT CHANGED 1 = SECONDARY INDUSTRY OF AN ENTERPRISE HAS CHANGED SEE ENTERPRISE SECONDARY INDUSTRY SUMMARY 1 CODE (ENP-SEC-NDR-1-CD) FOR
Col No Column Name Description
1 DnB Corp Link Cd
CODE REPRESENTING THE KIND/TYPE OF CORPORATE FAMILY TREE LINKAGE AS PROVIDED BY DUN AND BRADSTREET. THIS IS USED PRIMARILY TO IDENTIFY CONDITIONS FOR BROKEN LINKS. EXAMPLES OF VALUES: 00 = DATA NOT AVAILABLE 01 = EITHER STAND-ALONE SINGLE LOCATION BUSINESS, OR CORPORATE FAMILY TREE INTACT 02 = HEADQUARTERS WITHOUT ANY BRANCHES 03 = BRANCH WITHOUT HEADQUARTERS 04 = SUBSIDIARY OF FOREIGN PARENT (PARENT INFORMATION NOT AVAILABLE) 05 = CANADIAN LOCATION, PROVIDED FOR LINKAGE ONLY 06 = NO DIRECT MARKETING PERMITTED TO LOCATION, PROVIDED FOR LINKAGE ONLY
2DnB Corp Link Descr
FREE FORM TEXT DESCRIBING THE VALUES IN DUN AND BRADSTREET CORPORATE LINK CODE (DAB-CRP-LNK-CD).
3DnB Family Sequence Num
THE IDENTIFYING SEQUENCE NUMBER LINKING CORPORATE LOCATIONS WHICH ARE MEMBERS OF A CORPORATE FAMILY TREE AS ASSIGNED BY DUN AND BRADSTREET. THIS IS USED TO ORDER CORPORATE LOCATIONS WITHIN A CORPORATE FAMILY TREE. DUN AND BRADSTREET REFERS TO THIS AS A DIAD CODE. SEE ALSO DUN AND BRADSTREET CORPORATE LINK CODE (DAB-CRP-LNK-CD).
4DnB Dom Ultimate Parent DUNS
THE IDENTIFYING NUMBER OF THE DOMESTIC ULTIMATE PARENT ENTERPRISE OF ANOTHER ENTERPRISE AS ASSIGNED BY DUN AND BRADSTREET. SEE ALSO DUN AND BRADSTREET DOMESTIC ULTIMATE PARENT ENTERPRISE NAME (DAB-DOM-UPX-ENP-NA). SEE ENTERPRISE NUMBER (ENP-NR) FOR PARENT ELEMENT DEFINITION.
5DnB Dom Ultimate Parent Name
THE FULL NAME OF THE DOMESTIC ULTIMATE PARENT ENTERPRISE OF ANOTHER ENTERPRISE AS ASSIGNED BY DUN AND BRADSTREET. SEE ALSO DUN AND BRADSTREET DOMESTIC ULTIMATE PARENT ENTERPRISE NUMBER (DAB-DOM-UPX-ENP-NR). SEE ENTERPRISE NAME (ENP-NA) FOR PARENT ELEMENT DEFINITION.
6DnB Global Ultimate Parent DUNS
THE IDENTIFYING NUMBER OF THE GLOBAL ULTIMATE PARENT ENTERPRISE OF ANOTHER ENTERPRISE AS ASSIGNED BY DUN AND BRADSTREET. IT REPRESENTS THE HIGHEST PARENT OF A CORPORATE FAMILY. SEE ALSO DUN AND BRADSTREET GLOBAL ULTIMATE PARENT ENTERPRISE NAME (DAB-GLB-UPX-ENP-NA). SEE ENTERPRISE NUMBER (ENP-NR) FOR PARENT ELEMENT DEFINITION.
7DnB Global Ultimate Parent Name
THE NAME OF THE GLOBAL ULTIMATE PARENT ENTERPRISE OF ANOTHER ENTERPRISE AS ASSIGNED BY DUN AND BRADSTREET. SEE ALSO DUN AND BRADSTREET GLOBAL ULTIMATE PARENT ENTERPRISE NUMBER (DAB-GLB-UPX-ENP-NR). SEE ENTERPRISE NAME (ENP-NA) FOR PARENT ELEMENT DEFINITION.
8DnB Global Family Member Qty
THE TOTAL QUANTITY OF ENTERPRISE FAMILY MEMBERS, OF DUN AND BRADSTREET, INCLUDING THE GLOBAL ULTIMATE ENTERPRISE, ALL SUBSIDIARIES, AND BRANCHES OF THE ENTERPRISE FAMILY TREE ON A WORLDWIDE BASIS.
9DnB Headquarters DUNS
THE IDENTIFYING NUMBER OF AN ENTERPRISE THAT IS A HEADQUARTERS LOCATION AS ASSIGNED BY DUN AND BRADSTREET. SEE ALSO DUN AND BRADSTREET HEADQUARTERS ENTERPRISE NAME (DAB-HQ-ENP-NA). SEE ENTERPRISE NUMBER (ENP-NR) FOR PARENT ELEMENT DEFINITION.
10DnB Headquarters Name
THE FULL NAME OF THE ENTERPRISE THAT IS A HEADQUARTERS LOCATION AS ASSIGNED BY DUN AND BRADSTREET. SEE ALSO DUN AND BRADSTREET HEADQUARTERS ENTERPRISE NUMBER (DAB-HQ-ENP-NR). SEE ENTERPRISE NAME (ENP-NA) FOR PARENT ELEMENT DEFINITION.
Col No Column Name Description
1DnB Decision Maker Rec Seq Num
THE IDENTIFYING SEQUENCE NUMBER ASSIGNED TO EACH DECISION-MAKER OF AN ENTERPRISE AS PROVIDED BY DUN AND BRADSTREET.
2DnB Decision Maker Function Cd
CODE REPRESENTING THE DECISION-MAKING ROLE OF A PERSON WITHIN AN ENTERPRISE AS PROVIDED BY DUN AND BRADSTREET. DUN AND BRADSTREET REFERS TO THIS AS "MAC" (MANAGEMENT RESPOSIBILITY CODE). EXAMPLES OF VALUES: TO BE SUPPLIED
3 DnB Decision Maker Function
FREE FORM TEXT DESCRIBING THE VALUES IN DUN AND BRADSTREET DECISION MAKER FUNCTION CODE (DAB-DMK-FCT-CD).
Descr
4DnB Decision Maker Name
THE FULL NAME OF THE DECISION-MAKER WITHIN THE ENTERPRISE AS PROVIDED BY DUN AND BRADSTREET.
5DnB Decision Maker Title
THE CORPORATE TITLE OF THE DECISION-MAKER WITHIN THE ENTERPRISE AS PROVIDED BY DUN AND BRADSTREET.
Col No Column Name Description
1DnB Accounting Firm Name
THE FULL NAME OF THE ACCOUNTING COMPANY WHICH AN ENTERPRISE USES TO VALIDATE ITS FINANCIAL DATA.
2DnB Bus Emp Count Class Cd
CODE REPRESENTING THE CLASSIFICATION OF THE COUNT OF EMPLOYEES FOR AN ENTERPRISE. EXAMPLE OF VALUES: 00 = DATA NOT AVAILABLE 01 = FULL DMI RECORD, WITH INFORMATION FROM AN UPDATE 02 = DUNS SUPPORT RECORD WITH A VALID EMPLOYEE COUNT 03 = DUNS SUPPORT RECORD WITH NO EMPLOYEE COUNT
3DnB Bus Emp Count Class Descr
FREE FORM TEXT DESCRIBING THE VALUES IN ENTERPRISE EMPLOYEE COUNT CLASSIFICATION CODE (ENP-EMP-CNT-CSF-CD).
4DnB Bus Emp Here Quality Cd
CODE REPRESENTING THE QUALITY OF THE COLLECTED "LOCAL EMPLOYEES QUANTITY" AS DETERMINED BY DUN & BRADSTREET.
5DnB Bus Emp Here Quality Descr
FREE FORM TEXT DESCRIBING THE VALUES IN DUN AND BRADSTREET ENTERPRISE LOCAL EMPLOYEES QUALITY CODE (DAB-ENP-LOE-QLY-CD).
6DnB Bus Emp Total Quality Cd
CODE REPRESENTING THE QUALITY OF THE COLLECTED "TOTAL EMPLOYEES QUANTITY" AS DETERMINED BY DUN & BRADSTREET.
7DnB Bus Emp Total Quality Descr
FREE FORM TEXT DESCRIBING THE VALUES IN DUN AND BRADSTREET ENTERPRISE TOTAL EMPLOYEE QUALITY CODE (DAB-ENP-TOE-QLY-CD).
8DnB Bus Employees Here
THE QUANTITY OF EMPLOYEES ASSIGNED TO A SPECIFIC LOCATION OF AN ENTERPRISE.
9DnB Bus Employees Total
THE QUANTITY EMPLOYEES THAT REPRESENT THE TOTAL FOR AN ENTERPRISE.
10DnB Bus Num Of Clients
TOTAL NUMBER OF ACCOUNTS SERVICED BY THE ENTERPRISE, AS PROVIDED BY DUN & BRADSTREET.
11DnB Bus Property Size
THE TOTAL QUANTITY OF FLOOR SPACE OCCUPIED BY AN ENTERPRISE AT A PARTICULAR LOCATION STATED IN AN APPROPRIATE UNIT OF MEASURE, E.G., IN THE UNITED STATUES THE UNIT OF MEASURE IS A SQUARE FOOT.
12DnB County Population Range Cd
CODE REPRESENTING THE RESIDENTIAL POPULATION OF THE COUNTY IN WHICH AN ESTABLISHMENT IS LOCATED. EXAMPLES OF VALUES: 0 = UNDER 1000 1 = 1,000 TO 2,499, ETC. THIS DATA IS PURCHASED AND AVAILABLE IN THE D&B FILE
13DnB County Population Range Desc
FREE FORM TEXT DESCRIBING THE VALUES IN COUNTY POPULATION RANGE CODE (COY-PPN-RNG-CD).
14DnB Employee Growth Pct
THE PERCENT OF A CALCULATED GROWTH OR DECLINE IN EMPLOYEE TOTAL OVER A 3 OR 5 YEAR PERIOD.
15 DnB Own Lease CdCODE REPRESENTING THE TYPE OF OCCUPANCY HOLDING OF THE SPECIFIC LOCATION (PREMISES) OF THE ENTERPRISE.
16DnB Own Lease Descr
FREE FORM TEXT DESCRIBING THE VALUES IN ENTERPRISE LOCATION HOLDING CODE (ENP-LOC-HLG-CD).
17DnB Principal Employee Ind
INDICATES WHETHER OR NOT ALL (PRINCIPAL) OWNERS OF AN ENTERPRISE ARE INCLUDED (THAT IS, COUNTED) IN THE ASSOCIATED ENTERPRISE TOTAL EMPLOYEE QUANTITY. VALID VALUES: 0 = ALL (PRINCIPAL) OWNERS OF AN ENTERPRISE ARE NOT INCLUDED 1 = ALL (PRINCIPAL) OWNERS OF AN ENTERPRISE ARE INCLUDED
18DnB Sales Growth Pct
THE PERCENT OF A CALCULATED GROWTH OR DECLINE IN SALES OVER A 3 OR 5 YEAR PERIOD FOR AN ENTERPRISE.
19DnB Sales Vol Class Cd
CODE REPRESENTING THE CLASSIFICATION OF SALES VOLUME FOR THE ENTERPRISE AS PROVIDED BY DUN AND BRADSTREET. EXAMPLE OF VALUES: 00 = DATA NOT AVAILABLE 01 = ACTUAL SALES VOLUME 02 = LOW END OF RANGE 03 = ESTIMATED OR NOT AVAILABLE IF SALES VOLUME EQUALS ZERO
20DnB Sales Vol Class Descr
FREE FORM TEXT DESCRIBING THE VALUES IN ENTERPRISE SALES VOLUME CLASSIFICATION CODE (ENP-SLS-VOL-CSF-CD).
21DnB Base Year Employee Qty
THE QUANTITY OF THE FIRST YEAR EMPLOYEE TOTAL FOR THE TREND PERIOD.
22DnB Trend Year Employee Qty
THE QUANTITY OF TOTAL EMPLOYEES FOR THE CURRENT YEAR TREND PERIOD.
23DnB Trend Year Sales Qty
THE QUANTITY OF THE CURRENT YEAR SALES VOLUME FOR THE TREND PERIOD.
24DnB Base Year Sales Qty
THE QUANTITY OF FIRST YEAR SALES VOLUME FOR THE TREND PERIOD AS REPORTED BY DUN AND BRADSTREET FOR AN ENTERPRISE.
25DnB Bus Total Gross Revenue USD
THE MONETARY AMOUNT OF TOTAL GROSS REVENUE FOR AN ENTERPRISE ASSOCIATED WITH A SPECIFIED FISCAL YEAR AND EXPRESSED IN STANDARDIZED CURRENCY (U.S. DOLLARS).
26DnB Reporting Currency Cd
CODE REPRESENTING THE REPORTING CURRENCY OF AN ENTERPRISE AS REPORTED BY DUN AND BRADSTREET. SEE CURRENCY CODE (CCY-CD) FOR PARENT ELEMENT DEFINITION. REFER TO THEWORLD WIDE CODES REPOSITORY FOR A LISTING OF STANDARD CURRENCY CODES.
27DnB Reporting Currency Name
THE FULL NAME DESCRIBING THE CURRENCY IN DUN AND BRADSTREET ENTERPRISE REPORTING CURRENCY CODE (DAB-ENP-RCY-CCY-CD). SEE CURRENCY NAME (CCY-NA) FOR PARENT ELEMENT DEFINITION.
28DnB Bus Total Gross Revenue
THE MONETARY AMOUNT OF TOTAL GROSS REVENUE FOR AN ENTERPRISE ASSOCIATED WITH A SPECIFIED FISCAL YEAR AND STATED IN THE REPORTING CURRENCY.
29DnB Alternate Currency Cd
CODE REPRESENTING THE ALTERNATE CURRENCY OF AN ENTERPRISE AS REPORTED BY DUN AND BRADSTREET. SEE CURRENCY CODE (CCY-CD) FOR PARENT ELEMENT DEFINITION. REFER TO THE WORLD WIDE CODES REPOSITORY FOR A LISTING OF STANDARD CURRENCY CODES.
30DnB Alternate Currency Name
THE FULL NAME OF THE ALTERNATE CURRENCY OF AN ENTERPRISE AS REPORTED BY DUN AND BRADSTREET. SEE CURRENCY NAME (CCY-NA) FOR PARENT ELEMENT DEFINITION.
31DnB Bus Total Gross Revenue ALT
THE MONETARY AMOUNT OF TOTAL GROSS REVENUE FOR AN ENTERPRISE ASSOCIATED WITH A SPECIFIED FISCAL YEAR AND STATED IN THE ALTERNATE CURRENCY.
Col No Column Name Description
1DnB Primary Activity Class Cd
CODE REPRESENTING A CLASSIFICATION OF PRIMARY ACTIVITY OF AN ENTERPRISE. THIS IS USED IN CONJUNCTION WITH THE PRIMARY ACTIVITY INDUSTRY CODE IENP-PRI-ACY-NDR-CD) FOR AN ENTERPRISE. EXAMPLES OF VALUES: TO BE SUPPLIED EXAMPLES INCLUDE CANADIAN GOVERNMENT SIC, U.S. GOVERNMENT TWO DIGIT 1977 SIC CODE, U.S. 1972 FORMAT, ETC.
2DnB Primary Activity Class Descr
FREE FROM TEXT DESCRIBING THE VALUES IN ENTERPRISE PRIMARY ACTIVITY CLASSIFICATION CODE (ENP-PIR-ACY-CSF-CD).
3DnB Primary Activity Cd
CODE REPRESENTING THE TYPE OF INDUSTRY ACTIVITY USED LOCALLY AS THE PRIMARY ACTIVITY WITHIN AN INDUSTRY. EXAMPLES OF VALUES: TO BE SUPPLIED
4DnB Primary SIC Industry 2 Cd
CODE REPRESENTING THE THIRD SUMMARIZATION LEVEL OF THE INDUSTRY REPORTING STRUCTURE (HIERARCHY) THAT DENOTES THE PRIMARY INDUSTRY OF AN ENTERPRISE. IN THE U.S., THIS IS THE FIRST TWO DIGITS OF THE STANDARD INDUSTRIAL CLASSIFICATION CODE (SIC-CD); SIC-CD DENOTES THE WAY IN WHICH U.S. INDUSTRIES IDENTIFY MANUFACTURED COMMODITIES. SEE INDUSTRY SUMMARY 3 CODE (NDR-SMY-3-CD) FOR PARENT ELEMENT DEFINITION. REFER TO THE FOLLOWING ELEMENTS FOR RELATED INFORMATION: ENTERPRISE PRIMARY INDUSTRY CODE (ENP-PRI-NDR-CD) ENTERPRISE PRIMARY INDUSTRY SUMMARY 1 CODE (ENP-PRI-NDR-1-CD) ENTERPRISE PRIMARY INDUSTRY SUMMARY 2 CODE (ENP-PRI-NDR-2-CD)
5DnB Primary SIC Industry 2 Descr
FREE FORM TEXT DESCRIBING THE VALUES IN ENTERPRISE PRIMARY INDUSTRY SUMMARY 3 CODE (ENP-PRI-NDR-3-CD)
6DnB Primary SIC Industry 4 Cd
CODE REPRESENTING THE FIRST SUMMARIZATION LEVEL OF THE INDUSTRY REPORTING STRUCTURE (HIERARCHY) THAT DENOTES THE PRIMARY INDUSTRY OF AN ENTERPRISE. IN THE U.S., THIS IS THE FIRST FOUR DIGITS OF THE STANDARD INDUSTRIAL CLASSIFICATION CODE (SIC-CD); SIC-CD DENOTING THE WAY IN WHICH U.S. INDUSTRIES IDENTIFY MANUFACTURED COMMODITIES. SEE INDUSTRY SUMMARY 1 CODE (NDR-SMY-1-CD) FOR PARENT ELEMENT DEFINITION. REFER TO THE FOLLOWING ELEMENTS FOR RELATED INFORMATION: ENTERPRISE PRIMARY INDUSTRY CODE (ENP-PRI-NDR-CD) ENTERPRISE PRIMARY INDUSTRY SUMMARY 2 CODE (ENP-PRI-NDR-2-CD) ENTERPRISE PRIMARY INDUSTRY SUMMARY 3 CODE (ENP-PRI-NDR-3-CD)
7 DnB Primary SIC FREE FORM TEXT DESCRIBING THE VALUES IN ENTERPRISE PRIMARY INDUSTRY
Industry 4 Descr SUMMARY 1 CODE (ENP-PRI-NDR-1-CD).
8DnB Primary SIC Industry 8 Cd
CODE REPRESENTING THE PRIMARY INDUSTRY TO WHICH AN ENTERPRISE IS CLASSIFIED. THIS IS THE FUNDAMENTAL INDUSTRY (E.G. TRANSPORTATION INDUSTRY) IN WHICH AN ENTERPRISE TRANSACTS BUSINESS. SEE INDUSTRY CODE (NDR-CD) FOR PARENT ELEMENT DEFINITION. REFER TO THE FOLLOWING ELEMENTS FOR RELATED INFORMATION: - ENTERPRISE PRIMARY INDUSTRY SUMMARY 1 CODE (ENP-PRI-NDR-1-CD) FOR INFORMATION REGARDING USE OF THE FIRST FOUR DIGITS OF THE PRIMARY INDUSTRY CODE. - ENTERPRISE PRIMARY INDUSTRY SUMMARY 2 CODE (ENP-PRI-NDR-2-CD) FOR INFORMATION REGARDING USE OF THE FIRST THREE DIGITS OF THE PRIMARY INDUSTRY CODE. - ENTERPRISE PRIMARY INDUSTRY SUMMARY 3 CODE (ENP-PRI-NDR-3-CD) FOR INFORMATION REGARDING USE OF THE FIRST TWO DIGITS OF THE PRIMARY INDUSTRY CODE.
9DnB Primary SIC Industry 8 Descr
FREE FORM TEXT DESCRIBING THE VALUES IN ENTERPRISE PRIMARY INDUSTRY CODE (ENP-PRI-NDR-CD).
10DnB Primary NAICS Industry 3 Cd
CODE REPRESENTING THE KIND/TYPE OF INDUSTRY (AT THE HIGHEST LEVEL) WHICH IS THE NORTH AMERICAN INDUSTRY CLASSIFICATION 3 CHARACTER IDENTIFIER ASSOCIATED WITH AN ENTERPRISE. NOTE: THIS CODE IS DEFINED FOR NORTH AMERICA. EXAMPLES OF VALUES: 111191 = OILSEED AND GRAIN COMBINATION SEE NORTH AMERICAN INDUSTRY CLASSIFICATION SYSTEM 6 CHARACTER CODE (NAI-3-CHA-CD) FOR PARENT ELEMENT DEFINITION. SEE WORLD WIDE CODES REPOSITORY FOR A LISTING OF CODES.
11DnB Primary NAICS Industry 3 Descr
FREE FORM LONG TEXT DESCRIBING THE VALUES IN ENTERPRISE NORTH AMERICAN INDUSTRY CLASSIFICATION SYSTEM 3 CHARACTER CODE (ENP-NAI-3-CHA-CD).
12DnB Primary NAICS Industry 6 Cd
CODE REPRESENTING THE KIND/TYPE OF INDUSTRY (AT THE LOWEST LEVEL) WHICH IS THE NORTH AMERICAN INDUSTRY CLASSIFICATION 6 CHARACTER IDENTIFIER ASSOCIATED WITH AN ENTERPRISE. NOTE: THIS CODE IS DEFINED FOR NORTH AMERICA. EXAMPLES OF VALUES: 111191 = OILSEED AND GRAIN COMBINATION SEE NORTH AMERICAN INDUSTRY CLASSIFICATION SYSTEM 6 CHARACTER CODE (NAI-6-CHA-CD) FOR PARENT ELEMENT DEFINITION. SEE WORLD WIDE CODES REPOSITORY FOR A LISTING OF CODES.
13DnB Primary NAICS Industry 6 Descr
FREE FORM LONG TEXT DESCRIPTION OF THE VALUES IN ENTERPRISE NORTH AMERICAN INDUSTRY CLASSIFICATION SYSTEM 6 CHARACTER CODE (ENP-NAI-6-CHA-CD).
14DnB Secondary SIC Industry Rank Num
THE DUN AND BRADSTREET NUMBER IDENTIFYING THE POSITION OF A SECONDARY INDUSTRY ASSOCIATED WITH AN ACCOUNT DUN AND BRADSTREET NUMBER IN ORDER OF REVENUE OR IMPORTANCE. AN ACCOUNT DUN AND BRADSTREET NUMBER IS THE IDENTIFYING NUMBER OF AN ACCOUNT AS IDENTIFIED BY DUN AND BRADSTREET.
15DnB Secondary SIC Industry 4 Cd
CODE REPRESENTING THE FIRST SUMMARIZATION LEVEL OF THE INDUSTRY REPORTING STRUCTURE (HIERARCHY) THAT DENOTES THE SECONDARY INDUSTRY OF AN ENTERPRISE. THIS IS NECESSARY BECAUSE CORPORATIONS MAY DO BUSINESS IN MORE THAN ONE INDUSTRY CLASSIFICATION; FOR EXAMPLE, TRANSPORTATION AND FINANCIAL SERVICES. IN THE U.S., THIS IS THE FIRST FOUR DIGITS OF THE STANDARD INDUSTRIAL CLASSIFICATION CODE (SIC-CD); SIC-CD DENOTING THE WAY IN WHICH U.S. INDUSTRIES IDENTIFY MANUFACTURED COMMODITIES. SEE ENTERPRISE PRIMARY INDUSTRY SUMMARY 1 CODE (ENP-PRI-NDR-1-CD) FOR RELATED INFORMATION.
16DnB Secondary SIC Industry 4 Descr
FREE FORM TEXT DESCRIBING THE VALUES IN ENTERPRISE SECONDARY INDUSTRY SUMMARY 1 CODE (ENP-SEC-NDR-1-CD).
Col No Column Name Description
1DUNS Upload Group Num
DWH DESCRIPTION: UNIQUE IDENTIFIER OF A GROUP OF DUN & BRADSTREET ENTITIES (DUNS NUMBERS) THAT WERE UPLOADED BY A USER.
2DUNS Upload Group Name
DWH DESCRIPTION: THE NAME OF A DUN & BRADSTREET UPLOAD GROUP. A DUN & BRADSTREET UPLOAD GROUP REPRESENTS A COLLECTION OF DUN & BRADSTREET ENTITIES (RECORDS A/K/A DUNS NUMBERS) THAT WERE ASSOCIATED TOGETHER BY A USER TO SATISFY
3DUNS Upload Group Type Cd
DWH DESCRIPTION: CODE REPRESENTING A TYPE OF A DUN & BRADSTREET UPLOAD GROUP. THIS CODE IS USED TO ALLOW USERS TO CREATE AND UPLOAD THEIR OWN GROUPINGS OF DUN & BRADSTREET RECORDS.
4DUNS Upload Group Type Desc
DWH DESCRIPTION: FREE FORM TEXT DESCRIBING THE VALUES IN DUNS_UPLOAD_GROUP_TYPE_CD.
5DUNS Upload Group Country Cd
DWH DESCRIPTION: CODE REPRESENTING A NATION-STATE DEFINED BY TOPOGRAPHY, CULTURE AND DESIGNATED BOUNDARIES RESPONSIBLE FOR THE ASSOCIATED DUN & BRADSTREET UPLOAD GROUP.
6DUNS Upload Group Expiration Date
THE EXPIRATION DATE OF AN UPLOAD GROUP. AN UPLOAD GROUP IS A SET OF ITEMS GROUPED TOGETHER TO SATISFY A COMMON PURPOSE (SUCH AS FOR PURPOSES OF REPORTING, BILLING, ETC.). IN THE CORPORATE DATA WAREHOUSE, UPLOAD GROUPS ARE SIMILAR TO QUERY "IN LISTS", WHERE GROUPS OF LIKE ITEMS CAN BE REFERENCED BY A SINGLE GROUP IDENTIFIER TO FACILITATE REPETITIVE REPORTING. AN UPLOAD LIST MAY CONSIST OF DATA USED TO SPECIFY FILTERING CRITERIA (I.E. 'WHERE' CLAUSE) IN A DATABASE QUERY.