Shifts

Columns


Name	Type	Description
ShiftId [KEY]	Long	ShiftId of Shifts
Name	String	The name of the shift that you provide when creating an instance. This attribute is required.
Description	String	The description of the shift that you provide when creating an instance.
Code	String	The abbreviation that identifies the shift.
StartTime	String	The time when the shift starts. The text is formatted as
EndTime	String	EndTime of Shifts
Duration	Double	The value that identifies the duration of the shift.
DurationUnit	String	The unit of time to associate with the time-duration value.
CategoryCode	String	The abbreviation that identifies the shift categories, such as working from home or office.
PeriodTypeCode	String	The abbreviation that identifies the shift duration, such as work period or off period.
ShiftTypeCode	String	The abbreviation that identifies the type of shift being created. Valid values are Time, Duration, and Elapsed. This attribute is required.
ShiftDetailTypeCode	String	The abbreviation that identifies the type of Time shift being created. Valid values are Flexible, Punch, and None. This attribute is required for Time shifts.
CreatedBy	String	CreatedBy of Shifts
CreationDate	Datetime	CreationDate of Shifts
LastUpdateDate	Datetime	LastUpdateDate of Shifts
LastUpdatedBy	String	LastUpdatedBy of Shifts

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