Review the List of Additional Account and Contact Attributes
Review the list of mapped and unmapped account and contact information you can expose in the UI. You can expose the mapped fields in the UI using Application Composer. For the unmapped fields, you must first create a custom field for it in the sales application and add the field to the mapping.
Mapped Account Fields
You can expose any of the fields listed in the table in the account pages using the display name. Long field names aren't always completely visible in Application Composer, but you can hover over a display name to see the underlying technical name.
The table lists the name of the Oracle Account Enrichment attribute in the first column, and provides a brief definition and description. The Account Field Display Name field lists the display name in the UI and in Application Composer. The Account Field Name lists the technical name. The names don't always match.
|
Oracle Account Enrichment Attribute |
Definition |
Description |
Account Field Display Name |
Account Field Name |
|---|---|---|---|---|
|
Data/DataCloudStatus |
Data Cloud Status |
Indicates if the record has been matched. |
Enrichment Status |
DataCloudStatus |
|
Data/PrefFunctionalCurrency |
Currency |
A code value that describes the type of currency in which the sales volume (local currency) is expressed. |
Preferred Functional Currency |
PrefFunctionalCurrency |
|
Data/CurrFyPotentialRevenue |
Sales Volume (Local currency) |
The total annual sales revenue in US dollars as a signed, decimal field. If the revenue is collected in local currency, then the local value is converted to US dollars. |
Current Fiscal Year's Potential Revenue |
CurrFyPotentialRevenue |
|
Data/DomesticUltimateDunsNumC |
Domestic Ultimate DUNS Number |
A subsidiary within the global family tree that is the highest-ranking member within a specific country. May contain leading zeros, which will be lost if the field is treated as numeric. |
Domestic Ultimate D-U-N-S Number |
DomesticUltimateDunsNumC |
|
Data/DunsNumberC |
DUNS Number |
A randomly generated 9-digit number assigned by Dun & Bradstreet Corporation to identify unique business establishments. May contain leading zeros, which will be lost if the field is treated as numeric. |
D-U-N-S Number |
DunsNumberC |
|
Data/GlobalUltimateDunsNumC |
Global Ultimate DUNS Number |
The top-most responsible entity within the corporate family tree. May contain leading zeros, which will be lost if the field is treated as numeric. |
Global Ultimate D-U-N-S Number |
GlobalUltimateDunsNumC |
|
Data/ParentDunsNumC |
Parent DUNS Number |
The D-U-N-S number of the parent organization. May contain leading zeros, which will be lost if the field is treated as numeric. |
Parent D-U-N-S Number |
ParentDunsNumC |
|
Data/EmpAtPrimaryAdrEstInd |
Number of Employees (This Site) |
The number of employees at this location. |
Employees at Identifying Address |
EmployeesAtPrimaryAddressText |
|
Data/EmpAtPrimaryAdrEstInd |
Employees Here Reliability Code |
Describes the reliability of the Employees Total value. |
Number of Employees at Identifying Address |
EmployeesAtPrimaryAddress |
|
Data/EmpAtPrimaryAdrMinInd |
Employees Primary Minimum Indicator |
A code value that describes the reliability of the Employees Total value. |
Number of Employees at Identifying Primary Address Minimum |
EmployeesAtPrimaryAddressMinimum |
|
Data/EmployeesTotal |
Employees Total |
The total number of employees in the business organization; it should include subsidiary and branch locations. |
Number of Employees |
EmployeesTotal |
|
Data/TotalEmpEstInd |
Employees Total Reliability Code |
Describes the reliability of the Employees Total value. The possible values are: Actual, Estimated, and blank. |
Number of Employees Estimated Qualifier |
TotalEmployeesEstimatedIndicator |
|
Data/TotalEmpMinInd |
Employees Total Minimum Indicator |
Displays the reliability of the Employees Total value. The possible values are: Includes Subsidiaries, Subsidiaries not included, and blank. |
Number of Employees at Identifying Address Minimum Qualifier |
TotalEmployeesMinimumIndicator |
|
Data/ImportInd |
Import Indicator |
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. |
Importer Indicator |
ImportInd |
|
Data/ExportInd |
Export Indicator |
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. |
Exporter Indicator |
ExportInd |
|
Data/LegalStatusCode |
Legal Status Code |
A code value that describes the legal structure of the business. |
Legal Status |
LegalStatusCode |
|
Data/LineOfBusiness |
Line of Business |
A description of the operations or activities of the business. Relates to the primary four-digit 1987 US SIC. |
Line of Business |
LineOfBusiness |
|
Data/MinorityOwnedInd |
Minority Owned Indicator |
Whether or not the business is owned by a member of a minority group. |
Minority-Owned Indicator |
MinorityOwnedInd |
|
Data/MinorityOwnedType |
Minority Owned Type |
Indicates the ethnicity of the minority holding an ownership interest. |
Type of Minority-Owned Organization |
MinorityOwnedType |
|
Data/RentOwnInd |
Owns Rents Code |
A code value that indicates if the business owns or rents the building it occupies. |
Rent or Own Indicator |
RentOwnInd |
|
Data/PublicPrivateOwnershipFlag |
Public Private Indicator |
Whether or not ownership of the business is public or private. |
Private Ownership |
PublicPrivateOwnershipFlag |
|
Data/SmallBusInd |
Small Business Indicator |
Indicates if the business meets SBA certification eligibility criteria effective July 1, 1999. All firms must be certified by one of the Small Disadvantaged Business Certification Agencies. |
Small Business Indicator |
SmallBusInd |
|
Data/ParentSubInd |
Subsidiary Status |
Whether or not the subject business is more than 50-percent owned by another organization. |
Subsidiary Indicator |
ParentSubInd |
|
Data/YearStarted |
Year Started |
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. |
Year Established |
YearEstablished |
|
Data/LocationType |
Location Type |
A code value that describes the organizational status of the business; for example, Single Location, Headquarters, Branch. |
HQ Branch Indicator |
HQBranchIndicator |
|
Data/FederalTaxIDNumber |
Federal Tax ID Number |
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. |
Taxpayer Identification Number |
JgzzFiscalCode |
|
Data/PrimaryAddressLine1 |
Street Address 1 |
The first street address line where a business is physically located. Generally in local language. |
Address Line 1 |
PrimaryAddressLine1 |
|
Data/PrimaryAddressLine2 |
Street Address 2 |
The second street address line where a business is physically located. Generally in local language. |
Address Line 2 |
PrimaryAddressLine2 |
|
Data/PrimaryCity |
City |
City where the business is located. Generally in local language. |
City |
PrimaryAddressCity |
|
Data/PrimaryCounty |
County |
The full name of the county where the business is located. |
County |
PrimaryAddressCounty |
|
Data/PrimaryState |
State |
The full name of the state where the business is located. |
State |
PrimaryAddressState |
|
Data/PrimaryPostalCode |
OSC Postal Code |
The 5-digit postal code where the business is physically located. |
Postal Code |
PrimaryAddressPostalCode |
|
Data/PrimaryCountry |
Country |
The 2-byte alpha character ISO code for the country where the business is located. |
Country |
PrimaryAddressCountry |
|
Data/RawPhoneNumber |
Phone Number |
The primary phone number for the business with no formatting or punctuation. This string contains all telecommunication number components (area code, exchange, number). |
Primary Phone Number |
PrimaryPhoneNumber |
|
Data/FaxRawPhoneNumber |
Facsimile Number |
The primary facsimile number for the business with no formatting or punctuation. This string contains all telecommunication number components (area code, exchange, number). |
Fax |
Fax |
|
Data/Url |
Url |
The primary URL for the company. |
URL |
PrimaryURL |
|
Data/WomanOwned |
Woman Owned |
A business that is at least 51-percent owned by, and whose management and daily business operations are controlled by, a woman. |
Woman-Owned Indicator |
WomanOwnedInd |
Unmapped Account Fields
You must create a text or a number field for these attributes and add them to the mapping before you can expose the field in the account pages.
The table lists the name of the attribute on the mapping page in the first column, and provides a brief definition and description. The Geographical Availability column indicates if the attribute is available for all countries or just a subset.
|
Oracle Account Enrichment Attribute |
Definition |
Description |
Geographical Availability |
|---|---|---|---|
|
Data/State Name |
State Name |
The full name of the physical state or province name where the business is located. |
Global |
|
Data/PrimaryFullPostalCode |
Full Postal Code |
Full postal code as received by Dun & Bradstreet Corporation. |
Global |
|
Data/LatitudeShort |
Latitude Short |
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. |
Canada, Germany, UK, US, Mexico, Vietnam, Belgium, Australia, Netherlands, Republic of Korea |
|
Data/LongitudeShort |
Longitude Short |
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. |
Canada, Germany, UK, US, Mexico, Vietnam, Belgium, Australia, Netherlands, Republic of Korea |
|
Data/MailingFullPostalCode |
Mailing Full Postal Code |
Full postal code as received by Dun & Bradstreet Corporation. |
Global |
|
MetaData/MatchScore |
Match Score |
A score representing the likelihood of a match between records. |
Global |
|
Data/CompanyDescription |
Company Description |
Narrative company description. |
Global |
|
Data/MarketableIndicator |
Marketability Indicator |
Indicates that the record satisfies Dun & Bradstreet Corporation global marketability rules. |
Global |
|
Data/GEOCodeAccuracy |
GEO Code Accuracy |
A code value that describes how close the coordinates for a location are to a rooftop level. |
Global |
|
Data/SalesVolume(USDollars)Reliability Code |
Sales Volume (US Dollars) Reliability Code |
A code value that describes the reliability of the annual sales/revenue figure that is expressed in US dollars. |
Global |
|
Data/SalesVolume(LocalCurrency) |
Sales Volume US Dollars |
The total annual sales revenue for this business in local currency. Not available on branch locations. |
Global |
|
Data/SalesVolumeLocalCurrencyReliabilityCode |
Sales Volume Local Currency Reliability Code |
A code value that describes the reliability of the annual sales/revenue figure that is expressed in local currency. |
Global |
|
Data/DomesticUltimateBusinessName |
Domestic Ultimate Business Name |
The primary name of the domestic ultimate business. |
Global |
|
Data/DomesticUltimateFIPSCountryCode |
Domestic Ultimate FIPS Country Code |
The Federal Information Processing Standards code value that identifies the country where the domestic ultimate company is located. |
Global |
|
Data/DomesticUltimateD&BCountryCode |
Domestic Ultimate D&B Code |
Dun & Bradstreet Corporation geographical code identifying the country where the domestic ultimate is located. |
Global |
|
Data/DomesticUltimateState/ProvinceAbbreviation |
Domestic Ultimate State Province Abbreviation |
The abbreviated name of the state or province in which the domestic ultimate is located. |
Global |
|
Data/GlobalUltimateBusinessName |
Global Ultimate Business Name |
The name of the ultimate company. |
Global |
|
Data/GlobalUltimateIndicator |
Global Ultimate Indicator |
Indicates whether the site record is the Global Ultimate D-U-N-S within the corporate family tree. |
Global |
|
Data/GlobalUltimateFIPSCountryCode |
Domestic Ultimate FIPS Country Code |
The Federal Information Processing Standards code value that identifies the country where the domestic ultimate company is located. |
Global |
|
Data/GlobalUltimateD&BCountryCode |
Domestic Ultimate D&B Country Code |
Dun & Bradstreet Corporation geographical code identifying the country where the domestic ultimate is located. |
Global |
|
Data/GlobalUltimateState/ProvinceAbbreviation |
Global Ultimate State Province Abbreviation |
The abbreviated name of the state or province in which the global ultimate is located. |
Global |
|
Data/HeadquarterDUNSNumber |
Headquarter DUNS Number |
The D-U-N-S number of the headquarter organization. May contain lead zeros, which will be lost if field is treated as numeric. |
Global |
|
Data/Parent/HeadquarterBusinessName |
Parent Headquarters Business Name |
The primary name of the parent headquarters company. |
Global |
|
Data/HierarchyCode |
Hierarchy Code |
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. |
Global |
|
Data/NumberofFamilyMembers |
Number of Family Members |
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. |
Global |
|
Data/OutofBusinessIndicator |
Out of Business Indicator |
Indicates that the business is out of business or inactive based upon D&B policies and procedures. |
US only |
|
Data/OvertheCounterStockExchange |
Over the Counter Stock Exchange |
The symbol used to trade the company's stock on the Over the Counter Stock Exchange. |
US only |
|
Data/NYSEStockExchange |
NYSE Stock Exchange |
The symbol used to trade the company's stock on the New York Stock Exchange. |
US only |
|
Data/ASETicker |
ASE Ticker |
The symbol used to trade the company's stock on the American Stock Exchange. |
US only |
|
Data/NMSTicker |
NMS Ticker |
The symbol used to trade the company's stock on the NASDAQ National Market. |
US only |
|
Data/NASTicker |
NAS Ticker |
The symbol used to trade the company's stock on the NASDAQ Small Cap Exchange. |
US only |
|
Data/OperatesFromResidenceIndicator |
Operates From Residence Indicator |
Operates From Residence Indicator |
US only |
|
Data/PrimaryCompetitor1 |
Primary Competitor 1 |
DUNS number of the company deemed to be the primary competitor for the business. |
Global |
|
Data/3YearGrowthPercentageonSalesVolume |
3 Year Growth Percentage on Sales Volume |
The percentage increase or decrease in the sales volume over a three-year period. Includes a plus (+) or minus (-) sign denoting positive or negative growth in sales. |
US only |
|
Data/3YearGrowthPercentageonEmployees |
3 Year Growth Percentage on Employees |
The percentage increase or decrease in the number of employees over a three-year period. Includes a plus (+) or minus (-) sign denoting positive or negative growth in sales. |
US only |
|
Data/DeliquencyRisk |
Delinquency Risk |
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. |
US only |
|
Data/CensusFIPSTerritoryCode |
Census FIPS Territory Code |
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. |
US only |
|
Data/CensusFIPSCountyCode |
Census FIPS Country Code |
The Federal Information Processing Standards county code identifying the county where the subject is located. |
US only |
|
Data/PrimaryCompetitor2 |
Primary Competitor 2 |
DUNS number of the company deemed to be the second primary competitor for the business. |
Global |
|
Data/PrimaryCompetitor3 |
Primary Competitor 3 |
DUNS number of the company deemed to be the third primary competitor for the business. |
Global |
|
Data/SecondaryCompetitor1 |
Secondary Competitor 1 |
DUNS number of the company deemed to be the secondary competitor for the business. |
Global |
|
Data/SecondaryCompetitor2 |
Secondary Competitor 2 |
DUNS number of the company deemed to be the secondary competitor for the business. |
Global |
|
Data/GlobalExchangeName |
Global Exchange Name |
The exchange where the stock symbol is listed. |
Global |
|
Data/PrimaryIndicator |
Primary Indicator |
Indicates whether or not the ticker is the primary one for the business. |
Global |
|
Data/NationalIdentificationCode |
National Identification Code |
A code value that describes the type of national ID number provided; for example, '12' = CRO, '14' = Siren. |
Global |
|
Data/FIPSMSACode |
FIPS MSA Code |
The Federal Information Processing Standards code value, which 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. |
US only |
|
Data/ParentHeadquarterD&BCountryCode |
Parent Headquarters D&B Country Code |
Dun & Bradstreet Corporation geographical code identifying the country where the parent headquarters are located. |
Global |
Mapped Contact Fields
You can expose any of the fields listed in the table in the contact pages using the display name. Long field names aren't always completely visible in Application Composer, but you can hover over a display name to see the underlying technical name.
The table lists the name of the attribute on the mapping page in the first column, and provides a brief definition and description. The Contact Field Display Name field lists the display name in the UI and in Application Composer. The Contact Field Name lists the technical name. The names don't always match.
|
Oracle Contact Enrichment Attribute |
Definition |
Description |
Contact Field Display Name |
Contact Field Name |
|---|---|---|---|---|
|
Data/DataCloudStatus |
Data Cloud Status |
The status of the record. Example: Matched. |
Enrichment Status |
DataCloudStatus |
|
Data/PersonPreNameAdjunct |
Prefix |
The prefix (Mr., Ms., Dr.) associated with the person's name. |
Prefix |
PersonPreNameAdjunct |
|
Data/PersonFirstName |
First Name |
The first name of the person. |
First Name |
PersonFirstName |
|
Data/PersonMiddleName |
Middle Name |
The middle name of the person. |
Middle Name |
PersonMiddleName |
|
Data/PersonLastName |
Last Name |
The last name of the person. |
Last Name |
PersonLastName |
|
Data/JobTitle |
Title |
The title associated with the person's role. This is the title as it would read on a person's business card. |
Job Title |
JobTitle |
|
Data/PersonNameSuffix |
Suffix |
The last name suffix of the person. |
Suffix |
PersonNameSuffix |
|
Data/Address1 |
Street Address 1 |
The first street address line where a business is physically located. Generally in local language. |
Address Line 1 |
PrimaryAddressLine1 |
|
Data/City |
City |
City where the business is located. Generally in local language. |
City |
PrimaryAddressCity |
|
Data/State |
State |
The abbreviation for the physical state or province name where the business is located. |
State |
PrimaryAddressState |
|
Data/PostalCode |
OSC Postal Code |
The 5-digit postal code where the business is physically located. |
Postal Code |
PrimaryAddressPostalCode |
|
Data/Country |
Country |
The 2-byte alpha character ISO code for the country where the business is located. |
Country |
PrimaryAddressCountry |
|
Data/PhoneRawPhoneNumber |
Direct Dial Phone |
The direct-dial phone number associated with this person in this role. It includes country code, area code and phone number. |
Phone Number |
PrimaryFormattedPhoneNumber |
|
Data/CompanyPhone |
Company Phone |
The company phone number at which the professional can be reached (for current role assignments). |
Phone Number |
PrimaryPhoneNumber |
|
Data/PhoneExtension |
Company Phone Extension |
This is the phone extension associated with the company phone number indicated on this record. |
Phone Extension |
PrimaryPhoneExtension |
|
Data/EmailAddress |
Email Address |
The main email address associated with this person's role or contact record. |
|
|
|
Data/Department Department |
Department |
A division of a large organization such as Executive, Administration, and so on. |
Department |
Department |
Unmapped Contact Fields
You must create a text or a number field for these attributes and add them to the mapping before you can expose the field in the contact pages.
The table lists the name of the attribute on the mapping page in the first column, and provides a brief definition and description. The Geographical Availability column indicates if the attribute is available for all countries or just a subset.
|
Oracle Contact Enrichment Cloud Service Attribute |
Definition |
Description |
Geographical Availability |
|---|---|---|---|
|
Data/FullPostalCode |
Full Postal Code |
Full postal code as received by Dun & Bradstreet Corporation. |
Global |
|
DataDUNSNumber |
DUNS Number |
The D-U-N-S number of the business location. |
Global |
|
Data/IndividualID |
Individual ID |
The unique identifier of the professional. |
US only |
|
Data/RoleID |
Role ID |
Unique identifier of the professional's job at a particular DUNS location. |
US only |
|
Data/LastUpdateDateRole |
Last Update Date Role |
The date any of the role data was last updated. |
Global |
|
Data/ManagementLevel |
Management Level |
Level of management; for example, C-Level, VP-Level, and so on. |
Global |
|
Data/StandardizedTitle |
Standardized Title |
A business title derived from the Management Responsibility Code, which identifies a title or area of responsibility of an executive. |
Global |
|
MetaData/MatchScore |
Match Score |
A score representing the likelihood of a match between records. |
Global |
|
Data/Location |
Location |
Address information for individual. |
US only |