SSIS Components for Oracle Fusion Cloud HCM

Build 24.0.9060

ScheduleRequestsscheduleEventsscheduleShiftEvents

ScheduleRequestsscheduleEventsscheduleShiftEvents

Columns

Name Type Description
ScheduleRequestsschedRequestId [KEY] Long ScheduleRequestsschedRequestId of ScheduleRequestsscheduleEventsscheduleShiftEvents
ScheduleeventsschedEventId [KEY] Long ScheduleeventsschedEventId of ScheduleRequestsscheduleEventsscheduleShiftEvents
ShiftDuration Long Duration of the shift in minutes. If the shift type is Elapsed, this attribute is mandatory. For other shift types, you need to provide the start and end times.
ShiftNumber String Unique identifier of the shift in the source system. It's mandatory only when you update or delete shifts.
ShiftAction String Actions to do on the shift, such as CREATE and DELETE. When the import mode is FULL, only the CREATE action is accepted. Valid values are defined in the LOV_shiftAction lookup type.
ReferenceDay Date Date used to group shifts that span multiple work days into a single work day for processing. The import process checks that shifts marked with the DELETE action are on the reference day before deleting.
ShiftStartTime String Start time of the Time-type shifts, entered with the time zone offset, for example, 2015-08-02T08:00:00+01:00.
ShiftEndTime String End time of shifts of the type Time, entered with the time zone offset, for example, 2015-08-02T08:00:00+01:00.
ShiftTimeNotWorked Long Time not worked, and thus unpaid, during the shift in minutes. The shift value in the library provides the default value, which you can override.
ShiftCategory String Category of the shift, such as WORK. Valid values are defined in the LOV_shiftCategory lookup type.
ShiftCode String Unique identifier for a shift in the library. The shift code is language-independent and required only when you create or update shifts.
ShiftType String Types of shift, such as ELAPSED or TIME. Valid values are defined in the LOV_shiftType lookup type.
SchedShiftEventId [KEY] Long Surrogate ID for the schedule shift event, available only to reference existing records.
SchedEventId Long Unique identifier to reference the schedule event containing the shift.
AllowEdits String Indicates whether the scheduler can edit the imported shift using the Planned Schedule task. Valid values are Y or N and defined in the HcmLookupYesNo lookup type. If the value is Y or Null, shift editing is allowed when the value of the worker time entry profile Allow Edits option is Y and the schedule event isn't N.
Finder String Finder of ScheduleRequestsscheduleEventsscheduleShiftEvents
SchedRequestId Long SchedRequestId of ScheduleRequestsscheduleEventsscheduleShiftEvents

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060