Mapping Definitions That Update Schedule Data in Real Time

The following table describes mapping definitions that update schedule data in real time. Except where noted in the table, the Siebel CRM fields in the table reside in the Shift business component.

Siebel CRM		Oracle Real-Time Scheduler		Description
Integration Component	Field Name	Parent Element	Field Name
Shift	Id	Shift Weekly Template	externalId
	ExceptionId		externalExceptionId
	Description		description
	SyncSuccessFlag			Value is set as Y or N.
	languageCode			Value is set in FMW after looking up in the DVM.
			bo	Value is hardcoded as M1-CrewShiftTemplate in FMW.
			crewShiftType	Value is hardcoded as SIEBEL_GENERIC_SHIFT_TYPE in FMW.
			shiftCostProfile	Value is hardcoded as SIEBEL_STD_PROFILE in FMW.
			dripMode	Value is hardcoded as M1AL in FMW.
			shiftWeeklyTemplateId	Value is hardcoded as SIEBEL_GENERIC in FMW.
			standbyShift	Value is hardcoded as M1NO in FMW.

This integration maps Shift Hours from Oracle’s Siebel CRM to the Shift Weekly Template in Oracle Real-Time Scheduler by applying following logic:

For all the Shift Hours with same Start Day:

• The Start Time of the record with the Shift Start flag set to Y is mapped to Start Time for the Shift in Oracle Real-Time Scheduler.

• The End Time of the last record is mapped to the End Time for Shift in Oracle Real-Time Scheduler.

• The Gaps between these records are being mapped to Breaks in Oracle Real-Time Scheduler.