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 (Single Task Siebel Update Server Components) 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. The following three tables list the fields that are mapped when the D&B Update Manager (Siebel) server component is run. For more information, see Single Task Siebel Update Server Components.

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.

The following table shows the 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 following table shows the S_PRSP_CONTACT table mapping for D&B Update Manager (Siebel). 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 for each D&B account.

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 following table shows the S_DNB_ORG_SIC table mapping for D&B Update Manager (Siebel). 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 for each 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.

From Column	To Table	To Column
ROW_ID	S_INDUST	PR_INDUST_ID
	S_ORG_INDUST	INDUST_ID

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

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.