4 Manage Mappings

This section describes how to manage attribute mappings for use with the procedures Add New Companies and Contacts and Match Data.

Topics:

About Mappings

When you match or export data from DaaS, you select a mapping between the attributes in the export file that you create and those in the application. The mappings define which attributes will be present in the export file.

Note:

Mappings that contain contact attributes require a DaaS subscription for contact records. For example, the MarketingCloudContact&CompanyMatch mapping requires a DaaS subscription for D&B Company Enterprise Contact Records (for contact attributes) and D&B Company Enterprise Records (for company attributes).

DaaS provides the following search export mappings:

  • EngagementCloudCompanyExport (for Engagement Cloud)

  • EngagementCloudContactExport (for Engagement Cloud)

  • MarketingCloudCompanyExport (for Oracle Eloqua)

  • MarketingCoudContactExport (for Oracle Eloqua)

  • MarketingCloudContact&CompanyExport (for Oracle Eloqua)

  • CompanyExport (for other applications)

  • ContactExport (for other applications)

DaaS provides the following match export mappings:

  • EngagementCloudCompanyMatch (for Engagement Cloud)

  • EngagementCloudContactMatch (for Engagement Cloud)

  • MarketingCloudCompanyMatch (for Oracle Eloqua)

  • MarketingCloudContactMatch (for Oracle Eloqua)

  • MarketingCloudContact&CompanyMatch (for Oracle Eloqua)

The EngagementCloud and MarketingCloud mappings include default mappings to Engagement Cloud or Eloqua independent of the input file. The other provided mappings (for other applications) have no default mappings, but the input file includes mandatory attributes. In many cases, these provided mappings are sufficient. However, you may want to create a new mapping if you only need a subset of the provided attributes, or if you created a custom attribute in Engagement Cloud or Eloqua that you need to map to a DaaS attribute. New mappings are created using the existing map definition templates.

Note:

There are different default maps for Engagement Cloud depending on the version you have running (for example, Release 9 or Release 8 Bundle 8).

Typical Workflow for Using Mappings

To start using mappings, refer to the typical workflow described in the following table:

Task Description

Exploring the Mappings Page

Learn how to use the Mappings page to manage search export and match export mappings.

Creating Mappings for Engagement Cloud

Create a new mapping for use with Engagement Cloud.

Create Mappings for Eloqua Marketing Cloud Create a new mapping for use with Eloqua.

Creating Mappings for Other Oracle Cloud Applications

Create a new mapping for use with other Oracle Cloud applications.

Editing an Existing Mapping

Modify an existing mapping.

Explore the Mappings Page

Click Mapping icon in the Navigator at any time to display the Mappings page. From the Mappings page you can select, delete, or create a mapping of the attributes in DaaS to the attributes in your application.

Topics:

What You Can Do from the Mappings Page

On the Mappings page, you see a list of all mappings in your system. The following mappings are provided. They should be sufficient for most search export and match export jobs:

  • EngagementCloudCompanyExport and EngagementCloudContactExport for search export mappings to Engagement Cloud

  • MarketingCloudCompanyExport, MarketingCoudContactExport, and MarketingCloudContact&CompanyExport for search export mappings to Oracle Eloqua

  • EngagementCloudCompanyMatch and EngagementCloudContactMatch for match export mappings to Engagement Cloud

  • MarketingCloudCompanyMatch, MarketingCloudContactMatch, and MarketingCloudContact&CompanyMatch for match export mappings to Oracle Eloqua

  • CompanyExport and ContactExport for export mappings to other Oracle Cloud applications

You cannot delete these provided mappings. However, you can create a new map based on a default map and edit the attributes that way.

The following table highlights what you can do from the Mappings page:

Element Description
Create Mapping dropdown

From the Template Type list, select the kind of mapping template that you require:

  • Engagement Cloud: Use to create a mapping template to use with Engagement Cloud.

  • Marketing Cloud: Use to create a mapping template to use with Eloqua.

  • Generic: Use to create a mapping template to use with other Oracle Cloud applications.

Delete icon

Click the X icon to remove a custom mapping.

Row for a mapping

Click the mapping name to edit the mapping. See Edit an Existing Mapping.

To edit a mapping, click the mapping name, and click Create Mapping to create a new mapping by editing the existing mapping.

What You See on the Mappings Page

The following table describes the details shown on the Mappings page:

Column Description

Mapping Name

Unique name for the search export or match export mapping.

Data Type

Whether the mapping is for companies or contacts.

Mapping Type

Whether or not the job was a search export or a match export mapping.

Template Type

Identification that the mapping is for Engagement Cloud, Oracle Eloqua Marketing Cloud, or for another application (no value).

Date Date the mapping was created.

Create New Mappings

Topics:

Create Mappings for Engagement Cloud

To create a new mapping for use with Engagement Cloud:

  1. Click Mapping icon in the banner to display the Mappings page.
  2. Click Create Mapping.
  3. Use the following elements to complete the mapping:
    Element Description

    Name

    Enter a unique name for your export mapping.

    Data Type

    Select Company or Contact to obtain the correct list of mappings.

    Mapping Type

    Specify whether the mapping is for a Search Export or a Match Export job to Engagement Cloud.

    Template Type Select Engagement Cloud to create a mapping for use with Engagement Cloud. DaaS automatically maps the discovered attributes to those in Engagement Cloud.

    Add Attribute

    Add an attribute mapping that you accidently removed but you still want added. If you extended the attributes in Engagement Cloud, use Add Attribute for any attributes that you extended in Engagement Cloud.

    For each dropdown list that is displayed, select the attribute or object.

    See Edit Engagement Cloud Mappings for more information about the Engagement Cloud attributes.

    Note:

    Match Export mappings require that certain attributes exist. If you delete mandatory attributes, then your import job will fail. See About Matching Records and Analyze Rejected Match Export Jobs.

    If you get error message DCS-1059, make sure your mapping file has Column Data Attribute = External ID mapped to Column Target Attribute = Party ID, or, make sure that your input file contains a column header called External ID (or any name) with values that uniquely identifies the account record in Engagement Cloud.

  4. Click Save & Select.
  5. Apply the mapping to a search export or match export job by following these procedures:

    When prompted for the mapping, select the one that you created.

Create Mappings for Eloqua Marketing Cloud

Mappings define how DaaS attributes map to Eloqua attributes. Default mappings can't be edited or deleted, but you can create a new mapping based on a default mapping to add (and enrich) more of your attributes. To create a new mapping for use with Eloqua Marketing Cloud:

  1. Click Mapping icon in the banner to display the Mappings page.
  2. Click Create Mapping.
  3. Use the following elements to complete the mapping:
    Element Description

    Name

    Enter a unique name for your export mapping.

    Data Type

    Select Company or Contact to obtain the correct list of mappings.

    To create a mapping for both companies and contacts, select Contact for the Data Type, and then add both contact and company fields to it.

    Mapping Type

    Specify whether the mapping is for a Search Export or a Match Export job to Eloqua.

    Template Type Select Marketing Cloud to create a mapping for use with Eloqua Marketing Cloud. When you select the Marketing Cloud template, DaaS automatically maps the discovered attributes to those in Eloqua.

    Add Attribute

    For each dropdown list that is displayed, select the attribute.

    Mappings for lead (contact) enrichment must have one of the following options of required attributes:
    • External ID, Email Address

    • External ID, First Name, Last Name, Direct Dial Phone

    • External ID, First Name, Last Name, Business Name

    • External ID, First Name, Last Name, DUNS Number

    • External ID, First Name, Last Name, Parent DaaS ID

    Mappings for account (company) enrichment require the External ID, Business Name and City attributes.

    If you delete mandatory attributes, then import jobs will fail. See Rejected Matches with Oracle Eloqua Marketing Cloud.

    The number of attributes available for the mappings depends on which subscription you've purchased. See Understand Attributes for information about attributes in each subscription. See Edit Marketing Cloud Mappings for information about Marketing Cloud attributes.

    Note:

    Match Export mappings require that certain attributes exist. If you delete mandatory attributes, then your import job will fail. See About Matching Records and Rejected Matches with Oracle Eloqua Marketing Cloud.
  4. Click Save & Select.
  5. Apply the mapping to a search export or match export job by following the procedures in Add New Companies and Contacts to Eloqua Marketing Cloud.

    When prompted for the mapping, select the one that you created.

