AvailabilityPatternsshifts
AvailabilityPatternsshifts
Columns
| Name | Type | Description |
| AvailabilityPatternsAssignmentAvailabilityId [KEY] | Long | AvailabilityPatternsAssignmentAvailabilityId of AvailabilityPatternsshifts |
| AvailabilityDetailId [KEY] | Long | Unique identifier of the shift in an availability pattern. |
| AssignmentAvailabilityId | Long | Unique identifier of the availability pattern. |
| ExceptionDate | Date | Date when an exception applies. |
| CreatedBy | String | CreatedBy of AvailabilityPatternsshifts |
| CreationDate | Datetime | CreationDate of AvailabilityPatternsshifts |
| LastUpdateDate | Datetime | LastUpdateDate of AvailabilityPatternsshifts |
| LastUpdateLogin | String | LastUpdateLogin of AvailabilityPatternsshifts |
| LastUpdatedBy | String | LastUpdatedBy of AvailabilityPatternsshifts |
| ObjectVersionNumber | Int | ObjectVersionNumber of AvailabilityPatternsshifts |
| PatternException | String | Type differentiating a pattern from an exception. Possible values are PATTERN and EXCEPTION. |
| StartTime | String | Time when a shift starts, entered in HH24:MI format. For example, 14:00. |
| EndTime | String | Time when a shift ends, entered in HH24:MI format. For example, 21:00. |
| Duration | String | Duration of the shift in hours. Value must be between 0 and 24. For example, 8. |
| DayOfWeek | String | Number specifying the day of the week, or day of the cycle for multi-week patterns. For example, 1 for Sunday, 2 for Monday, 8 for the Monday of the second week, 14 for the Saturday for the second week. |
| NonWorkExceptionFlag | Bool | Indicates weather the flag for the exception shift represents a nonworking day. Possible values are true and false. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| AssignmentId | Long | AssignmentId |
| AvailabilityTypeId | Long | AvailabilityTypeId |
| DateFrom | Date | DateFrom |
| DateTo | Date | DateTo |
| EffectiveDate | Date | EffectiveDate |
| PersonId | Long | PersonId |
| Finder | String | finder |