Understand Attributes

DaaS, through its partnership with Dun & Bradstreet (D&B), provides company and contact attributes to search and enrich data.

Oracle also provides additional attributes not from D&B (and not listed here), free of charge, such as MatchScore and ContactCount.

Topics:

• Account Enrichment Attributes

• Contact Enrichment Attributes

Note: Attribute names may look slightly different in different mappings. Also, some D&B attributes have an alphanumeric code value. DaaS renders the corresponding descriptions of these codes in our interface. For example, Location Type may appear in DaaS with a value of Single Location, Headquarters, or Branch. However, these descriptions aren't included in the generated output files. In the export files, these Location Type values appear as 0, 1, or 2. See D&B Reference Tables.

Account Enrichment Attributes

The following company attributes are provided with Oracle Account Enrichment subscriptions. The Geographic Availability column lists whether the attribute applies to all (global) companies or only U.S companies.

To learn more about how these attributes map to other applications, see About Mappings and Edit Existing Mappings.

Company Attribute	Geographic Availability	Description
2 Byte ISO Country Code	Global	The two byte alpha character ISO code for the country where the business is located.
3 Year Growth Percentage on Employees	US only	The percentage increase or decrease in the number of employees over a 3-year period. Includes a + or - sign denoting positive or negative growth in sales.
3 Year Growth Percentage on Sales Volume	US only	The percentage increase or decrease in the sales volume over a 3-year period. Includes a + or - sign denoting positive or negative growth in sales.
ASE Ticker	US only	The symbol used to trade the company's stock on the American Stock Exchange.
Business Name	Global	The primary or registered name of the business.
Census FIPS Country Code	US only	The Federal Information Processing Standards county code identifying the county where the subject is located.
Census FIPS Territory Code	US only	The Federal Information Processing Standards territory code for where this subject is located. These territory codes are defined and developed by the National Institute of Standards and Technology (NIST) organization within the US federal Department of Commerce.
City	Global	The name of the city where the business is physically located. Generally in local language.
Company Description	Global	Narrative company description.
Country	Global	The 2-byte alpha character ISO code for the country where the business is located.
Country Access Code	Global	The international dialing code required to connect to the phone or fax number when dialing internationally.
County	Global	The full name of the county where the business is located.
Currency Code	Global	A code value that describes the type of currency in which the sales volume (local currency) is expressed.
Delinquency Risk	US only	Based on the standard Commercial Credit Score, which predicts the likelihood of a company becoming severely delinquent over the next 12 months. Grouped into risk ranges.
Domestic Ultimate Business Name	Global	The primary name of the domestic ultimate business.
Domestic Ultimate D&B Country Code	Global	D&B geographical code identifying the country where the domestic ultimate is located.
Domestic Ultimate DUNS Number	Global	A subsidiary within the global family tree that is the highest-ranking member within a specific country. May contain leading zeros, which are lost if the field is treated as numeric.
Domestic Ultimate FIPS Country Code	Global	The Federal Information Processing Standards code value that identifies the country where the domestic ultimate company is located.
Domestic Ultimate State Province Abbreviation	Global	The abbreviated name of the state or province in which the domestic ultimate is located.
DUNS Number	Global	A randomly generated 9-digit number assigned by D&B to identify unique business establishments. May contain leading zeros, which are lost if the field is treated as numeric.
Employees Here	Global	The number of employees at this location.
Employees Here Reliability Code	Global	A code value that describes the reliability of the Employees Total value.
Employees Total	Global	The total number of employees in the business organization; it should include subsidiary and branch locations.
Employees Total Reliability Code	Global	A code value that describes the reliability of the Employees Total value.
Facsimile Number	Global	The primary fax number for the business with no formatting or punctuation. This string contains all telecommunication number components (area code, exchange, number).
Federal Tax ID Number	US only	A number assigned by the Internal Revenue Services (IRS) that either uniquely identifies or helps to identify a subject, also referred to as Federal Taxpayer Identification Number.
FIPS MSA Code	US only	The Federal Information Processing Standards code value that identifies the Metropolitan Statistical Area (known as the MSA) where this subject is located. These MSA codes were defined and developed by the National Institute of Standards and Technology (NIST) organization within the US Federal Department of Commerce.
Full Postal Code	Global	Full postal code as received by D&B.
GEO Code Accuracy	Global	A code value that describes how close the coordinates for a location are to “rooftop” level.
Global Exchange Name	Global	The exchange where the stock symbol is listed.
Global Ultimate Business Name	Global	The name of the ultimate company.
Global Ultimate D&B Country Code	Global	D&B geographical code identifying the country where the ultimate company is located.
Global Ultimate DUNS Number	Global	The top-most responsible entity within the corporate family tree. May contain leading zeros, which are lost if the field is treated as numeric.
Global Ultimate FIPS Country Code	Global	The Federal Information Processing Standards code value that identifies the country where the ultimate company is located.
Global Ultimate Indicator	Global	Indicates whether the site record is the Global Ultimate D-U-N-S within the corporate family tree.
Global Ultimate State Province Abbreviation	Global	The abbreviated name of the state or province in which the domestic ultimate is located.
Headquarter DUNS Number	Global	The D-U-N-S number of the headquarter organization. May contain lead zeros, which are lost if field is treated as numeric.
Hierarchy Code	Global	A number used with the status and subsidiary indicators to pinpoint the location of an establishment within a corporate hierarchy. The hierarchy on the global ultimate is ‘01’. A branch hierarchy is the same as its headquarters. A subsidiary’s hierarchy is one more than its parent’s.
Import Indicator	Global	A code value that identifies whether the business imports goods or services for remanufacture or sale, exports products or services to a foreign country, or is an agent for goods. This appears as Foreign Trade on a company profile.
Labor Surplus Indicator	US only	Indicator of labor surplus area as defined by the United States Department of Labor and available only from the US.
Latitude	Canada, Germany, UK, US	The angular distance north or south from the earth's equator measured through 90 degrees.
Latitude Short	Canada, Germany, UK, US, Mexico, Vietnam, Belgium, Australia, Netherlands, Republic of Korea	The angular distance north or south from the earth's equator measured through 90 degrees. Note: This is a less granular view of the Latitude field.
Legal Status Code	Global	A code value that describes the legal structure of the business.
line-of-business	Global	A description of the operations or activities of the business. Relates to the primary four-digit 1987 US SIC.
Location Type	Global	A code value that describes the organizational status of the business; for example, Single Location, Headquarters, Branch.
Longitude	Canada, Germany, UK, US	The angular distance east or west from the prime meridian measured through 180 degrees.
Longitude Short	Canada, Germany, UK, US, Mexico, Vietnam, Belgium, Australia, Netherlands, Republic of Korea	The angular distance east or west from the prime meridian measured through 180 degrees. Note: This is a less granular view of the Longitude field.
Mailing Address 1	Global	The address line where a business has its mail delivered. Generally in local language.
Mailing Address 2	Global (not used in US)	The second street address line where a business has its mail delivered. Generally in local language.
Mailing City	Global	The city name where the business has its mail delivered. Generally in local language.
Mailing Full Postal Code	Global	The postal code where the business has its mail delivered.
Mailing State	Global	The abbreviation for the state or province where the business has its mail delivered.
Major Industry Category Code	Global	A code value that denotes under which major industry category an establishment falls.
Marketability Indicator	Global	Indicates that the record satisfies D&B global marketability rules.
Merge Date	Global	Date New DUNS Number was applied.
Merge Reason	Global	A code that provides the reason for the new DUNS number located in the New DUNS field.
Minority Owned Indicator	US only	Whether or not the business is owned by a member of a minority group.
Minority Owned Type	US only	Indicates the ethnicity of the minority holding an ownership interest.
NAICS Code1_1	Global	The North American Industry Classification System equivalent for the combination of the first 4 bytes and the first 4 byte node of the primary SIC code.
NAICS Code1_2	Global	The NAICS equivalent for the combination of the first 4 bytes and the second 4 byte node of the primary SIC code.
NAICS Code1_3	Global	The NAICS equivalent for the combination of the first 4 bytes and the third 4 byte node of the primary SIC code.
NAICS Code1_4	Global	The NAICS equivalent for the combination of the first 4 bytes and the fourth 4 byte node of the primary SIC code.
NAICS Code2_1	Global	The NAICS equivalent for the combination of the first 4 bytes and the first 4 byte node of the secondary SIC code.
NAICS Code2_2	Global	The North American Industry Classification System equivalent for the combination of the first 4 bytes and the second 4 byte node of the secondary SIC code.
NAICS Code2_3	Global	The NAICS equivalent for the combination of the first 4 bytes and the third 4 byte node of the secondary SIC code.
NAICS Code2_4	Global	The NAICS equivalent for the combination of the first 4 bytes and the fourth 4 byte node of the secondary SIC code.
NAICS Code3_1	Global	The North American Industry Classification System equivalent for the combination of the first 4 bytes and the first 4 byte node of the third SIC code.
NAICS Code3_2	Global	The NAICS equivalent for the combination of the first 4 bytes and the second 4 byte node of the third SIC code.
NAICS Code3_3	Global	The NAICS equivalent for the combination of the first 4 bytes and the third 4 byte node of the third SIC code.
NAICS Code3_4	Global	The NAICS equivalent for the combination of the first 4 bytes and the fourth 4 byte node of the third SIC code.
NAICS Code4_1	Global	The North American Industry Classification System equivalent for the combination of the first 4 bytes and the first 4 byte node of the fourth SIC code.
NAICS Code4_2	Global	The NAICS equivalent for the combination of the first 4 bytes and the second 4 byte node of the fourth SIC code.
NAICS Code4_3	Global	The NAICS equivalent for the combination of the first 4 bytes and the third 4 byte node of the fourth SIC code.
NAICS Code4_4	Global	The NAICS equivalent for the combination of the first 4 bytes and the fourth 4 byte node of the fourth SIC code.
NAICS Code5_1	Global	The North American Industry Classification System equivalent for the combination of the first 4 bytes and the first 4 byte node of the fifth SIC code.
NAICS Code5_2	Global	The NAICS equivalent for the combination of the first 4 bytes and the second 4 byte node of the fifth SIC code.
NAICS Code5_3	Global	The NAICS equivalent for the combination of the first 4 bytes and the third 4 byte node of the fifth SIC code.
NAICS Code5_4	Global	The NAICS equivalent for the combination of the first 4 bytes and the fourth 4 byte node of the fifth SIC code.
NAICS Code6_1	Global	The North American Industry Classification System equivalent for the combination of the first 4 bytes and the first 4 byte node of the sixth SIC code.
NAICS Code6_2	Global	The NAICS equivalent for the combination of the first 4 bytes and the second 4 byte node of the sixth SIC code.
NAICS Code6_3	Global	The NAICS equivalent for the combination of the first 4 bytes and the third 4 byte node of the sixth SIC code.
NAICS Code6_4	Global	The NAICS equivalent for the combination of the first 4 bytes and the fourth 4 byte node of the sixth SIC code.
NAS Ticker	US only	The symbol used to trade the company's stock on the NASDAQ Small Cap Exchange.
National Identification Code	Global	A code value that describes the type of national ID number provided; for example, ‘12’ = CRO, ‘14’ = Siren.
National Identification Number	Global	The business identification number used in some countries for business registration and tax collection. Examples include CRO numbers in the UK and the French Siren numbers.
New DUNS Number	Global	New DUNS Number for the business that should be used to replace the existing DUNS Number on the record.
NMS Ticker	US only	The symbol used to trade the company's stock on the NASDAQ National Market.
Number of Business Family Members	Global	The number of family members including the global ultimate and all subsidiaries and branches of the entire family tree worldwide. All family members within a particular tree carry the same count.
NYSE Stock Exchange	US only	The symbol used to trade the company's stock on the New York Stock Exchange.
Operates From Residence Indicator	US only	A flag stating whether or not the business is run from a residential address.
Out of Business Indicator	US only	Indicates that the business is out of business or inactive based upon D&B policies and procedures.
Over the Counter Stock Exchange	US only	The symbol used to trade the company's stock on the Over the Counter Stock Exchange.
Owns Rents Code	Global	A code value that indicates if the business owns or rents the building it occupies.
Parent DUNS Number	Global	The D-U-N-S number of the parent organization. May contain leading zeros, which are lost if the field is treated as numeric.
Parent Headquarter Business Name	Global	The primary name of the parent/headquarter company.
Parent Headquarter D&B Country Code	Global	D&B geographical code identifying the country where the parent/headquarter is located.
Phone Number	Global	The primary phone number for the business with no formatting or punctuation. This string contains all telecommunication number components (area code, exchange, number).
Primary Competitor 1	Global	DUNS number of the company deemed to be competitor for the business.
Primary Competitor 2	Global	DUNS number of a company deemed to be competitor for the business.
Primary Competitor 3	Global	DUNS number of a company deemed to be competitor for the business.
Primary Indicator	Global	Indicates whether or not the ticker is the primary one for the business.
Public Private Indicator	Global	Indicates whether ownership of the business is public or private.
Sales Volume Local Currency Reliability Code	Global	A code value that describes the reliability of the annual sales/revenue figure that is expressed in local currency.
Sales Volume (Local Currency)	Global	The total annual sales/revenue for this business, expressed in US dollars as a signed, decimal field. If the sales/revenue is collected in local currency, then the local value is converted to US dollars.
Sales Volume US Dollars	Global	The total annual sales/revenue for this business in local currency. Not available on branch locations.
Sales Volume (US Dollars) Reliability Code	Global	A code value that describes the reliability of the annual sales/revenue figure that is expressed in US dollars.
Secondary Competitor 1	Global	DUNS number of a company deemed to be competitor for the business.
Secondary Competitor 2	Global	DUNS number of a company deemed to be competitor for the business.
Small Business Indicator	US only	Whether or not a business meets certification eligibility criteria established by the SBA effective July 1, 1999. All firms must be certified by one of the Small Disadvantaged Business Certification Agencies.
State	Global	The abbreviation for the physical state or province name where the business is located.
State Name	Global	The full name of the physical state or province name where the business is located.
Stock Symbol	US only	The most commonly known symbol used to trade the company's stock.
Street Address 1	Global	The first street address line where a business is physically located. Generally in local language.
Street Address 2	Global (not used in US)	The second street address line where a business is physically located. Generally in local language.
Subsidiary Status	Global	Whether or not the subject business is more than 50% owned by another organization.
Trade Style Name	Global	A trading style name used by a business. It is an additional name used by a company. Also referred to as "Doing Business As" (DBA) and "Also Known As" (AKA).
Trade Style Name 2	Global	A second trading style name used by the business.
Trade Style Name 3	Global	An additional name used by a business for advertising and/or buying purposes - a "doing business as" name.
Trade Style Name 4	Global	An additional name used by a business for advertising and/or buying purposes - a "doing business as" name.
Trade Style Name 5	Global	An additional name used by a business for advertising and/or buying purposes - a "doing business as" name.
URL	Global	The primary URL for the company.
US 1987 SIC 1	Global	The US 1987 Standard Industrial Classification (SIC) code system categorizes business establishments based upon the type of activity done by that business at that location.  A business can have up to six SIC codes and each SIC can have four extensions. The first-listed SIC code represents the primary operations of the business.  Then, SIC codes are assigned in descending order according to the percentage of the revenue contributed by each function of the business. The SIC code of a parent/ultimate may include the activities of its subsidiaries. SIC Code 2 Category = The name of the Standard Industrial Classification code for the second line-of-business operations as ranked by percent of sales/revenue.
US 1987 SIC 2	Global	The Standard Industrial Classification code for the second line-of-business operations as ranked by percent of sales/revenue.
US 1987 SIC 3	Global	The Standard Industrial Classification code for the third line-of-business operations as ranked by percent of sales/revenue.
US 1987 SIC 4	Global	The Standard Industrial Classification code for the fourth line-of-business operations as ranked by percent of sales/revenue.
US 1987 SIC 5	Global	The Standard Industrial Classification code for the fifth line-of-business operations as ranked by percent of sales/revenue.
US 1987 SIC 6	Global	The Standard Industrial Classification code for the sixth line-of-business operations as ranked by percent of sales/revenue.
Woman Owned	US only	A business that is at least 51% owned by, and whose management and daily business operations are controlled by, a woman.
Year Started	Global	The year when the current ownership or management assumed control of the business or the year established if no control change has taken place. This is not provided for branch records.