Create Mappings for Other Oracle Cloud Applications

To create a new mapping for use with other Oracle Cloud applications (such as Business Intelligence Cloud Service):

  1. Click Mapping icon in the banner to display the Mappings page.
  2. Click Create Mapping.
  3. From the Template Type list, select Generic to create a new mapping for use with your Oracle Cloud application.

    If you are creating a Search Export mapping, the page lists the discovered attributes in DaaS.

    If you are creating a Match Export mapping, you must first click Import to select the file from your application that contains the data for mapping. You then need to manually map the source attributes from your application to the DaaS attributes.

    Note:

    When matching companies from other Oracle Cloud applications, each record in the input file should have a unique identifier value, such as Company ID. When creating a Generic Match Export mapping, this Company ID should be mapped to the DaaS attribute External ID.
  4. Use the following elements to complete the mapping:
    Element Description

    Name

    Enter a unique name for your export mapping.

    Data Type

    Select Company or Contact to obtain the correct list of mappings.

    Mapping Type

    Specify whether the mapping is for a search export or match export job.

    Template Type Select Generic.

    Delete icon

    Click this icon to remove any attributes whose values you don't want.

    Add Attribute

    Add an attribute mapping that you accidently removed but you still want added. If you extended the attributes in your application, use Add Attribute to add it in.

    Note:

    Match Export mappings require that certain attributes exist. If you delete mandatory attributes, then your import job will fail. See About Matching Records.

  5. Click Save.
  6. Apply the mapping to a search export or match export by following these procedures:

Edit Existing Mappings

Note:

Mappings included with DaaS cannot be deleted.

To modify an existing mapping:

  1. Click Mappings icon in the banner to display the Mappings page.
  2. From the Mapping Name column, click the name of a mapping that you want to edit.

    The Edit Mapping page is displayed. Here, you can add and remove attributes from the mapping. You can also modify the mappings of attributes to the equivalent attributes in Engagement Cloud or Eloqua Marketing Cloud. When you select to modify a template for other Oracle Cloud applications, the Edit Mapping page lists only the discovered attributes in DaaS. Later, you must map the attributes.

    Use the following elements to modify the mapping:

    Element Description

    Delete icon

    Click this icon to remove any attributes whose values you don't want.

    Add Attribute

    Add an attribute mapping that you accidentally removed but you still want added. Use Add Attribute for any attributes you extended in Engagement Cloud, Eloqua, or another Oracle Cloud application.

    For each dropdown list that is displayed, select the attribute or object.

    See Understand Attributes.

  3. Click Save.

    The Mappings page is displayed.

  4. Apply the modified mapping to a search export or match export job. When prompted for the mapping, select the one you just modified. See:

    Note:

    Some Dun and Bradstreet 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 are not included in the output files. In search export or match export files, these Location Type values appear as 0, 1, or 2.

See Edit Engagement Cloud Mappings and Edit Marketing Cloud Mappings.

Edit Engagement Cloud Mappings

Topics:

Understand Engagement Cloud Mappings

The Engagement Cloud mappings contain the full list of company and contact attributes we export. However, DaaS provides some attributes that don't have a corresponding map to an attribute in Engagement Cloud. Your administrator can decide if they want to leverage these attributes in your implementation. For a complete list of DaaS attributes not included in the provided mappings, see Engagement Cloud Attribute Mappings.

