WorkdayPatternsworkdayPatternShifts

Columns


Name	Type	Description
WorkdayPatternsPatternId [KEY]	Long	WorkdayPatternsPatternId of WorkdayPatternsworkdayPatternShifts
PatternDetailId [KEY]	Long	PatternDetailId of WorkdayPatternsworkdayPatternShifts
SequenceNumber	Long	The number that identifies the order of the assigned shift for the Duration pattern. This number is not currently used for Time or Elapsed patterns.
StartDay	Long	The day within the pattern when you begin using the shift.
EndDay	Long	The day within the pattern when you stop using the shift.
ShiftId	Long	The value that uniquely identifies the shift within the pattern. This attribute is required.
ShiftName	String	ShiftName of WorkdayPatternsworkdayPatternShifts
CreatedBy	String	CreatedBy of WorkdayPatternsworkdayPatternShifts
CreationDate	Datetime	CreationDate of WorkdayPatternsworkdayPatternShifts
LastUpdateDate	Datetime	LastUpdateDate of WorkdayPatternsworkdayPatternShifts
LastUpdatedBy	String	LastUpdatedBy of WorkdayPatternsworkdayPatternShifts

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