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

JDBC Driver for Oracle Fusion Cloud HCM

AvailabilityPatterns

Columns