Follow these steps to edit your mapping (that is, to map these “not mapped” attributes to their corresponding Engagement Cloud attribute and object name:
  1. Either identify the Engagement Cloud attribute and object that should be mapped to the DaaS attribute and object, or create a custom attribute in Application Composer and add the custom attribute to the Company or Contacts profile page. See Engagement Cloud documentation for information on creating custom attributes.
  2. Map the DaaS attribute (shown as "not mapped" in the following table) to the attribute identified or created in step 1 in DaaS.
  3. Map that DaaS attribute to the attribute identified or created in step 1 in Engagement Cloud Setup Manager.

Note:

Mappings included with DaaS cannot be deleted.

Understand the EngagementCloudCompanyExport Mapping

Use this table to understand how EngagementCloudCompanyExport attributes map to Engagement Cloud attributes.

To see the geographic availability of each attribute, see Understand Attributes.

Data Attribute Subscription Level Sequence Engagement Cloud Object Engagement Cloud Attribute Description Column in TXT/CSV File

External ID

internal attribute 1

OrganizationProfile

PartyId

The Engagement Cloud party ID.

Data/PartyId

Orig System

internal attribute 2

OrganizationProfile

PartyOrigSystem

The service name that originated the company ID.

Data/PartyOrigSystem

Company ID

internal attribute 3

OrganizationProfile

PartyOrigSystemReference

The ID of a company and sent by DaaS to Engagement Cloud.

Data/PartyOrigSystemReference

Data Cloud Status

internal attribute 4

OrganizationProfile

DataCloudStatus

Whether or not the record has been matched.

Data/DataCloudStatus

Business Name

Oracle Account Enrichment 5

OrganizationProfile

OrganizationName

The primary or registered name of the business.

Data/OrganizationName

Currency

Oracle Account Enrichment 6

OrganizationProfile

PrefFunctionalCurrency

A code value that describes the type of currency in which the sales volume (local currency) is expressed.

Data/PrefFunctionalCurrency

Sales Volume (Local currency)

Oracle Account Enrichment 7

OrganizationProfile

CurrFyPotentialRevenue

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.

Data/CurrFyPotentialRevenue

Domestic Ultimate DUNS Number

Oracle Account Enrichment 8

OrganizationProfile

DomesticUltimateDunsNumC

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.

Data/DomesticUltimateDunsNumC

DUNS Number

Oracle Account Enrichment 9

OrganizationProfile

DunsNumberC

A randomly generated 9-digit number assigned by D&B to identify unique business establishments. May contain leading zeros, which will be lost if the field is treated as numeric.

Data/DunsNumberC

Global Ultimate DUNS Number

Oracle Account Enrichment 10

OrganizationProfile

GlobalUltimateDunsNumC

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.

Data/GlobalUltimateDunsNumC

Parent DUNS Number

Oracle Account Enrichment 11

OrganizationProfile

ParentDunsNumC

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.

Data/ParentDunsNumC

Number of Employees (This Site)

Oracle Account Enrichment 12

OrganizationProfile

EmpAtPrimaryAdr

The number of employees at this location.

Data/EmpAtPrimaryAdr

Employees Here Reliability Code

Oracle Account Enrichment 13

OrganizationProfile

EmpAtPrimaryAdrEstInd

A code value that describes the reliability of the Employees Total value.

Data/EmpAtPrimaryAdrEstInd

Employees Primary Minimum Indicator

internal attribute 14

OrganizationProfile

EmpAtPrimaryAdrMinInd

A code value that describes the reliability of the Employees Total value.

Data/EmpAtPrimaryAdrMinInd

Employees Total

Oracle Account Enrichment 15

OrganizationProfile

EmployeesTotal

The total number of employees in the business organization; it should include subsidiary and branch locations.

Data/EmployeesTotal

Employees Total Reliability Code

Oracle Account Enrichment 16

OrganizationProfile

TotalEmpEstInd

A code value that describes the reliability of the Employees Total value.

Data/TotalEmpEstInd

Employees Total Minimum Indicator

internal attribute 17

OrganizationProfile

TotalEmpMinInd

A code value that describes the reliability of the Employees Total value.

Data/TotalEmpMinInd

Import Indicator

Oracle Account Enrichment 18

OrganizationProfile

ImportInd

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.

Data/ImportInd

Export Indicator

internal attribute 19

OrganizationProfile

ExportInd

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.

Data/ExportInd ExportInd

Legal Status Code

Oracle Account Enrichment 20

OrganizationProfile

LegalStatus

A code value that describes the legal structure of the business.

Data/LegalStatusCode

Line of Business Oracle Account Enrichment 21 OrganizationProfile LineOfBusiness A description of the operations or activities of the business. Relates to the primary four-digit 1987 US SIC. Data/LineOfBusiness

Minority Owned Indicator

Oracle Account Enrichment 22

OrganizationProfile

MinorityOwnedInd

Whether or not the business is owned by a member of a minority group.

Data/MinorityOwnedInd

Minority Owned Type

Oracle Account Enrichment 23

OrganizationProfile

MinorityOwnedType

Indicates the ethnicity of the minority holding an ownership interest.

Data/MinorityOwnedType

OwnsRents Code

Oracle Account Enrichment 24

OrganizationProfile

RentOwnInd

A code value that indicates if the business owns or rents the building it occupies.

Data/RentOwnInd

PublicPrivate Indicator

Oracle Account Enrichment 25

OrganizationProfile

PublicPrivateOwnershipFlag

Whether or not ownership of the business is public or private.

Data/PublicPrivateOwnershipFlag

Small Business Indicator

Oracle Account Enrichment 26

OrganizationProfile

SmallBusInd

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.

Data/SmallBusInd

Stock Symbol

Oracle Account Enrichment 27

OrganizationProfile

StockSymbol

The most commonly known symbol used to trade the company's stock.

Data/StockSymbol

Subsidiary Status

Oracle Account Enrichment 28

OrganizationProfile

ParentSubInd

Whether or not the subject business is more than 50% owned by another organization.

Data/ParentSubInd

Year Started Oracle Account Enrichment 29 OrganizationProfile YearEstablished 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. Data/YearStarted
Location Type Oracle Account Enrichment 30 OrganizationProfile HqBranchInd A code value that describes the organizational status of the business; for example, Single Location, Headquarters, Branch. Data/LocationType
National Identification Number Oracle Account Enrichment 31 AdditionalIdentifier AdditionalPartyIdentifierValue The business identification number used in some countries for business registration and tax collection. Examples include CRO numbers in the U.K. and the French Siren numbers. Data/NationalIdentificationNumber

National Identification Type

internal attribute 32

AdditionalIdentifier

AdditionalPartyIdentifierType

An internal value to represent the type of business identification used in business registration and tax collection.

Data/NationalIdentificationType

Issuing Authority

internal attribute 33

AdditionalIdentifier

IssuingAuthorityName

The authority that provides the National Identification Number. For example, in the US, the Social Security Office is the issuing authority.

Data/IssuingAuthority
Federal Tax ID Number Oracle Account Enrichment 34 OrganizationProfile JgzzFiscalCode 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. Data/FederalTaxIDNumber
Labor Surplus Indicator Oracle Account Enrichment 35 OrganizationProfile LABOR_SURPLUS_IND Indicator of labor surplus area as defined by the United States Department of Labor and available only from the US. Data/LaborSurplusIndicator

Street Address 1

Oracle Account Enrichment 36

Address

Address1

The first street address line where a business is physically located. Generally in local language.

Data/PrimaryAddressLine1

Street Address 2

Oracle Account Enrichment 37

Address

Address2

The second street address line where a business is physically located. Generally in local language.

Data/PrimaryAddressLine2

City

Oracle Account Enrichment 38

Address

City

The name of the city where the business is physically located. Generally in local language.

Data/PrimaryCity

County

Oracle Account Enrichment 39

Address

County

The full name of the county where the business is located.

Data/PrimaryCounty

State

Oracle Account Enrichment 40

Address

State

The abbreviation for the physical state or province name where the business is located.

Data/PrimaryState

State Name Oracle Account Enrichment 41 not mapped not mapped The full name of the physical state or province name where the business is located. Data/State Name

OSC Postal Code

internal attribute 42

Address

PostalCode

The 5-digit postal code where the business is physically located.

Data/PrimaryPostalCode

OS Postal Plus 4 Code internal attribute 43 Address PostalPlus4Code The 4 digits that determine a more specific location within a given ZIP code. Data/PrimaryPostalPlus4Code
Full Postal Code Oracle Account Enrichment 44 not mapped not mapped

Full postal code as received by D&B.

Data/PrimaryFullPostalCode

Country

Oracle Account Enrichment 45

Address

Country

The 2-byte alpha character ISO code for the country where the business is located.

Data/PrimaryCountry

Latitude

Oracle Account Enrichment 46

Address

Latitude

The angular distance north or south from the earth's equator measured through 90 degrees.

Data/PrimaryLatitude

Latitude Short Oracle Account Enrichment 47 not mapped not mapped 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. Data/LatitudeShort

Longitude

Oracle Account Enrichment 48

Address

Longitude

The angular distance east or west from the prime meridian measured through 180 degrees.

Data/PrimaryLongitude

Longitude Short Oracle Account Enrichment 49 not mapped not mapped 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. Data/LongitudeShort

Location ID

internal attribute 50

Address

LocationOrigSystemReference

The ID of the location object sent by DaaS to Engagement Cloud.

Data/PrimaryLocationOrigSystemReference

Site ID

internal attribute 51

Address

SiteOrigSystemReference

The ID of the site object sent by DaaS to Engagement Cloud.

Data/PrimarySiteOrigSystemReference

Mailing Address 1

Oracle Account Enrichment 52

Address

Address1

The address line where a business has its mail delivered. Generally in local language.

Data/MailingAddressLine1

Mailing Address 2

Oracle Account Enrichment 53

Address

Address2

The second street address line where a business has its mail delivered. Generally in local language.

Data/MailingAddressLine2

Mailing City

Oracle Account Enrichment 54

Address

City

The city name where the business has its mail delivered. Generally in local language.

Data/MailingCity

Mailing State

Oracle Account Enrichment 55

Address

State

The abbreviation for the state or province where the business has its mail delivered.

Data/MailingState

OSC Mailing Postal Code

internal attribute 56

Address

PostalCode

The 5-digit postal code where the business has its mail delivered.

Data/MailingPostalCode

OSC Mailing Post Plus 4 Code internal attribute 57 Address PostalPlus4Code The 4 digits that determine a more specific location within a given ZIP code where the business has its mail delivered. Data/MailingPostPlus4Code
Mailing Full Postal Code Oracle Account Enrichment 58 not mapped not mapped

Full postal code as received by D&B.

Data/MailingFullPostalCode

Mailing Country

internal attribute 59

Address

Country

The country where the business has its mail delivered.

Data/MailingCountry

Mailing Location ID

internal attribute 60

Address

LocationOrigSystemReference

The ID of the mailing location object sent by DaaS to Engagement Cloud.

Data/MailingLocationOrigSystemReference

Mailing Site ID

internal attribute 61

Address

SiteOrigSystemReference

The ID of the mailing site object sent by DaaS to Engagement Cloud.

Data/MailingSiteOrigSystemReference

Mailing Site Use type

internal attribute 62

Address

SiteUseType

A literal value that DaaS sends to Engagement Cloud denoting the type of address. Example: Mail To, Sent To.

Data/MailingSiteUseType

Country Access Code

Oracle Account Enrichment 63

PrimaryPhone

PhoneCountryCode

The international dialing code required to connect to the phone or fax number when dialing internationally.

Data/PhoneCountryCode

Phone Number

Oracle Account Enrichment 64

PrimaryPhone

RawPhoneNumber

The primary phone number for the business with no formatting or punctuation. This string contains all telecommunication number components (area code, exchange, number).

Data/RawPhoneNumber

Phone ID

internal attribute 65

PrimaryPhone

CpOrigSystemReference

The ID of the phone object sent by DaaS to Engagement Cloud.

Data/PhoneOrigSystemReference

Facsimile Number

Oracle Account Enrichment 66

Fax

RawPhoneNumber

The primary facsimile number for the business with no formatting or punctuation. This string contains all telecommunication number components (area code, exchange, number).

Data/FaxRawPhoneNumber

Fax ID

internal attribute 67

Fax

CpOrigSystemReference

The ID of the fax object sent by DaaS to Engagement Cloud.

Data/FaxOrigSystemReference

Url

Oracle Account Enrichment 68

Url

Url

The primary URL for the company.

Data/Url

WebSite ID

internal attribute 69

Url

CpOrigSystemReference

The ID of the website object sent by DaaS to Engagement Cloud.

Data/UrlOrigSystemReference

Woman Owned Oracle Account Enrichment 70 OrganizationProfile WOMAN_OWNED_IND A business that is at least 51% owned by, and whose management and daily business operations are controlled by, a woman. Data/WomanOwned

Trade Name Type

internal attribute 71

AdditionalName

NameType

A literal value that DaaS sends to Engagement Cloud denoting the type of business name. Example: Alias.

Data/AdditionalNameType1

Trade Style Name

Oracle Account Enrichment 72

AdditionalName

Name

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

Data/AdditionalName1

Trade Name 2 Type

internal attribute 73

AdditionalName

NameType

A literal value that DaaS sends to Engagement Cloud denoting the type of business name. Example: Alias.

Data/AdditionalNameType2

Trade Style Name 2

Oracle Account Enrichment 74

AdditionalName

Name

A second trading style name used by the business.

TradeStyleName2 Data/AdditionalName2

Trade Name 3 Type

internal attribute 75

AdditionalName

NameType

A literal value that DaaS sends to Engagement Cloud denoting the type of business name. Example: Alias.

Data/AdditionalNameType3

Trade Style Name 3 Oracle Account Enrichment 76

AdditionalName

Name

An additional name used by a business for advertising or buying purposes: a "doing business as" name.

Data/AdditionalName3

Trade Name 4 Type

internal attribute 77

AdditionalName

NameType

A literal value that DaaS sends to Engagement Cloud denoting the type of business name. Example: Alias.

Data/AdditionalNameType4

Trade Style Name 4 Oracle Account Enrichment 78

AdditionalName

Name

An additional name used by a business for advertising or buying purposes:a "doing business as" name.

Data/AdditionalName4

Trade Name 5 Type

internal attribute 79

AdditionalName

NameType

A literal value that DaaS sends to Engagement Cloud denoting the type of business name. Example: Alias.

Data/AdditionalNameType5

Trade Style Name 5

Oracle Account Enrichment 80

AdditionalName

Name

An additional name used by a business for advertising or buying purposes: a "doing business as" name.

Data/AdditionalName5

Major Industry Category internal attribute 81 Classification ClassificationCategory

Send a hard code category = MAJOR_INDUSTRY.

Data/MajorIndustryCategory
Major Industry Category Code Oracle Account Enrichment 82 Classification ClassificationCode A code value that denotes under which major industry category an establishment falls. Data/MajorIndustryCategoryCode

NAICS Class Category1_1

internal attribute 83

Classification

ClassificationCategory

A literal value that denotes the type of classification. Example: Major Industry, SIC 1987, NAICS 2017.

Data/NAICSClassCategory1_1

NAICS Class Code1_1

Oracle Account Enrichment 84

Classification

ClassificationCode

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.

Data/NAICSClassCode1_1

NAICS Class Category1_2

internal attribute 85

Classification

ClassificationCategory

A literal value that denotes the type of classification. Example: Major Industry, SIC 1987, NAICS 2017.

Data/NAICSClassCategory1_2

NAICS Class Code1_2

Oracle Account Enrichment 86

Classification

ClassificationCode

The North American Industry Classification System equivalent for the combination of the first 4 bytes and the first 4-byte node of the secondary SIC code.

Data/NAICSClassCode1_2

NAICS Class Category1_3

internal attribute 87

Classification

ClassificationCategory

A literal value that denotes the type of classification. Example: Major Industry, SIC 1987, NAICS 2017.

Data/NAICSClassCategory1_3

NAICS Class Code1_3

Oracle Account Enrichment 88

Classification

ClassificationCode

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.

Data/NAICSClassCode1_3

NAICS Class Category1_4

internal attribute 89

Classification

ClassificationCategory

A literal value that denotes the type of classification. Example: Major Industry, SIC 1987, NAICS 2017.

Data/NAICSClassCategory1_4

NAICS Class Code1_4

Oracle Account Enrichment 90

Classification

ClassificationCode

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.

Data/NAICSClassCode1_4

NAICS Class Category2_1

internal attribute 91

Classification

ClassificationCategory

A literal value that denotes the type of classification. Example: Major Industry, SIC 1987, NAICS 2017.

Data/NAICSClassCategory2_1

NAICS Class Code2_1

Oracle Account Enrichment 92

Classification

ClassificationCode

The North American Industry Classification System equivalent for the combination of the first 4 bytes and the first 4 byte node of the secondary SIC code.

Data/NAICSClassCode2_1

NAICS Class Category2_2

internal attribute 93

Classification

ClassificationCategory

A literal value that denotes the type of classification. Example: Major Industry, SIC 1987, NAICS 2017.

Data/NAICSClassCategory2_2

NAICS Class Code2_2

Oracle Account Enrichment 94

Classification

ClassificationCode

The NAICS equivalent for the combination of the first 4 bytes and the second 4 byte node of the secondary SIC code.

Data/NAICSClassCode2_2

NAICS Class Category2_3

internal attribute 95

Classification

ClassificationCategory

A literal value that denotes the type of classification. Example: Major Industry, SIC 1987, NAICS 2017.

Data/NAICSClassCategory2_3

NAICS Class Code2_3

Oracle Account Enrichment 96

Classification

ClassificationCode

The NAICS equivalent for the combination of the first 4 bytes and the third 4 byte node of the secondary SIC code.

Data/NAICSClassCode2_3

NAICS Class Category2_4

internal attribute 97

Classification

ClassificationCategory

A literal value that denotes the type of classification. Example: Major Industry, SIC 1987, NAICS 2017.

Data/NAICSClassCategory2_4

NAICS Class Code2_4

Oracle Account Enrichment 98

Classification

ClassificationCode

The NAICS equivalent for the combination of the first 4 bytes and the fourth 4 byte node of the secondary SIC code.

Data/NAICSClassCode2_4

NAICS Class Category3_1

internal attribute 99

Classification

ClassificationCategory

A literal value that denotes the type of classification. Example: Major Industry, SIC 1987, NAICS 2017.

Data/NAICSClassCategory3_1

NAICS Class Code3_1

Oracle Account Enrichment 100

Classification

ClassificationCode

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.

Data/NAICSClassCode3_1

NAICS Class Category3_2

internal attribute 101

Classification

ClassificationCategory

A literal value that denotes the type of classification. Example: Major Industry, SIC 1987, NAICS 2017.

Data/NAICSClassCategory3_2

NAICS Class Code3_2

Oracle Account Enrichment 102

Classification

ClassificationCode

The NAICS equivalent for the combination of the first 4 bytes and the second 4 byte node of the third SIC code.

Data/NAICSClassCode3_2

NAICS Class Category3_3

internal attribute 103

Classification

ClassificationCategory

A literal value that denotes the type of classification. Example: Major Industry, SIC 1987, NAICS 2017.

Data/NAICSClassCategory3_3

NAICS Class Code3_3

Oracle Account Enrichment 104

Classification

ClassificationCode

The NAICS equivalent for the combination of the first 4 bytes and the third 4 byte node of the third SIC code.

Data/NAICSClassCode3_3

NAICS Class Category3_4

internal attribute 105

Classification

ClassificationCategory

A literal value that denotes the type of classification. Example: Major Industry, SIC 1987, NAICS 2017.

Data/NAICSClassCategory3_4

NAICS Class Code3_4

Oracle Account Enrichment 106

Classification

ClassificationCode

The NAICS equivalent for the combination of the first 4 bytes and the fourth 4 byte node of the third SIC code.

Data/NAICSClassCode3_4

NAICS Class Category4_1

internal attribute 107

Classification

ClassificationCategory

A literal value that denotes the type of classification. Example: Major Industry, SIC 1987, NAICS 2017.

Data/NAICSClassCategory4_1

NAICS Class Code4_1

Oracle Account Enrichment 108

Classification

ClassificationCode

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.

Data/NAICSClassCode4_1

NAICS Class Category4_2

internal attribute 109

Classification

ClassificationCategory

A literal value that denotes the type of classification. Example: Major Industry, SIC 1987, NAICS 2017.

Data/NAICSClassCategory4_2

NAICS Class Code4_2

Oracle Account Enrichment 110

Classification

ClassificationCode

The NAICS equivalent for the combination of the first 4 bytes and the second 4 byte node of the fourth SIC code.

Data/NAICSClassCode4_2

NAICS Class Category4_3

internal attribute 111

Classification

ClassificationCategory

A literal value that denotes the type of classification. Example: Major Industry, SIC 1987, NAICS 2017.

Data/NAICSClassCategory4_3

NAICS Class Code4_3

Oracle Account Enrichment 112

Classification

ClassificationCode

The NAICS equivalent for the combination of the first 4 bytes and the third 4 byte node of the fourth SIC code.

Data/NAICSClassCode4_3

NAICS Class Category4_4

internal attribute 113

Classification

ClassificationCategory

A literal value that denotes the type of classification. Example: Major Industry, SIC 1987, NAICS 2017.

Data/NAICSClassCategory4_4

NAICS Class Code4_4

Oracle Account Enrichment 114

Classification

ClassificationCode

The NAICS equivalent for the combination of the first 4 bytes and the fourth 4 byte node of the fourth SIC code.

Data/NAICSClassCode4_4

NAICS Class Category5_1

internal attribute 115

Classification

ClassificationCategory

A literal value that denotes the type of classification. Example: Major Industry, SIC 1987, NAICS 2017.

Data/NAICSClassCategory5_1

NAICS Class Code5_1

Oracle Account Enrichment 116

Classification

ClassificationCode

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.

Data/NAICSClassCode5_1

NAICS Class Category5_2

internal attribute 117

Classification

ClassificationCategory

A literal value that denotes the type of classification. Example: Major Industry, SIC 1987, NAICS 2017.

Data/NAICSClassCategory5_2

NAICS Class Code5_2

Oracle Account Enrichment 118

Classification

ClassificationCode

The NAICS equivalent for the combination of the first 4 bytes and the second 4 byte node of the fifth SIC code.

Data/NAICSClassCode5_2

NAICS Class Category5_3

internal attribute 119

Classification

ClassificationCategory

A literal value that denotes the type of classification. Example: Major Industry, SIC 1987, NAICS 2017.

Data/NAICSClassCategory5_3

NAICS Class Code5_3

Oracle Account Enrichment 120

Classification

ClassificationCode

The NAICS equivalent for the combination of the first 4 bytes and the third 4 byte node of the fifth SIC code.

Data/NAICSClassCode5_3

NAICS Class Category5_4

internal attribute 121

Classification

ClassificationCategory

A literal value that denotes the type of classification. Example: Major Industry, SIC 1987, NAICS 2017.

Data/NAICSClassCategory5_4

NAICS Class Code5_4

Oracle Account Enrichment 122

Classification

ClassificationCode

The NAICS equivalent for the combination of the first 4 bytes and the fourth 4 byte node of the fifth SIC code.

Data/NAICSClassCode5_4

NAICS Class Category6_1

internal attribute 123

Classification

ClassificationCategory

A literal value that denotes the type of classification. Example: Major Industry, SIC 1987, NAICS 2017.

Data/NAICSClassCategory6_1

NAICS Class Code6_1

Oracle Account Enrichment 124

Classification

ClassificationCode

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.

Data/NAICSClassCode6_1

NAICS Class Category6_2

internal attribute 125

Classification

ClassificationCategory

A literal value that denotes the type of classification. Example: Major Industry, SIC 1987, NAICS 2017.

Data/NAICSClassCategory6_2

NAICS Class Code6_2

Oracle Account Enrichment 126

Classification

ClassificationCode

The NAICS equivalent for the combination of the first 4 bytes and the second 4 byte node of the sixth SIC code.

Data/NAICSClassCode6_2

NAICS Class Category6_3

internal attribute 127

Classification

ClassificationCategory

A literal value that denotes the type of classification. Example: Major Industry, SIC 1987, NAICS 2017.

Data/NAICSClassCategory6_3

NAICS Class Code6_3

Oracle Account Enrichment 128

Classification

ClassificationCode

The NAICS equivalent for the combination of the first 4 bytes and the third 4 byte node of the sixth SIC code.

Data/NAICSClassCode6_3

NAICS Class Category6_4

internal attribute 129

Classification

ClassificationCategory

A literal value that denotes the type of classification. Example: Major Industry, SIC 1987, NAICS 2017.

Data/NAICSClassCategory6_4

NAICS Class Code6_4

Oracle Account Enrichment 130

Classification

ClassificationCode

The NAICS equivalent for the combination of the first 4 bytes and the fourth 4 byte node of the sixth SIC code.

Data/NAICSClassCode6_4

SIC Code 1 Category

internal attribute 131

Classification

ClassificationCategory

A literal value that denotes the type of classification. Example: Major Industry, SIC 1987, NAICS 2017.

Data/SICClassCategory1

US 1987 SIC 1

Oracle Account Enrichment 132

Classification

ClassificationCode

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

Data/SICClassCode1

SIC Code 2 Category

internal attribute 133

Classification

ClassificationCategory

A literal value that denotes the type of classification. Example: Major Industry, SIC 1987, NAICS 2017.

Data/SICClassCategory2

US 1987 SIC 2

Oracle Account Enrichment 134

Classification

ClassificationCode

The Standard Industrial Classification code for the second line of business operations as ranked by percent of sales/revenue.

Data/SICClassCode2

SIC Code 3 Category

internal attribute 135

Classification

ClassificationCategory

A literal value that denotes the type of classification. Example: Major Industry, SIC 1987, NAICS 2017.

Data/SICClassCategory3

US 1987 SIC 3

Oracle Account Enrichment 136

Classification

ClassificationCode

The Standard Industrial Classification code for the third line of business operations as ranked by percent of sales/revenue.

Data/SICClassCode3

SIC Code 4 Category

internal attribute 137

Classification

ClassificationCategory

A literal value that denotes the type of classification. Example: Major Industry, SIC 1987, NAICS 2017.

Data/SICClassCategory4

US 1987 SIC 4

Oracle Account Enrichment 138

Classification

ClassificationCode

The Standard Industrial Classification code for the fourth line of business operations as ranked by percent of sales/revenue.

Data/SICClassCode4

SIC Code 5 Category

internal attribute 139

Classification

ClassificationCategory

A literal value that denotes the type of classification. Example: Major Industry, SIC 1987, NAICS 2017.

Data/SICClassCategory5

US 1987 SIC 5

Oracle Account Enrichment 140

Classification

ClassificationCode

The Standard Industrial Classification code for the fifth line of business operations as ranked by percent of sales/revenue.

Data/SICClassCode5

SIC Code 6 Category

internal attribute 141

Classification

ClassificationCategory

A literal value that denotes the type of classification. Example: Major Industry, SIC 1987, NAICS 2017.

Data/SICClassCategory6

US 1987 SIC 6

Oracle Account Enrichment 142

Classification

ClassificationCode

The Standard Industrial Classification code for the sixth line of business operations as ranked by percent of sales/revenue.

Data/SICClassCode6

Match Score internal attribute 143 not mapped not mapped

A score representing the likelihood of a match between records.

MetaData/MatchScore
Company Description Oracle Account Enrichment 144 not mapped not mapped Narrative company description. Data/CompanyDescription
Marketability Indicator Oracle Account Enrichment 145 not mapped not mapped Indicates that the record satisfies D&B global marketability rules. Data/MarketableIndicator
GEO Code Accuracy Oracle Account Enrichment 146 not mapped not mapped A code value that describes how close the coordinates for a location are to “rooftop” level. Data/GEOCodeAccuracy
Sales Volume (US Dollars) Reliability Code Oracle Account Enrichment 147 not mapped not mapped A code value that describes the reliability of the annual sales/revenue figure that is expressed in US dollars. Data/SalesVolume(USDollars)Reliability Code
Sales Volume US Dollars Oracle Account Enrichment 148 not mapped not mapped The total annual sales/revenue for this business in local currency. Not available on branch locations. Data/SalesVolume(LocalCurrency)
Sales Volume Local Currency Reliability Code Oracle Account Enrichment 149 not mapped not mapped A code value that describes the reliability of the annual sales/revenue figure that is expressed in local currency. Data/SalesVolumeLocalCurrencyReliabilityCode
Domestic Ultimate Business Name Oracle Account Enrichment 150 not mapped not mapped The primary name of the domestic ultimate business. Data/DomesticUltimateBusinessName
Domestic Ultimate FIPS Country Code Oracle Account Enrichment 151 not mapped not mapped The Federal Information Processing Standards code value that identifies the country where the domestic ultimate company is located. Data/DomesticUltimateFIPSCountryCode
Domestic Ultimate D&B Country Code Oracle Account Enrichment 152 not mapped not mapped D&B geographical code identifying the country where the domestic ultimate is located. Data/DomesticUltimateD&BCountryCode
Domestic Ultimate State Province Abbreviation Oracle Account Enrichment 153 not mapped not mapped The abbreviated name of the state or province in which the domestic ultimate is located. Data/DomesticUltimateState/ProvinceAbbreviation
Global Ultimate Business Name Oracle Account Enrichment 154 not mapped not mapped The name of the ultimate company. Data/GlobalUltimateBusinessName
Global Ultimate Indicator Oracle Account Enrichment 155 not mapped not mapped Indicates whether the site record is the Global Ultimate D-U-N-S within the corporate family tree. Data/GlobalUltimateIndicator
Global Ultimate FIPS Country Code Oracle Account Enrichment 156 not mapped not mapped The Federal Information Processing Standards code value that identifies the country where the ultimate company is located. Data/GlobalUltimateFIPSCountryCode
Global Ultimate D&B Country Code Oracle Account Enrichment 157 not mapped not mapped D&B geographical code identifying the country where the ultimate company is located. Data/GlobalUltimateD&BCountryCode
Global Ultimate State Province Abbreviation Oracle Account Enrichment 158 not mapped not mapped The abbreviated name of the state or province in which the domestic ultimate is located. Data/GlobalUltimateState/ProvinceAbbreviation
Headquarter DUNS Number Oracle Account Enrichment 159 not mapped not mapped The D-U-N-S number of the headquarter organization. May contain lead zeros which will be lost if field is treated as numeric. Data/HeadquarterDUNSNumber
Parent Headquarter Business Name Oracle Account Enrichment 160 not mapped not mapped The primary name of the parent/headquarter company. Data/Parent/HeadquarterBusinessName
Hierarchy Code Oracle Account Enrichment 161 not mapped not mapped 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. Data/HierarchyCode
Number of Family Members Oracle Account Enrichment 162 not mapped not mapped 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. Data/NumberofFamilyMembers
Out of Business Indicator Oracle Account Enrichment 163 not mapped not mapped Indicates that the business is out of business or inactive based upon D&B policies and procedures. Data/OutofBusinessIndicator
Over the Counter Stock Exchange Oracle Account Enrichment 164 not mapped not mapped The symbol used to trade the company's stock on the Over the Counter Stock Exchange. Data/OvertheCounterStockExchange
NYSE Stock Exchange Oracle Account Enrichment 165 not mapped not mapped The symbol used to trade the company's stock on the New York Stock Exchange. Data/NYSEStockExchange
ASE Ticker Oracle Account Enrichment 166 not mapped not mapped The symbol used to trade the company's stock on the American Stock Exchange. Data/ASETicker
NMS Ticker Oracle Account Enrichment 167 not mapped not mapped The symbol used to trade the company's stock on the NASDAQ National Market. Data/NMSTicker
NAS Ticker Oracle Account Enrichment 168 not mapped not mapped The symbol used to trade the company's stock on the NASDAQ Small Cap Exchange. Data/NASTicker
Operates From Residence Indicator Oracle Account Enrichment 169 not mapped not mapped A flag stating whether or not the business is run from a residential address. Data/OperatesFromResidenceIndicator
Primary Competitor 1 Oracle Account Enrichment 170 not mapped not mapped DUNS number of the company deemed to be the primary competitor for the business. Data/PrimaryCompetitor1
3 Year Growth Percentage on Sales Volume Oracle Account Enrichment 171 not mapped not mapped The percentage increase or decrease in the sales volume over a three year period. Includes a + or - sign denoting positive or negative growth in sales. Data/3YearGrowthPercentageonSalesVolume
3 Year Growth Percentage on Employees Oracle Account Enrichment 172 not mapped not mapped The percentage increase or decrease in the number of employees over a three year period. Includes a + or - sign denoting positive or negative growth in sales. Data/3YearGrowthPercentageonEmployees
Delinquency Risk Oracle Account Enrichment 173 not mapped not mapped 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. Data/DeliquencyRisk
Census FIPS Territory Code Oracle Account Enrichment 174 not mapped not mapped 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. Data/CensusFIPSTerritoryCode
Census FIPS Country Code Oracle Account Enrichment 175 not mapped not mapped The Federal Information Processing Standards county code identifying the county where the subject is located. Data/CensusFIPSCountyCode
Primary Competitor 2 Oracle Account Enrichment 184 not mapped not mapped DUNS number of the company deemed to be the second primary competitor for the business. Data/PrimaryCompetitor2
Primary Competitor 3 Oracle Account Enrichment 185 not mapped not mapped DUNS number of the company deemed to be the third primary competitor for the business. Data/PrimaryCompetitor3
Secondary Competitor 1 Oracle Account Enrichment 186 not mapped not mapped DUNS number of the company deemed to be the secondary competitor for the business. Data/SecondaryCompetitor1
Secondary Competitor 2 Oracle Account Enrichment 187 not mapped not mapped DUNS number of the company deemed to be the second secondary competitor for the business. Data/SecondaryCompetitor2
Global Exchange Name Oracle Account Enrichment 188 not mapped not mapped The exchange where the stock symbol is listed. Data/GlobalExchangeName
Primary Indicator Oracle Account Enrichment 189 not mapped not mapped Indicates whether or not the ticker is the primary one for the business. Data/PrimaryIndicator
National Identification Code Oracle Account Enrichment 190 not mapped not mapped A code value that describes the type of national ID number provided; for example, ‘12’ = CRO, ‘14’ = Siren. Data/NationalIdentificationCode
FIPS MSA Code Oracle Account Enrichment 191 not mapped not mapped 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. Data/FIPSMSACode
Parent Headquarter D&B Country Code Oracle Account Enrichment 192 not mapped not mapped D&B geographical code identifying the country where the parent/headquarter is located Data/ParentHeadquarterD&BCountryCode

Understand the EngagementCloudCompanyMatch Mapping

During matching, Engagement Cloud sends DaaS a list of attributes for matching. (The Engagement Cloud CompanyMatch mapping uses the same attributes as the Engagement Cloud CompanyExport mapping – see Understand the EngagementCloudCompanyExport Mapping.)

A company record is rejected if the DaaS Id field is invalid or if any of the following fields is missing:

  • PartyId (for example, CRM ID)

  • Name

  • City

  • DaaS Id

  • ExternalId

In addition to the required attributes, the following attributes also are sent:

  • Data Cloud Status: This indicates whether or not the record was previously matched.

  • DUNS#: If Engagement Cloud sends the DUNS# of the company, then DaaS can do a match using that unique number (DUNS#). There is no need to use the other required fields required for matching.

See About Matching Records.

When you export records from Engagement Cloud for matching, the values are exported from the Source Attribute (OSC) and Source Object (OSC) columns. DaaS completes the matching process, and the matched file is exported in a TXT file. This file should have the same columns as the columns in the TXT file during an export job that uses the template EngagementCloudCompanyExport.

Understand the EngagementCloudContactExport Mapping

Use the following table to understand how EngagementCloudContactExport attributes map to Engagement Cloud attributes.

Note:

Mappings that contain contact attributes require a subscription for contact records. For example, the EngagementCloudContactMatch mapping requires a subscription for Oracle Contact Enrichment (for contact attributes).

To see the geographic availability of each attribute, see Understand Attributes.

Data Attribute Subscription Level Sequence Engagement Cloud Object Engagement Cloud Attribute Description Column in TXT/CSV File

External ID

internal attribute 1

PersonProfile

ObjectKey

The ID of the contact and sent by Engagement Cloud to DaaS.

Data/PartyId

Orig System

Oracle Contact Enrichment 2

PersonProfile

PartyOrigSystem

The source from which the data is procured ( DaaS).

Data/PartyOrigSystem

Person ID

Oracle Contact Enrichment 3

PersonProfile

PartyOrigSystemReference

The ID of the contact sent by DaaS to Engagement Cloud.

Data/PartyOrigSystemReference

Data Cloud Status

Oracle Contact Enrichment 4

PersonProfile

DataCloudStatus

The status of the record. Example: Matched.

Data/DataCloudStatus

Prefix

Oracle Contact Enrichment 5

PersonProfile

PersonPreNameAdjunct

The prefix (Mr., Ms., Dr.) associated with the person's name.

Data/PersonPreNameAdjunct

First Name

Oracle Contact Enrichment 6

PersonProfile

PersonFirstName

The first name of the person.

Data/PersonFirstName

Middle Name

internal attribute 7

PersonProfile

PersonMiddleName

The middle name of the person.

Data/PersonMiddleName

Last Name

Oracle Contact Enrichment 8

PersonProfile

PersonLastName

The last name of the person.

Data/PersonLastName

Title

Oracle Contact Enrichment 9

PersonProfile

JobTitle

The title associated with the person's role. This is the title as it would read on a person's business card.

Data/JobTitle

MRC Code Oracle Contact Enrichment 10 not mapped not mapped The management responsibility code, which is a code that has been derived from the vanity title or standardized title. Data/MRCCode

Suffix

Oracle Contact Enrichment 12

PersonProfile

PersonNameSuffix

The last name suffix of the person.

Data/PersonNameSuffix

External Parent ID

Oracle Contact Enrichment 13

ContactRelationship

ObjectId

The ID of the organization object sent by DaaS to Engagement Cloud.

Data/OrganizationId

Organization Orig System

Oracle Contact Enrichment 14

ContactRelationship

ObjOrigSystem

The source from which the data is procured (DaaS).

Data/OrganizationOrigSystem

Parent Daas ID

internal attribute 15

ContactRelationship

ObjOrigSystemReference

The ID of the organization object in a company associated with the contact record and sent by DaaS to Engagement Cloud.

Data/OrgOrigSystemReference

Relationship ID

Oracle Contact Enrichment 16

ContactRelationship

RelOrigSystemReference

The ID of the relationship object sent by DaaS to Engagement Cloud.

Data/RelOrigSystemReference

Location ID

Oracle Contact Enrichment 17

Address

LocationOrigSystemReference

The ID of the location object sent by DaaS to Engagement Cloud.

Data/LocationOrigSystemReference

Site ID

Oracle Contact Enrichment 18

Address

SiteOrigSystemReference

The ID of the site object sent by DaaS to Engagement Cloud.

Data/SiteOrigSystemReference

Street Address 1

Oracle Contact Enrichment 19

Address

Address1

The first street address line where a business is physically located. Generally in local language.

Data/Address1

City

Oracle Contact Enrichment 20

Address

City

The name of the city where the business is physically located.  Generally in local language.

Data/City

State

Oracle Contact Enrichment 21

Address

State

The abbreviation for the physical state or province name where the business is located.

Data/State

OCS Postal Code

Oracle Contact Enrichment 22

Address

PostalCode

The 5-digit postal code where the business is physically located.

Data/PostalCode

OSC Postal Plus 4 Code Oracle Contact Enrichment 23 Address PostalPlus4Code The 4 digits that determine a more specific location within a given ZIP code. Data/PostalPlus4Code
Primary Full Postal Code Oracle Contact Enrichment 24 not mapped not mapped Full postal code as received by D&B. Data/FullPostalCode

Country

Oracle Contact Enrichment 25

Address

Country

The 2-byte alpha character ISO code for the country where the business is located.

Data/Country

Direct Phone ID

internal attribute 26

Phone

CpOrigSystemReference

The ID of the phone object sent by DaaS to Engagement Cloud.

Data/PhoneOrigSystemReference

Direct Dial Phone

Oracle Contact Enrichment 27

Phone

RawPhoneNumber

The direct-dial phone number associated with this person in this role. It includes country code, area code and phone number.

Data/PhoneRawPhoneNumber

Company Phone ID

internal attribute 28

Phone

CpOrigSystemReference

Internal ID value.

Data/PhoneOrigSystemReference

Company Phone Oracle Contact Enrichment 29 Phone PhoneNumber The company phone number at which the professional can be reached (for current role assignments). Data/CompanyPhone
Company Phone Extension Oracle Contact Enrichment 30 Phone PhoneExtension This is the phone extension associated with the company phone number indicated on this record. Data/PhoneExtension

Email ID

internal attribute 31

Email

CpOrigSystemReference

The ID of the email object sent by DaaS to Engagement Cloud.

Data/EmailOrigSystemReference

Email Address

Oracle Contact Enrichment 32

Email

EmailAddress

The main email address associated with this person's role or contact record.

Data/EmailAddress

DUNS Number Oracle Contact Enrichment 33 not mapped not mapped DUNS number of the business location. Data/DUNSNumber
Individual ID Oracle Contact Enrichment 34 not mapped not mapped The unique identifier of the professional. Data/IndividualID
Role ID Oracle Contact Enrichment 35 not mapped not mapped Unique identifier of the professional’s job at a particular DUNS location. Data/RoleID
Last Update Date Role Oracle Contact Enrichment 36 not mapped not mapped The date any of the role data was last updated. Data/LastUpdateDateRole
Department Oracle Contact Enrichment 37 PersonProfile Department A division of a large organization such as Executive, Administration, etc. Data/Department Department
Management Level Oracle Contact Enrichment 38 not mapped not mapped Level of management; for example, C-Level, VP Level, and so on. Data/ManagementLevel
Standardized Title Oracle Contact Enrichment 39 not mapped not mapped A business title derived from the Management Responsibility Code which identifies a title or area of responsibility of an executive. Data/StandardizedTitle
Match Score internal attribute 40 not mapped not mapped A score representing the likelihood of a match between records. MetaData/MatchScore
Location Oracle Contact Enrichment 43 not mapped not mapped Address information for individual. Data/Location

Understand the EngagementCloudContactMatch Mapping

During matching, Engagement Cloud sends DaaS a list of attributes for matching. (The Engagement Cloud ContactMatch mapping uses the same attributes as the Engagement Cloud ContactExport mapping – see Understand the EngagementCloudContactExport Mapping.)

A contact record is rejected if the Parent DaaS Id field is invalid or if any of the following fields is missing:

  • PartyId (for example, CRM ID)

  • Last Name

  • First Name

  • Parent Company Name

  • Parent DaaS Id

  • ExternalId

In addition to the required attributes, the following attributes also are sent:

  • DataCloudStatus: This indicates whether or not the record was previously matched.

  • DUNS#: If Engagement Cloud sends the DUNS# of the company, then DaaS can do a match using that unique number (DUNS#). There is no need to use the other required fields required for matching.

When you export records from Engagement Cloud for matching, the values are exported from the Source Attribute (OSC) and Source Object (OSC) columns. DaaS completes the matching process, and the matched file is exported in a TXT file. This file should have the same columns as the columns in the TXT file during an export job that uses the template EngagementCloudContactExport.

See About Matching Records.

Edit Marketing Cloud Mappings

Topics:

Note:

Mappings included with DaaS cannot be deleted.

See About Matching Records.

Understand the MarketingCloudCompanyExport Mapping

Note:

Mappings that contain contact attributes require a subscription for contact records. For example, the MarketingCloudContact&CompanyMatch mapping requires a subscription for both Oracle Contact Enrichment (for contact attributes) and Oracle Account Enrichment (for company attributes).

Use the following table to understand how MarketingCloudCompanyExport attributes map to Eloqua Marketing Cloud attributes.

Data Attribute Subscription Level Eloqua Attribute Description Column in TXT/CSV File

External ID

internal attribute

Eloqua Company ID

The unique ID of a company in Eloqua. 

Eloqua Company ID

Company ID

internal attribute

DaaS Company ID

The ID of a company in DaaS for Sales. 

DaaS Company ID

Business Name

Oracle Account Enrichment

Company Name

The primary or registered name of the business.

Company Name

Street Address 1

Oracle Account Enrichment

Address

The first street address line where a business is physically located. Generally in local language.

Address

Street Address 2

Oracle Account Enrichment

Address 2

The second street address line where a business is physically located. Generally in local language.

Address 2

City

Oracle Account Enrichment

City

The name of the city where the business is physically located. Generally in local language.

City

State Name

Oracle Account Enrichment

State or Province

The full name of the physical state or province name where the business is located.

State or Province

Full Postal Code

Oracle Account Enrichment

Zip or Postal Code

The postal code where the business is physically located.

Zip or Postal Code

County

Oracle Account Enrichment

Country

The full name of the county where the business is located. 

Country

Phone Number

Oracle Account Enrichment

Business Phone

The primary voice telephone number for the business with no formatting or punctuation. This string contains all telecommunication number components (area code, exchange, number).

Business Phone

Facsimile Number

Oracle Account Enrichment

Fax

The primary facsimile number for the business with no formatting or punctuation. This string contains all telecommunication number components (area code, exchange, number).

Fax

Major Industry Category 

internal attribute

Company Category

A value that denotes under which major industry category an establishment falls. 

Company Category

DUNS Number

Oracle Account Enrichment 

DUNS Number

A randomly generated nine-digit number assigned by D&B to identify unique business establishments. May contain lead zeros which will be lost if field is treated as numeric.  

DUNS Number

Understand the MarketingCloudCompanyMatch Mapping

The Marketing Cloud CompanyMatch mapping attributes are the same as the Marketing Cloud CompanyExport attributes – see Understand the MarketingCloudCompanyExport Mapping.

Understand the MarketingCloudContactExport Mapping

Use the following table to understand how MarketingCloudContactExport attributes map to Eloqua Marketing Cloud attributes.

Data Attribute Subscription Level Eloqua Attribute Description Column in TXT/CSV File

Person ID

internal attribute

DaaS Person ID

The ID of a contact in DaaS for Sales.

DaaS Person ID

External ID

internal attribute

Eloqua Contact ID

The ID of the contact in Eloqua. 

Eloqua Contact ID

Prefix

Oracle Contact Enrichment

Salutation

The prefix (Mr, Ms, Dr, etc.) associated with the professional’s name.

Salutation

First Name

Oracle Contact Enrichment

First Name

The first name of the professional.

First Name

Last Name

Oracle Contact Enrichment

Last Name

The last name of the professional.

Last Name

Title

Oracle Contact Enrichment

Title

This is the title associated with the professional’s role. This is the title as it would read on a professional’s business card.

Title

Email Address

Oracle Contact Enrichment

Email Address

This is the main email address associated with this professional’s role/contact record.

Email Address

Direct Dial Phone

Oracle Contact Enrichment

Business Phone

This is the direct dial phone number associated with this professional in this role.

Business Phone

DUNS Number 

Oracle Contact Enrichment

DUNS Number 

DUNS number of the business location.

DUNS Number 

Understand the MarketingCloudContactMatch Mapping

The Marketing Cloud ContactMatch mapping attributes are the same as the Marketing Cloud ContactExport mapping attributes – see Understand the MarketingCloudContactExport Mapping.

Understand the MarketingCloudContact&CompanyExport Mapping

Use the following table to understand how MarketingCloudContact&CompanyExport attributes map to Eloqua Marketing Cloud attributes.
Data Attribute Attribute Type Subscription Level Eloqua Attribute Description Column in TXT/CSV File

Person ID

Contact

internal attribute

DaaS Person ID

The ID of a contact in DaaS for Sales.

DaaS Person ID

External ID

Contact

internal attribute

Eloqua Contact ID

The ID of the contact in Eloqua. 

Eloqua Contact ID

Prefix

Contact

Oracle Contact Enrichment

Salutation

The prefix (Mr, Ms, Dr, etc.) associated with the professional’s name.

Salutation

First Name

Contact

Oracle Contact Enrichment

First Name

The first name of the professional.

First Name

Last Name

Contact

Oracle Contact Enrichment

Last Name

The last name of the professional.

Last Name

Title

Contact

Oracle Contact Enrichment

Title

The title associated with the professional’s role. This is the title as it would read on a professional’s business card.

Title

Email Address

Contact

Oracle Contact Enrichment

Email Address

The main email address associated with this professional’s role/contact record.

Email Address

Direct Dial Phone

Contact

Oracle Contact Enrichment

Business Phone

The direct dial phone number associated with this professional in this role.

Business Phone

Street Address 1

Company

Oracle Account Enrichment

Address 1

The first street address line where a business is physically located. Generally in local language.

Address 1

City

Company

Oracle Account Enrichment

City

The name of the city where the business is physically located. Generally in local language.

City

State

Company

Oracle Account Enrichment

State or Province

The name of the state/province where the business is located. Generally in local language.

State or Province

Primary Full Postal Code

Company

Oracle Account Enrichment

Zip or Postal Code

The 5-digit postal code where the business is physically located.

Zip or Postal Code

Country

Company

Oracle Account Enrichment

Country

The name of the country where the business is located. In English.

Country

Organization Name

Company

Oracle Account Enrichment

Company

The primary or registered name of the business. Derived from the associated company record. 

Company

Sales Volume (US Dollars)

Company

Oracle Account Enrichment

Annual Revenue

The total annual sales/revenue for this business, expressed in US dollars as a signed, decimal field.  If the sales/revenue figure is collected in local currency, the local value is converted to US dollars. Note: Data is converted to US dollars based on the date of the financial figures/statement of the record.  If the sales/revenue figure is from Jun-2009, the conversion rate is as of Jun-2009.  

Annual Revenue

Employees Total

Company

Oracle Account Enrichment

Employees

The total number of employees in the business organization; it should include subsidiary and branch locations.

Employees

Major Industry Category 

Company

internal attribute

Industry

A value that denotes under which major industry category an establishment falls. 

Industry

Facsimile Number

Company

Oracle Account Enrichment

Fax

The primary facsimile number for the business with no formatting or punctuation. This string contains all telecommunication number components (area code, exchange, number).

Fax

Street Address 2

Company

Oracle Account Enrichment

Address 2

The second street address line where a business is physically located. Generally in local language.

Address 2

DUNS Number 

Contact

Oracle Contact Enrichment

DUNS Number 

DUNS number of the business location.

DUNS Number 

Understand the MarketingCloudContact&CompanyMatch Mapping

The Marketing Cloud Contact&CompanyMatch mapping attributes are the same as the Marketing Cloud Contact&CompanyExport mapping attributes – see Understand the MarketingCloudContact&CompanyExport Mapping.