Bookshelf Home | Contents | Index | PDF     

Siebel Field Service Integration to Oracle Real-Time Scheduler Implementation Guide > Mapping Definitions > Mapping Definitions That Update Data in Real Time >

Mapping Definitions That Update Schedule Data in Real Time

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

Table 90. Mapping Definitions That Update Employee Data in Real Time
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.
      
Siebel Field Service Integration to Oracle Real-Time Scheduler Implementation Guide Copyright © 2018, Oracle and/or its affiliates. All rights reserved. Legal Notices.