Bullhorn CRM Mappings
Overview
The following fields, grouped by their tables in Sugar Market, are pulled down from Bullhorn CRM into Sugar Market. Fields that do not have a direct mapping to Sugar Market fields are identified with "--" in the table and are also listed at the end of this page.
Accounts
|
Bullhorn Field |
Sugar Market Field |
|
-- |
AccountID (primary key) |
|
Bullhorn's Account ID (primary key) |
ID |
|
Name |
AccountName |
|
Owner.ID (foreign key) (if multiple owners, then the first Bullhorn owner is pulled) |
OwnerID (foreign key) |
Contacts, Leads, and Candidates
Bullhorn's Contacts, Leads, and Candidates table are synced with Sugar Market's Contact table. Contacts, leads, and candidates are differentiated by Sugar Market's CRMType field.
|
Bullhorn Field |
Sugar Market Field |
|
CompanyName |
AccountName1 |
|
-- |
ContactID (primary key) |
|
Bullhorn's Contact ID (primary key) |
ID |
|
ClientCorporation.ID (foreign key) |
AccountID (foreign key) |
|
Owner.ID (foreign key) |
OwnerID (foreign key) |
|
-- |
CRMType |
|
-- |
CreatedDate |
|
-- |
LastUpdate |
|
DateAdded |
ExternalCRMCreatedDate |
|
DateLastModified2 |
ExternalCRMUpdatedDate |
|
FirstName |
FirstName |
|
LastName |
LastName |
|
|
|
|
MassMailOptOut |
OpOut |
|
Source |
Source |
|
- - |
LeadSource3 |
|
Occupation |
Title |
|
Phone |
Phone |
|
MobilePhone |
MobilePhone |
|
Address.Address1 |
MailingStreet |
|
Address.Address2 |
MailingStreet2 |
|
Address.City |
MailingCity |
|
Address.State |
MailingState |
|
Address.Zip |
MailingZip |
|
Address.Countryname |
MailingCountry |
1 The Sugar Market AccountName only populates the CompanyName field when the CompanyName field is empty. If a value exists in the CompanyName field during sync, then no change is made.
2 The DateLastModified field is the field that Sugar Market uses to determine if the record has been updated since the last successful sync to evaluate if the record needs to be synced.
3 LeadSource is a SugarMarket local field that does not natively sync up to Bullhorn. Instead, use the Source field to map between both Bullhorn and SugarMarket.
Opportunities
|
Bullhorn Field |
Sugar Market Field |
|
-- |
OpportunityID (primary key) |
|
Bullhorn's Opportunity ID (primary key) |
ID |
|
ClientCorporation.ID (foreign key) |
AccountID (foreign key) |
|
Owner.ID (foreign key) |
OwnerID (foreign key) |
|
ClientContact.ID |
ContactID (foreign key) |
|
Leadsource: Description |
LeadSource |
|
Description |
Description |
|
Dealvalue |
Amount |
|
Title |
OpportunityName |
|
Status |
Stage |
|
ActualCloseDate |
ClosingDate |
Users
|
Bullhorn Field |
Sugar Market Field |
|
-- |
UserID (primary key) |
|
Bullhorn's user ID (primary key) |
ID |
|
|
|
|
FirstName |
First_name |
|
LastName |
Last_name |
|
Username |
Username |
|
Name |
Name |
|
Enabled |
Status |
|
Address1 |
Address.Address1 |
|
Address2 |
Address.Address2 |
|
City |
Address.City |
|
State |
Address.State |
|
Zip |
Address.Zip |
|
Country |
Address.CountryName |
|
JobTitle |
Occupation |
|
Cell |
Mobile |
Fields Not Synced
The following Bullhorn CRM fields are not synced with Sugar Market:
- activePlacements
- branch
- candidateSource
- category
- certificationList
- clientCorporationBlackList
- clientCorporationWhiteList
- customObject1s
- educations
- FileAttachments
- interviews
- leads
- linkedPerson
- locations
- notes
- [owner]
- placements
- [references]
- referredByPerson
- secondaryOwners
- sendouts
- shifts
- submissions
- tasks
- tearsheets
- userType
- webResponses
- workHistories