Supported Data Elements

Organization

Organization Mapping
Taleo Field	Fusion Field
Record Identifier	Business Unit Internal ID
Organization Customer ID	Business Unit Internal ID
Organization Code	“BUCOD” + Internal ID with first three numbers stripped
Parent Organization Code	-1 (hardcoded)
Description (multilingual)	Business Unit Name
Industry	(left blank)
Status	Business Unit Status
Sequence Number	0 (hardcoded)

Location

Location Mapping
Taleo Field	Fusion Field
Record Identifier	Location Internal ID
Location Customer ID	Location Internal ID
Location Code	Location Code The location code must be unique. If the Fusion location code is used in multiple sets, the integration will fail.
Location Name	Location Name
Location Zip/Postal Code	Location Postal Code
Location Work Location Address 1	Location Address Line 1
Location Work Location Address 2	Location Address Line 2 and Line 3
Location Status	Location Status
Country Code	Location Country
Country Name	Location Country Name
State Code	Location State Internal ID
State Name	Location State
City Name	Location City Name
Locale	en (hardcoded)

Job Field

Job Field Mapping
Taleo Field	Fusion Field
Record Identifier	Job Family Internal ID
Job Field Customer ID	Job Family Internal ID
Job Field Code	“COD-“+JobFamilyId (starting from 4th char) (Derived) The code must be unique. If the code is used in multiple sets, the integration will fail.
Job Field Name	Job Family Name
Job Field Status	Job Family Status
Job Field Parent	Hard coded to root (flat structure)

Position

Position Mapping
Taleo Field	Fusion Field
Record Identifier	Position Internal ID
Position Element Customer ID	Position Internal ID
Position Code	Position Code For Taleo to uniquely identify Position Code, customers must first verify that Position Code is uniquely defined across business units in Fusion.
Description (multilingual)	Position Name
Status	Position Status
Effective From	(left blank)
Effective To	(left blank)
Complete	TRUE (hardcoded)
Sequence	0 (hardcoded)
LUDS Type	Fusion_Positions (hardcoded)

Grade

Grade Mapping
Taleo Field	Fusion Field
Record Identifier	Grade Internal ID
Grade Element Customer ID	Grade Internal ID
Grade Element Code	Grade Code
Description (multilingual)	Grade Name
Status	Grade Status
Effective From	(left blank)
Effective To	(left blank)
Complete	TRUE (hardcoded)
Sequence	0 (hardcoded)
LUDS Type	Fusion Grades (hardcoded)

Legal Employer

Legal Employer Mapping
Taleo Field	Fusion Field
Record Identifier	Legal Employer (Legal Entity) Internal ID
Legal Element Customer ID	Legal Employer Internal ID
Legal Element Code	LECOD-LegislationCode (from 3rd Char) (Derived)
Description (multilingual)	LECOD-LegislationCode (from 3rd Char) (Derived)
Status	Legal Employer Status
Effective From	(left blank)
Effective To	(left blank)
Complete	TRUE (hardcoded)
Sequence	0 (hardcoded)
LUDS Type	Fusion_LegalEmployers (hardcoded)

Department

Department Mapping
Taleo Field	Fusion Field
Record Identifier	Department Internal ID
Department Customer ID	Department Internal ID
Department Code	Department Code + Internal ID with first three numbers stripped
Department Name	Department Name
Department Location	Department Location
Status	Department Status

Requisition Template

Requisition Template Mapping
Taleo Field	Fusion Field
Record Identifier	Job Code
Job Code	Job Code
Title	Job Name
Job Field	Job Family
Organization	Hard coded to root
Requisition Type	Hard coded to 6 – Universal
Status	Hard coded to 1- Active
Fusion Job ID	Job ID
Base Language – en	Default is English
Active Language – en	All languages are sent

New Hire Mapping

