ScheduleExceptions

Columns


Name	Type	Description
ExceptionId [KEY]	Long	ExceptionId of ScheduleExceptions
Name	String	The name of the schedule exception that you provide when creating an instance. This attribute is required.
Description	String	The description of the exception that you provide when creating an instance.
ShortCode	String	The abbreviation that identifies the exception that is displayed.
ExceptionStartDate	String	The date when the schedule starts to use the exception.
ExceptionEndDate	String	The date when the schedule no longer uses the exception.
PeriodTypeCode	String	The abbreviation that identifies the type of period, such as Off period and Work period.
CategoryCode	String	The abbreviation that identifies the category, such as Holiday and Training.
AllDayFlag	Bool	Contains one of the following values: true or false. If true, then the exception is for the entire day and the Exception Start and the Exception End values are dates. If false, then the exception is for a subset of hours within each day in the exception range and the Exception Start and the Exception End values include date and time values. The default value is false.
CreatedBy	String	CreatedBy of ScheduleExceptions
CreationDate	Datetime	CreationDate of ScheduleExceptions
LastUpdateDate	Datetime	LastUpdateDate of ScheduleExceptions
LastUpdatedBy	String	LastUpdatedBy of ScheduleExceptions

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