Contact Enrichment Attributes

For non-US contacts, DaaS only provides the following personally identifiable information (PII) for business contacts: the contact's First Name, Last Name, Job Title, Gender, and Company Address associated with the company's DUNS#.

The following contact attributes are provided with Oracle Contact Enrichment subscriptions. The Geographic Availability column lists whether the attribute applies to all (global) companies or only U.S companies. Many countries in the European Union do not expose certain information due to GDPR (General Data Protection Regulation). For example, the Direct Dial Phone attribute is only available for contacts from companies in the US.

To learn more about how these attributes are mapped to other applications, see About Mappings and Edit Existing Mappings.

Contact Attribute	Geographic Availability	Description
Company Phone	US only	The company phone number at which the professional can be reached (for current role assignments).
Company Phone Extension	US only	The phone extension associated with the company phone number indicated on this record.
Direct Dial Phone	US only	The direct-dial phone number associated with this person in this role. It includes country code, area code and phone number.
DUNS Number	Global	DUNS number of the business location.
Email Address	US only	The main email address associated with this person's role or contact record.
First Name	Global	The first name of the person.
Gender	US only	The gender of the person.
Individual ID	US only	The unique identifier of the professional.
Last Name	Global	The last name of the person.
Last Update Date Role	US only	The date ANY of the role data was last updated. This date is assigned by Professional Contacts database.
Middle Name	US only	The middle name of the person.
MRC Code	Global	The management responsibility code, which is a code that has been derived from the vanity title or standardized title. This consists of 4 characters. The first position of the MRC Code indicates the general function of the individual, such as executive or finance. The second position indicates the general title of the individual, such as owner or director. The last two digits indicate a role under the general function and general title. For example, the role code CW = founder.
Prefix	Global	The prefix (Mr., Ms., Dr.) associated with the person's name.
Role ID	US only	Unique identifier of the professional’s job at a particular DUNS location.
Suffix	Global	The last name suffix of the person.
Title	Global	The title associated with the person's role. This is the title as it would read on a person's business card.