Excel Add-In for Oracle Fusion Cloud HCM

Build 24.0.9062

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 multiweek 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.
EffectiveDate Date EffectiveDate of AvailabilityPatterns
Finder String Finder of AvailabilityPatterns

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062