Power BI Connector for Oracle Fusion Cloud SCM

Build 23.0.8839

ShiftsshiftDetails

ShiftsshiftDetails

Columns

Name Type Description
ShiftsShiftId [KEY] Long ShiftsShiftId of ShiftsshiftDetails
ShiftDetailsId [KEY] Long ShiftDetailsId of ShiftsshiftDetails
Name String The name of the shift detail.
Day Long The day of the shift detail when shifts are longer than 24 hours in length.
StartTime String The time when the shift detail starts. The text is formatted as
Duration Double The value that identifies the duration of the shift detail.
DurationUnit String The unit of time to associate with the time-duration value.
MinimumBreakMinutes Long The minimum number of minutes that you may take as a break in the shift detail.
MaximumBreakMinutes Long The maximum number of minutes that you may take as a break in the shift detail.
CoreWorkFlag Bool Contains one of the following values: true or false. If true, then the shift detail is core working time. If false, then the shift detail is not core working time. The default value is false.
CreatedBy String CreatedBy of ShiftsshiftDetails
CreationDate Datetime CreationDate of ShiftsshiftDetails
LastUpdateDate Datetime LastUpdateDate of ShiftsshiftDetails
LastUpdatedBy String LastUpdatedBy of ShiftsshiftDetails

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
ShiftId Long ShiftId
Finder String finder

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