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

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。