Search Results per_absence_attendances

Overview

The PER_ABSENCE_ATTENDANCES table is a core transactional data store within the Oracle E-Business Suite Human Resources (HR) module. It serves as the primary repository for recording instances of employee absence and attendance. This table is fundamental to managing workforce availability, tracking leave, and supporting related payroll and compliance processes. Its data is central to generating absence-related reports, calculating entitlements, and integrating with other HR functionalities. The table's design accommodates complex scenarios, such as linking related absence records, which is essential for managing extended or recurring leave events.

Key Information Stored

The table stores comprehensive details for each absence or attendance event. The primary identifier is the ABSENCE_ATTENDANCE_ID. Key relational columns include BUSINESS_GROUP_ID, which links to the HR_ALL_ORGANIZATION_UNITS table to define the organizational context. The ABSENCE_ATTENDANCE_TYPE_ID foreign key references PER_ABSENCE_ATTENDANCE_TYPES, classifying the nature of the absence (e.g., sick leave, vacation). The ABS_ATTENDANCE_REASON_ID links to PER_ABS_ATTENDANCE_REASONS, providing further granularity. A critical self-referencing column is LINKED_ABSENCE_ID, which points to another record in the same table, enabling the connection of split or continuous absences. Other typical columns would include PERSON_ID (employee), DATE_START, DATE_END, and AUTHORIZED_STATUS.

Common Use Cases and Queries

This table is primarily queried for employee leave history, absence trend analysis, and payroll input validation. Common reporting scenarios include calculating total sick days taken in a quarter, identifying employees on leave on a specific date, or auditing unauthorized absences. A typical query to retrieve an employee's absences within a date range would be:

• SELECT paa.absence_attendance_id, paa.date_start, paa.date_end, paat.name type_name FROM hr.per_absence_attendances paa, hr.per_absence_attendance_types paat WHERE paa.person_id = :p_employee_id AND paa.absence_attendance_type_id = paat.absence_attendance_type_id AND paa.date_start BETWEEN :p_start_date AND :p_end_date ORDER BY paa.date_start;

Another common pattern involves using the LINKED_ABSENCE_ID to consolidate related records for a single absence event, which is crucial for accurate duration calculations.

Related Objects

PER_ABSENCE_ATTENDANCES has integral relationships with several key HR tables, as indicated by its foreign keys. The primary dependencies include:

• PER_ABSENCE_ATTENDANCE_TYPES: Provides the classification (type) for each absence record.
• PER_ABS_ATTENDANCE_REASONS: Supplies the detailed reason associated with an absence type.
• HR_ALL_ORGANIZATION_UNITS: Defines the business group for security and organizational hierarchy.
• Self-Reference (PER_ABSENCE_ATTENDANCES): The LINKED_ABSENCE_ID column creates a recursive relationship within the same table to manage complex absence chains.

Data from this table is often surfaced through HRMS forms, standard reports, and is critical for the Absence Management functionality.