New Hire Mapping
Taleo Field	Fusion Field
Requisition Contest Number
Candidate Number
Candidate Employee Number Employee/User Employee ID	Person Number
Candidate First Name	Person First Name
Candidate Middle Name	Person Middle Name
Candidate Last Name	Person Last Name
Candidate Email Address	Person Personal E-Mail
Candidate Address Line 1	Person Home Address Line 1
Candidate Address Line 2	Person Home Address Line 2
Candidate Residence Location Country	Person Home Address Country
Candidate Residence Location State	Home Address State
Candidate Residence Location Region Name	Home Address County
Candidate City	Person Home Address City
Candidate Zip Code	Person Home Address Postal Code
Candidate Home Phone	Person Home Phone
Candidate Work phone	Person Work Phone
Candidate Pager Phone	Person Pager Number
Candidate Social Security Number	Person National ID
Candidate Birthday	Person Date of Birth
Requisition Department	Work Assignment Department
Requisition Hiring Manager	Work Assignment Manager
Requisition Organization	Work Assignment Business Unit
Requisition Primary Location	Work Assignment Location
Requisition Legal Employer	Work Assignment Legal Employer
Requisition Grade	Work Assignment Grade
Requisition Job Template	Work Assignment Job
Offer Actual Start Date	Work Relationship Start Date and Compensation Start Date
Offer Relocation Amount	Other Compensation Relocation Amount
Offer Relocation Type Description	Other Compensation Relocation Package
Offer Sign on Bonus	Other Compensation Sign on Bonus
Offer Salary (Annualized Salary)	There is no direct mapping for this field. Pending Worker is assigned with one of existing annual salary basis; the value of Taleo Offer Salary will be assigned to annual amount.
Offer Annual Bonus	Other Compensation Annual Bonus Amount
Offer Car Allowance	Other Compensation Car Allowance
Offer Commission Amount	Other Compensation Commission Amount
Offer Commission Type Description	Other Compensation Commission Package
Offer Expense Account	Other Compensation Expense Account
Offer Stock Option	Other Compensation Options
Offer Stock Option Type Description	Other Compensation Option Package
Offer Fusion Position	Work Assignment Position
Candidate Profile Studies – Institution Description and Other Institution Name	Profile Education Entry - School or Profile Education Entry – School Name
Candidate Profile Studies – Program Description and Other Course Title	Profile Education Entry - Major
Candidate Profile Studies – Location Country Code	Profile Education Entry – Country
Candidate Profile Studies – Location State Code	Profile Education Entry – State
Candidate Profile Studies – Study Level	Profile Education Entry – Degree
Candidate Profile Studies – GPA	Profile Education Entry – GPA
Candidate Profile Studies – Start Date	Profile Education Entry – From Date
Candidate Profile Studies – Graduation Date	Profile Education Entry – Date Acquired
Candidate Profile Experiences - Employer Description and Other Employer Name	Profile Work Experience Entry – Employer Name
Candidate Profile Experiences - Job Function Name	Profile Work Experience Entry - Job Family
Candidate Profile Experiences - Other Job Title	Profile Work Experience Entry – Other Job Function
Candidate Profile Experiences - Begin Date	Profile Work Experience Entry - Start Date
Candidate Profile Experiences - End Date	Profile Work Experience Entry - End Date
Candidate Profile Experiences - Responsibility	Profile Work Experience Entry - Achievements
Candidate Profile Experiences - Current Employer checkbox	Profile Work Experience Entry – Current Job
Candidate Profile Certifications - Description	Profile Certification Entry - License Name
Candidate Profile Certifications - Other Certification Name	Profile Certification Entry – Item_Text2000_1
Candidate Profile Certifications - NumberID	Profile Certification Entry - Number
Candidate Profile Certifications - Location Country	Profile Certification Entry - Country
Candidate Profile Certifications - Location State	Profile Certification Entry - State
Candidate Profile Certifications - Issuing Organization	Profile Certification Entry – Issued By
Candidate Profile Certifications - Date Received	Profile Certification Entry - Issue Date
Candidate Profile Certifications Expiration Date	Profile Certification Entry - Expiration Date

Candidate

Candidate Mapping
Taleo Field	Fusion Field
Key Record Identifier	User Name
Candidate Username	User Name
Candidate SSOID	User Name
First Name	Worker First Name
Middle Name	Worker Middle Name
Last Name	Worker Last Name
Home Address	Home Address Line 1, Home Address Line 2
Home Address 2	Home Address Line 3, Home Address Line 4
Home City	Home Address Line City
Zip/Postal Code	Postal Code
Birthday	Worker Date of Birth
Email	Worker Primary Email Address
Home Phone	Worker Home Phone
Work Phone	Worker Work Phone
Fax Phone	Worker Fax
Mobile Phone	Worker Home Mobile Phone, (Or if this is not defined then Worker Work Mobile)
Pager Phone	Worker Pager
Internal Candidate	TRUE/FALSE (hardcoded)
National ID	Worker National Identification Number

Employee

Employee Mapping
Taleo Field	Fusion Field
Record Identifier	User Name
User Login Name	User Name
First Name	Worker First Name
Middle Initial	Worker Middle Name
Last Name	Worker First Name
Employee Number/ID	Person Number
Work Phone	Worker Work Phone
Extension	Worker Work Phone Extension
Email	Worker Primary Email Address
Correspondence Language	Correspondence Language
Title (multilingual)	Worker Primary Assignment Job Name
Address 1	Work Location Address Line 1
Address 2	Work Location Address Line 2
Address 3	Work Location Address Line 3 + Work Address Line 4
City	Work Location Address City
State	Work Location Address State
Country	Work Location Address Country
Zip/Postal Code	Work Location Address Postal Code
Organization	Business Unit
Location	Work Location
Department	Department
Job Role Code	EMPLOYEE (hardcoded)
Employee Status	CURRENT / TERMINATED (According to employee status in Fusion)
User Account Status	User Account Status
Manager	Worker’s Manager’s User Name in the superior position
Configuration Profile	Hiring Manager / Recruiter (hardcoded) Any user being a supervisor (someone who has direct reports) will be assigned the Hiring Manager configuration profile. Otherwise, the Recruiting configuration profile is assigned to the user. If the user configuration profile is changed manually in Taleo, there are good chances that Fusion will overwrite it on next user update.
Confirm Profile	False (hardcoded)
User Types	User Roles

Requisition

As part of the Fusion HCM - Taleo Recruiting Integration solution , a synchronization of requisitions is performed. Requisitions created in Taleo Recruiting are exported from Taleo and imported into Fusion HCM.

Requisition Mapping
Taleo Field	Fusion Field
Requisition Number	REQUISITION_NUMBER
Requisition Title	REQUISITION_TITLE
Requisition Status	REQUISITION_STATUS
Hiring Manager	MANAGER_USER_NAME
Target Start Date	TARGET_START_DATE
Employee Status	EMPLOYEE_STATUS
Job Schedule	JOB_SCHEDULE
Justification	REQUISITION_JUSTIFICATION
Number Of Openings	TOTAL_OPEN_HEADCOUNT
Fusion Job ID	JOB_ID
Organization Code	ORGANIZATION_ID
Primary Location Code/Id	PRIMARY_LOCATION_ID
Number Of Hired	TOTAL_HIRED_HEADCOUNT
Number Of Available Openings This is not an actual field in Taleo. It is a calculation of the number of openings and the number of hired candidates.	TOTAL_AVAILABLE_HEADCOUNT