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
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. |