Bookshelf v7.7: Field Mappings for Configuration of D&B Integration

Applications Administration Guide > D&B Integration >

Field Mappings for Configuration of D&B Integration

This section provides field mapping information for three types of D&B integration processes:

Field Mapping for the D&B Update Manager Process

D&B Update Manager (D&B) server component. For the table mapping for the D&B Update Manager (D&B) component, examine the appropriate tables (Figure 29) using Siebel Tools. The default field mappings can be determined by examining the UPDATE_DNB* sections of the RTI configuration file (dnbmaps.sql or dnbmaps.tsq).

D&B Update Manager (Siebel) server component. When the D&B Update Manager (Siebel) server component is run (Figure 30), the fields listed in Table 86, Table 87, and Table 88 are mapped. The field mappings can also be determined by examining the UPDATE_SIEBEL* sections of the RTI configuration file.

For information about changing these default mappings, see Update Server Process Configuration.

Table 86. S_DNB_ORG Table Mapping for D&B Update Manager (Siebel)
From Column	To Table	To Column
DUNS_NUM	S_ORG_EXT	DUNS_NUMBER
BUSINESS_NAME	S_ORG_EXT	NAME
TRADESTYLE	S_ORG_SYN	NAME
SCND_TRADESTYLE	S_ORG_SYN	NAME
PHYS_STREET_ADDR	S_ADDR_ORG	ADDR
SECOND_STREET_ADDR	S_ADDR_ORG	ADDR
PHYSICAL_CITY	S_ADDR_ORG	CITY
PHYSICAL_STATE	S_ADDR_ORG	PROVINCE or STATE
PHYSICAL_ZIP	S_ADDR_ORG	ZIPCODE
COUNTRY_NAME	S_ADDR_ORG	COUNTRY
COUNTY_NAME	S_ADDR_ORG	COUNTY
MAIL_ADDRESS	S_ADDR_ORG	ADDR
MAIL_ADDRESS_2	S_ADDR_ORG	ADDR
MAIL_CITY	S_ADDR_ORG	CITY
MAIL_STATE	S_ADDR_ORG	STATE
MAIL_ZIP	S_ADDR_ORG	ZIPCODE
TELEPHONE	S_ORG_EXT	PH_NUM
FAX_NUMBER	S_ORG_EXT	FAX_PH_NUM
ANNL_SLS_AMT	S_ORG_EXT_X	ATTRIB_14
CURRENCY_CODE	S_ORG_EXT	BASE_CURCY_CD
EMPLOYEES_TOTAL	S_ORG_EXT_X	ATTRIB_26
EMPLOYEES_HERE	S_ORG_EXT	EMP_COUNT
YEAR_STARTED	S_ORG_EXT_X	ATTRIB_27
LOC_TYPE_STAT_IND	S_ORG_EXT	included in LOC
PUBLIC_PRIVATE_IND	S_ORG_EXT_X	ATTRIB_08
GLBLULT_DUNS_NUM	S_ORG_EXT	GLBLULT_DUNS_NUM
DOM_ULT_DUNS_NUM	S_ORG_EXT	DOM_ULT_DUNS_NUM
PAR_DUNS_NUM	S_ORG_EXT	PAR_DUNS_NUM
LINE_OF_BUSINESS	S_ORG_EXT_X	ATTRIB 03
PCT_GROWTH_SLS_3YR	S_ORG_EXT_X	ATTRIB_15

The S_PRSP_CONTACT table contains information about the D&B contacts such as the name of the CEO and various company executives. D&B provides up to four contacts per D&B account.

Table 87. S_PRSP_CONTACT Table Mapping for D&B Update Manager (Siebel)
From Column	To Table	To Column
LAST_NAME	S_CONTACT	LAST_NAME
FST_NAME	S_CONTACT	FST_NAME
MID_NAME	S_CONTACT	MID_NAME
PER_TITLE	S_CONTACT	PER_TITLE
PER_TITLE_SUFFIX	S_CONTACT	PER_TITLE_SUFFIX
JOB_TITLE	S_CONTACT	JOB_TITLE
SEX_MF	S_CONTACT	SEX_MF

The S_DNB_ORG_SIC table contains the Standard Industrial Classification (SIC) code developed by the US Government. The code is assigned to businesses and other organizations by classifying and subdividing the activity performed by that establishment at that location. D&B provides up to six SICs per D&B account. In the D&B Update Manager process, the primary SIC code is mapped to the S_INDUST table and all SIC codes are mapped to the S_ORG_INDUST table.

Table 88. S_DNB_ORG_SIC Table Mapping for D&B Update Manager (Siebel)
From Column	To Table	To Column
ROW_ID	S_INDUST	PR_INDUST_ID
ROW_ID	S_ORG_INDUST	INDUST_ID

