AvailabilityPatterns
AvailabilityPatterns
Columns
| Name | Type | Description |
| AssignmentAvailabilityId [KEY] | Long | Unique identifier of the availability pattern. |
| AssignmentId | Long | Unique identifier of the assignment of an employee. |
| AnchorDate | Date | Any date belonging to a week which follows Week 1 of the multi-week cycle. |
| PersonId | Long | Unique identifier of the employee. |
| AvailabilityTypeId | Long | Unique identifier of the availability type. |
| DateFrom | Date | Date from which the availability pattern is valid. |
| DateTo | Date | Date to which the availability pattern is valid. |
| CreatedBy | String | CreatedBy of AvailabilityPatterns |
| CreationDate | Datetime | CreationDate of AvailabilityPatterns |
| LastUpdateDate | Datetime | LastUpdateDate of AvailabilityPatterns |
| LastUpdateLogin | String | LastUpdateLogin of AvailabilityPatterns |
| LastUpdatedBy | String | LastUpdatedBy of AvailabilityPatterns |
| ObjectVersionNumber | Int | ObjectVersionNumber of AvailabilityPatterns |
| AssignmentNumber | String | Assignment number of the employee. |
| AvailabilityType | String | Name of the availability type, such as CA-Nurse-Contracted or UK Retail Overtime. |
| ShiftCount | Int | Total count of the shifts in the pattern. |
| ScheduledDuration | String | Computed total scheduled duration of all shifts in the pattern, in hours, for example, 8.5. |
| PaidBreakDuration | String | Computed total paid break duration of all shifts in the pattern, in hours, for example, 0.5. |
| UnpaidBreakDuration | String | Computed total unpaid break duration of all shifts in the pattern, in hours, for example, 1.5. |
| PaidDuration | String | Computed total paid duration of all shifts in the pattern, in hours, for example, 8.5. |
| PersonNumber | String | Unique numeric identifier of the employee. |
| RepeatPeriod | String | Unit of measure for the repeating period length, for example ORA_HTS_WEEKS for Weeks. |
| RepeatNumber | Int | Length of the period for which the pattern is repeated, for example, 1 or 2. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| EffectiveDate | Date | EffectiveDate |
| Finder | String | finder |