JDBC Driver for Oracle Fusion Cloud HCM

Build 26.0.9770

AttendanceViolations

Returns Attendance violations recorded for workers based on attendance rules, such as tardiness or early departures.

Columns

Name Type SupportedFinders Description
AttendanceViolationId [KEY] Long PrimaryKey Unique identifier for the attendance violation.
AttendanceViolationDate Date Date for the attendance violation.
Status String Status for the attendance violation, such as not reviewed or dismissed.
PersonId Long Unique identifier for the person associated with the attendance violation.
ExcusedBy Long Manager who dismissed the attendance violation.
ExcusedTime Datetime Date and time when the manager dismissed the attendance violation.
Comments String Comments associated with the acknowledgment or dismissal of the attendance violation.
Points Decimal Points related to the attendance violation.
ThresholdViolatedFlag Bool Indicates whether the violation exceeds the number of allowed occurrences. Valid values are True and False. The default value is False.
ThresholdPeriodStartDate Date Start date for the period when attendance violations are counted.
ThresholdPeriodStopDate Date End date for the period when attendance violations are counted.
TimeEntryId Long Unique identifier for the time entry.
TimeEntryVersion Int Version for the time entry.
EntryStartTime Datetime Start time for the reported time entry with an attendance violation.
EntryStopTime Datetime Stop time for the reported time entry with an attendance violation.
TimeEventId Long Unique identifier for the time event.
AbsenceId Long Unique identifier for the absence entry.
AbsenceReportingTime Datetime Date and time when the absence was reported.
ShiftId Long Unique identifier for the schedule shift.
ShiftStartTime Datetime Start time for the schedule shift.
ShiftStopTime Datetime Stop time for the schedule shift.
RuleSetId Long Unique identifier for the attendance rule set.
RuleId Long Unique identifier for the attendance rule.
RuleType String Rule associated with the attendance violation, such as Tardy or Leave early.
ObjectVersionNumber Int Version for the attendance violation.
CreatedBy String Violations generated by the attendance rules process.
CreationDate Datetime Date when the attendance violation was generated.
LastUpdatedBy String Most recent manager who updated the attendance violation.
LastUpdateDate Datetime Most recent date when the attendance violation was updated.
LastUpdateLogin String Most recent user who updated the attendance violation.
IdentificationKey Long Identification key used to get the approval task details for the attendance violation.
StatusMeaning String Status of the attendance violation, such as Acknowledged or Dismissed.
AcknowledgmentRequired String Indicates whether an acknowledgment of the attendance violation is required from the manager. Valid values are True and False. The default value is False.
TotalPoints Decimal Total number of points the worker is being granted as of the date of the attendance violation.
PersonName String Name of the person associated with the attendance violation.
PersonNumber String Number for the person associated with the attendance violation.
RuleTypeName String Name for the rule associated to the attendance violation, such as Tardy or Leave early.
JobId Long Identifier for the job used to filter attendance violations.
Job String Job criteria available to filter attendance violations.
DepartmentId Long Identifier for the department used to filter attendance violations.
Department String Department criteria available to filter attendance violations.
LocationId Long Identifier for the location used to filter attendance violations.
Location String Location criteria available to filter attendance violations.
LoggedInUserId Long Identifier for the user who is logged in.
StatusCode String Code for the status of the attendance violation, such as ACKNOWLEDGED or DISMISSED.
Finder String The named finder used to filter the records returned for this resource.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9770