Table 89 describes how address and contact information is updated by the D&B Update Manager (Siebel) process.

Table 89. Update Rules for Addresses and Contacts
If This D&B Information Changes...	Then...
Street address City (Abbreviated) state	A new address record is added to the Address table.



Address information other than street address, city, or state	The address record is updated in the Address table.
Phone number Fax number	The address record is updated in the Address table.
Contact first name or Contact last name	A new contact record is added to the Contact table.
Contact information other than first or last name	The contact record is updated in the Contact table.

Field Mapping for D&B Real-Time Updates

When you purchase account information through the D&B Web site using the D&B real-time search and update feature in the Siebel application, certain fields in the Siebel business components are populated. These fields are a subset of the fields that are populated by the D&B Update Manager (D&B) server component. For example, D&B does not provide the contact first, last, and middle names fields in the real-time update.

Table 90 lists the fields that may be populated or updated when you purchase account information using the D&B real-time search and update feature.

Table 90. Fields Populated by D&B Real-Time Search and Update
D&B WorldBase Marketing Plus with Linkage	Siebel Business Component Name.Field Name
Business Structure Code (Location Type)	DNB Account.Location Type
Domestic Ultimate Name	DNB Account.Domestic Ultimate Business Name
Global Ultimate Name	DNB Account.Global Ultimate Business Name
Parent/HQ Business Name	DNB Account.Parent HQ Name
Physical State	DNB Account.State Name
Business Name	DNB Account.Business Name
Trade Style	DNB Account.Trade Style
Street Address	DNB Account.Physical Address
Mail Address	DNB Account.Mail Address
City Name	DNB Account.Physical City
Mail City Name	DNB Account.Mail City
Physical State/Province Abbreviation	DNB Account.Physical State
Mailing State/Province Abbreviation	DNB Account.Mail State
ZIP/Postal Code	DNB Account.Physical Zip
Mail Postal/ZIP Code	DNB Account.Mail Zip
Country Name	DNB Account.Country Name
D&B D-U-N-S Number	DNB Account.DUNS Number
Telephone Number	DNB Account.Main Phone 2
Cable/Telex Code	DNB Account.Cable Telex Number
Facsimile Number	DNB Account.Main Fax 2
National ID	DNB Account.National Identification Number 2
SIC Code	DNB Account.SIC Code
Primary Local Activity Code	DNB Account.Primary Local Activity Code
Year Started	DNB Account.Year Started 1
Employees Here	DNB Account.Employee Here
Employees Total	DNB Account.Employee Total
Annual Sales US Dollars	DNB Account.Sales Volume
Annual Sales Local	DNB Account.Annual Sales Local Currency
Legal Status	DNB Account.Legal Status
Subsidiary Code	DNB Account.Subsidiary Indicator
Import / Export / Agent Ind.	DNB Account.Import Export Code
Global Ultimate D&B D-U-N-S Number	DNB Account.Global Ultimate DUNS
Global Ultimate Indicator	DNB Account.Global Ultimate Indicator
Global Ultimate WorldBase Country Code	DNB Account.Global Ultimate Country Code
Domestic Ultimate D&B D-U-N-S Number	DNB Account.Domestic Ultimate DUNS
Headquarter/Parent D&B D-U-N-S Number	DNB Account.Parent HQ DUNS
HQ/Parent WorldBase Country Code	DNB Account.Parent/HQ Country Code

Field Mapping for Account Promotion and Prospect Lists

When end users promote D&B accounts or create prospect lists from the D&B screen, fields in the DNB Account and DNB Contact business components are mapped to fields in other business components. These maps are listed in Table 91 and can be viewed in detail in the Business Component User Properties window of Siebel Tools.

For information about promoting accounts and creating prospect lists, see Opportunities (End User).

Table 91. Maps of D&B to Siebel Fields for Promotion and List Creation
User Property Prefix and Map Name	D&B Source Business Component	Siebel Destination Business Component	Process and Description
Account Map	DNB Account	Account	Promotion Specifies the fields in DNB Account that is copied to Account business component
Contact Map	DNB Contact	Contact	Promotion Specifies the fields in DNB Contact that is copied to Contact business component
Mailing Address Map	DNB Account	Business Address	Promotion Specifies the mailing address fields in DNB Account that is copied to Business Address
Physical Address Map	DNB Account	Business Address	Promotion Specifies the physical address fields in DNB Account that is copied to Business Address
Prospect Info Map	DNB Contact	List Mgmt Prospective Contact	Create Prospect List Specifies the biological information (such as last name, first name, and so on)
Prospect Contact Info Map	DNB Account	List Mgmt Prospective Contact	Create Prospect List Specifies the contact information (such as company, address, phone number, and so on) fields in the DNB Account that is copied into the List Mgmt Prospective Contact