Field Level Mapping of Siebel and Oracle Field Service Business Objects

Below are the field level mapping between Siebel and Oracle Field Service Business Objects.

Siebel CRM	OFS
Service Region	Resource (Type Bucket/Field resource)
Service Region Id	Resource Id
Name	Resource Name
Language Code	Language
Service Region Time Zone Name	Time zone (Look up in OIC)
Service Region ZIP Codes	WorkZone
Service Region Name	WorkZone Name
Service Region Name	WorkZone Label
ZIP Codes	Keys (array)
ZIP Codes	Shapes (array)
Service Region Id	Resource Id
Service Region Shifts	Work Schedule
Service Region Id	Resource Id
Shift Name	scheduleLabel
Service Region Exception Hours	Work Schedule
Service Region Id	Resource Id
Exception Hour Name	comments
Exception Hour Start Date	Start Date
Exception Hour End Date	End Date
Employee	Resource
Employee row Id	Resource Id
Party Name	Resource Name
Language Code	Language
Service Region Time Zone Name/Time Zone Name	Time zone (Look up in OIC)
Service Region Id	Parent Resource Id
Work Phone Number	phone
Employee Locations	Resource Locations
Employee row Id	Resource Id
Start Depot Address	address
Start Depot Country	Country
Start Depot City	City
Start Depot State	State
Start Depot ZIP Code	postalCode
Primary Start Home Address	address
Primary Start Home Country	Country
Primary Start Home City	City
Primary Start Home State	State
Primary Start Home ZIP Code	postalCode
End Depot Address	address
End Depot Country	Country
End Depot City	City
End Depot State	State
End Depot ZIP Code	postalCode
Primary End Home Address	address
Primary End Home Country	Country
Primary End Home City	City
Primary End Home State	State
Primary End Home ZIP Code	postalCode
Primary Start Home ZIP Code	postalCode
End Depot Address	address
End Depot Country	Country
End Depot City	City
End Depot State	State
End Depot ZIP Code	postalCode
Primary End Home Address	address
Primary End Home Country	Country
Primary End Home City	City
Primary End Home State	State
Primary End Home ZIP Code	postalCode
Employee Exception Hours (Continued)	Work Schedule (Continued)
Exception Hour End Date	End Date
Employee Skills	Work Skills
Employee row Id	Resource Id
Employee Skill Item	Work skill Name
Proficiency	Ratio
Employee Exception Hours (Continued)	Work Schedule (Continued)
Exception Hour End Date	End Date
Employee Skills	Work Skills
Employee row Id	Resource Id
Employee Skill Item	Work Skill Name
Proficiency	Ratio

Below are the field level mapping of Oracle Field Service entities and their corresponding default values.

OFS entity	Default values
Resource Type	BK or PR
Parent Resource Id	SUNRISE
Status	active
Travel Area	sunrise_enterprise
Start Date	current date
Is Working	true
nonWorkingReason	HOLIDAY
recurEvery	1
recurrenceType	daily
recordType	non-working
shiftType	regular
Address labels	Work Location or Home Address